ACTIVITY view

Use this predefined database view for queries on activities.

Table 1. Columns in the ACTIVITY view
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
KIND_RECEIVE
KIND_REPLY
KIND_THROW
KIND_RETHROW
KIND_TERMINATE
KIND_WAIT
KIND_COMPENSATE
KIND_SEQUENCE
KIND_EMPTY
KIND_SWITCH
KIND_WHILE
KIND_PICK
KIND_FLOW
KIND_SCOPE
KIND_SCRIPT
KIND_STAFF
KIND_ASSIGN
KIND_CUSTOM

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
STATE_READY
STATE_RUNNING
STATE_PROCESSING_UNDO
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.
BUSINESS_RELEVANCE Boolean Specifies whether the activity is business relevant. The attribute affects logging to the audit trail. Possible values are:
TRUE
The activity is business relevant and it is audited.
FALSE
The activity is not business relevant and it is not audited.

Terms of use |

Last updated: Thu Apr 27 14:54:56 2006

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