Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HLinkedOrderGroup This table stores the definitional data about a Linked Order Group. Orders in an order set can be grouped by this and while performing an order function the user can presented the entire group to be acted upon
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Object Identifier of this record. This field is a primary key for the associated table.
InstanceHFCIDsmallintNOT NULL Healthcare Foundation Class(HFC) Identifier of the object.HFCID of this object is 1545. The value specified in the ObjectID field and in this field enables unique identification of an object instance across the application.
RecordIdintNULL Not Valued in this table. Column exists as part of persistence framework implementation.
IsDeletedtinyintNOT NULL Specifies whether the record is soft deleted.
Allowable Values
0 - Active
1 - Marked as Deleted.
Note: The presence of this field in tables depends on the configuration at the time of table design.
IsVersionedtinyintNOT NULL When set to True, the object was modified. Once this field is set to True, you cannot reset it to False. Allowable Values: 0 - False, 1 - True. Note: The presence of this field in tables depends on the configuration at the time of table design.
CreatedUserIdintNULL Object ID of the logged in user who created this record.
This field is linked to HSUser table to get details about the user. For more information see description of HSUser table
CreationTimesmalldatetimeNULL Date and time when the record is created.
LastCngDtimedatetimeNULL Last updated time; Universal Time Coordinate or Greenwich Mean Time
OrderSet_ServiceOidintNULL ObjectID of the OrderSet definition to which the order belongs to. It's the ObjectID of HService record which represents and OrderSet.
LinkedOrderGroupNamevarchar(64)NULL OrderSet Name of the Linked Order
LinkedSetOriginNamevarchar(64)NOT NULL Original Linked Set that order came from. Maps to LinkedSetOriginName field in HLinkedSetOrigin table
Foreign_Link_IDvarchar(128)NULL Foreign Link ID in which the order originally came from
LinkTypeNamevarchar(64)NOT NULL LinkTypeName from HLinkType table
Allowable Values
LinkRegular - Orders are linked to each other
NotLinked - The Order Set was marked as not linked

Return to Table-Index

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