Benefit cost range

Ranges applies only to YTD Ranges calculation types. Each YTD Ranges benefit and cost definition must have at least one range set. A range consists of a low value, a high value, and a percent. A range set is a collection of ranges. In a range set, the high value of one range must be less than the low value of the next range.

This table shows an example of one range set for one benefit:

Currency BenefitCostCode Percent Low value High value
USD YTD Range 1 0 20000
USD YTD Range 2 20000 40000
USD YTD Range 4 40000 130000
USD YTD Range 5 130000 160000

Range sets are stored by currency according to these rules:

  • If the benefit and cost is global and has a scope of a single entity, then there must be just one range set. It should be in the currency of that entity.
  • The benefit and cost can have multiple range sets in different currencies. There should be only one range set per currency.

The table is WFB_BenefitCostRange.

This table describes the Benefit Cost Range business object:

Field Type Required Description
Currency [nvarchar] (3)

NOT NULL

Y Valid currency ID in the Currency business object.
BenefitCostCode [nvarchar] (200)

NOT NULL

Y Unique ID for the benefit or cost in the Salary, Benefit, Cost Definition business objects.

The related table is BenefitCost, the field is BenefitCostCode.

Percent [float] (53)

NULL

Y Positive value indicating a percent.
LowValue [float] (53)

NULL

Y YTD low value.
HighValue [float] (53)

NULL

Y YTD high value of one range must be greater than the low value.