Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
DdcAnswer_OID | BIGINT | NOT NULL | Primary Key |
Patient_OID | INT | NOT NULL | Object Id reference to HPatient |
PatientVisit_OID | INT | NULL | Object Id reference to HPatientVisit |
DdcDoc_OID | BIGINT | NOT NULL | Object Id reference to DdcDocument(Main purpose is for Auto Recovery) |
IsCurrent | BIT | NOT NULL | True(1) if the value exists in latest version of the document |
VersionId | SMALLINT | NOT NULL | Version of the document in which answer was charted |
SectionConceptId | VARCHAR(32) | NOT NULL | Concept ID of the root(top-level) section to which the answer is associated |
DdcPath_OID | BIGINT | NOT NULL | Path OID FK to DdcPath table |
DdcDocTemplateContent_OID | BIGINT | NOT NULL | Object Id reference to DdcConceptInstanceDef |
ConceptInstanceId | VARCHAR(32) | NOT NULL | Id of concept instance to which this answer is associated |
LeafConceptId | VARCHAR(32) | NOT NULL | Id of concept associated with the concept instance |
IsHidden | BIT | NOT NULL | True(1) if the answer is hidden |
IsMandatory | BIT | NOT NULL | True(1) if its a mandatory answer |
IsReadOnly | BIT | NOT NULL | True(1) if its a read only answer |
IsFreeTextValue | BIT | NOT NULL | True(1) if its a free text answer |
IsValued | BIT | NOT NULL | True(1) if the answer has a value in it |
IsDefaultable | BIT | NOT NULL | True(1) if the answer can still have a value defaulted for it |
IsDirtied | BIT | NOT NULL | True(1) if the answer is selected or changed(dirtied) |
SequenceNumber | SMALLINT | NULL | For answers related to concept instances contained in a repetitive question, this column contains the sequence number of the repetition to which the answer/concept instance is associated. For all other answers, this column is null. |
AnswerDataType | TINYINT | NOT NULL | Type of data for the Answer, matching FindingDataType column in HObservation(0 - Numeric, 1 - Plain Text, 2 - Encoded, 9 - DateTime, 11 - Formatted Text, 50 - Relative Date, 51 - Boolean(future use), 52 - Repetitive, 53 - Container, 54 - Instructions, 56 - Reference Data) |
AnswerDataTypeMnemonic | CHAR(8) | NOT NULL | Type of data for the Answer |
| | | 0 - Numeric |
| | | 1 - Plain Text |
| | | 2 - Encoded |
| | | 9 - DateTime |
| | | 11 - Formatted Text |
| | | 50 - Relative Date |
| | | 51 - Boolean |
| | | 52 - Repetitive |
| | | 53 - Container |
| | | 54 - Instructions |
| | | 56 - Reference Data |
AnswerStatus | CHAR(1) | NOT NULL | Status of the Answer(A = AutoRecovery, I = Incomplete, C = Complete) |
AnswerRole | CHAR(2) | NOT NULL | Role of the Answer(A = Answer, AA - Allowable Answer) |
BooleanValue | BIT | NULL | Boolean value |
SpecialProcessingType | TINYINT | NULL | Identifies the type of special processing associated with the answer(2 – BP; 3 - Length/Height; 4 – Weight) |
BaseUnitValue | FLOAT | NULL | Contains the numeric value in the base UOM for a numeric answer. |
BaseUnitCode | VARCHAR(20) | NULL | Matches ParentUnitCode/UnitCode column in HPhysicalUnit table |
BaseUnitDisplayName | VARCHAR(20) | NULL | Matches Presentation column in HPhysicalUnit table |
NumericValue | FLOAT | NULL | Numeric value(major value) |
NumericMinorValue | FLOAT | NULL | Minor numeric value |
UomConceptId | VARCHAR(32) | NULL | Unit of measure concept id |
MajorUomDisplayName | VARCHAR(20) | NULL | Major unit of measure display name |
MinorUomDisplayName | VARCHAR(20) | NULL | Minor unit of measure value |
TextValue | NVARCHAR(MAX) | NULL | Text value |
FormattedValue | NVARCHAR(MAX) | NULL | Formatted value for narrative |
ValueConceptId | VARCHAR(32) | NULL | Concept ID of encoded value(without negation prefix) |
CodedValue | VARCHAR(34) | NULL | Coded internal value(with negation prefix "! ") |
IsNegated | BIT | NULL | True(1) if the answer is negated |
DateTimeValue | DATETIME | NULL | Date time value |
MinDateTimeValue | DATETIME | NULL | Min date time value |
MaxDateTimeValue | DATETIME | NULL | Max date time value |
CreateDTime | DATETIME | NOT NULL | Created Date Time(wall clock) |
CollectedDTime | DATETIME | NOT NULL | Collected Date Time(wall clock) |
LastCngDTime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
IsHTML5 | BIT | NULL | True(1) if html snippet in FormattedValue column as HTML5 compliant, False(0) or NULL if html snippet is Non compliant |