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 (21)
KIND_RECEIVE (23)
KIND_REPLY (24)
KIND_THROW (25)
KIND_RETHROW (46)
KIND_TERMINATE (26)
KIND_WAIT (27)
KIND_COMPENSATE (29)
KIND_SEQUENCE (30)
KIND_EMPTY (3)
KIND_SWITCH (32)
KIND_WHILE (34)
KIND_PICK (36)
KIND_FLOW (38)
KIND_SCOPE (40)
KIND_SCRIPT (42)
KIND_STAFF (43)
KIND_ASSIGN (44)
KIND_CUSTOM (45)
KIND_FOR_EACH_PARALLEL (49)
KIND_FOR_EACH_SERIAL (47)

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 (1)
STATE_READY (2)
STATE_RUNNING (3)
STATE_PROCESSING_UNDO (14)
STATE_SKIPPED (4)
STATE_FINISHED (5)
STATE_FAILED (6)
STATE_TERMINATED (7)
STATE_CLAIMED (8)
STATE_TERMINATING (9)
STATE_FAILING (10)
STATE_WAITING (11)
STATE_EXPIRED (12)
STATE_STOPPED (13)

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. Possible values are:
TRUE
The activity is business relevant. You can view the activity status in Business Process Choreographer Explorer.
FALSE
The activity is not business relevant.
EXPIRES Timestamp The date and time when the activity is due to expire. If the activity has expired, the date and time when this event occurred.

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