Payroll Budget Worksheet

This worksheet provides funding information for employees in a specific Division or Department for the entire fiscal year. Data is sourced from HRS and does not include salary expenses transferred later (SCT).

• Direct link: Payroll Budget Worksheet 
• Found in SMPH Accounting Data Warehouse. Under 'Payroll Information' header, click 'Paydata for Budgeting'.

OBIEE Queries

• Link: https://hr.wisc.edu/hr-professionals/systems/uwbi/
  • Log in to OBIEE.
  • Select the "Human Resources and Finance" dashboard.
  • Open "Workforce Dashboards" for reports.
• Recommended Queries
  • Current Employees and Jobs
    
    • Recommended views/tabs: Employee Detail, Employee Job Funding
    • Lists current employees in a specified Department.
    • Includes: start date, job and working title, pay rate, and funding details.
  • Termed Employees
    • Click the 'Termed Employees' tab
    • Shows terminated employees within a specified date range.
    • Includes: position number, start and end dates, reason for termination, and continuity status.
    • Note: Funding details are not included.
  • Rate & Jobcode History: Employee Details
    • Click the 'Employee Details' tab.
    • Provides pay rate and job code history for a selected employee.
    • Includes details on TBAs (added or removed).

Salary Lookup for Proposal Preparation

Use this resource to view rate, pay basis, employee type, and FTE for an employee.

• Link: RSP

Payroll Edit Report (UW_PY_EDIT_BY_JOB_DEPT) 

This report includes all employee types, with one line per funding string.

• Access via HRS
  • Log in to HRS.
  • Go to "Query Viewer."
  • Search for or favorite the query "UW_PY_EDIT_BY_JOB_DEPT."
  • Export to Excel