HR Data Reports

Listed below are regularly updated standard reports and information about setting up automated notifications based on specific job roles, to employees, supervisors, department managers and HR personnel.

Contact us for more information or to request a consultation.

Standard Reports and Resources

Human Resources Information Services produces several reports on a recurring basis to address regulatory/institutional reporting requirements and survey requests and help departments and units make human resources decisions. These reports are a collaboration with the Office of Budget and Planning and other departments to deliver these key reports.

Faculty/Staff Demographics

Annual Salary Disclosure Report — Data Source: HEPROD

Under the 'Freedom of Information Act' the University of Michigan is required to produce an annual 'Salary Disclosure Report. Definition of fields are provided in this report.

You may find previous years of the report in many of the campus libraries, including the University Archives, Bentley Historical Library, or you can call the Bentley Historical Library at (734) 764-3482.

The Analysis of Salaries Paid to the University of Michigan Regular Instructional Faculty, Regular Clinical Instructional Faculty, Lecturers and Graduate Student Instructors (FSA) Report

Data Sources: HEPROD - This report, published annually, analyzes current salaries of the University of Michigan's regular instructional faculty, regular clinical instructional faculty, lecturers, and graduate student instructors.

The report reflects the individual’s status effective on November 1 of the given year. All active and paid leave appointments are selected. Although most changes in salary rates occur on an annual cycle, these data are subject to change by normal on-going personnel actions.

You may find previous years of the report at the University Archives, Bentley Historical Library, or you can call the Bentley Historical Library at (734) 764-3482.

2015 Faculty and Staff Profile by Headcount and FTE (view in Tableau)

Data Sources: HR02- A comprehensive report that displays the number of Faculty, Supplemental employees and Staff by headcount and FTE across all campuses.

Annual FTE (Full Time Equivalent) Report (view in Tableau)

Data Source: HR02 - The FTE visualization is updated each November and can be used for surveys or for 5 year trend analysis. They provide a count of employees based on their FTE/effort. All regular active and paid leave faculty and staff are selected. FTE counts are broken down by Job Family within unit/campus and across fund group. Faculty counts are also broken down by tenure status. Several filters are included to allow customization.

This report can be accessed by U-M employees only.

IPEDS (Integrated Postsecondary Education Data System) Reports (EEO-6)

Data Source: HEPROD - The IPEDS surveys are completed annually and include counts of all regular active and paid leave faculty and staff. Counts are broken down by IPEDS categories, full-time/part-time (anything less than 40 hours), ethnicity/gender, appointment periods, and campuses. The faculty IPEDs category includes Regular Clinical Instructional, Regular Instructional, Supplemental Instructional, LEO Lecturers, LEO Adjunct Lecturers, Primary Research (Research Scientist and Research Professor tracks only – Librarians, Curators, and Archivists are counted as ‘other professional’), Supplemental Primary, Emeritus, and Research Fellows job families unless otherwise noted. The Instructional/Research Assistant category includes Graduate Student Instructors (GSI's), Graduate Student Research Assistants (GSRA’s), Graduate Student Staff Assistants (GSSA’s), and House Officers.

Reports reflect data as of November 1 of the year indicated. Documents are in PDF format unless otherwise noted.

2014 Surveys

Annual Summary Reports

You may find previous years of the report at the University Archives, Bentley Historical Library, or you can call the Bentley Historical Library at (734) 764-3482.

For more information about IPEDS please see the National Center for Education Statistics website at http://nces.ed.gov/ipeds/

Job Classification Summary Reports

Data Source: HR01, as of 01/21/2014 - This report provides listing of all active jobcodes. You can download the EXCEL report to sort it by jobcode, jobcode description, job families, job group and benefit families.

Management Communication Code (3D) Reports

Data Source: HR01, as of 12/31/2014 - This set of reports provides a listing of all active jobcodes in the management communication categories and a summary report (count) of jobcodes by management communication codes.

View Retirement Eligibility Report in Tableau

Data Source: HR02, as of 10/1/2014 - The “Retirement Eligibility Report” provides information on the percent of eligible retirements for current, 2016 and 2018. All regular active and paid leave faculty and staff are included in the report.

Other Sources of HR Data and Reporting

Other sources for HR reports and data are available and listed below. You can access these environments from Wolverine Access. There are security requirements for each environment.

NOTE: The report formerly listed on this page, Productive Time Analysis” is now a Business Objects corporate document called CMB Prod Time Analysis (Campus) [HR01, PY01].

eNotification

The eNotification system is an automated email service that sends notifications, based on specific job roles, to employees, supervisors, department managers and HR personnel.

Examples of notifications include:

  • Individual employee notifications to complete a specific action (i.e., select health benefits for new hires)
  • Notifications to supervisors, managers, or personnel recipients about an employee event (i.e., probation period ending)
  • Multi-tab reports for managers and personnel recipients about hires, terminations, transfers, etc.

The eNotification system extracts M-Pathways HR data and creates emails to specific recipients using a scheduling system.

eNotification Description and Distribution Schedule
eNotification Description Distribution Cycle Eligible Recipient(s) CC Recipients
Missing Timesheet Bi-Weekly Time Labor Recipient
Current RIF List for Benefits, Flnt/Dbn/Temp/WT/Med HR Offices Weekly hr-all-generalists@med.umich.edu tpalmer@.umich.edu; dbn-enotes@umich.edu; bmanning@umich.edu; jsymanns@umich.edu; nicadamc@umich.edu; kakasper@umich.edu
RIF Notification Weekly Personnel Recipient or Department Manager
JOLTS Report to Department of Labor Monthly brown.jennifer@bls.gov dcc_ncs@bls.gov; joltsdcc@bls.gov
People About to Return from Leave Bi-Weekly wjtenny@umich.edu dbn-enotes@umich.edu; nicadamc@umich.edu; kakasper@umich.edu; hr-all-generalists@med.umich.edu
People About to Go on Leave Weekly hr-all-generalists@med.umich.edu wjtenny@umich.edu; dbn-enotes@umich.edu; nicadamc@umich.edu; kakasper@umich.edu
Leave PMOD Expires in 14 Days Weekly Admin Personnel Recipient or Department Manager
Temporary Employee Has Worked 47-48 weeks Weekly Personnel Recipient
J-1 Registration is Required for Your Employee Weekly Personnel Recipient; Department Manager; Supervising Faculty Member; Administrative Contact j-reminder-copy@umich.edu
Warning: Exchange Visitor is About to Violate INS Regs Daily Personnel Recipient; Department Manager; Supervising Faculty Member; Administrative Contact j-reminder-copy@umich.edu
FLSA Jobcode Change Monthly campusrepreport@umich.edu
Annual Employment Evaluation is Needed Weekly Personnel Recipient or Department Manager Dearborn: dbn-enotes@umich.edu
I-20 Form About to Expire Monthly F1 Student mjbuhr@umich.edu
DS-2019 Form About to Expire Monthly J1 Student or J1 Scholar; Personnel Recipient; Department Manager; Administrative Contact (expiring in 30-90 days) mjbuhr@umich.edu
Incoming New Hire about Regional Office Nightly Newly hired employees
Faculty and Staff I-9 Complete Nightly Personnel Recipient or Department Manager
Student Temp I-9 Complete Nightly Personnel Recipient or Department Manager
I-9 Expired for Regular Emp Weekly Personnel Recipient or Department Manager
I-9 Expired for Temp Emp Weekly Personnel Recipient or Department Manager
I-9 Expires in 180 days-Temp Weekly Employee; Personnel Recipient or Department Manager Dearborn: dbn-enotes@umich.edu
I-9 Expires in 90 Days-Temp Weekly Employee; Personnel Recipient or Department Manager Dearborn: dbn-enotes@umich.edu
I-9 Expires in 30 Days-Temp Weekly Personnel Recipient or Department Manager Dearborn: dbn-enotes@umich.edu
I-9 Expires in 180 Days-Reg Weekly Employee; Personnel Recipient or Department Manager Dearborn: dbn-enotes@umich.edu
I-9 Expires in 90 Days-Reg Weekly Employee; Personnel Recipient or Department Manager Dearborn: dbn-enotes@umich.edu
I-9 Expires in 30 Days-Reg Weekly Personnel Recipient or Department Manager Dearborn: dbn-enotes@umich.edu
I-9 Missing Emails Weekly Personnel Recipient or Department Manager
Probationary Period Ending Weekly Supervisor and Personnel Recipient, if blank then Department Manager Dearborn: dbn-enotes@umich.edu
Probationary Period Mid-Point Weekly Supervisor and Personnel Recipient, if blank then Department Manager
Probationary Period, MNA, Ending Weekly Supervisor, Personnel Recipient or Department Manager Dearborn: dbn-enotes@umich.edu
LEO New Hire Weekly Weekly (Jan, May, Jul, Sep) leo.reports@umich.edu
LEO New Hire Monthly 1st Tues of month leo.reports@umich.edu
LEO Address 1st Tues of month leo.reports@umich.edu
LEO Termination 1st Tues of month leo.reports@umich.edu
LEO Demographics 1st Tues of Mar and Nov leo.reports@umich.edu
LEO New Hire Blank Spreadsheet 1st day of Apr, Jun, Aug and Dec ahr-leo-reports@umich.edu
LEO Seniority Report 3rd week of Mar, Aug and Nov Unit Contacts leo.reports@umich.edu
Professorship Weekly Personnel Recipient or Department Manager
Temps Working More Than 10 Months for Flint Monthly brancht@umflint.edubmanning@umflint.edu
GEO Monthly Report 1st Tues of month geo.reports@umich.edu
GEO Quarterly Deduction Notice Mar, Jun, Aug, Nov Each GEO member geomemberlists@umich.edu
GEO New Hire 4th Sunday of Jan, May, Jul and Sept Each GEO member geomemberlists@umich.edu
GEO Demographic 1st Tues of Mar, July and Nov geo.reports@umich.edu
GEO Temp Count 2nd Tues of Feb and Oct geo.reports@umich.edu
Regent Report Monthly djedele@umich.edugardners@umich.edu
Research Fellow Certificates Weekly djedele@umich.edugardners@umich.edu
Uyr Appt Expired Monthly Personnel Recipient or Department Manager
Uyr About to Expire in 30 Days Monthly Personnel Recipient or Department Manager
Dry Appt Expired Monthly Personnel Recipient or Department Manager
Missing SSN on Paycheck Monthly Employees
Multi-tab Reports Distribution Cycle Eligible Recipient(s) CC Recipients
HR Rep Monthly Report Monthly Reps; timwood@umich.edu tamif@umich.edu; kakasper@umich.edu; nicadamc@umich.edu
HR Rep Report Quarterly Quarterly Reps; timwood@umich.edu tamif@umich.edu; kakasper@umich.edu; nicadamc@umich.edu
Department Report Monthly Monthly Personnel Recipient or Department Manager
Department Report Quarterly Quarterly Personnel Recipient or Department Manager
Department Report Annually Annual Personnel Recipient or Department Manager
ORG (School) Fiscal Report Annual Org Administrator Org second, org third, org fourth
ORG (School) Annual Report Annual Org Administrator Org second, org third, org fourth
ORG (School) Monthly Report Monthly Org Administrator Org second, org third, org fourth
ORG (School) Quarterly Report 4x/year Org Administrator Org second, org third, org fourth

Contact us for more information or to request a consultation.