ESC_TEMPL view

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

Table 1. 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.