APPEAL_GRV_REC_STAT_HX

Description:

This table contains information about changes to the Chronicles record status/soft-delete flag (SDFL item) of the appeal/grievance record. Only records that have had their record status changed will be included in this table.

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	CM_PHY_OWNER_ID	VARCHAR	No
	The Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
4	SDFL_EDIT_INSTANT_DTTM	DATETIME (Attached)	No
	Stores the instant that the record status was changed
5	SDFL_EDIT_USER_ID	VARCHAR	No
	Stores the user who changed the record status
6	SDFL_EDIT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	SDFL_EDIT_ACTI_C_NAME	VARCHAR	No
	Stores the action that was applied to the record status May contain organization-specific values: No Category Entries: Soft Delete Undo Delete Hide Unhide