WebSphere Commerce database table: BUSAUDIT

WebSphere Commerce database table: BUSAUDIT

This table contains the WebSphere Commerce business auditing records captureed when the business auditing component is enabled.
Column Descriptions
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235132020 BUSAUDIT_ID Primary Key
I0000374 SESSION_ID+SEQUENCE Non-Unique Index

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 Name	Indexed Column Names	Index Type
SQL060903235132020	BUSAUDIT_ID	Primary Key
I0000374	SESSION_ID+SEQUENCE	Non-Unique Index