PROCESS_INSTANCE view

Use this predefined 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.
NAME String The name of the process instance.
STATE Integer The state of the process instance. Possible values are:

STATE_READY
STATE_RUNNING
STATE_FINISHED
STATE_COMPENSATING
STATE_INDOUBT
STATE_FAILED
STATE_TERMINATED
STATE_COMPENSATED
STATE_COMPENSATION_FAILED
STATE_TERMINATING
STATE_FAILING
STATE_SUSPENDED

CREATED Timestamp The time the process instance is created.
STARTED Timestamp The time the process instance started.
COMPLETED Timestamp The time the process instance completed.
PARENT_NAME String The name of the parent 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.
STARTER String The principal ID of the starter of the process instance.
DESCRIPTION String If the description of the process template contains placeholders, this column contains the description of the process instance with the placeholders resolved.
TEMPLATE_NAME String The name of the associated process template.
TEMPLATE_DESCR String Description of the associated process template.

Terms of use | | Broken links

Last updated: Tue Dec 06 04:14:40 2005

(c) Copyright IBM Corporation 2005.
This information center is powered by Eclipse technology (http://www.eclipse.org)