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 staging table is WFB_BenefitCostRange.
This table describes the Benefit Cost Range business object:
| Field | Type | Mandatory | 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. |