Data Definitions (HRP1116)

The data columns used in the Leave of Absence Actions 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 sub-org in which the employee is assigned (if applicable).
  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. Name: The employee’s professional name as indicated in the HR/Payroll system.
  6. Personnel Subarea Code: 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.
  7. 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.
  8. 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.
  9. Job Title: The employee's primary job title or classification in which the employee is assigned.
  10. Pay Scale Level: The number level signifying range of possible pay assigned to the employee’s job title or classification.
  11. Annual Salary: The actual base salary.
  12. Years Of Service: The length of time an employee has been working.
  13. Action Start Date: The effective date of the action on the employee record.
  14. Action Type Code - Name: The type of action entered on the employee record in the HR/Payroll system.
  15. Action Reason Name: The reason why the action was entered on the employee record in the HR/Payroll system.
  16. Off Campus Name: The name of the county the employee’s office resides at (if applicable). Will generally populate for MSU Extension offices.
  17. Estimated Leave Return Date: The date set in the HR/Payroll system they are expected to return to work, or at a minimum follow up with the supervisor or Human Resources. This date is an estimate and may be extended.
  18. Birth Date:  The employee's date of birth as indicated in the HR/Payroll system. 
  19. Supervisor NetID:  The employee's supervisor's MSU NetID.