Structure of the audit trail database view for human tasks

The TASK_AUDIT_LOG database view provides audit log information about human tasks.

Inline tasks are logged in the AUDIT_LOG_B view , whereas all other task types are logged in the TASK_AUDIT_LOG view.

To read the content of the audit trail, use SQL or any other administration tool that supports the reading of database tables and views.

Audit events are related to task entities. The audit event types depend on the entity to which the event refers. The audit event types include:

The following table describes the structure of the TASK_AUDIT_LOG audit trail view. It lists the names of the columns, the event types, and gives a short description for the column.

Inline tasks are logged in theAUDIT_LOG_B audit trail view and not in the TASK_AUDIT_LOG audit trail view. For example, claiming an inline participating task results in an ACTIVITY_CLAIMED event; a task-related event is not generated.

Table 1. Structure TASK_AUDIT_LOG audit trail view
Name TIE TTE EIE Description
ALID x x x The identifier of the audit log entry.
AUDIT_EVENT x x x The type of event that occurred. For a list of audit event codes, see Audit event types for human tasks.
CONTAINMENT_CTX_ID x x The identifier of the containing context, for example, ACOID, PTID, or PIID.
ESIID x The identifier of the escalation instance that is related to the current event.
ESTID x The identifier of the escalation template that is related to the current event.
EVENT_TIME x x x The time when the event occurred in Coordinated Universal Time (UTC) format.
FAULT_NAME x The name of the fault message. This attribute is applicable to the following events:

TASK_FAILED
TASK_FAULT_MESSAGE_UPDATED

FAULT_NAME_SPACE x The namespace of the fault message type. This attribute is applicable to the following events:

TASK_FAILED
TASK_FAULT_MESSAGE_UPDATED

FOLLOW_ON_TKIID x The ID of the follow-on task instance.
NAME x x x The name of the task instance, task template, or escalation instance that is associated with the event.
NAMESPACE x x   The namespace of the task instance, task template, or escalation instance that is associated with the event.
NEW_USER       The new owner of a transferred work item. This attribute is applicable to the following events:
x     TASK_WORKITEM_CREATED
x     TASK_WORKITEM_TRANSFERRED
    x ESCALATION_WORKITEM_CREATED
    x ESCALATION_WORKITEM_TRANSFERRED
OLD_USER The previous owner of a transferred work item. This attribute is applicable to the following events:
x     TASK_WORKITEM_TRANSFERRED
x     TASK_WORKITEM_DELETED
    x ESCALATION_WORKITEM_TRANSFERRED
    x ESCALATION_WORKITEM_DELETED
PARENT_CONTEXT_ID x The ID of the parent context of the task, for example, an activity template or a task instance. This is only set for subtasks and follow-on tasks.
PARENT_TASK_NAME x The name of the parent task instance or template. This is only set for subtasks and follow-on tasks.
PARENT_TASK_NAMESP x The namespace of the parent task instance or template. This is only set for subtasks and follow-on tasks.
PARENT_TKIID x The identifier of the parent task instance.
PRINCIPAL x x x The name of the principal whose request triggered the event.
TASK_KIND x x The kind of the task. Possible values are:

KIND_HUMAN 101
KIND_ORIGINATING 103
KIND_PARTICIPATING 105
KIND_ADMINISTRATIVE 106

TASK_STATE x The state of the task or task template. Possible values for task templates are:

STATE_STARTED 1
STATE_STOPPED 2

Possible values for task instances are:

'1' :'STATE_INACTIVE'
'2' :'STATE_READY'
'3' :'STATE_RUNNING'
'5' :'STATE_FINISHED'
'6' :'STATE_FAILED'
'7' :'STATE_TERMINATED'
'8' :'STATE_CLAIMED'
'12' :'STATE_EXPIRED'
'101':'FORWARDED'

TKIID x x The identifier of the task instance.
TKTID x x The identifier of the task template.
TOP_TKIID x The identifier of the top task instance.
VALID_FROM x Valid-from date of the task template that is related to the current event.
WORK_ITEM_REASON x x The reason for the assignment of the work item. Possible values are:

POTENTIAL_OWNER 1
EDITOR  2
READER 3
OWNER  4
POTENTIAL_STARTER 5
STARTER  6
ADMINISTRATOR 7
POTENTIAL_SENDER 8
ORIGINATOR 9
ESCALATION_RECEIVER 10
POTENTIAL_INSTANCE_CREATOR 11

The reason is set for all events related to work items: ESCALATION_RECEIVER is set for escalation work item related events, while the other reasons apply to task work item related events.


Terms of use |

Last updated: Thu Apr 27 14:54:57 2006

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