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.