AUDIT_MGMT_ACCESS_REQUEST table

AUDIT_MGMT_ACCESS_REQUEST table

The AUDIT_MGMT_ACCESS_REQUEST table contains information about account, group, person, and role provisioning that is submitted through the Administrative console, Self-service user interface, and Identity Service Center user interface. The AUDIT_MGMT_ACCESS_REQUEST table includes extra audit data that is related to rows in the AUDIT_EVENT table for which the ITIM_EVENT_CATEGORY column contains these values: PersonManagement, AccountManagement, AccessManagement, OrgRoleManagement, and AccessRequest.

Column name Column description Data type

EVENT_ID^* Identifier that is assigned to this event. References AUDIT_EVENT (ID). Numeric

WORKFLOW_PROCESS_ID^* Identifier of the workflow process to which this additional audit data is related. Numeric

ACTION^* The supported actions are ADD, MODIFY, CHANGE, DELETE, SUSPEND, RESTORE, TRANSFER, CHANGE_PASSWORD, ADDMEMBER, REMOVEMEMBER, and SELF_REGISTER. Character (25)

PERSON_NAME ^** Name of the person for whom the access request was submitted. Character (1000)

PERSON_DN ^** Distinguished name of the person for whom the access request was submitted. Character (1000)

ACCESS_CATALOG_ID ^** Access catalog identifier of the service, group, or role for which the access request was submitted. Numeric

ACCESS_CATALOG_NAME^** Access catalog name of the service, group, or role for which the access request was submitted. Character (1000)

ACCESS_CATALOG_DESCRIPTION^** Access catalog description of the service, group, or role for which the access request was submitted. Character (1000)

ACCESS_CATALOG_CATEGORY^** Access catalog description of the service, group, or role for which the access request was submitted. Character (1000)

ACCESS_CATALOG_ICON ^** URL of the access catalog icon of the service, group, or role for which the access request was submitted. Character (1000)

ACCESS_CATALOG_BADGE_1 ^** First access catalog badge of the service, group, or role for which the access request was submitted. Character (3000)

ACCESS_CATALOG_BADGE_2 ^** Second access catalog badge of the service, group, or role for which the access request was submitted. Character (3000)

ACCESS_CATALOG_BADGE_3 ^** Third access catalog badge of the service, group, or role for which the access request was submitted. Character (3000)

ACCESS_CATALOG_BADGE_4 ^** Fourth access catalog badge of the service, group, or role for which the access request was submitted. Character (3000)

ACCESS_CATALOG_BADGE_5 ^** Fifth access catalog badge of the service, group, or role for which the access request was submitted. Character (3000)

ACCESS_OBLIGATION_IDS^* List of obligation IDs separated by semicolons that identifies the obligations that must be fulfilled for the access request. Character (4000)

SERVICE_NAME Name of the service for which the account or access request was submitted. Character (1000)

STATUS^* Status of the access request. The STATUS contains one of the following values.

FULFILLED
NOT_FULFILLED
PENDING
Character (25)

COMPLETED_DATE^* Date and time when the access request is completed or canceled. Character (50)

^* Indicates the column is required and not null.
^** Indicates the column is null if the event category is not AccessRequest. The AUDIT_MGMT_ACCESS_REQUEST table contains multiple rows that have the same WORKFLOW_PROCESS_ID column value if there is more than one access associated with the corresponding request.
Parent topic: Access request management

Column name	Column description	Data type
EVENT_ID^*	Identifier that is assigned to this event. References AUDIT_EVENT (ID).	Numeric
WORKFLOW_PROCESS_ID^*	Identifier of the workflow process to which this additional audit data is related.	Numeric
ACTION^*	The supported actions are ADD, MODIFY, CHANGE, DELETE, SUSPEND, RESTORE, TRANSFER, CHANGE_PASSWORD, ADDMEMBER, REMOVEMEMBER, and SELF_REGISTER.	Character (25)
PERSON_NAME ^**	Name of the person for whom the access request was submitted.	Character (1000)
PERSON_DN ^**	Distinguished name of the person for whom the access request was submitted.	Character (1000)
ACCESS_CATALOG_ID ^**	Access catalog identifier of the service, group, or role for which the access request was submitted.	Numeric
ACCESS_CATALOG_NAME^**	Access catalog name of the service, group, or role for which the access request was submitted.	Character (1000)
ACCESS_CATALOG_DESCRIPTION^**	Access catalog description of the service, group, or role for which the access request was submitted.	Character (1000)
ACCESS_CATALOG_CATEGORY^**	Access catalog description of the service, group, or role for which the access request was submitted.	Character (1000)
ACCESS_CATALOG_ICON ^**	URL of the access catalog icon of the service, group, or role for which the access request was submitted.	Character (1000)
ACCESS_CATALOG_BADGE_1 ^**	First access catalog badge of the service, group, or role for which the access request was submitted.	Character (3000)
ACCESS_CATALOG_BADGE_2 ^**	Second access catalog badge of the service, group, or role for which the access request was submitted.	Character (3000)
ACCESS_CATALOG_BADGE_3 ^**	Third access catalog badge of the service, group, or role for which the access request was submitted.	Character (3000)
ACCESS_CATALOG_BADGE_4 ^**	Fourth access catalog badge of the service, group, or role for which the access request was submitted.	Character (3000)
ACCESS_CATALOG_BADGE_5 ^**	Fifth access catalog badge of the service, group, or role for which the access request was submitted.	Character (3000)
ACCESS_OBLIGATION_IDS^*	List of obligation IDs separated by semicolons that identifies the obligations that must be fulfilled for the access request.	Character (4000)
SERVICE_NAME	Name of the service for which the account or access request was submitted.	Character (1000)
STATUS^*	Status of the access request. The STATUS contains one of the following values. FULFILLED NOT_FULFILLED PENDING	Character (25)
COMPLETED_DATE^*	Date and time when the access request is completed or canceled.	Character (50)