Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
DdcMappedConcepts Contains information about finding abbreviations and their values from the Map Definition and concepts with mapping code interfaces.
Column Name Column Datatype Column Null Option Column Comment
DdcMappedConceptsIDBIGINTNOT NULL ID to associate rows in DdcMappedConcepts and DdcMappingCodes
FindingAbbreviationVARCHAR(16)NULL Finding Abbreviation. For example, for Temperature it's A_Temp. Value remains null for FDT concepts
DisplayNameVARCHAR(255)NOT NULL Display Name of question/parameter/value
DdcPath_OIDBIGINTNULL Foreign Key(FK) to DdcPath table; path of question/parameter; only used with FDT(FlowsheetData Template) concepts
PubSessionIdBIGINTNOT NULL Foreign Key(FK) to DdcPubSession
ConceptIdVARCHAR(32)NOT NULL Concept ID of the question/parameter/finding map
ValueCIDVARCHAR(32)NULL Concept ID of value; null indicates a question/parameter
TemplateRootIDVARCHAR(255)NULL Root ID associated to Consolidated Clinical Data Architecture(CCDA) section. Valid for questions/parameters
SequenceNumberSMALLINTNULL Sequence number to identify the order of values for an encoded
IsDefaultValueBITNOT NULL Default value for an encoded. Allowable values are: 1 - Yes, 0 - No.
IsHistoricBITNOT NULL Historic data. Allowable values are: 1 - Yes, 0 - No.
LastCngDTimeDATETIMENOT NULL Last time row was changed(UTC)

Return to Table-Index

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