Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object Identifier of this record. This field is a primary key for the associated table. |
InstanceHFCID | smallint | NOT 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. |
RecordId | int | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
Description | varchar(1) | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
IsVersioned | bit | NOT 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. |
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 |
CreationTime | 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 time of the order |
OrderDescription | varchar(300) | NOT NULL | Order Description as Written. |
IsTobeSigned | bit | NULL | Whether order has been co-signed. Values are 0 for if already co-signed and 1 for not yet co-signed |
IsApproachingExp | bit | NULL | Whether order qualifies for order approaching expiration worklist. Values are 0 for if not qualifies and 1 when qualifies |
IsConsult | bit | NULL | Whether the worklist entry qualifies for Consultations category. Allowable Values: 0 - Not Qualifies , 1 - Qualifies |
IsIntervention | bit | NULL | Whether the worklist entry qualifies for Intervention category. Allowable Values: 0 - Not Qualifies , 1 - Qualifies |
IsRestricted | bit | NULL | Whether the order is restricted as defined in the Service Catalog |
VisitOID | int | NULL | Internal Visit Identifier. ObjectID of Patient's visit(HPatientVisit table) |
IsDrug | bit | NOT NULL | Whether the worklist entry is a drug order. Values are 0 for Non-Drug and 1 for Drug |
OrderTypeCode | smallint | NOT NULL | ServiceType Code associated with the order. Links to the ServiceTypeCode Field in HServiceType table |
OrderTypeIdentifier | varchar(2) | NOT NULL | Order type identifier - has value of MD for Medication Order and DG for Non-Medication Order |
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. |
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 |
ChangeNo | smallint | NULL Default | 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 Default | Whether the order should be administered as needed. Values are 1 for yes and 0 for no. |
TargetCosigner1StaffName | varchar(188) | NULL | Target Cosigner 1 staff name from HStaff |
TargetCosigner2StaffName | varchar(188) | NULL | Target Cosigner 2 staff name from HStaff |
TargetCosigner3StaffName | varchar(188) | NULL | Target Cosigner 3 staff name from HStaff |
TargetCosigner1StaffOID | Int | NULL | Target Cosigner 1 objectid from HStaff |
TargetCosigner2StaffOID | Int | NULL | Target Cosigner 2 objectid from HStaff |
TargetCosigner3StaffOID | INT | NULL | Target Cosigner 3 objectid from HStaff |
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. |
FutureDCDTimeMins | smalldatetime | NULL | Represents Future Discontinue Date Time. Only valued for a Medication order which is future Discontinued. |
PriorityModifierCode | smallint | NULL | Modifier Code for Custom Priority |
PriorityModifierText | VARCHAR(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. |
PriorityCode | smallint | NULL | 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 |
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. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|