This topic applies only to the IBM Business Automation Workflow Advanced configuration.

PROCESS_TEMPLATE view

Edit online
Draft comment:
This topic only applies to BAW, and is located in the BAW repository. Last updated on 2025-03-13 12:15
Use this predefined Business Process Choreographer database view for queries on process templates.
Table 1. Columns in the PROCESS_TEMPLATE view.

This table defines the parameters of the Business Process Choreographer database view.
Column name Type Comments
PTID ID The process template ID.
VALID_FROM Timestamp The time from when the process template can be instantiated.
APPLICATION_NAME String The name of the enterprise application to which the process template belongs.
CAN_RUN_SYNC Boolean Specifies whether a process can be invoked by the call method.
CAN_RUN_INTERRUP Boolean Specifies whether a process can be invoked by the initiate or sendMessage methods.
COMP_SPHERE Integer Specifies the compensation behavior of instances of 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)
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 Workflow 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.
Table 2. Additional columns in the PROCESS_TEMPLATE view. This table shows the additional columns that are set for BPEL processes that were deployed using the Workflow Center.
Column name Type Comments
PROCESS_APP_ACRONYM String The acronym of the process application if the root container is a process application.
PROCESS_APP_NAME String The name of the process application if the root container is a process application.
SNAPSHOT_ID String The snapshot ID of the root container, which can be either a process application or a toolkit.
SNAPSHOT_NAME String The snapshot name of the root container.
TOOLKIT_SNAPSHOT_ID String The snapshot ID of the toolkit that contains the process if the process is contained in a toolkit.
TOOLKIT_SNAPSHOT_NAME String The snapshot name of the toolkit that contains the process if the process is contained in a toolkit.
TOOLKIT_ACRONYM String The acronym of the toolkit that contains the process if the process is contained in a toolkit.
TOOLKIT_NAME String The name of the toolkit that contains the process if the process is contained in a toolkit.
TOP_LEVEL_TOOLKIT_ACRONYM String The acronym of the toolkit if the root container is a toolkit.
TOP_LEVEL_TOOLKIT_NAME String The name of the toolkit if the root container is a toolkit.
TRACK_NAME String The name of the track of the root container.