Data Definitions (HRP1199)

The data columns used in the Individual Employee Employment History report are defined on this page.

  1. NETID:  The employee’s MSU assigned ID to be used for login access to MSU applications.  
  2. Person ID:  An HR/Payroll system generated number linking a person to all their assignments.
  3. 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.
  4. Last Name:  The employee’s last name as indicated in the HR/Payroll system.
  5. First Name:  The employee’s first name as indicated in the HR/Payroll system.
  6. Action Start Date:   The start date of the employee’s employment action as indicated in the HR/Payroll system. 
  7. Action End Date:  The end date of the employee’s employment action as indicated in the HR/Payroll system.
  8. Action Type Name:  The action type of the employee’s employment action as indicated in the HR/Payroll system.
  9. Status as of Action Start_Date:  The employee’s employment status as of the Action Start date indicated in the HR/Payroll system.
  10. Organization Code & Name:  The primary college or MAU code and name in which the employee is assigned.
  11. Employee Position Number:  The employee’s assigned position number as indicated in the HR/Payroll system.  
  12. Employee Position Title:  The employee’s position title based on position number in which the employee is assigned.
  13. Personnel Subarea:  The personnel subarea the employee is assigned. The principal organization aspects of HR are controlled at this level, including work schedules, pay scales, public holiday calendar, and wage types.
  14. Employee Group Name:  The employee group the employee is assigned; Union, Non-Union, Non-Employee/No Pay.
  15. Employee Subgroup Code & Name:  The employee subgroup code and name assigned to the employee.  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.