The Fiscal Constraint tab is the first tab on the Budgets interface. This tab will be selected by default. Only users with the System Administrator security role, View Fiscal Constraint permission, or Manage Fiscal Constraint permission will have access to this tab.
The Fiscal Constraint tab contains the budget information for each Fund Source per year. As projects are funded through the life of the STIP, the total values programmed against each Fund Source are compared to its corresponding budget to ensure that fiscal constraint for the year is being met. Changes to Fiscal Constraint values will not trigger a STIP action; however, all Fiscal Constraint budgeted values will be copied when a Revision is closed in order to maintain the accurate Revision History.
Filter
To filter this tab, the user can select a value in the "Year" picklist located above the table to select the year in the STIP they wish to view or edit. This filter will display the first year of the current STIP by default.
Table
Funding records in the Fiscal Constraint table will be grouped by Fund Type and Fund Subtype. To expand these groups, the user can select the caret on the left side of the desired row's header; all groups can also be expanded at once by using the "Expand All" link at the bottom left of the interface. To collapse these groupings, the user can select the caret once more or the "Collapse All" link. Only groups that have associated Fund Sources will be displayed in the interface. Each record in the Fiscal Constraint table will be defined by these columns:
| Columns | Description |
| Fund Source | A unique description of the Fund Source created through the Fund Sources interface, formatted as "Fund Code – Fund Name". The Fund Sources' display order can be defined in the Fund Sources interface. |
| Apportioned/Allocated | This field contains the apportioned or allocated amount for the particular Fund Source. A few instances affect this column:
|
| Estimated Carryover | This text field contains the carryover for the particular funding category. Only categories with Fund Type = Federal will have the option to input values. If the FMIS module is active, the current and previous year values will be calculated using information from FMIS while the remaining years will be automatically calculated using the value in the previous year’s Estimated Balance Remaining column. The user can select the checkbox to the left of the Carryover amount and override the calculated value if desired. |
| Estimated Transfer | This text field can be used to enter negative or positive numbers to indicate a transfer of funds. The total for this column must equal 0 prior to the user being able to save. Only categories with Fund Type = Federal will have the option to input values. |
| Total Available | This field is read-only and automatically calculated using the following formula: Apportioned/Allocated + Estimated Carryover + Estimated Transfer. |
| Programmed Obligations | This field is automatically calculated using the associated programmed funds for all projects matching the STIP, Year, and Fund Source. Its value will be a link that opens the Fiscal Constraint/Program Obligations Detail pop-up, listing the record details included in the reported total value. The Programmed Obligations Detail table will include the following fields: Project ID, Name, Work Phase, Program, and Amount. This pop-up can be exported to CSV or Excel if desired. |
| Estimated Balance | This field is read-only and automatically calculated by the system using the following formula: Total Available – Programmed Obligations. |
| Actual Obligations | If the FMIS module is active, this column will be visible and calculated using information from FMIS. The header for this column will be updated to display "Actual Obligations as of MM/DD/YYYY" where the MM/DD/YYYY value is the date the data was retrieved from FMIS. This field's value will be a link that opens the Actual Obligations Detail pop-up, listing the record details included in the reported total value. The Actual Obligations Detail table will include the following fields: Obligation Date, Program Code, Federal Project Number, Recipient Project Number, Project Action, Project Title, and Obligation Amount. This pop-up can be exported to CSV or Excel if desired. |
| Actual Balance | If the FMIS module is active, this column will be visible and calculated as Total Available – Actual Obligations. |
There are also two "total" rows:
| Row | Description |
| Subtotal | Each grouping will display its subtotal on the header row. |
| Overall Totals | The bottom of the table will display an overall total of all Funding Sources in the last row. |
Estimated Obligation Authority
Below the Totals row, there is an additional summary line containing the Estimated Obligation Authority. When this row's override checkbox is selected, the user can manually enter the Obligation Authority value into the field. If it is unchecked, this field will be automatically populated from FMIS. These fields make up the Estimated Obligations Authority row:
| Column | Description |
| Total Available | This contains the Estimated Obligation Authority amount for the year selected. If the FMIS module is active, the current and previous year values will be calculated using information from FMIS. The user can select the checkbox to the left of the Available amount and override the calculated value if desired. |
| Programmed Obligations | This field is read-only and automatically calculated using the associated programmed funds for all projects matching the STIP, Year, and Fund Source. |
| Estimated Balance | This field is read-only and automatically calculated by the system using the following formula: Total Available (Estimated Obligation Authority) – Programmed Obligations. |
| Actual Obligations | If the FMIS module is active, this column will be visible and calculated using information from FMIS. The header for this column will be updated to display "Actual Obligations as of MM/DD/YYYY" where the MM/DD/YYYY value is the date the data was retrieved from FMIS. |
| Actual Balance | If the FMIS module is active, this column will be visible and calculated as Total Available (Estimated Obligation Authority) – Actual Obligations. |
Auto Forecast
Auto Forecast is an additional toggle displayed above the Fiscal Constraint table for Future STIP Years. When a Future Year is selected in the "Year" picklist and the "Auto Forecast" toggle is turned on, the system will automatically set the Apportioned/Allocated values for all funds equal to the prior year. If the user enters a Forecasted Increase percentage, the Apportioned/Allocated values for all funds where the "Auto Set Budget" flag is not set will be calculated as "Prior Year amount * (1 + Forecasted Increase)". If these values are automatically populated, users will still have the option to override the forecasted value.
Other Formats
There are two other formats that the user can view the Fiscal Constraint information in:
| Control | Description |
| Pie Chart | This button opens a pie chart of the Fiscal Constraint information for the selected STIP and Year. It will include the rounded Actual Balance for each Fund group and the Total Available. |
| Export | This button opens a picklist for the user to export the table in CSV or Excel. |
Save/Cancel
When changes are made to the Fiscal Constraint tab, the user must either save or cancel these changes.
| Button | Description |
| Save | This button saves any changes made to the table. |
| Cancel | This button cancels any changes made since the last save. |
Comments
0 comments
Please sign in to leave a comment.