Benefit cost caps

Benefit cost caps apply to these benefit and cost calculation types:

• QuantityXRate
• PercentOfPeriodic
• PercentOfAnnualized
• YTDRanges

The process uses these tables and stored procedures:

• The staging table is DAT_BENEFITCOSTDATA_CAPS_STAGE.
• The stored procedure to validate staged data is depm_integration_wb_benefitcostdata_caps_prepare_staging.
• The stored procedure to process staged data is depm_integration_wb_benefitcostdata_caps.
• The data is imported to:
  • The DAT_BENEFITCOSTDATA_CAPS_TRANSFORMED table.
  • The WBCCONFIG_BENEFITCOST and ATT_WBCCONFIG_BENEFITCOST cubes.

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
BenefitCostCode	Y	Valid benefit or cost BenefitCostCode. The related field is BenefitCostCode in the DAT_BENEFITCOST_STAGE table.
Currency	Y	Valid currency ID from BPDCURRENCY.
Cap	N	The maximum amount that can be applied over the course of a year. This is optional. If specified, must be greater than 0. Benefit cost caps are stored by currency. If the benefit and cost is global and has a scope of a single entity, then there must be just one benefit cost cap and it must be in the currency of that entity. The benefit and cost can have multiple benefit cost caps in different currencies.