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