AUDIT_MGMT_PARTICIPANT table

AUDIT_MGMT_PARTICIPANT table

The AUDIT_MGMT_PARTICIPANT table contains information about participants of manual activities. It includes extra audit data that is related to rows in the AUDIT_EVENT table for which the ITIM_EVENT_CATEGORY column contains the value ManualActivity. The AUDIT_MGMT_PARTICIPANT table contains the following columns.

Column name Column description Data type

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

ROOT_WORKFLOW_PROCESS_ID^* Identifier of the root workflow process for the manual activity to which the participant is assigned. Numeric

WORKFLOW_PROCESS_ID^* Identifier of the workflow process for the manual activity to which the participant is assigned. Numeric

ACTIVITY_ID^* Identifier of the activity. References AUDIT_MGMT_ACTIVITY (ID). Numeric

WORKITEM_ID^* Identifier of the work item that represents the current participant assignments and the due date for the manual activity. Numeric

PERSON_NAME Name of the person who is a participant of the manual activity. Character (1000)

PERSON_DN Distinguished name of the person who is a participant of the manual activity. Character (1000)

ACCOUNT_USERID User ID of the IBM Security Identity Manager account that is a participant of the manual activity. Character (1000)

ACCOUNT_DN Distinguished name of the IBM Security Identity Manager that is a participant of the manual activity. Character (1000)

STATUS^* Status of the assignment for the manual activity that is assigned to the participant.

CANCELED
COMPLETED
COMPLETED_OTHER
ESCALATED
PENDING
SKIPPED
TIMED_OUT
Character (25)

^* Indicates the column is required and not null. The AUDIT_MGMT_PARTICIPANT table contains multiple rows that have the same ACTIVITY_ID column value if there is more than one participant for the corresponding activity.The rows for a specific ACTIVITY_ID might change as the manual activity changes from one state to another:

Initially the rows represent the original participants for the manual activity.
If the manual activity escalates, the STATUS column for the original participant rows is updated to ESCALATED. New rows that represent the escalation participants are added with the STATUS column set to PENDING.
If a participant completes the manual activity, the STATUS column is updated to COMPLETED. Other participants for which the STATUS was PENDING, are updated to COMPLETED_OTHER.
If the manual activity is canceled or times out, the rows for the participants for which the STATUS is PENDING is updated to CANCELED or TIMED_OUT.

Parent topic: Create manual activity event

Column name	Column description	Data type
EVENT_ID^*	Identifier that is assigned to this event. References AUDIT_EVENT (ID).	Numeric
ROOT_WORKFLOW_PROCESS_ID^*	Identifier of the root workflow process for the manual activity to which the participant is assigned.	Numeric
WORKFLOW_PROCESS_ID^*	Identifier of the workflow process for the manual activity to which the participant is assigned.	Numeric
ACTIVITY_ID^*	Identifier of the activity. References AUDIT_MGMT_ACTIVITY (ID).	Numeric
WORKITEM_ID^*	Identifier of the work item that represents the current participant assignments and the due date for the manual activity.	Numeric
PERSON_NAME	Name of the person who is a participant of the manual activity.	Character (1000)
PERSON_DN	Distinguished name of the person who is a participant of the manual activity.	Character (1000)
ACCOUNT_USERID	User ID of the IBM Security Identity Manager account that is a participant of the manual activity.	Character (1000)
ACCOUNT_DN	Distinguished name of the IBM Security Identity Manager that is a participant of the manual activity.	Character (1000)
STATUS^*	Status of the assignment for the manual activity that is assigned to the participant. CANCELED COMPLETED COMPLETED_OTHER ESCALATED PENDING SKIPPED TIMED_OUT	Character (25)