Tableau Connector for Workday

Build 20.0.7740

Applicants

Wrapper element for the Applicant Data.

Columns

Name Type References Description
Applicant_Reference_WID String Contains a unique identifier for an instance of an object.
Applicant_Reference_Applicant_ID String Contains a unique identifier for an instance of an object.
Applicant_ID String Applicant ID.
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.
Applicant_Entered_Date Date The date the applicant was created.
Applicant_Comments String Comments about the applicant.
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.
Eligible_for_Rehire_Comments String Comment on the rehire eligibility status for the prehire.
Applicant_Has_Marked_as_No_Show_Reference_WID String Contains a unique identifier for an instance of an object.
Applicant_Has_Marked_as_No_Show_Reference_Boolean_ID String Contains a unique identifier for an instance of an object.
Applicant_Source_Reference_WID String Contains a unique identifier for an instance of an object.
Applicant_Source_Reference_Applicant_Source_ID String Contains a unique identifier for an instance of an object.
Referred_by_Worker_Reference String Worker referring the applicant.
Positions_Considered_for_Reference String The positions that the applicant is considered for.

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