PROCESS table

Edit online

The PROCESS table stores all the pending, running, and historical requests submitted to the IBM Verify Identity Governance workflow. Each request is represented as a process.

Table 1. PROCESS table
Column Name Description Data type
ROOT_PROCESS_ID* The root process ID number. Numeric
ID* Process ID number. Primary key. Numeric
PARENT_ID Parent process ID number, if any. Numeric
PARENT_ACTIVITY_ID Parent activity ID number. Numeric
NAME Process name. Character (100)
TYPE* Process type code. Values include:
  • Access Request Batch Processing (AB)
  • User Data Change (UC)
  • User BU Change (UO)
  • Suspend User (US)
  • Restore User (UR)
  • Delete User (UD)
  • New User (UA)
  • Suspend Multiple Users (MS)
  • Restore Multiple Users (MR)
  • Delete Multiple Users (MD)
  • Account Add (AA)
  • Account Change (AC)
  • Account Password Change (AP)
  • Suspend Multiple Accounts (LS)
  • Restore Multiple Accounts (LR)
  • Delete Multiple Accounts (LD)
  • Change Password for Multiple Accounts (LP)
  • Suspend Account (AS)
  • Restore Account (AR)
  • Delete Account (AD)
  • Reconciliation (RC)
  • Add Provisioning Policy (PA)
  • Modify Provisioning Policy (PC)
  • Delete Provisioning Policy (PD)
  • Add Service Selection Policy (SA)
  • Modify Service Selection Policy (SC)
  • Delete Service Selection Policy (SD)
  • Add Dynamic Role (DA)
  • Modify Dynamic Role (DC)
  • Remove Dynamic Role (DD)
  • Account Add (OA)
  • Account Modify (OC)
  • Provision Ordered Accounts (OP)
  • Self-Register Person Operation (SR)
  • Multi Account Adopt Operation (LO)
  • Account Adopt Operation (AO)
  • Policy Enforcement for Service (PS)
  • Policy Enforcement for Account (EN)
  • Import or Export Policy Enforcement (PE)
  • Life Cycle Rule Execution (LC)
  • Custom Process (CP)
  • Entitlement Process (EP)
  • Recertification Policy (RP)1
  • Manual Service (SM)1
  • Multiple Account State Change (MA)1
  • Access Entitlement Request (EA)1
  • Access Entitlement Removal (ER)1
  • Human Resource Feed (HR)1
  • Add Separation of Duty Policy (SP)2
  • Delete Separation of Duty Policy (SX)2
  • Modify Separation of Duty Policy (SU)2
  • Evaluate Separation of Duty Policy (DR)2
  • Separation of Duty Policy Violation Evaluation (DE)2
  • Separation of Duty Policy Violation Approval (DP)2
  • Change Role Hierarchy (CR)2
  • Add Credential to Vault (VA)3
  • Check in (CI)3
  • Check out (CO)3
  • Handle an Expired Lease (EL)3
  • Process all Expired Leases (PL)3
  • Bulk Load Shared Accesses (BL)3
  • Enforce Policies for Service (SE)3
  • Connect credential to account (CC)4
 Character (2)
DEFINITION_ID* Process definition identifier. Character (2000)
REQUESTER_TYPE Requester type. Values include:

  • End User (U)

  • Workflow System (S)

  • Tenant Administrator (T)

  • Identity Manager System (P)

 Character (2)
REQUESTER DN of the requester. Character (2000)
REQUESTER_NAME Requesters name. Character (100)
DESCRIPTION Description of the process. Character (300)
PRIORITY Priority of the process. Numeric
SCHEDULED Scheduled start time for the process. Character (50)
STARTED Time that the process is started. Character (50)
COMPLETED Time that the process is completed. Character (50)
LASTMODIFIED Time that the process was last modified. Character (50)
SUBMITTED Time that the process was submitted. Character (50)
STATE Current state of the process. Values include:

  • Running (R)

  • Not Started (I)

  • Terminated (T)

  • Aborted (A)

  • Suspended (S)

  • Completed (C)

  • Bypassed (B)

 Character (1)
NOTIFY Specifies who is notified when a process is completed. You have the following choices:

  • NOTIFY_NONE (0)

  • NOTIFY_REQUESTOR (1)

  • NOTIFY_REQUESTEDFOR (2)

  • NOTIFY_BOTH (3)

 Numeric
REQUESTEE DN of the requestee. Character (2000)
REQUESTEE_NAME Name of the requestee. Character (100)
SUBJECT The subject of the process. Character (2000)
SUBJECT_PROFILE The data service object profile name that indicates the type of the subject. Character (100)
SUBJECT_SERVICE If the subject is an account, this field contains the name of the service associated with the account. Character (100)
SUBJECT_ACCESS_ID1 DN of the requested access. Character (2000)
SUBJECT_ACCESS_NAME1 Name of the requested access. Character (100)
COMMENTS Comments for the process. Character (200)
RESULT_SUMMARY Process result summary code. Values include:

  • Approved (AA)

  • Rejected (AR)

  • Submitted (RS)

  • Success (SS)

  • Timeout (ST)

  • Failed (SF)

  • Warning (SW)

  • Pending (PE)

  • Participant Resolution Failed (PF)

  • Escalated (ES)

  • Skipped (SK)

 Character (2)
RESULT_DETAIL Detailed information about the process result. Long Character
SHORT_DETAIL1 Short detailed information about the process result. Character (4000)
TENANT DN of the requesters tenant. Character (2000)

* Indicates the column is required and not null.

1 Indicates the column or the value is added in release 5.0.

2 Indicates the column or the value is added in release 5.1.

3 Indicates the column or the value is added in release 6.0.

4 Indicates the column or the value is added in release 6.0 Service Stream Enhancement.