Process template tables

The PROCESSTEMPLATE table¹ 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 table² 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