IBM BPM, V8.0.1, All platforms > Reference > Database views for Business Process Choreographer

PROCESS_TEMPLATE view

Use this predefined Business Process Choreographer database view for queries on process templates.

microflows in the process template; either an existing compensation sphere is joined or a compensation sphere is created.

Possible values are:

COMP_SPHERE_REQUIRED (2)
COMP_SPHERE_SUPPORTS (4)

Columns in the PROCESS_TEMPLATE view.

This table defines the parameters of the Business Process Choreographer database view.

Column name	Type	Comments
CONTINUE_ON_ERROR	Boolean	Specifies what happens to a process if an unexpected fault is raised and a fault handler is not defined for that fault. Possible values are: True Standard fault handling is applied. False Navigation of the process stops so that the process can be repaired.
CREATED	Timestamp	The time the process template is created in the database.
CUSTOM_TEXT1 through CUSTOM_TEXT8	String	Inline custom properties that can be set for a BPEL process. The values of these fields can be set in Integration Designer.
DESCRIPTION	String	Description of the process template.
DISPLAY_NAME	String	The descriptive name of the process.
EXECUTION_MODE	Integer	Specifies how process instances that are derived from this process template can be run. Possible values are: EXECUTION_MODE_MICROFLOW (1) EXECUTION_MODE_LONG_RUNNING (2)
IS_TIP	Boolean	Indicates whether the process template was deployed from a Process Center Tip.
NAME	String	The name of the process template.
STATE	Integer	Specifies whether the process template is available to create process instances. Possible values are: STATE_STARTED (1) STATE_STOPPED (2)
TARGET_NAMESPACE	String	The target namespace of the process template.
VERSION	String	User-defined version.

Database views for Business Process Choreographer

Additional columns in the PROCESS_TEMPLATE view. This table shows the additional columns that are set for BPEL processes that were deployed using the Process Center.

Column name	Type	Comments