CREATE C/SSR REPORT TABLES

Use this screen to create the report table from which the C/SSR will print. You must execute this process for the projects and subperiods for which you want a C/SSR. You can select only those projects that have been entered in the Maintain C/SSR Information screen (Projects » Budgeting and ETC » Maintain C/SSR); however, the system will insert a row for each branch of the project tree selected into the RPT_CSSR_LN table. You can then specify the number of levels that you want to print on the report in the Print C/SSR screen (Projects » Budgeting and ETC » Maintain C/SSR).

Create report tables after entering all budget information in the Maintain C/SSR Budgets screen or uploading it with the Upload C/SSR Budgets screen (Projects » Budgeting and ETC » Maintain C/SSR). To ensure the most current data, run this function after you have executed the Compute Burden Cost screen (Projects » Cost and Revenue Processing » Project Cost Processing).

Select Project

Use the fields in this group box to limit which projects will have tables created for them.

Range Option

Use this drop-down list to select the range of projects to be included in the C/SSR reports. Each project tree will be presented on a separate report. Valid options are:

The default for this field is All.

From

Enter, or use to select, the first project of the range to include in the C/SSR reports. If you select All or From Beginning in the Range Option field, this field will be inactive. Only projects that have been entered in the Maintain C/SSR Information screen (Projects » Budgeting and ETC » Maintain C/SSR) will be available for .

To

Enter, or use to select, the last project of the range to be included in the C/SSR reports. If you select All, One, or To End in the Range Option field, this field will be inactive. Only projects that have been entered in the Maintain C/SSR Information screen (Projects » Budgeting and ETC » Maintain C/SSR) will be available for .

Select Ending Subperiod

The C/SSR is a cumulative report; use this group box to select project data for all subperiods up to and including the subperiod selected.

Fiscal Year

Select the last fiscal year to be included in the calculation of the report table.

Period

Select the last period to be included in the calculation of the report table.

Subperiod

Select the last subperiod to be included in the calculation of the report table.

Select Rate Type

Target

Select this option to use target rates on the report. The target rates are found in the Pool Rates subtask of the Cost Pools screen (Projects » Cost and Revenue Processing » Cost Pool Setup).

Actual

Select this option to use actual rates on the report. The actual rates are found in the Pool Rates subtask of the Cost Pools screen (Projects » Cost and Revenue Processing » Cost Pool Setup).

Data Source

Use this group box to include Project Period Budgets in the work-scheduled or work-performed areas of the C/SSR Budgets.

Work Scheduled

Use this group box to use the Project Budgets by Period screen as the data source for the work-scheduled area of the C/SSR Budget.

Use Period Budgets

Select this check box if work-scheduled data for the selected projects will come from the period budgets created in the Project Budgets By Period screen. If you do not select this check box, the work-scheduled data will come from the Maintain C/SSR Budgets screen (Projects » Budgeting and ETC » Maintain C/SSR).

Budget Revision

Use the drop-down list to select the budget revision to use in the creation of this report table. This field is active once you select the Use Period Budgets check box in this group box.

Work Performed

Use this group box to use the Project Budgets by Period screen (Projects » Budgeting & ETC » Period Budgets) as the data source for the work-performed area of the C/SSR Budget.

Use Period Budgets

Select this check box if work-performed data for the selected projects will come from the period budgets created in the Project Budgets by Period screen (Projects » Budgeting and ETC » Period Budgets). If you do not select this check box, the work-performed data will come from the Maintain C/SSR Budgets screen (Projects » Budgeting and ETC » Maintain C/SSR).

Budget Revision

Use the drop-down list to choose the budget revision to use in the creation of this report table. This field is active once you select the Use Period Budgets check box in this group box.

Table Information

Changes to this screen update the following tables:

RPT_CSSR_HDR

RPT_CSSR_LN