Summarizing Form Setup and Management

Objective

After completing this lesson, you will be able to set up fields and columns using the Label Names and Visibility editor and Column Designer.

Variable Pay Form Fields

Let’s look at the various fields of the Variable Pay form.

A software interface displaying employee variable pay details, with sections for business and individual targets, goal names, weights, payout calculations, collapsible columns, and floating budget panels.

Form Columns: Sections

Form Sections (Levels)

  • Entry-Level

    • Support standard and custom columns

      In the case of custom columns, validations for Entry Level fields in a variable pay templates apply as in SAP SuccessFactors Compensation.
    • Entry level field option includes functionality to determine level of validation: No validation, Warning or Error.
    • Groupings and column order are configured in Column Designer

  • Assignment Details Level

    • Order of fields is configured in the background element

    • Data is pulled from the employee history data file

  • Calculation Level

    • Fields are configured under Label Names and Visibility

    • The order of fields is not customizable

Note

Most of the levels and columns are collapsible to save screen space.

Form Columns: Editors

There are two tools to arrange or design the worksheet:

  1. Label Names and Visibility

    • List all the standard fields for Variable Pay, select the visibility and labels as required by customers

    • Standard fields are grouped into different levels – use checkboxes to display/hide levels

  2. Column Designer is used for:

    • Sorting and grouping standard fields

    • Adding Assignment Level custom fields

    • Customizing budget row labels

    • Configuring Custom Views

A Plan Setup interface showing options for configuring label names and visibility. Sections include Assignment, Business Goals, Business Goal Performance, Team Performance, Individual Performance, Total, and Custom Fields.

Form Columns: Assignment

  • Displays on Employee History

  • Columns:

    • Assignment Basis – Basis amount

    • Target Percent 1–4 – Bonus plan target percentages

    • Proration – Calculated percent based on Start/End and Program Dates

    • Target Amount – Prorated basis amount

    • Multiplier – Applied multiplier

Assignment table with columns for SuccessFactor Name, Customer Name, and selection checkboxes. Rows include fields like assignment basis and target amount. User's details visible on the left sidebar.

Form Columns: Business Goals

  • Displays in Business Calculation

  • Columns:

    • Business Goal Header – Title of the Business Calculation Section

    • Business Section Amount – Section Weight x Target Amount

    • Goal Name

    • Goal Weight

    • Goal Basis – Business Section Amount x Goal Weight

      A table displaying business goals with sections for goal weight, basis, minimum, maximum, target, achievement, payout percentage, and amount. Another panel shows options to configure label names and visibility.
    • Goal Results – Actual result value for the Business Goal

    • Goal Results Payout Percent – Calculated Achievement Percent

    • Goal Results Payout Amount – Goal Basis x Goal Payout Percent

    • Business Section Multiplier

    • Business Section Multiplied Amount – Goal Results Payout Amount x Business Section Multiplier

    • Business Section Prorated Amount – Business Section Multiplied Amount x Proration

Goal Result, Payout Percent, Payout Amount are repeated for both Forecast and Forecast2 (modeling).

Form Columns: Business Goals Performance

  • Displays in Business Calculation

  • Financial metrics from the business goals data file

  • Columns:

    • Performance Minimum

    • Performance Low

    • Performance Target

    • Performance High

    • Performance Maximum

Two tables showing performance goals. The first table configures label names for performance metrics; checked items are highlighted. The second table lists goals for corporate revenue and profit with weightage and targets.

Form Columns: Individual Performance

  • Displays in Individual Calculation

  • Columns:

    • Individual Goal Header – Individual Calculation Section title

    • Individual Section Amount

    • Goals – Goal Name

    • Form Name

    • Weight – Goal weight

    • Rating – Performance rating or achievement percent

    • Prorated Objective Amount – Goal Weight x Individual Section Prorated Amount

    • Individual Guidelines

    • Individual Percent

    • Individual Amount – Individual Calculation Amount x Individual Percent

    • Individual Section Multiplier

    • Individual Section Multiplied Amount – Individual Results Payout Amount x Individual Section Multiplier

    • Individual Section Prorated Amount – Individual Section Multiplied Amount x Proration

    • Individual Section Weighted Percentage – Section Weight

A table displaying configurations for label names and visibility for individual performance. Below is another table highlighting performance evaluation for Marcus Hoff, showing goal section weight, amount, weight, and rating.

Form Columns: Totals

  • Display in Entry-Level

  • Can also be configured in Column Designer

  • Columns:

    • Local Currency Code

    • Total Target Amount

    • Total Target – Business Target Amount

    • Business Calc Amount – Business Goals Payout Amount

    • Business Percent – Business Goals Payout Percent

    • Individual Calc Amount – Individual Target Amount

    • Business Calc Amount and Percent repeat for both Forecast and Forecast2 (modeling)

    • Individual Rating – Individual Performance Rating or Achievement Percent

    • Individual Guideline

    • Individual Percent – Individual Payout Percent

    • Amt – Individual Payout Amount

    • Total – Sum of Forecast2 Payout Amount

    • Percent of Target – Percent of the Target Payout

    • Percent of Salary – Imported from user data file

    • Final Payout

    • Override – Field for managers to enter an override value

Configuration table with columns for SuccessFactor Name, Customer Name, and visibility checkboxes. Below, a table compares Marcus Hoff and Richard Maxx on various performance metrics and payouts.

Variable Pay Form Columns

Column Designer, the tool that is used to configure form fields, is also used to configure form columns.

Column Designer

  • Provides the ability to add and configure field grouping

  • Can change name or column order for Entry-Level columns

  • Ability to specify column alignment and rounding format

  • Custom fields sourced from the user data file also use an Import Key

Note

Label names and visibility of standard fields should first be configured before any fields are grouped in Column Designer.

Using Column Designer

Column Designer interface displaying selected column attributes with options for visibility, formula, validation, and import keys. Business Unit is the selected field with configurations visible.
  • Column Name: Customer-defined
  • Read Only: must be set to yes for Calculated and Reloadable Fields
  • Visibilities: Do not use. Set visibilities in the Label names and Visibility tool
  • Column Alignment: Sets the horizontal alignment
  • Column Type -
    • String: Any alphanumeric character set
    • Money: Numeric value for currency fields
    • Date: Calendar date
    • Percent: Percentage value
    • Amount: Numeric value - non-currency
    • Username: For Employee Central customers - can display Second Manager information
  • Enable Help Text
    • Add a help text icon for the field to assist planners in better understanding the technical aspects of a field or its purpose.
    • Help text may be added in multiple languages that are visible during Executive Review or on the worksheet. 
    • Limitations allow for 50 help text enabled fields on a given template. Up to 256 characters per help text are allowed.
  • Formula: Mathematical formula for a calculated field
  • Validation: Validation rules for an input field
  • Column Width: Define a new width if the default is not desired
  • Other Options
    • Hide Column: For fields used in a calculation that should not display on the form
    • Reloadable: When selected, data in this column is updated whenever data is modified in the user data file. By design, reloadable only works with read-only fields. To improve system performance, there is a setting to update reloadable fields only when Update All Worksheets is run, instead of whenever the form is opened. The setting can be enabled in Plan SettingsAdvanced Settings.
    • Reportable: Field is available in ad hoc reports
    • Translatable: Displays translated values of custom fields mapped in Employee Central
    • Note: This cannot be selected after forms are live.

Column ID: Unique field identifier, used when referencing fields in the formula

Import Source: Defines where to pull the data, either user data file or employee history data file

Import Key: Field mapping can be a user data file column header or data-field-Id for employee history data

Aggregate Field: Amount pulled from lower level

Grouping Columns

Grouping the columns makes the worksheet more cohesive and easier to look at and analyze.

Column Group Settings:

  • Column Name: Label visible in the worksheet.

  • Grouping ID: Unique identifier is visible in the XML. Use letters, no special characters.

  • Initial State: Column behavior when opening the form for the first time. Can be set to expanded or collapsed.

  • Displayed Column When Collapsed: One column can be set to be visible even when the group is collapsed.

  • Group Color: Background color for the columns.

Interface for configuring form fields in a worksheet. Options include adding columns, grouping fields, and customizing views. The selected group is named Business Section, with settings for initial state and background color.

Custom Views

Custom views provide planners direct access to view portlets from People Profile (PP3) in the compensation worksheet. The ability to view employee details such as compensation history, rating history, or bonus history facilitates better decision-making for planners.

Compensation Profile is another option of configuring the display of historical information, however, Compensation Profile can only use existing compensation templates as historical source. When off-cycle changes are made through Manager Self-Service (MSS), the changes are not recorded in compensation plans, which make the historical periods in Compensation Profile incomplete.

Administrators can configure which portlets are viewable in the form using Design Worksheet. Viewing permissions respect the role-based permission set for the planner.

Screenshot of a Column Designer interface with options for configuring custom views. A custom view titled Bonus History is displayed with details including section, block ID, and language settings.
Employee information table with five names, user IDs, and business tab icons. A dropdown menu next to Brenda Davis shows options: Open Profile, View Details, Bonus History, Download Bonus Details.

Supported Portlets

For Non-Employee Central: Portlets which are supported for Performance Management are also supported by Compensation/Variable Pay.

For Employee Central: The following list of EC_Portlets is supported both for Compensation and Variable Pay:

  • EMPLOYMENT_INFO_BLOCK

  • ASSIGNMENT_INFO_BLOCK

  • JOB_INFO_BLOCK

  • ORGANIZATION_INFO_BLOCK

  • BENEFIT_CURRENT_BENEFITS_PP3

  • ADDRESS_INFO_BLOCK

  • DEPENDENT_INFO_BLOCK

  • COMP_INFO_BLOCK

  • TOTAL_COMP_HISTORY_BLOCK

  • NON_RECURRING_BLOCK

  • ONETIME_DEDUCTION_BLOCK

Spot Bonus table showing four entries with issue dates, types as Spot Bonus (SPOT), currency as USD, and varying amounts/percentages for Brenda Davis, Marcus Hoff, Richard Maxx, and Sid Morton.

Plan Level Executive Review Filters

An extra three custom string fields with import key can be used as executive review filters.

Screenshot showing a user interface for defining plan level executive review filters in a software application with options to add custom fields, use column designer, and a save button.

Plan-Level Executive Review Filters: Enablement

Plan-level executive review filters can be enabled within Advanced Settings.

Screenshot of a software interface showing Plan Setup in Settings. The Advanced Settings section includes various options with checkboxes. One option, Enable plan-level executive review custom filters, is highlighted.

Configure Label Names and Visibility

Business Example

You must prepare to launch variable pay forms by setting up field visibility and loading goal results.

Steps

  1. Set up field visibility.

    1. Navigate to Plan SetupDesign WorksheetConfigure Label Names and Visibility.

    2. Set field visibility as follows:

  2. Add Employee ID and Country in Entry-Level.

    1. Navigate to Plan SetupDesign WorksheetColumn Designer.

    2. Add USER ID as a custom column by using EMPID as Import Key.

    3. Add Country as a custom column by using customCountry as Import Key. Remember, the Country column in the user data file cannot be referenced directly on forms. You have to copy the information to the new customCountry in the user data file.

  3. Segregate fields into groups.

    1. Add a column group.

    2. Enter Business Section as the column name. Use biz as Grouping ID. Select your preferred background color.

    3. Drag Business Target, Business Payout% and Business Payout Amount into the group.

    4. Add another column group.

    5. Enter Individual Section as the column name. Use ind as Grouping ID. Select your preferred background color.

    6. Drag Ind Target Amt, Ind Guideline, Indv Perf Rating, Indv Achievement %, Ind Payout Amt into the group.

    7. Add another column group.

    8. Enter Total as the column name. Use final as Grouping ID. Select your preferred background color.

    9. Drag Final Payout, % of Total Target, Emp ID and Country into the group.

  4. Load business preliminary goal results.

    1. Open the ProTech_Performance metrics.xls file in the Master Configuration File folder.

    2. Navigate to Plan SetupManage Plan DetailsBusiness Goals. Open each business goal to enter the preliminary results from the performance metrics file.

    3. Recalculate bonus by navigating to Calculate BonusBonus payout.

  5. Launch and test worksheets.

    1. Navigate to Manage WorksheetsCreate Worksheets. Create worksheets for Carla Grant.

    2. Open Carla's form and check the bonus details and calculation. Verify calculation and plan assignment of each employee on cgrant's form.

    3. Verify if Force Comments is working.

Assignment Level Custom Fields

Assignment Level Custom Fields (ALCF) give greater flexibility in setting up complex calculations at any level of the Variable Pay form. ALCF refers to any custom fields that are added outside of the Entry-Level.

Use Cases

One use case for ALCF is when the customer requires different guidelines that differ based on assignment information. Without ALCF, this requires creating multiple Variable Pay plans, as Variable Pay allows only for one set of guidelines to be set on data at the Entry-Level.

When using ALCF, it is important to know the levels on which you can create custom fields. Lower levels can reference data at higher levels and higher levels can aggregate data from lower levels.

Employee compensation data with sections for ALCF Levels, Assignment, Business Section, Business Goal, Entry level, and Individual section. Highlighted payout details include USD 10,548 and USD 12,573 totals.

In the preceding figure, Example – Assignment Level Custom Fields, there are four ALCFs in the business goal level: Overall Rating, Business Unit, Modifier, and Goal Level Payout.

The sum of the Goal Level Payout is aggregated to business section, which is then aggregated to the assignment level before finally being aggregated to the Entry-Level.

Assignment Level Custom Fields can be used in the following:

LevelABR (Assignment Based Rating)NON-ABR (Non-Assignment Based Rating)
EntryYY
AssignmentYY
BizSectYY
BizGoalYY
TeamSectYY**
TeamDetOnly for byGoalN
IndSectYY**
IndDetOnly for byGoalN

**For TeamSect & IndSect for NonABR, if configured, they are still calculated based on each assignment, same behavior as ABR.

A sample configuration of Assignment Level Custom Field is discussed in the unit Advanced Topics.

Summary

  • Form Columns and Sections: The Variable Pay form contains multiple sections such as Entry-Level, Assignment Details, and Calculation Level. These sections support standard and custom columns. Custom validations can be set up in Entry-Level fields, with the arrangement managed through the Column Designer.

  • Tools for Design and Configuration: Tools like Label Names and Visibility and Column Designer facilitate form customization. These tools allow sorting, grouping, and configuring the visibility of standard fields, assignment-level custom fields, and budget labels, tailoring the presentation for specific organizational needs.

  • Column Designer Features: The Column Designer tool allows for adding and configuring field groupings, changing names and column orders, specifying alignment and formats, and integrating custom fields using an Import Key. It's essential to configure label names and visibility first before grouping fields.

  • Flexibility with Assignment Level Custom Fields (ALCF): ALCF enhances flexibility by allowing complex calculations at various levels of the Variable Pay form. These fields are custom additions outside the Entry-Level, enabling more detailed data management and calculations.