This topic applies only to the IBM Business Process Manager Advanced configuration.

PROCESS_INSTANCE view

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

Table 1. Columns in the PROCESS_INSTANCE view
Column name	Type	Comments
PTID	ID	The process template ID.
PIID	ID	The process instance ID.
COMPLETED	Timestamp	The time the process instance completed.
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 instance is created.
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 either in Integration Designer, or by using the Business Flow Manager EJB API.
DESCRIPTION	String	If the description of the process template contains placeholders, this column contains the description of the process instance with the placeholders resolved.
IS_MIGRATED	Boolean	Specifies whether the process instance has been migrated from an older version of the process. If this attribute is set to `TRUE`, the process instance has been migrated.
NAME	String	The name of the process instance.
PARENT_NAME	String	The name of the parent process instance.
PARENT_PIID	ID	The ID of the parent process instance.
RESUMES	Timestamp	The time when the process instance is to be resumed automatically.
STARTER	String	The principal ID of the starter of the process instance.
STARTED	Timestamp	The time the process instance started.
STATE	Integer	The state of the process instance. Possible values are: STATE_READY (1) STATE_RUNNING (2) STATE_FINISHED (3) STATE_COMPENSATING (4) STATE_INDOUBT (10) STATE_FAILED (5) STATE_TERMINATED (6) STATE_COMPENSATED (7) STATE_COMPENSATION_FAILED (12) STATE_TERMINATING (8) STATE_FAILING (9) STATE_SUSPENDED (11)
TEMPLATE_DESCR	String	Description of the associated process template.
TEMPLATE_NAME	String	The name of the associated process template.
TOP_LEVEL_PIID	ID	The process instance ID of the top-level process instance. If there is no top-level process instance, this is the process instance ID of the current process instance.
TOP_LEVEL_NAME	String	The name of the top-level process instance. If there is no top-level process instance, this is the name of the current process instance.