Tableau Connector for Workday

Build 20.0.7740

ExternalPayrollInputs

Encapsulating element containing all External Payroll Input data.

Columns

Name Type References Description
External_Payroll_Input_Reference_WID String Contains a unique identifier for an instance of an object.
External_Payroll_Input_Reference_Payroll_Input_ID String Contains a unique identifier for an instance of an object.
Payroll_Input_ID String The integration ID used to reference the Payroll Input. If the ID for the Payroll Input is found, the web service will update the existing data. Otherwise, a new Payroll Input instance will be created.
Payee_Reference_WID String Contains a unique identifier for an instance of an object.
Payee_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Pay_Component_Workday_Reference_WID String Contains a unique identifier for an instance of an object.
Pay_Component_Workday_Reference_Deduction_Code String Contains a unique identifier for an instance of an object.
Pay_Component_Workday_Reference_Earning_Code String Contains a unique identifier for an instance of an object.
Pay_Component_Workday_Reference_Workday_Deduction_Code String Contains a unique identifier for an instance of an object.
Pay_Component_Workday_Reference_Workday_Earning_Code String Contains a unique identifier for an instance of an object.
External_Payroll_Code String A non-unique code used by some Payroll Interface customers. External Payroll Code is available in Workday 13 if the customer has enabled it via the Tenant Setup page.
Batch_ID String Batch ID can be assigned to a set of Payroll Inputs to enable the external system to manage Payroll Input data by Batch ID. There are transactions in Workday Payroll that let the user maintain Payroll Input data by Batch ID (Payroll Input by Batch ID and Delete Payroll Input by Batch ID).
Start_Date Date Start Date (e.g. the date on which the Payroll Input commences)
End_Date Date End Date (e.g. the date on which the Payroll Input ends, if applicable)
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.
Worktag_Reference_WID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Business_Unit_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Cost_Center_Reference_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Custom_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Custom_Worktag_06_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Custom_Worktag_07_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Custom_Worktag_08_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Custom_Worktag_09_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Custom_Worktag_1_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Custom_Worktag_10_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Custom_Worktag_11_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Custom_Worktag_12_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Custom_Worktag_13_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Custom_Worktag_14_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Custom_Worktag_15_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Custom_Worktag_2_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Custom_Worktag_3_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Custom_Worktag_4_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Custom_Worktag_5_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Exemption_Code String Contains a unique identifier for an instance of an object.
Worktag_Reference_Flexible_Payment_and_Deduction_Worktag_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_FLSA_Workweek_Calendar_Event_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Fund_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Gift_Reference_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Grant_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Holiday_Calendar_Event_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Worktag_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Worktag_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Worktag_Reference_Job_Profile_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Location_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_NI_Category_Letter String Contains a unique identifier for an instance of an object.
Worktag_Reference_Object_Class_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Payroll_Federal_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Worktag_Reference_Payroll_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Payroll_Income_Code String Contains a unique identifier for an instance of an object.
Worktag_Reference_Payroll_Local_City_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Worktag_Reference_Payroll_Local_County_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Worktag_Reference_Payroll_Local_Other_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Worktag_Reference_Payroll_Local_School_District_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Worktag_Reference_Payroll_State_Authority_Tax_Code String Contains a unique identifier for an instance of an object.
Worktag_Reference_Position_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Program_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Project_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Project_Plan_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Region_Reference_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Rubric_Value_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Run_Category_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_UK_Holiday_Pay_Work_Period_Calendar_Event_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Withholding_Order_Case_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference_Workers_Compensation_ID String Contains a unique identifier for an instance of an object.
Input_Value Decimal Value (for Currency)
Unit Decimal Unit of the External Payroll Input
Unit_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Unit_Type_Reference_UN_CEFACT_Common_Code_ID String Contains a unique identifier for an instance of an object.
Unit_Type_Reference_UOM_EDI_Code_ID String Contains a unique identifier for an instance of an object.
Rate Decimal Rate
Percentage Decimal Percentage
Goal_Amount Decimal Goal Amount (for Currency)
Adjustment_Value Decimal Adjustment Value (for Currency)
Comment String Comment
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