Tableau Connector for Workday

Build 20.0.7740

PayrollPayeeNIs

Payroll Payee NI Data

Columns

Name Type References Description
Worker_Reference_WID String Contains a unique identifier for an instance of an object.
Worker_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Worker_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Effective_As_Of Date Effective date NI category assigned to employee
Company_Reference_WID String Contains a unique identifier for an instance of an object.
Company_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Company_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
NI_Category_Reference_WID String Contains a unique identifier for an instance of an object.
NI_Category_Reference_NI_Category_Letter String Contains a unique identifier for an instance of an object.
Position_Reference_WID String Contains a unique identifier for an instance of an object.
Position_Reference_Position_ID String Contains a unique identifier for an instance of an object.
Calculation_Method_Reference_WID String Contains a unique identifier for an instance of an object.
Calculation_Method_Reference_Payroll_Constant_Text_ID String Contains a unique identifier for an instance of an object.
SCON String Scheme contracted out number (SCON) for employee (only required for NI categories D, E, I, K, L) and must pass modulus 19 validation
Proof_of_Age_Exemption_Reference_WID String Contains a unique identifier for an instance of an object.
Proof_of_Age_Exemption_Reference_Payroll_Constant_Text_ID String Contains a unique identifier for an instance of an object.
CA2700 Bool CA2700 certificate for employee (only for NI categories J, K, L, Z)
CA2700_Valid_for_Tax_Year_Ending_Reference_WID String Contains a unique identifier for an instance of an object.
CA2700_Valid_for_Tax_Year_Ending_Reference_Calendar_Year_ID String Contains a unique identifier for an instance of an object.
Certificate_of_Election_Reference_WID String Contains a unique identifier for an instance of an object.
Certificate_of_Election_Reference_Payroll_Constant_Text_ID String Contains a unique identifier for an instance of an object.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7740