Tableau Connector for Workday

Build 20.0.7740

FormerWorkers

Contains the data for adding or updating a Former Worker.

Columns

Name Type References Description
Former_Worker_Reference_WID String Contains a unique identifier for an instance of an object.
Former_Worker_Reference_Former_Worker_ID String Contains a unique identifier for an instance of an object.
ID String Unique Identifier for the former worker. If not entered, one will be generated.
Former_Worker_ID String ID used in the former system. You can use this as the ID as well if it will be unique.
Worker_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Worker_Type_Reference_Worker_Type_ID String Contains a unique identifier for an instance of an object.
Last_Termination_Date Date Last Termination Date for the former worker. Required on the initial Add.
Most_Recent_Hire_Date Date Most Recent Hire Date (prior to the termination) for the former worker.
Original_Hire_Date Date Original Hire Date for the former worker. This value will be brought forward on a re-hire.
Continuous_Service_Date Date Continuous Service date for the former worker. This date will be brought forward on a re-hire.
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.
Birth_Date Date A person's birth date.
Ethnicity_Reference String Indicates the ethnicities that a person has.
Hispanic_or_Latino Bool Returns a true if the person's ethnicity is Hispanic or Latino.
Last_Termination_Reason String Reason for the Last Termination.
Manager String Last Manager of the former worker. Free-form text entry.
Cost_Center String Cost Center for the former worker. Free-form text entry.
Job_Title String Job Title for the former worker. Free-form text entry.
Job_Code String Job Profile Code for the former worker. Free-form text entry.
Job_Profile_Text String Job Profile Name for the former worker. Free-form text entry.
Job_Level String Job Level for the former worker. Free-form text entry.
Time_Type String Time Type for the former worker. Free-form text entry. Example: Full Time or Part Time.
Location String Location for the former worker. Free-form text entry.
Base_Pay Decimal Last Base Pay for the former worker.
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.
Frequency_Reference_WID String Contains a unique identifier for an instance of an object.
Frequency_Reference_Frequency_ID String Contains a unique identifier for an instance of an object.
Scheduled_Weekly_Hours Decimal Scheduled Weekly Hours for the former worker.
Eligible_for_Rehire_Reference_WID String Contains a unique identifier for an instance of an object.
Eligible_for_Rehire_Reference_Yes_No_Type_ID String Contains a unique identifier for an instance of an object.
Performance_Rating String Performance Rating for the former worker. Free-form text entry.
Rehired Bool Returns true if the former worker has a completed Hire Employee or Contract Contingent Worker business process.
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.
Worker_Reference String Returns the workers for the former worker.

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