Process choreographer provides the following predefined view for queries on process instances. Only the columns that are relevant to V5.0-style processes are documented here.
Column name | Type | Comments |
---|---|---|
PTID | ID | Process template ID. |
PIID | ID | Process instance ID. |
NAME | String | Name of the process instance. |
STATE | Integer | State of the process instance. Possible
values: STATE_READY STATE_RUNNING STATE_FINISHED STATE_COMPENSATING STATE_FAILED STATE_TERMINATED STATE_COMPENSATED STATE_TERMINATING STATE_FAILING |
CREATED | Timestamp | The time the process instance is created. |
STARTED | Timestamp | The time the process instance is started. |
COMPLETED | Timestamp | The time the process instance is completed. |
PARENT_NAME | String | The name of the parent process instance. |
TOP_LEVEL_NAME | String | The name of the top-level process instance. This name is the current process instance if there is no top level. |
STARTER | String | Principal ID of the starter. |
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. |
TEMPLATE_CATEGORY | String | The category to which the associated process template belongs. |