Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HResultIdentifiers This table stores information related to standardized Coding systems.
Column Name Column Datatype Column Null Option Column Comment
ResultIdentifierOidintNOT NULL Object ID and primary key of the table, HResultIdentifiers.
IdentifierAbbrvarchar(16)NULL Standardized Coding System abbbreviation. For example, LN, SMD, SCT etc.
IdentifierNamevarchar(32)NULL Standardized Coding System Name. For example, LOINC, SNOMED etc.
IdentifierISOOIDvarchar(150)NULL ISO OID associated to the Coding System.
IdentifierVersionvarchar(16)NULL Coding System Version. For example, '23.1' etc.
LastCngDtimedatetimeNULL Current Universal Time Coordinate or Greenwich Mean Time.

Return to Table-Index

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