WebSphere Commerce database table: BUSAUDIT

BUSAUDIT

This table contains the WebSphere Commerce business auditing records captured when the business auditing component is enabled.

Column Descriptions:

Name 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 The phase during execution when the audit record was created: 0=Exit 1=Exception 2=Entry. By default the Admin Console reports include phases 1 (Exception) and 2 (Entry), as specified in BusinessAuditingReport.xml.
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 (10000000) 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 NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
<SYSTEM-GENERATED> BUSAUDIT_ID Primary Key
I0000374 SESSION_ID+SEQUENCE Non-Unique Index

Name	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	The phase during execution when the audit record was created: 0=Exit 1=Exception 2=Entry. By default the Admin Console reports include phases 1 (Exception) and 2 (Entry), as specified in BusinessAuditingReport.xml.
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 (10000000)	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Name	Column Names	Type
<SYSTEM-GENERATED>	BUSAUDIT_ID	Primary Key
I0000374	SESSION_ID+SEQUENCE	Non-Unique Index