Viewing and Reporting on Total Compensation Data

This chapter provides an overview of viewing options and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the Viewing Options

You can use the Employee Total Compensation inquiry page to view compensation data or to check the results of the Employee Compensation report before printing it.

In Excel, you can view any base and variable compensation information from Human Resources. You cannot view Benefits Administration or payroll information with this feature.

Click to jump to top of pageClick to jump to parent topicViewing Compensation Data Online

To view total compensation data online, use the Review Employee Total Comp (TC_EE_COMP) component.

This section discusses how to view worker total compensation.

Click to jump to top of pageClick to jump to parent topicPage Used to View Total Compensation

Page Name

Object Name

Navigation

Usage

Review Employee Total Comp (review employee total compensation)

TC_EE_COMP

Compensation, Total Compensation, View Total Compensation, Review Employee Total Comp

View on screen the compensation for all workers within the specified groups. This inquiry page gives the same results as the Employee Total Compensation report, except the output is to the screen.

Click to jump to top of pageClick to jump to parent topicViewing Employee Total Compensation

Access the Review Employee Total Comp page.

From/Thru Date

Enter the dates for this inquiry. You can inquire on a subset of the plan’s period.

Amount Type

Select Compensation Amount, Payroll Amount, or (None). These values refer to the data sources.

Refresh

When you enter or modify one of the parameters, click this link to load the associated data onto the page.

Compensation Detail

This group box contains the worker’s compensation information.

Click to jump to top of pageClick to jump to parent topicViewing Compensation Data in Excel

To view compensation data in Excel, use the Transfer Comp Data to Excel (TC_EXCEL_RUNCTL) component.

This section discusses how to view compensation data in Excel.

Click to jump to top of pageClick to jump to parent topicPage Used to View Compensation Data in Excel

Page Name

Object Name

Navigation

Usage

Review Total Compensation

TC_EXCEL_RUNCTL

Compensation, Total Compensation, View Total Compensation, Transfer Comp Data to Excel

Launch Excel with information (base and variable pay) that you extract from Human Resources.

Click to jump to top of pageClick to jump to parent topicLaunching Excel

Access the Review Total Compensation page.

Population

Select whether you want Employee(s) or Group(s) in the results.

If you select Employee(s), you can select one or more EmplID. The worker’s name appears.

If you select Group(s), you can select one or more Group ID. The group’s description appears.

(Download)

Click to access Excel and have the data entered into a spreadsheet.

Note. When the Excel file is created, it is created and saved in the Default Log/Output directory on the server. To view this on the client machine, the file needs to be FTP’d to the client. Set up an FTP server for read and write access to the default log output directory that is used.

Create a URL identifier to give the client access to the file on the FTP server.

Click to jump to top of pageClick to jump to parent topicRunning Total Compensation Reports

This section discusses how to run total compensation reports.

Click to jump to top of pageClick to jump to parent topicCommon Elements Used in This Section

Amount Type

Select one: Compensation Amount, Payroll Amount, and (None). These values refer to the data sources.

Group ID

You can run the reports on a subset of the groups specified for the selected TC plan ID. Select the groups within the specified TC plan ID for which you want to run this report.

Click to jump to top of pageClick to jump to parent topicPages Used to Run Total Compensation Reports

Page Name

Object Name

Navigation

Usage

Benefit Statement

TC_BEN_RUN_CNTL

Compensation, Total Compensation, View Total Compensation, Total Comp Statement Report

Run the Total Compensation Statement (Benefits Statement) report (TC001) that provides a listing of all compensation for each individual, designed for distribution to workers.

Group Compensation or Employee Compensation Report

TC_GRP_RUN_CNTL

  • Compensation, Total Compensation, View Total Compensation, Group Detail Compensation Rpt

  • Compensation, Total Compensation, View Total Compensation, Group Summary Compensation Rpt

Use this page to run these reports:

  • Group Summary Compensation report (TC002). This report provides aggregated information for individuals within a group that you specify.

    Each compensation ID that you define reports a value. If, for example, you specify a group of five workers and define three compensation IDs, the Group Compensation report gives three values, one for each compensation ID. The values are summed for the group.

  • Employee Compensation Report (TC003). This report lists detailed information about each compensation type for each individual within a group that you specify. To check the results of the report before printing it, use the Employee Total Compensation Inquiry page.

    Note. Ad hoc awards entered directly in the TC warehouse are reported on a separate page for each worker.