Search

 This Document

 All Library Documents



 Other Documents

Versions Compared

Key

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

...

Caption table
Relationship file - Detailed specification

Bookmarker
Typestart
Namefilespec


Field

Data type

Purpose

Gloss
tMutable
LinkTypesubtle

Part of Primary Key

id

Specref
RefTypedata type
tSCTID

Uniquely identifies the

Gloss
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
Spacetrue
trelationship
was
Gloss
Spacetrue
tactive
or
Gloss
Spacetrue
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
Spacetrue
trelationship
version's module. Set to a
Gloss
Spacetrue
tchild
of
Concept
t900000000000443000|Module|
ShowFormatinline
within the metadata
Gloss
thierarchy.

YES

NO

Specref
RefTypefield
tsourceId

Specref
RefTypedata type
tSCTID

Identifies the source

Gloss
Spacetrue
tconcept
of the
Gloss
Spacetrue
trelationship
version. That is the
Gloss
Spacetrue
tconcept
defined by this
Gloss
Spacetrue
trelationship.
Set to the
Gloss
Spacetrue
tidentifier
of a
Gloss
Spacetrue
tconcept.
in the Concept File.

NO

NO

Specref
RefTypefield
tdestinationId

Specref
RefTypedata type
tSCTID

Identifies the

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

That is the

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

Set to the

Gloss
Spacetrue
tidentifier
of a
Gloss
Spacetrue
tconcept.
in the Concept File.

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
Spacetrue
trelationship
versions that are part of a logically associated
Specref
RefTypefield
trelationshipGroup
. All
Gloss
Spacetrue
tactive
Gloss
Spacetrue
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
Spacetrue
tconcept
that represent the defining attribute (or relationship type) represented by this
Gloss
Spacetrue
trelationship
version.

That is the

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

Set to the

Gloss
Spacetrue
tidentifier
of a
Gloss
Spacetrue
tconcept
in the Concept File. 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
Spacetrue
tconcept
enumeration value that identifies the characteristic type of the
Gloss
Spacetrue
trelationship
version (i.e. whether the
Gloss
Spacetrue
trelationship
version is defining, qualifying, etc.) This field is set to a
Gloss
Spacetrue
tdescendant
of
Concept
t900000000000449001|Characteristic type|
ShowFormatinline
in the metadata
Gloss
thierarchy
.

YES

NO

Specref
RefTypefield
tmodifierId

Specref
RefTypedata type
tSCTID

A

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

Note

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

Only one

Gloss
Spacetrue
trelationship
record with the same id field will be current at any point in time. The current record will be the one with the most recent effectiveTime before or equal to the point in time under consideration.

...