WDCCALCULATION cube

This cube is for employee FTE records.

• The staging table is DAT_WDCCALCULATION_STAGE.
• The stored procedure to validate staged data is depm_integration_wp_calculation_prepare_staging.
• The stored procedure to process staged data is depm_integration_wp_calculation.
• The output table is ATT_WDCCALCULATION (calculations cube data table).

The table describes DAT_WDCCALCULATION_STAGE:

Field	Type	Required	Description
WBDPERIOD	nvarchar(2000)	Y	Must be assigned to a valid period.
BPDENTITY	nvarchar(2000)	N	Must exist in DIM_BPDENTITY_ELEMENTS.
BPDORGANIZATION	nvarchar(2000)	Y	Must exist in DIM_BPDORGANIZATION_ELEMENTS.
WBDJOB	nvarchar(2000)	Y	Must exist in DIM_WBDJOB_ELEMENTS.
WBDPOSITION	nvarchar(2000)	N	Must exist in DIM_WBDPOSITION_ELEMENTS.
WBDEMPLOYEE	nvarchar(2000)	Y	Must exist in DIM_WBDJOB_ELEMENTS.
BPDANALYSIS_nn	nvarchar(2000)	N	Must exist in DIM_BPDANALYSIS_nn_ELEMENTS.
BPDPSEGMENT	nvarchar(2000)	N	Must exist in DIM_BPDPSEGMENT_ELEMENTS.
BPDSSEGMENT	nvarchar(2000)	N	Must exist in DIM_BPDSSEGMENT_ELEMENTS.
BPDTSEGMENT	nvarchar(2000)	N	Must exist in DIM_BPDTSEGMENT_ELEMENTS.
BPDACCOUNT	nvarchar(2000)	Y	Filled in automatically in ATT_WDCCALCULATION table.
VALUE		N	Must be numeric.