Tableau Connector for Workday

Build 20.0.7740

CanadaIncomeWithholdingOrders

Contains all income withholding order data.

Columns

Name Type References Description
Employee_Reference_WID String Contains a unique identifier for an instance of an object.
Employee_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Employee_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Withholding_Order_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Withholding_Order_Type_Reference_Withholding_Order_Type_Code String Contains a unique identifier for an instance of an object.
Withholding_Order_Additional_Order_Number String An additional withholding order number.
Order_Date Date Date the withholding order was issued.
Received_Date Datetime Date the withholding order was received.
Begin_Date Date Date the withholding order should begin.
End_Date Date Date the withholding order should end.
Termination_Date Date The date the withholding order is terminated.
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.
Inactive_Order Bool Indicates that the withholding order is inactive.
Pay_Period_Frequency_Reference_WID String Contains a unique identifier for an instance of an object.
Pay_Period_Frequency_Reference_Frequency_ID String Contains a unique identifier for an instance of an object.
Total_Debt_Amount Decimal The total debt amount on the order.
Issued_In_Reference_WID String Contains a unique identifier for an instance of an object.
Issued_In_Reference_Payroll_Federal_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Issued_In_Reference_Payroll_Local_City_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Issued_In_Reference_Payroll_Local_County_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Issued_In_Reference_Payroll_Local_Other_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Issued_In_Reference_Payroll_Local_School_District_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Issued_In_Reference_Payroll_State_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Deduction_Recipient_Reference_WID String Contains a unique identifier for an instance of an object.
Deduction_Recipient_Reference_Deduction_Recipient_ID String Contains a unique identifier for an instance of an object.
Originating_Entity String The agency or court that issued the withholding order.
Number_of_Dependents Decimal Number of dependants to be used in the exemption calculation.
Number_of_Child_Dependents Decimal The number of child dependents for use when calculating exemptions.
Supports_Family Bool Indicates whether the employee supports a family for the purpose of determining the exemption amount.
No_Exemption Bool If set to True, Workday doesn't calculate exemptions for the withholding order and the full disposable earnings amount will be eligible for withholding.
Exemption_Amount_Override Decimal When specified, the exemption amount to be used in the calculation of disposable earnings.
Exemption_Frequency_Reference_WID String Contains a unique identifier for an instance of an object.
Exemption_Frequency_Reference_Frequency_ID String Contains a unique identifier for an instance of an object.
Exempt_Percent_Override Decimal When the exemption calculation includes a percentage, the percentage to be used in the calculation of disposable earnings.
Override_Subject_Rate Decimal Override rate used in the maximum amount to withhold calculation for Quebec garnishment orders.
Memo String Additional details.
Non_Family_Withholding_Order_Data String Non-family withholding order details.
Family_Maintenance_Order_Data String Details for family maintenance orders.
Withholding_Order_Fee_Data String Details of the withholding order fee.
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.
Withholding_Order_ID String The withholding order ID you defined.

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