Versions Compared

Key

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

The

Specref
RefTypefile
tRelationship file
holds one
Gloss
SpacePreSpacetruefalse
trelationship
per row. Each
Gloss
SpacePreSpacetruefalse
trelationship
is of a particular type, and has a source
Gloss
SpacePreSpacetruefalse
tconcept
and a destination
Gloss
SpacePreSpacetruefalse
tconcept.
An example of a
Gloss
SpacePreSpacetruefalse
trelationship
is given below:
Concept
t371883000|Outpatient procedure|
ShowFormatinline
Concept
t116680003|Is a|
ShowFormatinline
Concept
t71388002|Procedure|
ShowFormatinline
where:

  • Concept
    t371883000|Outpatient procedure|
    ShowFormatinline
    is the source
    Gloss
    PreSpacefalse
    tconcept;

  • Concept
    t116680003|Is a|
    ShowFormatinline
    is the
    Gloss
    SpacePreSpacetruefalse
    trelationship type
     
    Gloss
    SpacePreSpacetruefalse
    tconcept
      and;

  • Concept
    t71388002|Procedure|
    ShowFormatinline
    is the destination
    Gloss
    tconcept.

...

Field

...

Data type

...

Immutable

...

Purpose

...

id

...

SCTID

...

Y

...

Uniquely identifies the

Gloss
trelationship.

...

effectiveTime

...

Time

...

N

...

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

...

YES (Full)

Optional (Snapshot) 

...

active

...

Boolean

...

N

...

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 effectiveTime field.

...

moduleId

...

SCTID

...

N

...

Identifies the

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

...

sourceId

...

SCTID

...

Y

...

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.

...

destinationId

...

SCTID

...

Y

...

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 typeId 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.

...

relationshipGroup

...

Integer

...

N

...

Groups together

Gloss
Spacetrue
trelationship
versions that are part of a logically associated relationshipGroup. All
Gloss
Spacetrue
tactive
Gloss
Spacetrue
tRelationship
records with the same relationshipGroup number and sourceId are grouped in this way.

...

typeId

...

SCTID

...

Y

...

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 typeId 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.

...

characteristicTypeId

...

SCTID

...

N

...

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
.

...

modifierId

...

SCTID

...

N

...

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.

...

NO

 

  • PreSpacefalse
    tconcept.


Bookmarked content insert
Startfilespec
PageREUSE:Relationship File

Only one

Gloss
PreSpacefalse
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.

If the

Gloss
SpacePreSpacetruefalse
tactive
field of this record is false ('0'), then the
Gloss
SpacePreSpacetruefalse
trelationship
is
Gloss
SpacePreSpacetruefalse
tinactive
at that point in time. If the
Gloss
SpacePreSpacetruefalse
tactive
field is true ('1'), then there is a
Gloss
SpacePreSpacetruefalse
trelationship
between the
Gloss
SpacePreSpacetruefalse
tSNOMED CT concepts
identified by
Specref
RefTypefield
tsourceId
and
Specref
RefTypefield
tdestinationId
.

The

Specref
RefTypefield
tsourceId
,
Specref
RefTypefield
tdestinationId
,
Specref
RefTypefield
trelationshipGroup
,
Specref
RefTypefield
ttypeId
, characteristicTypeIdand
Specref
RefTypefield
tmodifierId
will not change between two rows with the same id, in other words they are immutable. Where a change is required to one of these fields, then the current row will be de-activated (by appending a row with the same id and the
Gloss
SpacePreSpacetruefalse
tactive
field set to false) and a new row with a new id will be appended.

The

Specref
RefTypefield
trelationshipGroup
field is used to group
Gloss
SpacePreSpacetruefalse
trelationships
with the same
Specref
RefTypefield
tsourceId
field into one or more logical sets. A
Gloss
SpacePreSpacetruefalse
trelationship
with a
Specref
RefTypefield
trelationshipGroup
field value of '0' is considered not to be grouped. All
Gloss
SpacePreSpacetruefalse
trelationships
with the same
Specref
RefTypefield
tsourceId
and non-zero
Specref
RefTypefield
trelationshipGroup
are considered to be logically grouped.

The

Specref
RefTypefield
trelationshipGroup
field will be an unsigned
Specref
RefTypedata type
tInteger
, and will not be limited to a single digit value. There is no guarantee that they will be assigned sequentially, and the values will not be unique across
Gloss
PreSpacefalse
tconcepts.

Related Links

...

Scroll Pagebreak