linear_scale How To

Forecast in CMS

CMS allows you to create modified hard salary commitments for forecasting purposes. This page provides instructions for forecasting a change to employee distribution of effort, leave, other compensation, a change in salary, mass salary increase and a change to employee FTE percentage.

Forecast Change to Employee Distribution of Effort

You can forecast a change of effort to a different account (PTA). You can also forecast a change in percentage of effort associated with that employee. You will see all pay lines associated with an employee even if you do not have "authority " over all pay lines. You can only edit those lines for which you have authority for. Because of this the Dist % can total over 100%.

Employee records must exist in PeopleSoft and Oracle Labor Distribution in order for information to be available in CMS for forecasting and reporting purposes

  1. Enter ofweb.stanford.edu in the browser
  2. Click Login
  3. As prompted, log in using SUNet ID and password

  1. Click SU CMS USER

  1. Select the People tab
  2. Enter search criteria in the Manage People screen Search criteria can be by name of person, HR Org, or attributes of the PTA(s) paying them
  3. Select Go – Execute Your Search

  1. Select Assignment No./Student ID link
  2. Select Salary Distribution tab from the People Planning by Person – Employee screen
  3. Modify salary distribution in one of the following ways:
    • Edit the existing field values (Project-Task-Award, Exp Type, Commit Start Date, Commit Stop Date, and/or Dist %)
    • Add Line(s) and enter new field values
    • Copy Line and edit field values
    • Remove Line as needed
  4. Select Save
What Happens Next?
  • To remove forecasted changes, select the Reset CMS to match Hard button. This will reset all salary distribution lines to match current Hard Commitment data from PeopleSoft and Oracle Labor Distribution. Note that in order to use the Reset To Match Hard functionality in CMS, you must have salary update authority over all of an employee's schedule lines within the CMS Commitments section; otherwise, the Reset To Match Hard button will be grayed out.
  • You can view the new forecasted salary in the People > Monthly Spread tab and on the Account Overview screen from the Accounts tab.

Forecast Change to Leave

Leave is generally represented as credit to expense. CMS calculates leave credit based on salary, working days in a month, and number of days of leave (to be taken).

  1. Enter ofweb.stanford.edu in the browser
  2. Click Login
  3. As prompted, log in using SUNet ID and password

  1. Click SU CMS USER

  1. Select the People tab
  2. Enter search criteria in the Manage People screen Search criteria can be by name of person, HR Org, or attributes of the PTA(s) paying them
  3. Select Go – Execute Your Search

  1. Select the Assignment No./Student ID link from the search results
  2. Select Leave tab from the People Planning by Person – Employee screen
  3. Select Add Line
  4. Select Leave Type from the drop-down box
  5. Click calendar icon to select Start Date
  6. Click calendar icon to select Stop Date 
    Calculated Salary Credit is displayed. If further edits are made, click Calc button to re-calculate salary credit.
  7. Select Save and Update PTA Distribution
What Happens Next?
  • View the leave forecast in the People > Monthly Spread tab.
  • View the leave credit on the Account Overview screen from the Accounts tab. Forecasted leave shows as a credit to (or against) the leave expenditure type.

Forecast Change to Other Compensation

In CMS, Other Compensation mirrors earning codes in Oracle, and includes bonus, housing allowance, supplemental pay and other compensation.

  1. Enter ofweb.stanford.edu in the browser
  2. Click Login
  3. As prompted, log in using SUNet ID and password

  1. Click SU CMS USER

  1. Select the People tab
  2. Enter search criteria in the Manage People screen Search criteria can be by name of person, HR Org, or attributes of the PTA(s) paying them
  3. Select Go – Execute Your Search

  1. Select the Assignment No./Student ID link for the person for whom you are forecasting compensation
  2. Select Other Compensation tab from the People Planning by Person – Employee screen
  3. Select Add Line
  4. Enter or search for Project, Task, Award
  5. Select the Comp Type from the drop-down box
  6. Enter or search for Expenditure Type
  7. Select One-Time or Recurring
  8. Enter or search for Commit Start (Payroll Start Date)
  9. Enter or search for Commit Stop (Payroll End Date)
  10. Enter forecasted Other Compensation amount in Pay Period Amount
  11. Enter Notes (optional)
  12. Select Save
What Happens Next?
  • You can view your Other Compensation forecast in the People > Monthly Spread tab.
  • View the Other Compensation forecast in the Accounts Overview screen from the Accounts tab as a credit to the Other Compensation expenditure type.

Forecast Change in Salary / FTE Percentage

Employee records must exist in PeopleSoft and Oracle Labor Distribution in order for information to be available in CMS for forecasting and reporting purposes.

  1. Enter ofweb.stanford.edu in the browser
  2. Click Login
  3. As prompted, log in using SUNet ID and password

  1. Click SU CMS USER

  1. Select the People tab
  2. Enter search criteria in the Manage People screen Search criteria can be by name of person, HR Org, or attributes of the PTA(s) paying them
  3. Select Go – Execute Your Search

  1. Select Employee Assignment No./Student ID link
  2. Select Salary / FTE tab from the People Planning by Person – Employee screen
  3. Select Add Line
  4. Click calendar icon to select new Salary Start Date 
    Salary Start Date must be after the most recent payroll posted date.
  5. Enter the new salary amount in the Hourly Rate/Annual Salary @ 1 FTE column (cannot be blank )
  6. Enter the new FTE percentage in the Effective FTE column (cannot be blank)
  7. Enter Notes (optional)
  8. Select Save
What Happens Next?
  • You can view the new forecasted salary in the People > Monthly Spread tab and on the Account Overview screen from the Accounts tab.

Forecast Mass Salary Increase Across an Org

A Mass Salary increase in CMS allows you to forecast a salary increase across an organization. Once you SAVE a mass salary increase, there is no way to do a "mass removal." Instead, you may:

  • Modify the salaries for each individual, or
  • Create a Mass Salary Increase that is a NEGATIVE percent, effectively erasing the initial increase.

If you choose "b" and there have been any individual salary increases made since the initial mass salary increase, your negative adjustment will be made on the newer effective salary.

  1. Enter ofweb.stanford.edu in the browser
  2. Click Login
  3. As prompted, log in using SUNet ID and password

  1. Click SU CMS USER

  1. Select People tab from the Manage People screen
  2. Select Mass Salary Increase button 
    The History Tab on the Mass Salary Increase screen will provide information on Mass Salary Increases that have occurred in the past 12 months.
  3. Enter or search for Organization Code

  1. Click Add Line from the Mass Salary Increase screen
  2. Click calendar icon to select Effective Start Date
  3. Enter Expenditure Type Range:
    • Enter or search for From Exp Type
    • Enter or search for To Exp Type
  4. Enter Percent Increase
  5. Select Run Mass Salary 
    As needed, select View Previously Run Mass Salary.
What Happens Next?
  • View Mass Salary Increase in the Monthly Spread tab.
  • View the Mass Salary Increase forecast in the Accounts tab.
Last Updated: Jul 24, 2023