Drill Down Detail - HRP1066

The Salary Comparison Drill Down 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) from the summary report. The report provides users a detailed view of specific employee data across university organizations.  The Summary report will remain open in the same tab in which it was launched and can be accessed by navigating back to that tab. 

Use the Sort option to change the sort of the report, options are;

  • Organization
  • Department
  • Pay Scale Level
  • Job Title
  • Years of Service
  • FTE Salary

You can also take advantage of the additional filtering functions to perform analysis of the report. Three drop down options are provided: Organization, Department and Years of Service. 

Example of the Salary Comparison Drill Down Detail report.  See below for a list of the data column definitions. 

HRP1067 Detail report

Report Columns:

HRP1066 Detail columns

Data Column Definitions:

  1. Organization Code - Name: 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. 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.
  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 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.
  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.