Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
DdcMappedConceptsID | BIGINT | NOT NULL | ID to associate rows in DdcMappedConcepts and DdcMappingCodes |
FindingAbbreviation | VARCHAR(16) | NULL | Finding Abbreviation. For example, for Temperature it's A_Temp. Value remains null for FDT concepts |
DisplayName | VARCHAR(255) | NOT NULL | Display Name of question/parameter/value |
DdcPath_OID | BIGINT | NULL | Foreign Key(FK) to DdcPath table; path of question/parameter; only used with FDT(FlowsheetData Template) concepts |
PubSessionId | BIGINT | NOT NULL | Foreign Key(FK) to DdcPubSession |
ConceptId | VARCHAR(32) | NOT NULL | Concept ID of the question/parameter/finding map |
ValueCID | VARCHAR(32) | NULL | Concept ID of value; null indicates a question/parameter |
TemplateRootID | VARCHAR(255) | NULL | Root ID associated to Consolidated Clinical Data Architecture(CCDA) section. Valid for questions/parameters |
SequenceNumber | SMALLINT | NULL | Sequence number to identify the order of values for an encoded |
IsDefaultValue | BIT | NOT NULL | Default value for an encoded. Allowable values are: 1 - Yes, 0 - No. |
IsHistoric | BIT | NOT NULL | Historic data. Allowable values are: 1 - Yes, 0 - No. |
LastCngDTime | DATETIME | NOT NULL | Last time row was changed(UTC) |