Data Definitions (HRP1068)

The data columns used in the End-dated Employees Listing report are defined on this page.

  1. Organization Code:  The primary college or MAU code in which the employee is assigned. 
  2. Organization Name:  The primary college or MAU name in which the employee is assigned. 
  3. Department Code:  The primary department code in which the employee is assigned.
  4. Department Name:  The primary department name in which the employee is assigned.
  5. Sub-Org Code: The primary sub org department in which the employee is assigned.
  6. Sub-Org Name: The primary sub org department in which the employee is assigned.
  7. Person ID:  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.
  8. 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.
  9. Professional Last Name:  The last name of the employee as indicated in the HR/Payroll system.
  10. Professional Middle Name:  The middle name of the employee as indicated in the HR/Payroll system.
  11. Professional First Name:  The first name of the employee as indicated in the HR/Payroll system.
  12. Assignment Start Date: The employee’s assignment start date as indicated in the HR/Payroll system.  
  13. Assignment End Date:  The employee’s assignment end date as indicated in the HR/Payroll system.
  14. Primary Assignment End Date:  The employee’s primary assignment end date as indicated in the HR/Payroll system.
  15. Job Code:  The employee’s primary job code in which the employee is assigned.
  16. Job Title:  The employee’s primary job title in which the employee is assigned.
  17. Personnel Subarea:  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.
  18. Employee Group:  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.
  19. Employee Subgroup Code:  The HR/Payroll code for employee subgroup.
  20. 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.
  21. Employment Status:  The employment status identifies whether the employee is an active or inactive employee or withdrawn from employment at the university.
  22. Employment Percent:  The percent of employment the employee is working.
  23. Email:  The employee's MSU email address (@msu.edu).
  24. Current Supervisor:  Name of supervisor as indicated in the HR/Payroll system.