Table 1: Full Transitive Closure File - Example Specification
|
Field |
Data type |
Purpose |
Part of Primary Key |
|
subtypeId |
Id of the concept playing the subtype role. Set to an Identifier of a concept. |
YES | |
|
supertypeId |
Id of the concept playing the supertype role. Set to an Identifier of a concept. |
YES |
|
|
Specifies the inclusive date at which the transitive closure record was added or changed its active state. |
YES | ||
|
Specifies whether at the transitive closure represented by the subtypeId and supertypeId became valid (active) or invalid (inactive) from the point in time specified by the effectiveTime. |
NO |