Understanding Data Revisions to the Staging Tables

If you have data that did not map correctly from the flat files to the staging tables (F09610 and F09611) when you ran the Process Automatic Bank Statements Flat File program (R09600), perform one of these tasks:

  • Fix the errors and run the R09600 again.

  • Revise data in the staging tables using the Revise Electronic Bank Statement Staging program.

    Some fields in the staging tables are disabled and the system does not allow you to revise data. Other fields in the staging tables can be revised. You use a processing option to control which of these fields can be revised.

You can only revise data in the staging tables; you cannot add or delete records. When you revise data that is in error, the Revise Electronic Bank Statement Staging program validates the data to ensure that the beginning balance and transaction amounts equal the ending balance for a bank statement.

The staging tables include audit fields that are used for tracking and security purposes. Records that are revised in the staging tables are tracked for internal audit purposes.