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
Required - Filtered
Optional - Not Offered
Optional - Not Started
Optional - In Progress
Optional - Completed
Optional - Not Needed
Optional - Filtered
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