Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
OrderToBeAckOID | int | NOT NULL | Identifier of the record. Is Primary Key. |
CreatedUserId | int | NULL | 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 |
CreationDateTime | smalldatetime | NULL | Date and time when the record is created. |
PatientID | int | NOT NULL | Internal Patient Identifier. ObjectID of Patient(HPatient table) |
OrderOID | int | NOT NULL | Internal Order Identifier. ObjectID of Order(HOrder table) |
OrderTypeAbbr | varchar(30) | NULL | Order Type Abbreviation such as Laboratory, Radiology, etc. |
EndDateTime | smalldatetime | NULL | The ending date time of the worklist entry |
StatusCode | tinyint | NOT NULL | Internal identifier of the Order Status Code . See definition of HOrder table for allowable values. |
StartDateTime | smalldatetime | NULL | Start Date and Time of the order to be acknowledged |
OrderDescription | varchar(300) | NOT NULL | Order Description as written. |
IsToBeAcknowledged | bit | NULL | Whether order has been acknowledged. Values are 0 for acknowledged and 1 for not yet acknowledged |
IsRestricted | bit | NULL | Whether the order is restricted as defined in the Service Catalog |
| | | Allowable Values |
| | | 0 - False |
| | | 1 - True. |
VisitOID | int | NULL | Internal Visit Identifier. ObjectID of Patient's visit(HPatientVisit table) |
ServiceRequestor_oid | int | NULL | Foreign Key - ObjectId of HHealthCareUnit table. This is the internal identifier of the service requestor |
ServiceProvider_oid | int | NULL | Foreign Key - ObjectId of HHealthCareUnit table. This is the internal identifier of the service provider |
OrderTypeCode | smallint | NOT NULL | ServiceType Code associated with the order. Links to the ServiceTypeCode Field in HServiceType table |
OrderSubTypeAbbr | varchar(30) | NULL | Abbreviation from HServiceType table of it's ServiceSubType relation with HService from which the Order is created. |
Providedby_oid | int | NULL | Object ID associated with the healthcare professional who fulfills the order request. Primarily used for capturing physician's for Consult orders. |
OrderTypeIdentifier | varchar(2) | NOT NULL | Order type identifier - has value of MD for Medication Order and DG for Non-Medication Order |
IsDrug | bit | NOT NULL | Whether the worklist entry is a drug order. Values are 0 for Non-Drug and 1 for Drug |
ChangeNo | smallint | NULL | Internal field which maps to the ChangeNo column on HOrder table. Used to perform staleness check for UI workflows. |
IsRecurringOrder | tinyint | NOT NULL | Whether this order is recurring order. Values are 0 for not-recurring and 1 for recurring order. |
IsPRNtype | tinyint | NULL | Whether the order should be administered as needed. Values are 1 for yes and 0 for no. |
LastCngDtime | datetime | NULL | When was the record update the last time. This is Coordinated Universal Time(UTC) |
RequestedbyStaffName | varchar(188) | NULL | Name of Staff person(HStaff) who requested the order |
RequestedbyStaffOID | int | NULL | Internal identifier - ObjectID of the staff who requested the order |
OrderSourceAbbr | char(4) | NULL | Order Source Abbreviation. Allowable Values : NULL, PRTL for protocol, WRTN for written, VERB for verbal discontinue |
CausedInFunctionCode | smallint | NULL | Internal orders module code to indicate which order function caused the entry of this acknowledgment row in worklist. |
PriorityText | varchar(32) | NULL | Priority text of the order. This column contains values such as Routine, Call back, As soon as possible, etc. |
PriorityCode | tinyint | NULL | 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 |
FutureDCDTimeMins | smalldatetime | NULL | Represents Future Discontinue Date Time. Only valued for a Medication order which is future Discontinued. |
LastModifiedDtimeMins | smalldatetime | NULL | Last modified Date Time. This is the wall time when the record was modified last. |
PriorityModifierPriorityCode | smallint | NULL | Modifier Code for Custom Priority |
OrderSourceModifierName | VARCHAR(64)NULL, | | Reason for which the order is marked as verbal order. Order source can be valued from Session detail/ Order detail |
PendingStatusDateTime | SMALLDATETIME | NULL | Represents the Future Suspend Date/Time . Only valued for a Medication order which is future suspended. |