PREDICTED_LOS

Description:

The PREDICTED_LOS table contains the predicted length of stay audit trail history.

Primary Key

Column Name	Ordinal Position
PAT_ENC_CSN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ENC_CSN_ID	NUMERIC	No
	The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
4	PAT_ENC_DATE_REAL	FLOAT	No
	A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
5	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
6	CM_CT_OWNER_ID	VARCHAR	No
	The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
7	PRED_LOS_ENTRY_UTC_DTTM	DATETIME (UTC)	No
	The instant of update for the Predicted Length of Stay.
8	PRED_LENGTH_OF_STAY	NUMERIC	No
	The Length of Stay determined by the Predictive Model."
9	PRED_LOS_EVENT	VARCHAR	No
	The Event Trigger that caused the Predictive Model to run.
10	PRED_LOS_EVENT_EVENT_NAME	VARCHAR	No
	The name of the event.
11	UPD_PRED_LOS_YN	VARCHAR	No
	Indicates whether the prediction value was copied to the operational item. May contain organization-specific values: No Category Entries: No Yes
12	PRED_LOS_TRIG_TYP_C_NAME	VARCHAR	No
	The Event Trigger that caused the Predictive Model to run. May contain organization-specific values: Yes Category Entries: Admission Discharge Transfer ED Arrival ED Dismissal L&D Assessment L&D Admission Newborn Admission Undo Admission Undo Discharge Undo Transfer Update Admission Update Discharge Update Transfer Preadmission Added Isolation Status Removed Isolation Status Insert Patient Update Update Patient Update Pending Event Created Bed Requested Ready to Plan Bed Request Assigned Bed Request Rejected Bed Request Approved Pending Event Updated HOV Confirm Pending Event Canceled Pending Event Completed Pending Event Restored Appointment Scheduled Appointment Signed In Appointment Checked In Appointment Checked Out Appointment Canceled Appointment Sign In Canceled Appointment Check In Canceled HOV Discharge Inpatient Admission Delivery Observation Admission After Merge ED Roomed Transport Request Put In Pending List Primary Transport Request Assigned Transport Request In Progress Primary Transport Request Completed Transport Request Delayed Primary Transport Request Canceled Transport Request Unassigned Secondary Transport Request Assigned Secondary Transport Request Completed Secondary Transport Request Canceled Transporter Request For Additional Help Transport Warning Escalation Transport Escalation Insert Transfer Transfer Failure - Patient Location Update Generated Primary Transport Request Acknowledged Secondary Transport Request Acknowledged Leave of Absence Return From Leave of Absence Undo Leave of Absence Undo Return From Leave of Absence Update Leave of Absence Update Return From Leave of Absence Convert Discharge to Leave of Absence Convert Leave of Absence to Discharge Bed Requested Bed Request Pre-assigned Bed Request Bed Ready Bed Request Requested Delay Bed Request Ready to Plan Delay Bed Request Pre-assigned Delay Bed Request Assigned Delay Bed Request Approved Delay Bed Request Rejected Delay Bed Request Bed Ready Delay Transport Request Linked Appointment Updated Transfer Failure - Transport Generated Discharge Failure - Transport Generated Provider Added to Treatment Team Provider Added As Attending Bed Request Ready to Move Bed Request Not Ready to Move Midnight Census Transport Ready to Move Transport Not Ready to Move Transport Bed Ready Transport Bed Not Ready Transport Source Location Changed Transport Destination Location Changed Discharge Failure - Patient Location Update Generated Transfer Canceled Discharge Time Delayed Discharge Canceled Patient No Longer Ready Other Patient No Longer Ready Bed Request Escalation Another Bed is Ready Dismiss Failure - Patient Location Update Generated ED Room Failure - Patient Location Update Generated Discharge Delay Added: Bed Planning Impacted Transfer Center Request Created Transfer Center Request Accepted Transfer Center Request Completed Transfer Center Request Canceled Transfer Center Request Patient Attached Undo Preadmission Order Reverted Bed Request Order Has Meaningful Bed Request Changes Order Was Discontinued Hold Bed Was Canceled Hold Bed Was Restored Bed Request Unassigned From Unit Case Tracking Event Transfer Failure - Patient Location Updated Logistics Request Planned Logistics Request Assigned Logistics Request At Start Location Logistics Request In Progress Logistics Request At End Location Logistics Request Completed Logistics Request Canceled Logistics Request Unassigned Logistics Request Delayed Logistics Technician Escalation Logistics Supervisor Escalation Logistics Manager Escalation Logistics Request Updated Logistics Request Postponed Logistics No Technician In The Sector Logistics Technician Not Returned From Break Logistics Technician Total Break Time Exceeded Logistics Update Patient Location Action Failed Logistics Request Bed Clean for Patient's Bed Action Failed Logistics Update Bed Status Action Failed Logistics Print Ticket To Ride Action Failed Logistics Complete Pending Discharge Action Failed Logistics Complete Pending Transfer Action Failed Logistics Break Started Logistics Update Bed Blocks Action Failed Logistics Break Ended Logistics Sign In Logistics Manual Sign Out Logistics Transport Link Appointment Updated Order Reverted Transfer Center Request Order Has Meaningful Transfer Center Changes Logistics Job Interrupted By Stat Logistics Request Acknowledged Logistics Job Skipped Bed Request Now Planned To New Unit Logistics Job Priority Upgraded to High Logistics Job Priority Upgraded to Stat Logistics Job Now Upcoming Logistics Automatic Transport Creation Failed Logistics Daemon Problem Encountered Discharge Milestone Completed Discharge Milestone Overdue Discharge Milestone Marked Incomplete Discharge Milestone Added Discharge Milestone Removed Logistics Break Time Over Logistics Daily Task not Completed Sector Level Logistics Auto Sign Out Logistics Inactive Technician Logistics Daily Task Job Interrupted Discharge Delay Resolved Discharge Delay Marked Unresolved Discharge Delay Added Discharge Order Signed Discharge Milestone Still Outstanding and Expected Discharge Date is Today Discharge Milestone Still Outstanding and Expected Discharge Date is Tomorrow Discharge Milestone Still Outstanding and Discharge Order Signed Discharge Milestone Still Outstanding and Medically Ready For Discharge Discharge Milestone Became Next Step Delay Still Unresolved and Expected Discharge Date is Today Delay Still Unresolved and Expected Discharge Date is Tomorrow Delay Still Unresolved and Discharge Order Signed Delay Still Unresolved and Medically Ready For Discharge Patient Medically Ready For Discharge Admission Failure - Patient Location Update Generated Bed Request Unassigned From Bed ADT Order Error Patient Verification Encounter Verification HAR Verification HAR 2 Verification Patient's PCP Notification Preference Changed Surgical Case Scheduled Hospital Coding Complete Appointment Canceled (Same Day) Appointment Roomed Close Nurse Triage Encounter
13	PRED_LOS_ACCPTED_YN	VARCHAR	No
	This item represents whether or not this prediction was accepted by an end user. If it was, then this prediction will be copied over into the expected length of stay and end users will no longer be prompted to use the prediction. May contain organization-specific values: Yes Category Entries: No Yes Not Shown