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

...

id

...

Specref
RefTypedata type
tSCTID

...

Uniquely identifies the

Gloss
trelationship.

...

NO

...

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

...

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

...

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

...

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

...

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

...

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|

...

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

...

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

Bookmarked content insert
Startfilespec
PageREUSE:Relationship File

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.

...

Scroll Pagebreak