Data Definitions (HRP1102)
The data columns used in the Succession Planning Detail Page report are defined on this page.
- Organization Code & Name: The primary college or MAU in which the employee is assigned.
- Department Code & Name: The primary department in which the employee is assigned.
- Sub-Org Code & Name: The sub-org in which the employee is assigned (if applicable).
- Person ID: An HR/Payroll system generated number linking a person to all of their assignments.
- Personnel Number: An HR/Payroll system generated number linking a person to their benefits eligible assignment.
- Professional Name: The employee's professional last and first name as indicated in the HR/Payroll system.
- 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 type.
- 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 Code & 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 is assigned.
- Pay Scale Level: The number level signifying range of pay assigned to the employee’s job title or classification.
- Employment Percentage: The percent of employment the employee is working.
- Annual Salary: The base salary for a full year at 100% employment.
- Continuous Service Date: The employee’s hire date, last rehire date, or last position adjustment date without a break of service.
- Seniority Date: The employee's seniority date as indicated in the HR/Payroll system.
- Time in Level Date: The date the employee entered the pay grade (scale) level.
- Benefit Eligible Date: The employee’s hire date, last rehire date, or last position adjustment date in a benefits eligible position with no more than a 30-day break of service.
- 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.
- Years Until Eligible to Retire: The number of years between the date the report is run and the employee’s Vested Date. Employees who have already retired (and have an Original Retirement Date) should be listed as “Currently Eligible."
- Date of Birth: The employee's date of birth as indicated in the HR/Payroll system.
- Age: The employee's age based on their date of birth as indicated in the HR/Payroll system.
- Supervisor Name: The employee's supervisor name as indicated in the HR/Payroll system.
