ESCALATION view

Use this predefined database view to query data for escalations.

Table 1. Columns in the ESCALATION view
Column name Type Comments
ESIID String The ID of the escalation instance.
ACTION Integer The action triggered by the escalation. Possible values are:
ACTION_CREATE_WORK_ITEM
Creates a work item for each escalation receiver.
ACTION_SEND_EMAIL
Sends an e-mail to each escalation receiver.
ACTION_CREATE_EVENT
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
Specifies that the human or participating task is ready to be claimed.
ACTIVATION_STATE_RUNNING
Specifies that the originating task is started and running.
ACTIVATION_STATE_CLAIMED
Specifies that the task is claimed.
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
Specifies that the task is claimed.
AT_LEAST_EXPECTED_STATE_ENDED
Specifies that the task is in a final state (FINISHED, FAILED, TERMINATED or EXPIRED).
ESTID String The ID of the corresponding escalation template.
FIRST_ESIID String 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
The task priority is not increased.
INCREASE_PRIORITY_ONCE
The task priority is increased once by one.
INCREASE_PRIORITY_REPEATED
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
STATE_WAITING
STATE_ESCALATED
STATE_SUPERFLUOUS

TKIID String The task instance ID to which the escalation belongs.

Terms of use | | Broken links

Last updated: Tue Dec 06 04:14:40 2005

(c) Copyright IBM Corporation 2005.
This information center is powered by Eclipse technology (http://www.eclipse.org)