This document provides a comprehensive guide to using the Control Table within CMEI. Learn how to navigate, understand, and manage financial data, B&R codes, and appropriations. It's designed to help you efficiently track and control fund distribution. |
In the Navigational Menu, choose the correct fiscal year and folder for which you want to view the control table. Once the content area refreshes, hover on "Funding Information" in the menu header and click "Control Table".
|
Adjust Amounts: If you have edit privileges, you can adjust control levels and assign deductions to specific B&R codes. This allows you to manage fund allocations directly.
Copy Appropriations: With edit privileges, you can quickly transfer amounts from the Congressional Request, House, and Senate columns into the Appropriation' column using the Copy Appropriation button. This saves you time and reduces manual entry.
Budget Analysts are the only users authorized to adjust control amounts for the current execution year. This ensures financial accuracy and oversight.
Program Managers and Headquarters Technology Managers can adjust control amounts for planning years, allowing them to strategize for future financial needs.
Adding New B&R Codes: If you have the necessary permissions, you can add a new B&R code or select a previously used one for any account. Look for the Add B&R Code link under "Actions" to expand your tracking capabilities.
Check the Exclude Text Columns box to hide unnecessary textual information. Once you select this, the setting will remain active even if you navigate away, until you choose to deselect it. This helps you quickly scan the essential data.
You can also hide particular rows or columns from the Control Table by checking any combination of the following boxes:
Exclude SBIR and STTR Columns
Exclude Direct Charges Column
Exclude Congressional Request, House and Senate
To show only regular rows, remove the "Carryover" and "Prior Year Deobligation" rows that repeat for each B&R code, giving you a cleaner view of regular appropriations.
To save or open the table's contents in Microsoft Excel, click the Export to Excel button. This is useful for further analysis or reporting outside of the system.
Refine Your View: To focus on specific program, subprogram, or key activity folders, use the filtering feature:
Click the filter icon to display a dropdown list of names.
Check the names you want to include in your filter.
Click OK to save your changes, close the dropdown, and refresh the table. The table will now display only the data for your selected folders.
Clear All Filters: To remove all enabled filters at once, click the Clear Filter link that appears above the table.
You can edit a Control Table row in two ways:
Click the Edit link under "Actions" at the beginning of the specific row you wish to modify.
Alternatively, click directly into any cell displaying blue text within the row.
Adjust Appropriation Amounts: Modify the appropriation amount for the selected B&R Code.
Insert Specific Values: Enter values for Congressional Request, House, Senate, SBIR, or STTR.
Manage Reductions and Rescissions: Adjust values for general reductions or rescissions.
|
To calculate amounts for general reductions, rescissions, or SBIR/STTR:
Enter the desired percentages in the appropriate fields (e.g., for reduction, rescission, or SBIR/STTR).
Click the calculate button next to the amount you want to update.
|
To efficiently move funds from legislative columns into your appropriation column:
If you need to include new or previously used B&R codes in your control table, follow these steps:
Q: Why does my Grand Total look different from my colleague's, even when viewing the same control table?
A: Your individual permissions dictate which B&R codes are visible to you. If your colleague has different permissions, they may see a different set of B&R codes.
Q: I'm a Program Manager, but I can't adjust a control amount for the current execution year. Why not?
A: Only budget analysts have the authority to adjust control amounts for the current execution year. As a Program Manager, you can adjust control amounts for planning years.
Q: I added a new B&R code, but it's not showing up immediately. What should I do?
A: Ensure you have the necessary rights to add B&R codes first. After clicking "Update Database", the system should reflect the change. If it still doesn't appear after a moment, double-check your input or contact support for assistance.
Q: I'm seeing too much information in the table, and it's hard to read. How can I simplify the view?
A: You have several options to simplify your view. You can check the "Exclude Text Columns" box to hide unnecessary textual information. Additionally, you can use the various checkboxes to "Exclude SBIR and STTR Columns", "Exclude Direct Charges Column", "Exclude Congressional Request, House and Senate", or "Show Only Regular Rows" to further customize your view. Remember that selecting "Exclude Text Columns" will keep that setting active until you deselect it.