SUBPROCESSVIEW view

Edit online

This view is used in the design of Account operations and Account operations by individual report. This view provides information about the subprocesses that are initiated due to various root processes. These processes are in turn initiated for different operations in the IVIG system.

Table 1. `SUBPROCESSVIEW` view table
Column Name	Description	Data type
`ROOT_PROCESS_ID`	ID of the parent process initiated for an IVIG operation.	Numeric
`SUBMITTED`	Time that the subprocess was submitted.	Numeric
`COMPLETED`	Time that the subprocess is completed.	Numeric
`SUBJECT_PROFILE`	Profile name of the subject.	Character
`SUBJECT_SERVICE`	`ITIM` service name.	Character
`SUBJECT`	Process subject.	Character
`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
`TYPE`	Type of the subprocess. Values include: Account Add (`OA`) Account Change (`OC`) Account Password Change (`AP`) Suspend Account (`AS`) Restore Account (`AR`) Delete Account (`AD`)	Character
`REQUESTER`	The DN of the user who requested this process.	Character