Maintaining Worksheets, Forms, Reward and Personal Statements.

• Located under Settings→Set Number Format Rules

• Default rules populate in the Number Formatting Rules List

  • Admin can modify existing rules

  • Admin can create new rules

• Use for money, percent, amount, or rating

• Round or Truncate Modes

• Rounding Multiple to the nearest 1, 10, 100, 1,000, or 10,000

  • # only displays significant digits, so it does not display leading or trailing zeros

  • 0 always displays the digit

  • Examples

    • 15234.2 (#,###.00) = 15,234.200

    • 434.52 (0,000.#) = 0434.5

    • 15 (#.0#) = 15.0

Navigate to Settings→Set Number Format Rules.

• Enter a unique Rule Name.
• Enter a Format.
• Select Use For.
• Select a Mode.
• If Mode is round, then select the nearest Multiple to round (if necessary).
• Select Add Rule.

Navigate to Settings→Set Number Format Rules

• Select the Rule Name of an existing rounding rule.
• Enter a Format.
• Select Use For.
• Select a Mode.
• If Mode is round, then select the nearest Multiple to round (if necessary).
• Select Edit Rule.

• To round to the nearest tenth for percent fields, you’ll need three places after the decimal. The system treats the percent as a decimal number, moves the decimal two places to the right, and then rounds to the last digit in the format (###.000 or ###.###).

• Example: you want 37.53% to round to 37.5% (nearest 10th).

  • You might think to use ###.# as your rounding format, but actually you must use ###.###. The system rounds to the five because the five is the last digit in the format (0.3753).

  • 0.3753 is changed to 37.53 first, and then rounded. The result is 37.5.

  • You can do this for your defPercentFormat if you need all or most percent fields to round to the tenth. Then, you could set up a customPercentFormat for those fields that do not need the rounding.

Each standard field is set to display the default number format for that type of field.

If you need a certain field to use a different format than the default (in the example in the preceding figure, Apply Rounding Rules, Goal Weight must be rounded to the 100th), you assign a different format here.

Navigate to Design Worksheets→Set Number Formats.

• Find the desired field to apply a number format.
• Choose the desired Number Format from the dropdown.
• Choose Save.

The Check Tool helps eliminate common errors and catch configuration and data-related issues. It is recommended to run checks before launching forms, as the information returned by the Check Tool can provide valuable input to an administrator, and can be used to identify potential issues before a bonus period begins with forms launched.

The Check Tool requires role-based permissions and the Metadata Framework. Grant the following administrative permissions to use the feature:

• Access Check Tool authorizes users to access the tool.

• Allow Configuration Export authorizes users to export system configuration data from within the Check Tool.

The Check Tool can be launched directly from the Manage Worksheet page or by using Action Search. Checks available for Compensation and Variable Pay include but are not limited to checking:

• Cyclic Dependency
• Inactive Planners
• Formula Configuration issues
• Statement Setup

Check results can be any of the following:

• No issues found.
• Warning: Inconsistency is found. System proposes a solution.
• Error: Inconsistency is found, admin must take action, which might include creating a ticket.

The process of launching a Variable Pay form is the same process followed when launching Compensation forms. Navigate to Manage Worksheets.

1. Select Create Worksheets.
2. Enter a unique worksheet name.
3. Select Start Date, End Date, and Due Date.
4. Select the top level manager/planner (you must use the Find Employee button OR type the planner's username, for example, "aathompson" instead of typing "Alan Thompson".

• Create worksheet for Head of Planning only - launches a form only to the planner selected in Head of Planning; used mostly in testing scenarios in order to reduce form creation time.
• Send Email Notifications to planner(s) - if selected, planners are notified that forms are ready for review (assuming the Document Creation notification is turned on in the Admin Center).

Some organizations may need to launch forms to employees within a hierarchy at different points in the year.

For example:

• UK merit planning takes place in March; Netherlands merit planning takes place in April.

• Planners with teams in both countries receive one worksheet that lists the UK employees, and then another worksheet that lists Netherlands employees.

To enable worksheet creation by employee group, enable the setting in Advanced Settings→Create worksheets by employee group. This setting is grayed out when the template already have in-progress forms. Groups can be created under the Manage Employee Groups tool.

When changes are made to employee data, these changes might need to be reflected on Variable Pay forms too. The following options are available to push employee data changes to the worksheet:

• Add New Employee to Variable Pay worksheet (employee hired and added as a user after the admin created the worksheets).
• Move employee’s variable pay data from previous manager to current manager (this setting will only work if the new manager already has an existing variable pay worksheet).
• Create Worksheet for new manager(s). A manager is considered a new manager if:
  • This manager is in the user hierarchy of specified head of compensation planning and/or is manager of employees in specified dynamic group.
  • This manager does not have a worksheet created yet.

  A manager has a worksheet created if the manager has at least one eligible employee. If all their employees are ineligible, no worksheet is created.

  If Move employee’s compensation data from old manager to current manager is not checked, then only employees under the new manager not in any existing worksheet is included in the new worksheet.
• Remove Inactive Employees from Variable Pay Worksheets
• Remove Inactive Planner’s WorksheetsUse caution when selecting this – this deletes the planner’s entire worksheet, even if there are still employees on the worksheet. Make sure you first move the employees to a new worksheet before deleting an inactive planner worksheet.
• Update Budget
• Synchronize Bonus Data with Performance Management form

Updates can also be applied to specific worksheets.

The update process can be automated by setting up a scheduled update job in Provisioning→Manage Scheduled Jobs.

If needed, the job may be run later or on a schedule, use the option to Update Compensation Forms for Template job in Job Scheduler.

The same update options exist for the automated job as the manual process. Changes are automatically applied to all ongoing and completed Variable Pay forms (if the completed option is selected).

Employees can be moved, deleted, and added to worksheets manually.

To move an employee (for example):

• Select the Source Worksheet.

  • All available employees on the worksheet are listed.

  • Select the employee(s) to move.

• Select the Target Worksheet.
• Select whether to update budget and which notifications to send.
• Select Move.

By default, any manual movements are overwritten when a mass update job is run. For example:

• Employee A is manually moved from Manager 1’s worksheet to Manager 2’s worksheet.

• Then Employee A is assigned to a new manager – Manager 3 – and forms are updated with the Move employee’s variable pay data form previous manager to current manager option.

• Employee A is not moved to Manager 3’s worksheet.

This overwrite behavior can be skipped with the Advanced Settings option Do not override manually updated employees. If this option is checked before the processes take place, Employee A remains on Manager 2’s worksheet when forms are updated in the preceding sample. An e-mail notification is sent to alert the admin that Employee A was not moved.

There can be times when you want to delete Variable Pay worksheets. There are two methods for deleting worksheets:

1. Using Manage Worksheets.

2. Using Delete Document.

This option is appropriate for a few worksheets (under 100).

This option is appropriate for deleting many worksheets (over 100).

An optional setting in Actions for All Plans→Company Settings can be used to automatically purge deleted worksheets. As deleted forms reside in the same database tables as that of live forms, enabling the setting can help improve Executive Review loading performance. To set the process, enter how old deleted worksheets must be before being purged. The system can auto purge 1 to 365-day old deleted forms.

There are two other purging tools available for Compensation and Variable Pay: Data Retention Management (DRM) and Data Retention Time Management (DRTM). The latter allows for different data retention times for different countries. To know more about purging settings for Compensation and Variable Pay, visit the SAP Help Portal for DRM and DRTM guides.

The process includes:

1. Adding a Variable Pay statement template from SuccessStore (or import in case of custom templates).
2. When you go to import an XSL file in the statement editor template from the Add Template from an Import File XSL screen, the template is now validated. You're unable to proceed with the import in case the file isn't a valid XSL template.
3. 
4. Associating a reward template with the Variable Pay plan.
5. Generating statements.
6. Use the Download Sample Template option to view the final appearance of the PDF statements before you generate them for your employees.
7. 

Statement permissions can be set at the plan level.

1. Default Permissions follow the user permission and the target population defined in the role-based permission.
2. Change Permission who can view generated statements supersede the permission in RBP.
3. Generated Statements are not viewable hide the statements from all users.

When statement templates are added to the system, administrators can manage how statement templates are used at the plan level. Navigate to Complete Compensation Cycle→Rewards Statements.

• To associate the plan with a statement template, use Select Template. The list displays all previously added reward templates that match the plan (for example, only variable pay statement templates will appear on the list if the plan is variable pay).
• When using multiple plan sources, use the Combined Statement template.
• Multiple statement templates can be associated if different versions are required for employee statement groups.
• When using multiple statement templates, assign a default template. The system will use the default template for any employees included in a complete form but not associated to a statement group. Default template should be the last on the list.
• Assign template permissions – this can be modified even after statements are generated.
• Statements can be generated by employee name, username, or by reward template. The same options are available when recalling statements.
• Bulk printing from Executive Review can be enabled at the plan settings. The Download statement button appears only if a generated statement is available for any of the filtered employees in Executive Review.
• When using the Combined Statement template with Compensation and Variable Pay as data sources, use Compensation as the primary plan. This will allow planners to download/bulk print statements on compensation worksheets.

The system can prevent statement generation for select employees, such as if there is no change in an employee’s base salary, no bonus, and so on. In order to prevent generating statements, a dedicated custom string column should be added to each template.

Data on a custom string column can be imported or formula driven. Column result should be Boolean "TRUE" or "FALSE". Examples of formulas which can be used:

• Example for no bonus payout: if(finalPayout=0,"FALSE","TRUE")

• Example for low rating that would render ineligible for planning: if(totalIndividualRating<50,"FALSE", "TRUE")

• Example with a custom logic to look to exclude certain statuses: if(customStatus="Leave of Absence" , "FALSE", "TRUE")

1. Create a custom string column in the Design Worksheet dedicated for statement suppression.

   

2. Enable the setting from Plan Setup→Settings.

   Note

   The dropdown to designate field suppression shows all string data custom fields, but only those custom columns with the value "TRUE" have forms generated, a value of "FALSE" will be suppressed.
   

3. Generate statements as you normally would.

4. The Job Status report lists the names whose statements have been suppressed.

1
<comp-statement-suppression fieldId="customfield4"/>

An additional option for making the reward statements available is to place them directly on the employee’s profile page. With this option, employees can access their reward information at any time after the statements are generated.

Variable Pay statements can be made available directly on People Profile. With this option, employees can access their reward statements anytime after it is published. Make sure that proper permissions are set for users. The statement links are defined in User Permissions→Employee Data, while statement blocks are defined in User Permissions→Employee Views. To configure statements on People Profile:

1. Go to Manage People Profile.
2. Set Variable Pay Statement section and block to be visible.
3. Save.

Once the Compensation statement is generated and published by the administrator, the employee can view it at any time.

Administrators can send a system-generated e-mail to notify employees of their reward statement by completing the following steps:

1. Enable the setting, View generated Variable Pay and Combined Statements based on Role-Based Permission, from Actions for All Plans→Company Settings.
2. Enable permission from the role-based permission, Manage Permission Role→Administrator Permissions→Manage Compensation and Variable Pay→Manage Email Notifications for Statement Generation.

A new e-mail template, Personal Compensation Statement Generation notification is available from E-Mail Notification Templates. To send the e-mail notification, navigate to Complete Compensation Cycle→Reward Statements→Send Email Notification. The same choices are available for sending notifications as that of generating statements, by template, by employee name, and by username.

Administrators can generate reconciliation reports into a downloadable CSV file and identify 1) employees who have reward statements generated and 2) employees who do not have them.

Navigate to Complete Compensation Cycle→Reward Statements→Manage Statement Templates. Select the Reward Statement Generation Report icon on the far right.

A job is initiated and can be accessed via Report Center→View Scheduled Jobs→My Jobs. In the Statement Generated column of the downloaded CSV, the name of the statement template is displayed for the employees for whom a statement was generated. If a statement was not generated, a blank cell is displayed.

Personal statements can be generated using an autocomplete search for user:

• User Search: Only one user can be generated at a time

• Statement Type: Can pull Compensation, Variable Pay, or Combined Statements

• Date Range: The system fetches all statements within the date range specified

• Print All: The administrator or data protection officer can print all fetched statements

1. The following permission code block must be added to the data model for the appropriate roles. In this example, the Employee, Managers up the chain, and HR Rep can view the Variable Pay Individual Review.

   
   Note

   Be sure to properly select the Target Population for each permission role.

2. Enable the Variable Pay Individual View in RBP→Employee Views.

3. Add the Variable Pay Individual View as a section or subsection in People Profile.

4. Search for the Variable Pay Individual view block and add it to the subsection.

5. Navigate to the appropriate Variable Pay program to enable Live Profile visibility for the plan.

Employees can easily access their bonus payout distribution from the home page or People Profile. To set up the home page bonus distribution notification, the latest home page must be enabled.

The home page bonus revision notifications require the New Experience for the home page found in the Upgrade Center. To trigger these types of notifications, you must have the Send Personal Statement and Bonus Plan Notifications RBP found under Manage Compensation and Varpay within RBP. This now opens up the capability to trigger the notifications by clicking on a template within Compensation Home and navigating to: Complete Compensation Cycle→Manage Notifications.

Manage Notifications allows the administrator to send a personal statement or the individual bonus view the notification.

A more user-friendly individual bonus payout view is available for employees; however, this does require a setting to be enabled: Enhanced Individual Variable Pay View is found in Company Settings.

Navigate to Compensation Home→Actions for All Plans→Company Settings.

Once enabled, the overall experience of reviewing bonus payout information is easier.

Enhanced Bonus Payout View for employees requires a Company Settings switch enabled in Compensation Home.