Microsoft Entra ID 的 Workday 屬性參考

本節提供您可以使用 XPATH 查詢從 Workday 擷取的屬性清單。 根據 Workday Web Services API 版本,您打算使用,請參閱適當的章節。

Workday Web Services (WWS) API v21.1 的 XPATH 值

下表會擷取 Workday 屬性清單,以及隨附于 Workday 輸入布建應用程式連接器的現用 XPATH 運算式清單。 如果連線 URL 中未指定任何版本資訊,或版本設定為 v21.1 ,則會使用這些 XPATH 值。

Workday no version info

# Workday 屬性名稱 Workday XPATH API 運算式
1 使用中 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::描述元),'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 傳真 wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:電話_Data[translate(string(wd:電話_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_電話
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 行動裝置 wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:電話_Data[translate(string(wd:電話_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_電話
33 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:電話_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_電話
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 電話 wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:電話_Data[translate(string(wd:電話_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_電話
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

Workday Web Services (WWS) API v30+ 的 XPATH 值

如果您在連線 URL 中使用 WWS API v30.0 或更新版本,如下所示:

Workday version info

...然後在開啟布建作業之前,請在 [屬性對應 - 進階選項 - >> 編輯 Workday 的屬性清單] 底下 更新 XPATH API 運算式 ,以使用資料表中列出的值。

若要設定其他 XPATHs,請參閱教學課程:管理您的設定 一節

# Workday 屬性名稱 Workday XPATH API 運算式
1 使用中 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 傳真 wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:電話_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:電話_Device_Type_Reference/wd:ID[@wd:type='電話_Device_Type_ID']]='Fax']/@wd:Workday_Traditional_Formatted_電話
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 行動裝置 wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:電話_Data[wd:Usage_Data/@wd:Public='1' 和 string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='WORK' and string(wd:電話_Device_Type_Reference/wd:ID[@wd:type='電話_Device_Type_ID'])='Mobile']/@wd:Workday_Traditional_Formatted_電話
33 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:電話_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:電話_Device_Type_Reference/wd:ID[@wd:type='電話_Device_Type_ID'])='Landline']/@wd:Workday_Traditional_Formatted_電話
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 電話 wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:電話_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:電話_Device_Type_Reference/wd:ID[@wd:type='電話_Device_Type_ID'])='Landline']/@wd:Workday_Traditional_Formatted_電話
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」 或 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

自訂 XPATH 值

下表提供將背景工作角色從 Workday 布建到 Active Directory 或 Microsoft Entra ID 時,其他常用的自訂 XPATH API 運算式清單。 請參閱教學課程:管理設定 一節 中擷取的指示,以測試這裡提供的 XPATH API 運算式與您的 Workday 版本。

若要將更多屬性新增至 XPATH 資料表,以利於實作此整合的客戶,請在下面留下批註或直接 參與 文章。

# Workday 屬性名稱 Workday API 版本 Workday XPATH API 運算式
1 通用識別碼 v30.0+ wd:Worker/wd:Worker_Data/wd:Universal_ID/text()
2 使用者名稱 v30.0+ wd:Worker/wd:Worker_Data/wd:User_Account_Data/wd:User_Name/text()
3 管理層級識別碼 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 雇用撤銷 v30.0+ wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Hire_Rescinded/text()
5 指派的布建群組 v21.1+ wd:Worker/wd:Worker_Data/wd:Account_Provisioning_Data/wd:Provisioning_Group_Assignment_Data[wd:Status='Assigned']/wd:Provisioning_Group/text()

支援的 XPATH 函式

下面提供 Microsoft .NET XPATH 程式庫 支援的 XPATH 函式清單,您可以在建立 XPATH API 運算式時使用。

  • NAME
  • 最後一
  • position
  • string
  • substring
  • concat
  • substring-after
  • starts-with
  • string-length
  • contains
  • 翻譯
  • normalize-space
  • substring-before
  • boolean
  • true
  • not
  • false
  • 數值
  • 天花板
  • 總和
  • round
  • floor