MAINTAIN BUDGET REPORT TABLES

Use this screen to update the budget report tables with the budgeted data in the Total Budgets and Period Budgets menus.  These report tables are then used as the basis for any budget information that appears on the Project Status Reports. You can also use this screen to delete budget report table rows from outdated budget revisions. This delete process will clear data and free disk storage, resulting in faster processing time.

Run this process after you have entered information into the Total Budgets and Period Budgets menus. You must run this process and then the Update Project Status Report process before any budgeted information can appear on the project status report.

Select Operation

Using the drop-down list, select the type of maintenance you want performed. Valid options are:

• Update - Select this option to update the budget report tables with existing Period or Total Budget information.

• Delete - Select this option to delete rows from the report tables.

Select Periods

Fiscal Year

Using the drop-down list, select the fiscal year for which you would like to update the budget tables.

Range Option

From the drop-down list, select the range of periods you would like to update within the selected fiscal year. Valid options are:

• All

• One

• Range

• From Beginning

• To End

The default for this field is All.

From

The value entered in this field varies, depending on the range that you selected. If you selected All periods, this field is inactive. If you selected One period, enter the period in this field. If you elected to update a Range of periods, enter the starting period for the range in this field. If you selected From Beginning, this field is inactive. If you selected To End, enter the beginning period for the range in this field.

Use to select values from the appropriate table.

To

The value entered in this field varies, depending on the range that you selected. If you selected All periods or One period, this field is inactive. If you elected to update a Range of periods, enter the ending period for the range in this field. If you selected From Beginning, enter the ending period for the range in this field. If you selected To End, this field is inactive.

Use to select values from the appropriate table.

Select Projects

Range Option

Using the drop-down list, select the range of projects for which you would like to update the budget tables. Valid selections are:

• All

• One

• Range

• From Beginning

• To End

Depending on your selection, the From and To fields may not be applicable.

From

Enter, or use to select, the starting value for the range you want to include. If you select All or From Beginning in the Range Option field, this field will be inactive.

To

Enter, or use to select, the ending value for the range you want to include. If you select All, One, or To End in the Range Option field, this field will be inactive.

Process

Click this icon on the toolbar to perform the update of the budget report tables, using the parameters you selected.

Table Information

Changes to this screen update the following tables:

PSR_BUD_PD01

PSR_BUD_PD02

PSR_BUD_PD03

PSR_BUD_PD04

PSR_BUD_PD05

PSR_BUD_PD06

PSR_BUD_PD07

PSR_BUD_PD08

PSR_BUD_PD09

PSR_BUD_PD010

PSR_BUD_PD011

PSR_BUD_PD012

PSR_BUD_PD013

PSR_BUD_PD014

PSR_BUD_PD015

PSR_BUD_PD016

PSR_BUD_PD017

PSR_BUD_PD018

The data from the Total Budgets screens will reside in the TOT_BUD_AMT columns in the tables.  The specific table that is updated will depend on the selection that you make in Select Periods group box.