USERRECERT_ACCOUNT table

Edit online

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.

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