How to Enter Basic Commitment Data in EPBCS using Smart View


This article covers the process of entering basic Commitment data using Task 7.2 Enter Basic Commitment Data within the Resource Commitment Tracking Tool (RCTT). The task has been split into two forms: Task 7.2A Enter Basic Commitment Data - Simplified and Task 7.2B Enter Basic Commitment Data - Full. While the "Full" version is still available for viewing, this article will describe commitment data entry using the Simplified version. Please note that the following steps are for users of Excel Smart View. 

Essential Information

Next Steps

Navigating to Task 7.2A Enter Basic Commitment Data - Simplified in Smart View

  1. Open Excel workbook and connect to EPBCS Planning environment.
  2. Login using Single Sign-On.
  3. In the Private Connections Smart View panel, expand each node in the connection panel by clicking the ‘+’ symbols until you see the Task Lists folder, then click on the ‘+’ symbol next to Task Lists to populate the list of commitment tracking forms.

    SmartView Task List

  4. Double-click 7 - Create and Manage Commitments to expand the Task List. This will result in a new view in the panel.
  5. Double-click task 7.2A Enter Basic Commitment Data - Simplified to render the form in the active Excel sheet.
    SmartView 7.2A Open

Locating Commitment Record

  1. With the Task 7.2A form open in the sheet, search for the relevant CTID by using the Ctrl + F key combination.
  2. Click the Find All or Find Next buttons until you navigate to the correct Base Commitment or Reclass Commitment record.


Enter Basic Commitment Data

  1. Once you have located the correct record, select the status of the record (e.g., Active, Inactive, Completed, Hold) under CT Commitment Status.
  2. Ignore values in CT Pushed for now - this value is auto-populated based upon an action on another form, and cannot be edited within form 7.2A.
  3. Enter the name of your commitment in the CT Name field, making sure to avoid restricted special characters and line breaks.
  4. Under the CT Created By dropdown menu, select your name.
  5. Within the CT Source Notes field, enter any notes you wish to associate with the Commitment. These notes will be visible to anyone with access to the Base Commitment/Reclass Commitment record, but will not be visible to the Destination (unless they have access to the Base/Reclass record).
  6. To save what you have entered, click Submit Data within the Smart View Excel ribbon.

    NOTE: When you make any edits to the form, the cell you are editing will turn light orange. When you click on the Submit Data button, the cell will turn back to pale yellow to indicate that the data has been submitted to the database.

    SmartView 7.2A Submit
  7. If you need to enter data for multiple CTIDs, repeat Steps #1-6 as needed.
  8. When ready to enter additional Commitment details (e.g., Commitment Amount, Destination chartstring, Start/End dates), locate the relevant CTID and right-click on that cell to open the Action Menu.
  9. Select Smart View located at the bottom of the Action Menu, and select one of the Details Time Horizon views. Generally, you will want to select a View that encapsulates the duration of your Commitment (i.e. select Details 1 Year Horizon for a One-Time Commitment in the current FY, or Details 5 Year Horizon for a One-Time Multi-Year Commitment spanning between 3 and 5 years).
    SmartView 7.2A Action Menu

  10. This selection will generate Task 7.3 Enter Commitment Details where you can enter additional information and take action on your Commitment.


If you need any additional assistance, please submit a ticket here.