Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
DdcMappingCodes This table contains various codes (SNOMED, LOINC, UCUM, etc.) which are associated with concepts in the DdcMappedConcepts table.
Column Name Column Datatype Column Null Option Column Comment
DdcMappedConceptsIDBIGINTNOT NULL ID to associate rows in DdcMappedConcepts and DdcMappingCodes
MappingSystemCodeVARCHAR(64)NOT NULL Systematized Nomenclature of Medicine(SNOMED)/Logical Observation Identifiers Names and Codes(LOINC)/ Unified Code for Units of Measure(UCUM) code, etc.
ResultIdentifierOidINTNOT NULL Foreign Key(FK) to HResultIdentifiers
PubSessionIdBIGINTNOT NULL Foreign Key(FK) to DdcPubSession
UsageTypeTINYINTNOT 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
UsageTypeMnemonicVARCHAR(16)NOT NULL This indicates the Code usage Mnemonics:
1 - QUES_PRIMARY
2 - UCUM
3 - QUES_SECONDARY
4 - ANSW_PRIMARY
5 - ANSW_SECONDARY
LastCngDTimeDATETIMENOT NULL The last time the row was changed(UTC)

Return to Table-Index

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