UNCONFIRMED_PAT_STAT_HX

Description: |
Clarity table for historical information regarding unconfirmed patient statuses.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | 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.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | UNCNFRM_HX_STAT_C_NAME | VARCHAR | No |
Holds the historical information regarding the patient unconfirmed status (EPT 2023).
May contain organization-specific values: Yes
Category Entries:
Duplicate Review Needed
Identity Verification Needed
Patient Creation in Progress
Flagged as Suspicious
4 | UNCNFRM_HX_STAT_SRC_C_NAME | VARCHAR | No |
Stores whether the patient status from EPT 2043 was added or removed.
May contain organization-specific values: No
Category Entries:
Added
Removed
Modified
5 | UNCNFRM_HX_WKFW_C_NAME | VARCHAR | No |
Holds historical information regarding the unconfirmed patient source workflow in EPT 2044.
May contain organization-specific values: Yes
Category Entries:
MyChart - On My Way
MyChart - Unverified Proxy Video Visit
Welcome
MyChart - Self-Signup
MyChart - Open Scheduling
MyChart - Symptom Checker
Unconfirmed Identity Activity
Web Service
MyChart - SAML Login
MyChart - Guest Proxy
MyChart - Provider Finder
Cheers - Call Management
Patient Merge
MyChart - Location Finder
MyChart - Questionnaire Builder
MyChart Online Enrollment
MyChart - Unverified Patient Video Visit
6 | UNCNFRM_HX_UTC_DTTM | DATETIME (UTC) | No |
Historical information regarding the instant the patient unconfirmed status changed.
7 | UNCNFRM_HX_CLI_DTTM | DATETIME (Attached) | No |
Historical information regarding the client instant of the patient's unconfirmed status.
8 | UNCNFRM_HX_DTTM | DATETIME (Local) | No |
Historical information regarding the server instant of the patient's unconfirmed status.
9 | UNCNFRM_HX_MYPT_ID | VARCHAR | No |
Holds historical information regarding the patient's unconfirmed status. This item holds the MyChart user linked to the patient's unconfirmed status change.
10 | UNCNFRM_HX_USER_ID | VARCHAR | No |
Holds historical information regarding the patient's unconfirmed status. This item holds the Hyperspace user linked to the patient's unconfirmed status change.
11 | UNCNFRM_HX_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
12 | UNCNFRM_HX_RSN_C_NAME | VARCHAR | No |
Holds historical information regarding the patient's unconfirmed status. This item holds the reason linked to the patient's unconfirmed status change.
May contain organization-specific values: Yes
Category Entries:
Fake Demographics
Identity Theft
No Identification
Patient Not Present
Patient Cannot Communicate
Other