WORK_ITEM view: Business Process Choreographer database view

IBM BPM, V8.0.1, All platforms > Reference > Database views for Business Process Choreographer
WORK_ITEM view

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

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_ESCALATION_TEMPLATE (8)
Specifies that the work item was created for an escalation template.
OBJECT_TYPE_APPLICATION_COMPONENT (9)
Specifies that the work item was created for an application component.
Columns in the WORK_ITEM view
Column name Type Comments

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. This integer value indicates one of the following meanings:
REASON_NONE (0)
REASON_POTENTIAL_OWNER (1)
REASON_EDITOR (2)
REASON_READER (3)
REASON_OWNER (4)
REASON_POTENTIAL_STARTER (5)
REASON_STARTER (6)
REASON_ADMINISTRATOR (7)
REASON_ORIGINATOR (9)
REASON_ESCALATION_RECEIVER (10)
REASON_POTENTIAL_INSTANCE_CREATOR (11)
CREATION_TIME Timestamp The date and time when the work item was created.

Database views for Business Process Choreographer

Column name	Type	Comments
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. This integer value indicates one of the following meanings: REASON_NONE (0) REASON_POTENTIAL_OWNER (1) REASON_EDITOR (2) REASON_READER (3) REASON_OWNER (4) REASON_POTENTIAL_STARTER (5) REASON_STARTER (6) REASON_ADMINISTRATOR (7) REASON_ORIGINATOR (9) REASON_ESCALATION_RECEIVER (10) REASON_POTENTIAL_INSTANCE_CREATOR (11)
CREATION_TIME	Timestamp	The date and time when the work item was created.