Search



Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Note
iconfalse
titleImportant Note

Transitive Closure Files are not distributed in the SNOMED CT International Release
The file structures documented here are points of reference for those generating transitive closure table from release data. SNOMED International provides a script file that can be used to generate the Snapshot Transitive Closure file from the snapshot Relationship File.


The

Gloss
PreSpacefalse
tTransitive Closure
is the complete set of
Gloss
PreSpacefalse
trelationships
between every
Gloss
PreSpacefalse
tconcept
and each of its super-type
Gloss
PreSpacefalse
tconcepts
, in other words both its parents and
Gloss
PreSpacefalse
tancestors
. A History file can be generated from the content using scripts provided with each release. The generated file will be of the following format and contain the valid states of the of each across all previous releases:

...

 

...

 

A transitive closure table is one of the most efficient ways to test for subsumption between concepts.

Snapshot Transitive Closure File

SNOMED International provides an example of a Transitive Closure Perl script file (click to download)  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.

Caption label
CapIdtransitive-closure-file-detailed-specification
CapTypeTable
Transitive Closure File - Detailed Specification

Bookmarked content insert
Startfilespec
PageREUSE:Transitive Closure Snapshot File

Scroll Pagebreak

Versioned Transitive Closure

A versioned view of the

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

Caption label
CapIdversioned-transitive-closure-file-example-specification
CapTypeTable
Versioned Transitive Closure File - Example Specification

Bookmarked content insert
Startfilespec
PageREUSE:Transitive Closure File

...

Field

...

Data type

...

Purpose

...

 

...

subtypeId

...

SCTID (data type)

...

Id of the playing the role. Set to an of a .

...

 

...

supertypeId

...

SCTID (data type)

...

Id of the playing the supertype role. Set to an of a .

...

 

...

effectiveTime (field)

...

Time (data type)

...

Specifies the inclusive date at which the record became valid.

...

 

...

active (field)

...

Boolean (data type)

...

Specifies whether the version's state was or from the point in time specified by the effectiveTime (field) .

...

Related Links

Scroll Pagebreak