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

Process template tables

Business Process Server uses two tables, PROCESSTEMPLATE and PROCESSXML, to store process templates.

PROCESSTEMPLATE table

The PROCESSTEMPLATE table1 stores information about process templates, including its ID, name, manager, and table name for dataslots. The following table presents the definition of the PROCESSTEMPLATE table fields.
Field
Type
Description
PROCESS_TEMPLATE_ID
NUMBER NOT NULL
Unique template ID for a process
PROCESS_TEMPLATE_NAME
VARCHAR2(64) NOT NULL
Unique process template name
PROCESS_MANAGER
VARCHAR2(32)
Manager of the process
INSTANCE_DATA_TABLE_NAME
VARCHAR2(30)
None
GLOBAL_DATA_TABLE_NAME
VARCHAR2(30)
None
PROCESS_INSTANCE_COUNTER
NUMBER
The process instance counter
STATUS
CHAR(20) NOT NULL
Process template state such as P_CREATED, P_INSTALLED, or P_SUSPENDED.
APP_NAME
VARCHAR2(64)
Application name that is common across all versions of an application
PROCESS_TYPE
NUMBER(1)
Type of process – business process, system process
MONITOR_DS_NAME
VARCHAR2(32)
The dataslot name of the external instance ID for a process containing a monitoring workstep

PROCESSXML table

The PROCESSXML table2 stores XML files for all created Business Process Server application templates. The following table presents the definition of the PROCESSXML table fields.
Field
Type
Description
PROCESS_TEMPLATE_ID
NUMBER NOT NULL
Unique template ID for a process
DESCRIPTION
VARCHAR2(1000)
Process/application description
XML
LONG
Process template in XML format
* Dataslot tables for a process template

1 Table constraint: PROCESS_TEMPLATE_PKEY

2 Table constraint: PROCESS_XML_PKEY