Copyright © Cloud Software Group, Inc. All rights reserved.

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 number(5) NOT NULL,
proc_id number(5) NOT NULL,
casenum number(20) NOT NULL,
type_id number(3) NOT NULL,
audit_date date NOT NULL,
stepdesc varchar2(24) NULL,
user_name varchar2(64) NULL,
stepname varchar2(8) NULL,
audit_usecs number(6) NOT NULL,
major_vers number(5) NOT NULL,
minor_vers number(5) NOT NULL)

Column	Description
node_id	ID of the node that this audit event is hosted on, as defined in the nodes table.
proc_id	ID of the procedure that this audit event belongs to, as defined in the proc_index table.
casenum	Case number that this audit event belongs to, as defined in the case_information table.
type_id	ID of the audit event that occurred. Either: • 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.
audit_date	Date and time that this audit event occurred. Note: The audit_usecs column can be combined with this column to provide resolution to a microsecond.
stepdesc	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.
user_name	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.
stepname	Name of the step that this audit event occurred for. For internal use only.
audit_usecs	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.
major_vers	Major version number of the version of the procedure that this audit event belongs to, as defined in the proc_version table.
minor_vers	Minor version number of the version of the procedure that this audit event belongs to, as defined in the proc_version table.

Primary Key

None.

Foreign Keys

The following foreign key is defined for this table.

Key Name	Column(s)	Referenced in Table...
fk_audit_trail1	node_id proc_id casenum	case_information

---

1

This key enforces the DELETE CASCADE referential action.

Indexes

The following index is defined for this table.

Index Name	Column(s) Indexed	Tablespace
idx_audit_trail_fk	casenum proc_id node_id	MASSIVEINDEXSPACE

Storage

The following STORAGE values are defined for this table.

Value	Definition
Initial	MASSIVETABLESIZE
Percentage Increase	MASSIVETABLEPCTINCREASE
Tablespace	MASSIVETABLESPACE

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.

A row is...	When...
added	an audit event occurs.
updated	never.
deleted	a case is purged.

Copyright © Cloud Software Group, Inc. All rights reserved.