Values for columns in the AUDIT_EVENT table that is used by access request management

Edit online

The AUDIT_EVENT table is common for all audit events. However, the value for some columns is different depending on the event. See the specific event for the column values.

Table 1. AUDIT_EVENT table for access request management
Column Name Column Description Data type
ID* ID by which this event is identified. Primary key. Numeric
ITIM_EVENT_CATEGORY* AccessRequest. Character (50)
ACTION* ADD Character (25)
WORKFLOW_PROCESS_ID The identifier of the request. Numeric
INITIATOR_NAME The user ID of the ITIM account that submitted the request. Character (1000)
INITIATOR_DN The distinguished name of the ITIM account that submitted the request. Character (1000)
INITIATOR_TYPE

PERSON - Indicates that the request was submitted by a person.

SYSTEM - Indicates that the request was submitted by the IVIG system.

 Character (50)
INITIATOR_PERSON_DN Distinguished name of the person who submitted the request. Character (1000)
INITIATOR_PERSON_NAME Name of the person who submitted the request. Character (1000)
RESULT_SUMMARY The status of the request. The RESULT_SUMMARY contains one of the following values.
  • 0 - PENDING
  • 1 - NOT_FULFILLED
  • 2 - PARTIALLY_FULFILLED
  • 3 - FULFILLED
 Character (25)
TIMESTAMP* The time stamp for when the request was submitted. Character (50)
COMMENTS The justification for the request. Character (1000)
TIMESTAMP2 The time stamp for when the request was completed. Character (50)

* Indicates the column is required and not null.