TASK_HISTORY view
Use this predefined Business Process Choreographer database
view for queries on the event log for a task.
| 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.
|