PROCESS_INSTANCE view: Business Process Choreographer database view

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

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

fault handling is applied.
False
Navigation of the process stops so that the process can be repaired.
Columns in the PROCESS_INSTANCE view
Column name Type Comments

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.

Database views for Business Process Choreographer

Column name	Type	Comments
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.