APPEAL_GRV_AUDIT_TRAIL
Description:
This table contains the audit trail of item value changes for an appeal/grievance record.

Primary Key
Column Name Ordinal Position
APPEAL_GRV_ID 1
LINE 2

Column Information
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_TYPE_C_NAME VARCHAR No
The type of change category ID this line in the audit trail is for.
May contain organization-specific values: No
Category Entries:
Item Value Changed
Attachment Added
Attachment Removed
4 DOCUMENT_ID VARCHAR No
The unique ID of the document attachment that was modified.