Use this predefined database view for queries on process instances.
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 (1) |
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. |
(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)