DAT_WDCCALCULATION_TRANSFORMED

This table describes DAT_WDCCALCULATION_TRANSFORMED:

Columns Validations Value
WDDPERIOD From the _STAGE table.
BPDENTITY Must exist in BPDENTITY. N.A.
BPDORGANIZATION Must exist in BPDORGANIZATION. nvarchar(71)
WBDJOB Must exist in WBDJOB. nvarchar(71)
WBDPOSITION Must exist in WBDPOSITION. N.A.
WBDEMPLOYEE Must exist in WBDEMPLOYEE. Mandatory; nvarchar(71)
BPDANALYSIS_01 Must exist in BPDANALYSIS_01. nvarchar(71)
BPDANALYSIS_02 Must exist in BPDANALYSIS_02. nvarchar(71)
BPDANALYSIS_03 Must exist in BPDANALYSIS_03. nvarchar(71)
BPDANALYSIS_04 Must exist in BPDANALYSIS_04. nvarchar(71)
BPDANALYSIS_05 Must exist in BPDANALYSIS_05. nvarchar(71)
BPDANALYSIS_06 Must exist in BPDANALYSIS_06. N.A.
BPDANALYSIS_07 Must exist in BPDANALYSIS_07. nvarchar(71)
BPDANALYSIS_08 Must exist in BPDANALYSIS_08. nvarchar(71)
BPDANALYSIS_09 Must exist in BPDANALYSIS_09. nvarchar(71)
BPDANALYSIS_10 Must exist in BPDANALYSIS_10. nvarchar(71)
BPDANALYSIS_11 Must exist in BPDANALYSIS_11. nvarchar(71)
BPDPSEGMENT Must exist in BPDPSEGMENT. nvarchar(71)
BPDSSEGMENT Must exist in BPDSSEGMENT. nvarchar(71)
BPDTSEGMENT Must exist in BPDTSEGMENT. nvarchar(71)
BPDACCOUNT From the _STAGE table. WFD_FTE
VALUE Must be numeric.