![]() |
Copyright © TIBCO Software Inc. All rights reserved. |
The audit_trail table holds information about each event that has happened to each case on the system.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 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:
•
• If type_id is:
•
• => 256, a user-defined string, containing for example the name of the user who performed this audit event. 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. The following clustered index is defined for this table.
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. |