Pay Bonuses at Different Rates
This example demonstrates how to create criteria to pay employee bonuses at different rates based on age and location. This table summarizes the key decisions for this scenario:
Decisions to Consider |
In this Example |
---|---|
What ages and rates should be used? |
|
What locations should be used to determine bonus rates? |
|
Are there any special conditions that should be added? |
Yes. In City 2 the general manager wants to pay a flat amount of 15,000 for all employees over the age of 25 who make over 100,000 per year. |
In this example, we would perform these actions:
-
Create the bonus rate criteria definition
-
Create age criteria
-
Create location criteria for age group 2
-
Create a calculation value definition for age group 1
-
Create calculation value definitions for locations
-
Modify evaluation conditions
Before You Start
In this example, HRX_US_REP_LOCATION is used as the value set for the entry of different locations. If you don't have an equivalent value set, you may need to create one.
Create the Bonus Rate Criteria Definition
-
On the Home page, click the Values Defined by Criteria quick action under the My Client Groups tab.
-
Click Create.
-
Complete these fields as shown in this table.
Field
Value
Name
Bonus Rate
Effective Start Date
1/1/15
Legislative Data Group
Select your legislative data group.
-
Select Create new value definition group.
-
Enter Bonus in the New Value Definition Group field.
-
Enter Flat Rate in the Default Calculation Type field.
-
Click OK.
Create Age Criteria
-
Select the row with the Bonus Rate criteria definition.
-
Click New.
-
Select Criteria and click OK.
-
For each criteria definition you create, complete these fields.
Field
Age 25 or less
Age greater than 25
Calculation Value Definition Name
Bonus Rate Age Group 1
Bonus Rate Age Group 2
Value Definition Group
Bonus
Bonus
Retrieval Date
Date Earned
Date Earned
Sequence
1
2
Database Item Name
PER_PER_PERSON_AGE
PER_PER_PERSON_AGE
Operand
<=
>
Literal Value
25
25
-
Click OK each time you create a criteria definition.
-
To create a default group for the age criteria, repeat steps 1 through 3.
-
Complete these fields:
Field
Value
Calculation Value Definition Name
Bonus Rate Age Group Default
Value Definition Group
Bonus
Retrieval Date
Date Earned
-
Select the Default Criteria check box and click OK.
Create the Location Criteria for Age Group 2
-
Select the row with the Person Age > 25 criteria definition.
-
Click New.
-
Select Criteria and click OK.
-
For each criteria definition you create, complete these fields.
Field
City 1
City 2
Calculation Value Definition Name
Bonus Range Age Group 2 Location 1
Bonus Range Age Group 2 Location 2
Value Definition Group
Bonus
Bonus
Retrieval Date
Date Earned
Date Earned
Sequence
1
2
Database Item Name
PER_ASG_LOCATION_ID
PER_ASG_LOCATION_ID
Display Name
Location
Location
Operand
=
=
Value Set
HRX_US_REP_LOCATION
HRX_US_REP_LOCATION
Literal Value
City 1
City 2
-
Click OK each time you create a criteria definition.
-
To create a default group for the location criteria, repeat steps 1 through 3.
-
Complete these fields:
Field
Value
Calculation Value Definition Name
Bonus Rate Age Group 2 Location Default Rate
Value Definition Group
Bonus
Retrieval Date
Date Earned
-
Select the Default Criteria check box and click OK.