QuantityXRate

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