V_EHI_AUDIT_CVG_MEM_2

Description: |
This view contains audit information for coverage records for the purpose of EHI export. If not in the EHI context, AUDIT_ITM_COVERAGE should be used instead. This view only contains data for items that correspond to a specific member on the coverage. This member-specific data is split across multiple views. This specific view contains data for the following related groups: 9510, 18160, 18400, 18971, 19100, 19120, and 19400.
Note that no data from this view will be included in the export if a date is not set in I EAF 995 - COVERAGE AUDIT TRAIL EXPORT CUTOFF DATE.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | COVERAGE_ID | NUMERIC | No |
The ID of the coverage record that was changed.
2 | PAT_ID | VARCHAR | No |
The ID of the patient associated with this coverage.
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 | 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 | ITEM | VARCHAR | No |
The item number for the information that was changed.
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.