Examples of Derived Factors
The scenarios described here illustrate how to define different types of derived factors.
Age
Benefits administrators frequently use age factors to determine:
-
Dependent eligibility
-
Life insurance rates
Age factors typically define a range of ages, referred to as age bands, and rules for evaluating the person's age. The following table illustrates a set of age bands that could be used to determine eligibility for life insurance rates that vary based on age.
Derived Factor Name |
Greater Than or Equal To Age Value |
Less Than Age Value |
---|---|---|
Age Under 25 |
1 |
25 |
Age 25 to 34 |
25 |
35 |
Age 35 to 44 |
35 |
45 |
Age 45 to 54 |
45 |
55 |
Age 55 to 64 |
55 |
65 |
Age 64 or Older |
65 |
75 |
The determination rule and other settings for each age band can use the same values, as shown in the following table:
Field |
Value |
---|---|
Determination Rule |
First of calendar year |
Age to Use |
Person's |
Units |
Year |
Rounding |
None |
Length of Service
You use the length of service derived factor to determine eligibility based on an employee's length of service. For example, you can create a derived factor to determine if an employee has completed 10 years of service. You can specify the start date of the length of service period using any rule in the Period Start Date Rule list:
-
Adjusted service date
-
Date of hire
-
Original hire date
-
Seniority date
If you select Seniority Date, you use the Seniority Date list to select the specific configuration rule, such as the grade seniority date, to determine the date. If you have other special requirements to calculate the length of service, you can use a formula. You indicate the end of the length of service period by using a determination rule, such as end of month, first of month, as of event date, or end of pay period. The following table shows an example of a set of length-of-service bands.
A derived factor for length of service defines a range of values and rules for calculating an employee's length of service. The following table shows an example of a set of length-of-service bands. You can use the length-of-service bands to determine eligibility for compensation objects such as bonuses or severance pay.
Derived Factor Name |
Greater Than or Equal To Length of Service Value |
Less Than Length of Service Value |
---|---|---|
Service Less Than 1 |
0 |
1 |
Service 1 to 4 |
1 |
5 |
Service 5 to 9 |
5 |
10 |
Service 10 to 14 |
10 |
15 |
Service 15 to 19 |
15 |
20 |
Service 20 to 24 |
20 |
25 |
Service 25 to 29 |
25 |
30 |
Service 30 Plus |
30 |
999 |
The determination rule and other settings for each length-of-service band are the same:
Field |
Value |
---|---|
Period Start Date Rule |
Date of hire This sets the beginning of the period being measured. |
Determination Rule |
End of year This sets the end of the period being measured. |
Age to Use |
Person's |
Units |
Year |
Rounding |
None |
Compensation
A derived factor for compensation defines a range of values and rules for calculating an employee's compensation amount. The following table shows an example of a set of compensation bands. You can use the compensation bands to determine eligibility for compensation objects such as bonuses or stock options.
Derived Factor Name |
Greater Than or Equal To Compensation Value |
Less Than Compensation Value |
---|---|---|
Less than 20000 |
0 |
20,000 |
Salary 20 to 34000 |
20,000 |
35,000 |
Salary 35 to 49000 |
35,000 |
50,000 |
Salary 50 to 75000 |
50,000 |
75,000 |
Salary 75 to 99000 |
75,000 |
100,000 |
Salary 100 to 200000 |
100,000 |
200,000 |
Salary 200000 Plus |
200,000 |
999,999,999 |
The determination rule and other settings for each compensation band are the same:
Field |
Value |
---|---|
Determination Rule |
First of year |
Unit of Measure |
US Dollar |
Source |
Stated compensation |
Rounding |
Rounds to nearest hundred |