Instructions for Running the Funding Edit Query

1. Enter query name: UW_FI_FUND_EDT2.
2. Select either HTML or Excel.
   
   
3. Enter your campus name in the 'Unit' field.
   NOTE: To run the report for all campuses, enter “UW%"
4. Click View Results
   
   

Reviewing the Funding Edit Error Inquiry Page

HRS Navigation:  Payroll for North America > Payroll Processing USA > Pay Period Reports > Funding Edit Errors Inquiry

1. Enter values in the following fields:
   a. Business Unit field - enter your campus (e.g. UWEAU)
   b. Funding Deptfield - all or part of the 6-digit funding department -- without the alpha campus code identifier
   • Percentage sign (%) is wildcard
   • To find employees with funding in payroll suspense, enter the Funding Department PRSUSP
2. c. Include Valid/Unprocessed - check or uncheck depending upon the results wanted
   • To see only employees with invalid funding, leave the box unchecked
   • To see employees in payroll suspense, check the box (PRSUSP is a valid funding department)
   • To see all valid and invalid funding, check the box

  When viewing all rows including valid and unprocessed, do not run for UW Madison due to the large volume of records; instead use the Query

• If no results are found, no data will be shown.  (NOTE: HRS does not return a "no matching values" message if no data has been found for your search criteria).

Download Results to an Excel Spreadsheet

1. Click the Show all columns icon.
     If you do not click this first you will only download the displayed columns.
2. Click the Download icon

Evaluate the Data

1. Review the “Error Description” column. All values other than "Valid" must be reviewed and corrected. Refer to KB Resolving Funding Error Issues in HRS to resolve funding errors.
   
   
2. Review the "Budget Level Indicator" column. All values other than "A" (Appointment-level funding) must be reviewed; this includes rows with Error Description "Valid".
   • Review for “P” (Position-level funding). A80 is currently the primary division that regularly utilizes Position-level funding. Contact UW Shared Services for assistance if there are results indicating Position-level funding.
   • Review for “D” (Department-level funding). When the value "D" appears, it means that an employees Appointment-level funding has not been set up. Add or correct employee's Appointment-level funding if Department level funding is not appropriate; see KB Adding or Changing Appointment Level Funding for Employee's Salary Expense in HRS  for guidance.
   • Review for "S" (payroll is in suspense). A funding entry for any transaction in suspense must be made by noon on the final payroll calc day; refer to KB Adding or Changing Appointment Level Funding for Employee's Salary Expense in HRS   for guidance.

Troubleshooting Listed Funding Items

• Review Job Data (Workforce Administration > Job Information > Job Data). Verify that funding was entered using the correct Appointing Department as listed on the Work Location tab.
• Review funding entries in the Funding Data Entry Page (Set Up HCM > Product Related > Commitment Accounting > Budget Information > Budget Funding Data Entry).  Verify that the Department and Effective Date entered exactly matches the Appointing Department and Effective Date of the Hire, Rehire, Transfer or Department Change action on Job Data. Do NOT rely on information listed at the top of the Budget Funding Data Entry page.
• Analyze the calculated paycheck in Review Paycheck (Payroll for North America > Payroll Processing USA > Produce Payroll > Review Paycheck).  Click “View All” to ensure that all payments can be viewed. Review the date of the payments and determine if a payment is related to a prior pay period and/or to a previous position.  For example, if a monthly employee’s April 2016 Review Paycheck includes payments related to December 2015 from the employee’s previous position, funding must be entered using Earnings Codes as described in KB Designate Funding for Payroll Earnings Code Differently Than Regular Pay in HRS.