Deprecated: Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 393 Deprecated: Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 2647 Deprecated: Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2/Driver/mysql.php on line 1409 HRS Engineering Add-on Report Tools - College of Engineering - UW-Madison

UNIVERSITY OF WISCONSIN-MADISON   COLLEGE OF ENGINEERING

UW Search  |   MyUW  |   Map  |   Calendar

HEART logo
 
 
   

Filter by Category

Select Category:

Filter by Words

Enter Search Words:

Select the report you wish to examine:

Absence Management

Report Provider Description
Absence Checker College of Engineering Report of absences/leaves in your department so that entry into HRS can be verified.
HRS Absences Information UW Query Library Provides HRS absence activity for Campus Absence Coordinators. Data includes absences that need approvals, pushed back or not submitted but saved, zero hours submitted and approved, and to monitor No Leave Taken for unclassified staff.
Jobs on Leave UW Query Library Provides details on HRS employee jobs where the empl status = L (leave).
Unclassified Leave Usage and Balances UW Query Library Provides details on HRS leave usage and balances for unclassified employees. Also provides information on employee FTE changes and leave status for assistance in determining FMLA.

 

Add/Edit Funding

Report Provider Description
Tool: Funding LayOut Assistance Tool College of Engineering Funding LayOut Assistance Tool. This feature allows you to enter a funding scheme using a PayData-like interface. You can then see what that funding scheme would look like in HRS. Especially useful for complex funding schemes.

 

Directory

Report Provider Description
Employee Directory Business Address UW Query Library Business addresses, email addresses and phone numbers retrieved from the UW System's IAA System
Employee Directory General UW Query Library Home, business, email addresses and phone numbers retrieved from the UW System's IAA system and job data from HRS

 

History

Report Provider Description
Academic Staff Job Security (Non Sensitive) UW Query Library Provides reports of UW-Madison Academic Staff employees who are eligible for job security.
Academic Staff Job Security (Sensitive) UW Query Library Provides reports of UW-Madison Academic Staff employees who are eligible for job security. Reports include sensitive data.
Academic Staff Time in Jobcode UW Query Library Management reports that assist departments/divisions in making equitable salary offers to new staff and changes to existing staff salaries.
Rate and Jobcode History UW Query Library Replacement for legacy 3270 transaction APRH.
Salary Equity Non Sensitive UW Query Library Management reports that assist departments/divisions in making equitable salary offers to new staff and changes to existing staff salaries without sensitive data.
Salary Equity Sensitive UW Query Library Management reports that assists departments/divisions in making equitable salary offers to new staff and changes in existing staff salaries.

 

Jobs/Appts

Report Provider Description
LTE Hours Report HRS/Cypress The LTE Hours Report provides cumulative hours worked for each active LTE Job within the most recent twelve months from the job anniversary date. It is used to monitor the statutory 1043 hour limit for an LTE appointment within a 12 month period. This report includes only hours paid in HRS.
2 Ninths (2/9) Report College of Engineering Summer pay in previous years for C basis employees to aid in 2/9 reporting.
Academic Staff Job Security (Non Sensitive) UW Query Library Provides reports of UW-Madison Academic Staff employees who are eligible for job security.
Academic Staff Job Security (Sensitive) UW Query Library Provides reports of UW-Madison Academic Staff employees who are eligible for job security. Reports include sensitive data.
Academic Staff Years in Service for a Campus UW Query Library Provides reports detailing current academic staff employee jobs for a specific campus, and their years in service (using UW-Madison criteria).
Active Jobs for a Given Date Range UW Query Library Lists jobs active within a given date range and other selection criteria. Reports include person and job related data.
Appointments Ending (equivalent) HRS/EPM Provides a detailed list of employees/appointments in the specified department. Results includes appointment (job) end date. (EPM =>EPM Reports => Job list by Department)
Current Classified, Unclassified, and Student Jobs UW Query Library Lists of appointments by various selection criteria. Data results are from the EPM Data Warehouse. Includes a new report displaying current funding for a job.
Deptid Current Jobs - Rate and Jobcode History UW Query Library Provides pivot table output reflecting rate and jobcode history for active jobs for a given Deptid (output may include legacy data).
Doc: Student Hourly Entry 'Cheat Sheet' Anonymous Provides step-by-step instructions on entering a student hourly appointmentment into HRS both when there is a pre-existing EmplID and when there is not.
Employee Job History UW Query Library Report output resembles legacy APPR transaction. Includes additional parameters if EmplID not known (requires Last Name entry)
Employee Job Probation UW Query Library Generaties a listing of employees currently on probation or for a given time period.
Ended Classified, Unclassified and Student Jobs UW Query Library Lists of ended jobs by selection criteria. Includes a report with non-sensitive end codes and reason descriptions.
Ended Classified, Unclassified and Student Jobs Sensitive UW Query Library Lists of ended jobs by various selection criteria. Includes a report with end codes and reason descriptions (sensitive data).
Existing Appointments (equivalent) HRS/EPM Provides a detailed list of employees/appointments in the specified department. (EPM =>EPM Reports => Job list by Department)
Expected End Date Query HRS Provides a list of appointments/jobs that have an expected end date of between today and the date you enter in the "As Of Date" field.
FTE Overload UW Query Library Provides reports and table output about employees with total current job FTE greater than 1.
HRS Current and Past Jobs - Export Only UW Query Library Query retrieves general appointment data so that the user can select the specific data needed to export to excel.
HRS Hires and Job Change Transactions UW Query Library New query which reflects reports on 1) hires made since HRS go-live, and 2) job changes made since HRS go-live, including information on who made the change and when.
LTE Monitoring by Anniversary Date UW Query Library Query retrieves both EPM and IADS payroll history data. Report lists cumulative hours in a LTE's anniversary year.
Position Status Report HRS Inventories the types of positions in your organization, and lists all filled and vacant positions
Probation Report HRS/Cypress Lists classified permanent employees who are at the three-month and the five-month probation points in the probationary period. The report will be produced via a batch process and is available in Cypress. The report is produced Monthly on the night of the 1st.
Rate and Jobcode History UW Query Library Replacement for legacy 3270 transaction APRH.
Rate Over Max/Under Min HRS/Cypress This report helps users ensure that employees' base rates are correct and that employees are paid within the authorized range. It compares the compensation rate to the Minimum and Maximum from the Salary Grade Table. Then it lists those jobs that meet one of three comparisons to the Over Max and Under Min checkboxes, as selected by the user on the parameter page.
Rehired Annuitant UW Query Library Provides details on rehired annuitants and their job(s) which were active on a given 'as of date' and Deptid. Rehired Annuitant Code, Empl Class and Continuity Code are optional parameters.

 

Miscellaneous

Report Provider Description
Blank EPM Query UW Query Library Interactive Reporting document with connection to Production HRS EPM database. This document can be used as a starting point to write queries using data you are authorized for from HRS EPM.
HRS EPM Control Tables UW Query Library Provides data sets of control (look up/prompt) table values for HRS - EPM
Legacy-to-HRS Data Mapping UW Query Library An excel (.xls) spreadsheet that contains information on Legacy data elements mapping to EPM data elements, etc. This will be updated on an on-going basis.

 

Monitor Funding

Report Provider Description
Budget Worksheet by Person SMPH Given a department code and fiscal year, lists all funding for persons at least partially funded by the given department. [Available as PDF, Excel spreadsheet, or on-line view.]
Detail Funding by Person (being tested) UW Query Library Provides detiled funding and some HR information for a given person.
Funding Split Report (equivalent) SMPH Given PI name and/or list of projects, provides a list of employees with detailed funding information. [Available as PDF, Excel spreadsheet, or on-line view.]
HRS Funding for a Fiscal Year UW Query Library Provides output detailing all HRS funding for a given Deptid, Emplid or Funding String and a given fiscal year. If Deptid is the input, it reflects all jobs where the funding 'touches' this Deptid entry.
Payroll Detail by Employee SMPH Provides detailed funding information for a given employee. [Available as PDF, Excel spreadsheet, or on-line view.]
Payroll Star Detail SMPH Provides detailed funding information for past payrolls for a given employee. [Available as PDF, Excel Spreadsheet, or on-line view.]
Placeholder Report (Accounting) SMPH Given a department code and pay period(s) date range, lists all cases where payment will be after a project end date, or payment is on a placeholder project. [Available as PDF, Excel
Placeholder Report (Simple) College of Engineering Visual representation of appointments in your UDDS that include placeholder funding. [Excel spreadsheet, or on-line view.]
Proj/Dept Inactive Fund Report HRS Provides a list of employees who are scheduled to be paid on project/grants that are expiring during the timeframe you specify. (HRS => UW Financial Reports => Proj/Dept Inactive Fund Report)
Who Is Funded? (equivalent) SMPH Given PI name and/or list of projects, provides a list of employees with detailed funding information. [Available as PDF, Excel spreadsheet, or on-line view.]

 

Payroll Cycle

Report Provider Description
Adjusting Employee Balances/Payroll Check Processing HRS/Cypress TSA Report for who will fall into this category. To identify any TSA deduction adjustment (negative or positive), to adjust vendor payment (before vendor payment date), or recoup the vendor payment (after the vendor payment date).
Biweekly Payroll Edit Checksheet UW Query Library Hourly payroll check sheet to be used to review pay hours prior to next confirmed payroll or to review prior confirmed payrolls.
Deduction Register HRS/Cypress The Deduction Register Report (Vendor Payment Report) will be produced via a batch process and is available in Cypress. This report will include all general deductions with the exception of garnishments.
HRS Time Approver Information UW Query Library Query provides details on active employee jobs and HRS Time Approvers (including backup, non-HRS approvers and Payroll Coordinators), their approver status (Active, Term, LOA), and the employees whose time they approve.
LTE Monitoring by Anniversary Date UW Query Library Query retrieves both EPM and IADS payroll history data. Report lists cumulative hours in a LTE's anniversary year.
Missed Payroll Report HRS/Cypress This report lists people who have active employment status, but who are not getting paid on the upcoming payroll.
Monthly Payroll Edit Checksheet with Funding for All Jobs UW Query Library Reports generated with all jobs of an employee in the given DeptID and given Run ID. Query defaults to the next unconfirmed pay period. This can be changed to query a previous confirmed pay period.
Non-ACH Employees Report HRS/Cypress Lists Employees who don't have current active ACH records.
Off Cycle Payroll Edit Checksheet UW Query Library Query generates a report for a given Off Cycle Payroll for a given DeptID
Payroll Register HRS/Cypress This report will combine all payment data to employees and distribute to the campus/division/department payroll coordinators. Will be run after each Payroll Confirm and is available in Cypress.

 

Person

Report Provider Description
Annual Academic Staff Promotion Review (General) UW Query Library According to Academic Staff Assembly Doc 345B this query produces reports of academic staff employees who must be reviewed for possible promotion.
Classified Leave History by Employee UW Query Library Classified leave activity of currently active employees (as of the last calc'd payroll) by pay period end dates. Data can be limited to just a calendar year, beginning and ending calc numbers, or pay period end dates. (Query by Emplid only and combines data from InfoAccess and HRS-EPM)
Classified Leave HRS History by Dept or Employee UW Query Library Classified leave activity of currently active employees (as of the last calc'd payroll) by pay period end dates. Data can be limited to just a calendar year, beginning and ending calc numbers, or pay period end dates. (Query by Deptid or Emplid - but only brings back data from HRS - EPM.)
Employee Job History UW Query Library Report output resembles legacy APPR transaction. Includes additional parameters if EmplID not known (requires Last Name entry)
Employee Payroll and Deduction History UW Query Library History of an employees pay and deductions.
HR Sensitive Personnel Data UW Query Library Reports contain employee campus, email addresses and phone numbers, ethnicity, gender and birthdate information.
HRS Current and Past Jobs - Export Only UW Query Library Query retrieves general appointment data so that the user can select the specific data needed to export to excel.
Retirement Benefit for Counseling (Sensitive) UW Query Library Query uses Infoaccess data and is only for Retirement Counselors. Report generated consists of Benefit Projections, Employee Contributions, Total Money Purchase, and Employee Total Service
Termed Employees for a Campus UW Query Library Returns information about employees who have terminated all employment for a campus (for a given Deptid and timeframe); Empl Class is optional. As of today's date, they do not hold any type of job with the given campus.

 

Student

Report Provider Description
Career Positions for SAs and SHs UW Query Library Madison Query - Reports of student employees who have other jobs that may have an affect on FICA exemption. The reports generated are to be used to determine if FICA should be taken.
Current Funding for Graduate Students UW Query Library Madison Query - Query reports funding for current graduate student jobs.
Monitor UW Madison Grad Assistants UW Query Library Madison query - The purpose of this query is to identify employees who may not be compliant with the following UW-Madison Grad School policies for Grad Assistants.
Student Assistant Enrollment Status for 8 Week Summer Session UW Query Library Madison Query - Verifies enrollment and job status for SA titles Y26NN, Y21NN, and Y23NN. Query can be used to determine if students are enrolled for enough credits at the grad level.
Student Assistant Enrollment Status for Academic Year UW Query Library Madison query - This query can be used to determine if a student assistant is enrolled for enough credits at the graduate level to meet the student assistant appointment criteria.
Tuition Remission Report College of Engineering Provides a list of grad students with appointments in the selected department and indicates whether or not the student qualifies for tuition remission based on the combination of qualifying appointment FTEs. Contains a link to create an Excel spreadsheet that can be sent to the Bursar's office.
WS Award Job and Earnings Info UW Query Library Provides details on Workstudy Awards, Jobs and Earnings.

 


List of HRS/EPM Reports:

View an excel spreadsheet of HRS Report List


Manage