Tableau Connector for Workday

Build 20.0.7740

PayrollResults_Payroll_Result_Data

Payroll Result Data

Columns

Name Type References Description
PayrollResult_Employee_Reference_WID String

PayrollResults.Employee_Reference_WID

The unique identifier type. Each
Pay_Component_Reference String Pay Component Reference
Pay_Component_Frequency Decimal Pay Component Frequency Factor
Periods_Remaining_In_Calendar_Year Decimal Periods Remaining In Calendar Year - Number of Pay Periods remaining in the calendar year based on Payment Date and Pay Component Frequency.
Subperiod_Start_Date Date Subperiod Start Date
Subperiod_End_Date Date Subperiod End Date
Company_Worktag_Reference String Worktag - Company.
Location_Worktag_Reference String Worktag - Location.
Region_Worktag_Reference String Worktag - Region.
Job_Profile_Worktag_Reference String Worktag - Job Profile.
Cost_Center_Worktag_Reference String Worktag - Cost Center.
Project_Worktag_Reference String Worktag - Project.
Withholding_Order_Worktag_Reference String Worktag - Withholding Order Case.
Payroll_State_Authority_Worktag_Reference String Worktag - Payroll State Authority.
Workers_Compensation_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Workers_Compensation_Code_Reference_Workers_Compensation_ID String Contains a unique identifier for an instance of an object.
Payroll_Local_County_Authority_Worktag_Reference String Worktag - Payroll Local County Authority.
Payroll_Local_City_Authority_Worktag_Reference String Worktag - Payroll Local City Authority.
Payroll_Local_School_District_Worktag_Reference String Worktag - Payroll Local School District.
Payroll_Local_Other_Worktag_Reference String Worktag - Payroll Local Other Authority
Custom_Worktag_1_Reference String Worktag - Custom Worktag 1.
Custom_Worktag_2_Reference String Worktag - Custom Worktag 2.
Custom_Worktag_3_Reference String Worktag - Custom Worktag 3.
Custom_Worktag_4_Reference String Worktag - Custom Worktag 4.
Custom_Worktag_5_Reference String Worktag - Custom Worktag 5.
Fund_Worktag_Reference_WID String Contains a unique identifier for an instance of an object.
Fund_Worktag_Reference_Fund_ID String Contains a unique identifier for an instance of an object.
Grant_Worktag_Reference_WID String Contains a unique identifier for an instance of an object.
Grant_Worktag_Reference_Grant_ID String Contains a unique identifier for an instance of an object.
Gift_Worktag_Reference_WID String Contains a unique identifier for an instance of an object.
Gift_Worktag_Reference_Gift_Reference_ID String Contains a unique identifier for an instance of an object.
Program_Worktag_Reference_WID String Contains a unique identifier for an instance of an object.
Program_Worktag_Reference_Program_ID String Contains a unique identifier for an instance of an object.
Business_Unit_Worktag_Reference_WID String Contains a unique identifier for an instance of an object.
Business_Unit_Worktag_Reference_Business_Unit_ID String Contains a unique identifier for an instance of an object.
Object_Class_Worktag_Reference_WID String Contains a unique identifier for an instance of an object.
Object_Class_Worktag_Reference_Object_Class_ID String Contains a unique identifier for an instance of an object.
Project_Phase_Worktag_Reference_WID String Contains a unique identifier for an instance of an object.
Project_Phase_Worktag_Reference_Project_Plan_ID String Contains a unique identifier for an instance of an object.
Project_Task_Worktag_Reference_WID String Contains a unique identifier for an instance of an object.
Project_Task_Worktag_Reference_Project_Plan_ID String Contains a unique identifier for an instance of an object.
Custom_Organization_Worktag_Data String Custom Organizations Worktag Data
Custom_Worktag_06_Reference_WID String Contains a unique identifier for an instance of an object.
Custom_Worktag_06_Reference_Custom_Worktag_06_ID String Contains a unique identifier for an instance of an object.
Custom_Worktag_07_Reference_WID String Contains a unique identifier for an instance of an object.
Custom_Worktag_07_Reference_Custom_Worktag_07_ID String Contains a unique identifier for an instance of an object.
Custom_Worktag_08_Reference_WID String Contains a unique identifier for an instance of an object.
Custom_Worktag_08_Reference_Custom_Worktag_08_ID String Contains a unique identifier for an instance of an object.
Custom_Worktag_09_Reference_WID String Contains a unique identifier for an instance of an object.
Custom_Worktag_09_Reference_Custom_Worktag_09_ID String Contains a unique identifier for an instance of an object.
Custom_Worktag_10_Reference_WID String Contains a unique identifier for an instance of an object.
Custom_Worktag_10_Reference_Custom_Worktag_10_ID String Contains a unique identifier for an instance of an object.
Custom_Worktag_11_Reference_WID String Contains a unique identifier for an instance of an object.
Custom_Worktag_11_Reference_Custom_Worktag_11_ID String Contains a unique identifier for an instance of an object.
Custom_Worktag_12_Reference_WID String Contains a unique identifier for an instance of an object.
Custom_Worktag_12_Reference_Custom_Worktag_12_ID String Contains a unique identifier for an instance of an object.
Custom_Worktag_13_Reference_WID String Contains a unique identifier for an instance of an object.
Custom_Worktag_13_Reference_Custom_Worktag_13_ID String Contains a unique identifier for an instance of an object.
Custom_Worktag_14_Reference_WID String Contains a unique identifier for an instance of an object.
Custom_Worktag_14_Reference_Custom_Worktag_14_ID String Contains a unique identifier for an instance of an object.
Custom_Worktag_15_Reference_WID String Contains a unique identifier for an instance of an object.
Custom_Worktag_15_Reference_Custom_Worktag_15_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.
ARRCO_AGIRC_Category_Reference_WID String Contains a unique identifier for an instance of an object.
ARRCO_AGIRC_Category_Reference_Rubric_Value_ID String Contains a unique identifier for an instance of an object.
Income_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Income_Code_Reference_Payroll_Income_Code String Contains a unique identifier for an instance of an object.
Exemption_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Exemption_Code_Reference_Exemption_Code String Contains a unique identifier for an instance of an object.
Tax_Residency_Country_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Residency_Country_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Tax_Residency_Country_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Tax_Residency_Country_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Costing_Company_Reference_WID String Contains a unique identifier for an instance of an object.
Costing_Company_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Costing_Company_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Result_Line_Amount Decimal Result Line Amount
Result_Line_QTD_Amount Decimal Quarter-To-Date Amount for the Pay Component.
Result_Line_YTD_Amount Decimal Year-To-Date Amount for the Pay Component.
Result_Line_Arrears_Amount Decimal Result Line Arrears Amount
Related_Calculation_Result_Data String Related Calculation Result Data
Case_Number String Case Number
Withholding_Order_Type String The withholding order type.
Order_Date Date Order Date
Received_Date Datetime Date the withholding order was received.
Begin_Date Date Begin Date
End_Date Date End Date
Order_Status String End Date
Order_Priority Decimal Order Priority
Total_Debt_Amount Decimal Total Debt Amount
Pay_Period_Amount_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Pay_Period_Amount_Type_Reference_Withholding_Order_Amount_Type_ID String Contains a unique identifier for an instance of an object.
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.
Payroll_Tax_Authority_Reference_WID String Contains a unique identifier for an instance of an object.
Payroll_Tax_Authority_Reference_Payroll_Federal_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Payroll_Tax_Authority_Reference_Payroll_Local_City_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Payroll_Tax_Authority_Reference_Payroll_Local_County_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Payroll_Tax_Authority_Reference_Payroll_Local_Other_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Payroll_Tax_Authority_Reference_Payroll_Local_School_District_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Payroll_Tax_Authority_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.
Deduction_Recipient_Instant_Messenger_Reference String Deduction Recipient Instant Messenger Reference
Deduction_Recipient_Bank_Account_Reference_WID String Contains a unique identifier for an instance of an object.
Deduction_Recipient_Bank_Account_Reference_Payee_Settlement_Bank_Account_ID String Contains a unique identifier for an instance of an object.
Originating_Entity String The agency or court that issued the withholding order.
Memo String Memo
Deduction_Recipient_Address_Data String Address Information for the Deduction Recipient on the Withholding Order
Payroll_Input_Comment String Comment on associated Payroll Input (first comment shown, if there are multiple).

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