CLARITY_HVR_SDFL

Description:

This table contains the audit history of the Soft delete/Record status (SDFL) flag of the verification records.

Primary Key

Column Name	Ordinal Position
VERIFY_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	VERIFY_ID	NUMERIC	No
	The unique ID of the verification record
2	LINE	INTEGER	No
	This column holds the line number corresponding to the line of the edit. Each edit's details (instant, user id and action) associated with the verification record will be stored on a separate line.
3	SDFL_EDIT_INSTANT	DATETIME (Attached)	No
	The instant the verification record was edited.
4	SDFL_EDIT_USER_ID	VARCHAR	No
	The unique ID of the user who edited the verification record.
5	SDFL_EDIT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	SDFL_EDIT_ACTION_C_NAME	VARCHAR	No
	The category value representing the action which the user performed on the verification record. This value indicated whether the user deleted or hid the record. May contain organization-specific values: No Category Entries: Soft Delete Undo Delete Hide Unhide