V_EHI_REG_ITEM_AUDIT_EPT

Description: |
Patient record audit events. This view contains audit information for patient records for the purpose of Electronic Health Information (EHI) export. If not in the EHI context, REG_ITEM_AUDIT_EPT and REG_ITEM_AUDIT_LINES_EPT should be used instead.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ITEM_AUDIT_ID | NUMERIC | No |
The unique identifier (.1 item) for the audit event record.
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 | AUDIT_INSTANT_UTC_DTTM | DATETIME (UTC) | No |
The instant the audit was recorded in the UTC time zone.
4 | AUDIT_INSTANT_LOCAL_DTTM | DATETIME (Attached) | No |
The instant the audit was recored in the local time zone where the change took place.
5 | PAT_ID | VARCHAR | No |
Patient that was changed in this audit event.
6 | CHANGED_PAT_ENC_CSN_ID | NUMERIC | No |
Contact serial number of the contact that was changed in this audit event.
7 | CHANGED_DATA_ELEMENT | VARCHAR | No |
The name of the Clarity table and column corresponding to the changed data.
8 | CHANGED_ITEM_NAME | VARCHAR | No |
Name of the item that was changed in the audit event.
9 | CHANGED_LINE | INTEGER | No |
Item line that was changed in the audit event.
10 | CHANGED_SUB_LINE | INTEGER | No |
Item subline that was changed in the audit event.
11 | OLD_VALUE_EXTERNAL | VARCHAR | No |
External value of the item line before the item was changed.
12 | NEW_VALUE_EXTERNAL | VARCHAR | No |
External value of the item line after the item was changed.
13 | USER_ID | VARCHAR | No |
User who changed the items in this audit event.
14 | USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.