Benefit cost based on

Benefit and cost actions based on other benefit and cost definitions apply to these benefit and cost calculation types:

• Non-global benefits
• PremiumAmountPremiumRate
• PremiumPercentPremiumRate
• Non-global and global benefits
• PercentOfPeriodic
• PercentOfAnnualized
• YTDRanges

The process uses these tables and stored procedures:

• The staging table is DAT_BENEFITCOST_BASEDON_STAGE.
• The stored procedure to validate staged data is depm_integration_ wb_benefitcost_basedon_prepare_staging.
• The stored procedure to process staged data is depm_integration_wb_benefitcost_basedon.
• The data is imported to:
  • The DAT_BENEFITCOST__BASEDON_TRANSFORMED table.
  • The WBCCONFIG_BENEFITCOST_ASSIGNMENT cube.

The output tables are:

• ATT_WBCCONFIG_BENEFITCOST contains configuration cube data.
• DIM_WBD_BENEFITCOST_ELEMENTS contains the elements for the WBD_BENEFITCOST dimension.
• DIM_WBD_BENEFITCOST_PARENTS contains the parent/child relationships for the WBD_BENEFITCOST dimension.
• The benefit cost elements are also included in the WBD_BASEDON_BENEFITCOST dimension.
• DIM_WBD_BASEDON_BENEFITCOST_ELEMENTS contains the elements for the WBD_BASEDON_BENEFITCOST dimension.
• DIM_WBD_BASEDON_BENEFITCOST_PARENTS contains the parent/child relationships for the WBD_BASEDON_BENEFITCOST dimension.

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

The table describes DAT_BENEFITCOST_STAGE:

Field	Required	Description
BenefitCostCode	Y	BenefitCostCode of benefit or cost definition. The related field is BenefitCostCode in the DAT_BENEFITCOST_STAGE table.
BasedOnBenfitCostCode	Y	BenefitCostCode of benefit or cost definition based on other benefit and cost definitions. These calculation types are for benefit costs: PremiumAmountPremiumRate PremiumPercentPremiumRate Must have exactly one based-on benefit and cost. The based-on benefit and cost must exist and must have a calculation type of either PremiumAmountBaseRate or PremiumPercentBaseRate. PercentOfPeriodic PercentOfAnnualized YTDRanges Must have at least one based-on benefit and cost. Can have more than one based-on benefit and cost. Based-on benefits and costs must exist and can be any calculation type except BaseRateAmountChange and BaseRatePercentChange. Can be based on base salary which has no definition. If using base salary as a Based On type, specify BaseSalary without a space. The related field is BenefitCostCode in the DAT_BENEFITCOST_STAGE table.