Report Jobs

The Budgeting area includes batch jobs that are listed under several different areas in the Batch Catalog. The report jobs are listed alphabetically in the below table and the last column indicates the location in the Batch Catalog. For detailed information on the jobs (such as when to run, input, output, and process parameters) refer to the associated run sheet in the following user guides: CGI Advantage - Budget Control Run Sheets, CGI Advantage - General Accounting Run Sheets, CGI Advantage Financial - Utilities Run Sheets, and CGI Advantage Financial - System Assurance Run Sheets.

Job Name

Description

Batch Catalog Section

Budget Roll

When preparing to run the Budget Roll Chain in Modes 1, 2, or 3, this report is available to list what lines will be selected in the source year. By choosing the Report as the Roll Mode on the Parameters for Budget Roll Process (PBRP) page, selection logic will occur, but transaction creation does not happen. From that selection logic a report is produced that will show all lines in the source year that will be selected.

Budget

Budget vs. Actual Exp

The Budget vs. Actual Report for Expense is a sample report configured to work with budget structure 29 only. The report lists each Object for a Fund, Department, Appropriation, and Unit combination. Columns exist showing the Current Budget amount as Exp Budget, along with totals for Encumbered, Accrued Expenses, and Cash Expenses for both the current period as well as inception-to-date. The report ends with a Difference column showing what would be unobligated.

Records are displayed with summary totals as rollups are presented at:

  • Fund, Department, and Appropriation

  • Fund and Department

  • Fund

  • All budget lines

General Accounting

Budget vs. Actual Rev

The Budget vs. Actual Report for Revenue is a sample report configured to work with budget structure 30 only. The report lists each Revenue Source for a Fund, Department, and Unit combination. Columns exist showing the Current Budget amount as Rev Budget, along with totals for Billed Earned Rev and Collected Earned Rev for both the current period as well as inception-to-date. The report ends with a Difference column showing what would be the difference of the total billed and collected from what was budgeted.

Records are displayed with summary totals as rollups are presented at:

  • Fund and Department

  • Fund

  • All budget lines

General Accounting

Pre-Archive Budget Report

This report helps to identify unfinished budget activity. The most common use for the report is before running the Budget Archiving chain job, which archives data from budget tables. An alternative use for the report is at year end to find pending activity for which a decision should be made to complete the activity or it will fail when the final approval is applied. Lastly, the report can be run on an ad hoc basis to review one or more budget lines.

Utilities

System Assurance 01
(chain) or SA01 Report

 

The SA01 Report, produced separately or as part of the chain, lists all budget lines or only those with an accounting amount that is not in sync with historical transaction records.

System Assurance

System Assurance 11

System Assurance 11 produces a report listing all budget lines or only those with a budgeting amount that is not in sync with the Budget Journal.

System Assurance

System Assurance 12

System Assurance 12 produces a report listing each budget line with one or more Constraint Amount records that do not reflect amounts found on the budget line.

System Assurance

System Assurance 15

System Assurance 15 produces a listing of budget lines where an accounting amount on the budget line does not reflect the total open amounts of accounting lines against the budget line and amount.  The report will also list all journal postings against those open accounting lines to determine what the open amount should be.

System Assurance

Budget Structure 90 Activity System Assurance

The Budget Structure 90 Activity System Assurance batch job produces a report listing budget lines where the stand alone (not calculated) amounts do not match between Budget Structure 90 Level 2 (BQ90LV2) and the Detail Activity Inquiry.

Budget