Tableau Connector for Workday

Build 20.0.7740

Payees

Encapsulating element containing all Payee data.

Columns

Name Type References Description
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.
Universal_Identifier_Reference_WID String Contains a unique identifier for an instance of an object.
Universal_Identifier_Reference_Universal_Identifier_ID String Contains a unique identifier for an instance of an object.
Universal_ID String The universal ID uniquely identifies the Person. It remains the same for a person regardless of what roles they have. This field will be automatically populated if a sequence generator is configured in Edit Tenant Setup-System.
Legal_Name_Country_Reference_WID String Contains a unique identifier for an instance of an object.
Legal_Name_Country_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Legal_Name_Country_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Legal_Name_Country_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Legal_Name_Title_Reference_WID String Contains a unique identifier for an instance of an object.
Legal_Name_Title_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Legal_Name_Title_Descriptor String The description of the reference to the Title of a person.
Legal_Name_Salutation_Reference_WID String Contains a unique identifier for an instance of an object.
Legal_Name_Salutation_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Legal_Name_First_Name String The First Name (Given Name) for a person.
Legal_Name_Middle_Name String The Middle Name for a person.
Legal_Name_Last_Name String The Last Name (Family Name) for a person.
Legal_Name_Secondary_Last_Name String The Secondary Last Name (Secondary Family Name) for a person.
Legal_Name_Tertiary_Last_Name String The Tertiary Last Name for a person.
Local_Name_Detail_First_Name String Contains First Name in local script, which is generally configured to as Given Name, for supporting Countries.
Local_Name_Detail_Middle_Name String Contains Middle Name in local script for supporting Countries.
Local_Name_Detail_Last_Name String Contains Last Name in local script, which is generally configured as Family Name, for supporting Countries.
Local_Name_Detail_Secondary_Last_Name String Contains Secondary Last Name in local script, which is generally configured as Maternal Family Name, for supporting Countries.
Legal_Name_First_Name_2 String Contains First Name in second local script, which is generally configured as Given Name, for supporting Countries.
Legal_Name_Middle_Name_2 String Contains Middle Name in second local script for supporting Countries.
Legal_Name_Last_Name_2 String Contains Last Name in second local script, which is generally configured as Given Name, for supporting Countries.
Legal_Name_Secondary_Last_Name_2 String Contains Secondary Last Name in second local script, which is generally configured as Maternal Family Name, for supporting Countries.
Legal_Name_Social_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Legal_Name_Social_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Legal_Name_Social_Suffix_Descriptor String A reference to the description of Social Suffix for a person.
Legal_Name_Academic_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Legal_Name_Academic_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Legal_Name_Hereditary_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Legal_Name_Hereditary_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Legal_Name_Honorary_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Legal_Name_Honorary_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Legal_Name_Professional_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Legal_Name_Professional_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Legal_Name_Religious_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Legal_Name_Religious_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Legal_Name_Royal_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Legal_Name_Royal_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Legal_Name_Full_Name_for_Singapore_and_Malaysia String Full Person Name is used by Malaysia and Singapore. It is designed for (eliminate space between these two words) Workers in these countries to enter their Full Legal Name. It is an attribute of Global Person Name Class and is not a concatenation of First and Last Names.
Preferred_Name_Country_Reference_WID String Contains a unique identifier for an instance of an object.
Preferred_Name_Country_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Preferred_Name_Country_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Preferred_Name_Country_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Preferred_Name_Title_Reference_WID String Contains a unique identifier for an instance of an object.
Preferred_Name_Title_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Preferred_Name_Title_Descriptor String The description of the reference to the Title of a person.
Preferred_Name_Salutation_Reference_WID String Contains a unique identifier for an instance of an object.
Preferred_Name_Salutation_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Preferred_Name_First_Name String The First Name (Given Name) for a person.
Preferred_Name_Middle_Name String The Middle Name for a person.
Preferred_Name_Last_Name String The Last Name (Family Name) for a person.
Preferred_Name_Secondary_Last_Name String The Secondary Last Name (Secondary Family Name) for a person.
Preferred_Name_Tertiary_Last_Name String The Tertiary Last Name for a person.
Name_Detail_First_Name String Contains First Name in local script, which is generally configured to as Given Name, for supporting Countries.
Name_Detail_Middle_Name String Contains Middle Name in local script for supporting Countries.
Name_Detail_Last_Name String Contains Last Name in local script, which is generally configured as Family Name, for supporting Countries.
Name_Detail_Secondary_Last_Name String Contains Secondary Last Name in local script, which is generally configured as Maternal Family Name, for supporting Countries.
Preferred_Name_First_Name_2 String Contains First Name in second local script, which is generally configured as Given Name, for supporting Countries.
Preferred_Name_Middle_Name_2 String Contains Middle Name in second local script for supporting Countries.
Preferred_Name_Last_Name_2 String Contains Last Name in second local script, which is generally configured as Given Name, for supporting Countries.
Preferred_Name_Secondary_Last_Name_2 String Contains Secondary Last Name in second local script, which is generally configured as Maternal Family Name, for supporting Countries.
Preferred_Name_Social_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Preferred_Name_Social_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Preferred_Name_Social_Suffix_Descriptor String A reference to the description of Social Suffix for a person.
Preferred_Name_Academic_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Preferred_Name_Academic_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Preferred_Name_Hereditary_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Preferred_Name_Hereditary_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Preferred_Name_Honorary_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Preferred_Name_Honorary_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Preferred_Name_Professional_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Preferred_Name_Professional_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Preferred_Name_Religious_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Preferred_Name_Religious_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Preferred_Name_Royal_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Preferred_Name_Royal_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Preferred_Name_Full_Name_for_Singapore_and_Malaysia String Full Person Name is used by Malaysia and Singapore. It is designed for (eliminate space between these two words) Workers in these countries to enter their Full Legal Name. It is an attribute of Global Person Name Class and is not a concatenation of First and Last Names.
Gender_Reference_WID String Contains a unique identifier for an instance of an object.
Gender_Reference_Gender_Code String Contains a unique identifier for an instance of an object.
Birth_Date Date Person's date of birth.
Date_of_Death Date The date of a person's death. The date of death element is not valid for the following web services and will be ignored: Hire Employee, Contract Contingent Worker, and Put Applicant.
Country_of_Birth_Reference_WID String Contains a unique identifier for an instance of an object.
Country_of_Birth_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Country_of_Birth_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Country_of_Birth_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Region_of_Birth_Reference_WID String Contains a unique identifier for an instance of an object.
Region_of_Birth_Reference_Country_Region_ID String Contains a unique identifier for an instance of an object.
Region_of_Birth_Reference_ISO_3166_2_Code String Contains a unique identifier for an instance of an object.
Region_of_Birth_Descriptor String Country Region where the person was born.
City_of_Birth String Person's City of birth.
City_of_Birth_Reference_WID String Contains a unique identifier for an instance of an object.
City_of_Birth_Reference_Country_Subregion_Code_In_Country String Contains a unique identifier for an instance of an object.
City_of_Birth_Reference_Country_Subregion_Internal_ID String Contains a unique identifier for an instance of an object.
Marital_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Marital_Status_Reference_Marital_Status_Code String Contains a unique identifier for an instance of an object.
Marital_Status_Reference_Marital_Status_ID String Contains a unique identifier for an instance of an object.
Marital_Status_Date Date Person's Marital Status Date.
Religion_Reference_WID String Contains a unique identifier for an instance of an object.
Religion_Reference_Religion_ID String Contains a unique identifier for an instance of an object.
Ethnicity_Reference String Reference for the person's Ethnicities.
Hispanic_or_Latino Bool Returns a true if the person's Ethnicity is Hispanic or Latino.
Citizenship_Status_Reference String Person's Legal Citizenship status.
Primary_Nationality_Reference_WID String Contains a unique identifier for an instance of an object.
Primary_Nationality_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Primary_Nationality_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Primary_Nationality_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Additional_Nationality_Reference String List of Additional Nationalities for the person. This is a list of countries.
Hukou_Region_Reference_WID String Contains a unique identifier for an instance of an object.
Hukou_Region_Reference_Country_Region_ID String Contains a unique identifier for an instance of an object.
Hukou_Region_Reference_ISO_3166_2_Code String Contains a unique identifier for an instance of an object.
Hukou_Subregion_Reference_WID String Contains a unique identifier for an instance of an object.
Hukou_Subregion_Reference_Country_Subregion_ID String Contains a unique identifier for an instance of an object.
Hukou_Locality String Locality on the Hukou of the person. This field is only available for the country China and the person with citizenship status of China.
Hukou_Postal_Code String Hukou postal code for the person. This field is only available for the country China and the person with citizenship status of China.
Hukou_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Hukou_Type_Reference_Hukou_Type_ID String Contains a unique identifier for an instance of an object.
Local_Hukou Bool Whether the hukou subregion of the person is local to the location of the primary job. This field is only used in a response and is not used for requests.
Native_Region_Reference_WID String Contains a unique identifier for an instance of an object.
Native_Region_Reference_Country_Region_ID String Contains a unique identifier for an instance of an object.
Native_Region_Reference_ISO_3166_2_Code String Contains a unique identifier for an instance of an object.
Native_Region_Descriptor String The Native Region for the person.
Personnel_File_Agency_for_Person String Personnel File Agency is used in China to indicate where Workers have their Personnel File Stored.
Last_Medical_Exam_Date Date This field tracks the date of the worker's most recent Medical Exam.
Last_Medical_Exam_Valid_To Date This field tracks the expiration date of the worker's most recent Medical Exam.
Medical_Exam_Notes String This field tracks any comments regarding the worker's most recent Medical Exam.
Blood_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Blood_Type_Reference_Blood_Type_ID String Contains a unique identifier for an instance of an object.
Tobacco_Use Bool True if the person uses tobacco. To update a person's Tobacco Use, use the Put Worker Wellness Data web service.
Political_Affiliation_Reference_WID String Contains a unique identifier for an instance of an object.
Political_Affiliation_Reference_Political_Affiliation_ID String Contains a unique identifier for an instance of an object.
Social_Benefits_Locality_Reference_WID String Contains a unique identifier for an instance of an object.
Social_Benefits_Locality_Reference_Social_Benefits_Locality_ID String Contains a unique identifier for an instance of an object.
Active Bool Boolean attribute identifying whether the Worker is Active.
Active_Status_Date Date The most recent date the employee's status was changed.
Hire_Date Date The most recent hire date for the employee or contract start date for the contingent worker.
Original_Hire_Date Date Earliest Hire Date for the Worker.
Hire_Reason_Reference_WID String Contains a unique identifier for an instance of an object.
Hire_Reason_Reference_Event_Classification_Subcategory_ID String Contains a unique identifier for an instance of an object.
Hire_Reason_Reference_General_Event_Subcategory_ID String Contains a unique identifier for an instance of an object.
End_Employment_Date Date Employment End Date for the Worker. This field is informational only. The value is effective immediately on update.
Continuous_Service_Date Date Continuous Service Date for the Worker.
First_Day_of_Work Date First Day of Work only applies to the Payroll web service.
Expected_Retirement_Date Date Expected retirement date for the worker.
Retirement_Eligibility_Date Date Retirement Eligibility Date for the Worker.
Retired Bool Boolean attribute identifying whether the Worker is currently retired.
Retirement_Date Date Most recent Retirement Date.
Seniority_Date Date Seniority date for the worker. Defaults to hire date.
Severance_Date Date Severance date for the worker.
Benefits_Service_Date Date The Benefits Service Date in the employee's service dates. If empty, Workday will use the existing date.
Company_Service_Date Date The Company Service Date in the employee's service dates. If empty, Workday will use the existing date.
Time_Off_Service_Date Date The Time Off Service Date in the worker's service dates. If empty, Workday will use the existing date.
Vesting_Date Date The Vesting Date in the employee's service dates. If empty, Workday will use the existing date.
Date_Entered_Workforce Date The Date Entered Workforce in the employee's service dates. If empty, Workday will use the existing date.
Days_Unemployed Decimal Number of days unemployed since the employee first joined the work force. Used only for China.
Months_Continuous_Prior_Employment Decimal Number of months of continuous prior employment at the employee's most recent job. Used only for China.
Terminated Bool Boolean attribute identifying whether the Worker is currently Terminated.
Termination_Date Date Most recent Termination Date.
Pay_Through_Date Date The payroll pay through date from the worker's most recent termination.
Primary_Termination_Reason_Reference_WID String Contains a unique identifier for an instance of an object.
Primary_Termination_Reason_Reference_Event_Classification_Subcategory_ID String Contains a unique identifier for an instance of an object.
Primary_Termination_Reason_Reference_Termination_Subcategory_ID String Contains a unique identifier for an instance of an object.
Primary_Termination_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Primary_Termination_Category_Reference_Benefits_Event_Category_ID String Contains a unique identifier for an instance of an object.
Primary_Termination_Category_Reference_Change_Job_Category_ID String Contains a unique identifier for an instance of an object.
Primary_Termination_Category_Reference_End_Additional_Job_Category_ID String Contains a unique identifier for an instance of an object.
Primary_Termination_Category_Reference_General_Event_Category_ID String Contains a unique identifier for an instance of an object.
Primary_Termination_Category_Reference_Leave_of_Absence_Family_ID String Contains a unique identifier for an instance of an object.
Primary_Termination_Category_Reference_Termination_Category_ID String Contains a unique identifier for an instance of an object.
Primary_Termination_Category_Reference_Undo_Move_Category_ID String Contains a unique identifier for an instance of an object.
Termination_Involuntary Bool Indicates if the termination was involuntary.
Local_Termination_Reason_Reference_WID String Contains a unique identifier for an instance of an object.
Local_Termination_Reason_Reference_Local_Termination_Reason_ID String Contains a unique identifier for an instance of an object.
Eligible_for_Hire_Reference_WID String Contains a unique identifier for an instance of an object.
Eligible_for_Hire_Reference_Yes_No_Type_ID String Contains a unique identifier for an instance of an object.
Regrettable_Termination Bool Boolean attribute identifying whether the termination was regrettable.
Eligible_for_Rehire_on_Latest_Termination_Reference_WID String Contains a unique identifier for an instance of an object.
Eligible_for_Rehire_on_Latest_Termination_Reference_Yes_No_Type_ID String Contains a unique identifier for an instance of an object.
Hire_Rescinded Bool If True, the Employee's hire was rescinded.
Termination_Last_Day_of_Work Date Last day worked for the worker's termination event.
Resignation_Date Date Date the employee submitted their resignation.
Last_Date_for_Which_Paid Date The last date for which the Canadian worker is paid as specified on the most recent termination transaction for the worker. This field is specific to Canadian employment.
Expected_Date_of_Return Date The date the Canadian worker is expected to return as specified on the most recent termination transaction for the worker. This field is specific to Canadian employment.
Not_Returning Bool Returns
Return_Unknown Bool Returns
Probation_Start_Date Date Primary Position Probation Start Date
Probation_End_Date Date Primary Position Probation End Date
Academic_Tenure_Date Date Date the worker received tenure.
Rehire Bool Returns
Number_of_Payroll_Dependents Decimal The number of dependents, for this worker, that are used for payroll purposes.
User_Name String The user name that is used to sign on to the Workday application.
User_Language_Reference_WID String Contains a unique identifier for an instance of an object.
User_Language_Reference_User_Language_ID String Contains a unique identifier for an instance of an object.
Preferred_Communication_Language_Reference_WID String Contains a unique identifier for an instance of an object.
Preferred_Communication_Language_Reference_User_Language_ID String Contains a unique identifier for an instance of an object.
Locale_Reference_WID String Contains a unique identifier for an instance of an object.
Locale_Reference_Locale_ID String Contains a unique identifier for an instance of an object.
Hour_Clock_Reference_WID String Contains a unique identifier for an instance of an object.
Hour_Clock_Reference_Hour_Clock_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.
Time_Zone_Reference_WID String Contains a unique identifier for an instance of an object.
Time_Zone_Reference_Time_Zone_ID String Contains a unique identifier for an instance of an object.
Default_Display_Language_Reference_WID String Contains a unique identifier for an instance of an object.
Default_Display_Language_Reference_User_Language_ID String Contains a unique identifier for an instance of an object.
Simplified_View Bool To enable user preferences that simplify the overall user experience.

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