UPlan Enhancements

This page lists all upcoming and previous enhancements made to UPlan that were announced in a previous Weekly Digest. The dates reflect which Weekly Digest the enhancement was announced in, and are linked to the specific UPlan Weekly Digest.

2019-20

+UCPath Job Codes and Composite Benefit Rates (CBRs)

The UCPath job codes and Composite Benefit Rates (CBRs) are now appearing in Employee Planning. They will be available for planning after the UPlan annual maintenance in August. Although the new job codes and benefits accounts now appear on the forms, you should continue planning on the old Title Codes and benefit accounts for the remainder of the current planning season. To understand the changes that are coming for the next planning season, read about the new accounts below.

All references to forms and accounts below are in the context of the Employee Planning Individual Forms. The same accounts are included in the changes made to the Multi-Employee Forms and TBH Empl Forms.

Employee Planning changes for 2020-21 planning season:

  • NEW: The CBR account is called “Benefits %”
    • The account is read-only on the Empl Sal&Ben Level form.
    • The account is updated nightly from UCPath. The nightly rate is brought into the Forecast, and will soon be brought into the Plan.
    • For employees in the Faculty Tenure, Faculty Non-Tenured, Management, and Academic and Staff General CBR groups, you will see the UPlan Planning Rate in the Individual Employee Sal&Ben Level form. The planning rate is slightly lower than the real CBR charged to the department to account for the VLA credit to the department when the employee takes vacation.
    • For HCOMP-eligible employees, the Benefits % includes the 1.25% Faculty childbearing/childrearing assessment.
    • The Base&Neg Benefits % and Adj, Addtl Benefits % and Adj, and Fac Bon&Incv (BYZ) Benefits % and Adj accounts are going away. Between now and UPlan annual maintenance in August, you will see the current year Forecast populated with actuals in these old accounts from July through April in the PPS Title Codes. May and June will have actuals populated in “Benefits %” in the UCPath Job Codes. The old accounts will be removed from the form during the annual maintenance in August.

      Screenshot of Empl Sal&Ben Level form with PPS Title Code and UCPath Job Code

  • NEW: Modify the “Benefits %” using “Benefits Adj (%)”
    • The account is writable on the Empl Sal&Ben Level form. It will override the Benefits % account if there is a value in the cell, and calculates on the “New Base&Neg Salary” account.
  • NEW: Benefits ($)
    • The account is read-only on the Empl Sal&Ben Level form. The account is the result of either the “Benefits %” or “Benefits Adj (%)” multiplied by the “New Base&Neg Salary”. Since a benefits subtotal account already exists (see below), this account will be removed from the form during annual maintenance in August.

      Screenshot of Empl Sal&Ben Level form with Benefits ($) account

  • UPDATE: Benefit $ Totals
    • The account existed prior to the enhancement, is read-only, and is a subtotal of Base&Neg Benefits ($), Addtl Benefits ($), Fac Bon&Incv (BYZ) Benefits ($) and now, Benefits ($). Since the Base&Neg, Addtl, and Fac Bon&Incv benefit accounts are going away, this account will only reflect Benefits ($) going forward for the UCPath Job Code.
  • UPDATE: UCPath Job Codes appear in addition to PPS Title Codes
    • The UCPath Job Codes are six digits and appear alongside the PPS Title Codes for each employee. In UPlan, the Job Codes are identical to the title codes except with ‘J00’ prefixed instead of “T”. Any % effort planned on the PPS Title Code in the “Base&Neg Dist (%), Addtl Dist (%), or Fac Bon&Incv (BYZ) Ben Dist (%) accounts will be mapped to the UCPath Job Code during annual maintenance in August.
    • PPS Title Codes will be removed from the form during annual maintenance in August.
  • NEW: Ben Dist ($)
    • The account is read-only on the Empl Distr Ben $ form.
    • For open months, the account is the result of “Base&Neg Ben Dist ($)” + “Addtl Ben Dist ($)” + “Fac Bon&Incv (BYZ) Ben Dist ($)”.
    • For actual months, the account is the lump sum total found in the UCPath Labor Ledger for that Employee-Job Code combination. In UCPath, the ERN code is no longer included in Payroll actuals, therefore benefit $ cannot be discernable by “Base&Neg”, “Addtl/Other”, and “Fac Bon&Incv (BYZ)”.
+Faculty Portfolio Integration in UPlan

With the implementation of UCPath on June 1, 2020, UCSF will retire the Faculty Portfolio Projection tool. The nightly FP Feed to UPlan was turned off in General and Employee Planning, and all FP forms were removed from the Task List.

2018-19

+Weekly UPlan Forecast Export to MyReports

Announced on APril 26, 2019

The automated export of the UPlan forecast to MyReports will occur weekly every Friday instead of the 14th calendar day of each month. The forecast data will be available in MyReports on the following Monday.

2017-18

+Planning by Project

Announced on February 9, 2018

Ability to plan for individual projects that are Sponsored, Retention, Recruitment, Other Faculty/PI, and Capital projects rather than as aggregated UPlan-only project IDs.

2016-17

+Enhancements made to streamline the Employee Planning Forms

Announced on April 28, 2017

  1. The “Benefit Global Assumptions” form has not been used to date and has been removed from the Task List.
  2. The “Empl Salary” and “Empl Benefits” tabs on the “Search Individual Empl” form have been combined into a single tab and is now named “Empl Sal&Ben Level”.
  • All relevant accounts are now displayed on the rows of the new “Empl Sal&Ben Level” for all employee/title code combinations.  This eliminates the need for the "Add/Remove Account" right-click menu item, which has been removed from the form.
  • The following accounts are no longer available on the new “Empl Sal&Ben Level” tab.  These accounts were available in the old “Empl Salary” and “Empl Benefits” tabs but are being removed since they have not been used to date:
    • UCSF Pay
    • Non-UCSF Pay
    • Base&Neg Ben Incr %
    • Addtl Ben Incr %
    • Fac Bon&Incv (BYZ) Ben Incr %

Image of the Search Individual Empl form.

+Fcst Apprd – Rev & Exp Level C Form

Announced on March 30, 2017

Forecast Approved Revenue and Expense level C form is now avai lable in UPlan web and Smart View. This version omits the Current Year Actual Final and adds the Current Year Forecast Approved column. Both the current Revenue and Expense level C form and the new Forecast Approved Rev & Exp form are now below a “Revenue and Expense – Level C” folder.

To access the two versions of the Revenue and Expense Level C form, follow the below steps:

  • In UPlan Web:  Navigate to My Task List > General Planning > Revenue and Expense - Level C

Revenue and Expense - Level C form

Screenshot of the UPlan Web Revenue and Expense Level C form.

Fcst Apprd - Rev & Exp Level C form

Screenshot of the UPlan Web Forecast Approved Revenue and Expense Level C form.

  • In Smart View:  Navigate to Smart View ribbon in Excel > click on the Panel bu tton > Shared Connections > Select Server to proceed drop down menu > Select Oracle Hyper ion Planning, Fusion Edition – Prod > Expand uplan.ucsf.edu > UPlan > Task Lists > General Planning > 1.0 Revenue and Expense – Level C folder

1.1 Revenue and Expense - Level C form

Screenshot of the Smart View Revenue and Expense Level C form.

1.2 Fcst Apprd - Rev & Exp Level C form

Screenshot of the Smart View Forecast Approved Revenue and Expense Level C form.

+Net Position – Beginning of Period for FY17

Announced on March 24, 2017

The beginning balance for FY17 Actual Final, Forecast Working and Plan Final have been updated on March 21 to match MyReports Actual Final.

Screenshot of the beginning balance for FY17.

+Add and Remove DFP Rows

Announced on March 10, 2017

Planners now have the ability to add and remove blank DFP rows in the “Account Detail by DFP” form. This new feature allows planners to create and plan for new DFP’s within the form and eliminates the need to navigate back to the “Revenue and Expense – Level C/E” form to plan for new DFP combinations.

 

  • To add a DFP
  1. Navigate to My Task List > General Planning > Revenue and Expense – Level C/E.

    Screenshot of the Revenue and Expense form.

  2. Right-click on the account you want to add a DFP to and choose “Account Detail by DFP."

    Screenshot on how to navigate to the "Account Detail by DFP" form.

  3. Right-click anywhere on the Project column and choose “Add DFP.” This will bring up a prompt for you to create a DFP.

    Screenshot on how to add a DFP.

     

    Screenshot of the DFP prompt window.

  • Remove a DFP
  1. Verify that the DFP has no data in it.
  2. Right-click anywhere on the Project column and choose “Remove DFP.”

    Screenshot on how to remove a DFP.

+Total Comp and Total Non Comp accounts now available in Revenue & Expense Forms

Announced on February 24, 2017

Planners are now able to view the subtotals for Total Compensation and Total Non Compensation directly on the Revenue & Expense forms. The subtotals are children of Total Expense.

  • Total Comp – A subtotal of Accounts 5000C/E through Staff benefits adjustment for Faculty, Non-faculty academic and Staff salaries and benefits.
  • Total Non Comp – A subtotal of non-compensation expense accounts.

Screenshot of Total Comp and Total Non Comp accounts in the Revenue and Expense form.

+Project Dimension with updated Descriptions and Project Uses

Announced on February 10, 2017

On February 7, we implemented a one-time update to Project Description and Project Use in UPlan. The changes now reflect how these fields appear in PeopleSoft. The process for future project chart field changes will be announced at a later time. For project use changes from/to the FP planning only projects, the actuals for the current year going back to July may be impacted. If your DFP was impacted, depending on the dollar amount, you may want to adjust your Forecast. See your control point coordinator for further information.

+Career Tracks Title Code Mapping

Announced on January 27, 2017

Career Tracks title code changes that occurred in November 2016 have been implemented in UPlan to show historical and forecast data exclusively on employees’ new title codes.  Changes were implemented from the most recent singular old title code to the new, so that the majority of these employees now have a single title code for planning.  These changes exclude:

  • Old title codes with July to November 2016 expenses.  These will appear for employees along with their current Career Tracks title code.  Examples include employees who may have been reclassified, changed positions, or had other similar changes prior to Career Tracks.
  • Payroll Expense Transfers (PETs) that impact any period before November 2016.  These will show the retroactive change on the relevant old title code at the time when monthly actuals are loaded.
  • Employees whose changes are in the December through January round of changes.  These have not been finished in PPS and are therefore not complete in UPlan.

Career Tracks changes from the January reconsideration period will be implemented in the coming weeks.  We encourage you to wait to plan for these employees until we consolidate their data to their new title codes.  If you cannot wait, continue to plan on these employees’ old title codes so that the data will be mapped accurately.

+Year to date (YTD) members in Smart View

Announced on December 22, 2016

Planners are now able to view Year to Date (YTD) data in Smart View ad hoc. The data can be accessed by zooming in (double left click) on the Period Dimension > Total Year > Q1 YTD > Jul YTD, etc. After you refresh, year-to-date data through the periods you have selected YTD is displayed.

One of four screenshots of the Year-to-Date members in Smart View.

Two of four screenshots of the Year-to-Date members in Smart View.

Three of four screenshots of the Year-to-Date members in Smart View.

One of four screenshots of the Year-to-Date members in Smart View.

+VAC DOS code now entirely mapped to Benefits in Employee Planning

Announced on November 4, 2016

The VAC DOS code for payroll in Employee Planning no longer mimics PPS (MyReports DPE) where VAC is mapped to both Salary and Benefits accounts. Now, Employee Planning matches General Planning which mimics the PeopleSoft GL where VAC is mapped entirely to Benefits. This resolves inconsistencies between the salary and benefits amounts in Employee Planning versus General Planning so that planners are not overstating benefits and understating salary when using Employee Planning.

+Account Detail by DFP form now writeable

Announced on October 28, 2016

Planners are now able to plan for multiple DFPs at the same time in the Account Detail by DFP form. The form can be accessed by right-clicking on your Revenue and Expense form and selecting Account Detail by DFP. For fastest results, do the following:

  1. Set the DFP at the highest level for your department, or the highest level you are responsible for planning. For example, if you are the planner for ITS, set the DFP to: 411101: F_IT Info Tech Svcs-Total Funds-Total Projects.

    Image shows the UPlan system with the Revenue and Expence Level E form open, with a Dept ID, Fund and Project highlighted to show users the section they need to focus on.

  2. Right-click on the account you wish to modify.

    Second step after getting to the highest level DFP (Dept ID, Fund and Project combination), users are instructed to right-click on an account and select the Account Detail by DFP form.

  3. All DFPs under the top level you specified show up for that account. Plan for multiple DFPs at a time. Save in web / Submit in Smart View.

    Image shows where the save button is when users are done editing the Account Detail by DFP form and would like to save their data. The Save button looks like a floppy disk.

  4. Toggle to a different account to plan for other multiple DFPs at the same time.

    Image shows that users are able to toggle between other accounts which saves time going back to the Revenue and Expense form.

+Function Code now available in CommtPln

Announced on October 28, 2016

Planners can now plan by Function Code for each distribution in a commitment. The Function column appears between Target Project and Long Description in the Edit Existing Commitment Form.

Image shows the the Function code column in the Manage Existing Commitments form.

It also appears in the By Source DeptID and By Target DeptID Commitment reports.

Image shows the By Source DeptID form open with the Function code column highlighted.

Image shows the By Source DeptID form open with the Function code column highlighted.

+Total Comp account now available in Revenue & Expense Form-Level E

Announced on October 28, 2016

Total Comp account now available in Revenue & Expense Form-Level E: FAS Planners are now able to view Accounts 5000E through Staff benefits adjustment as an aggregate Salaries and Benefits Total for Faculty, Non-faculty academic and Staff directly on the Revenue & Expense form.

Image shows the new Total Comp line on the Revenue and Expense form Level E.

+New Base&Neg Salary now available on the Multi-Empl Sal&Ben Level form

Announced on September 2, 2016

Planners can now view the New Base&Neg Salary account on the Multi-Empl Sal&Ben Level form for both the YearTotal and each month. This account is multiplied against the Base&Neg distribution percentages to calculate the Base&Neg distribution dollars.

Screenshot of the New Base&Neg Salary on the Multi-Empl Sal&Ben Level form.

 

 

2015-16

+To Be Hired (TBH) Employee Names

Announced on May 13, 2016

Planners now have the ability to uniquely name their TBH’s; this functionality is referred to as “Dynamic TBH” in the UPlan system. All existing TBH’s have transitioned to the new names as indicated by you and/or your Control Point. Note that existing TBH’s that were not renamed remain the same, albeit with an underscore – for example, “To be Hired 1” is now “To be Hired_1”. If you would like to change your existing TBH to a different name, you must first delete the TBH and create a new one.

The interface, steps, and forms for creating a new Dynamic TBH remain the same:

a. To access the forms, navigate to My Task List > Employee Planning > TBH Empl Forms.

Screenshot of the TBH Empl Forms.

b. To add a new TBH, navigate to the TBH Landing Page form > choose your MyOrg DeptID > right -click anywhere on the form > choose “Add TBH”. This will bring up a prompt for you to create the new TBH.

Screenshot of the Add Dynamic TBH prompt window.

The Dynamic TBH functionality has some known gaps that we are currently working with Oracle to address in future patches. Below are the gaps as well as recommended best practices:

  • Add/Delete TBH’s outside of planner’s DeptID access- We are working with Oracle to address a known issue that allows planners to add and delete TBH’s for outside of their access. Please be diligent in reviewing the TBH’s that you add or delete to ensure you are working with the correct DeptID(s). If you delete a TBH in error that does not belong to your DeptID, please contact the UPlan team for assistance.
  • All TBH names must be unique - Planners will receive an error if a particular name is already taken. Please follow the guideline indicated by your Control Point. For example, your Control Point may have you preface your TBH name with certain text such as “F_...” for FAS and “D_...” for SOD.
  • Correct Year and Scenario combination – When creating TBH’s, the correct Year and Scenario combination must be entered in the Add Dynamic TBH prompt (e.g. FY16/Forecast, FY17/Plan, FY18/Plan). If the prompt is launched with the wrong Year and Scenario combination, planners will receive an error message but the TBH member name is created in the backend. Planners will not be able to recreate the TBH with the same name until the member name is deleted by the UPlan team. If this occurs, please contact the UPlan team to delete the TBH.
  • Use of some special characters could create some issues in Smart View Essbase for ad hoc reporting - Please avoid having spaces before/after a dash (-), using back slashes (/), or using forward slashes (\).
  • Smart View Essbase - The new TBH name will not be reflected in Essbase (“UPlan-Empl” or “EmplRpt”) for ad hoc reporting until the next day.
+Employee Year 2 Planning

Announced on May 6, 2016

Year 2 Plan Working (i.e. 2017-18) is now available in all data entry forms and reports in Employee Planning. Planners have the ability to view and edit Year 2 data as needed. Prior to this enhancement, salary and benefits distribution data for Year 2 flowed “behind the scenes” to General Planning upon seeding/integrating Year 2 employee data. Note that while seeding Year 2 for employee data is still highly recommended for streamlining workload processes, Control Points and planners have the option to plan directly in Year 2 without seeding. Please contact your Control Point Coordinator if you have questions on seeding for Year 2.

+Drill Through for Historical Forecast Detail

Announced on April 15, 2016

Drill Through has been implemented in the Forecast Working column to see historical monthly forecast snapshots sent to MyReports on the 14th calendar day starting with the February and March 2016 forecasts (April is coming soon). To view the historical snapshot from any DFP:

  • In UPlan Web: click any intersection in Forecast Working with a triangle > navigate to the UPlan Edit > Drill Through > Feb/Mar/Apr Forecast.

    Image shows how users would access Drill Through technology while in UPlan.

  • In Smart View: Planners have two options to view the detail:
  1. Click any intersection in Forecast Working with a green border > navigate to the Planning ribbon > Drill Through > Feb/Mar/Apr Forecast

    Image shows how users would access Drill Through technology while using Smart View.

  2. Right-click on any intersection in Forecast Working with a green border > Smart View > Drill Through > Feb/Mar/Apr Forecast

    Image shows how users would access Drill Through technology while using Smart View and upon right-clicking a cell with a green highlight around it.Image shows the secondary menu users will see upon right-clicking a cell with a green highlight. The image shows that Drill-through is highlighted and should be selected.

    Image shows the prompt users will see when in Smart View, and after selecting Drill-through. The image shows that users should select their FEB or MAR forecast (as an example, the months change depending on time of year).

+Drill Through for “Planning by Project” Detail

Announced on April 15, 2016

Drill Through has been implemented in Actual Final and Forecast/Plan Working to see ProjectID level detail for projects below “FP Projects” in the UPlan project hierarchy. This enables planning by individual project IDs for sponsored, recruitment, retention and other faculty/PI/owner activity projects. A new training manual has been created and there will be three webinars to demo how to use the new features next week. See the announcements section for webinar details.

  • In UPlan Web: Drill Through is enabled in the Actual Final and Forecast/Plan Working columns on the R&E forms. Intersections allowing drill through have two black lines creating a triangle in the upper-right corner. To view the detail, click any intersection with this triangle > navigate to the UPlan Edit > Drill Through > Lvl C/E or F Drill.

Image shows the menu users would see when accessing Drill Through Planning by Project supporting detail upon right-clicking the highlighted cell when using Smart View.

  • In Smart View: Drill Through is enabled in the Actual Final and Forecast/Plan Working columns on the R&E forms. Intersections allowing drill through have green border lines.  Planners have two options to view the detail:
  1. Click any intersection with a green border > navigate to the Planning ribbon > Drill Through > Lvl C/E or F Drill

    Image shows how users would access Drill Through Supporting Detail when using Smart View.

  2. Right-click on any intersection with a green border > Smart View > Drill Through > Lvl C/E or F Drill

    Image shows the menu users would see when accessing Drill Through Planning by Project supporting detail upon right-clicking the highlighted cell when using Smart View.Image shows the secondary menu users will see upon right-clicking a cell with Drill Through Planning by Project supporting detail behind it. It shows that users should select Drill through.

    Image shows the prompt they will receive after selecting Drill Through in the secondary menu.

+New Account Detail by DFP

Announced on March 18, 2016

Planners now have the ability to drill down to the “Account Detail by DFP” report to view the planning-level DFPs for a particular Account from any DFP level in the Revenue and Expense – Level C/E forms. This new feature allows planners to quickly view the detailed amounts for an Account at a higher level DFP.

To access the Account Detail by DFP:

  1. Go to General Planning ->Revenue and Expense – Level C/E
  2. Select and go to DFP at any level.For example, D100000-Total Funds-Total Projects
  3. Right-click on the desired account and select Account Detail by DFP
  4. The report will appear showing all the DFP that has data for that specific account chosen.
+General Planning Global Assumptions

Announced on March 18, 2016

When seeding Year 1 and 2, the Global Assumptions calculations in General Planning now include Accounts 5300C: Occupancy Expense and 5320C: Utilities in the seeding rules. UPlan Job Aid 209 has been updated to reflect the change.

+New FR reports with Tfr Accounts Together

Announced on March 4, 2016

All Hyperion FR reports at account level C are now available with consolidated views of COA and corresponding Tfr accounts added together in UPlan web and Smart View.

  • In UPlan Web: Navigate to the Explore button > Click on General Reports – Tfr Accounts Together > Double-click on the report you wish to see. In the example below, General state appropriation is the total of 4000C and Tfr state appropriation. You can expand each line to show the COA account and corresponding Tfr from CmmtPlan. You can export these reports to Excel or access them directly in Smart View. Note: If you want to see the children accounts expanded you must expand them before exporting to Excel.
  • In Smart View: Navigate to Smart View ribbon in Excel > click on the Panel button > Shared Connections > Select Server to Proceed drop down menu > Select Reporting & Analysis Framework > Expand http://hyperwebprod04:19000/raframwork/browse/listSML server > Expand General Reports > Tfr Accounts Together folder > Double-click on the report you wish to see. In the example below, General state appropriation is the total of 4000C and Tfr state appropriation. If you want to see the children accounts expanded you must expand them in the Preview Screen before clicking Finish. If you wish to modify the report after clicking Finish, simply open the report again (double click it) in the Smart View panel, expand the lines you wish to see, click Finish.
+Sponsored Project Revenue Account

Announced on January 29, 2016

The 4500C: Sponsored project revenue_C account on the Revenue and Expense – Level C form in General Planning was previously auto-calculated but is now writable.