BUSAUDIT

This table contains the HCL 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