TASK view

Use this predefined database view for queries on task objects.

Table 1. Columns in the TASK view
Column name Type Comments
TKIID ID The ID of the task instance.
ACTIVATED Timestamp The time when the task was activated.
APPLIC_DEFAULTS_ID ID The ID of the application component that specifies the defaults for the task.
APPLIC_NAME String The name of the enterprise application to which the task belongs.
BUSINESS_RELEVANCE Boolean Specifies whether the task is business relevant. The attribute affects logging to the audit trail. Possible values are:
TRUE
The task is business relevant and it is audited.
FALSE
The task is not business relevant and it is not audited.
COMPLETED Timestamp The time when the task completed.
CONTAINMENT_CTX_ID ID The containment context for this task. This attribute determines the life cycle of the task. When the containment context of a task is deleted, the task is also deleted.
CTX_AUTHORIZATION Integer Allows the task owner to access the task context. Possible values are:
AUTH_NONE
No authorization rights for the associated context object.
AUTH_READER
Operations on the associated context object require reader authority, for example, reading the properties of a process instance.
DUE Timestamp The time when the task is due.
EXPIRES Timestamp The date when the task expires.
FIRST_ACTIVATED Timestamp The time when the task was activated for the first time.
IS_ESCALATED Boolean Indicates whether an escalation of this task has occurred.
IS_INLINE Boolean Indicates whether the task is an inline task in a business process.
KIND Integer The kind of task. Possible values are:
KIND_HUMAN
States that the task is created and processed by a human.
KIND_WPC_STAFF_ACTIVITY
States that the task is a human task that is a staff activity of a WebSphere Business Integration Server Foundation, version 5 business process.
KIND_ORIGINATING
States that the task supports person-to-computer interactions, which enables people to create, initiate, and start services.
KIND_PARTICIPATING
States that the task supports computer-to-person interactions, which enable a person to implement a service.
KIND_ADMINISTRATIVE
States that the task is an administrative task.
LAST_MODIFIED Timestamp The time when the task was last modified.
LAST_STATE_CHANGE Timestamp The time when the state of the task was last modified.
NAME String The name of the task.
NAME_SPACE String The namespace that is used to categorize the task.
ORIGINATOR String The principal ID of the task originator.
OWNER String The principal ID of the task owner.
PARENT_CONTEXT_ID String The parent context for this task. This attribute provides a key to the corresponding context in the calling application component. The parent context is set by the application component that creates the task.
PRIORITY Integer The priority of the task.
STARTED Timestamp The time when the task was started (STATE_RUNNING, STATE_CLAIMED).
STARTER String The principal ID of the task starter.
STATE Integer The state of the task. Possible values are:
STATE_READY
States that the task is ready to be claimed.
STATE_RUNNING
States that the task is started and running.
STATE_FINISHED
States that the task finished successfully.
STATE_FAILED
States that the task did not finish successfully.
STATE_TERMINATED
States that the task has been terminated because of an external or internal request.
STATE_CLAIMED
States that the task is claimed.
STATE_EXPIRED
States that the task ended because it exceeded its specified duration.
SUPPORT_AUTOCLAIM Boolean Indicates whether this task is claimed automatically if it is assigned to a single user.
SUPPORT_CLAIM_SUSP Boolean Indicates whether this task can be claimed if it is suspended.
SUPPORT_DELEGATION Boolean Indicates whether this task supports work delegation through creating, deleting, or transferring work items.
SUSPENDED Boolean Indicates whether the task is suspended.
TKTID String The task template ID.
TYPE String The type used to categorize the task.

Terms of use |

Last updated: Tue Feb 21 17:31:26 2006

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