Benefit cost caps

Benefit cost caps apply to these benefit and cost calculation types:
  • QuantityXRate
  • PercentOfPeriodic
  • PercentOfAnnualized
  • YTDRanges

The table is WFB_BenefitCostCaps.

Field Type Required Description
Currency [nvarchar] (3)

NOT NULL

Y Valid currency ID in the Currency business object.
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.

Cap [float] (53)

NULL

Y The maximum amount that can be applied over the course of a year.

Optional, but 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.