HL_JOB_ACTIONS
Description:
Hospital Logistics Requests Actions.

Primary Key
Column Name Ordinal Position
HLR_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 HLR_ID NUMERIC No
The unique identifier (.1 item) for the request record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 HL_ACTION_HL_REQ_STATUS_C_NAME VARCHAR No
The status that triggered the corresponding action.
May contain organization-specific values: No
Category Entries:
Unplanned
Planned
Assigned
Acknowledged
At Start Location
In Progress
At End Location
Completed
Canceled
Skipped
4 HL_ACTION_C_NAME VARCHAR No
The action that was triggered when this Request reached the corresponding status.
May contain organization-specific values: No
Category Entries:
Update Patient Location
Request Bed Clean for Patient's Bed
Update Bed Status
Print Ticket To Ride
Complete Pending Discharge
Complete Pending Transfer
Cancel Linked Bed Clean
Update Bed Blocks
Update Bed Type
Revert Bed Status
5 HL_ACTION_RESULT_C_NAME VARCHAR No
The result of the corresponding action. If the action failed, this will include the reason for failure.
May contain organization-specific values: No
Category Entries:
Success
Not Executed - Patient Bed Not Changing
Not Executed - Patient Not Admitted
Not Executed - Patient Does Not Have a Bed
Not Executed - Back to Bed End Location Isn't Patient's Bed
Not Executed - Patient Discharged and Readmitted
Not Executed - Patient Admitted While on LOA
Not Executed - Patient Location Update Not Required
Not Executed - Feature Not Enabled
Not Executed - No Linked Pending Event
Not Executed - Missing Required Parameter
Not Executed - No Bed Associated with Location
Not Executed - Unknown Action
Not Executed - Unknown Print TTR Location
Not Executed - No Location
Not Executed - No Patient
Not Executed - Prevented By Exclusion Rule
Not Executed - Patient Discharged or On LOA
Not Executed - Linked Pending Event Canceled
Not Executed - Linked Pending Event Completed
Not Executed - Bed Already Dirty
Not Executed - No Linked Bed Clean
Not Executed - No Protocols on Bed Clean
Not Executed - No Bed Block Types are Resolved by EVS
Not Executed - No Bed Type Update
Not Executed - Bed Not Valid for EVS
Not Executed - Linked Bed Clean Linked to ADT Event
Not Executed - Linked Bed Clean is Assigned
Not Executed - Linked Bed Clean is Complete
Not Executed - Skipped by System
Not Executed - Prevented By Inclusion Rule
Not Executed - Protocol Not in Mapping Table
Not Executed - Linked Patient Does Not Have a Contact
Not Executed - Action Hasn't Finished Running
Failed - Unknown Bed Status
Failed - Patient Record Locked
Failed - Confirmation Errors
Failed - Transported Patient Success, L&D Linked Patients Failed
Failed - Transported Patient Failed, L&D Linked Patients Success
Failed - Transported and L&D Linked Patients Failed
Failed - Patient has Earlier Pending Transfers
Failed - Unexpected Error
Failed - Enqueuing Background Job Failed
Failed - Request or Job Record Locked
Failed - Request Already Completed
Failed - Bed Record Locked
Failed - Legacy Bed Clean Not Created
Failed - Logistics Validation Error
Failed - Action Not Yet Implemented
6 HL_ACTION_SOURCE_HLR_ID NUMERIC No
The Logistics Request or Job (HLR) that was the source of this action. For single-stage Requests, this will always be this Job. For multi-stage Requests, this will either be this Job or this Job's parent Request. If a Job has the same Task as its parent Request, only actions sourced from the parent request will be triggered by that Job; the Job's actions will be ignored.
7 HL_ACTION_HL_REQ_STATUS_MOD_C_NAME VARCHAR No
The status modifier that triggered the corresponding action.
May contain organization-specific values: No
Category Entries:
Delay
Hold
8 HL_ACTION_HL_REQ_HOLD_TYPE_C_NAME VARCHAR No
The hold type that triggered the corresponding action when Job Action Status Modifier (I HLR 276) equals 2 - Hold.
May contain organization-specific values: No
Category Entries:
Postpone
Multistage
Stat Interrupt
Protocols
Hold for Bed Request
Working on Another Assignment