Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HResultRefRanges This table stores information related to the Normal and Critical reference ranges of a Result.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Object ID and primary key of the table, HResultRefRanges.
InstanceHFCIDsmallintNOT NULL HFC(Healthcare Foundation Class) ID of the object. Note: The value specified in the ObjectID field and in this field enables unique indentification of an object across the application.
RecordIdintNULL Record ID.
Descriptionvarchar(1)NULL User-defined description for the row.
IsVersionedbitNOT NULL Indicates whether the result is modified. Allowable Values: 0 - No, 1 - Yes.
CreatedUserIdintNULL Object ID of the user who created the result. This field is linked to the HSUser table to get details about the user.
CreationTimesmalldatetimeNULL Date and time when the Result is created.
ResOIDbigintNOT NULL ObjectID of a Result.
NormalReferenceRangevarchar(255)NULL NormalReferenceRange of a Result.
CriticalReferenceRangevarchar(255)NULL CriticalReferenceRange of a Result.

Return to Table-Index

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