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.
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. For a list of audit event codes, see Audit event types for business processes |
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 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 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 |
|||
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:
|
||||
ADDITIONAL_INFO | x | x | x | The contents of this field depends on the type of the
event:
|
Last updated: Tue Dec 06 04:14:40 2005
(c) Copyright IBM Corporation 2005.
This information center is powered by Eclipse technology (http://www.eclipse.org)