Compensation Drill Through Form

Overview

The Compensation Drill Through form allows you to view your data beginning at a summary level and drill down to detailed data and return to summary level. While viewing detailed data at the employee level, you can make updates if needed. The form shows a summary of compensation and benefits for each unique combination of DeptID, fund bucket, and chartfield1.

Topics

Open the HCP Total Empl by Entity – Account Drill through form

To access the form, select Total Empl By Entity – Account Drill through from My Task List

HCP Task List with Compensation Drill Through highlighted

The form presents the HCP accounts for the selected entity, organized by DeptID, fund bucket, and chartfield1.

Drill into account details

To drill into the details, right-click on an account and select Account Details by Employee.

Account Details ByEmpl highlighted

Account Details

The Account Details shows a list of all employees followed by a summary by job code, and finally a summary of all job codes. 

List view by employee with intersection details

More detail about an employee

To see more details about a specific employee, right-click on the employee and select Edit EE Details.

Edit employee details

Employee Details Drill Through

The Employee Details Drillthrough form allows you to update the Monthly Pay Rate and/or Distributions, just as you would on the Manage Existing Employees and Job Codes form. The Salary Expense, Benefits, and Total Comp tabs are calculated, so you cannot make edits on those tabs.

Employee Details Drill Through

Return to summary level

The form presents breadcrumbs in the upper left corner to show the path followed to get to the current view. Select any link to return to the summary level you want to view.

Employee Details Drill Through with breadcrumbs highlighted

Forms and data are connected

Account Details are not just for employees in the Manage Existing Employees and Job Codes form. If the entity presented has pooled positions and/or DeptID comp adjustments, the Account Details form presents those. Right-click on an entry in the first column to go to the detail form.

Employee list connect to form

Right-click on

Opens this form

Employee

Manage Existing Employees and Job Codes

Dept ID Adjustments

Dept ID Comp Adjustments

Pooled Employee

Create and Manage HCP Pooled Positions

Data entered in one form will be immediately present on all other relevant forms. For example, if you update the monthly pay rate for an employee on the Employee Details Drillthrough form, the update is also present on the Manage Existing Employees and Job Codes form.

Data is updated in real time

With the Total Empl by Entity – Account Drill through form, you can get summary level reporting in real time. There is no need to wait for the data load that happens every three hours in the HCP reporting module.

 Practice

Complete Exercise 8 to practice.

End of Self-Study

This concludes the self-study portion of Navigating HCP. Please be sure to join the scheduled group session to review the self-study and work on a case study.