Benefit cost dated value

One or more non-global pay-benefit values for different data ranges used in these benefit and non-global cost calculation types:
  • FlatAmount that is spread (in BenefitCost object Calculation Method across periods)
  • RateXQuantity that is spread (in BenefitCost object Calculation Method is across periods)
  • PercentOfPeriodic (in BenefitCost object Calculation Method is across periods)
  • PercentofAnnualized (in BenefitCost object Calculation Method is single period)

There can be multiple values in a dated values definition. Values have effective start and end dates or start and end periods according to these rules:

  • FlatAmount that is spread. The effective start and effective end dates must be specified for every value.
  • RateXQuantity that is spread. The effective start and effective end dates must be specified for every value.
  • PercentOfPeriodic. The start and end periods must be specified for every value.
  • PercentOfAnnualized. The effective start date must be specified for every value.

The table is WFB_BenefitCostDatedValue.

Field Type Required Description
Currency [nvarchar] (3)

NOT NULL

Y Valid currency ID in the Currency business object.

Currency is used by these calculation types:

  • FlatAmount
  • RateXQuantity
BenefitCostCode [nvarchar] (200)

NOT NULL

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

The related table is BenefitCost, the field is BenefitCostCode.

EffectiveStart [datetime]

NULL

Y/N Start date of the specified value.

This value is required for these calculation types:

  • FlatAmount spread (Calculation method is across periods)
  • RateXQuantity spread (Calculation method is across periods)
  • PercentOfAnnualized (Calculation method is a single periods)

There is no default value.

EffectiveEnd [datetime]

NULL

Y/N End date of the specified value.

This value is required for these calculation types:

  • FlatAmount spread (Calculation method is across periods)
  • RateXQuantity spread (Calculation method is across periods)

There is no default value.

StartPeriod [float] (53)

NULL

Y/N Start period of the specified value.

The format is YYYYMM.

PercentOfPeriodic is required.

There is no default value.

EndPeriod [float] (53)

NULL

Y/N End period of the specified value.

The format is YYYYMM.

This is required for the PercentOfPeriodic calculation type that is configured for across periods as the calculation method.

There is no default value.

Value [float] (53)

NULL

Y/N Value or percentage used in calculations.

This value is required for these non-global calculation types:

  • FlatAmout spread
  • RateXQuantity spread
  • PercentOfAnnualized (single period)
  • PercentOfPeriodic (spread)