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. |