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.

Faculty and Staff Profile by Headcount and FTE

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 

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

IPEDS (Integrated Postsecondary Education Data System) Reports (view in Tableau) IPEDS is a system of interrelated surveys conducted annually by the U.S. Department’s National Center for Education Statistics (NCES). IPEDS gathers information from every college, university, and technical and vocational institution that participates in the federal student financial aid programs. More information about IPEDS can be found at the National Center for Education Statistics (http://nces.ed.gov/ipeds/)

Summary data for the University of Michigan’s Human Resources section of the IPEDS Survey is provided as a Tableau workbook. Reports reflect data as of November 1 of the year indicated. Previous years of the report can be found at the University Archives, Bentley Historical Library, or you can call the Bentley Historical Library at (734) 764-3482.

Job Classification Summary Reports

Data Source: HR01, as of 10/11/2016 - This report provides a 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

The 3D (Deans, Directors, and Department Heads) Report provides a listing of all active jobcodes in the management communication categories and a summary count of the number of individuals within each category.

View Retirement Eligibility Report in Tableau

Retirement Eligibility Report (view in Tableau) Data Source: HR02, as of 7/1/2016 - The “Retirement Eligibility Report” provides information on the percent of eligible retirements for current, 2018 and 2020. 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 detailed in the link listed below.

eNotification Description and Distribution Schedule

Contact us for more information or to request a consultation.