V_EHI_AUDIT_BEN

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

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | BENEFIT_ID | NUMERIC | No |
The ID of the benefits record that was changed.
2 | PAT_ID | VARCHAR | No |
The ID of the patient associated with this benefit record.
3 | CHANGE_TIME | DATETIME (Local) | No |
The time the information in the record was changed.
4 | LINE | INTEGER | No |
Indicates which line of the item this row holds. This is used for items which can have multiple responses.
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.