Try OpenEdge Now
skip to main content
Application Developer's Guide
Understanding the Business Process Server repository : Schema for process tables : Work item tables
 

Work item tables

The WORKITEM table fields, which stores workitems, is defined as follows:

WORKITEM table fields

The WORKITEM table1 is defined as follows:
Field
Type
Description
WORKITEM_ID1
NUMBER NOT NULL
Identity of the work item
PROCESS_TEMPLATE_ID2
NUMBER NOT NULL
Template ID of the process
PROCESS_INSTANCE_ID3
NUMBER NOT NULL
Instance number of the process
WORKSTEP_NAME4
VARCHAR2(32) NOT NULL
Name of the workstep
PERFORMER
VARCHAR2(64) NOT NULL
Name of the performer of this work item
LOOPCOUNTER5
NUMBER NOT NULL
The number of times this workstep runs.
STATUS
CHAR(20)
Status of the work item/performer
PRIORITY
CHAR(10)
Priority of the work item
ESTIMATED_DURATION
NUMBER
Estimated time in seconds to complete the work item
START_TIME
DATE
Starting time of the work item
END_TIME
DATE
Time when the work item ends
1 Table primary key

2 CREATE INDEX IXWORKITEM_STATUS ON work item

3 CREATE INDEX ixworkitem ON work item

4 CREATE INDEX ixworkitem ON work item

5 CREATE INDEX IXWORKITEM_STATUS ON work item

Note: If infopad requires higher dimensions, then the higher dimension index columns is also generated.
1 Table constraint: WORKITEM_PKEY