Jobcode Detail tab

The JobCodeDetail (Department Jobcode and Employee Detail) tab displays payroll and productivity data by job class, job code, and employee. Use this tab to review detailed labor activity and analyze differences between actual and budget values.

How to use this tab

Load job code detail data

You can load job code detail data when opening or refreshing the report:

  • Select the Load JobCode Detail refresh variable

  • Expand a department using the arrow to load all job codes

  • Drill down to view job code and employee-level details

Worked and Paid views

  • The default view shows worked pay types

  • Select Paid when opening or refreshing the report to include non-worked pay types and total paid values

  • Column headers update based on the selected view

Pay type classifications

The tab groups payroll data into the following pay types:

  • Regular

  • Overtime

  • Education

  • Orientation

  • Premium (for dollars only)

You can review data at the job class level or drill down to job code and employee details.

Overtime and Premium Opportunities

This section shows estimated overtime and premium cost Additional labor cost paid above regular wages for specific pay types, such as overtime, shift differentials, call pay, or bonuses. opportunities at the employee level.

Some overtime and premium costs are expected based on operational needs. The report compares actual values to target thresholds A set limit or percentage used to determine when a value is considered acceptable or requires attention. and identifies costs that exceed those thresholds as potential reduction opportunities.

For example, nursing departments operate 24 hours a day, so shift differential Additional pay given to employees who work less desirable shifts, such as evenings, nights, or weekends. costs are expected. The target defines the expected level of these costs , and any amount above the target is shown as a potential reduction opportunity.

Default targets

  • Overtime target - 3.5%

  • Premium target - 8%

You can update these targets in the report.

Additional information

The Evaluation tab summarizes overtime and premium opportunities.

You must load the JobCodeDetail tab to calculate and view these values.

Column descriptions

This table describes the columns on the JobCode Detail tab.

Column group Field Description
Department Department Identifies the department.
Job hierarchy JobClass | JobCode | Employee Displays data grouped by job class, job code, and employee.
Hours (Actual Worked Hours) Regular, Overtime, Education, Orientation Displays hours worked by pay type.
Hours (Actual Worked Hours) Total Worked Displays total worked hours across pay types.
Worked FTEs Worked FTEs Displays full-time equivalents based on worked hours.
Worked FTEs Budget Wkd FTEs Displays budgeted full-time equivalents.
Salary Expense (Actual Worked Salary Expense) Regular, Overtime, Education, Orientation, Premium Displays labor cost by pay type.
Salary Expense Total Worked Displays total labor cost across pay types.
Salary Expense Budget Wkd Salaries Displays budgeted salary expense.
AHR (Average Hourly Rate) AHR Displays the average hourly rate based on actual values.
AHR Budget AHR Displays the target average hourly rate.
Overtime Opportunity Overtime % Prod Displays overtime as a percentage of productive hours.
Overtime Opportunity Overtime Opp Displays estimated overtime cost above the target threshold.
Premium Opportunity Premium % Prod Displays premium pay as a percentage of productive hours.
Premium Opportunity Premium Opp Displays estimated premium cost above the target threshold.

The Department Management Productivity report includes the following tabs: