Drill Down Detail - HRP1066

Drill Down Detail (HRP 1067) Salary Comparison Detail (HRP1067) is the report displayed when users utilize the “drill down” functionality by selecting a job title or classification or a slice from the rose chart. The report provides users a detailed view of specific employee data across university organizations.

Report Columns

  1. Organization: The primary college or MAU in which the employee is assigned.
  2. Department, Sub-Org: The primary department and sub-org (if applicable) in which the employee is assigned.
  3. Personnel Number: An HR/Payroll system generated number linking a person to an assignment. A person with concurrent employment will have multiple PERNRs.
  4. Professional Name: The employee’s professional name as indicated in the HR/Payroll system.
  5. Pay Scale Level: The number level signifying range of possible pay assigned to the employee’s job title or classification.
  6. Job Title: The employee’s job title or classification in which the employee is assigned.
  7. Employee 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.
  8. 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.
  9. 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.
  10. Off Campus Location: An employee’s work location off campus.
  11. Employment Percent: The percent of full time employment that the employee is working.
  12. Annual Salary: The actual base salary.
  13. FTE Salary: The base salary for a full year at 100% employment.
  14. Standard Deviation of FTE Salary for Job Title: The typical variation of salaries within the range of the job title or classification from the average (mean) or expected value. A high standard deviation indicates the classification salaries are spread out.
  15. Years of Service: The number of years the employee has worked. This is based on the employee’s retirement eligibility date.
  16. Years of Service Range: The range in which the number of years the employee has worked resides.
  17. Years in Level: The number of years the employee has remained in the pay grade (scale) level.
  18. Tenure/Continuing Status: The faculty, academic staff, or executive manager’s tenure or continuing appointment status.