WORK_ITEM view

Use this predefined database view for queries on work items and authorization data for process, tasks, and escalations.

Table 1. Columns in the WORK_ITEM view
Column name Type Comments
WIID ID The work item ID.
OWNER_ID String The principal ID of the owner.
GROUP_NAME String The name of the associated group worklist.
EVERYBODY Boolean Specifies whether everybody owns this work item.
OBJECT_TYPE Integer The type of the associated object. Possible values are:
OBJECT_TYPE_ACTIVITY (1)
Specifies that the work item was created for an activity.
OBJECT_TYPE_PROCESS_INSTANCE (3)
Specifies that the work item was created for a process instance.
OBJECT_TYPE_TASK_INSTANCE (5)
Specifies that the work item was created for a task.
OBJECT_TYPE_TASK_TEMPLATE (6)
Specifies that the work item was created for a task template.
OBJECT_TYPE_ESCALATION_INSTANCE (7)
Specifies that the work item was created for an escalation instance.
OBJECT_TYPE_APPLICATION_COMPONENT (9)
Specifies that the work item was created for an application component.
OBJECT_ID ID The ID of the associated object, for example, the associated process or task.
ASSOC_OBJECT_TYPE Integer The type of the object referenced by the ASSOC_OID attribute, for example, task, process, or external objects. Use the values for the OBJECT_TYPE attribute.
ASSOC_OID ID The ID of the object associated object with the work item. For example, the process instance ID (PIID) of the process instance containing the activity instance for which this work item was created.
REASON Integer The reason for the assignment of the work item. Possible values are:

REASON_POTENTIAL_STARTER (5)
REASON_POTENTIAL_INSTANCE_CREATOR (11)
REASON_POTENTIAL_STARTER (1)
REASON_EDITOR (2)
REASON_READER (3)
REASON_ORIGINATOR (9)
REASON_OWNER (4)
REASON_STARTER (6)
REASON_ESCALATION_RECEIVER (10)
REASON_ADMINISTRATOR (7)

CREATION_TIME Timestamp The date and time when the work item was created.

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