Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HOrderWLItems This is a worktable which holds the order information which is then used to populate worklist categories namely - Orders To be Signed, Orders Approaching Expiration, Intervention & Consultations.
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 1512. 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.
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 time of the order
OrderDescriptionvarchar(300)NOT NULL Order Description as Written.
IsTobeSignedbitNULL Whether order has been co-signed. Values are 0 for if already co-signed and 1 for not yet co-signed
IsApproachingExpbitNULL Whether order qualifies for order approaching expiration worklist. Values are 0 for if not qualifies and 1 when qualifies
IsConsultbitNULL Whether the worklist entry qualifies for Consultations category. Allowable Values: 0 - Not Qualifies , 1 - Qualifies
IsInterventionbitNULL Whether the worklist entry qualifies for Intervention category. Allowable Values: 0 - Not Qualifies , 1 - Qualifies
IsRestrictedbitNULL Whether the order is restricted as defined in the Service Catalog
VisitOIDintNULL Internal Visit Identifier. ObjectID of Patient's visit(HPatientVisit table)
IsDrugbitNOT NULL Whether the worklist entry is a drug order. Values are 0 for Non-Drug and 1 for Drug
OrderTypeCodesmallintNOT NULL ServiceType Code associated with the order. Links to the ServiceTypeCode Field in HServiceType table
OrderTypeIdentifiervarchar(2)NOT NULL Order type identifier - has value of MD for Medication Order and DG for Non-Medication Order
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.
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
ChangeNosmallintNULL Default 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 Default Whether the order should be administered as needed. Values are 1 for yes and 0 for no.
TargetCosigner1StaffNamevarchar(188)NULL Target Cosigner 1 staff name from HStaff
TargetCosigner2StaffNamevarchar(188)NULL Target Cosigner 2 staff name from HStaff
TargetCosigner3StaffNamevarchar(188)NULL Target Cosigner 3 staff name from HStaff
TargetCosigner1StaffOIDIntNULL Target Cosigner 1 objectid from HStaff
TargetCosigner2StaffOIDIntNULL Target Cosigner 2 objectid from HStaff
TargetCosigner3StaffOIDINTNULL Target Cosigner 3 objectid from HStaff
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.
FutureDCDTimeMinssmalldatetimeNULL Represents Future Discontinue Date Time. Only valued for a Medication order which is future Discontinued.
PriorityModifierCodesmallintNULL Modifier Code for Custom Priority
PriorityModifierTextVARCHAR(64)NULL Custom Priority Modifier Text - Indicates the priority of the order. If an order is of high priority, indicates that it must be performed immediately.
PriorityCodesmallintNULL Indicates 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
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.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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