Επεξεργασία

Κοινή χρήση μέσω


Workday attribute reference for Microsoft Entra ID

This section provides a list of attributes that you can fetch from Workday using XPATH queries. Based on the Workday Web Services API version, you plan to use, refer to the appropriate section.

XPATH values for Workday Web Services (WWS) API v21.1

The table below captures the list of Workday attributes and corresponding XPATH expressions that are shipped out of the box with the Workday inbound provisioning app connector. These XPATH values are used if no version information is specified in the connection URL or if the version is set to v21.1.

Screenshot of Workday no version info

# Workday Attribute Name Workday XPATH API expression
1 Active wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Active/text()
2 AddressLine2Data wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_2']/text()
3 AddressLine3Data wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_3']/text()
4 AddressLine4Data wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_4']/text()
5 AddressLine5Data wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_5']/text()
6 AddressLine6Data wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_6']/text()
7 AddressLine7Data wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_7']/text()
8 AddressLine8Data wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_8']/text()
9 AddressLine9Data wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_9']/text()
10 AddressLineData wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data/text()
11 BusinessTitle wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Title/text()
12 Company wd:Worker/wd:Worker_Data/wd:Organization_Data/wd:Worker_Organization_Data[translate(string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='COMPANY']/wd:Organization_Reference/@wd:Descriptor
13 ContingentWorkerID wd:Worker/wd:Worker_Reference/wd:ID[@wd:type='Contingent_Worker_ID']/text()
14 CountryReference wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Reference/wd:ID[@wd:type='ISO_3166-1_Alpha-3_Code']/text()
15 CountryReferenceFriendly wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Reference/@wd:Descriptor
16 CountryReferenceNumeric wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Reference/wd:ID[@wd:type='ISO_3166-1_Numeric-3_Code']/text()
17 CountryReferenceTwoLetter wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Reference/wd:ID[@wd:type='ISO_3166-1_Alpha-2_Code']/text()
18 CountryRegionReference wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Region_Reference/@wd:Descriptor
19 EmailAddress wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Email_Address_Data[translate(string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='WORK']/wd:Email_Address/text()
20 EmployeeID wd:Worker/wd:Worker_Reference/wd:ID[@wd:type='Employee_ID']/text()
21 FacilityLocation wd:Worker/wd:Worker_Data/wd:Organization_Data/wd:Worker_Organization_Data[translate(string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='FACILITY']/wd:Organization_Reference/@wd:Descriptor
22 Fax wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[translate(string(wd:Phone_Device_Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='FAX' and translate(string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='WORK']/@wd:Formatted_Phone
23 FirstName wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Name_Data/wd:Name_Detail_Data/wd:First_Name/text()
24 JobClassificationID wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Job_Classification_Summary_Data/wd:Job_Classification_Reference/wd:ID[@wd:type='Job_Classification_Reference_ID']/text()
25 JobFamilyID wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Job_Profile_Summary_Data/wd:Job_Family_Reference/wd:ID[@wd:type='Job_Family_ID']/text()
26 LastName wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Name_Data/wd:Name_Detail_Data/wd:Last_Name/text()
27 LeaveAbsenceType wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Leave_Status_Data[wd:On_Leave='1']/wd:Leave_of_Absence_Type_Reference/wd:ID[@wd:type='Leave_of_Absence_Type_ID']/text()
28 LocalReference wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Local_Reference/wd:ID[@wd:type='Locale_ID']/text()
29 LocationIdentifier wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Location_Reference/wd:ID[@wd:type='Location_ID']/text()
30 ManagerReference wd:Worker/wd:Worker_Data/wd:Management_Chain_Data/wd:Worker_Supervisory_Management_Chain_Data[position()=1]/wd:Management_Chain_Data[last()=position()]/wd:Manager_Reference/wd:ID[@wd:type='WID']/text()
31 MiddleName wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Name_Data/wd:Name_Detail_Data/wd:Middle_Name/text()
32 Mobile wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[translate(string(wd:Phone_Device_Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='MOBILE' and translate(string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='WORK']/@wd:Formatted_Phone
33 Municipality wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Municipality/text()
34 PositionID wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Position_ID/text()
35 PositionTitle wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Position_Title/text()
36 PostalCode wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Postal_Code/text()
37 PreferredFirstName wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:First_Name/text()
38 PreferredLastName wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:Last_Name/text()
39 PreferredMiddleName wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:Middle_Name/text()
40 PreferredNameData wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/@wd:Formatted_Name
41 PrimaryWorkTelephone wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[wd:Usage_Data/wd:Type_Data/@wd:Primary='1' and translate(string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='WORK']/@wd:Formatted_Phone
42 StatusAcademisTenureDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Academic_Tenure_Date/text()
43 StatusActiveStatusDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Active_Status_Date/text()
44 StatusBenefitsServiceDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Benefits_Service_Date/text()
45 StatusCompanyServiceDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Company_Service_Date/text()
46 StatusContinuousFirstDayOfWork wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:First_Day_of_Work/text()
47 StatusContinuousServiceDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Continuous_Service_Date/text()
48 StatusDateEnteredWorkforce wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Date_Entered_Workforce/text()
49 StatusDaysUnemployed wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Days_Unemployed/text()
50 StatusEndEmploymentDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:End_Employment_Date/text()
51 StatusExpectedRetirementDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Expected_Retirement_Date/text()
52 StatusHireDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Hire_Date/text()
53 StatusMonthsContinuousPriorEmployment wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Months_Continuous_Prior_Employment/text()
54 StatusNotEligibleForHire wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Not_Eligible_For_Hire/text()
55 StatusNotEligibleForRehire wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Not_Eligible_for_Rehire/text()
56 StatusOriginalHireDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Original_Hire_Date/text()
57 StatusProbationEndDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Probation_End_Date/text()
58 StatusProbationStartDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Probation_Start_Date/text()
59 StatusRegrettableTermination wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Regrettable_Termination/text()
60 StatusRehire wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Rehire/text()
61 StatusResignationDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Resignation_Date/text()
62 StatusRetired wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Retired/text()
63 StatusRetirementDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Retirement_Date/text()
64 StatusRetirementEligibilityDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Retirement_Eligibility_Date/text()
65 StatusSeniorityDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Seniority_Date/text()
66 StatusSeveranceDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Severance_Date/text()
67 StatusTerminated wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Terminated/text()
68 StatusTerminationDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Termination_Date/text()
69 StatusTerminationInvoluntary wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Termination_Involuntary/text()
70 StatusTerminationLastDayOfWork wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Termination_Last_Day_of_Work/text()
71 StatusTimeOffServiceDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Time_Off_Service_Date/text()
72 StatusVestingDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Vesting_Date/text()
73 SupervisoryOrganization wd:Worker/wd:Worker_Data/wd:Organization_Data/wd:Worker_Organization_Data/wd:Organization_Data[translate(string(wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='SUPERVISORY']/wd:Organization_Name/text()
74 Telephone wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[translate(string(wd:Phone_Device_Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='TELEPHONE' and translate(string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='WORK']/@wd:Formatted_Phone
75 TransactionLogData wd:Worker/wd:Worker_Data/wd:Transaction_Log_Entry_Data/wd:Transaction_Log_Entry
76 UserID wd:Worker/wd:Worker_Data/wd:User_ID/text()
77 WID wd:Worker/wd:Worker_Reference/wd:ID[@wd:type='WID']/text()
78 WorkerID wd:Worker/wd:Worker_Data/wd:Worker_ID/text()
79 WorkerType wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Worker_Type_Reference/@wd:Descriptor
80 WorkSpaceReference wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Work_Space__Reference/@wd:Descriptor

XPATH values for Workday Web Services (WWS) API v30+

If you are using WWS API v30.0 or above in the connection URL as shown below:

Screenshot of Workday version info

...then before turning on the provisioning job, please update the XPATH API expressions under Attribute Mapping -> Advanced Options -> Edit attribute list for Workday to use the values listed in the table.

To configure additional XPATHs, refer to the section Tutorial: Managing your configuration.

# Workday Attribute Name Workday XPATH API expression
1 Active wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Active/text()
2 AddressLine2Data wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_2']/text()
3 AddressLine3Data wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_3']/text()
4 AddressLine4Data wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_4']/text()
5 AddressLine5Data wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_5']/text()
6 AddressLine6Data wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_6']/text()
7 AddressLine7Data wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_7']/text()
8 AddressLine8Data wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_8']/text()
9 AddressLine9Data wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data[@wd:Type='ADDRESS_LINE_9']/text()
10 AddressLineData wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Address_Line_Data/text()
11 BusinessTitle wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Title/text()
12 Company wd:Worker/wd:Worker_Data/wd:Organization_Data/wd:Worker_Organization_Data[translate(string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='COMPANY']/wd:Organization_Data/wd:Organization_Name/text()
13 ContingentWorkerID wd:Worker/wd:Worker_Reference/wd:ID[@wd:type='Contingent_Worker_ID']/text()
14 CountryReference wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Reference/wd:ID[@wd:type='ISO_3166-1_Alpha-3_Code']/text()
15 CountryReferenceFriendly wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Reference/@wd:Descriptor
16 CountryReferenceNumeric wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Reference/wd:ID[@wd:type='ISO_3166-1_Numeric-3_Code']/text()
17 CountryReferenceTwoLetter wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Reference/wd:ID[@wd:type='ISO_3166-1_Alpha-2_Code']/text()
18 CountryRegionReference wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Country_Region_Descriptor/text()
19 EmailAddress wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Email_Address_Data[wd:Usage_Data/@wd:Public='1' and string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='WORK']/wd:Email_Address/text()
20 EmployeeID wd:Worker/wd:Worker_Reference/wd:ID[@wd:type='Employee_ID']/text()
21 FacilityLocation wd:Worker/wd:Worker_Data/wd:Organization_Data/wd:Worker_Organization_Data/wd:Organization_Data[translate(string(wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='LOCATION_HIERARCHY']/wd:Organization_Name/text()
22 Fax wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[wd:Usage_Data/@wd:Public='1' and string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='WORK' and string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])='Fax']/@wd:Workday_Traditional_Formatted_Phone
23 FirstName wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Name_Data/wd:Name_Detail_Data/wd:First_Name/text()
24 JobClassificationID wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Job_Classification_Summary_Data/wd:Job_Classification_Reference/wd:ID[@wd:type='Job_Classification_Reference_ID']/text()
25 JobFamilyID wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Job_Profile_Summary_Data/wd:Job_Family_Reference/wd:ID[@wd:type='Job_Family_ID']/text()
26 LastName wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Name_Data/wd:Name_Detail_Data/wd:Last_Name/text()
27 LeaveAbsenceType wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Leave_Status_Data[wd:On_Leave='1']/wd:Leave_of_Absence_Type_Reference/wd:ID[@wd:type='Leave_of_Absence_Type_ID']/text()
28 LocalReference wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Local_Reference/wd:ID[@wd:type='Locale_ID']/text()
29 LocationIdentifier wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Location_Reference/wd:ID[@wd:type='Location_ID']/text()
30 ManagerReference wd:Worker/wd:Worker_Data/wd:Management_Chain_Data/wd:Worker_Supervisory_Management_Chain_Data[position()=1]/wd:Management_Chain_Data[last()=position()]/wd:Manager_Reference/wd:ID[@wd:type='WID']/text()
31 MiddleName wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Name_Data/wd:Name_Detail_Data/wd:Middle_Name/text()
32 Mobile wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[wd:Usage_Data/@wd:Public='1' and string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='WORK' and string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])='Mobile']/@wd:Workday_Traditional_Formatted_Phone
33 Municipality wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Municipality/text()
34 PositionID wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Position_ID/text()
35 PositionTitle wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Position_Title/text()
36 PostalCode wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Postal_Code/text()
37 PreferredFirstName wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:First_Name/text()
38 PreferredLastName wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:Last_Name/text()
39 PreferredMiddleName wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:Middle_Name/text()
40 PreferredNameData wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/@wd:Formatted_Name
41 PrimaryWorkTelephone wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[wd:Usage_Data/@wd:Public='1' and string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='WORK' and string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])='Landline']/@wd:Workday_Traditional_Formatted_Phone
42 StatusAcademisTenureDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Academic_Tenure_Date/text()
43 StatusActiveStatusDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Active_Status_Date/text()
44 StatusBenefitsServiceDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Benefits_Service_Date/text()
45 StatusCompanyServiceDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Company_Service_Date/text()
46 StatusContinuousFirstDayOfWork wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:First_Day_of_Work/text()
47 StatusContinuousServiceDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Continuous_Service_Date/text()
48 StatusDateEnteredWorkforce wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Date_Entered_Workforce/text()
49 StatusDaysUnemployed wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Days_Unemployed/text()
50 StatusEndEmploymentDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:End_Employment_Date/text()
51 StatusExpectedRetirementDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Expected_Retirement_Date/text()
52 StatusHireDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Hire_Date/text()
53 StatusMonthsContinuousPriorEmployment wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Months_Continuous_Prior_Employment/text()
54 StatusNotEligibleForHire wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Not_Eligible_For_Hire/text()
55 StatusNotEligibleForRehire wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Not_Eligible_for_Rehire/text()
56 StatusOriginalHireDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Original_Hire_Date/text()
57 StatusProbationEndDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Probation_End_Date/text()
58 StatusProbationStartDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Probation_Start_Date/text()
59 StatusRegrettableTermination wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Regrettable_Termination/text()
60 StatusRehire wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Rehire/text()
61 StatusResignationDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Resignation_Date/text()
62 StatusRetired wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Retired/text()
63 StatusRetirementDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Retirement_Date/text()
64 StatusRetirementEligibilityDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Retirement_Eligibility_Date/text()
65 StatusSeniorityDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Seniority_Date/text()
66 StatusSeveranceDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Severance_Date/text()
67 StatusTerminated wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Terminated/text()
68 StatusTerminationDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Termination_Date/text()
69 StatusTerminationInvoluntary wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Termination_Involuntary/text()
70 StatusTerminationLastDayOfWork wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Termination_Last_Day_of_Work/text()
71 StatusTimeOffServiceDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Time_Off_Service_Date/text()
72 StatusVestingDate wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Vesting_Date/text()
73 SupervisoryOrganization wd:Worker/wd:Worker_Data/wd:Organization_Data/wd:Worker_Organization_Data/wd:Organization_Data[translate(string(wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='SUPERVISORY']/wd:Organization_Name/text()
74 Telephone wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[wd:Usage_Data/@wd:Public='1' and string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='WORK' and string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])='Landline']/@wd:Workday_Traditional_Formatted_Phone
75 TransactionLogData wd:Worker/wd:Worker_Data/wd:Transaction_Log_Entry_Data/wd:Transaction_Log_Entry
76 UserID wd:Worker/wd:Worker_Data/wd:User_ID/text()
77 WID wd:Worker/wd:Worker_Reference/wd:ID[@wd:type='WID']/text()
78 WorkerID wd:Worker/wd:Worker_Data/wd:Worker_ID/text()
79 WorkerType wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Worker_Type_Reference[wd:ID/@wd:type="Contingent_Worker_Type_ID" or wd:ID/@wd:type="Employee_Type_ID"]/@wd:Descriptor
80 WorkSpaceReference wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Work_Space__Reference/@wd:Descriptor

Custom XPATH values

The table below provides a list of other commonly used custom XPATH API expressions when provisioning workers from Workday to Active Directory or Microsoft Entra ID. Please test the XPATH API expressions provided here with your version of Workday referring to the instructions captured in the section Tutorial: Managing your configuration.

To add more attributes to the XPATH table for the benefit of customers implementing this integration, please leave a comment below or directly contribute to the article.

# Workday Attribute Name Workday API version Workday XPATH API expression
1 Universal ID v30.0+ wd:Worker/wd:Worker_Data/wd:Universal_ID/text()
2 User Name v30.0+ wd:Worker/wd:Worker_Data/wd:User_Account_Data/wd:User_Name/text()
3 Management Level ID v30.0+ wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Job_Profile_Summary_Data/wd:Management_Level_Reference/wd:ID[@wd:type="Management_Level_ID"]/text()
4 Hire Rescinded v30.0+ wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Hire_Rescinded/text()
5 Assigned Provisioning Group v21.1+ wd:Worker/wd:Worker_Data/wd:Account_Provisioning_Data/wd:Provisioning_Group_Assignment_Data[wd:Status='Assigned']/wd:Provisioning_Group/text()

Supported XPATH functions

Given below is the list of XPATH functions supported by Microsoft .NET XPATH library that you can use while creating your XPATH API expression.

  • name
  • last
  • position
  • string
  • substring
  • concat
  • substring-after
  • starts-with
  • string-length
  • contains
  • translate
  • normalize-space
  • substring-before
  • boolean
  • true
  • not
  • false
  • number
  • ceiling
  • sum
  • round
  • floor