|
Name |
Type |
Discontinued? |
|
1 |
APPEAL_GRV_ID |
NUMERIC |
No |
|
|
|
The unique identifier (.1 item) for the appeal/grievance 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 |
AUDIT_TRAIL_INSTANT_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
The date and time that the user changed the item. |
|
|
4 |
AUDIT_TRAIL_ITEM |
INTEGER |
No |
|
|
|
|
5 |
AUDIT_TRAIL_LINE |
INTEGER |
No |
|
|
|
The line that was changed. |
|
|
6 |
OLD_VALUE_INTERNAL |
VARCHAR |
No |
|
|
|
The value of the item prior to the change. |
|
|
7 |
NEW_VALUE_INTERNAL |
VARCHAR |
No |
|
|
|
The value the item was changed to. |
|
|
8 |
OLD_VALUE_EXTERNAL |
VARCHAR |
No |
|
|
|
This item stores the value of the item prior to the change. This column shows the translated external value as of when the the item was changed. |
|
|
9 |
NEW_VALUE_EXTERNAL |
VARCHAR |
No |
|
|
|
This item stores the value the item was changed to. This column shows the translated external value as of when the item was changed. |
|
|
10 |
AUDIT_TRAIL_USER_ID |
VARCHAR |
No |
|
|
|
The unique ID associated with the user record who made the change. This column is frequently used to link to the CLARITY_EMP table. |
|
|
11 |
AUDIT_TRAIL_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
12 |
CHANGED_DATA_ELEMENT |
VARCHAR |
No |
|
|
|
The name of the Clarity table and column corresponding to the changed data. |
|
|