Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
DdcMappedConceptsID | BIGINT | NOT NULL | ID to associate rows in DdcMappedConcepts and DdcMappingCodes |
MappingSystemCode | VARCHAR(64) | NOT NULL | Systematized Nomenclature of Medicine(SNOMED)/Logical Observation Identifiers Names and Codes(LOINC)/ Unified Code for Units of Measure(UCUM) code, etc. |
ResultIdentifierOid | INT | NOT NULL | Foreign Key(FK) to HResultIdentifiers |
PubSessionId | BIGINT | NOT NULL | Foreign Key(FK) to DdcPubSession |
UsageType | TINYINT | NOT NULL | Code usage. Allowable Values include: 1 - Primary code for question, 2 - UCUM code, 3 - Secondary code for question, 4 - Primary Code for Answer, 5 - Secondary Code for Answer |
UsageTypeMnemonic | VARCHAR(16) | NOT NULL | This indicates the Code usage Mnemonics: |
| | | 1 - QUES_PRIMARY |
| | | 2 - UCUM |
| | | 3 - QUES_SECONDARY |
| | | 4 - ANSW_PRIMARY |
| | | 5 - ANSW_SECONDARY |
LastCngDTime | DATETIME | NOT NULL | The last time the row was changed(UTC) |