Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HResultIdentifierDetail This table stores information related to standardized coding systems such as LOINC Snomed, etc. For example, the LOINC code of 10917-3 would be stored in Identifier details Code and Zinc would be stored as the description.
Column Name Column Datatype Column Null Option Column Comment
ResultIdentifierDetailOidintNOT NULL Object ID and primary key of the table, HResultIdentifierDetail.
IdentifierCodevarchar(32)NOT NULL Observation Identifier. For example, 58410-2 would be stored as the LOINC code for a CBC.
IdentifierDescvarchar(255)NULL Observation Identifier Description. For example, Complete blood count(hemogram) panel.
ResultIdentifierOidintNOT NULL Relationship with HResultIdentifiers table.
LastCngDtimedatetimeNULL Current Universal Time Coordinate or Greenwich Mean Time.

Return to Table-Index

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