Tableau Connector for Workday

Build 20.0.7740

PayrollPayeePT1s

The Data Related to Payroll Payee PT1 Tax Election

Columns

Name Type References Description
Payroll_Payee_PT1_ID String Payroll Payee PT1 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 Date
Payroll_State_Authority_Reference_WID String Contains a unique identifier for an instance of an object.
Payroll_State_Authority_Reference_Payroll_State_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Basic_Personal_Amount Decimal PT1 Basic Personal Amount
Child_Amount Decimal PT1 Child Amount
Age_Amount Decimal PT1 Age Amount
Age_Amount_Supplement Decimal PT1 Age Amount Supplement
Senior_Supplementary_Amount_for_Withholding Decimal PT1 Senior Supplementary Amount for Withholding
Amount_for_Workers_65_or_Older Decimal PT1 Amount for Workers 65 or Older
Pension_Income_Amount Decimal PT1 Pension Income Amount
Tuition_Education_and_Textbook_Amounts Decimal PT1 Tuition, Education and Textbook Amounts
Disability_Amount Decimal PT1 Disability Amount
Spouse_or_Common_law_Partner_Amount Decimal PT1 Spouse or Common-law Partner Amount
Spouse_or_Common_law_Partner_Amount_Supplement Decimal PT1 Spouse or Common-law Partner Amount Supplement
Additional_Amount Decimal PT1 Additional Amount
Deduction_for_Living_in_a_Prescribed_Zone Decimal PT1 Deduction for Living in a Prescribed Zone
Amount_for_an_Eligible_Dependant Decimal PT1 Amount for an Eligible Dependant
Amount_for_an_Eligible_Dependant_Supplement Decimal PT1 Amount for an Eligible Dependant Supplement
Caregiver_Amount Decimal PT! Caregiver Amount
Amount_for_Infirm_Dependants_Age_18_or_Older Decimal PT1 Amount for Infirm Dependants Age 18 or Older
Amounts_Transferred_from_your_Spouse_or_Common_law_Partner Decimal PT1 Amounts Transferred from your Spouse or Common-law Partner
Amounts_Transferred_from_a_Dependant Decimal PT1 Amounts Transferred from a Dependant
Manitoba_Family_Tax_Benefit_Amount Decimal PT1 Manitoba Family Tax Benefit Amount
Total_Income_less_than_Total_Claim_Amount Bool PT1 Total Income less than Total Claim Amount
More_than_One_Employer_Reference Bool PT1 More than One Employer Reference
Dependents_Under_Age_19 Decimal PT1 Dependents Under Age 19
Disabled_Dependents Decimal PT1 Disabled Dependents
Exempt Bool PT1 Exempt
Exempt_from_Health_Contribution Bool PT1 Exempt from Health Contribution
Last_Updated Datetime PT1 Last Updated

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