Database Integrity Checking problem? How?

I have an import routine to take an ASCII file and import it into ORACLE tables.

From these tables I do a small check on the data via a Validation Check Flag and
then depending if it set to less than 3 I MOVE this data into the FINAL tables.

From these FINAL Tables I run extraction routines to split/merge record types into
Financial Records and post into another DATABASE/Tables.

Problem:
How can I put in place that the records I have fed into the FINAL tables has been extracted and posted
into the FINANCE Tables.

I have thought of calculating a sum value on the DATABASE and when ever there is change I
take/add to the DATABASE Value but this is not 100% fool proof. Has anyone done this type of Data Flow Integrity Checking before?

*~~~~~~~~~~~~~~~*


* Ken                       *


* ICQ 34477742       *

• not1.demon.co.uk * *~~~~~~~~~~~~~~~*