Article: Understanding the Control Table
| Panel | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
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. |
Access the Control Table
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".
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
Manage Control Levels and Deductions
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.
- Who Can Adjust Control Amounts?
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.
Control Table Details
Customize Your View
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.
Filter Your Data
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.
Edit a Control Table Row
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.
- Either action opens a pop-up form where you can make your adjustments.
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.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
Calculate Specific Amounts
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.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
- Click Update Database to save your changes or Cancel to discard.
Copy Funds from Congressional Request, House, and Senate
To efficiently move funds from legislative columns into your appropriation column:
- Click the Copy Appropriation button at the top of the control table.
- A pop-up form will appear, allowing you to select which combinations of rows and columns you want to copy.
- Use the checkboxes on the left to choose which B&R codes will be copied.
- Use the radio buttons in the middle of the grid to select which column (Congressional Request, House, or Senate) should be copied to the appropriation column.
- Once you've made all your selections, click copy. The system will then populate the selected amounts into the appropriation column.
Add a B&R Code
If you need to include new or previously used B&R codes in your control table, follow these steps:
- Click the Add B&R Code link under "Actions".
- The pop-up will initially show options to "Add a New B&R Code". You have two choices:
- Select an appropriation year, funding type, and a previously used B&R code from the available options.
- Choose to "Add a New B&R Code" directly.
- If you select "Add a New B&R Code", you will then be able to input the new B&R code, Fund Value, and STARS Program value to create the new row within the Control Table.
- After you have selected or entered your B&R code details, click Update Database to integrate the new B&R code into the control table.
Frequently Asked Questions
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.
Related Articles
| Content by Label | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
| Optics Button | ||||
|---|---|---|---|---|
|