Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software 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 DATETIME NOT NULL,
stepdesc VARCHAR(24) NULL,
user_name VARCHAR(64) NULL,
stepname VARCHAR(8) NULL,
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.
Note: On systems that have been upgraded from Version 9, for any existing cases the 6 least significant digits of the at_id column are copied into this column to ensure that audit trail entries remain in the correct order.
Primary Key
None.
Triggers
None.
Indexes
The following clustered 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 © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved