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 Pending Note Edit Note Signed Note Deleted Note Cosigned Note Undeleted Note Cosign Removed
4	DOCUMENT_ID	VARCHAR	No
	The unique ID of the document attachment that was modified.