Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HOrderContext This table stores the contextual information that an order is associated with. Eg ED Orders , Ambulatory Orders etc. Design allows to attach multiple contexts to a given order.
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 1542. 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.
Descriptionvarchar(1)NULL Not Valued in this table. Column exists as part of persistence framework implementation..
IsVersionedbitNOT 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.
ContextNamevarchar(16)NOT NULL Identifying name of the context that the order is associated to. Currently,
Eg "EDVISIT" - all the Orders that are placed from within Tracking Boards will get "EDVISIT" as their context
"Ambulatory" - Inbound pending orders from ambulatory systems are having this context
Design allows to tag the order with different context as per business requirements
ContextOIDintNOT NULL Identifier of the context-specific category/entity that the order is associated to. Eg - for the Orders with "EDVISIT" context it will contain the Tracking Board Visit OID.
Order_oidintNOT NULL ObjectID of the Order(HOrder) to which the context is associated
PatientVisit_oidintNULL ObjectID of the Patient Visit(HpatientVisit) to which the Order is associated
OverrideSourcevarchar(16)NULL Valued when the defaulted Context has been overridden
Allowable values:
User - if the user manually overrides the Context
NULL - context is not overriden.
ContextModifiervarchar(256)NULL Valued only when ContextName is present; can be a comma-delimited list of multiple modifiers or a single one; Eg: ED

Return to Table-Index

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