|
Field
|
Type
|
Description
|
|
PROCESS_TEMPLATE_ID
|
NUMBER NOT NULL
|
Template ID of the process
|
|
PROCESS_INSTANCE_ID1
|
NUMBER NOT NULL
|
Instance number of the process
|
|
WORKSTEP_NAMEb
|
VARCHAR2(32) NOT NULL
|
Name of the workstep2
|
|
PERFORMER
|
VARCHAR2(64)
|
Name of the performer of this workstep
|
|
GROUP_TYPE
|
CHAR(3)
|
How the actual performer of this workstep is decided, for example ALL, ANY, or NONE.
|
|
LOOPCOUNTER
|
NUMBER
|
The number of times this workstep runs.
|
|
STATUS
|
CHAR(20)
|
Status of the workstep
|
|
PRIORITY
|
CHAR(10)
|
User's preferred choice of priority (restrict priority values to Low|Medium|High|Critical)
|
|
ESTIMATED_DURATION
|
NUMBER
|
Estimated time in seconds to complete the workstep
|
|
START_TIME
|
DATE
|
Starting time of the workstep
|
|
END_TIME
|
DATE
|
Time when the workstep ends
|
|
TYPE
|
VARCHAR2(15)
|
The type of the workstep
|
|
WAIT_TIME
|
NUMBER
|
Summation of time from workitem creation till the opening of workitem by end user for the workstep
|
|
WORK_TIME
|
NUMBER
|
Summation of time from opening of workitem till completion of the same for the workstep
|
|
TOTAL_COST
|
NUMBER
|
Summation of cost of performing workitem for the workstep
|
|
DUE_DATE
|
TIMESTAMP
|
The date on which the workstep is due
|
|
DURATION
|
NUMBER
|
The duration of the workstep
|
|
INLINEBLOCK_NAME
|
VARCHAR2(32)
|
The inline subprocess name to which this worksitep belongs to
|
|
MONITOR_STEP
|
NUMBER(1)
|
Informs if this is monitoring workstep
|