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.
FOLLOW_ON_TKIID ID The ID of the instance of the follow-on task.
HIERARCHY_POSITION Integer Possible values are:
HIERARCHY_POSITION_TOP_TASK (0)
The top-level task in the task hierarchy.
HIERARCHY_POSITION_SUB_TASK (1)
The task is a subtask in the task hierarchy.
HIERARCHY_POSITION_FOLLOW_ON_TASK (2)
The task is a follow-on task in the task hierarchy.
IS_AD_HOC Boolean Indicates whether this task was created dynamically at runtime or from a task template.
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.
IS_WAIT_FOR_SUB_TK Boolean Indicates whether the parent task is waiting for a subtask to reach an end state.
KIND Integer The kind of task. Possible values are:
KIND_HUMAN (101)
States that the task is created and processed by a human.
KIND_WPC_STAFF_ACTIVITY (102)
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 (103)
States that the task supports person-to-computer interactions, which enables people to create, initiate, and start services.
KIND_PARTICIPATING (105)
States that the task supports computer-to-person interactions, which enable a person to implement a service.
KIND_ADMINISTRATIVE (106)
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 (2)
States that the task is ready to be claimed.
STATE_RUNNING (3)
States that the task is started and running.
STATE_FINISHED (5)
States that the task finished successfully.
STATE_FAILED (6)
States that the task did not finish successfully.
STATE_TERMINATED (7)
States that the task has been terminated because of an external or internal request.
STATE_CLAIMED (8)
States that the task is claimed.
STATE_EXPIRED (12)
States that the task ended because it exceeded its specified duration.
STATE_FORWARDED (101)
States that task completed with a follow-on task.
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.
SUPPORT_FOLLOW_ON Boolean Indicates whether this task supports the creation of follow-on tasks.
SUPPORT_SUB_TASK Boolean Indicates whether this task supports the creation of subtasks.
SUSPENDED Boolean Indicates whether the task is suspended.
TKTID ID The task template ID.
TOP_TKIID ID The top parent task instance ID if this is a subtask.
TYPE String The type used to categorize the task.

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