Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved


Chapter 7 Cases : audit_trail

audit_trail
The audit_trail table holds information about each event that has happened to each case on the system.
Structure
The audit_trail table has the following structure:
TABLE audit_trail (
node_id INTEGER NOT NULL,
proc_id INTEGER NOT NULL,
casenum NUMERIC(20) NOT NULL,
type_id INTEGER NOT NULL,
audit_date TIMESTAMP NOT NULL,
stepdesc VARCHAR(24) ,
user_name VARCHAR(64) ,
stepname VARCHAR(8) ,
audit_usecs NUMERIC(10) NOT NULL,
major_vers INTEGER NOT NULL,
minor_vers INTEGER NOT NULL)
a system-defined audit event (<=255), as defined in the SWDIR\etc\language.lng\audit.mes file.
a custom, application-defined event (256-999), as defined in the SWDIR\etc\language.lng\auditusr.mes file.
Note: See "Defining Audit Trail Entries" in TIBCO iProcess swutil and swbatch Reference Guide for more information about system-defined and application-defined audit trail entries.
Note: The audit_usecs column can be combined with this column to provide resolution to a microsecond.
If type_id is:
<= 255, the step description of the step that this audit event occurred to.
=> 256, a user-defined string, containing for example the description of this audit event.
If type_id is:
<= 255, the name of the user who performed this audit event, as defined in the user_names table.
=> 256, a user-defined string, containing for example the name of the user who performed this audit event.
Number of microseconds since the start of the seconds value specified in the audit_date column.
Primary Key
None.
Foreign Keys
The following foreign key is defined for this table.

1
This key enforces the DELETE CASCADE referential action.

Indexes
The following index is defined for this table.
Table Activity
The audit_trail table contains one or more rows for each step of each case on the system. Rows are added, updated and deleted in the following situations.

Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved