V_EHI_AUDIT_EAR
Description:
This view contains audit information for guarantor account records for the purpose of Electronic Health Information (EHI) export. If not in the EHI context, AUDIT_ITM_ACCOUNT should be used instead.

Primary Key
Column Name Ordinal Position
ACCOUNT_ID 1
CHANGE_TIME 2
CHANGED_DATA_ELEMENT 3
LINE 4

Column Information
Name Type Discontinued?
1 ACCOUNT_ID NUMERIC No
The ID of the account record that was changed.
2 PAT_ID VARCHAR No
The ID of the patient associated with this account.
3 CHANGE_TIME DATETIME (Local) No
The time the information in the record was changed.
4 LINE INTEGER No
A value needed when the item that changed was multiple response.
5 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.
6 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.
7 NEW_VALUE_INTERNAL VARCHAR No
The value after the change, in internal format.
8 OLD_VALUE_INTERNAL VARCHAR No
The value before the change, in internal format.
9 CHANGED_DATA_ELEMENT VARCHAR No
The name of the Clarity table and column corresponding to the changed data.
10 USER_ID VARCHAR No
The ID of the user that made the change.
11 USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.