HCM Analytics

Retention Rate & Seniority

  Quick Tip: Watch this short tutorial to see the HCM Dashboard in action.                     

Overview

---

The Retention Rate & Seniority card measures the percentage of benefit-eligible employees retained through the fiscal year. It also shows the average years of service (seniority) for all active and inactive employees as of the start of the fiscal year, providing context for workforce stability and experience over time.

This card helps users monitor retention trends, identify potential shifts in workforce longevity, and explore differences across organizational areas or employee groups.

Key Metrics & Definitions

---

> Retention

• • The % of benefit eligible employees that remained employed at MSU for the entire fiscal year.
  • Note: Retention is not meant to capture internal movement within the organization.

Retention Rate     =

# of active/inactive employees on 7/1 that are still employed at MSU on 6/30 # of active/inactive employees on 7/1

x     100

 

> Seniority

• • The average years of service at MSU.
  • Note: Years of service is calculated from continuous employment date.

Average Seniority     =

Sum of years of service for all active/inactive employees on 7/1 # of active/inactive employees on 7/1

x     100

 

Security & Access

---

The Retention Rate & Seniority Card is available to users with the following roles: 

• Report Administrator
• Report Administrator Sensitive

Org-based security applies; users will only see data for organizations they are permissioned to access.

 

Drilldown Page

---

Select any data point within the card to open the drilldown page for that fiscal year. To view a different fiscal year, adjust the Fiscal Year filter at the top of the page. 

 

> Filters

The following filters can be applied on the drilldown page. Click 'Go' to apply your selections. 

Visible by Default	Available through 'Adapt Filters'
Fiscal Year*  College/MAU Organizational Unit Employee Group Employee Type FAS Category *Required filter	Employee Subgroup Job Personnel Subarea  Retained (Yes/No) Seniority Group Work Contract

 

> Default Views 

• • Chart View: Displays the number of retained and not retained employees by Seniority Group in a column chart, showing how retention rates vary across different levels of service.

• • Table View: Displays the following fields by default: 
    • Employee Name
    • Personnel Subarea 
    • Employee Group
    • Employee Subgroup
    • Organizational Unit
    • Job 
    • Seniority
    • Seniority Group 
    • Retained (Yes/No)

 

> Customizing Your View

You can personalize the chart and table to better align with your analysis needs. Click the gear icon to add, remove, or reorder dimensions. For a brief walkthrough, see the Customizing & Saving Views video.

Available dimensions include:

College/MAU Employee Group Employee Subgroup Employee Type

FAS Category Fiscal Year  Job Organizational Unit

Personnel Subarea Seniority Seniority Group Work Contract

Interpreting the Data

---

Please review the Interpreting the Data section on the main dashboard help page. It highlights key considerations—such as effective dates and organizational changes—that may influence results.