ACTIVITY view: Business Process Choreographer database view

IBM BPM, V8.0.1, All platforms > Reference > Database views for Business Process Choreographer
ACTIVITY view

Use this predefined Business Process Choreographer database view for queries on activities.

process instance ID.
Columns in the ACTIVITY view
Column name Type Comments
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.

Database views for Business Process Choreographer

Column name	Type	Comments
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.