Tableau Connector for Workday

Build 20.0.7740

Payees_Related_Person

Contains the dependent, beneficiary, and emergency contact information for the related person.

Columns

Name Type References Description
Payee_Payee_Reference_WID String

Payees.Payee_Reference_WID

The unique identifier type. Each
Related_Person_Relationship_Reference String A reference to the related person relationship.
Person_Reference_IID String Contains a unique identifier for an instance of an object.
Person_Reference_WID 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.
Additional_Name_Data String Contains the additional names for a person, other than their legal and preferred names. Additional names are not valid for applicants.
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.
Personal_Country_of_Birth_Reference_WID String Contains a unique identifier for an instance of an object.
Personal_Country_of_Birth_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Personal_Country_of_Birth_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Personal_Country_of_Birth_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Personal_Region_of_Birth_Reference_WID String Contains a unique identifier for an instance of an object.
Personal_Region_of_Birth_Reference_Country_Region_ID String Contains a unique identifier for an instance of an object.
Personal_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.
Personal_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.
Disability_Status_Data String Security Note: This element is secured according to the security policy for the Worker Data: Disabilities domain.
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.
Personal_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.
Military_Service_Data String Security Note: This element is secured according to the security policy for the
National_ID String Wrapper element for all National Identifier Data.
Government_ID String Wrapper element for all Government Identifier Data.
Visa_ID String Wrapper element for all Visa Identifier Data.
Passport_ID String Wrapper element for all Passport Identifier Data.
License_ID String Wrapper element for all License Identifier Data.
Custom_ID String Wrapper element for all Custom Identifier Data.
Address_Data String Address information
Phone_Data String Phone Information
Email_Address_Data String Email Address Information
Instant_Messenger_Data String Instant Messenger Information
Web_Address_Data String Web Address Information
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.
Relative_Name_Data String contains relative names for a relative of a person
Dependent_Reference_WID String Contains a unique identifier for an instance of an object.
Dependent_Reference_Dependent_ID String Contains a unique identifier for an instance of an object.
Dependent_ID String The ID for the dependent.
Full_time_Student Bool Boolean attribute identifying whether Dependent is a Full-time Student.
Student_Status_Start_Date Date The date the dependent became a full-time student.
Student_Status_End_Date Date The date the dependent's student status ended (no longer a full-time student)
Disabled Bool Boolean attribute identifying whether Dependent is Disabled.
Dependent_Inactive_Date Date If inactive, the date from which dependent is inactive.
Dependent_for_Payroll_Purposes Bool Tells if this dependent's information is used in payroll calculations. Only use if dependents for payroll purposes are being tracked for the location context of the worker for this dependent.
Dependent_Citizenship_Status_Reference String Reference to the legal status of the dependent.
Country_of_Nationality_Reference_WID String Contains a unique identifier for an instance of an object.
Country_of_Nationality_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Country_of_Nationality_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Country_of_Nationality_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Dependent_Country_of_Birth_Reference_WID String Contains a unique identifier for an instance of an object.
Dependent_Country_of_Birth_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Dependent_Country_of_Birth_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Dependent_Country_of_Birth_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Dependent_Region_of_Birth_Reference_WID String Contains a unique identifier for an instance of an object.
Dependent_Region_of_Birth_Reference_Country_Region_ID String Contains a unique identifier for an instance of an object.
Dependent_Region_of_Birth_Reference_ISO_3166_2_Code String Contains a unique identifier for an instance of an object.
Dependent_City_of_Birth String The dependent's city of birth.
Dependent_Court_Order String Court Order Details. NOTE: You must pass in the entire set of court orders. Any existing court orders that are not submitted will be removed.
Lives_With_Worker_Data String If the dependent lives with worker
Has_Health_Insurance_Data String If the dependent has health insurance
Allowed_for_Tax_Deduction_Data String If the dependent is allowed for tax deduction
Annual_Income_Data String Dependent's annual income
Occupation_Data String Occupation of the Dependent
Disability_Data String Wrapper element for all Disability Status data for the Dependent.
Beneficiary_Reference_WID String Contains a unique identifier for an instance of an object.
Beneficiary_Reference_Beneficiary_ID String Contains a unique identifier for an instance of an object.
Beneficiary_ID String The ID for the beneficiary.
Irrevocable Bool Indicates if the beneficiary is revocable.
Beneficiary_Inactive_Date Date If inactive, the date from which the beneficiary is inactive.
Beneficiary_Court_Order String Court Order Details. NOTE: You must pass in the entire set of court orders. Any existing court orders that are not submitted will be removed.
Emergency_Contact_Reference_WID String Contains a unique identifier for an instance of an object.
Emergency_Contact_Reference_Emergency_Contact_ID String Contains a unique identifier for an instance of an object.
Emergency_Contact_ID String The ID for the emergency contact.
Language_Reference String The preferred language for the emergency contact.
Emergency_Contact_Priority_Reference_WID String Contains a unique identifier for an instance of an object.
Emergency_Contact_Priority_Reference_Emergency_Contact_Priority_ID String Contains a unique identifier for an instance of an object.

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