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

AUDIT_LOG_B view

Use this predefined Business Process Choreographer database view for queries on audit log information for BPEL processes.

Inline tasks are logged in both the AUDIT_LOG_B view and in the TASK_AUDIT_LOG view.

For example, claiming an inline participating task results in a TASK_CLAIMED event and an ACTIVITY_CLAIMED event. All other task types are only logged in the TASK_AUDIT_LOG view. Depending on the choices made in IBM Integration Designer, inline human tasks can also trigger Common Event Infrastructure (CEI) events to be emitted for Business Flow Manager staff activity events and Human Task Manager task events.

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:

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

process instance was migrated. Possible values are:

SUB_STATE_NONE (0)
SUB_STATE_EXPIRING (1)
SUB_STATE_SKIPPING (2)
SUB_STATE_RESTARTING (3)
SUB_STATE_FINISHING (4)
SUB_STATE_FAILING (5)

Structure of the AUDIT_LOG_B audit trail view
Name PTE PIE AIE VAR CLE SIE Description
ATID   x The ID of the activity template related to the current event.
CONTROL_LINK_NAME x Name of the link that is related to the current link event.
CORR_SET_INFO x The string representation of the correlation set that was initialized at process start time. Provided with the processCorrelationSetInitialized event (42027).
DESCRIPTION x x x x x Description of activity or process, containing potentially resolved replacement variables.
EXCEPTION_TEXT   x x x Exception message that caused an activity or process to fail. Applicable for:

PROCESS_FAILED
ACTIVITY_FAILED
SCOPE_FAILED

PARENT_PIID x x x x x Process instance ID of the parent process, or null if no parent exists.
PIID x x x x x Process instance ID of the process instance that is related to the current event.
PRINCIPAL x x x x x Name of the principal. This is not set for PROCESS_DELETED events.
PROCESS_APP_ACRONYM x x x x x x The acronym of the process application if the root container is a process application. This is only set if the BPEL process is deployed from the Process Center.
PROCESS_TEMPL_NAME x x x x x x Process template name of the process template that is related to the current event.
PTID x x x x x x Process template ID of the process that is related to the current event.
SIID x The ID of the scope instance related to the event.
SNAPSHOT_ID x x x x x x The snapshot ID of the root container, which can be either a process application or a toolkit. This is only set if the BPEL process is deployed from the Process Center.
SNAPSHOT_NAME x x x x x x The snapshot name of the root container. This is only set if the BPEL process is deployed from the Process Center.
TOP_LEVEL_PIID   x x x x x Identifier of the top-level process that is related to the current event.
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

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.
VARIABLE_DATA   x Data for variables for variable updated events.
VARIABLE_NAME x   The name of the variable related to the current event.

Database views for Business Process Choreographer


Related information:
Business process events