Batch Assurance Reports

As discussed in the previous sections, a number of text reports are generated by each step of the batch programs to give you assurance that the transactions are processed in order. Each of the generated text reports is suffixed by the date and time of run. The following table summarizes the batch assurance reports generated by the batch process:

Batch assurance reports

No

Report Title

Text Report Name

Description

1

GLPE Statistics Report

glpe_ledger

Summary total and record count of approved General Ledger pending entries fed by balance type, origin code, fiscal year and period. Created by the nightlyOutJob.

2

PENDING LEDGER ENTRY TABLE)

glpe_list

Detailed listing of approved General Ledger pending entries fed. Created by the nightlyOutJob.

3

Scrubber Report STATISTICS

scrubber

Summary total number of records scrubbed and automated entries generated (offset, capitalization, liabilities, plant indebtedness, and cost share). Errors detected by the scrubber are also listed in detail. Created by the scrubberJob.

 

4

Ledger Report
)

scrubber_ ledger

Summary listing of transactions scrubbed, including GLPE and external batch feed files by balance type, origin code, fiscal year and period. Created by the scrubberJob.

5

Scrubber Input Transactions with Bad Balance Type

scrubber_ badbal

Detailed listing of transactions with bad or blank balance types. The scrubber replaces these with a balance type of AC. Created by the scrubberJob.

6

Error Listing - Transactions Remove From the Scrubber

scrubber_ errors

Detailed listing of transactions removed from 'Scrubber' including transactions pulled by the 'Demerger' process. Also includes subtotals for error entries. Created by the scrubberJob.

7

Demerger Report STATISTICS

demerger

Total number of valid and invalid transactions and scrubber-generated entries (offset, capitalization, plant indebtedness, cost share) bypassed. Created by the scrubberJob.

8

Poster Report (post pending entries) STATISTICS

poster_main

Total record count of rows deleted, inserted, and updated from in the GL tables updated by the poster. Created by the PosterJob.

9

Main Poster Input Transactions
)

poster_ main_ledger

Summary total and record count of transactions posted fed by balance type, origin code, fiscal year and period. Created by the PosterJob.

10

Main Poster Error Transaction Listing

poster_main_ error_list

Detailed listing of the error transactions along with a summary total and record count for transactions not posted. Created by the PosterJob.

11

Poster Report (Post reversal entries) STATISTICS

poster_ reversal

Summary total and record count of rows selected, deleted, inserted, and updated in the GL tables by the reversal poster. Created by the PosterJob.

12

Reversal Poster Transaction Listing

poster_reversal_list

Detailed list of transactions generated by the reversal poster along with a summary total and record count. Created by the PosterJob.

13

Reversal Poster Input Transactions

poster_ reversal_ ledger

Summary total and record count of transactions that generated reversals by balance type, origin code, fiscal year and period. Created by the PosterJob.

14

Reversal Poster Error Transaction Listing

poster_ reversal_ error_list

Detailed listing of error reversal transactions along with a summary and record count for transactions not posted. Created by the PosterJob.

15

ICR Generation Report STATISTICS

icr_ generation

Summary total and record count of rows selected, deleted, and kept from the GL Expenditure Transaction table and the record count of ICR transactions generated. Created by the PosterJob.

16

Poster Report (Post ICR entries) STATISTICS

poster_icr

Total record count of rows deleted, inserted, and updated in the GL tables by the ICR poster. Created by the PosterJob.

17

ICR Poster Input Transactions

poster_icr_ ledger

Summary total and record count of ICR transactions generated by the ICR poster by balance type, origin code, fiscal year and period. Created by the PosterJob.

18

ICR Poster Error Transaction Listing

poster_icr_ error

Detailed listing of ICR error transactions along with a summary and record count for transactions not posted. Created by the PosterJob.

19

Sufficient Funds Rebuilder Report Statistics

sufficient_funds

Detailed listing of sufficient funds errors (if any) and a summary of records read, deleted, converted or retained due to errors by the sufficient funds rebuilder process. Also records the number of entries added, deleted and updated in the sufficient funds table. Total and record count of Sufficient Balance Table rows selected, deleted, updated, and inserted. Created by the sufficientFundsJob.

20

GL Summary for Fiscal Year, Balance Type of CB/BB/MB

gl_summary_bud

Beginning, annual, monthly and accumulated balances by fund group for budget balance types. Created by the posterSummaryReportJob.

21

GL Summary for Fiscal Year, Balance Type of AC

gl_summary_act

Beginning, annual, monthly and accumulated balances by fund group for the AC balance type. Created by the posterSummaryReportJob.

22

GL Summary for Fiscal Year, Balance Type of EX/IE/PE/CE

gl_summary_enc

YTD Balance by fund group for the encumbrance balance types. Created by the posterSummaryReportJob.

23

Poster Output Summary

poster_ output_ summary

Summary debit, credit, budget, and net amount total by balance type, fiscal year, period code and fund group. Created by the posterSummaryReportJob.

24

Collector Reports

collector

Summary of all files processed by the collector, a list of all errors from collector transactions, statistics for records read and in error, and an input summary of all valid transactions by balance type, origin code, fiscal year and period code. Created by the CollectorJob.

 

Description: exclaim     The delivery mechanism of these reports depends on the implementing institution.

More:

General Ledger Automated Balancing