Structure of the audit trail database view for business processes

The AUDIT_LOG_B database view provides audit log information about business processes.

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 process entities. The audit event types depend on the entity to which the event refers. The audit event types include:

For a list of the audit event type codes, see Audit event types for business processes.

The following table describes the structure of the AUDIT_LOG_B 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 the AUDIT_LOG_B audit trail view and not in the TASK_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 of AUDIT_LOG_B audit trail view
Name PTE PIE AIE VAR CLE SIE Description
ALID x x x x x x Identifier of the audit log entry.
EVENT_TIME x x x x x x Timestamp of when the event occurred in Coordinated Universal Time (UTC) format.
EVENT_TIME_UTC x x x x x x Timestamp of when the event occurred in Coordinated Universal Time (UTC) format.
AUDIT_EVENT x x x x x x The type of event that occurred.
PTID x x x x x x Process template ID of the process that is related to the current event.
PIID x x x x x Process instance ID of the process instance that is related to the current event.
VARIABLE_NAME x   The name of the variable related to the current event.
SIID x The ID of the scope instance related to the event.
PROCESS_TEMPL_NAME x x x x x x Process template name of the process template that is related to the current event.
TOP_LEVEL_PIID   x x x x x Identifier of the top-level process that is related to the current event.
PARENT_PIID x x x x x Process instance ID of the parent process, or null if no parent exists.
VALID_FROM x x x x x x Valid-from date of the process template that is related to the current event.
VALID_FROM_UTC x x x x x x Valid-from date of the process template that is related to the current event in Coordinated Universal Time (UTC) format.
ATID   x The ID of the activity template related to the current event.
ACTIVITY_NAME     x x Name of the activity on which the event occurred.
ACTIVITY_KIND   x Kind of the activity on which the activity occurred. Possible values are:

KIND_EMPTY 3
KIND_INVOKE 21
KIND_RECEIVE 23
KIND_REPLY 24
KIND_THROW 25
KIND_TERMINATE 26
KIND_WAIT 27
KIND_COMPENSATE 29
KIND_SEQUENCE 30
KIND_SWITCH 32
KIND_WHILE 34
KIND_PICK 36
KIND_FLOW 38
KIND_SCRIPT 42
KIND_STAFF 43
KIND_ASSIGN 44
KIND_CUSTOM 45
KIND_RETHROW 46

These are the constants defined for ActivityInstanceData.KIND_*

ACTIVITY_STATE x State of the activity that is related to the event. Possible values are:

STATE_INACTIVE 1
STATE_READY 2
STATE_RUNNING 3
STATE_SKIPPED 4
STATE_FINISHED 5
STATE_FAILED 6
STATE_TERMINATED 7
STATE_CLAIMED 8
STATE_TERMINATING 9
STATE_FAILING 10
STATE_WAITING 11
STATE_EXPIRED 12
STATE_STOPPED 13

These are the constants defined for ActivityInstanceData.STATE_*

CONTROL_LINK_NAME x Name of the link that is related to the current link event.
PRINCIPAL x x x x x Name of the principal. This is not set for PROCESS_DELETED events.
VARIABLE_DATA   x Data for variables for variable updated events.
EXCEPTION_TEXT   x x x Exception message that caused an activity or process to fail. Applicable for:

PROCESS_FAILED
ACTIVITY_FAILED
SCOPE_FAILED

DESCRIPTION x x x x x Description of activity or process, containing potentially resolved replacement variables.
CORR_SET_INFO x The string representation of the correlation set that was initialized at process start time. Provided with the processCorrelationSetInitialized event (42027).
USER_NAME x x The name of the user whose work item has been changed. This is applicable for the following events:
  • Process instance work item deleted
  • Activity instance work item deleted
  • Process instance work item created
  • Activity instance work item created
ADDITIONAL_INFO   x x     x The contents of this field depends on the type of the event:
ACTIVITY_WORKITEM_ TRANSFERRED, PROCESS_WORK_ITEM_ TRANSFERRED
The name of the user that received the work item.
ACTIVITY_WORKITEM_ CREATED, ACTIVITY_WORKITEM_ REFRESHED, ACTIVITY_ESCALATED
The list of all of the users for which the work item was created or refreshed, separated by ','. If the list contains only one user, USER_NAME field is filled with the user name of this user. If the list contains only one user, the USER_NAME field is filled with the user name of this user and the ADDITIONAL_INFO field will be empty (null).
PROCESS_EVENT_RECEIVED, SCOPE_EVENT_RECEIVED
If available, the type of operation that was received by an event handler. The following format is used: '{' port type namespace '}' port type name ':' operation name. This field is not set for 'onAlarm' events.

Terms of use |

Last updated: Thu Apr 27 15:07:55 2006

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