Data Definitions (HRP1137)

The data columns used in the TOC Break in Service report are defined on this page.

  1. Last Name: The employee’s last name as indicated in the HR/Payroll system.
  2. First Name: The employee’s first name as indicated in the HR/Payroll system.
  3. Middle Name: The employee’s middle name as indicated in the HR/Payroll system.
  4. Person ID: An HR/Payroll system generated number linking a person to all of their assignments.
  5. ZPID: The unique identifier assigned to the employee.
  6. 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.
  7. Current Status: The current status identifies whether the employee is an active or inactive employee, or withdrawn from employment at the university.
  8. 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.
  9. Personnel Subarea Code – Name: 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.
  10. Job Title: The employee's primary job title or classification in which the employee is assigned.
  11. Action Name: The type of action entered on the employee record in the HR/Payroll system.
  12. Employee Primary Assignment Start Date: Start date of employee’s new primary assignment.
  13. Primary Assignment End: End date of employee’s primary assignment.
  14. Organization Code – Name: The primary college or MAU in which the employee is assigned.
  15. Department Code – Name: The primary department in which the employee is assigned.

Note: When seeing an action type of “Termination,” the Employee Primary Assignment Start Date reflects the effective date of the termination, while the Primary Assignment End reflects the documented end date of the assignment being terminated.