Browser version scriptSkip Headers

Oracle® Fusion Applications Compensation Management Implementation Guide
11g Release 1 (11.1.1.5.0)
Part Number E20376-01
Go to contents  page
Contents
Go to Previous  page
Previous
Go to previous page
Next

23 Define Total Compensation Statements

This chapter contains the following:

Define Total Compensation Statements: Overview

Total Compensation Statement Building Blocks: How They Fit Together

Compensation Items and Sources: Explained

Compensation Category Types: Explained

Total Compensation Categories and Subcategories: Critical Choices

Total Compensation Statement Definitions: Critical Choices

Total Compensation Statement Display Options: Points to Consider

Worked Examples for Define Total Compensation Statements

FAQs for Define Total Compensation Statements

Define Total Compensation Statements: Overview

Configure the design, content, and delivery of a compensation statement that includes nontraditional forms of pay such as fringe benefits, cost of benefits, and paid time off, in addition to traditional forms of pay such as base pay and variable compensation.

Application implementors and compensation administrators can:

To define total compensation statements, start from the Setup and Maintenance Overview page. Select Navigator - Setup and Maintenance.

Note

Compensation administrators can maintain total compensation statements from the Compensation work area. Select Navigator - Compensation.

Total Compensation Statement Building Blocks: How They Fit Together

To construct a total compensation statement, you create compensation items, attach them to compensation categories, and arrange the categories hierarchically in a statement definition. After specifying the statement period and configuring other display options, you generate the statements and make them available for workers to view.

This figure shows the construction of a total compensation statement definition and how it displays items and categories.

Construction of a total compensation
statement

Compensation Items and Sources

Compensation items are the foundation on which the statement is built. Define compensation items that represent actual amounts paid to workers, costs incurred by the company, or the value of accrued time off, for example. Map each item to the specific source from which the compensation information is retrieved. The sources of compensation information include payroll element entries, payroll balances, and benefit balances. You can also create fast formulas to retrieve compensation from other sources. You can use compensation items across statement definitions.

Compensation Categories

Arrange compensation items into categories, such as cash compensation, benefits, time off, or stock history, which enable you to display related compensation items together. Compensation categories display information in tables. The category type determines the table columns and the general layout of a category page within the statement. A row in a category table can contain compensation items, or it can contain another category used as a subcategory that contains its own compensation items. You can use compensation categories across statement definitions.

Statement Definition

The statement definition acts as a template and determines the layout and content of the generated statement. Add the categories that contain the items you want to include in the statement, and arrange them into a hierarchy. You can nest categories within other categories to create subcategories. Define periods for which statement data is valid and customize an optional welcome message for each period. You can reuse statement definitions by creating new statement periods and then modify the definition for subsequent periods. You can also duplicate a definition as the starting point for other definitions.

Statement Display

Top-level categories in the statement definition appear in the optional summary page and as separate pages in the statement. From each top-level category, viewers can view item details, or drill into items and subcategories, depending on how the category is configured. The statement can also display optional graphs, worker instructions, and supplemental information, such as compensation policies or benefit plan details.

Compensation Items and Sources: Explained

Compensation items are the lowest level of detail on which the total compensation statement is based. Items can hold monetary, nonmonetary, date, or text values. Compensation items must be added to a compensation category to include them in a total compensation statement. You cannot add items to statement definitions directly.

These are significant aspects of compensation items:

Source Types

You map compensation items to the source of the compensation to retrieve the compensation information. Compensation items using different source types have slightly different data entry configurations based on the data required for each type.

This table describes the source types and special data entry requirements.


Source Type

Description

Additional Data Entry Requirements

Payroll Element

Compensation retrieved from payroll elements, such as salary and bonus earnings.

Legislative Data Group and Input Value

Payroll Balance

Compensation retrieved from payroll balance records, such as commissions or company-paid taxes.

Legislative Data Group and Dimension

Benefit Balance

Compensation entered as a one-time benefit balance, such as data obtained from a legacy compensation system.

None

Formula

Create a formula to retrieve compensation information that is not stored in the other predefined source types.

Type of Compensation, nonmonetary Unit of Measure, and Currency. (Formula unit or currency overrides item definition)

Compensation Type and Unit of Measure

The compensation item inherits from the source the default type of compensation, such as monetary or nonmonetary, and the monetary currency or nonmonetary unit of measure. In some cases you can override the default compensation type and nonmonetary unit of measure when defining the item.

Note

If a formula that retrieves compensation also specifies currency or nonmonetary unit of measure, the formula currency or unit overrides the currency or unit specified in the item definition.

Estimated Values

For each item, you can select the Estimated amount option to indicate that this compensation is not the actual amount paid. In the statement definition, you can specify whether to display the estimated amount indicator for amounts designated as estimated.

Rounding

You can specify how to round nonmonetary amounts.

Compensation Category Types: Explained

The compensation category type determines the table columns and general layout of the category page in the total compensation statement, as well as whether the category can include subcategories within it.

These are the category types:

Benefits, Cash Compensation, Savings and Retirement

The Benefits, Cash Compensation, Savings and Retirement, and Other categories share the same basic category structure. These category types permit you to add compensation items as well as categories nested within the category as subcategories. By default, the category table display includes a worker contribution column and an employer contribution column, as well as a description. You can hide columns that do not apply.

Time Off

The Time Off category does not permit you to add categories as subcategories. It includes columns for the type of time off, monetary value of the time off, and accrued balance. You can edit column labels and configure each row name in the category table to be a link to time off information, such as a holiday schedule for paid holidays.

Stock History

The Stock History category type displays up to 27 columns of data from the database table that stores workers' stock details. When you configure the category, you can select which types of stock to include in the category, such as incentive stock options, non-qualified stock options, restricted stock, and so on. By default, many of the columns are hidden or only visible in the statement optionally, if the worker selects the column in the statement View menu. You can alter which columns are hidden or optionally available in the statement, and edit the column labels.

Custom

If you select the Custom category type, you must also specify the number of columns, up to five, that you want to include in the category, and then configure the column labels and select compensation items for the table rows. For example, you might use the custom category type to display information about commissions by including columns such as sales target, units sold, percentage over target, percentage under target, and commission amount. You cannot add subcategories to the Custom category type.

Other

The Other category type shares the same basic structure as the Cash Compensation or Benefits category type, but you can use it for any type of compensation.

Total Compensation Categories and Subcategories: Critical Choices

Group related compensation together into compensation categories for display in total compensation statements. When planning how to group compensation items and categories for display, you must consider compatibility of the grouped compensation and some display options. The following factors affect your ability to add compensation items or other categories to a category and how you can display the category in the statement:

Category Type

When you create a new category, you first select the category type. The category type determines the table columns and general layout of the page in the statement. The category types are Benefits, Cash Compensation, Stock History, Custom, Savings and Retirement, Time Off, and Other. You can add subcategories only to categories of Benefits, Cash Compensation, Savings and Retirement, or Other category type.

Important

You can use a category in more than one statement. Once you use a category in any statement, you cannot change the category type.

Contribution Type and Unit of Measure

A category's monetary or nonmonetary contribution type and nonmonetary unit of measure are determined by the contribution type and unit of measure of the items or subcategories added.

All items and subcategories within a nonmonetary subcategory must share the same unit of measure.

Level of Detail

When you create a category, you specify how you want to display the category details in the statement.

Choose one of these levels of detail for the category:

When deciding on the level of detail display option, consider the following effects of showing all details on a single page:

Total Compensation Statement Definitions: Critical Choices

Consider these statement elements and options when determining how many different total compensation statement definitions you require and planning the presentation of content in each:

Including Compensation Items and Categories

The total compensation statement definition comprises compensation items added to compensation categories to build the structure of the statement. You can define these building block components first and then associate them hierarchically to build the statement definition, or you can create the item and category components as you build the statement hierarchy. Because you can reuse items and categories across multiple statements, you might find it more efficient to create the items and categories before creating statement definitions.

The total compensation statement can report compensation across countries. You can add compensation items with sources, such as payroll elements, that belong to different legislative data groups.

Specifying the Statement Audience

When you generate statements for a statement definition, you can select the statement audience at run time using the following population filter parameters: business unit, benefits group, legal employer, country, a person selection formula that you define, or a single person that you select.

In addition, you might want to configure different statement definitions for different statement audiences within the populations determined by the run time population filters. For example, within a business unit, you might create separate statement definitions for individual contributors and executive level workers. Accomplish this by creating eligibility profiles that differentiate between individual contributors and executive workers, and attach each to the corresponding statement definition.

Defining Statement Periods

Configure statements to cover any period of time by specifying start and end dates. You can create multiple periods at one time. For each statement period, further specify:

Duplicating Statement Definitions

You can duplicate a statement definition and edit it to create a new definition. For example, to create the definition for executive level workers, you could duplicate the statement definition for individual contributors, add additional compensation categories or items, and associate a different eligibility profile.

Reusing Statements in Other Periods

You do not need to recreate statement definitions for each year or period. You can reuse an existing statement definition by adding new periods. You might also want to update the welcome message, add or edit the items and categories included, or modify the display of graphs and tables.

Total Compensation Statement Display Options: Points to Consider

You have many options to control the layout and display of tables and categories in total compensation statements, as well as additional options for displaying graphs, descriptive text, and supplemental information. In general, you configure display options for category detail pages during category setup. During statement definition setup, you configure top-level categories and the summary page.

This table lists and compares the display options available when creating or editing compensation categories and compensation statement definitions.


Display Option

Category Setup

Statement Definition Setup

Hide table columns

Yes

Yes: summary page columns

Rename table columns

Yes

Yes: top-level categories only

Configure display of zero values

Yes

Yes: top-level categories only

Configure graph display

Yes

Yes: in summary page

Add descriptive text

Yes

Yes: in summary page

Add supplemental text

Yes

Yes: in summary page

Change vertical display order

Yes

Yes: in summary page

Hide regions for graphs or descriptions

Yes

Yes: in summary page

Exclude category from statement summary

No

Yes: top-level categories only

Hide or show estimated amount indicator

No

Yes

Include and hide welcome message

No

Yes

Include and hide statement summary page

No

Yes

Hiding Columns

When you edit the column properties to hide a column in the statement, the data that the column would display is not included in summary or detail tables or graphs.

Here are points to consider when hiding columns:

Displaying Zero Contribution Values

When you design categories for a statement, decide how to handle rows for categories, subcategories, and items for which a worker has no values to display during the statement period, such as when a worker has not received any stock options during the period or a worker is not participating in a compensation or benefit plan.

This table describes the zero value display options.


Statement Element

Display Options When All Contribution Values are Zero

Category and item rows

Display the row in the statement or hide it.

Subcategory rows

Display or hide the row in the high-level category page and permit or prevent drilling to the subcategory detail page.

Top-level categories

Display or hide the top-level category page in the statement.

If you choose to display the row or category page with zero values, you can optionally compose a message to display in the statement that explains the lack of values or calls attention to missed opportunities, such as participation in a stock purchase plan.

Displaying Graphs

You can display up to two graphs for each category. If you include a summary page in the statement, you can also include up to two graphs each in the Monetary and Nonmonetary sections of the summary.

For each graph that you choose to display, you must specify:

Note

A graph cannot include columns containing text, dates, more than one nonmonetary unit of measure, or a combination of monetary and nonmonetary values. For example, a graph that mixes shares of stock, a company car, and fitness membership would not provide clear information.

Denoting Estimated Amounts

When creating compensation items, you can identify whether the item amounts are estimates. At the statement level, you specify whether to display or hide the indicator that visually denotes amounts as estimated.

Composing a Welcome Message

For each statement period, you can compose an optional welcome message, personalized with each worker's name, that uses rich text and includes hyperlinks. If included, the welcome message is the first page the worker sees in the statement.

Configuring the Statement Summary Page

The optional statement summary page provides workers with a high-level view of their total compensation in graphs and tables. The summary displays summed totals of the top-level categories included in monetary and nonmonetary sections. Viewers can drill down to detailed category pages from the summary page or from the navigation links in the regional area.

The summary page comprises three optional sections that you can configure.

Note

If you include a graph in the nonmonetary section, all top-level categories in the nonmonetary summary should share the same unit of measure. You can exclude individual top-level categories from the summary.

Worked Examples for Define Total Compensation Statements

Creating a Bonus Category: Worked Example

This example demonstrates how to create a bonus category that includes a profit sharing bonus, a new hire bonus, and a quarterly bonus. The new hire and quarterly bonus items already exist and are reused in this category.

The following table summarizes key decisions for the Profit Sharing compensation item in this scenario.


Decision to Consider

Item in This Example

What compensation does the item represent?

Profit sharing bonus

What is the source type?

Payroll element

What is the legislative data group?

USA

The following table summarizes key decisions for the category in this scenario.


Decision to Consider

Category in This Example

What is the category type?

Cash Compensation

Display category details in the statement at what level?

Viewers see all details on one page.

Add items? (Describe)

Yes: Profit sharing bonus, new hire bonus, and quarterly bonus.

Add other categories as subcategories? Describe

No

Display graphs? (No or Yes?) One or two? What type?

Yes. Two: Bar and stacked bar.

Hide or edit any columns in the category?

Hide worker contributions because this is a cash compensation category. Edit company contribution column name to make it familiar to workers.

Display the row if values are zero in the period?

No

Create a profit sharing bonus item, then create a bonus category and attach the item you created along with other existing bonus items and configure display options. Use the default values except where indicated.

Prerequisites

  1. Create a payroll element named Profit Sharing Bonus using the USA legislative data group.
  2. Create the following compensation items using payroll elements in the USA legislative data group:

Creating a Compensation Item

Use the default values except where indicated.

  1. In the Compensation work area, click Manage Compensation Items to open the Manage Compensation Items page.
  2. Click Create.
  3. On the Create Compensation Item page, complete the fields as shown in this table:

    Field

    Value

    Item Name

    Profit Sharing Bonus

    Source Type

    Element entry

    Legislative Data Group

    USA

    Payroll Element

    Profit Sharing Bonus

    Input Value

    Pay Value


  4. Click Save and Close.

Entering Category Details and Adding Items

  1. In the Compensation work area, click Manage Compensation Categories to open the Manage Compensation Categories page.
  2. Click Create.
  3. On the Create Compensation Categories page, complete the fields, as shown in this table.

    Field

    Value

    Name

    Bonus

    Category Type

    Cash Compensation


  4. Click Continue.
  5. On the Create Category page, Table tab, select Viewers see all details on one page in the Level of Detail field.
  6. Click Add Items three times to add three new rows.
  7. Complete the fields for each new row, entering a name and description of the category row and selecting compensation items for the contribution column, as shown in this table.

    Name

    Description

    Company Contribution (Items)

    Profit Sharing

    Profit Sharing Bonus

    Profit Sharing Bonus

    New Hire

    New Hire Bonus

    New Hire Bonus

    Quarterly

    Quarterly Bonus

    Quarterly Bonus


  8. Click Edit Column Properties and select the Your Contribution column.
  9. Select Do not display in the statement.
  10. Click OK.
  11. Click Edit Column Properties and select the Company Contribution column.
  12. Enter Amount in the Column Label field.
  13. Click OK.

Configuring Display Options.

  1. Select the Graphs tab.
  2. Complete the fields for two graphs, as shown in this table.

    Field

    Value for the First Graph

    Value for the Second Graph

    Graph Title

    Your Bonuses

    How Your Bonuses Add Up

    Graph Type

    Bar

    Bar - stacked

    Graph Items

    Amount

    Amount


  3. Click Save.
  4. Click OK in the confirmation.
  5. Select the Descriptive Text tab.
  6. Enter any text here to describe what is included in this category or details about policies, and format it appropriately.
  7. Click Reorder Components at the top of the page.
  8. Select Descriptive Text and click the downward arrow until Descriptive Text appears below Graphs.
  9. Click OK.
  10. Click Save and Close.

Creating a Benefits Category: Worked Example

This example demonstrates how to create a benefits category that includes medical, dental, vision, disability insurance, and life insurance.

The following table summarizes key decisions for the compensation items in this scenario.


Decision to Consider

First Item

Second Item

What compensation does the item represent?

Worker contribution for medical benefit

Company contribution for medical benefit

What is the source type?

Payroll element

Payroll element

What is the legislative data group?

USA

USA

The following table summarizes key decisions for the category in this scenario.


Decision to Consider

Category in This Example

What is the category type?

Benefits

Display category details in the statement at what level?

Display details of item rows on separate pages that viewers drill to for details.

Add items? (Describe)

Yes: Both worker and company contributions for medical, dental, vision, disability insurance, and life insurance benefits.

Add other categories as subcategories? Describe

No

Display graphs? (No or Yes?) One or two? What type?

Yes. Two: Stacked bar and pie chart.

Hide or edit any columns in the category?

No

Display the row if values are zero in the period?

No

Create items for medical insurance, then create a benefits category and attach the items you created along with eight existing benefits items and configure display options. Use the default values except where indicated.

Prerequisites

  1. Create the following payroll elements using the USA legislative data group.
  2. Create the following compensation items using payroll elements in the USA legislative data group:

Creating a Compensation Item

Use the default values except where indicated.

  1. In the Compensation work area, click Manage Compensation Items to open the Manage Compensation Items page.
  2. Click Create.
  3. On the Create Compensation Item page, complete the fields as shown in this table:

    Field

    Value

    Item Name

    Medical Worker Contribution

    Source Type

    Element entry

    Legislative Data Group

    USA

    Payroll Element

    Medical Worker Contribution

    Input Value

    Pay Value


  4. Click Save and Create Another.
  5. On the Create Compensation Item page, complete the fields as shown in this table:

    Field

    Value

    Item Name

    Medical Company Contribution

    Source Type

    Element entry

    Legislative Data Group

    USA

    Payroll Element

    Medical Company Contribution

    Input Value

    Pay Value


  6. Click Save and Close.

Entering Category Details and Adding Items

  1. In the Compensation work area, click Manage Compensation Categories to open the Manage Compensation Categories page.
  2. Click Create.
  3. On the Create Compensation Categories page, complete the fields, as shown in this table.

    Field

    Value

    Name

    Benefits

    Category Type

    Benefits


  4. Click Continue.
  5. On the Create Category page, Table tab, select Viewers drill into line items to see details in the Level of Detail field.
  6. Click Add Items five times to add five new rows.
  7. Complete the fields for each new row, entering a name and description of the category row and selecting compensation items for each contribution column in the category, as shown in this table.

    Name

    Description

    Your Contribution (Items)

    Company Contribution (Items)

    Medical

    Amounts reflect your coverage.

    Medical Worker Contribution

    Medical Company Contribution

    Dental

    Amounts reflect your coverage.

    Dental Worker Contribution

    Dental Company Contribution

    Vision

    Amounts reflect your coverage.

    Vision Worker Contribution

    Vision Company Contribution

    Disability Insurance

    LTD provides income protection.

    Disability Worker Contribution

    Disability Company Contribution

    Life Insurance

    Life insurance is a core benefit.

    Life Insurance Worker Contribution

    Life Insurance Company Contribution


Configuring Display Options.

  1. Select the Graphs tab.
  2. Complete the fields for two graphs, as shown in this table.

    Field

    Value for the First Graph

    Value for the Second Graph

    Graph Title

    Employee Versus Company Contributions

    Total Contribution Comparison

    Graph Type

    Bar

    Pie

    Graph Items

    Your Contribution, Company Contribution

    Your Contribution, Company Contribution


  3. Click Save.
  4. Click OK in the confirmation.
  5. Select the Descriptive Text tab.
  6. Enter any text here to describe what is included in this category or details about policies, and format it appropriately.
  7. Click Reorder Components at the top of the page.
  8. Select Descriptive Text and click the downward arrow until Descriptive Text appears below Graphs.
  9. Click OK.
  10. Click Save and Close.

Creating a Custom Category for Commissions: Worked Example

This example demonstrates how to create a Commissions category using the Custom category type.

The following table summarizes key decisions for the category in this scenario.


Decision to Consider

Category in This Example

What is the category type?

Custom

Display category details in the statement at what level?

Viewers see all details on one page.

Add items? (Describe)

Yes: Sales target, sales revenue, and commissions items for year end.

Add other categories as subcategories? Describe

No

Display graphs? (No or Yes?) One or two? What type?

Yes. Two bar charts, one for revenue generated and one for commissions earned.

Hide or edit any columns in the category?

Edit column labels.

Display the row if values are zero in the period?

No

Create a Custom category, attach existing compensation items, and configure display options. Use the default values except where indicated.

Prerequisites

  1. Create the following compensation items:

Entering Category Details and Adding Items

  1. In the Compensation work area, click Manage Compensation Categories to open the Manage Compensation Categories page.
  2. Click Create.
  3. On the Create Compensation Categories page, complete the fields, as shown in this table.

    Field

    Value

    Name

    Commissions

    Category Type

    Custom

    Number of Item Columns

    3


  4. Click Continue.
  5. On the Create Category page, Table tab, select Viewers see all details on one page in the Level of Detail field.
  6. Click Edit Column Properties and select the Your Contribution column.
  7. Enter Sales Target in the Column Label field.
  8. Click OK.
  9. Click Edit Column Properties and select the Company Contribution column.
  10. Enter Sales Revenue in the Column Label field.
  11. Click OK.
  12. Click Edit Column Properties and select the Custom Column 3 column.
  13. Enter Commission in the Column Label field.
  14. Click OK.
  15. Click Add Items.
  16. Complete the fields for the new row, entering a description of the category row and selecting a compensation item for each column in the category, as shown in this table.

    Name

    Description

    Sales Target (Item)

    Sales Revenue (Item)

    Commission (Item)

    Row 1

    Year End Activity

    Sales Target Year End

    Sales Revenue Year End

    Commission Year End


    Note

    The Name column does not show in the statement when the level of detail is configured to display all details on a single page.

Configuring Display Options.

  1. Select the Graphs tab.
  2. Complete the fields for two graphs, as shown in this table.

    Field

    Value for the First Graph

    Value for the Second Graph

    Graph Title

    Revenue Generated

    Commissions Earned

    Graph Type

    Bar

    Bar

    Graph Items

    Sales Revenue

    Commissions


  3. Click Save.
  4. Click OK in the confirmation.
  5. Select the Descriptive Text tab.
  6. Enter any text here to describe what is included in this category or details about policies, and format it appropriately.
  7. Click Reorder Components at the top of the page.
  8. Select Descriptive Text and click the downward arrow until Descriptive Text appears below Graphs.
  9. Click OK.
  10. Click Save and Close.

Creating a Stock History Category: Worked Example

This example demonstrates how to create a stock history category for nonqualified stock options with vesting information.

The following table summarizes key decisions for the category in this scenario.


Decision to Consider

Category in This Example

What is the category type?

Stock History

Display category details in the statement at what level?

Viewers see all details on one page.

Add items? (Describe)

Not applicable

Add other categories as subcategories? Describe

Not applicable

Display graphs? (No or Yes?) One or two? What type?

Yes. One: Bar.

Hide or edit any columns in the category?

Accept most default column visibility settings. Make some adjustments to visibility of vested share columns and grant number. Edit some column labels for display on the statement.

Display the row if values are zero in the period?

Not applicable

Create a stock history category and configure column visibility and graphs.

Note

The Stock Details table must contain stock data.

Entering Category Details and Configuring Columns

  1. In the Compensation work area, click Manage Compensation Categories to open the Manage Compensation Categories page.
  2. Click Create.
  3. On the Create Compensation Categories page, complete the fields, as shown in this table.

    Field

    Value

    Name

    Stock History

    Category Type

    Stock History


  4. Click Continue.
  5. On the Create Category page, Table tab, select Non-Qualified Stock Option in the Grant Type field.
  6. Edit the column labels and availability of column types, as shown in this table, using the default values of columns not listed.

    Sequence

    Column Type

    Column Label

    Available for Display

    1

    Original Grant Date

    Grant Date

    (Use default)

    3

    Grant Number

    (Use default)

    Select

    10

    Original Value at Grant

    Grant Value

    (Use default)

    16

    Estimated Market Value of Total Shares

    Estimated Market Value

    (Use default)

    17

    Vested Shares

    (Use default)

    Select

    18

    Exercised Shares

    (Use default)

    Select

    20

    Estimated Gain from Vested Shares

    (Use default)

    Deselect


Configuring Display Options.

  1. Select the Graphs tab.
  2. Complete the fields, as shown in this table.

    Field

    Value for the First Graph

    Graph Title

    Vested Versus Unvested Shares

    Graph Type

    Bar

    Nonmonetary Graph Items

    Vested Shares, Unvested Shares


  3. Click Save.
  4. Click OK in the confirmation.
  5. Select the Descriptive Text tab.
  6. Enter any text here to describe what is included in this category or details about policies, and format it appropriately.
  7. Click Reorder Components at the top of the page.
  8. Select Descriptive Text and click the downward arrow until Descriptive Text appears below Graphs.
  9. Click OK.
  10. Click Save and Close.

Creating a Total Compensation Statement: Worked Example

This example demonstrates how to create, generate, and view a total compensation statement that contains two top-level categories, one for cash compensation and one for stock. The statement definition is for individual contributors whose salaries are quoted on an annual basis. The categories added as subcategories have already been created for other statement definitions and are reused in this definition.

The following table summarizes key decisions for the compensation item in this scenario.


Decision to Consider

Item in This Example

What compensation does the item represent?

Base pay for exempt workers with annual salary

What is the source type?

Payroll element

What is the legislative data group?

USA

The following table summarizes key decisions for the categories in this scenario.


Decision to Consider

Cash Compensation Category

Stock Category

What is the category type?

Cash Compensation

Other

Display category details in the statement at what level?

Display details of item and subcatgory rows on separate pages that viewers drill to for details.

Display details of item and subcatgory rows on separate pages that viewers drill to for details.

Add items? (Describe)

Yes: Base pay for exempt workers

Not directly, only through subcategories.

Add other categories as subcategories? Describe

Yes. One: Bonuses Exempts

Yes. Two: ESPP Exempts and Stock History Exempts

Display graphs? (No or Yes?) One or two? What type?

Yes. Two: Bar and stacked bar.

No

Hide or edit any columns in the category?

Hide worker contributions because this is a cash compensation category. Edit subcategory names to make them familiar to workers.

Edit subcategory names to make them familiar to workers.

Display the row if values are zero in the period?

No

Display the Employee Stock Purchase Plan row but prevent drilling to details.

The following table summarizes key decisions for the statement definition in this scenario.


Decision to Consider

Statement Definition in This Example

Include which top-level categories?

Cash Compensation and Stock

What is the statement period?

Calendar year 2010

Also create a second annual period to be ready for the next year.

Include welcome message?

Yes. Address recipients by first name.

Include summary page?

Yes

What is the statement audience for eligibility?

Individual contributors whose salaries are quoted on an annual basis

What is the population for statement generation?

Legal employer: Infusion USA

Summary of the Tasks

Create a new total compensation statement definition using a new item and two new categories that you create, assembled with some existing categories that contain items. Generate and view statements using the new definition.

  1. Create a compensation item.

  2. Create a cash compensation category and add the item and a subcategory.

  3. Create a stock category and add subcategories.

  4. Create a statement definition.

  5. Configure optional eligibility and statement summary page.

  6. Generate and view statements.

Prerequisites

  1. Create a payroll element named Base Pay Exempts that represents base pay earnings for salaried exempt workers in the USA legislative data group.
  2. Create the following compensation categories with items:
  3. Create an eligibility profile named IC Annual Salary that identifies individual contributors who are salaried with annual salary basis.

Creating a Compensation Item

Use the default values except where indicated.

  1. In the Compensation work area, click Manage Compensation Items to open the Manage Compensation Items page.
  2. Click Create.
  3. On the Create Compensation Item page, complete the fields as shown in this table:

    Field

    Value

    Item Name

    Base Pay Exempts

    Source Type

    Element entry

    Legislative Data Group

    USA

    Payroll Element

    Base Pay Exempts

    Input Value

    Pay Value


  4. Click Save and Close.

Creating a Cash Compensation Category

Create a cash compensation category and attach the base pay item you created along with two existing cash categories with items. Use the default values except where indicated.

  1. Enter category details and add an item.
  2. Add and configure subcategories.
  3. Configure display options.

1. Enter category details and add an item.

  1. In the Compensation work area, click Manage Compensation Categories to open the Manage Compensation Categories page.
  2. Click Create.
  3. On the Create Compensation Categories page, complete the fields, as shown in this table.

    Field

    Value

    Name

    Cash Compensation

    Category Type

    Cash Compensation


  4. Click Continue.
  5. On the Create Category page, Table tab, select Viewers drill into line items to see details in the Level of Detail field.
  6. Click Add Items.
  7. Complete the column fields in the new row, as shown in this table.

    Column

    Value

    Name

    Salary

    Description

    Base pay amounts

    Company Contribution

    Base Pay Exempts


  8. Click Edit Column Properties and select the Your Contribution column.
  9. Select Do not display in the statement.
  10. Click OK.
  11. Click Edit Column Properties and select the Company Contribution column.
  12. Enter Amount in the Column Label field.
  13. Click OK.

2. Add and configure a subcategory.

  1. Click Add Subcategory.
  2. On the Select and Add: Categories page, select Bonuses Exempts.
  3. Click Apply.
  4. Click Done.
  5. Complete the fields, as shown in this table, for the new category row.

    Column

    Value

    Name

    Bonuses

    Description

    Lump sum compensation amounts


  6. Click Save.
  7. Click OK in the confirmation.

3. Configure display options.

  1. Select the Graphs tab.
  2. Complete the fields for two graphs, as shown in this table.

    Field

    Value for Graph 1

    Value for Graph 2

    Graph Title

    Your Cash Awards

    Total Cash Compensation

    Graph Type

    Bar

    Bar - stacked

    Graph Items

    Amount

    Amount


  3. Click Save.
  4. Click OK in the confirmation.
  5. Select the Descriptive Text tab.
  6. Enter any text here to describe what is included in this category or details about the compensation policies, and format it appropriately.
  7. Click Reorder Components at the top of the page.
  8. Select Descriptive Text and click the downward arrow until Descriptive Text appears below Graphs.
  9. Click OK.
  10. Click Save and Close.

Creating a Stock Category

Create a stock category and attach two existing stock categories with items. Use the default values except where indicated.

  1. Enter category details.
  2. Add and configure subcategories.
  3. Configure display options.

1. Enter category details.

  1. On the Manage Compensation Categories page click Create.
  2. On the Create Compensation Categories page, complete the fields, as shown in this table:

    Field

    Value

    Category Name

    Stock Awards

    Category Type

    Other


  3. Click Continue.
  4. On the Create Category page, Table tab, select Viewers drill into line items to see details in the Level of Detail field.

2. Add and configure subcategories.

  1. Click Add Subcategory.
  2. On the Select and Add: Category page, select the row for ESPP Exempts.
  3. Hold down the Control key and select the Stock History Exempts row.
  4. Click Done.

3. Configure display options.

  1. On the Create Category page, Table tab, edit the subcategory names as shown in this table:

    Column

    Stock History Category

    ESPP Category

    Name

    Stock Options

    Employee Stock Purchase Plan


  2. Click Edit Column Properties and select the Company Contributions column.
  3. Change the column label to Stock Award.
  4. Click OK.
  5. Select the Employee Stock Purchase Plan row.
  6. In the Action menu, select Configure Zero Value Behavior of Row.
  7. On the Zero Value Behavior page, complete the fields as shown in this table:

    Field

    Value

    Zero Contributions Display

    Display the row and prevent drilling to subcategory

    Alert Message

    Enter any text to display when workers have no stock to display.


  8. Click OK.
  9. Click Save and Close.

Creating a Statement Definition

Create a statement definition and configure the statement table display, periods, and welcome message. Use the default values except where indicated.

  1. Enter statement details and add top-level categories.
  2. Configure table display options.
  3. Define statement periods and welcome message.

1. Enter statement details and add top-level categories.

  1. In the Compensation work area, click Manage Statement Definitions to access the Manage Statement Definitions page.
  2. Click Create.
  3. In the Create Statement Definition window, enter any name for the statement, such as 2010 Annual Statement.
  4. Click Continue.
  5. On the Create Statement Definition page, enter any description of the statement.
  6. Click Add Category.
  7. On the Select and Add: Categories page, select the two categories that you created: Cash Compensation and Stock.
  8. Click Apply.
  9. Click Done.

2. Configure table display options.

  1. On the Statement Definition Details tab, edit the top-level category names in the Display Name column to make the names more familiar to workers.
  2. In the Description column, add descriptions that display in the statement, as needed.
  3. Select Reorder Top-Level Categories in Statement from the Actions menu.
  4. Select the first category and use the downward arrow to place it after the other category.
  5. Click OK.
  6. Click Save.
  7. Click OK in the confirmation.

3. Define statement periods and welcome message.

  1. Select the Statement Periods tab.
  2. Click Add.
  3. Complete the fields to create two annual periods, as shown in this table:

    Field

    Value

    Start Date

    01-Jan-2010

    End Date

    31-Dec-2010

    Date Available to Workers

    01-Mar-2010

    Currency Conversion Date

    31-Dec-2010

    Number of Periods

    2


  4. Click OK.
  5. In the Display Name column, add a display name for each period, such as 2010 Annual Statement and 2011 Annual Statement.
  6. Click the icon in the Welcome Message column to compose a welcome message that workers see as the first page in the statement.
  7. Type Dear followed by a space.
  8. Click Insert Name.
  9. In the First Name row, click the Insert Segment icon.
  10. Click Done.
  11. Enter a comma after the first name placeholder in the welcome message.
  12. Use the rich text editor to complete the welcome message.
  13. Click Save and Close.

Configuring Optional Eligibility and Statement Summary Page

  1. Select the Statement Options tab.
  2. In the Eligibility Profile field, select IC Annual Salary.
  3. Click Configure Summary Page.
  4. In the Monetary Compensation section, select the Table tab and verify the table contents.
  5. Select the Graphs tab.
  6. Complete the fields, as shown in this table.

    Field

    Value for the First Graph

    Value for the Second Graph

    Graph Title

    Your Total Compensation

    How Your Compensation Adds Up

    Graph Type

    Bar

    Bar - stacked

    Graph Items

    Company Contributions

    Company Contributions


  7. Click Save.
  8. Click OK in the confirmation.
  9. Select the Descriptive Text tab.
  10. Enter any text that you want to display in the summary page specifically related to monetary compensation.
  11. Scroll down to the Summary Page Descriptive Text section and expand it.
  12. Enter some text, such as: The summary provides you an overview of your compensation package. Click each category name to view additional details.
  13. Click Save and Close.
  14. Click OK in the confirmation.
  15. Click Finish to validate the statement.

Generating and Viewing Statements

Update global settings, run the process to generate the statements, check the process reports, and view workers' generated statements. Use the default values except where indicated.

  1. Generate statements.
  2. Monitor the process.
  3. View the statements.

1. Generate statements.

  1. In the Total Compensation Statements work area, click Configure Global Settings to access the Configure Global Settings page.
  2. Complete the fields used for default stock estimates in the statement, as shown in this table.

    Field

    Value

    Default Stock Price

    35

    Currency

    US Dollar


  3. In the Total Compensation Statements work area, click Generate Statements to access the Process Details page.
  4. On the Process Details page, complete the fields, as shown in this table.

    Field

    Value

    Statement Definition Name

    2010 Annual Statement

    Statement Period

    2010 Annual Statement

    Legal Employer

    Infusion USA


  5. Click Submit.
  6. Click OK in the information window.

2. Monitor the process.

  1. In the Total Compensation Statements work area, click Monitor Processes to access the Monitor Total Compensation Processes page.
  2. Find your process in the table.
  3. If the status is Processing, click Refresh.
  4. When the status is Completed, click the icon in the Reports column for your process ID.
  5. Analyze the summary details.

3. View the statements.

Note

You must have the Compensation Manager role to view statements.

  1. Click the Details tab to see the workers for whom statements were generated.
  2. Click the icon in the View Statement column for a worker.
  3. Verify the statement content and formatting.
  4. Click Processing Reports in the task pane to return to the report Details tab.
  5. View and verify additional statements as needed.
  6. Click Sign Out.
  7. Close the Browser.

FAQs for Define Total Compensation Statements

How can I change whether the category displays zero values in the statement?

Select the category or item row, and then select the zero value display option in the Actions menu. The Display Zero Rows column shows the current setting for each category. On the Edit Statement Definition page you can edit only the top-level category. You must edit subcategory and item rows on the Edit Compensation Categories page.

How can I display a hidden column?

Click the Column Properties button and select the column from the menu. Update the option to display the column in the statement.

On the summary page you can edit only summary table column properties. You must edit each individual category's column properties on the Edit Compensation Category page.

How can I hide or show the welcome message in total compensation statements?

First select the statement definition and click Edit. On the Periods tab, select the icon in the Welcome Message column. Edit the Do not display welcome message option.

How can I change welcome message text in total compensation statements?

First select the statement definition and click Edit. On the Periods tab, select the edit icon in the Welcome Message column.

Why can't I delete or edit some items?

If the item is in use in a compensation category, it cannot be deleted and you cannot edit some attributes, such as the type of compensation and nonmonetary unit of measure.

Why did the default stock details change?

More than one administrator might have access to these settings because this stock price and currency information is used to display stock in compensation history as well as when managing workforce compensation or generating total compensation statements.

Can I reuse a previous year's statement?

Yes. You can reuse an existing statement definition by adding new periods. You might also want to update the welcome message, add or edit the items and categories included, and hide or update the display of graphs, descriptive text, and supplementary information.

Can I correct the definition after workers received statements?

Yes. You can correct the statement definition and regenerate the statements, which makes the newer version available to workers.