FN - Add or Change Appointment Level Funding for Employee's Salary Expense

GENERAL DESCRIPTION:

This document shows how to add or change appointment-level funding for an employee's salary expense (e.g. earnings, deductions, taxes) in HRS.

PROCESS CONSIDERATIONS:

  • The Budget Level indicator of "Appointment" means that funding for the employee's salary expense is linked to their appointing department, Empl ID  and Empl Record Number. Appointment-level funding is used for nearly all funding transactions at all campuses. (The only exceptions are UW-Madison divisions A96 and A80.)
  • A new funding value needs to be added anytime an employee is hired, rehired, transferred, or their department changes. A new funding entry is also required for each fiscal year.
  • Funding is added once per campus, appointing department, Fiscal Year, budget level, Empl ID, and Empl Record Number on the Funding Data Entry page. The Funding Data Entry page, Add a New Value tab is used to add funding for the employee's current pay period or a future pay period, according to the Pay Schedules listed on the Calendars and Schedules page. The Funding Data Entry page in HRS does not adjust funding retroactively for payrolls previously completed.
  • When funding is populated or entered for a new fiscal year, the Funding Effective Date varies by pay group and/or campus.  An employee’s Pay Group can be viewed in the Payroll tab of Job Data (Workforce Administration > Job Information > Job Data).
  • Funding Effective Date to be entered at the start of the fiscal year for active employees:
    • A-Basis employees (all campuses): always July 1
    • H-Basis employees (all campuses): the Period Begin Date for the bi-weekly payroll that includes July 1
    • C-Basis, S-Basis, and V-Basis employees: the Period Begin Date for the monthly payroll that includes July 1; the Period Begin Date varies by campus; although C-basis salaries are not paid in July, funding needs to be in place effective July 1 to fund employer share prepaid fringes over the summer. 
  • A Fiscal Year End website is updated each year with specific funding information relevant for that fiscal year at Fiscal Year End Webpage. Refer to the Fiscal Year End Funding Entry Guide for your campus for each Pay Group’s Period Begin Dates that should be entered as the Effective Date at the start of the new Fiscal Year.
  • The funding Effective Cate for employees with a Job Data Action of Hire, Rehire, Transfer or Department Change that is effective after the Period Begin Date for the payroll that includes July 1 will be the Effective Date of the Action
  • HRS Security Role Needed: FI Campus Funding One BU, FI Campus Funding - All Campus
warning sign Funding for an employee's salary expense must be entered prior to final calc and confirm to ensure the change takes effect for the current payroll period.

NOTE: The funding entry process is the same for all types of UW employees whose pay basis is Academic, Annual, Hourly, Lump, Summer Service or Summer Session.

Fiscal Year End Special Notes:

Each year as part of the Fiscal Year End Budget Import and Funding Rollover process, HRS will automatically populate the new Fiscal Year Appointment-level funding for most active employees.  Refer to the Fiscal Year End website, located on the UW Service Center, Finance home page.




Add Appointment Funding for Employee's Salary Expense (first time only)

  1. View the employee's Job Data record to verify the Empl Record Number of their current or future job, appointing Department of their current or future job and the Effective Date of the Job action that requires funding entry.

    NOTE:
    The appropriate job row and effective date that require funding may not be the first row displayed. Use 'Include History' and scroll through Job Data rows to find the appropriate Effective Date and row for the Hire, Rehire, Transfer or Department Change.

    Example of Job Data page in HRS:
https://kb.wisc.edu/images/group61/29976/9.2jobdata.png

  1. Obtain the necessary source document that lists salary funding information for the employee's salary expense (e.g., effective date, fund, funding department, program, project/grant, funding percentage, earnings code). Documentation should be available from your financial representative/controller's office.

  2. Navigate to: Set Up HCM > Product Related > Commitment Accounting > Budget Information > Budget Funding Data Entry.

  3. Click Add a New Value tab.
  4.  From your source document, enter data into the following required fields:

    • Set ID - Pre-populated with value 'SHARE'; leave as is
    • Business Unit - Pre-populated with your business unit , e.g., UWPKS
    • Department - Appointing Department code from Job Data; e.g., G991234
    • Fiscal Year - 4 digit year for the appropriate fiscal year; UW fiscal years begin on July 1 and end on June 30
    • Budget Level - Always select Appointment; this means you are funding the salary expense of one person in one appointment
    • Position Number: leave blank
    • Empl ID - verify it is correct
    • Empl Rcd Nbr - of the employee's job being funded; verify that the correct Empl Record Number is used.

  5.  Click the Add button.
    • If you receive a message, "The value you tried to add already exists", this means Appointment-level funding has already been entered for this appointing department, fiscal year, Empl ID and Empl Rcd Nbr combination.

    https://kb.wisc.edu/images/group61/29976/9.2addanewvalue.jpg

  6. The Funding Data Entry page displays for the employee. Verify the appointing department, fiscal year, employee name, Empl ID and Empl Rcd Number are correct.

    The Budget Data section displays the most recent HR information from the employee's Job Data page. The most recent rows may not be hire, rehire, transfer of department change actions.

    https://kb.wisc.edu/images/group61/29976/9.2fundingdataentrypageentry1.png
  7.  From your source document, enter the following funding distribution information: 

    • Effective Date - update the funding Effective Date
      • The funding Effective Date should be either the employee's Hire/Rehire/Transfer/Department Change personnel action date (found on Job Data) - or - the first day of the employee's pay period that includes July 1; whichever date is later.
    • GL Business Unit (defaults to your campus but can be modified, if needed) Example: UWMSN
    • Fund (3-digit fund code) Example: 101
    • Dept ID (6-digit funding department number without the alpha character) Example: 534255
    • Program code (1-character Program code) Example: 4
    • Project (7-character Project/Grant ID, if applicable) Example: PRJ46MW
      Note: If a Project is entered, a Project End Date column will display the ending date of the project/grant. This field is not editable. (This is the project end date, not the budget end date).
    • Distrib % (total percentage that will be expensed from this fund, department, program, etc.); accepts up to 3 decimal places.
      Note: In order to save properly, all percentages under the Distrib % column must total 100.000%.
    • ERNCD (Earnings Code), if applicable, when a specific payroll earnings code (such as for Retro Pay, Overload, Overtime) should be funded differently than regular pay. For more details, refer to KB FN - Designate Funding for Payroll Earnings Code Differently Than Regular Pay .
      Note: This is not common when adding funding for the first time.

  8. To add a new funding row, click the plus icon at the end of the row (used when the funding distribution is less than 100% and you need to add an additional line to total 100%).

  9. To delete a funding row, click the minus icon at the end of the row.

     https://kb.wisc.edu/images/group61/29976/9.2fundingdataentrypagefinal.png

  10. Click the Save button. HRS validates the funding information entered against rules in the Shared Financial System (SFS).


Changing Current Funding Record

warning sign  If funding is being updated because an employee changed departments, you must follow the steps to Add New Funding, see above.

Navigation: Set Up HCM Product Related > Commitment Accounting > Budget Information > Budget Funding Data Entry > Find an Existing Value
  1. Enter information to find the employee with the funding you wish to change, then click Search.
    Note: If you receive the message, "No matching values were found," this may mean that no Appointment level-funding has been entered for the fiscal year for the employee's appointing department, Employee ID, and Empl Record Number. If this is the case, add Appointment-Level funding by selecting the Add a New Value tab. (see steps above)

  2. If the search criteria results in multiple records, select the desired record based on Department, Fiscal Year and Empl Rcd Nbr.

  3. The Funding Data Entry page displays for the employee

    • The top part of the screen shows the Fiscal Year (e.g. 2016) and Appointing Department (e.g. A073600). 
    • The Budget Data section shows the employee's two most recent Job Data rows.  However, the action reason and description are not shown.  Before entering funding, always analyze the employee's Job Data record for their current or future job. Navigation: Workforce Administration > Job Information > Job Data
    • The Funding Distribution grid at the bottom of the screen shows current (or future-dated) funding for the employee's regular earnings, deductions, and taxes. This funding will remain in effect for the rest of the fiscal year.

Guidelines for Changing Funding:

  • The funding Effective Date should be the Pay Period Begin Date of the employee's current or future payroll calendar within the fiscal year, or the employee's most recent Hire, Rehire, Transfer or Cepartment Change, if this information has not been previously entered in the current fiscal year.
  • Future funding Effective Dates should not be more than 30 to 60 days from today because of Job Data and funding changes that may occur in the meantime.
  • Each day of the employee's pay period should be funded, even if the employee will not be working on that date. Each day of the fiscal year should be funded for all employees who are active employees on the pay period begin date that includes July 1.
  • Any funding changes must be entered prior to final calc and confirm to ensure the change will take effect for the current payroll.

Add a New Effective Dated Funding Row

  1. Click the Add a new row icon (plus sign)
    Note: If you have View-Only access to the Funding Data Entry page, you will not see a plus icon under the Budget Data section header.

  2. When a new funding effective dated row is added:
    • The new information becomes the current row, and the previous information is historical. The new information is displayed first.
    • The Effective Date displays with the current date.
    • The funding Eff Seq (effective sequence) field indicates 0 for the first entry, 1 for the second entry, etc., for multiple entries with the same funding effective date.
    • The funding Status field (e.g. Active) and funding distribution data are copied from the previous funding effective date.

  3. In the new Effective Date field, update to the date you want the salary funding change to take effect.  The funding Effective Date will usually, but not always, be the Pay Period Begin Date of the employee's current or future pay period.
    Note: The employee's Pay Group (located on Job Data page, Payroll tab) determines the applicable payroll calendar, with specific pay period begin and end dates. See KB PY - Pay Group Descriptions

  4.  In the new Funding Distribution grid section, enter the updated salary funding information, per your source document.
    • To delete a funding row, click the minus symbol at the end of the row you wish to delete.
    • To add a new funding row, click the plus sign.
    • Verify that all the percentage numbers under the Distrib % column total 100. 
      Note: You may use up to 3 decimal places, if needed.
    • The ERNCD (earnings code) column is only used to designate that a specific payroll earnings code (such as for an Overload, Retro Pay, Overtime, for example) is funded differently than an employee's regular earnings, deductions, and taxes.  For more details, refer to KB FN - Designate Funding for Payroll Earnings Code Differently Than Regular Pay .

    https://kb.wisc.edu/images/group61/29976/9.2changeapptfundingfinal.jpg

  5. To save the new salary funding changes for the specified funding effective date, click the Save button at the bottom of the screen. 

  6. The message, Processing, will display for a few seconds in the upper right portion of the screen.  This means HRS is validating the funding information entered against rules in place in the Shared Financial System (SFS).
    • Correct any errors found, and click Save again.  For more information about error messages, refer to KB FN - Resolve Error Messages on Funding Data Entry Page ,
    • If no errors are found, the message, Saved displays for a few seconds in the upper right portion of the screen.

  7. To add new effective dated row(s) to enter more changes to salary funding for The Fiscal Year, repeat steps above.

Using Correct History to Make Funding Changes

Use of Correct History to make changes on the funding page should be very rare.  It should only be used in two circumstances:
  • To change a previously entered Effective Date to an earlier date. For example, the Funding Effective Date was entered as 9/1, but the date needs to be 8/31 to match Job Data
  • To trigger the system to closeout encumbrances.  See KB FN - Simple Encumbrance Maintenance - Close out
Correct History should never be used to:
  • Change a funding string -- a new funding row should be entered to add a new funding string, even if it is for the same date as an existing entry;
  • Delete a funding string - there is no limit on how many funding rows can be added in the funding screen, but existing funding entries should never be deleted;
  • Add funding as a result of a Hire, Rehire, Transfer or Department Change -- new rows should be added in all cases.
The use of Correct History to change funding or the deletion of funding rows is known to cause a variety of issues, including incorrect salary and benefit postings and challenges with encumbrance calculations and closeouts.  In many instances, encumbrance calculation and closeout issues that are a result of the use of Correct History can only be resolved at the end of the fiscal year when all encumbrances are zeroed out.

There are also infrequent instances where an existing funding entry does not match Job Data and users receive a “Not Eligible for Budget Definition” error, see KB FN - Resolve Error Messages on Funding Data Entry Page .  In those cases, we recommend contacting the Service Center.  The Job Data and existing funding entries will be analyzed and a corrective funding entry will be made.

Contact the Service Center for assistance if a situation is encountered where it appears that the use of Correct History is the only available option for an issue other than a date change.


ADDITIONAL RESOURCES:

Related KBs

Related Links



    Keywords:HRS add funding enter funding funding entry salary commitment accounting budget fund hire new employee appointment level earnings code ERNCD eff seq effective sequence detailed salary funding plan report total by pay period Fiscal Year FYE Summer Session Summer Service Academic Annual Lump Pay Basis Training Hire Rehire   Doc ID:29976
    Owner:Christine G.Group:Human Resource System (HRS)
    Created:2013-05-02 12:51 CDTUpdated:2017-02-24 10:43 CDT
    Sites:Human Resource System (HRS)
    Feedback:  1   4