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

Column Descriptions:

BUSAUDIT_IDBIGINT NOT NULLUnique identifier of a particular business audit record.
SESSION_IDBIGINT NOT NULLThe unique session ID associated with the request that made the audit.
SEQUENCEINTEGER NOT NULLAt which point or sequence, in the request, that the audit was made.
USERS_IDBIGINT NOT NULLThe user of the request.
FOR_USER_IDBIGINTThe user identifier on which the request was made.
AUDIT_TIMESTAMPTIMESTAMP NOT NULLWhen the audit record was created.
EVENT_TYPECHAR (3) NOT NULLThe 3 letter prefix to represent the event type. For example, a value of GEN means a generic business audit event type.
SIGNATUREBINARY NOT NULLThe signature of the audit record to ensure that there is no tampering with the stored data.
STORE_IDINTEGER NOT NULLThe store ID of the request.
OCCURENCEINTEGER NOT NULLThe 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_NAMEVARCHAR (254) NOT NULLThe name of the business logic or object being audited.
SEARCH_FIELD1VARCHAR (254)Customizable.
SEARCH_FIELD2VARCHAR (254)Customizable.
SEARCH_FIELD3VARCHAR (254)Customizable.
SEARCH_FIELD4VARCHAR (254)Customizable.
SEARCH_FIELD5VARCHAR (254)Customizable.
PARAMETERSCLOB (10000000)The parameter of the audit event. Parameters are encrypted if they contain attributes that need to be encrypted.
WORKSPACECHAR (25)The workspace identifier associated with the business operation.
TASKGRPCHAR (25)The task group identifier associated with the business operation.
TASKCHAR (25)The task identifier associated with the business operation.
ACTIONCHAR (1)An action key associated with the business operation.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


NameColumn NamesType
I0000374SESSION_ID+SEQUENCENon-Unique Index