Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.


Chapter 5 Procedures : proc_audit

proc_audit
The proc_audit table stores audit events for a version of a procedure (or sub-procedure or sub-procedure parameter template). An audit event occurs whenever:
Structure
The proc_audit table has the following structure:
TABLE proc_audit(
node_id
INTEGER NOT NULL,
proc_id INTEGER NOT NULL,
major_vers SMALLINT NOT NULL,
minor_vers SMALLINT NOT NULL,
pd_version SMALLINT NULL,
pa_comment VARCHAR(128) NULL,
pa_event SMALLINT NULL,
pa_date DATETIME NULL,
pa_user VARCHAR(24) NULL)
The audit event that occurred. Either: Created (0), Updated (1), Released (2) or Withdrawn (3).
Primary Key
None.
Triggers
None.
Indexes
The following index is defined for this table.
Table Activity
The proc_audit table contains one row for every audit event for every version of every procedure (or sub-procedure or sub-procedure parameter template) defined 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.