Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HOrdCheckResultAxnDet This table stores the result of the Alert resolution by the user. Applicable only for Duplicate Check and Medical Necessity Check on Non-medication orders.
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 1667. 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.
ActionIDvarchar(30)NULL Identifier for the Suggested Action the user choose to resolve the Alert
ActionExecutedbitNULL Whether the Action was executed or not. Allowable Values: 0 - Not executed, 1 - Executed.
UserActionDateTimesmalldatetimeNULL DateTime when the action got executed
UserIDintNULL UserOID which executed the Action
RelatedOrderOIDintNULL ObjectID of the Order(Horder), which the suggested Action was pointing to.
ActionTypetinyintNULL Type of Action which was performed by the user
Allowable Values
100 - EHActionTypes.ordActionDCOrder
101 - EHActionTypes.ordActionOverride
102 - EHActionTypes.ordActionDoNotPlaceOrder
103 - EHActionTypes.ordActionPlaceOrderProvideABN
OrdCheckResult_oidintNOT NULL ObjectID of HOrdCheckResult table to which this Action is associated with
SuggAxnStatustinyintNULL Status of the Suggested Action. Allowable Values : 0 - Not Executed , 1 - Executed
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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