V_EHI_AUDIT_RFL

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

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
REFERRAL_ID | 1 |
LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | REFERRAL_ID | NUMERIC | No |
The ID for the referral 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 | HX_USER_ID | VARCHAR | No |
The user tied to the audited action on the referral.
4 | HX_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
5 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple values associated with a specific group of data within this record.
6 | ACTION_UTC_DTTM | DATETIME (UTC) | No |
Store the UTC instant when an action took place.
7 | ITEM_CHANGE_LN | INTEGER | No |
The item line that was added or changed.
8 | ITEM_CHANGE_POS | INTEGER | No |
The item position that was added or changed.
9 | OLD_VALUE_INTERNAL | VARCHAR | No |
The previously stored value for an item change, as defined by the item changed value in RFL_HX_ITEM_CHANGE.ITEM_CHANGE. If you use IntraConnect, this is the CID of the previously stored value.
10 | OLD_VALUE_EXTERNAL | VARCHAR | No |
The previously stored value for an item change, as defined by the item changed value in RFL_HX_ITEM_CHANGE.ITEM_CHANGE, in an external format. This column shows the translated external value as of when the column was last extracted.
11 | NEW_VALUE_INTERNAL | VARCHAR | No |
The new stored value for an item change, as defined by the item changed value in RFL_HX_ITEM_CHANGE.ITEM_CHANGE. If you use IntraConnect, this is the CID of the new stored value.
12 | NEW_VALUE_EXTERNAL | VARCHAR | No |
The new stored value for an item change, as defined by the item changed value in RFL_HX_ITEM_CHANGE.ITEM_CHANGE, in an external format. This column shows the translated external value as of when the column was last extracted.
13 | 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