Patent ID: 7634520

Claim:
An audit computer system structured for auditing at least one operational table of a transaction computer system for an audit event, the audit computer system comprising: at least one audit history table operatively associated with the operational table of the transaction computer system, the audit history table including at least one database trigger configured for monitoring one or more data changes in the operational table; the audit history table being configured to store substantially all data changes which occur in the transaction computer system during the audit event by storing the data changes in the audit history table as audit event data; the audit history tables being configured to function separately from the operational tables of the transaction computer system; at least one audit event table operatively associated with at least one of the audit history tables and the associated operational table, the audit event table being configured for associating the data changes with the audit event, wherein the audit event table groups together a plurality of data changes that occur against multiple tables which produce a single logical transaction; and, at least one representation of the data of an operational table as it appeared on a historical date generated by the operational interaction of the at least one audit history table, the at least one audit event table, and the at least one operational table.