Use this predefined database view for queries on activities.
Column name | Type | Comments |
---|---|---|
PIID | ID | The process instance ID. |
AIID | ID | The activity instance ID. |
PTID | ID | The process template ID. |
ATID | ID | The activity template ID. |
KIND | Integer | The kind of activity. Possible values are: KIND_INVOKE |
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 | Integer | The state of the activity. Possible values
are: STATE_INACTIVE |
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. |
BUSINESS_RELEVANCE | Boolean | Specifies whether the activity is business
relevant. The attribute affects logging to the audit trail. Possible values
are:
|
Last updated: Tue Feb 21 17:21:50 2006
(c) Copyright IBM Corporation 2005.
This information center is powered by Eclipse technology (http://www.eclipse.org)