14.1 sp599_transaction_audit

This table cross-references the operation (action) carried out by the server, with the job changes that have resulted in the database. This cross-reference is by transaction_id; so that the transaction_id in this table corresponds with the transaction_id in SP507_AUDIT_SP100, SP508_AUDIT_SP108, SP509_AUDIT_SP111 and SP500_GANTT_AUDIT.

It should be noted that SP100_ACTIVITIES, SP108_JOB_DETAILS and SP111_JOBS also have a transaction_id column. These columns are for internal purpose only and will contain the NULL value if queried. These columns are used to populate the corresponding audit tables transaction_id.

HouseKeeping

This table is tidied by sp_dbtidy's Audit group.

Table Definition

Field	Type	Default
action	varchar2(255)
transaction_id	number(9)
timestamp	date	sysdate
reason_code	number
reason_comment	varchar2(255)

Keys

foreign key (reason_code) references SP590_audit_reason_codes (reason_code)

Column Descriptions

Field	Description
action	This is a mnemonic describing this transaction. It corresponds to the action/operation identifier used in the FRU application log.
transaction_id	An integer that relates the transaction_id columns of audit tables together with the action that caused the change.
timestamp	Is the date and time that the action occurred (Uses the time zone of the DBMS server machine).
reason_code	Optional reason code.
reason_comment	Optional reason comment.