Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
borderColor#999999
titleColor#FFFFFF
borderWidth2
titleBGColor#085A9B
iconfalse
titleDESCRIPTION

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
bgColor#E7F6F8
borderWidth2
iconfalse

pushpin The B&R codes you see in the Control Table are based on your specific permissions. This means that the Grand Total, which adds up all the amounts on the page, might be different for you than for a colleague. Your permissions determine what you see, ensuring you only access relevant information. 

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:

    1. Click the filter icon to display a dropdown list of names.

    2. Check the names you want to include in your filter.

    3. 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
bgColor#E7F6F8
borderWidth2
iconfalse

pushpin You must edit Regular, Carryover, and Prior Year Deobligations independently using the "Edit" link on each respective row, outside of this general pop-up form. 

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
bgColor#E7F6F8
borderWidth2
iconfalse

pushpin The system calculates the Rescission based on the remaining appropriation amount after general reductions have been applied. Similarly, it calculates the SBIR/STTR amount based on the remaining appropriation amount after both general reductions and rescissions have been applied. 

  •  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.

Article: Understanding the Control Table


Content by Label
showLabelsfalse
max5
showSpacefalse
cqllabel in ("cps","control+table","budget","b-r-code","appropriation","funds")


Optics Button
macroIdtZQ4UtHlceCqB3iTmBs8s
dataJTdCJTIyYnV0dG9uVHlwZSUyMiUzQSUyMmljb25fbGVmdCUyMiUyQyUyMmJ1dHRvblNpemUlMjIlM0ElMjJtZWRpdW0lMjIlMkMlMjJidXR0b25UZXh0JTIyJTNBJTIyQ29udGFjdCUyMEhlbHBkZXNrJTIyJTJDJTIyYnV0dG9uUmFkaXVzJTIyJTNBNCUyQyUyMmJ1dHRvbldpZHRoJTIyJTNBMjAlMkMlMjJidXR0b25Db2xvciUyMiUzQSUyMiUyMzIwMzE1OWZmJTIyJTJDJTIyYnV0dG9uRm9udENvbG9yJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTJDJTIyYnV0dG9uQm9yZGVyQ29sb3IlMjIlM0ElMjIlMjMyMDMxNTlmZiUyMiUyQyUyMmJ1dHRvbkxpbmslMjIlM0ElMjIlN0IlNUMlMjJsaW5rJTVDJTIyJTNBJTVDJTIyaHR0cHMlM0ElMkYlMkZlZXJlc3lzdGVtaGVscC5lZS5kb2UuZ292JTJGc2VydmljZWRlc2slMkZjdXN0b21lciUyRnBvcnRhbHMlNUMlMjIlMkMlNUMlMjJzb3VyY2UlNUMlMjIlM0ElNUMlMjJkaXJlY3QlNUMlMjIlN0QlMjIlMkMlMjJidXR0b25OZXdUYWIlMjIlM0ElMjJ0cnVlJTIyJTJDJTIyYnV0dG9uTmV3TGluayUyMiUzQSUyMiUyMiUyQyUyMmJ1dHRvbkljb24lMjIlM0ElMjJtYXRlcmlhbC1kZXNpZ24lMkZDb250YWN0TWFpbCUyMiUyQyUyMmJ1dHRvbkhvdmVyQ29sb3IlMjIlM0ElMjIlMjNmZmZmZmYlMjIlMkMlMjJidXR0b25Cb3JkZXJIb3ZlckNvbG9yJTIyJTNBJTIyJTIzMjAzMTU5ZmYlMjIlMkMlMjJidXR0b25Gb250SG92ZXJDb2xvciUyMiUzQSUyMiUyMzIwMzE1OWZmJTIyJTJDJTIyYnV0dG9uSWNvbkhvdmVyQ29sb3IlMjIlM0ElMjIlMjMyMDMxNTlmZiUyMiUyQyUyMmlzQnV0dG9uU2hhZG93T24lMjIlM0F0cnVlJTJDJTIyYnV0dG9uSWNvbkNvbG9yJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTJDJTIyYnV0dG9uV2lkdGhEZXRlY3Rpb24lMjIlM0E0NiUyQyUyMmVtb2ppRW5hYmxlZCUyMiUzQWZhbHNlJTJDJTIyZW1vamklMjIlM0ElMjIlN0IlN0QlMjIlN0Q=