Data Definitions (HRP1103)
The data columns used in the Employee Years of Service 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).
- 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, Non-Employee/No Pay. 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: EBS code for employee subgroup.
- 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.
- Personnel Number: An HR/Payroll system generated number linking a person to an assignment. A person with concurrent employment will have multiple PERNRs but only one PERSID.
- Employee Name: The full name of the employee as indicated in the HR/Payroll system.
- Professional Last Name: The last name of the employee as indicated in the HR/Payroll system.
- Professional First Name: The first name of the employee as indicated in the HR/Payroll system.
- Professional Middle Name: The middle name of the employee as indicated in the HR/Payroll system.
- Employee Status: The employment status identifies whether the employee is an active or inactive employee or withdrawn from employment at the university.
- Job Classification/ Job Title: The employee's primary job title or classification in which the employee is assigned.
- Salary: The employee's annual salary as indicated in the HR/Payroll system.
- Pay Scale Level: The number level signifying range of possible pay assigned to the employee’s job title or classification.
- 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.
- Vested Date: The first day of the month in which the employee is vested for retirement.
- Continuous Employment Date: The date the employee was hired without any breaks in service.
- Group Date: The date the employee entered the union (if applicable).
- Time in Position: The date the employee was hired/promoted/demoted/lateral transfer from a posting.
- Time in Level: The date the employee entered the pay grade (scale) level.
- Years of Service: Years of continuous service with the University. Years is calculated from Continuous Employment Date to the "As of Date" entered in the report prompts.
- Years of Service in MAU*: Years of continuous service within MAU. Years is calculated from date of employment within the employee's current organization (MAU) to the current date.
- Years of Service in Department*: Years of continuous service within department. Years is calculated from date of employment within the employee's current department to the current date.
- Email Address: The employee's MSU email address (@msu.edu).
- Address Line 1: Work location Address Line 1 as indicated in the HR/Payroll system.
- Address Line 2: Work location Address Line 2 as indicated in the HR/Payroll system.
- City: Work location city.
- State: Work location state.
- Zip Code: Work location zip code.
- Off Campus Location: Off Campus work location (if applicable).
- Supervisor Name: Name of supervisor as indicated in the HR/Payroll system.
- Supervisor Email: The supervisor's MSU Email address (@msu.edu).
*Data is as of Jan 1, 2011 which may impact years of service in an MAU and/or Department.
