HL_ASGN_INFO

Description: |
Hospital Logistics Assignment Information.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
HLR_ID | 1 |
ASSIGNMENT_DATE_REAL | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | HLR_ID | NUMERIC | No |
The unique identifier (.1 item) for the request record.
2 | ASSIGNMENT_DATE_REAL | FLOAT | No |
A unique contact date in decimal format. Each represents an individual assignment of the Logistics request.
3 | ASGN_STATUS_C_NAME | VARCHAR | No |
The current status of each Assignment on this Logistics Request.
May contain organization-specific values: No
Category Entries:
Unplanned
Planned
Assigned
Acknowledged
At Start Location
In Progress
At End Location
Completed
Canceled
Skipped
4 | ASGN_CANCEL_RSN_C_NAME | VARCHAR | No |
When an Assignment's status (I HLR 410) is Canceled or Skipped, this item contains the Assignment's cancel or skip reason.
May contain organization-specific values: Yes
Category Entries:
Automatically Canceled (Default)
Linked Appointment Canceled
Linked Admission PND Canceled
Linked Discharge PND Canceled
Linked Transfer PND Canceled
Linked LOA Out PND Canceled
Linked LOA Return PND Canceled
Planned Break Canceled
Reducing Required Technicians
Canceled By Utility
Linked Transport Request Canceled
Linked ADT Event Canceled
Maintenance Clean Replaced By Bed Clean
Linked Bed Clean Canceled (Room Clean)
Linked Appointment Time Changed
Canceled by Contact Move
Linked Appointment Department Changed
Linking To Adjacent Appointment In Department
Linked Appointment Patient No Show
Linked Appointment Patient Left Without Being Seen
Technician No Longer Needed
Linked Procedural Preassignment Canceled
Linked Case Tracking Event Canceled