ESC_TEMPL view

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

Use this predefined database view to query data for escalation templates.

Columns in the ESC_TEMPL view
Column name Type Comments
ESTID ID The ID of the escalation template.
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.

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.

CONTAINMENT_CTX_ID String If the escalation template belongs to an inline task template, the containment context is the process template. If the escalation template context belongs to a stand-alone task template, the containment context is the task template.
FIRST_ESTID ID The ID of the first escalation template in a chain of escalation templates.
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 template.
PREVIOUS_ESTID ID The ID of the previous escalation template in a chain of escalation templates.
TKTID ID The task template ID to which the escalation template belongs.

Database views for Business Process Choreographer

Column name	Type	Comments
ESTID	ID	The ID of the escalation template.
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.
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.
CONTAINMENT_CTX_ID	String	If the escalation template belongs to an inline task template, the containment context is the process template. If the escalation template context belongs to a stand-alone task template, the containment context is the task template.
FIRST_ESTID	ID	The ID of the first escalation template in a chain of escalation templates.
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 template.
PREVIOUS_ESTID	ID	The ID of the previous escalation template in a chain of escalation templates.
TKTID	ID	The task template ID to which the escalation template belongs.