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_RECORD_NAME VARCHAR No
The name of the PLF record.
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.