V_EHI_AUDIT_HTT
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

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
This column stores the user who changed the items on the record.
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
This column stores the date and time of data change on the record.
6 TRANSACTION_LINE INTEGER No
This column stores on which line the data change happened. It will be blank if the change is not specific to a line.
7 ITEM_CHANGE_LN INTEGER No
This column stores on which item line the record's item changes. It is only set for multiple response item value changes.
8 OLD_VALUE_INTERNAL VARCHAR No
Stores the old data value that was changed on the temporary transaction. If you use IntraConnect, this is the CID of the old stored value.
9 OLD_VALUE_EXTERNAL VARCHAR No
This column stores the previous value, in an external format, of the changed item in the record's audit history. This column shows the translated external value as of when the column was last extracted.
10 NEW_VALUE_INTERNAL VARCHAR No
Stores the new data value that was added to the temporary transaction. If you use IntraConnect, this is the CID of the new stored value.
11 NEW_VALUE_EXTERNAL VARCHAR No
This column stores the new value, in an external format, of the changed item in the record's audit history. This column shows the translated external value as of when the column was last extracted.
12 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.