V_EHI_AUDIT_ETR

Description: |
This view contains one row for each audited item changed on a transaction record that corresponds to a column that is configured for EHI export.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
TX_ID | 1 |
LINE | 2 |
CHANGED_DATA_ELEMENT | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
The unique identifier for the transaction 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 | CHANGE_USER_ID | VARCHAR | No |
Stores the user ID of the person who performed edit operations.
4 | CHANGE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
5 | CHANGE_UTC_DTTM | DATETIME (UTC) | No |
Instant of change for the transaction history.
6 | ITEM_CHANGE_LINE | NUMERIC | No |
The transaction line that was changed from transaction edit.
7 | OLD_VALUE_INTERNAL | VARCHAR | No |
The edited items previous value.
8 | OLD_VALUE_EXTERNAL | VARCHAR | No |
The edited items previous value, in an external format. This column shows the translated external value as of when the column was last extracted.
9 | NEW_VALUE_INTERNAL | VARCHAR | No |
The edited items new value.
10 | NEW_VALUE_EXTERNAL | VARCHAR | No |
The edited items new value, in an external format. This column shows the translated external value as of when the column was last extracted.
11 | CHANGED_DATA_ELEMENT | VARCHAR | No |
The column descriptor that contains the metadata to be associated with data stored in columns OLD_VALUE_INTERNAL and NEW_VALUE_INTERNAL.