HL_REQ_STATUS_AUDIT

Description:

Hospital Logistics Request Status Audit.

Primary Key

Column Name	Ordinal Position
HLR_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	HLR_ID	NUMERIC	No
	The unique identifier 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	EVENT_UTC_DTTM	DATETIME (UTC)	No
	The UTC instant when a status change event occurred for this Logistics Request.
4	STATUS_C_NAME	VARCHAR	No
	The status audit trail for this Logistics Request's status (I HLR 160). May contain organization-specific values: No Category Entries: Unplanned Planned Assigned Acknowledged At Start Location In Progress At End Location Completed Canceled Skipped
5	CANCEL_RSN_C_NAME	VARCHAR	No
	The status audit trail for this Logistics Request's cancel or Job's skip reason (I HLR 175). 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
6	EVENT_LOCAL_DTTM	DATETIME (Local)	No
	The local instant when a status change event occurred for this Logistics request. For UTC, use HL_REQ_STATUS_AUDIT.EVENT_UTC_DTTM.