Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table width manager
Col225px,85px,1*,83px,104px
Sizefs8


Field

Data type

Purpose

Gloss
PreSpacefalse
tMutable
LinkTypesubtle

Part of Primary Key

id

Specref
RefTypedata type
tSCTID

Uniquely identifies the

Gloss
PreSpacefalse
trelationship
.

NO

YES (Full/ Snapshot) 

Specref
RefTypefield
teffectiveTime

Specref
RefTypedata type
tTime

Specifies the inclusive date at which the component version's state became the then current valid state of the component.

YES

YES (Full)

Optional (Snapshot) 

Specref
RefTypefield
tactive

Specref
RefTypedata type
tBoolean

Specifies whether the state of the

Gloss
SpacePreSpacetruefalse
trelationship
was
Gloss
SpacePreSpacetruefalse
tactive
or
Gloss
SpacePreSpacetruefalse
tinactive
from the nominal release date specified by the
Specref
RefTypefield
teffectiveTime
field.

YES

NO

Specref
RefTypefield
tmoduleId

Specref
RefTypedata type
tSCTID

Identifies the

Gloss
SpacePreSpacetruefalse
trelationship
version's module. Set to a
Gloss
SpacePreSpacetruefalse
tchild
of
Concept
t900000000000443000|Module|
ShowFormatinline
within the metadata
Gloss
PreSpacefalse
thierarchy
.

YES

NO

Specref
RefTypefield
tsourceId

Specref
RefTypedata type
tSCTID

Identifies the source

Gloss
SpacePreSpacetruefalse
tconcept
of the
Gloss
SpacePreSpacetruefalse
trelationship
version. That is the
Gloss
SpacePreSpacetruefalse
tconcept
defined by this
Gloss
SpacePreSpacetruefalse
trelationship.
Set to the
Gloss
SpacePreSpacetruefalse
tidentifier
of a
Gloss
PreSpacefalse
tconcept
.

NO

NO

Specref
RefTypefield
tdestinationId

Specref
RefTypedata type
tSCTID

Identifies the

Gloss
SpacePreSpacetruefalse
tconcept
that is the destination of the
Gloss
SpacePreSpacetruefalse
trelationship
version.

That is the

Gloss
SpacePreSpacetruefalse
tconcept
representing the value of the attribute represented by the
Specref
RefTypefield
ttypeId
column.

Set to the

Gloss
SpacePreSpacetruefalse
tidentifier
of a
Gloss
PreSpacefalse
tconcept
.

Note that the values that can be applied to particular attributes are formally defined by the   SNOMED CT Machine Readable Concept Model.

NO

NO

Specref
RefTypefield
trelationshipGroup

Integer

Groups together

Gloss
SpacePreSpacetruefalse
trelationship
versions that are part of a logically associated
Specref
RefTypefield
trelationshipGroup
. All
Gloss
SpacePreSpacetruefalse
tactive
Gloss
SpacePreSpacetruefalse
tRelationship
records with the same
Specref
RefTypefield
trelationshipGroup
number and
Specref
RefTypefield
tsourceId
are grouped in this way.

YES

NO

Specref
RefTypefield
ttypeId

Specref
RefTypedata type
tSCTID

Identifies the

Gloss
SpacePreSpacetruefalse
tconcept
that represent the defining attribute (or relationship type) represented by this
Gloss
SpacePreSpacetruefalse
trelationship
version.

That is the

Gloss
SpacePreSpacetruefalse
tconcept
representing the value of the attribute represented by the
Specref
RefTypefield
ttypeId
column.

Set to the

Gloss
SpacePreSpacetruefalse
tidentifier
of a
Gloss
SpacePreSpacetruefalse
tconcept
. The concept identified must be either
Concept
t116680003|Is a|
ShowFormatinline
or a subtype of
Concept
t410662002|Concept model attribute|
. The concepts that can be used as in the typeId column are formally defined as follows:

Scg expression
Borderridge
ShowFormatblock
116680003|is a| OR <410662002|concept model attribute|
Note that the attributes that can be applied to particular concepts are formally defined by the SNOMED CT Machine Readable Concept Model.

NO

NO

Specref
RefTypefield
tcharacteristicTypeId

Specref
RefTypedata type
tSCTID

A

Gloss
SpacePreSpacetruefalse
tconcept
enumeration value that identifies the characteristic type of the
Gloss
SpacePreSpacetruefalse
trelationship
version (i.e. whether the
Gloss
SpacePreSpacetruefalse
trelationship
version is defining, qualifying, etc.) This field is set to a
Gloss
SpacePreSpacetruefalse
tdescendant
of
Concept
t900000000000449001|Characteristic type|
ShowFormatinline
in the metadata
Gloss
PreSpacefalse
thierarchy
.

YES

NO

Specref
RefTypefield
tmodifierId

Specref
RefTypedata type
tSCTID

A

Gloss
SpacePreSpacetruefalse
tconcept
enumeration value that identifies the type of
Gloss
PreSpacefalse
tDescription Logic
(DL) restriction (some, all, etc.). Set to a
Gloss
SpacePreSpacetruefalse
tchild
of
Concept
t900000000000450001|Modifier|
ShowFormatinline
in the metadata
Gloss
PreSpacefalse
thierarchy
.

Note
iconfalse

Currently the only value used in this column is

Concept
t900000000000451002|Some|
ShowFormatinline
and thus in practical terms this column can be ignored. For further clarification please see Notes on modifierId.


YES

NO

 



Bookmarker
Typeend
Namefilespec