CLINICIAN_ON_MY_WAY
Description:
This table stores information regarding clinicians who marked themselves On My Way to see the patient.

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 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 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.
6 USER_ID VARCHAR No
Provider who is on the way to see the patient
7 USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
8 MARKED_UTC_DTTM DATETIME (UTC) No
The instant that the provider marked that they were on their way to see the patient
9 ON_MY_WAY_STAT_C_NAME NUMERIC No
Stores if the clinician's On My Way status is no longer active based on an event other than the time length of the On My Way status running out. This is set when a clinician arrives in the patient's room based on RTLS data.
May contain organization-specific values: No
Category Entries:
Active
Clinician Canceled
Clinician Reached The Room
Expired