This topic applies only to the IBM Business Process Manager Advanced configuration.

ACTIVITY view

Use this predefined Business Process Choreographer 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.
SIID	ID	The scope instance ID.
STID	ID	The ID of the scope of the template.
EHIID	ID	The ID of the event handler instance if this activity is part of an event handler.
ENCLOSING_FEIID	ID	The ID of the enclosing forEach activity if this activity is nested in another forEach activity.
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) KIND_REPEAT_UNTIL (52)
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.
PREVIOUS_EXPIRATION_TIME	Timestamp	The previous expiration time for the activity.
STATE	Integer	The state of the activity. Possible values are: STATE_INACTIVE (1) STATE_READY (2) STATE_RUNNING (3) 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) STATE_PROCESSING_UNDO (14)
SUBSTATE	Integer	The substate of the activity when the process instance was migrated. Possible values are: SUB_STATE_NONE (0) SUB_STATE_EXPIRING (1) SUB_STATE_SKIPPING (2) SUB_STATE_RESTARTING (3) SUB_STATE_FINISHING (4) SUB_STATE_FAILING (5)
STOP_REASON	Integer	The reason why the activity stopped. Possible values are: STOP_REASON_UNSPECIFIED (1) STOP_REASON_ACTIVATION_FAILED (2) STOP_REASON_IMPLEMENTATION_FAILED (3) STOP_REASON_FOLLOW_ON_NAVIGATION_FAILED (4) STOP_REASON_EXIT_CONDITION_FALSE (5)
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.
INVOKED_INST_ID	Integer	The instance ID of the invoked process or task. You can use the value of the INVOKED_INSTANCE_TYPE column to determine the instance type.
INVOKED_INST_TYPE	Integer	The type of the instance ID in the INVOKED_INST_ID column. Possible values are: INVOKED_INSTANCE_TYPE_NOT_SET (0) INVOKED_INSTANCE_TYPE_INLINE_TASK (1) INVOKED_INSTANCE_TYPE_CHILD_TASK (2) INVOKED_INSTANCE_TYPE_CHILD_PROCESS (3)
SKIP_REQUESTED	Boolean	Specifies whether the activity is marked for skipping.
CONTINUE_ON_ERROR	Boolean	Specifies what happens to a process if an unexpected fault is raised and a fault handler is not defined for that fault. This column is Initialized with the corresponding value from the activity template but can be overwritten by the forceComplete and forceRetry APIs. Possible values are: True Standard fault handling is applied. False Navigation of the process stops so that the process can be repaired.