Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HOrdHeldOrdersInfo Worktable which holds the orders which got suspended from UI or Non-UI workflows
Column Name Column Datatype Column Null Option Column Comment
StatusDateTimesmalldatetimeNot null Effective DateTime since when the order got supsended
PatientOIDIntNot null Internal Patient Identifier. ObjectID of Patient(HPatient table)
VisitOIDIntnull Internal Visit Identifier. ObjectID of Patient's visit(HPatientVisit table)
OrderOIDIntNot null Internal Order Identifier. ObjectID of Order(HOrder table)
OrderTypeIdentifierVarchar(2)Not null Order type identifier - has value of MD for Medication Order and DG for Non-Medication Order
HoldTypevarchar(3)Not null Value of the workflow which put the order on Hold.
Allowable Values:
UIS - Suspended from UI
DCH - Suspended due to Discharge
UID - Already suspended before Discharge
UIB - Suspended due to Bed Removal
UIC - Already suspended order before HL7 A32 message
LOA - Suspended due to Leave of Absence event
A32 - Suspended due to HL7 A32 message
A09 - Suspended due to HL7 A09 message
PendingStatusDateTimesmalldatetimeNULL Future Suspend orders value this field. During Auto Discontinue Job for Suspended orders, this field is used to filter future suspend orders if they are still in future when the job is running.

Return to Table-Index

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