VISIT_PREDICTIONS

Description:

The VISIT_PREDICTIONS table contains information about when and where in the hospital a patient is expected to be during their visit. This will currently only include projections used for OR throughput.

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	EXPECTED_PAT_LOC_ID	NUMERIC	No
	The unique ID of the patient's expected location.
4	EXPECTED_REASON_C_NAME	VARCHAR	No
	The reason for the patient's expected stay in this location. May contain organization-specific values: Yes Category Entries: Preprocedure Procedure Recovery Phase II
5	EXPECTED_START_DTTM	DATETIME (Local)	No
	The instant at which the patient is expected to arrive in this location.
6	EXPECTED_DURATION	NUMERIC	No
	The amount of time (in minutes) a patient is expected to stay in this location.
7	PREDICTION_SRC_FEV_ID	VARCHAR	No
	The unique ID of the event that created this prediction.
8	PREDICTION_SRC_FEV_ID_EVENT_NAME	VARCHAR	No
	The name of the event.
9	PREDICTION_SRC_PND_ID	VARCHAR	No
	The unique ID of the pending record that created this prediction.
10	PREDICTION_DTTM	DATETIME (UTC)	No
	The instant at which this prediction was made.
11	PREDICTION_CAUSE_C_NAME	VARCHAR	No
	The reason or event that triggered this prediction to be made. May contain organization-specific values: No Category Entries: Appointment Scheduled Preassignment Location Updated Surgical Case Scheduled
12	ACTIVE_PRED_YN	VARCHAR	No
	Indicates whether this prediction is the most current. May contain organization-specific values: No Category Entries: No Yes
13	UPDATED_BY_USER_ID	VARCHAR	No
	The unique ID of the user who manually entered this prediction.
14	UPDATED_BY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.