|
Field
|
Type
|
Description
|
|
PROCESS_TEMPLATE_ID
|
NUMBER NOT NULL
|
Template ID of the process1
|
|
PROCESS_INSTANCE_ID2
|
NUMBER NOT NULL
|
Instance number of the process
|
|
PROCESS_INSTANCE_NAME
|
VARCHAR2(256) NOT NULL
|
Name of the process instance
|
|
CREATOR
|
CHAR(32) NOT NULL
|
Name of the creator of this process instance
|
|
STATUS
|
CHAR(20) NOT NULL
|
Status of this process instance, for example PI_CREATED
|
|
PRIORITY
|
CHAR(10)
|
The priority of this process (restrict priority values to Low|Medium|High|Critical)
|
|
ESTIMATED_DURATION
|
NUMBER
|
The estimated number of seconds to complete the process instance
|
|
START_TIME
|
TIMESTAMP
|
Starting time of this process instance
|
|
END_TIME
|
TIMESTAMP
|
Time when this process instance ends
|
|
WAIT_TIME
|
NUMBER
|
Summation of time from workitem creation till the opening of workitem by end user for the process instance
|
|
WORK_TIME
|
NUMBER
|
Summation of time from opening of workitem till completion of the same for the process instance
|
|
TOTAL_COST
|
NUMBER
|
Summation of cost of performing workitem for the process instance
|
|
DUE_DATE
|
TIMESTAMP
|
The date on which the process instance is due
|
|
DURATION
|
DURATION
|
The duration of the process instance
|