...
Concept |
---|
t | 371883000|Outpatient procedure| |
---|
ShowFormat | inline |
---|
|
is the source Concept |
---|
t | 116680003|Is a| |
---|
ShowFormat | inline |
---|
|
is the Gloss |
---|
Space | true |
---|
t | relationship type |
---|
|
and; Concept |
---|
t | 71388002|Procedure| |
---|
ShowFormat | inline |
---|
|
is the destination
Field | Data type | Purpose | | Part of Primary Key |
id | | | NO | YES (Full/ Snapshot) |
Specref |
---|
RefType | field |
---|
t | effectiveTime |
---|
|
| | Specifies the inclusive date at which the component version's state became the then current valid state of the component | YES | YES (Full) Optional (Snapshot) |
| | Specifies whether the state of the was or from the nominal release date specified by the Specref |
---|
RefType | field |
---|
t | effectiveTime |
---|
|
field. | YES | NO |
| | Identifies the version's module. Set to a of Concept |
---|
t | 900000000000443000|Module| |
---|
ShowFormat | inline |
---|
|
within the metadata | YES | NO |
| | Identifies the source of the version. That is the defined by this Set to the of a in the Concept File. | NO | NO |
Specref |
---|
RefType | field |
---|
t | destinationId |
---|
|
| | Identifies the that is the destination of the version. That is the representing the value of the attribute represented by the column. Set to the of a in the Concept File. Note that the values that can be applied to particular attributes are formally defined by the SNOMED CT Machine Readable Concept Model . | NO | NO |
Specref |
---|
RefType | field |
---|
t | relationshipGroup |
---|
|
| Integer | Groups together versions that are part of a logically associated Specref |
---|
RefType | field |
---|
t | relationshipGroup |
---|
|
. All records with the same Specref |
---|
RefType | field |
---|
t | relationshipGroup |
---|
|
number and are grouped in this way. | YES | NO |
| | Identifies the that represent the defining attribute (or relationship type) represented by this version. That is the representing the value of the attribute represented by the column. Set to the of a in the Concept File. The concept identified must be either Concept |
---|
t | 116680003|Is a| |
---|
ShowFormat | inline |
---|
|
or a subtype of Concept |
---|
t | 410662002|Concept model attribute| |
---|
|
. The concepts that can be used as in the typeId column are formally defined as follows: Scg expression |
---|
Border | ridge |
---|
ShowFormat | block |
---|
| 116680003|is a| OR <410662002|concept model attribute| |
Note that the attributes that can be applied to particular concepts are formally defined by the SNOMED CT Machine Readable Concept Model.
| NO | NO |
Specref |
---|
RefType | field |
---|
t | characteristicTypeId |
---|
|
| | A enumeration value that identifies the characteristic type of the version (i.e. whether the version is defining, qualifying, etc.) This field is set to a of Concept |
---|
t | 900000000000449001|Characteristic type| |
---|
ShowFormat | inline |
---|
|
in the metadata . | YES | NO |
|
| A enumeration value that identifies the type of (DL) restriction (some, all, etc.). Set to a of Concept |
---|
t | 900000000000450001|Modifier| |
---|
ShowFormat | inline |
---|
| in the metadata Note |
---|
Currently the only value used in this column is Concept |
---|
t | 900000000000451002|Some| |
---|
ShowFormat | inline |
---|
| and thus in practical terms this column can be ignored. For further clarification please see notes on modifierId . |
| YES | NO |
Only one
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.
...