SAP Knowledge Base Article - Public

2076822 - Variable Pay Bonus Plans

Symptom

  • This KB article outlines the management of Bonus Plan data
  • What file format is required to import a Bonus Plan?
  • This one file contains the bonus plan data

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HXM Suite
  • SAP SuccessFactors Variable Pay

Resolution

  • Bonus Plans define the weighting of the business, individual and/or team goals used to calculate incentive pay-outs
  • The bonus plan file is created and imported during the initial implementation phase.
  • This file does not need to be imported unless there is a required change to Bonus Plan data.
  • The Bonus Plan file can be directly imported or created within the Variable Pay program:
  1. Navigate to Admin Center > Compensation Home
  2. Select plan > Plan Setup > Manage Plan Details > Bonus Plans > Import Bonus Plans

import bonus plans.png

  1. Within this screen, you are also able to either edit the plans within the UI, export your plans as well as deleting them.
  2. Bonus plans MUST be within your plan prior to running any bonus calculation.

Bonus Plan Import File Format

Assumptions regarding the file format:

  • The import file should be a .CSV file, comma-delimited with string values enclosed in double quotes. The file can be renamed to anything you require. The important thing to remember is this must be a .CSV format
  • The first record is designated as the system header for the field
  • The second record is designated as a descriptor for this field. This descriptor can contain customer specific information which relates to the field
  • No currency symbols in front of values/amounts are needed
  • No commas allowed with values/amounts
  • All percentages should be imported in decimal formats. For example, 10% = .10

The following is a breakdown of fields used:

 

Column

Data Type

Example

Description

A

BONUSPLAN

STRING

“SROE, 50% SHR/50% Retail EBITDA”

Identifies the bonus plan name.  This field must be unique. This field is required.

B

DESCRIPTION

STRING

“This plan measures overall company financials and a retail location’s financials evenly“

A longer text field used to describe the bonus plan.  This field is optional.

C

POOL

STRING

“Retail”

A string used to identify and consolidate bonus plans.  This string is visible on exports/reports and can be used in filters and pivot tables outside of the system.  This field is optional.

D

ASSOCIATE_TYPE             

STRING

“Mid Management”

A string used to identify and consolidate bonus plans.  This string is visible on exports/reports and can be used in filters and pivot tables outside of the system.  This field is optional.

E

ELIGIBILITY_RULE

STRING

KSS

The eligibility rule that applies to this bonus plan. This field is required.

F

ASSIGNMENT_TARGET_PERCENT1

FLOAT OR STRING

targetname_a

This field is optional. If not used, it should be imported as 1. 

G

ASSIGNMENT_TARGET_PERCENT2

FLOAT OR STRING

targetname_b

This field is optional. If not used, it should be imported as 1. 

H

ASSIGNMENT_TARGET_PERCENT3

FLOAT OR STRING

0.8

This field is optional. If not used, it should be imported as 1. 

I

ASSIGNMENT_TARGET_PERCENT4

FLOAT OR STRING

targetname_d

This field is optional. If not used, it should be imported as 1. 

J

BONUS_CAP_PERCENT   

FLOAT

1

Represents the cap. The application multiplies the bonus cap percent by the assignment target amount to determine the bonus cap amount.  This bonus cap amount is compared against the assignment payout amount and the lesser of two values is used for the employee’s bonus.

K

FORCE_SECTION_WEIGHT_TOTAL

STRING

“Y” or “N”

Flag used to determine if the sum of the section weights for business goals, team goals, and individual goals must equal 1 (100%).  This field is optional.  If this field is not included in the file, then the default value = “N”

L

BUSINESS_GOALS_WEIGHT

FLOAT

0.6

Default value of the business goal section weight for the plan “0.6” = 60%.  This field is optional.  If this field is not included in the file, then the default value = 1

M

BUSINESS_GOALS_WEIGHT_ALLOW_EDIT

STRING

“Y” or “N”

Flag used to determine if the user can edit the business goal section weight for an individual user from within the form.  This field is optional.  If this field is not included in the file, then the default value = “N”

N

BUSINESS_GOALS_WEIGHT_MIN

FLOAT

0.25

If the business goal section weight is editable for an individual user from within the form, this field describes the minimum value acceptable for input.  This will be the minimal acceptable value (other than zero) allowed by the form.  “0.25” = 25%.  This field is optional.  If this field is not included in the file, then the default value = 1

O

BUSINESS_GOALS_WEIGHT_MAX

FLOAT

0.75

If the business goal section weight is editable for an individual user from within the form, this field describes the maximum value acceptable for input.  “0.25” = 25%.  This field is optional.  If this field is not included in the file, then the default value = 1

P

BUSINESS_GOALS_WEIGHT_ALLOW_ZERO

STRING

“Y” or “N”

If the business goal section weight is editable for an individual user from within the form, this flag determines if a value of zero is acceptable. If this flag is set to “Y”, then an inputted value of zero will always be acceptable regardless of the minimum.  This field is optional.  If this field is not included in the file, then the default value = N

Q

INDIVIDUAL_GOALS_WEIGHT

FLOAT

0.25

Default value of the individual goal section weight for the plan “0.25” = 25%.  This field is optional.  If this field is not included in the file, then the default value = 0

R

INDIVIDUAL_GOALS_WEIGHT_ALLOW_EDIT

STRING

“Y” or “N”

Flag used to determine if the user can edit the individual goal section weight for an individual user from within the form.  This field is optional.  If this field is not included in the file, then the default value = “N”

S

INDIVIDUAL_GOALS_WEIGHT_MIN

FLOAT

0.1

If the individual goal section weight is editable for an individual user from within the form, this field describes the minimum value acceptable for input.  This will be the minimal acceptable value (other than zero) allowed by the form.  “0.1” = 10%.  This field is optional.  If this field is not included in the file, then the default value = 0

T

INDIVIDUAL_GOALS_WEIGHT_MAX

FLOAT

0.5

If the individual goal section weight is editable for an individual user from within the form, this field describes the maximum value acceptable for input.  “0.5” = 50%.  This field is optional.  If this field is not included in the file, then the default value = 0

U

INDIVIDUAL_GOALS_WEIGHT_ALLOW_ZERO

STRING

“Y” or “N”

If the individual goal section weight is editable for an individual user from within the form, this flag determines if a value of zero is acceptable. If this flag is set to “Y”, then an inputted value of zero will always be acceptable regardless of the minimum.  This field is optional.  If this field is not included in the file, then the default value = Y

V

TEAM_GOALS_WEIGHT

FLOAT

0.15

Default value of the team goal section weight for the plan “0.25” = 25%.  This field is optional.  If this field is not included in the file, then the default value = 0

W

TEAM_GOALS_WEIGHT_ALLOW_EDIT

STRING

“Y” or “N”

Flag used to determine if the user can edit the team goal section weight for an individual user from within the form.  This field is optional.  If this field is not included in the file, then the default value = “N”

X

TEAM_GOALS_WEIGHT_MIN

FLOAT

0.1

If the team goal section weight is editable for an individual user from within the form, this field describes the minimum value acceptable for input.  This will be the minimal acceptable value (other than zero) allowed by the form.  “0.1” = 10%.  This field is optional.  If this field is not included in the file, then the default value = 0

Y

TEAM_GOALS_WEIGHT_MAX

FLOAT

0.5

If the team goal section weight is editable for an individual user from within the form, this field describes the maximum value acceptable for input.  “0.5” = 50%.  This field is optional.  If this field is not included in the file, then the default value = 0

Z

TEAM_GOALS_WEIGHT_ALLOW_ZERO

STRING

“Y” or “N”

If the team goal section weight is editable for an individual user from within the form, this flag determines if a value of zero is acceptable. If this flag is set to “Y”, then an inputted value of zero will always be acceptable regardless of the minimum.  This field is optional.  If this field is not included in the file, then the default value = Y

Keywords

import, export, create format, SF, Success Factors , KBA , sf varpay manage data , sf varpay bonus , LOD-SF-CMP-VAR , Compensation Integration Issues with Variable Pay , How To

Product

SAP SuccessFactors Compensation all versions ; SAP SuccessFactors HCM Suite all versions

Attachments

bonusplan.xls