USERRECERT_GROUP table

The USERRECERT_GROUP¹ table stores account recertification audit information for user recertification policies. This table is used by the User Recertification History Report. Each row in the table represents the approval or rejection of a group on a user account during user recertification. This table references the USERRECERT_HISTORY and USERRECERT_ACCOUNT tables through foreign keys.

Header	Header	Header
ID*	A unique identifier for the group entry in this user recertification approval. Primary key.	Numeric
RECERT_ID*	The unique identifier of this user recertification approval. This field is a foreign key reference to the USERRECERT_HISTORY table ID column.	Numeric
ACCOUNT_ID*	The unique identifier of the account entry in the recertification approval. This field is a foreign key reference to the USERECERT_ACCOUNT table ID column.	Numeric
GROUP_DN*	The DN of the group that is being recertified.	Character (500)
GROUP_NAME	The name of the group that is being recertified.	Character (240)
GROUP_DESCRIPTION	The description of the group that is being recertified.	Character (500)
DECISION	The decision submitted for this group. The following values are valid: Approved (“AA”) Rejected (“AR”)	Character (2)

^* Indicates the column is required and not null.

¹ Indicates the column or the value is added in release 5.1.

Parent topic: Recertification policy tables