Benefit cost caps

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

The staging table is WFB_BenefitCostCaps.

Field Type Mandatory 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.