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).

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

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  at the top of the page (not the right-pointing arrow in a circle) and choose the appropriate action to run.