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

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:

•	a version is created, updated, released or withdrawn,

•	the procedure definition instance associated with the version is updated. (For example, when a user makes changes to the procedure definition in the iProcess Modeler but does not change the version number).

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 ,
pa_comment VARCHAR(128) NULL,
pa_event SMALLINT ,
pa_date TIMESTAMP ,
pa_user VARCHAR(24) )

Column	Description
node_id	ID of the node that this audit event is stored on, as defined in the nodes table.
proc_id	Procedure number of the procedure associated with this audit event, as defined in the proc_index table.
major_vers	Major version number of the version associated with this audit event, as defined in the proc_version table.
minor_vers	Minor version number of the version associated with this audit event, as defined in the proc_version table.
pd_version	Instance number of the procedure definition associated with this audit event, as defined in the proc_instance table.
pa_comment	Comment describing the audit event.
pa_event	The audit event that occurred. Either: Created (0), Updated (1), Released (2) or Withdrawn (3).
pa_date	Date and time that the audit event occurred.
pa_user	Name of the user who performed the audit event, as defined in the user_names table.

Primary Key

None.

Foreign Keys

The following foreign key is defined for this table.

Key Name	Column(s)	Referenced in Table...
fk_proc_audit1	node_id proc_id pd_version	proc_instance

---

1

This key enforces the DELETE CASCADE referential action.

Indexes

The following index is defined for this table.

Index Name	Column(s) Indexed
idx_proc_audit_fk	node_id proc_id pd_version

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.

A row is...	When...
added	a version is created, updated, released or withdrawn.
updated	never.
deleted	a procedure or version is deleted.

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