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

Meta data information tables

Business Process Server also creates a set of tables for storing meta data information about process instances and worksteps. These tables are defined as follows:

PROCESSDATAINFO table

The PROCESSDATAINFO table is defined as follows:
Field
Type
Description
PROCESS_TEMPLATE_ID1
NUMBER NOT NULL
The unique template ID for a process
DATASLOT_NAME2
VARCHAR2(32) NOT NULL
Name of the dataslot presented in Designer
DATASLOT_TYPE
NUMBER NOT NULL
JDBC type represented as an integer value
DATASLOT_SIZE
NUMBER
Size of string
BIZLOGIC_DATASLOT_TYPE
VARCHAR2(16) NOT NULL
The BP Server datatype
BIZMANAGE_ACCESS_FLAG
CHAR(1)
Access permission for the Management module of Business Process Portal
SCALE
NUMBER
The scale if there is a decimal dataslot
GLOBAL_FLAG
CHAR(1)
Where the dataslot is either global or not
LABEL
VARCHAR2(32)
The default size is 128 characters. If you expect the dataslot label size to exceed this number, then you may alter the database schema for this field label.
BIZSITE_ACCESS_FLAG
CHAR(1)
Not used currently.
MONITOR_ID
NUMBER(1)
Informs if this dataslot is the External Instance ID for monitoring worksteps
1 Table primary key

2 Table primary key

PROCESSWORKSTEPINFO table

The PROCESSWORKSTEPINFO table is defined as follows:
Field
Type
Description
PROCESS_TEMPLATE_ID1
NUMBER NOT NULL
Unique template ID for a process
WORKSTEP_NAME2
VARCHAR2(32) NOT NULL
Name of the workstep
WORKSTEP_TYPE
CHAR(15) NOT NULL
Type of workstep, for example: nestedWS
MILESTONE
VARCHAR2(256)
The milestone workstep information
WORKSTEP_ID
NUMBER
The ID of the workstep
MILESTONE_NAME
VARCHAR2(64)
The name of the milestone
MILESTONE_DESC
VARCHAR2(512)
The description of the milestone
PHASE
VARCHAR2(64)
The name of the phase of the workstep
PHASE_ID
NUMBER
The ID of the phase of the workstep
1 Table primary key

2 Table primary key

SUBPROCESSINFO table

Business Process Server uses the SUBPROCESSINFO table1 to store process and subprocess relationships. This table is defined as follows:
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
PARENT_PROCESS_INSTANCE_IDc
NUMBER NOT NULL
Instance ID of the parent process of this subprocess
PARENT_WORKSTEP_NAMEc
VARCHAR2(32) NOT NULL
Name of the parent workstep, which started this subprocess
PARENT_WORKSTEP_LOOPCOUNTER
NUMBER
The loop counter of the parent subprocess workstep
1 Table primary key

1 Table constraint: SUB_PROCESS_PKEY