ECHKIN_PHASE_INFO
Description:
The ECHECKIN_PHASE_INFO table contains information about the "just in time" eCheck-In status. Each row contains information about a single phase where eCheck-In information could be asked, such as pre-arrival or post-arrival.

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 ECHKIN_PHASE_C_NAME VARCHAR No
A given phase for just-in-time eCheck-In, to track statuses of eCheck-In at a given point in time. When used with the rest of the items in the related group, this allows retrieving phase-based status information, such as whether a patient completed all of their pre-arrival or post-arrival tasks.
May contain organization-specific values: No
Category Entries:
Pre-Everything
Pre-Arrival
Post-Arrival
Post-Everything
Any Phase
7 ECHKIN_PHASE_STATUS_C_NAME VARCHAR No
The status for a given phase of just-in-time eCheck-In. This tracks whether a patient completed all of their tasks for a given phase, such as pre-arrival or post-arrival.
May contain organization-specific values: No
Category Entries:
Not Offered
Not Yet Available
Not Started
In Progress
Completed
Not Needed
Not Completed
Filtered
Required - Not Offered
Required - Not Started
Required - In Progress
Required - Completed
Required - Not Needed
Optional - Not Offered
Optional - Not Started
Optional - In Progress
Optional - Completed
Optional - Not Needed
8 ECHKIN_URL_PHASE_YN VARCHAR No
Whether a URL was generated for eCheck-In during a given phase for just-in-time eCheck-In. This tracks whether a "for all" workflow was available, not whether a tickler was sent manually from front desk workflows.
May contain organization-specific values: No
Category Entries:
No
Yes