Drill Down Detail (HRP1093)

You will have the ability to view the detail of the summary when you click on a highlighted link in either the Organization or Department summary tabs of the Retirement Trends Analysis report (HRP1093).

Retirement Trend Report Tabs

Clicking on the link provides the Retirement Trends Analysis Detail report (HRP 1094) in a separate browser window.

Report Detail

The detail will provide all the employees that have retired based on the criteria selected for the summary report. By default, the detail is sorted by the Organization Code. The Sort drop down menu at the top of the page offers the following additional sorting options:

  • Department Name
  • Employee Name
  • Pay Scale Level
  • Personnel Subarea
  • Employee Subgroup Name
  • Job Title

Additionally, there are the following dynamic filters:

  • Department
  • Personnel Subarea
  • Job Title

The report provides users a detailed view of specific employee data across either the selected organization(s) or department(s).

Detail Report Columns:

  1. Organization Code
  2. Organization Name
  3. Department Code
  4. Department Name
  5. Sub-Org Code
  6. Sub-Org Name
  7. Person ID
  8. Personnel Number
  9. Last Name
  10. First Name
  11. Personnel Subarea Code
  12. Employee Group Name
  13. Employee Subgroup Name
  14. Job Title
  15. Pay Scale Level
  16. Employment Percentage
  17. FTE Salary
  18. Original Retirement Date
  19. Retirement Eligibility Date
  20. Years at MSU
  21. Vested Date
  22. Age at Retirement
  23. Gender
  24. Ethnicity

To have the detail report run in a different application (i.e. Excel, PDF, etc.), select the bottom-pointing menu arrow Arrow at the top of the page (not the right-pointing arrow in a circle) and choose the appropriate action to run.