Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
DdcAnswer This table contains answers and data associated with concept instances in patient provider documents (DDC).
Column Name Column Datatype Column Null Option Column Comment
DdcAnswer_OIDBIGINTNOT NULL Primary Key
Patient_OIDINTNOT NULL Object Id reference to HPatient
PatientVisit_OIDINTNULL Object Id reference to HPatientVisit
DdcDoc_OIDBIGINTNOT NULL Object Id reference to DdcDocument(Main purpose is for Auto Recovery)
IsCurrentBITNOT NULL True(1) if the value exists in latest version of the document
VersionIdSMALLINTNOT NULL Version of the document in which answer was charted
SectionConceptIdVARCHAR(32)NOT NULL Concept ID of the root(top-level) section to which the answer is associated
DdcPath_OIDBIGINTNOT NULL Path OID FK to DdcPath table
DdcDocTemplateContent_OIDBIGINTNOT NULL Object Id reference to DdcConceptInstanceDef
ConceptInstanceIdVARCHAR(32)NOT NULL Id of concept instance to which this answer is associated
LeafConceptIdVARCHAR(32)NOT NULL Id of concept associated with the concept instance
IsHiddenBITNOT NULL True(1) if the answer is hidden
IsMandatoryBITNOT NULL True(1) if its a mandatory answer
IsReadOnlyBITNOT NULL True(1) if its a read only answer
IsFreeTextValueBITNOT NULL True(1) if its a free text answer
IsValuedBITNOT NULL True(1) if the answer has a value in it
IsDefaultableBITNOT NULL True(1) if the answer can still have a value defaulted for it
IsDirtiedBITNOT NULL True(1) if the answer is selected or changed(dirtied)
SequenceNumberSMALLINTNULL 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.
AnswerDataTypeTINYINTNOT 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)
AnswerDataTypeMnemonicCHAR(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
AnswerStatusCHAR(1)NOT NULL Status of the Answer(A = AutoRecovery, I = Incomplete, C = Complete)
AnswerRoleCHAR(2)NOT NULL Role of the Answer(A = Answer, AA - Allowable Answer)
BooleanValueBITNULL Boolean value
SpecialProcessingTypeTINYINTNULL Identifies the type of special processing associated with the answer(2 – BP; 3 - Length/Height; 4 – Weight)
BaseUnitValueFLOATNULL Contains the numeric value in the base UOM for a numeric answer.
BaseUnitCodeVARCHAR(20)NULL Matches ParentUnitCode/UnitCode column in HPhysicalUnit table
BaseUnitDisplayNameVARCHAR(20)NULL Matches Presentation column in HPhysicalUnit table
NumericValueFLOATNULL Numeric value(major value)
NumericMinorValueFLOATNULL Minor numeric value
UomConceptIdVARCHAR(32)NULL Unit of measure concept id
MajorUomDisplayNameVARCHAR(20)NULL Major unit of measure display name
MinorUomDisplayNameVARCHAR(20)NULL Minor unit of measure value
TextValueNVARCHAR(MAX)NULL Text value
FormattedValueNVARCHAR(MAX)NULL Formatted value for narrative
ValueConceptIdVARCHAR(32)NULL Concept ID of encoded value(without negation prefix)
CodedValueVARCHAR(34)NULL Coded internal value(with negation prefix "! ")
IsNegatedBITNULL True(1) if the answer is negated
DateTimeValueDATETIMENULL Date time value
MinDateTimeValueDATETIMENULL Min date time value
MaxDateTimeValueDATETIMENULL Max date time value
CreateDTimeDATETIMENOT NULL Created Date Time(wall clock)
CollectedDTimeDATETIMENOT NULL Collected Date Time(wall clock)
LastCngDTimeDATETIMENOT NULL Current Universal Time Coordinate or Greenwich Mean Time
IsHTML5BITNULL True(1) if html snippet in FormattedValue column as HTML5 compliant, False(0) or NULL if html snippet is Non compliant

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates