Data Definitions (HRP962)

The data columns used in the Supervisors and Staff report are defined on this page. 

Supervisor columns:

  1. Dept Code-Name:  The primary department assigned to the Supervisor.
  2. Personnel Number:  An HR/Payroll system generated number linking the supervisor to their assignment.  
  3. Professional Name:  The supervisor’s professional name as indicated in the HR/Payroll system.  
  4. Job Code:  The job code assigned to the supervisor in the HR/Payroll system.  
  5. Job Title:  The supervisor’s primary job title or classification assigned in the HR/Payroll system.  
  6. Position Number:  An HR/Payroll system generated number linking the supervisor to a position.
  7. Capacity Utilization Level:  The percent of employment the supervisor is working.  
  8. Pay Scale Level:  The number level signifying range of possible pay assigned to the job title or classification of the supervisor.
  9. 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.  
  10. 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.  
  11. Employee Subgroup Code:  The employee subgroup code assigned to the supervisor.  
  12. Employee Subgroup Name:  The employee subgroup name assigned to the supervisor.  It is 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.
  13. Supervisor Email:  The supervisor’s MSU Email address (@msu.edu).  
  14. **  Off Campus Name:  The supervisor’s off campus location name.  

Employees Reporting to Supervisor columns:

  1. Org Code-Name:  The primary college or MAU assigned to the employee.
  2. Dept Code-Name:  The primary department assigned to the employee.
  3. Personnel Number:  An HR/Payroll system generated number linking the employee to their assignment.  
  4. Professional Name:  The employee’s professional name as indicated in the HR/Payroll system.  
  5. Job Code:  The job code assigned to the employee in the HR/Payroll system.  
  6. Job Title:  The employee’s primary job title or classification assigned in the HR/Payroll system.  
  7. Position Number:  An HR/Payroll system generated number linking the employee to a position.
  8. Capacity Utilization Level:  The percent of employment the employee is working.  
  9. Pay Scale Level:  The number level signifying range of possible pay assigned to the job title or classification of the employee.
  10. 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.  
  11. 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.  
  12. Employee Subgroup Code:  The employee subgroup code assigned to the employee.  
  13. Employee Subgroup Name:  The employee subgroup name assigned to the employee.  It is 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.
  14. Relationship Type Name:  The employee’s relationship to the supervisor.  
  15. Employee Email:  The employee’s MSU Email address (@msu.edu). 
  16. **  Off Campus Name:  The employee’s off campus location name. 

** - The Off Campus Name column is only included in the second list.