Tableau Connector for Workday

Build 20.0.7740

PayrollPayeeTD1s

Payroll Payee TD1 Data

Columns

Name Type References Description
Payroll_Payee_TD1_ID String Payroll Payee TD1 ID
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.
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 As Of
Basic_Personal_Amount Decimal TD1 Basic Personal Amount
Child_Amount Decimal TD1 Child Amount
Age_Amount Decimal TD1 Age Amount
Pension_Income_Amount Decimal TD1 Pension Income Amount
Tuition_Education_and_Textbook_Amounts Decimal TD1 Tuition, Education and Textbook Amounts
Disability_Amount Decimal TD1 Disability Amount
Spouse_or_Common_law_Partner_Amount Decimal TD1 Spouse or Common-law Partner Amount
Amount_for_an_Eligible_Dependant Decimal TD1 Amount for an Eligible Dependant
Caregiver_Amount Decimal TD1 Caregiver Amount
Amount_for_Infirm_Dependants_Age_18_or_Older Decimal TD1 Amount for Infirm Dependants Age 18 or Older
Amounts_Transferred_from_your_Spouse_or_Common_law_Partner Decimal TD1 Amounts Transferred from your Spouse or Common-law Partner
Amounts_Transferred_from_a_Dependant Decimal TD1 Amounts Transferred from a Dependant
Total_Income_less_than_Total_Claim_Amount Bool TD1 Total Income less than Total Claim Amount
More_than_One_Employer_or_Payer_at_the_Same_Time Bool TD1 More than One Employer or Payer at the Same Time
Deduction_for_Living_in_a_Prescribed_Zone Decimal TD1 Deduction for Living in a Prescribed Zone
Additional_Amount Decimal TD1 Additional Amount
Non_Resident Bool Non-Resident
ESS_Electronic_Signature_Confirmation Datetime TD1 ESS Electronic Signature Confirmation
Payroll_Payee_Tax_Data_Event_Reference_IID String Contains a unique identifier for an instance of an object.
Payroll_Payee_Tax_Data_Event_Reference_WID String Contains a unique identifier for an instance of an object.
Last_Updated Datetime Last Updated
Last_Updated_By_Reference_WID String Contains a unique identifier for an instance of an object.
Last_Updated_By_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Last_Updated_By_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.

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