QuantityXRate

The QuantityXRate calculation method uses information as described in this topic.

This information is required for the WFB_BenefitCost table:

  • The value for BenefitCostSalary can be Benefit or Cost.
  • The value for BenefitCostCode is a unique ID.
  • The value for BenefitCostName is free text.
  • The value for Account is one of the available accounts specified for the configuration set.
  • The value for YTD can be Fiscal or Calendar. If the field is empty, then the default is Fiscal.
  • The value for CalcType is QuantityXRate.
  • The value for GlobalOrDetailed is always Detailed. If the field is empty, then the default is Detailed.
  • The value for DateType is one of the available date types. If the field is empty, then the default is CalendarDate.
  • The value for CalculationMethod can be Across Periods or Single Period. If the field is empty, then the default is Across Periods.

This information is optional for the WFB_BenefitCost table:

  • Value1. If dated values are activated, then this field is not used. It is filled from the WFB_BenefitCostDatedValue table.
  • Value2
  • AllowBudgeterToApply. If the field is empty, then the default is Active.
  • AllowBudgeterToOverride. If the field is empty, then the default is Active.
  • DatedValues is used only by a calculation method that is spread. If the field is empty, then the default is Inactive.

If QuantityXRate uses DatedValues for a calculation method Across Periods, then this information in the WFB_BenefitCostDatedValue table is required:

  • Currency
  • BenefitCostCode
  • EffectiveStart
  • EffectiveEnd
  • Value

If QuantityXRate uses Cap, then this information in the WFB_BenefitCostCaps table is required:

  • Currency
  • BenefitCostCode
  • Cap