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 IVIG 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.
|
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.
Note: 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 that is associated with the
corresponding request.