Navigate Here: Reports > CIP Planning Reports > Funding Reports > Expanded Program Source And Use
Expanded Program Source And Use Report is an expanded version of report on capital projects sorted by program in a specific filtering phase.
You can configure the below settings before viewing the report. These settings will affect the content and layout of the report.
Filtering Phase: Select a filtering phase that determines the funded projects in the report. Please note each filtering phase has its own funded and unfunded project list and carries its own set of funding allocation numbers. The default is the current working filtering phase using your working cycle and working scenario. If you do not have the right to set the working cycle and working scenario, then your working cycle and working scenario will be the same as the system default. For further information on working scenario, system default scenario, working cycle, and system default cycle, please visit the Cycle and Scenario section under the Utilities module.
Program: Select whether to contain projects in all programs or only in a specific program. This will filter the Subprogram list.
Subprogram: Select whether to contain projects in all subprograms or only in a specific subprogram.
Department: Select whether to contain projects in all departments or only in a specific department.
Group the years after the first 5 years: If you select "Yes", the financial data for the first five years will be presented in detail, while the remaining years in the cycle will be grouped together. If you select "No", no years will be grouped, but you must specify how many years will be shown in Number of years. You can choose between 5, 6, 7, and 10 years.
You can set the Page Number Format and the Starting Page Number in the report. The Page Number Format allows you to enter text, symbols, or numbers to help display the page numbers on the report. For example, if you wanted to include the word “Page” before each number you would enter this in the first format text box. The page numbers would appear as “Page 1”, “Page 2”, etc. The Starting Page Number allows you to modify the starting page on your report. This is used for display purposes only, and will not affect the output of the report. The default starting page number is 1.
Once you have finished, click the View Report button to open the report in a new window. Once the report is opened there are a number of features on the top navigation bar. You can export the report to PDF, Excel, Word, or RTF format by selecting the Export button. You can also navigate to another page using the page arrows, refresh the report by clicking the Refresh button, and adjust the zoom percentage of the report by selecting a different percentage in the dropdown box.
Below are the descriptions of the content contained in this report:
Project ID: This is the Project ID field on the Project General Information form.
Subprogram: This is the Subprogram field on the Project General Information form.
Project Name: This is the Project Name field on the Project General Information form.
FY 20NN - NN Projected: The funding allocated to each project in the year before the start of the current working cycle.
Prior Years: The total funding allocated to each project prior to FY 20NN - NN Projected.
FY 20NN - NN: These columns list the funding allocated to each project by fiscal year in the current working cycle.
N Year Total: The total funding allocated to each project during FY 20NN - NN.
Total Use Of Funds: The total funding allocated to the projects of each program.
Sources: It lists funds that allocate the funding to the projects of each program. Each fund row shows the funding amount allocated from this fund to the program.
Total Source Of Fund: The sum of the funding allocated to each program.
