Database views tables

The tables described in this section are used for database views.

PENDING_APPROVAL view
This view is used in the design of Pending Approvals report. This view provides information about the process ID of a process with pending work items and the associated status.
ROOTPROCESSVIEW view
This view is used in the design of Account operations and Account operations by individual report. The ROOTPROCESSVIEW captures all root processes, their IDs, types, and requestor information from PROCESS table. It is an SQL view defined on PROCESS table.
SUBPROCESSVIEW view
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.
SUSPENDED_USERS view
The SUSPENDED_USERS¹ view is used in the design of Suspended Users report. This view provides the completion time of latest user suspend operation for a requestee.
SUSPENDED_ACCOUNT_OPERATIONS view
The SUSPENDED_ACCOUNT_OPERATIONS¹ view is used in the design of Suspended Accounts report. This view provides information about suspended account operation for each requestee. It is an SQL view defined on PROCESS table.
PROCESS_VIEW view
The PROCESS_VIEW¹ view is used in the design of Operations Report, User Report, and Rejected Report. This view is defined on PROCESS table.

Parent topic: Database tables reference