TASK_HISTORY view: Business Process Choreographer database view

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

Use this predefined Business Process Choreographer database view for queries on the event log for a task.

Columns in the TASK_HISTORY view
Column name Type Comments
EVENT Integer The event type.
TKIID ID The ID of the task instance.
EVENT_TIME Timestamp The time when the logged event occurred.
PRINCIPAL String The name of principal who triggered the event.
FROM_ID String The name of user whose work item was transferred to the TO_ID, or whose work item was deleted. Not all events have a FROM_ID value.
TO_ID String The name of user for whom a work item was created, or transferred to. Not all events have a TO_ID value.
WORK_ITEM_KIND Integer The authorization type. Possible values are:
WORK_ITEM_KIND_EVERYBODY (1)
WORK_ITEM_KIND_USER (2)
WORK_ITEM_KIND_GROUP (3)
REASON Integer The reason for the assignment of the work item. Not all events have a REASON value. Possible values are:
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)
PARENT_TKIID ID The ID of the related task instance. If the task instance is a subtask or a follow-on task of a parent task, this column contains the ID of the parent task. Otherwise, this column is null.
ESIID ID If the event is associated with an escalation instance, this column contains the escalation instance ID. Otherwise, this column is null.
NEXT_TIME Timestamp The time when the event is due to occur. The time depends on the event type.

TASK_STARTED

The expiration time of the task instance.

TASK_SUSPENDED

The resumption time of the task instance.

TASK_COMPLETED, TASK_TERMINATED, TASK_EXIRED, and TASK_FAILED

The time when the task instance is deleted automatically.

ESCALATION_STARTED

The time when the escalation fires.

ESCALATION_FIRED

The time when the escalation fires again.

Database views for Business Process Choreographer

Column name	Type	Comments
EVENT	Integer	The event type.
TKIID	ID	The ID of the task instance.
EVENT_TIME	Timestamp	The time when the logged event occurred.
PRINCIPAL	String	The name of principal who triggered the event.
FROM_ID	String	The name of user whose work item was transferred to the TO_ID, or whose work item was deleted. Not all events have a FROM_ID value.
TO_ID	String	The name of user for whom a work item was created, or transferred to. Not all events have a TO_ID value.
WORK_ITEM_KIND	Integer	The authorization type. Possible values are: WORK_ITEM_KIND_EVERYBODY (1) WORK_ITEM_KIND_USER (2) WORK_ITEM_KIND_GROUP (3)
REASON	Integer	The reason for the assignment of the work item. Not all events have a REASON value. Possible values are: 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)
PARENT_TKIID	ID	The ID of the related task instance. If the task instance is a subtask or a follow-on task of a parent task, this column contains the ID of the parent task. Otherwise, this column is null.
ESIID	ID	If the event is associated with an escalation instance, this column contains the escalation instance ID. Otherwise, this column is null.
NEXT_TIME	Timestamp	The time when the event is due to occur. The time depends on the event type. TASK_STARTED The expiration time of the task instance. TASK_SUSPENDED The resumption time of the task instance. TASK_COMPLETED, TASK_TERMINATED, TASK_EXIRED, and TASK_FAILED The time when the task instance is deleted automatically. ESCALATION_STARTED The time when the escalation fires. ESCALATION_FIRED The time when the escalation fires again.