Reconciliation Manager SQL table maintenance

Reconciliation Manager makes use of the SQL table RECON_MGR_TEMP to store transactions that are being worked on and for communication of this data to the Report Manager.

The single table is used for all Reconciliation Manager sessions and the various transactions are identified by operator code and an 'instance' field which identifies the current session.

In normal circumstances at the end of the session all the transactions for that session are marked as 'to be deleted' but are left so that the final report can make use of the data. On entry for the next session Reconciliation Manager deletes all transactions in the table for that operator that have been marked as 'to be deleted'. This means that the table should only ever contain a few sets of transactions which are, in effect, waiting to be deleted. The deletion is not an essential action of Reconciliation Manager and if there is nothing to delete the session begins anyway.

However, if the system crashes in Reconciliation Manager the transactions would not have been marked 'to be deleted', they would not be deleted by the next Reconciliation Manager session, and so remain in the table. They will not affect subsequent processing because for a new session for the operator, a new value of the 'instance' field is used to identify those transactions for the current session, but they may be viewed as undesirable. These unwanted transactions can be removed by deleting the contents of the RECON_MGR_TEMP table provided that Reconciliation Manager and its report are not running at the time.