本部分提供了可以使用 XPATH 查询从 Workday 中提取的属性列表。 请根据你打算使用的 Workday Web 服务 API 版本参阅相应的部分。
Workday Web 服务 (WWS) API v21.1 的 XPATH 值
下表汇总了 Workday 入站预配应用连接器附带的 Workday 属性及相应 XPATH 表达式的列表。 如果未在连接 URL 中指定版本信息,或者版本设置为 v21.1,则会使用这些 XPATH 值。
| # | 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 | 公司 | 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 | 国家参考数值 | 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() |
| 十七 | 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 | 电子邮件地址 | 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']/wd:Email_Address/text() |
| 20 | 员工编号 | 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']/wd:Organization_Reference/@wd:Descriptor |
| 22 | 传真 | 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(string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ']/@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() |
| 二十五 | 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() |
| 二十七 | 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() |
| 二十九 | 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 | 中间名 | 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:Phone_Data[translate(string(wd:Phone_Device_Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='MOBILE' and translate(string(string(wd:Usage_Data/wd:Type_Data/wd:Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='WORK']/@wd:Formatted_Phone |
| 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 | 邮政编码 | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Business_Site_Summary_Data/wd:Address_Data/wd:Postal_Code/text() |
| 37 | 首选名字 | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:First_Name/text() |
| 三十八 | 首选姓氏 | 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']/@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 | 状态ContinuousFirstDayOfWork | 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 | 状态EndEmploymentDate | 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 | 状态HireDate | 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() |
| 六十 | 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 | 状态退休日期 | 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 | 状态终止日期 | 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 | 监管机构 | 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:Phone_Data[translate(string(wd:Phone_Device_Type_Reference/@wd:Descriptor),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='TELEPHONE' and translate(string(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 | 工人类型 | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Worker_Type_Reference/@wd:描述符 |
| 80 | WorkSpaceReference | wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Position_Data/wd:Work_Space__Reference/@wd:描述符 |
Workday Web 服务 (WWS) API v30+ 的 XPATH 值
如果在连接 URL 中使用 WWS API v30.0 或更高版本,如下所示:
...在启用预配作业之前,请更新“属性映射”-“高级选项”->“编辑 Workday 的属性列表”下的“XPATH API 表达式”,以使用表中列出的值。
若要配置其他 XPATH,请参阅教程:管理配置。
| # | 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 | 公司 | 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 | 国家参考数值 | 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() |
| 十七 | 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 | 电子邮件地址 | 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 | 员工编号 | 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: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() |
| 二十五 | 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() |
| 二十七 | 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() |
| 二十九 | 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 | 中间名 | 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: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 | 自治市 | 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 | 邮政编码 | 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 | 首选名字 | wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:First_Name/text() |
| 三十八 | 首选姓氏 | 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' 和 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 | 状态ContinuousFirstDayOfWork | 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 | 状态EndEmploymentDate | 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 | 状态HireDate | 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() |
| 六十 | 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 | 状态退休日期 | 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 | 状态终止日期 | 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 | 监管机构 | 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:Phone_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: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 | 工人类型 | 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 |
自定义 XPATH 值
下表提供在将员工从 Workday 预配到 Active Directory 或 Microsoft Entra ID 时的其他常用自定义 XPATH API 表达式列表。 请参考教程:管理配置部分中的说明,在自己的 Workday 版本中测试此处提供的 XPATH API 表达式。
若要向 XPATH 表添加更多属性以使实现此集成的客户从中获益,请在下面评论或直接向本文投稿。
| # | Workday 属性名称 | Workday API 版本 | Workday XPATH API 表达式 |
|---|---|---|---|
| 1 | 通用 ID | 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 | 管理级别 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 | 已离职 | 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 表达式时使用这些函数。
- 姓名
- 最后
- 职位
- 字符串
- 子
- concat
- substring-after
- starts-with
- string-length
- 包含
- 翻译
- normalize-space
- substring-before
- 布尔
- 是
- 不
- 假
- 数字
- 天花板
- 总和
- 圆
- 地板