Data Definitions (HRP1015)

The data columns used in the Hires and Transfers into a College or Department report are defined on this page.

  1. Organization Code-Name: The primary college or MAU in which the employee is assigned. 
  2. Department Code-Name:  The primary department in which the employee is assigned.
  3. Sub-Org Code-Name: The primary sub org department in which the employee is assigned. 
  4. 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.
  5. Professional Last Name:  The employee’s professional last name as indicated in the HR/Payroll system.
  6. Professional First Name:  The employee’s professional first name as indicated in the HR/Payroll system.
  7. Professional Middle Name: The employee’s professional middle name as indicated in the HR/Payroll system.
  8. Action Type:   The type of action entered on the employee record in the HR/Payroll system.
  9. Action Reason:  The reason why the action was entered on the employee record in the HR/Payroll system.
  10. Action Start Date:  The effective date of the action on the employee record.
  11. Primary Assignment End Date:  The employee’s primary assignment end date.  
  12. 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.
  13. 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. 
  14. Employee Subgroup:  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.
  15. Email:  The employee’s MSU email address (@msu.edu).  
  16. Position Number:  The employee’s position number assigned to the job title or classification.    
  17. Job Title:  The employee's primary job title or classification in which the employee is assigned.
  18. Pay Scale Level: The number level signifying range of possible pay assigned to the job title or classification. 
  19. Employment Percent:  The employee’s employment percentage.  
  20. Annual Salary:  The employee’s base salary based on employment percentage.    
  21. FTE Salary:  The employee’s base salary for a full year at 100% employment, not including bonuses or commissions.
  22. Current Status:  The employee’s current status as indicated in the HR/Payroll system.  
  23. Supervisor Name:  Name of supervisor as indicated in the HR/Payroll system.
  24. Supervisor Title:  The supervisor’s primary job title or classification.  
  25. Supervisor Email:   The supervisor’s MSU email address (@msu.edu).