Copyright © Cloud Software Group, 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 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 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.
This key enforces the DELETE CASCADE referential action.
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. |