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