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 calculation types

The staging table is WFB_BenefitCostBasedOn.

This table describes the Benefit Cost Based On business object:

Field Type Mandatory Description
BenefitCostCode [nvarchar] (200)

NOT NULL

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

The related table is BenefitCost, the field is BenefitCostCode.

BasedOnBenefitCostCode [nvarchar] (200)

NOT NULL

Y Benefit or cost action based on other benefit and cost definitions.

The related table is BenefitCost, the field is BenefitCostCode.

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.