Search



Versions Compared

Key

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

...

SNOMED International provides an example of a  Transitive Closure Perl script file that can be used to generating a snapshot view of the transitive closure from the snapshot release of the 

Specref
RefTypefile
tRelationship
. The output of this script conforms to the following following file structure. Note that the primary key for this table consists of both columns.


Field

Data type

Purpose

Part of Primary Key

subtypeId

Specref
RefType(data type)
tSCTID

Id of the

Gloss
Spacetrue
tconcept
playing the
Gloss
Spacetrue
tsubtype
role. Set to an
Gloss
Spacetrue
tIdentifier
of a
Gloss
tconcept
.

YES

supertypeId

Specref
RefType(data type)
tSCTID

Id of the

Gloss
Spacetrue
tconcept
playing the supertype role. Set to an
Gloss
Spacetrue
tIdentifier
of a
Gloss
tconcept
.

YES

...

A versioned view of the

Gloss
Spacetrue
tTransitive Closure
can also be generated by combining the snapshot views for different effective times and removing redundant rows (e.g. where the transitive closure has not changed between release versions). The generated file could then be represented using the example specification below. Note that the unique key for this file would consist of the subtypeId, supertypeId and effectiveTime.


Field

Data type

Purpose

Part of Primary Key

subtypeId

Specref
RefType(data type)
tSCTID

Id of the

Gloss
Spacetrue
tconcept
playing the
Gloss
Spacetrue
tsubtype
role. Set to an
Gloss
Spacetrue
tIdentifier
of a
Gloss
tconcept
.

YES

supertypeId

Specref
RefType(data type)
tSCTID

Id of the

Gloss
Spacetrue
tconcept
playing the supertype role. Set to an
Gloss
Spacetrue
tIdentifier
of a
Gloss
tconcept
.

YES

Specref
RefType(field)
teffectiveTime

Specref
RefType(data type)
tTime

Specifies the inclusive date at which the

Gloss
Spacetrue
ttransitive closure
record was added or changed its active state.

YES

Specref
RefType(field)
tactive

Specref
RefType(data type)
tBoolean

Specifies whether at the

Gloss
Spacetrue
ttransitive closure
represented by the subtypeId and superTypeId supertypeId became valid
Gloss
Spacetrue
t(active)
or invalid
Gloss
Spacetrue
t(inactive)
from the point in time specified by the
Specref
RefType(field)
teffectiveTime
.

NO

...