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
4	ASGN_CANCEL_RSN_C_NAME	VARCHAR	No
	When an Assignment's status is Canceled, this item contains the Assignment's cancel 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