|
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 |
|
|