USERRECERT_ACCOUNT table

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.
Column Name Description Data type

ID^* A unique identifier for the account 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_DN^* The DN of the account that is being recertified. Character (255)

ACCOUNT_UID^* The user ID of the account that is being recertified. Character (240)

SERVICE_DN^* The DN of the service for the account that is being recertified. Character (255)

SERVICE_NAME The name of the service for the account that is being recertified. Character (240)

SERVICE_DESCRIPTION The description of the service for the account that is being recertified. Character (240)

DECISION The decision submitted for this account. The following values are valid:
Approved (“AA”.
Rejected (“AR”.
No Decision Required (null.
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

Column Name	Description	Data type
ID^*	A unique identifier for the account 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_DN^*	The DN of the account that is being recertified.	Character (255)
ACCOUNT_UID^*	The user ID of the account that is being recertified.	Character (240)
SERVICE_DN^*	The DN of the service for the account that is being recertified.	Character (255)
SERVICE_NAME	The name of the service for the account that is being recertified.	Character (240)
SERVICE_DESCRIPTION	The description of the service for the account that is being recertified.	Character (240)
DECISION	The decision submitted for this account. The following values are valid: Approved (“AA”. Rejected (“AR”. No Decision Required (null.	Character (2)