Benefit cost range

Ranges applies only to YTDRanges calculation types. Each YTDRanges 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 process uses these tables and stored procedures:

• The staging table is DAT_BENEFITCOSTDATA_RANGE_STAGE.
• The stored procedure to validate staged data is depm_integration_wb_benefitcostdata_range_prepare_staging.
• The stored procedure to process staged data is depm_integration_wb_benefitcostdata_range.
• The data is imported to:
  • The DAT_BENEFITCOSTDATA_RANGE_TRANSFORMED table.
  • The WBCCONFIG_BENEFITCOST cube.

The output tables are:

• ATT_WBCCONFIG_BENEFITCOST contains configuration cube data.
• DIM_WBDBC_RANGE_ELEMENTS contains BC_RANGE_nnnn placeholder elements for the WBDBC_RANGE dimension.
• DIM_ WBDBC_RANGE_PARENTS contains parent/child relationships for the WBDBC_RANGE dimension.

Currency and the BenefitCostCode field in the BenefitCost table must exist prior to importing data.

This table describes DAT_BENEFITCOSTDATA_RANGE_STAGE:

Field	Required	Description
Currency	Y	Valid currency ID from BPDCURRENCY.
BenefitCostCode	Y	Valid benefit or cost ID. The related field is BenefitCostCode in the DAT_BENEFITCOST_STAGE table.
Percent	Y	Positive integer indicating a percent.
SUBPLAN_WFB_LOWVALUE	N	Low value. This is required for range data. Must be a numeric number, can have decimals. If empty, then the value is defaulted to negative infinity.
SUBPLAN_WFB_HIGHVALUE	N	High value. This is required for range data. Must be a numeric number, can have decimals. If empty, then the value is defaulted to negative infinity.