USERRECERT_GROUP table

Edit online

The USERRECERT_GROUP1 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.

Table 1. USERRECERT_GROUP table
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.

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