V_EHI_AUDIT_HTR

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 |
This column stores the unique identifier for the hospital billing transaction.
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 item stores the user who changed the hospital temporary transaction items while the hospital billing transaction is in its temporary state. It is part of the hospital billing transaction audit history.
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 item stores the instant of data change on a hospital temporary transaction when a hospital billing transaction is in its temporary state.
6 | ITEM_CHANGE_LINE | INTEGER | No |
This item stores on which item line a hospital temporary transaction item changes. It is only set for multiple response item value changes. It is part of the hospital billing transaction audit history.
7 | OLD_VALUE_INTERNAL | VARCHAR | No |
This item stores the previous value of the changed hospital temporary transaction item when the hospital billing transaction is in its temporary state. It is part of the hospital billing transaction audit history.
8 | OLD_VALUE_EXTERNAL | VARCHAR | No |
This item stores the previous value, in an external format, of the changed hospital temporary transaction item when the hospital billing transaction is in its temporary state. It is part of the hospital billing transaction audit history.
9 | NEW_VALUE_INTERNAL | VARCHAR | No |
This item stores the new value of the changed hospital temporary transaction item when a hospital billing transaction is in its temporary state. It is part of the hospital billing transaction audit history.
10 | NEW_VALUE_EXTERNAL | VARCHAR | No |
This item stores the new value, in an external format, of the changed hospital temporary transaction item when the hospital billing transaction is in its temporary state. It is part of the hospital billing transaction audit history.
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.