V_EHI_AUDIT_EPT

Description: |
This view contains audit information for patient records for the purpose of Electronic Health Information (EHI) export. This view contains patient-level patient data. If not in the EHI context, AUDIT_ITM_PATIENT should be used instead.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ID | 1 |
CHANGE_TIME | 2 |
CHANGED_DATA_ELEMENT | 3 |
LINE | 4 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ID | VARCHAR | No |
The ID of the patient record that was changed.
2 | CHANGE_TIME | DATETIME (Local) | No |
The time the information in the record was changed.
3 | LINE | INTEGER | No |
A value needed when the item that changed was multiple response.
4 | NEW_VALUE_EXTERNAL | VARCHAR | No |
The value after the change, in external format. This column shows the translated external value as of when the column was last extracted.
5 | OLD_VALUE_EXTERNAL | VARCHAR | No |
The value before the change, in external format. This column shows the translated external value as of when the column was last extracted.
6 | NEW_VALUE_INTERNAL | VARCHAR | No |
The value after the change, in internal format.
7 | OLD_VALUE_INTERNAL | VARCHAR | No |
The value before the change, in internal format.
8 | CHANGED_DATA_ELEMENT | VARCHAR | No |
The name of the Clarity table and column corresponding to the changed data.
9 | USER_ID | VARCHAR | No |
The ID of the user that made the change.
10 | USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.