ESCALATION view: Business Process Choreographer database view

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

Use this predefined Business Process Choreographer database view to query data for escalations.

Columns in the ESCALATION view
Column name Type Comments
ESIID ID The ID of the escalation instance.
ACTION Integer The action triggered by the escalation. Possible values are:

ACTION_CREATE_WORK_ITEM (1)

Creates a work item for each escalation receiver.

ACTION_SEND_EMAIL (2)

Sends an email to each escalation receiver.

ACTION_CREATE_EVENT (3)

Creates and publishes an event.

ACTIVATION_STATE Integer An escalation instance is created if the corresponding task reaches one of the following states:

ACTIVATION_STATE_READY (2)

Specifies that the human or participating task is ready to be claimed.

ACTIVATION_STATE_RUNNING (3)

Specifies that the originating task is started and running.

ACTIVATION_STATE_CLAIMED (8)

Specifies that the task is claimed.

ACTIVATION_STATE_WAITING_FOR_SUBTASK (20)

Specifies that the task is waiting for the completion of subtasks.

ACTIVATION_TIME Timestamp The time when the escalation is activated.
AT_LEAST_EXP_STATE Integer The state of the task that is expected by the escalation. If a timeout occurs, the task state is compared with the value of this attribute. Possible values are:

AT_LEAST_EXPECTED_STATE_CLAIMED (8)

Specifies that the task is claimed.

AT_LEAST_EXPECTED_STATE_ENDED (20)

Specifies that the task is in a final state (FINISHED, FAILED, TERMINATED or EXPIRED).

AT_LEAST_EXPECTED_STATE_SUBTASKS_COMPLETED (21)

Specifies that all of the subtasks of the task are complete.

ESCALATION_TIME Timestamp The time when the escalation is to be raised.
ESTID ID The ID of the corresponding escalation template.
FIRST_ESIID ID The ID of the first escalation in the chain.
INCREASE_PRIORITY Integer Indicates how the task priority will be increased. Possible values are:

INCREASE_PRIORITY_NO (1)

The task priority is not increased.

INCREASE_PRIORITY_ONCE (2)

The task priority is increased once by one.

INCREASE_PRIORITY_REPEATED (3)

The task priority is increased by one each time the escalation repeats.

NAME String The name of the escalation.
STATE Integer The state of the escalation. Possible values are:
STATE_INACTIVE (1)
STATE_WAITING (2)
STATE_ESCALATED (3)
STATE_SUPERFLUOUS (4)
TKIID ID The task instance ID to which the escalation belongs.

Database views for Business Process Choreographer

Column name	Type	Comments
ESIID	ID	The ID of the escalation instance.
ACTION	Integer	The action triggered by the escalation. Possible values are: ACTION_CREATE_WORK_ITEM (1) Creates a work item for each escalation receiver. ACTION_SEND_EMAIL (2) Sends an email to each escalation receiver. ACTION_CREATE_EVENT (3) Creates and publishes an event.
ACTIVATION_STATE	Integer	An escalation instance is created if the corresponding task reaches one of the following states: ACTIVATION_STATE_READY (2) Specifies that the human or participating task is ready to be claimed. ACTIVATION_STATE_RUNNING (3) Specifies that the originating task is started and running. ACTIVATION_STATE_CLAIMED (8) Specifies that the task is claimed. ACTIVATION_STATE_WAITING_FOR_SUBTASK (20) Specifies that the task is waiting for the completion of subtasks.
ACTIVATION_TIME	Timestamp	The time when the escalation is activated.
AT_LEAST_EXP_STATE	Integer	The state of the task that is expected by the escalation. If a timeout occurs, the task state is compared with the value of this attribute. Possible values are: AT_LEAST_EXPECTED_STATE_CLAIMED (8) Specifies that the task is claimed. AT_LEAST_EXPECTED_STATE_ENDED (20) Specifies that the task is in a final state (FINISHED, FAILED, TERMINATED or EXPIRED). AT_LEAST_EXPECTED_STATE_SUBTASKS_COMPLETED (21) Specifies that all of the subtasks of the task are complete.
ESCALATION_TIME	Timestamp	The time when the escalation is to be raised.
ESTID	ID	The ID of the corresponding escalation template.
FIRST_ESIID	ID	The ID of the first escalation in the chain.
INCREASE_PRIORITY	Integer	Indicates how the task priority will be increased. Possible values are: INCREASE_PRIORITY_NO (1) The task priority is not increased. INCREASE_PRIORITY_ONCE (2) The task priority is increased once by one. INCREASE_PRIORITY_REPEATED (3) The task priority is increased by one each time the escalation repeats.
NAME	String	The name of the escalation.
STATE	Integer	The state of the escalation. Possible values are: STATE_INACTIVE (1) STATE_WAITING (2) STATE_ESCALATED (3) STATE_SUPERFLUOUS (4)
TKIID	ID	The task instance ID to which the escalation belongs.