Process choreographer provides the following predefined view for queries on activities. Only the columns that are relevant to V5.0-style processes are documented here.
Column name | Type | Comments |
---|---|---|
PIID | ID | Process instance ID. |
AIID | ID | Activity instance ID. |
PTID | ID | Process template ID. |
ATID | ID | Activity template ID. |
KIND | Integer | Kind of activity. Possible values:KIND_PROCESS_SUBFLOW KIND_PROCESS_BLOCK KIND_EMPTY KIND_SINK KIND_SOURCE KIND_ELEMENTAL KIND_FAULT KIND_PERSON KIND_EVENT |
RUN_MODE | Integer | Possible values: RUN_MODE_SYNCHRONOUS RUN_MODE_INTERRUPTIBLE RUN_MODE_ATOMIC_SPHERE RUN_MODE_CHAINED |
COMPLETED | Timestamp | The time the activity is completed. |
ACTIVATED | Timestamp | The time the activity is activated. |
FIRST_ACTIVATED | Timestamp | The time at which the activity was activated for the first time. |
STARTED | Timestamp | The time the activity is started. |
STATE | String | State of the activity. Possible values:STATE_INACTIVE STATE_READY STATE_RUNNING STATE_SKIPPED STATE_FINISHED STATE_FAILED STATE_TERMINATED STATE_CLAIMED STATE_TERMINATING STATE_FAILING STATE_WAITING STATE_EXPIRED STATE_STOPPED |
OWNER | String | Principal ID of the owner. |
DESCRIPTION | String | If the activity template description contains placeholders, this column contains the description of the activity instance with the placeholders resolved. |
TEMPLATE_NAME | String | Name of the associated activity template. |
TEMPLATE_DESCR | String | Description of the associated activity template. |