Benefit cost dated value
- FlatAmount that is spread
- RateXQuantity that is spread
- PercentOfPeriodic
- PercentofAnnualized
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 staging table is WFB_BenefitCostDatedValue.
| 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 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:
There is no default value. |
| EffectiveEnd | [datetime] NULL |
Y/N | End date of the specified value. This value is required for these calculation types:
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. There is no default value. |
| Value | [float] (53) NULL |
Y/N | Value or percentage used in calculations. This value is required for these calculation types:
|