Recertification policy tables

The tables described in this section are for recertification policy information.

RECERTIFICATIONLOG table
The RECERTIFICATIONLOG¹ table stores recertification policy audit information for account and access recertification policies. This table is used by the Recertification History report. Each row in the table represents the recertification of a single account or access.
USERRECERT_HISTORY table
The USERRECERT_HISTORY¹ table stores recertification policy audit information for user recertification policies. This table is used by the User Recertification History Report. Each row in the table represents the completion of a user recertification policy approval. Specific resources and decisions that were included in the approval are recorded and described in the following additional tables.
USERRECERT_ROLE table
The USERRECERT_ROLE¹ 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.
USERRECERT_ACCOUNT table
The USERRECERT_ACCOUNT¹ 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 an account owned by the user during recertification. This table references the USERRECERT_HISTORY table through a foreign key.
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.

Parent topic: Database tables reference