Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HOrdCheckResult This table stores the details of Duplicate Check & Medical Necessity Check Alerts that appeared on Non-Medication Orders during order entry.
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 1666. 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.
SessionIDintNULL Identifier of the Ordering session in which the Alert was Created.
AlertIDvarchar(30)NULL Identifier of the Alert which got generated for the Order
AlertTypetinyintNULL Type of Alert
Allowable Values
100 - EHCheckType.ordTypeDuplicateCheck(Duplicate Check Alert)
101 - EHCheckType.ordTypeMNC(Medical Necessity Check Alert)
AlertDescriptionvarchar(64)NULL Description of the Alert
OrderOIDintNULL ObjectID of the Order(HOrder) for which the alert is generated.
OverrideCommentsvarchar(64)NULL Comments entered by the user while overriding/Ignoring the Alert.
AlertStatustinyintNULL Final Status of the Alert
Allowable Values
100 - EHAlertAction.ordAlertPresented
101 - EHAlertAction.ordAlertResolutionInprogress
102 - EHAlertAction.ordAlertResolutionComplete
103 - EHAlertAction.PartialOverride
104 - EHAlertAction.CompleteOverride
Patient_oidintNULL ObjectID of the patient(HPatient)
Visit_oidintNULL ObjectID of the patientVisit(HPatientVisit)
CreatedDateTimesmalldatetimeNULL DateTime when the Alert was created
CreatedUserOIDintNULL UserOID which created the Alert
TriggerOrderOIDintNULL ObjectID of Order(HOrder) which triggered this Alert processing. This field is only valued when Order is getting placed from AutoSign public service and the public service passes an OrderOID as input
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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