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