PeopleSoft Enterprise Human Resources 9.1 PeopleBook: Report Total Compensation

Setting Up Reporting Groups

This chapter provides an overview of reporting groups and discusses how to populate reporting groups.

Note. This chapter assumes that you are familiar with the concept of building groups.

Understanding Reporting Groups

Reporting for compensation is different from reporting for other aspects of HRMS. Therefore, the groups that you build in Total Compensation will probably differ from other groups that you build in HRMS. These groups are strictly for reporting.

For example, a compensation manager wants a report on her company's two industries, so she sets up groups as follows:

Industry A
- Executives Group 1.
- Sales Group 2.
- Non-exempt Group 3.
Industry B
- Executives Group 4.
- Sales Group 5.
- Non-exempt Group 6.

The process of populating reporting groups involves populating two tables, TC_TIME and TC_POPULATION. It also generates an exchange file (exchange.csv). This file stores the rates of exchange between the potential workers' job currencies and the currency of the total compensation reporting plan.

A third party application can load this file in a cube. This way, you can use the multi-currency function and switch between currencies. Compensation and payroll amounts can be displayed in any currency from the exchange file.

There is no limit to the number of reporting groups. However, an individual cannot belong to more than one reporting group. If, by mistake, an individual does belong to more than one group, his or her compensation is counted multiple times because of the roll-up structure of the Compensation Tree. You can avoid this by running the Group Build Overlapping Groups report.

You use this procedure to build a reporting group:

Use the Group Build pages to build groups.
To ensure that the populations in your groups do not overlap, run the Group Member Overlap report.
Use the groups to set up total compensation reporting plans.

Populating Reporting Groups

To populate reporting groups, use the Create Reporting Groups (TC_GROUP_RUNCTL) component.

This section discusses how to populate reporting groups.

Page Used to Populate Reporting Groups

Page Name	Definition Name	Navigation	Usage
Create Reporting Groups	TC_GROUP_RUNCTL	Compensation, Total Compensation, Calculate Total Compensation, Create Reporting Groups, Create Reporting Groups	Populate the reporting groups that you define.

Populating Reporting Groups

Access the Create Reporting Groups page (Compensation, Total Compensation, Calculate Total Compensation, Create Reporting Groups, Create Reporting Groups).

Total Comp Plan ID (total compensation plan ID)

Select from the options.

Total Comp Plan Effective Date (total compensation plan effective date)

Select from the options.

Run Type

Select the type of run:

Standard populates the TC_POPULATION table with all the workers from all the groups associated with the specified TC Plan ID. If you are rerunning this process, a standard run deletes all previous information and enters new data into the table.

Delete deletes all the group records.

Run

Click to run the Group Population process.

Total Comp Plan ID (total compensation plan ID)	Select from the options.
Total Comp Plan Effective Date (total compensation plan effective date)	Select from the options.
Run Type	Select the type of run: Standard populates the TC_POPULATION table with all the workers from all the groups associated with the specified TC Plan ID. If you are rerunning this process, a standard run deletes all previous information and enters new data into the table. Delete deletes all the group records.
Run	Click to run the Group Population process.