...
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 relationship file. 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 | | Id of the playing the role. Set to an of a . | YES |
supertypeId | | Id of the playing the supertype role. Set to an of a . | YES |
...
Field | Data type | Purpose | Part of Primary Key |
|---|
subtypeId | | Id of the playing the role. Set to an of a . | YES |
supertypeId | | Id of the playing the supertype role. Set to an of a . | |
| Specref |
|---|
| RefType | (field) |
|---|
| t | effectiveTime |
|---|
|
| | Specifies the inclusive date at which the | Gloss |
|---|
| Space | true |
|---|
| t | transitive closure |
|---|
|
record was added or changed its active state. | YES |
| | Specref |
|---|
| RefType | (data type) |
|---|
| t | Boolean |
|---|
|
| Specifies whether at the | Gloss |
|---|
| Space | true |
|---|
| t | transitive closure |
|---|
|
represented by the subtypeId and superTypeId became valid or invalid from the point in time specified by the | Specref |
|---|
| RefType | (field) |
|---|
| t | effectiveTime |
|---|
|
. | NO |
Related Links