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