Data Definitions (HRP1093)
The data columns used in the Retirement Trends Analysis Detail report are defined on this page.
- Organization Code & Name: The primary college or MAU in which the employee was assigned at the time of retiring.
- Department Code & Name: The primary department in which the employee was assigned at the time of retiring.
- Sub-Org Code & Name: The sub-org in which the employee was assigned at the time of retiring (if applicable).
- Person ID: An HR/Payroll system generated number linking a person to all of their assignments at the time of retiring.
- Personnel Number: An HR/Payroll system generated number linking a person to their benefits eligible assignment at the time of retiring.
- Personnel Subarea Code: A Further breakdown of the Personnel Area. The principal organization aspects of HR are controlled at this level, including work schedules, pay scales, public holiday calendar, and wage types.
- Employee Group Name: Union, Non-Union. The employee group allows you to divide your employees into groups and allows you to define their relationship to the enterprise. It classifies employees into general groups for processing of Payroll, Time and Benefits.
- Employee Subgroup Name: A further breakdown of Employee Group. All control features of the Personnel Structure are defined at the Employee Subgroup level including specific payroll calculations for hourly or salaried employees, work schedules, and benefit groupings.
- Job Title: The employee's primary job title or classification in which the employee was assigned at the time of retiring.
- Pay Scale Level: The number level signifying range of pay assigned to the employee’s job title or classification at the time of retiring.
- Employment Percentage: The percent of employment the employee was working at the time of retiring.
- FTE Salary: The base salary (at the time of retiring) for a full year at 100% employment.
- Original Retirement Date: The day after the employee’s last day of employment in a benefits eligible position and meeting one of the two minimum retirement requirements (15 years of service and at least age 62, or 25 years of service at any age), and the first day as an “official retiree” of MSU.
- Retirement Eligibility Date: The first day of employment in a benefits eligible position where the employee is earning credit (time and FTE service months) toward meeting one of the two minimum retirement requirements.
- Years at MSU: The number of years working in a benefits eligible position at MSU.
- Vested Date: The first date the employee met one of the two minimum retirement requirements while in a benefits eligible position.
- Age at Retirement: The age of the employee at the time of retiring.
- Gender: The employee's gender as indicated in the HR/Payroll system.
- Ethnicity: The employee's ethnicity as indicated in the HR/Payroll system.
