Tableau Connector for Workday

Build 20.0.7740

AcademicAppointee

Academic Appointee

Columns

Name Type References Description
Academic_Appointee_Reference String Academic Appointee Reference
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.
Date_of_Birth Date Person's Date of Birth.
Date_of_Death Date Person's Date of Death.
Birth_Country_Reference_WID String Contains a unique identifier for an instance of an object.
Birth_Country_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Birth_Country_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Birth_Country_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Birth_Region_Reference_WID String Contains a unique identifier for an instance of an object.
Birth_Region_Reference_Country_Region_ID String Contains a unique identifier for an instance of an object.
Birth_Region_Reference_ISO_3166_2_Code String Contains a unique identifier for an instance of an object.
City_of_Birth String Person's City of Birth.
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.
Ethnicity_Reference String Reference for the person's Ethnicities.
Hispanic_or_Latino Bool Boolean to indicate if a person is Hispanic or Latino.
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.
Citizenship_Reference String Reference for the person's Citizenship Status.
Nationality_Reference_WID String Contains a unique identifier for an instance of an object.
Nationality_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Nationality_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Nationality_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
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.
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.
Personnel_File_Agency String Personnel File Agency is used in China to indicate where persons have their personnel file stored.
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.
Last_Medical_Exam_Date Date Date of person's most recent Medical Examination.
Last_Medical_Exam_Valid_To Date Expiration date of person's most recent Medical Examination.
Medical_Exam_Notes String Notes for the person's most recent Medical Examination.
Uses_Tobacco Bool True if the person uses tobacco. To update a person's Tobacco Use, use the Put Worker Wellness Data web service.
Filename String Name of file uploaded
File String Data of file uploaded

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