Search



Versions Compared

Key

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

The

Specref
RefTypefile
tRelationship file
holds one
Gloss
PreSpacefalse
trelationship
per row. Each
Gloss
PreSpacefalse
trelationship
is of a particular type, and has a source
Gloss
PreSpacefalse
tconcept
and a destination
Gloss
PreSpacefalse
tconcept.
An example of a
Gloss
PreSpacefalse
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
    PreSpacefalse
    trelationship type
    Gloss
    PreSpacefalse
    tconcept
    and;

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

Caption label
CapIdrelationship-file-detailed-specification
CapTypeTable
Relationship file - Detailed specification

Bookmarked content insert
Startfilespec
PageREUSE:Relationship File

Only one

Gloss
PreSpacefalse
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
PreSpacefalse
tactive
field of this record is false ('0'), then the
Gloss
PreSpacefalse
trelationship
is
Gloss
PreSpacefalse
tinactive
at that point in time. If the
Gloss
PreSpacefalse
tactive
field is true ('1'), then there is a
Gloss
PreSpacefalse
trelationship
between the
Gloss
PreSpacefalse
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
PreSpacefalse
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
PreSpacefalse
trelationships
with the same
Specref
RefTypefield
tsourceId
field into one or more logical sets. A
Gloss
PreSpacefalse
trelationship
with a
Specref
RefTypefield
trelationshipGroup
field value of '0' is considered not to be grouped. All
Gloss
PreSpacefalse
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