This table contains the WebSphere Commerce business auditing records captureed when the business auditing component is enabled.
Column Description(s):
Column Name | Column Type | Description |
BUSAUDIT_ID |
BIGINT NOT NULL |
Unique identifier of a particular business audit record. |
SESSION_ID |
BIGINT NOT NULL |
The unique session ID associated with the request that made the audit. |
SEQUENCE |
INTEGER NOT NULL |
At which point or sequence, in the request, that the audit was made. |
USERS_ID |
BIGINT NOT NULL |
The user of the request. |
FOR_USER_ID |
BIGINT |
The user identifier on which the request was made. |
AUDIT_TIMESTAMP |
TIMESTAMP NOT NULL |
When the audit record was created. |
EVENT_TYPE |
CHAR(3) NOT NULL |
The 3 letter prefix to represent the event type. For example, a value of GEN means a generic business audit event type. |
SIGNATURE |
BINARY NOT NULL |
The signature of the audit record to ensure that there is no tampering with the stored data. |
STORE_ID |
INTEGER NOT NULL |
The store ID of the request. |
OCCURENCE |
INTEGER NOT NULL |
When, in the execution, that this audit record was created; that is, before the command was executed. This number corresponds to the constants defined in CommandExectionTrigger. |
COMMAND_NAME |
VARCHAR(254) NOT NULL |
The name of the business logic or object being audited. |
SEARCH_FIELD1 |
VARCHAR(254) |
Customizable. |
SEARCH_FIELD2 |
VARCHAR(254) |
Customizable. |
SEARCH_FIELD3 |
VARCHAR(254) |
Customizable. |
SEARCH_FIELD4 |
VARCHAR(254) |
Customizable. |
SEARCH_FIELD5 |
VARCHAR(254) |
Customizable. |
PARAMETERS |
CLOB |
The parameter of the audit event. Parameters are encrypted if they contain attributes that need to be encrypted. |
WORKSPACE |
CHAR(25) |
The workspace identifier associated with the business operation. |
TASKGRP |
CHAR(25) |
The task group identifier associated with the business operation. |
TASK |
CHAR(25) |
The task identifier associated with the business operation. |
ACTION |
CHAR(1) |
An action key associated with the business operation. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031203180 |
BUSAUDIT_ID |
Primary Key |
I0000374 |
SESSION_ID+SEQUENCE |
Non-Unique Index |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.