Data Definitions (HRP943)

The data columns used in the All Active and Inactive Employees in an Organization 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 sub-org code in which the employee is assigned (if applicable).
  6. Sub-Org Name: The sub-org name in which the employee is assigned (if applicable).
  7. Personnel Subarea Code: The personnel subarea code assigned to the employee in the HR/Payroll system. The principal organization aspects of HR are controlled at this level, including work schedules, pay scales, public holiday calendar, and wage types. 
  8. 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.
  9. 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.
  10. Personnel Number: An HR/Payroll system generated number linking a person to their assignment.
  11. Professional Last Name: The last name of the employee as indicated in the HR/Payroll system.  
  12. Professional First Name: The first name of the employee as indicated in the HR/Payroll system.
  13. Professional Middle Name: The middle name of the employee as indicated in the HR/Payroll system.
  14. Professional Name:  The last, first, and middle names combined of the employee 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 or classification in which the employee is assigned.
  17. MSU NetID:  The employee’s MSU Net ID as indicated in the HR/Payroll system.
  18. Email:  The employee's MSU email address (@msu.edu).
  19. Continuous Service Date: The date the employee was hired without any breaks in service. 
  20. Employment Status: The employment status identifies whether the employee is an active or inactive employee.