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
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