USERRECERT_ROLE table

The USERRECERT_ROLE1 table stores role membership 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 membership for a user in a particular role. This table references the USERRECERT_HISTORY table through a foreign key.

Column Name Description Data type
ID* A unique identifier for the role 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
ROLE_DN The DN of the role that is being recertified. Character (255)
ROLE_NAME The name of the role that is being recertified. Character (240)
ROLE_DESCRIPTION The description of the role that is being recertified. Character (500)
DECISION The decision submitted for this role. 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.

Parent topic: Recertification policy tables