Data Definitions (HRP1135)

The data columns used in the Support Staff Terminations and Retirements report are defined on this page.

  1. Organization: The primary college or MAU code and name in which the employee was assigned.
  2. Department Code-Name: The primary department code and name in which the employee was assigned.
  3. Person ID:  An HR/Payroll system generated number linking a person to all their assignment(s).
  4. Personnel Number (PERNR): 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.
  5. Professional Last Name: The last name of the employee as indicated in the HR/Payroll system.
  6. Professional First Name: The first name of the employee as indicated in the HR/Payroll system.
  7. Professional Middle Name: The middle name of the employee as indicated in the HR/Payroll system.
  8. Personnel Subarea Code: A further breakdown of Personnel Area. The principal organization aspects of HR are controlled at this level, including work schedules, pay scales, public holiday calendar, and wage types.
  9. 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.
  10. 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.
  11. Termination/Retirement Date:  The date the employee terminated employment or retired from the university.  
  12. Action Type Name: The type of action entered on the employee record in the HR/Payroll system.
  13. Action Reason Name: The reason why the action was entered on the employee record in the HR/Payroll system.
  14. Email Address: The employee’s MSU Email address (@msu.edu).
  15. Funding Organization Code:  The organization code (at the department level) providing position funding. 
  16. Funding Organization Name:  The organization name (at the department level) providing position funding.