Patent ID: 8332349

Claim:
An audit computer system structured for auditing at least one operational table of a financial transaction computer system for an audit event, the audit computer system comprising: (a) a programmable processor; and (b) a computer memory in electronic communication with the processor, the memory configured to hold data and instructions, comprising: at least one audit history table operatively associated with the operational table of the transaction computer system, each audit history table including at least one database trigger; the audit history table being configured to store substantially all data changes which occur in the financial 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 where the data changes produce a single logical action and track the plurality of data changes in an audit event table; 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; the database trigger being configured to monitor for one or more data changes in the operational table, and to generate a message describing a monitored data change, and to transmit the message to a SQL server service broker queue; the SQL server service broker queue configured, upon the arrival of the message at the queue, to activate a routing procedure to transmit the message to at least one applicable subscriber's service broker queue; and the subscriber service broker queue configured, upon arrival of the message, to activate an asynchronous data processing service for the monitored data change.