PROCESSLOG table

PROCESSLOG table

The PROCESSLOG table maintains a record of audit events associated with a process.
Column Name Description Data type

ID^* Log ID number. Primary key. Numeric

PROCESS_ID ID of the process associated with the log. Reference PROCESS (ID). Numeric

ACTIVITY_ID ID of the activity associated with the log. Numeric

CREATED Time that the log was created. Character (50)

EVENTTYPE^* Log event type code. Values include:
Activity Created (AC.
Process State Changed (PS.
Old Value (OV.
Mail Notification (MN.
Process Initial Data (PI.
Process User Changed Data (PC.
Process Timeout (PT.
Process Escalation Participant Resolution Failed (PP.
Activity Timeout (AT.
Activity Escalation Timeout (AE.
Activity State Changed (AS.
Activity Data (AD.
Activity Assignment Changed (AA.
Manual Activity Performed By (CM.
Activity Participant Resolution Failed (AP.
Activity Escalation Participant Resolution Failed (AX.
Password Pickup (PD.
Message Log Information (IF.
Character (2)

OLD_PARTICIPANT_TYPE Old participant type for the assignment change event. Values include:
User (U.
Person (P.
Role (R.
System Administrator (SA.
Supervisor (SU.
Sponsor (SP.
Service Owner (SO.
System (WS.
Requestor (RR.
Requestee (RE.
Domain Administrator (DA.
Custom Defined Participant (CM.
Access Owner (AO.
Role Owner (RO.
ITIM Group (SR.
Character (2)

OLD_PARTICIPANT_ID Old participant ID for the assignment change event. Character (2000)

NEW_PARTICIPANT_TYPE New participant type for the assignment change event. Values include:
User (U.
Person (P.
Role (R.
System Administrator (SA.
Supervisor (SU.
Sponsor (SP.
Service Owner (SO.
System (WS.
Requestor (RR.
Requestee (RE.
Domain Administrator (DA.
Custom Defined Participant (CM.
Access Owner (AO.
Role Owner (RO.
ITIM Group (SR.
Character (2)

NEW_PARTICIPANT_ID New participant ID for the assignment change event. Character (2000)

REQUESTOR_TYPE Requester type for any user-related event. Values include:
End User (U.
Workflow System (S.
Tenant Administrator (T.
Security Identity Manager System (P.
Character (2)

REQUESTOR Requester name for any user-related event. Character (2000)

REQUESTOR_DN The DN of theSecurity Identity Manager Service account requester for any user-related event. Character (1000)

OLD_STATE Old state for a state change event. Values include:
Running (R.
Not Started (I.
Terminated (T.
Aborted (A.
Suspended (S.
Completed (C.
Bypassed (B.
Character (1)

NEW_STATE New state for a state change event. Values include:
Running (R.
Terminated (T.
Aborted (A.
Suspended (S.
Completed (C.
Bypassed (B.
Character (1)

DATA_ID Data ID for a data change event. Character (100)

NEW_DATA Data value for a data change event. Long Character

SMALL_NEW_DATA¹ Small data value a data change event. Character (4000)

^* Indicates the column is required and not null.
¹ Indicates the column or the value is added in release 5.0.
Parent topic: Workflow tables

Column Name	Description	Data type
ID^*	Log ID number. Primary key.	Numeric
PROCESS_ID	ID of the process associated with the log. Reference PROCESS (ID).	Numeric
ACTIVITY_ID	ID of the activity associated with the log.	Numeric
CREATED	Time that the log was created.	Character (50)
EVENTTYPE^*	Log event type code. Values include: Activity Created (AC. Process State Changed (PS. Old Value (OV. Mail Notification (MN. Process Initial Data (PI. Process User Changed Data (PC. Process Timeout (PT. Process Escalation Participant Resolution Failed (PP. Activity Timeout (AT. Activity Escalation Timeout (AE. Activity State Changed (AS. Activity Data (AD. Activity Assignment Changed (AA. Manual Activity Performed By (CM. Activity Participant Resolution Failed (AP. Activity Escalation Participant Resolution Failed (AX. Password Pickup (PD. Message Log Information (IF.	Character (2)
OLD_PARTICIPANT_TYPE	Old participant type for the assignment change event. Values include: User (U. Person (P. Role (R. System Administrator (SA. Supervisor (SU. Sponsor (SP. Service Owner (SO. System (WS. Requestor (RR. Requestee (RE. Domain Administrator (DA. Custom Defined Participant (CM. Access Owner (AO. Role Owner (RO. ITIM Group (SR.	Character (2)
OLD_PARTICIPANT_ID	Old participant ID for the assignment change event.	Character (2000)
NEW_PARTICIPANT_TYPE	New participant type for the assignment change event. Values include: User (U. Person (P. Role (R. System Administrator (SA. Supervisor (SU. Sponsor (SP. Service Owner (SO. System (WS. Requestor (RR. Requestee (RE. Domain Administrator (DA. Custom Defined Participant (CM. Access Owner (AO. Role Owner (RO. ITIM Group (SR.	Character (2)
NEW_PARTICIPANT_ID	New participant ID for the assignment change event.	Character (2000)
REQUESTOR_TYPE	Requester type for any user-related event. Values include: End User (U. Workflow System (S. Tenant Administrator (T. Security Identity Manager System (P.	Character (2)
REQUESTOR	Requester name for any user-related event.	Character (2000)
REQUESTOR_DN	The DN of theSecurity Identity Manager Service account requester for any user-related event.	Character (1000)
OLD_STATE	Old state for a state change event. Values include: Running (R. Not Started (I. Terminated (T. Aborted (A. Suspended (S. Completed (C. Bypassed (B.	Character (1)
NEW_STATE	New state for a state change event. Values include: Running (R. Terminated (T. Aborted (A. Suspended (S. Completed (C. Bypassed (B.	Character (1)
DATA_ID	Data ID for a data change event.	Character (100)
NEW_DATA	Data value for a data change event.	Long Character
SMALL_NEW_DATA¹	Small data value a data change event.	Character (4000)