Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HObservationUOM Information about the unit of measure (ex:celsius) is stored in this table.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL The primary key for the table.
InstanceHFCIDsmallintNOT NULL HFC(Healthcare Foundation Class) ID of the object.
RecordIdintNULL This column is not used.
Descriptionvarchar(1)NULL This column is not used.
IsVersionedbitNOT NULL When set to True(1), indicates that the object was modified.
CreatedUserIdintNULL ID of the user who created the object.
CreationTimesmalldatetimeNULL Date and time when the object was created.
Unitvarchar(16)NOT NULLType of unit of measure used ex: Cel,F.
Observation_oidbigintNOT NULLID of the observation for which the UOM was used.
LevelsmallintNOT NULLWhen set to 1, indicates whether a base unit of measure(ex:kelvin) or a derived unit of measure(Celsius,Fahrenheit) was used.
ObservationIDbigintNOT NULLID of the observation for which UOM was used.
UnitCodevarchar(16)NOT NULL Code for the Unit of Measure used. ex. The code for Fahrenheit(F) is "degF".
LastCngDtimedatetimeNULL The date and time of the last change.

Return to Table-Index

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