Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HOrderToBeAckWLItems This is a worktable which holds the order information which is then used populate the Orders to be Acknowledged worklist category in Cinical UI.
Column Name Column Datatype Column Null Option Column Comment
OrderToBeAckOIDintNOT NULL Identifier of the record. Is Primary Key.
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
CreationDateTimesmalldatetimeNULL Date and time when the record is created.
PatientIDintNOT NULL Internal Patient Identifier. ObjectID of Patient(HPatient table)
OrderOIDintNOT NULL Internal Order Identifier. ObjectID of Order(HOrder table)
OrderTypeAbbrvarchar(30)NULL Order Type Abbreviation such as Laboratory, Radiology, etc.
EndDateTimesmalldatetimeNULL The ending date time of the worklist entry
StatusCodetinyintNOT NULL Internal identifier of the Order Status Code . See definition of HOrder table for allowable values.
StartDateTimesmalldatetimeNULL Start Date and Time of the order to be acknowledged
OrderDescriptionvarchar(300)NOT NULL Order Description as written.
IsToBeAcknowledgedbitNULL Whether order has been acknowledged. Values are 0 for acknowledged and 1 for not yet acknowledged
IsRestrictedbitNULL Whether the order is restricted as defined in the Service Catalog
Allowable Values
0 - False
1 - True.
VisitOIDintNULL Internal Visit Identifier. ObjectID of Patient's visit(HPatientVisit table)
ServiceRequestor_oidintNULL Foreign Key - ObjectId of HHealthCareUnit table. This is the internal identifier of the service requestor
ServiceProvider_oidintNULL Foreign Key - ObjectId of HHealthCareUnit table. This is the internal identifier of the service provider
OrderTypeCodesmallintNOT NULL ServiceType Code associated with the order. Links to the ServiceTypeCode Field in HServiceType table
OrderSubTypeAbbrvarchar(30)NULL Abbreviation from HServiceType table of it's ServiceSubType relation with HService from which the Order is created.
Providedby_oidintNULL Object ID associated with the healthcare professional who fulfills the order request. Primarily used for capturing physician's for Consult orders.
OrderTypeIdentifiervarchar(2)NOT NULL Order type identifier - has value of MD for Medication Order and DG for Non-Medication Order
IsDrugbitNOT NULL Whether the worklist entry is a drug order. Values are 0 for Non-Drug and 1 for Drug
ChangeNosmallintNULL Internal field which maps to the ChangeNo column on HOrder table. Used to perform staleness check for UI workflows.
IsRecurringOrdertinyintNOT NULL Whether this order is recurring order. Values are 0 for not-recurring and 1 for recurring order.
IsPRNtypetinyintNULL Whether the order should be administered as needed. Values are 1 for yes and 0 for no.
LastCngDtimedatetimeNULL When was the record update the last time. This is Coordinated Universal Time(UTC)
RequestedbyStaffNamevarchar(188)NULL Name of Staff person(HStaff) who requested the order
RequestedbyStaffOIDintNULL Internal identifier - ObjectID of the staff who requested the order
OrderSourceAbbrchar(4)NULL Order Source Abbreviation. Allowable Values : NULL, PRTL for protocol, WRTN for written, VERB for verbal discontinue
CausedInFunctionCodesmallintNULL Internal orders module code to indicate which order function caused the entry of this acknowledgment row in worklist.
PriorityTextvarchar(32)NULL Priority text of the order. This column contains values such as Routine, Call back, As soon as possible, etc.
PriorityCodetinyintNULL The code associated with the priority of the order.
Allowable Values:
0 - Routine
1 - Timing Critical
2 - Now Routine
3 - As Soon As possible
4 - Preoperative
5 - Call Back
6 - Stat
FutureDCDTimeMinssmalldatetimeNULL Represents Future Discontinue Date Time. Only valued for a Medication order which is future Discontinued.
LastModifiedDtimeMinssmalldatetimeNULL Last modified Date Time. This is the wall time when the record was modified last.
PriorityModifierPriorityCodesmallintNULL Modifier Code for Custom Priority
OrderSourceModifierNameVARCHAR(64)NULL, Reason for which the order is marked as verbal order. Order source can be valued from Session detail/ Order detail
PendingStatusDateTimeSMALLDATETIMENULL Represents the Future Suspend Date/Time . Only valued for a Medication order which is future suspended.

Return to Table-Index

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