The WorkdayHR connector allows you to connect WorkdayHR with One Identity Starling enabling you to take advantage of the features and products available with Starling Connect that complement and enhance WorkdayHR’s cloud-based human resource management services.
To configure the connector, following parameters are required:
-
Connector name
-
Tenant
-
API Version
-
Username (Refer Workday permissions needed to integrate via the Starling Connector)
- Password (Refer Workday permissions needed to integrate via the Starling Connector)
-
WorkdayHR instance URL (Cloud application's instance URL used as target URI in the payload)
-
Customer-specific configuration parameters must be configured based on the Workday HR instance.
-
OrganizationTypeID for Department
-
OrganizationTypeID for Division
-
OrganizationTypeID for Desk
-
OrganizationTypeID for CostCenter
-
OrganizationTypeID for Company
-
OrganizationTypeID for Region
-
OrganizationTypeID for Personal Assistant
-
OrganizationTypeID for Asset Class
-
OrganizationTypeID for DepartmentHead
-
OrganizationSubTypeID for Department
-
OrganizationSubTypeID for Division
-
OrganizationSubTypeID for Desk
-
OrganizationSubTypeID for CostCenter
-
OrganizationSubTypeID for Company
-
OrganizationSubTypeID for Region
-
OrganizationSubTypeID for Personal Assistant
-
OrganizationSubTypeID for Asset Class
-
OrganizationRoleID for Department Head
-
CustomIDTypeID for Date Joined Industry
-
CustomIDTypeID for Code Of Conduct
-
CustomIDTypeID for External ID
-
Certification Names
-
Additional Names Types
-
OrganizationType reference ID for Location Hierarchy
-
SAMAccount ID Type
-
Mobile Device Type ID
-
Landline Device Type ID
-
OrgTypeID for Custom Organizations
-
OrgSubTypeID for Custom Organizations
-
OrganizationTypeID for Matrix
-
OrganizationSubTypeID for Matrix
-
Future Hire Interval
-
Business Process Types
-
Retry Server Call
IMPORTANT:
- Retry Server Call is used to make a retry request to WorkdayHR target instance in-case of failures related to the instance being unreachable at a given point in time.
- By Default the value is set to false. The customer can enable it in-case such failures are encountered.
-
Increase Request Time out
IMPORTANT:The default request time out is 100 seconds, please enable this option if time out exception occurs.
-
-
Use Change Contact Information API for Update.
IMPORTANT:
-
This configuration defines which update API will be used to update the contact details including email, cell phone and business phone. When the configuration is enabled the Change_Work_Contact_Information API and Change_Home_Contact_Information API would be used to update the work and home contact information respectively.
-
By default, the configuration would be disabled and the update will use Maintain_Contact_Information API.
-
For additional information on update configurations in One Identity Manager, refer Additional configuration for update.
-
-
Field Override Integration System ID
-
OrganizationTypeID for Cost Center Hierarchy
-
OrganizationSubTypeID for Cost Center Hierarchy
-
Instance DateTime Offset (refer Configuring additional datetime offset in connectors for more details)
-
Get Minimal List of all Users
-
Get Response Logged (Enabling this flag will log the cloud target system response data and disabling will stop the logging)
-
Get Request Logged (Enabling this flag will log SCIM request and cloud target system request data and disabling will stop the logging)
Note: The data will be stored in Azure for 90 days.
-
Exclude Inactive Employees
NOTE:
- Username should be entered in the format : <username>@<tenantname>.
- The API version supported by the connector is v34.0.
- To know more about configuring the values for customer specific parameters, refer Values for customer-specific configuration parameters.
Supported objects and operations
Employees
Operation |
VERB |
---|---|
Get Employee | GET |
Get All Employees | GET |
Update Employee |
PUT |
NOTE:
- The Get Employee endpoint fetches the primary work email, primary cellphone and landline for home and work. The Update Employee endpoint sets the default value for email to type work and public to false, when the values for type and public flag are not provided. IsPrimary is always set to true.
-
Available until v3.1.
Locations
Operation |
VERB |
---|---|
Get Location | GET |
Get All Locations | GET |
CustomOrgs
Operation |
VERB |
---|---|
Get CustomOrg | GET |
Get All CustomOrgs | GET |
NOTE:
- CustomOrgs is a single endpoint that provides information on Departments, SubDivisions, Divisions, Desks, LegalEntities and CostCenters.
- To extract specific entities from CustomOrgs you must create the mappings, workflow steps and set up the filter.
- For more information, see OneIM_CloudHRSystems_Administration guide on the Support site.
JobClassifications
Operation |
VERB |
---|---|
Get JobClassification | GET |
Get All JobClassifications | GET |
JobProfiles
Operation |
VERB |
---|---|
Get JobProfile | GET |
Get All JobProfiles | GET |
FutureDatedEmployees
Operation |
VERB |
---|---|
Get FutureDatedEmployees | GET |
Get All FutureDatedEmployees | GET |
NOTE:
-
The Get All FutureDatedEmployees endpoint is dependent on the Starling UI config parameters Business process type and Future Hire Interval.
-
The FutureDatedEmployees endpoint does not support any filters.
DeltaSyncEmployees
Operation |
VERB |
---|---|
Get DeltaSyncEmployees | GET |
Get All DeltaSyncEmployees GET | GET |
NOTE: This endpoint is only for supporting the delta sync.
Positions
Operation |
VERB |
---|---|
Get Position | GET |
Get All Position | GET |
NOTE: This Endpoint requires additional permission for the API.
JobFamilies
Operation |
VERB |
---|---|
Get JobFamilies | GET |
Get All JobFamilies | GET |
JobFamilyGroups
Operation |
VERB |
---|---|
Get JobFamilyGroups | GET |
Get All JobFamilyGroups | GET |
Mappings
Endpoint Mapping
Target system objects | SCIM endpoints |
---|---|
Workers | Employees |
Locations | Locations |
Organizations | CustomOrgs |
Job Classification Groups |
JobClassifications |
Positions |
Positions |
Job Profiles |
JobProfiles |
Attributes Mapping
Different mappings associated with this connector are listed in the tables below:
SCIM parameter | WorkDayHR parameter |
---|---|
AdditionalNames.details[] |
Additional_Name_Type_ID;First_Name;Last_Name |
Addresses.country |
Worker/Worker_Data/Personal_Data/Contact_Data/Address_Data[@Defaul ted_Business_Site_Address=1]/Country_Reference/ID[@wd:type='ISO_31 66-1_Alpha-3_Code']/text() |
Addresses.countryCode2 |
wd:Worker/Worker_Data/Personal_Data/Contact_Data/Address_Data[@Defaulted_Business_Site_Address=1]/Country_Reference/ID[@wd:type='ISO_31 66-1_Alpha-2_Code']/text() |
Addresses.locality |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Addre ss_Data[@wd:Defaulted_Business_Site_Address=1]/wd:Municipality/text() |
Addresses.postalCode |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/Address_ Data[@Defaulted_Business_Site_Address=1]/Postal_Code/text() |
Addresses.region |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Addre ss_Data[@wd:Defaulted_Business_Site_Address=1]/wd:Country_Region_Descriptor/text() |
Addresses.streetAddress |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Addre ss_Data[@wd:Defaulted_Business_Site_Address=1]/@wd:Formatted_Address |
assetClass |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_AssetClass>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@wd:type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_AssetClass>']/wd:Organization_Reference/wd:ID[@wd:type='WID']/text() |
assetClassName (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_AssetClass>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@wd:type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_AssetClass>']/Organization_Data/Organization_Name/text() |
assetClassReferenceId (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_AssetClass>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@wd:type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_AssetClass>']/wd:Organization_Reference/wd:ID[@wd:type='Organization_Reference_ID']/text() |
businessUnitWID |
wd:Worker/wd:Worker_ Data/wd:Organization_Data/wd:Worker_Organization_Data/wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text()='Business_Unit'/ID [@type='WID']/text() |
Certificates.certificateDetails[] |
Certification_Name;Certification_ID;Certification_Skill_ID;Issued_Date;Expiry_Date |
codeOfConduct |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Identification_Data/wd:Custom_ID/wd:Custom_ID_Data[string(wd:ID_Type_Reference/wd:ID/@wd:type)='Custom_ID_Type_ID' and string(wd:ID_Type_Reference/wd:ID[@wd:type='Custom_ID_Type_ID']/text())='<CodeOfConductValue>']/wd:ID/text() |
company |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organiz ation_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_Company>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_Company>']/Organization_Reference/ID[@type='WID']/text() |
companyName (Available from v3.2) (Not available in LIST response) |
Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_ For_Company>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_Company>']/Organization_Data/Organization_Name/text() |
companyReferenceId (Available from v3.2) (Not available in LIST response) |
Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_Company>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_Company>']/Organization_Reference/ID[@type='Organization_Reference_ID']/text() |
costCenter |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_CostCenter>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_CostCenter>']/Organization_Reference/ID[@type='WID']/text() |
costCenterHierarchyName (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_CostCenterHierarchy>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_CostCenterHierarachy>']/Organization_Data/Organization_Name/text() |
costCenterHierarchyReferenceId (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_CostCenterHierarchy>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_CostCenterHierarachy>']/Organization_Reference/ID[@type='Organization_Reference_ID']/text() |
costCenterName (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_CostCenter>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_CostCenter>']/Organization_Data/Organization_Name/text() |
costCenterReferenceId (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_CostCenter>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_CostCenter>']/Organization_Reference/ID[@type='Organization_Reference_ID']/text() |
countryIsoCode |
NA |
countryPhoneCode |
NA |
dateJoinedIndustry |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Identification_Data/wd:Custom_ID/wd:Custom_ID_Data[string(wd:ID_Type_Reference/wd:ID/@wd:type)='Custom_ID_Type_ID' and string(wd:ID_Type_Reference/wd:ID[@wd:type='Custom_ID_Type_ID']/text())='<DateJoinedIndustryValue>']/wd:ID/text() |
dateOfBirth |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Birth_Date/text() |
daysUnemployed |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/daysUnemployed/text() |
department |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_for_Department>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_Department>']/Organization_Reference/ID[@type='WID']/text() |
departmentHeadID |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data/wd:Organization_Data[string(wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_DepartmentHead>' and string(wd:Organization_Support_Role_Data/wd:Organization_Support_Role/wd:Organization_Role_Reference/wd:ID[@wd:type='Organization_Role_ID']/text())='<OrganizationRoleID_For_DepartmentHead>' and string(wd:Organization_Support_Role_Data/wd:Organization_Support_Role/Organization_Role_Data/Assignment_From/text())='assigned']/wd:Organization_Support_Role_Data/wd:Organization_Support_Role/wd:Organization_Role_Data/Worker_Reference/ID[@wd:type='WID']/text() |
departmentHeadReferenceId (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data/wd:Organization_Data[string(wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_DepartmentHead>' and string(wd:Organization_Support_Role_Data/wd:Organization_Support_Role/wd:Organization_Role_Reference/wd:ID[@wd:type='Organization_Role_ID']/text())='<OrganizationRoleID_For_DepartmentHead>' and string(wd:Organization_Support_Role_Data/wd:Organization_Support_Role/Organization_Role_Data/Assignment_From/text())='assigned']/wd:Organization_Support_Role_Data/wd:Organization_Support_Role/wd:Organization_Role_Data/Worker_Reference/ID[@wd:type='Organization_Reference_ID']/text() |
departmentName (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_for_Department>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_Department>']/Organization_Data/Organization_Name/text() |
departmentReferenceId (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_for_Department>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_Department>']/Organization_Reference/ID[@type='Organization_Reference_ID']/text() |
desk |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_Desk>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_Desk>']/Organization_Reference/ID[@type='WID']/text() |
deskName (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_Desk>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_Desk>']/Organization_Data/Organization_Name/text() |
deskReferenceId (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_Desk>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_Desk>']/Organization_Reference/ID[@type='Organization_Reference_ID']/text() |
DisplayName |
wd:Worker/wd:Worker_Descriptor/text() |
division |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_for_Division>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_Division>']/Organization_Reference/ID[@type='WID']/text() |
divisionName (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_for_Division>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_Division>']/Organization_Data/Organization_Name/text() |
divisionReferenceId (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_for_Division>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_Division>']/Organization_Reference/ID[@type='Organization_Reference_ID']/text() |
Emails.value |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Email _Address_Data/wd:Email_Address/text() |
endDate |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:End_Date/text() |
endEmploymentDate |
wd:Worker/wd:Worker_Data/wd:Employment_Data[string(wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Worker_Type_Reference/wd:ID/@wd:type)='Employee_Type_ID']/wd:Worker_Status_Data/End_Employment_Date/text() |
estimatedLeaveEndDate |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Leave_Status_Data[wd:On_Leave='1']/wd:Estimated_Leave_End_Date/text() |
externalID |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Identification_Data/wd:Custom_ID/wd:Custom_ID_Data[string(wd:ID_Type_Reference/wd:ID/@wd:type)='Custom_ID_Type_ID' and string(wd:ID_Type_Reference/wd:ID[@wd:type='Custom_ID_Type_ID']/text())='<ExternalIDValue>']/wd:ID/text() |
externalIDDescription |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Identification_Data/wd:Custom_ID/wd:Custom_ID_Data[string(wd:ID_Type_Reference/wd:ID/@wd:type)='Custom_ID_Type_ID' and string(wd:ID_Type_Reference/wd:ID[@wd:type='Custom_ID_Type_ID']/text())='<ExternalIDValue>']/wd:Custom_Description/text() |
externalIDType |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Identification_Data/wd:Custom_ID/wd:Custom_ID_Data/wd:ID_Type_Reference[string(wd:ID/@wd:type)='Custom_ID_Type_ID' and string(wd:ID[@wd:type='Custom_ID_Type_ID']/text())='<ExternalIDValue>']/wd:ID[@wd:type='Custom_ID_Type_ID']/text() |
fullTimeEquivalentPercentage |
/wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data/wd:Position_Data/wd:Full_Time_Equivalent_Percentage/text() |
Gender |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Gender_Reference/wd:ID[@wd:type="Gender_Code"]/text() |
hireDate |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Hire_Date/text() |
hireReason |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Hire_Reason_Reference/wd:ID/[@wd:type='General_Event_Subcategory_ID']/text() |
hireRescinded |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/hireRescinded/text() |
Id |
wd:Worker/wd:Worker_Reference/wd:ID[@wd:type='WID']/text() |
isContingentWorker |
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/@w d:type='Contingent_Worker_Type_ID' |
isEmployee |
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/@w d:type='Employee_Type_ID' |
jobCategoryID (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data/wd:Position_Data/wd:Job_Profile_Summary_Data/wd:Job_Category_Reference/wd:ID[@wd:type='Job_Category_ID'] |
jobClassificationReference.id |
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='WID'] |
jobClassificationReference.referenceID |
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'] |
jobClassifications.id |
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_Group_Reference/wd:ID[@wd:type='WID'] |
jobExempt (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data/wd:Position_Data/Job_Exempt/text() |
jobFamilyID |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data/wd:Position_Data/wd:Job_Profile_Summary_Data/wd:Job_Family_Reference/wd:ID[@wd:type='Job_Family_ID']/text() |
jobProfileID |
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_Profile_Reference/wd:ID[wd:type='Job_Profile_ID']/text() |
jobProfileName |
wd:Worker/wd:Worker_Data/wd:Employment_Data/ wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/ wd:Job_Profile_Summary_Data/Job_Profile_Name/text() |
jobProfileWID |
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_Profile_ Reference/wd:ID[wd:type='WID']/text() |
jobTitle |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Business_Title/text() |
lastHierarchicalManagerWID |
wd:Worker/wd:Worker_ Data/wd:Management_Chain_Data/wd:Worker_Supervisory_Management_Chain_Data/wd:Management_Chain_Data/wd:Manager/wd:Worker_Reference/wd:ID[@wd:type='WID']/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() |
leaveEndDate |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Leave_Status_Data[wd:On_Leave='1']/wd:Leave_End_Date/text() |
leaveStartDate |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Leave_Status_Data[wd:On_Leave='1']/wd:Leave_Start_Date/text() |
localFirstName |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:Local_Name_Detail_Data/wd:First_Name/text() |
localLastName |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:Local_Name_Detail_Data/wd:Last_Name/text() |
localTerminationReasonID |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Local_Termination_Reason_Reference/wd:ID/[@wd:type='Local_Termination_Reason_ID']/text() |
locationID (Available from v3.2) |
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'] |
locationName (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data/wd:Position_Data/Business_Site_Summary_Data/Name/text() |
managementLevelID |
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() |
managerEmployeeID |
wd:Worker/wd:Worker_ Data/wd:Employment_Data/wd:Worker_ Job_Data[@wd:Primary_ Job=1]/wd:Position_Data/wd:Manager_as_ of_last_detected_manager_change_ Reference/wd:ID[@wd:type='Employee_ID']/text() |
managerId |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Manager_as_of_last_detected_manager_change_Reference/wd:ID[@wd:type='WID']/text() |
matrixName (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_Matrix>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@wd:type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_Matrix>']/Organization_Data/Organization_Name/text() |
matrixReferenceId (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_Matrix>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@wd:type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_Matrix>']/wd:Organization_Reference/wd:ID[@wd:type='Organization_Reference_ID']/text() |
Name.FamilyName |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Na me_Data/wd:Name_Detail_Data/wd:Last_Name /text() |
Name.Formatted |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Na me_Data/wd:Name_Detail_Dat/@wd:Formatted_Name |
Name.GivenName |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Legal_Na me_Data/wd:Name_Detail_Data/wd:First_Name/text() |
notReturning |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/notReturning/text() |
onLeave |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Leave_Status_Data/wd:On_Leave |
OrganizationSubTypeID for Cost Center Hierarchy |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data/wd:Position_Organizations_Data/wd:Position_Organization_Data/wd:Organization_Data[string(wd:Organization_Type_Reference/wd:ID/@type\)='Organization_Type_ID' and string(wd:Organization_Subtype_Reference/wd:ID/@type\)='Organization_Subtype_ID' and string(wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID'])/text()=’{value_for_the_UI_config_field_OrganizationSubTypeID for Cost Center Hierarchy}']/Organization_Type_Reference/wd:ID[@type='Organization_subType_ID']/text() |
OrganizationSubTypeID for Matrix |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data/wd:Position_Organizations_Data/wd:Position_Organization_Data/wd:Organization_Data[string(wd:Organization_Type_Reference/wd:ID/@type\)='Organization_Type_ID' and string(wd:Organization_Subtype_Reference/wd:ID/@type\)='Organization_Subtype_ID' and string(wd:Organization_Type_Reference/wd:ID[@type='Organization_Type_ID'])/text()='{value_for_the_UI_config_field_OrganizationTypeID for Matrix}']/Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text() |
OrganizationTypeID for Cost Center Hierarchy |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data/wd:Position_Organizations_Data/wd:Position_Organization_Data/wd:Organization_Data[string(wd:Organization_Type_Reference/wd:ID/@type\)='Organization_Type_ID' and string(wd:Organization_Subtype_Reference/wd:ID/@type\)='Organization_Subtype_ID' and string(wd:Organization_Subtype_Reference/wd:ID[@type='Organization_type_ID'])/text()=’{value_for_the_UI_config_field_OrganizationTypeID for Cost Center Hierarchy}']/Organization_Type_Reference/wd:ID[@type='Organization_Type_ID']/text() |
OrganizationTypeID for Matrix |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data/wd:Position_Organizations_Data/wd:Position_Organization_Data/wd:Organization_Data[string(wd:Organization_Type_Reference/wd:ID/@type\)='Organization_Type_ID' and string(wd:Organization_Subtype_Reference/wd:ID/@type\)='Organization_Subtype_ID' and string(wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID'])/text()='{value_for_the_UI_config_field_OrganizationSubTypeID for Matrix}']/Organization_Type_Reference/wd:ID[@type='Organization_Type_ID']/text() |
OrgSubTypeID for Custom Organizations |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data/wd:Position_Organizations_Data/wd:Position_Organization_Data/wd:Organization_Data[string(wd:Organization_Type_Reference/wd:ID/@type\)='Organization_Type_ID' and string(wd:Organization_Subtype_Reference/wd:ID/@type\)='Organization_Subtype_ID' and string(wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID'])/text()=’{value_for_the_UI_config_field_OrgSubTypeID for Custom Organizations}']/Organization_Type_Reference/wd:ID[@type='Organization_Type_ID']/text() |
OrgTypeID for Custom Organizations |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data/wd:Position_Organizations_Data/wd:Position_Organization_Data/wd:Organization_Data[string(wd:Organization_Type_Reference/wd:ID/@type\)='Organization_Type_ID' and string(wd:Organization_Subtype_Reference/wd:ID/@type\)='Organization_Subtype_ID' and string(wd:Organization_Type_Reference/wd:ID[@type='Organization_Type_ID'])/text()=’{value_for_the_UI_config_field_OrgTypeID for Custom Organizations}']/Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text() |
originalHireDate |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Orignial_Hire_Date/text( |
personalAssistantID |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_PersonalAssistant>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@wd:type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_PersonalAssistant>']/wd:Organization_Reference/wd:ID[@wd:type='WID']/text() |
personalAssistantName (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_PersonalAssistant>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@wd:type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_PersonalAssistant>']/Organization_Data/Organization_Name/text() |
personalAssistantReferenceId (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_PersonalAssistant>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@wd:type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_PersonalAssistant>']/wd:Organization_Reference/wd:ID[@wd:type='Organization_Reference_ID']/text() |
PhoneNumbers.businessPhone |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_ID/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Landline_ Device_Type_ID>]/wd:Phone_Number/text() wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data/wd:Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Home'] |
PhoneNumbers.cellPhone (available until v3.1) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_ID/wd:ID[@wd:type='Phone_Device_Type_ ID'])=<Mobile_ Device_Type_ID>]/wd:Phone_Number /text() wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data/wd:Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Home'] |
PhoneNumbersWork.businessPhone (available until v3.1) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_ID/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Landline_ Device_Type_ID>]/wd:Phone_Number/text() wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data/wd:Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Work'] |
PhoneNumbersWork.cellPhone (available until v3.1) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_ID/wd:ID[@wd:type='Phone_Device_Type_ ID'])=<Mobile_Device_Type_ID>]/wd:Phone_Number/text() wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data/wd:Usage_Data/wd:Type_Data/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Work'] |
positionID (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/ wd:Position_Reference/wd:ID[@wd:type='Position_ID'] |
positionReferenceWID |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Position_Reference/wd:ID[@wd:type='WID'] |
preferredCommunicationLanguageReference |
/wd:Worker/wd:Worker_Data/wd:User_Account_Data/wd:Preferred_Communication_Language_Reference/text() |
preferredFirstName |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:First_Name/text() |
preferredLastName |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:Last_Name/text() |
preferredLastNameSuffix |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:Suffix_Data/wd:Hereditary_Suffix_Reference/wd:Descriptor/text() |
preferredMiddleName |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Name_Data/wd:Preferred_Name_Data/wd:Name_Detail_Data/wd:Middle_Name/text() |
primaryDeviceType |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_ID/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Mobile_Device_Type_ID>]/wd:Phone_Device_Type_Reference/wd:Phone_Device_Type_ID/text() |
primaryTerminationCategoryID |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Primary_Termination_Category_Reference/wd:ID/[@wd:type='Termination_Category_ID']/text() |
primaryTerminationSubCategoryID |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Primary_Termination_Reason_Reference/wd:ID/[@wd:type='Termination_Subcategory_ID']/text() |
pronounID (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Personal_Information_Data/wd:Pronoun_Reference/wd:ID[@wd:type='Pronoun_ID'] |
region |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_Region>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@wd:type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_Region>']/wd:Organization_Reference/wd:ID[@wd:type='WID']/text() |
regionName (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_Region>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@wd:type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_Region>']/Organization_Data/Organization_Name/text() |
regionReferenceId (Available from v3.2) (Not available in LIST response) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Organizations_Data/wd:Position_Organization_Data[string(wd:Organization_Data/wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_Region>'] and string(wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@wd:type='Organization_Subtype_ID']/text())='<OrganizationSubTypeID_For_Region>']/wd:Organization_Reference/wd:ID[@wd:type='Organization_Reference_ID']/text() |
rehire |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/rehire/text() |
retired |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/Retired/text() |
returnUnknown |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/returnUnknown/text() |
samAccountName |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Identification_Data/wd:Custom_ID/wd:Custom_ID_Data[string(wd:ID_Type_Reference/wd:ID/@wd:type)='Custom_ID_Type_ID' and string(wd:ID_Type_Reference/wd:ID[@wd:type='Custom_ID_Type_ID']/text())='<SAMAccountID>']/wd:ID/text() |
startDate |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Start_Date/text() |
status |
Active (A): wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/Active/text()='1' Or Terminated (L): wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/Terminated/text()='1' |
supervisorManagementChainData~managerDescriptor (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data/wd:Position_Management_Chains_Data/wd:Position_Supervisory_Management_Chain_Data/wd:Management_Chain_Data/wd:Manager/Worker_Descriptor/text() |
supervisorManagementChainData~managerId (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data/wd:Position_Management_Chains_Data/wd:Position_Supervisory_Management_Chain_Data/wd:Management_Chain_Data/wd:Manager/wd:Worker_Reference/wd:ID[@wd:type='WID'] |
supervisorManagementChainData~organizationReferenceId (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data/wd:Position_Management_Chains_Data/wd:Position_Supervisory_Management_Chain_Data/wd:Management_Chain_Data/wd:Organization_Reference/wd:ID[@wd:type='Organization_Reference_ID'] |
supplierReferenceID (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Contract_Data/wd:Supplier_Reference/wd:ID[@wd:type='Supplier_Reference_ID'] |
terminationDate |
wd:Worker/wd:Worker_Data/wd:Employment_Data[string(wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Worker_Type_Reference/wd:ID/@wd:type)='Employee_Type_ID']/wd:Worker_Status_Data/Termination_Date/text() or wd:Worker/wd:Worker_Data/wd:Employment_Data[string(wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Worker_Type_Reference/wd:ID/@wd:type)='Contingent_Worker_Type_ID']/wd:Worker_Contract_Data/Contract_End_Date/text() |
terminationLastDayOfWork |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/Termination_Last_Day_Of_Work/text() |
title |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Position_Title/text() |
userId |
wd:Worker/wd:Worker_Data/wd:User_ID/text() |
userLanguageReference |
/wd:Worker/wd:Worker_Data/wd:User_Account_Data/wd:User_Language__Reference/text() |
UserName |
wd:Worker/wd:Worker_Data/wd:User_ID/text() |
workerId |
wd:Worker/wd:Worker_Data/wd:Worker_ID/text() |
workerJobDetails.businessTitle (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=WorkJobDetails.primaryJob]/wd:Position_Data/wd:Business_Title/text() |
workerJobDetails.positionTitle (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=WorkJobDetails.primaryJob]/wd:Position_Data/wd:Position_Title/text() |
workerJobDetails.primaryJob (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd :Primary_Job]/text() |
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[@w d:type='Employee_Type_ID' Or @wd:type='Contingent_Worker_Type_ID']/text() |
workPhoneLandline (Available until v3.1) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_ID/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Landline_ Device_Type_ID>]/wd:Phone_Number/text()wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data/wd:Usage_Data/wd:Type_Data[@wd:primary='0']/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Work'] |
workPhoneLandline~countryIsoCode (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Landline_Device_Type_ID> AND string(wd:Usage_Data/wd:Type_Data[@wd:primary='0']/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Work']/wd:Country_ISO_Code/text() |
workPhoneLandline~countryPhoneCode (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Landline_Device_Type_ID> AND string(wd:Usage_Data/wd:Type_Data[@wd:primary='0']/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Work']/wd:International_Phone_Code/text() |
workPhoneLandline~number (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Landline_Device_Type_ID> AND string(wd:Usage_Data/wd:Type_Data[@wd:primary='0']/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Work')]/@wd:E164_Formatted_Phone |
workPhoneMobile (Available until v3.1) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_ID/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Mobile_ Device_Type_ID>]/wd:Phone_Number/text()wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data/wd:Usage_Data/wd:Type_Data[@wd:primary='0']/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Work'] |
workPhoneMobile~countryIsoCode (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Mobile_Device_Type_ID> AND string(wd:Usage_Data/wd:Type_Data[@wd:primary='0']/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Work']/wd:Country_ISO_Code/text() |
workPhoneMobile~countryPhoneCode (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Mobile_ Device_Type_ID> AND string(wd:Usage_Data/wd:Type_Data[@wd:primary='0']/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Work']/wd:International_Phone_Code/text() |
workPhoneMobile~number (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Mobile_ Device_Type_ID> AND string(wd:Usage_Data/wd:Type_Data[@wd:primary='0']/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Work')]/@wd:E164_Formatted_Phone |
workPhoneMobilePrimary~countryIsoCode (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Mobile_ Device_Type_ID> AND string(wd:Usage_Data/wd:Type_Data[@wd:primary='1']/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Work']/wd:Country_ISO_Code/text() |
workPhoneMobilePrimary~countryPhoneCode (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Mobile_ Device_Type_ID> AND string(wd:Usage_Data/wd:Type_Data[@wd:primary='1']/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Work']/wd:International_Phone_Code/text() |
workPhoneMobilePrimary~number (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Mobile_ Device_Type_ID> AND string(wd:Usage_Data/wd:Type_Data[@wd:primary='1']/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Work']/@wd:E164_Formatted_Phone |
workPhonePrimary (Available until v3.1) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_ID/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Any_ Device_Type_ID>]/wd:Phone_Number/text()wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data/wd:Usage_Data/wd:Type_Data[@wd:primary='1']/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Work'] |
workPhonePrimary~countryIsoCode (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Landline_ Device_Type_ID> AND string(wd:Usage_Data/wd:Type_Data[@wd:primary='1']/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Work']/wd:Country_ISO_Code/text() |
workPhonePrimary~countryPhoneCode (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Landline_ Device_Type_ID> AND string(wd:Usage_Data/wd:Type_Data[@wd:primary='1']/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Work']/wd:International_Phone_Code/text() |
workPhonePrimary~number (Available from v3.2) |
wd:Worker/wd:Worker_Data/wd:Personal_Data/wd:Contact_Data/wd:Phone_Data[string(wd:Phone_Device_Type_Reference/wd:ID[@wd:type='Phone_Device_Type_ID'])=<Landline_ Device_Type_ID> AND string(wd:Usage_Data/wd:Type_Data[@wd:primary='1']/wd:Type_Reference/wd:ID[@wd:type='Communication_Usage_Type_ID'])='Work')]/@wd:E164_Formatted_Phone |
SCIM Parameter |
WorkDayHR Parameter |
---|---|
managerID |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data/wd:Position_Organizations_Data/wd:Position_Organization_Data/wd:Organization_Data/wd:Organization_Support_Role_Data/wd:Organization_Support_Role/wd:Organization_Role_Data/wd:Worker_Reference/wd:ID[@wd:type='WID'] |
continuousServiceDate |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Status_Data/wd:Continuous_Service_Date/text() |
rehireDate |
wd:Worker/wd:Worker_Data/wd:Transaction_Log_Entry_Data/wd:Transaction_Log_Entry/wd:Transaction_Log_Data/wd:Transaction_Effective_Moment/text() WHERE wd:Worker/wd:Worker_Data/wd:Transaction_Log_Entry_Data/wd:Transaction_Log_Entry/wd:Transaction_Log_Data/wd:Transaction_Log_Type_Reference/wd:ID [@wd:type="Business_Process_Type"]/text() = Hire Employee |
businessProcessTransactionLogs[]~businessProcessType [Mapped only if the corresponding Business Process Type is configured in the Starling Connect portal] |
wd:Worker/wd:Worker_Data/wd:Transaction_Log_Entry_Data/wd:Transaction_Log_Entry/wd:Transaction_Log_Data/wd:Transaction_Log_Type_Reference/wd:ID [@wd:type="Business_Process_Type"]/text() |
businessProcessTransactionLogs[]~businessProcessEffectiveMoment [Mapped only if the corresponding Business Process Type is configured in the Starling Connect portal] |
wd:Worker/wd:Worker_Data/wd:Transaction_Log_Entry_Data/wd:Transaction_Log_Entry/wd:Transaction_Log_Data/wd:Transaction_Effective_Moment/text() |
businessProcessTransactionLogs[]~businessProcessXML [Mapped only if the corresponding Business Process Type is configured in the Starling Connect portal] |
wd:Worker/wd:Worker_Data/wd:Transaction_Log_Entry_Data/wd:Transaction_Log_Entry/xml() |
NOTE:
- All the other SCIM Parameter mapping is same as the Employees Mapping.
NOTE:
- All the SCIM Parameter mapping is same as the Employees Mapping.
SCIM Parameter |
WorkDayHR Parameter |
---|---|
Addresses.country |
wd:Location/wd:Location_Data/wd:Contact_Data/wd:Address_Data/wd:Country_Refer ence/ID[@type='ISO_3166-1_Alpha-3_Code']/text() |
Addresses.countryCode2 |
wd:Location/wd:Location_Data/wd:Contact_Data/wd:Address_Data/wd:Country_Reference/ID[@type='ISO_3166-1_Alpha-2_Code']/text() |
Addresses.locality |
wd:Location/wd:Location_Data/wd:Contact_Data/wd:Address_Data/wd:Municipality/ text() |
Addresses.postalCode |
wd:Location/wd:Location_Data/wd:Contact_Data/wd:Address_Data/wd:Postal_Code/t ext() |
Addresses.region |
wd:Location/wd:Location_Data/wd:Contact_Data/wd:Address_Data/wd:Country_Region_Descriptor/text() |
Addresses.streetAddress |
wd:Location/wd:Location_Data/wd:Contact_Data/wd:Address_Data/@Formatted_Addre ss |
addressLineData.addressData |
wd:Location/wd:Location_Data/wd:Contact_Data/wd:Address_Data/wd:Address_Line_Data/text() |
countryRegionCode2 |
wd:Location/wd:Location_Data/wd:Contact_Data/wd:Address_Data/wd:Country_Region_Reference/wd:ID[@wd:type='ISO_3166-2_Code'] |
countryRegionCode |
wd:Location/wd:Location_Data/wd:Contact_Data/wd:Address_Data/wd:Country_Region_Reference/wd:ID[@wd:type='ISO_3166-2_Country-Region_Code'] |
citySubDivisionData.citySubdivisionData |
wd:Location/wd:Location_Data/wd:Contact_Data/wd:Address_Data/wd:Submunicipality_Data/text() |
Emails.value |
wd:Location/wd:Location_Data/wd:Contact_Data/wd:Email_Address_Data/wd:Email_A ddress/text() |
fax |
wd:Location/wd:Location_Data/wd:Contact_Data/wd:Phone_Data[string(Phone_Devic e_Type_Reference/ID[@wd:type='Phone_Device_Type_ID']/text())='Fax']/wd:Phone_ Number/text() |
Id |
wd:Location/Location_Reference/ID[@type='WID']/text() |
locationID |
wd:Location/wd:Location_Data/wd:Location_ID/text() |
name |
wd:Location/wd:Location_Data/wd:Location_Name/text() |
regionSubDivisionData.regionSubdivisionData |
wd:Location/wd:Location_Data/wd:Contact_Data/wd:Address_Data/wd:Subregion_Data/text() |
status |
wd:Location/wd:Location_Data/wd:Inactive/text() |
telephone |
wd:Location/wd:Location_Data/wd:Contact_Data/wd:Phone_Data[string(Phone_Devic e_Type_Reference/ID[@wd:type='Phone_Device_Type_ID']/text())='Landline']/wd:P hone_Number/text() |
SCIM Parameter |
WorkDayHR Parameter |
---|---|
companyReferenceID |
wd:Organization/wd:Organization_Data/wd:Supervisory_Data/wd:Organization_Assignments_Data[string(wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_Company>']/Organization_Reference/ID[@wd:type='WID']/text() |
costCenterID |
wd:Organization/wd:Organization_Data/wd:Supervisory_Data/wd:Organization_Assignments_Data[string(wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_CostCenter>']/Organization_Reference/ID[@wd:type='WID']/text() |
Id |
wd:Organization/Organization_Reference/ID[@type='WID']/text() |
lastModifiedOn |
wd:Organization/wd:Organization_Data/Last_Updated_DateTime/text() |
locationID |
wd:Organization/wd:Organization_Data/Supervisory_Data/Location_Reference/ID[@type='WID']/text() |
managerReferenceID |
wd:Organization/wd:Organization_Data/wd:Manager_Reference/wd:ID[@wd:type='WID']/text() |
Meta.LastModified |
wd:Organization/wd:Organization_Data/Last_Updated_DateTime/text() |
name |
wd:Organization/wd:Organization_Data/wd:Name/text() |
organizationCode |
wd:Organization/wd:Organization_Data/wd:Organization_Code/text() |
organizationOwnerID |
wd:Organization/wd:Organization_Data/Organization_Owner_Reference/ID[@type='WID']/text() |
organizationTypeReferenceID |
wd:Organization/wd:Organization_Data/Organization_Type_Reference/ID[@type='Organization_Type_ID']/text() |
referenceID |
wd:Organization/wd:Organization_Data/wd:Reference_ID/text() |
regionReferenceID |
wd:Organization/wd:Organization_Data/wd:Supervisory_Data/wd:Organization_Assignments_Data[string(wd:Organization_Type_Reference/wd:ID[@wd:type='Organization_Type_ID']/text())='<OrganizationTypeID_For_Region>']/Organization_Reference/ID[@wd:type='WID']/text() |
status |
wd:Organization/wd:Organization_Data/wd:Inactive/text() |
type |
wd:Organization/wd:Organization_Data/wd:Organization_Subtype_Reference/wd:ID[@type='Organization_Subtype_ID']/text() |
includedInOrganizationReferenceWID |
wd:Worker/wd:Worker_Data/wd:Employment_Data/wd:Worker_Job_Data[@wd:Primary_Job=1]/wd:Position_Data/wd:Position_Reference/wd:ID[@wd:type='WID'] |
leadershipReferences~id |
wd:Organization/wd:Organization_Data/wd:Leadership_Reference/wd:ID[@type='WID']/text() |
leadershipReferences~empId |
wd:Organization/wd:Organization_Data/wd:Leadership_Reference/wd:ID[@type='Employee_ID']/text() |
SCIM Parameter |
WorkDayHR Parameter |
---|---|
groupId |
Job_Classification_Group/Job_Classification_Group_Data/ID/text() |
groupName |
Job_Classification_Group/Job_Classification_Group_Name_Data/ Job_Classification_Group_Name/text() |
Id |
Job_Classification_Group/Job_Classification_Group_Reference/ID[@type='WID']/text() |
inActive |
Job_Classification_Group/Job_Classification_Group_Data/Inactive/text() |
SCIM Parameter |
WorkDayHR Parameter |
---|---|
ID |
wd:Position/wd:Position_Reference/wd:Employment_Data/ID[@type='WID']/text() |
jobPostingTitle |
wd:Position/wd:Position_Data/wd:Position_Definition_Data/wd:Job_Posting_Title/text() |
jobDescriptionSummary |
wd:Position/wd:Position_Data/wd:Position_Definition_Data/wd:Job_Description_Summary/text() |
positionID |
wd:Position/wd:Position_Data/wd:Position_Definition_Data/wd:Position_ID/text() |
SCIM Parameter |
WorkDayHR Parameter |
---|---|
ID |
wd:Job_Profile/Job_Profile_Reference/ID [@type='WID']/text() |
jobCode |
wd:Job_Profile/Job_Profile_Data/Job_Code/text() |
jobTitle |
wd:Job_Profile/Job_Profile_Data/Job_Profile_Basic_Data/Job_Title/text() |
inActive |
true - wd:Job_Profile/Job_Profile_Data/Job_Profile_Basic_Data/Inactive/text() = '1' or false - wd:Job_Profile/Job_Profile_Data/Job_Profile_Basic_Data/Inactive/text() = '0' |
includeJobCodeInName |
true - wd:Job_Profile/Job_Profile_Data/Job_Profile_Basic_Data/Include_Job_Code_in_Name/text() = '1' or false - wd:Job_Profile/Job_Profile_Data/Job_Profile_Basic_Data/Include_Job_Code_in_Name/text() = '0' |
criticalJob |
true - wd:Job_Profile/Job_Profile_Data/Job_Profile_Basic_Data/Critical_Job/text() = '1' or false - wd:Job_Profile/Job_Profile_Data/Job_Profile_Basic_Data/Critical_Job/text() = '0' |
SCIM Parameter |
WorkDayHR Parameter |
---|---|
ID |
wd:Job_Family/Job_Family_Reference/ID[@type='WID']/text() |
jobFamilyId |
wd:Job_Family/Job_Family_Data/ID/text() |
name |
wd:Job_Family/Job_Family_Data/Name/text() |
inActive |
true - wd:Job_Family/Job_Family_Data/Inactive/text() = '1' or false - wd:Job_Family/Job_Family_Data/Inactive/text() = '0' |
summary |
wd:Job_Family/Job_Family_Data/Summary/text() |
jobProfileData[].id |
wd:Job_Family/Job_Family_Data/Job_Profile_Data/Job_Profile_Reference/ID[@type='WID']/text() |
jobProfileData[].jobProfileId |
wd:Job_Family/Job_Family_Data/Job_Profile_Data/Job_Profile_Reference/ID[@type='Job_Profile_ID']/text() |
SCIM Parameter |
WorkDayHR Parameter |
---|---|
ID |
wd:Job_Family_Group/Job_Family_Group_Reference/ID[@type='WID']/text() |
jobFamilyGroupId |
wd:Job_Family_Group/Job_Family_Group_Data/ID/text() |
name |
wd:Job_Family_Group/Job_Family_Group_Data/Name/text() |
inActive |
true - wd:Job_Family_Group/Job_Family_Group_Data/Inactive/text() = '1' or false - wd:Job_Family_Group/Job_Family_Group_Data/Inactive/text() = '0' |
summary |
wd:Job_Family_Group/Job_Family_Group_Data/Summary/text() |
jobFamilyData[].id |
wd:Job_Family_Group/Job_Family_Group_Data/Job_Family_Data/Job_Family_Reference/ID[@type='WID']/text() |
jobFamilyData[].jobFamilyId |
wd:Job_Family_Group/Job_Family_Group_Data/Job_Family_Data/Job_Family_Reference/ID[@type='Job_Family_ID']/text() |
Filter Resource
Workday Employee resource response does not provide 'meta.lastModified' in the response. This makes impossible to get the revision filtered employees list. The full employee list without revision filters will be too slow for frequent synchronizations. As a work-around for this the Workday HR connector has been modified to support filtering only on the Employees endpoint. Even though the intension to support filtering is only on 'meta.lastModified', the connector has been modified to support some more attributes for filtering. Below are the details on the supported attributes and operations on filter functionality on the Employee resource on the SCIM connector.
NOTE:
WorkdayHR supports two kind of updates -
-
Manual update- when an employee record is updated manually on workdayHR.
-
effective update - when an employee is updated manually with an effective date and workdayHR updates the record as the effective date is reached
A new endpoint DeltaSyncEmployees has been added to support these two updates using combination of two filters - meta.lastModified and manualupdate
Supported attributes for Filtering Employee Resource
Attribute | Supported Operations |
addresses.country | eq (equal to) |
assetClass | eq |
company | eq |
costCenter | eq |
department | eq |
desk | eq |
division | eq |
id |
eq |
futurehire |
eq |
meta.lastModified |
gt (greater than) ge (greater than or equal to) |
personalAssistantID |
eq |
region |
eq |
status |
eq |
manualUpdate |
eq |
workerId |
eq |
contingentWorkerId |
eq |
NOTE: As the WorkDayHR API supports only filtering of Active Employees, Status filter has been implemented to support only Active employees. Filtering of inactive employees is not supported. Valid values for Status filter is 'A' for active Employees.
NOTE: manualUpdate is only applicable for DeltaSyncEmployees endpoint.
NOTE: workerId and contingentWorkerId filters are supported by only List employees and Future Dated Employees endpoints. These filters are supported all versions of the connector.
More information about Filtering Resource
-
As the Workday API supports only AND conditions in the request filter criteria, the connector has been implemented to support only AND in SCIM filter condition.
-
In the connector filter functionality, any invalid or non-supported filter criteria will be ignored in the filter. If no valid criteria found, then normal LIST employees will be carried out.
-
Due to timezone differences there is a considerable difference in the Workday returned date time data and the local date time date. Since the Workday documentation do not mention on the supported timezone, as a work around, 1 day is subtracted from current date time while implementing the filter in the Workday HR connector for meta.lastModified. Similarly 1 day is subtracted from the meta.lastModified value in the filter criteria while making a request to the target system.
-
The filter functionality searches generously for the filter condition and values instead of performing a greedy and strict match. For example: the meta.lastModified with below are some of the valid formats:
filter=meta.lastModified gt xxxx-xx-xxTxx:xx:xx
filter=meta.lastModified gt xxxx-xx-xx xx:xx:xx
filter=meta.lastModified gt xxxx-xx-xxTxx:xx:xx.xxx
filter=meta.lastModified gt "xxxx-xx-xxTxx:xx:xx"
filter=meta.lastModified gt xxxx-xx-xx xx:xx:xxZ
filter=meta.lastModified gt xxxx-xx-xxTxx:xx:xx.xxxZ
filter=meta.lastModified gt 'xxxx-xx-xxTxx:xx:xx'
- The Filter expressions will only accept OR with ID attributes and individual filter expressions on various attributes are combined using AND only.
- Only OR is supported within individual id filter expressions
- All OR expressions of ID should be placed together, out-of-order OR expressions are considered invalid. The collection of OR expressions on IDs can be at the start or at the end.
For more information about Filter Resource, see Workday documentation of filtering on Workers endpoints.
One IM Configuration for Delta Synchronization
Modifying the FullProjection process
-
In Designer, locate the 'DPR_DPRProjectionStartInfo_Run_Synchronization' process click to edit it. Under 'Pre-script for generating' add the script as mentioned below:
'Starling Delta Sync Handling (search sync project variables with their names staring with dprRevisionDate and put the corresponding revision data value in)
Dim f = session.SqlFormatter
Dim nameSchema as String
Dim nameVariable as String
Dim variableValue as String
values("OverrideVariables") = ""
'search project variables dprRevisionDate*
Dim qVariables = Query _
.From("DPRSystemVariable") _
.Orderby("UID_DPRSystemVariable") _
.Where( f.AndRelation( _
f.Comparison("Name", "dprRevisionDate%", ValType.String, CompareOperator.Like, FormatterOptions.IgnoreCase), _
f.UidComparison("UID_DPRSystemVariableSet", $UID_DPRSystemVariableSet$, CompareOperator.Equal))) _
.Select("Name")
Dim colVariables = Session.Source.GetCollection(qVariables)
If colVariables.Count > 0 then
'fetching revision data from last synchronization of that sync project configuration
Dim qRevStore = Query _
.From("DPRRevisionStore") _
.Where( f.AndRelation( _
f.UidComparison("UID_DPRProjectionConfig", $UID_DPRProjectionConfig$, CompareOperator.Equal), _
f.UidComparison("UID_DPRSystemVariableSet", $UID_DPRSystemVariableSet$, CompareOperator.Equal))) _
.Select("Value", "SchemaTypeKey")
Dim colRevStore = Session.Source.GetCollection(qRevStore)
Dim dictRevStore = new System.Collections.Generic.Dictionary(of String, String)()
For Each elemRevStore As IEntity In colRevStore
nameSchema = elemRevStore.GetValue("SchemaTypeKey").String 'Schema[FTP#C04A6567-9EAE-4121-973E-AF1EE514D728].Type[Employees]
If string.IsNullOrEmpty(nameSchema) OrElse not nameSchema.Contains(".") then
Continue For
End If
nameSchema = nameSchema.Split("."c)(1)
dictRevStore.Add(nameSchema, elemRevStore.GetValue("Value").String)
Next
'put the revision date into the variables if available, else provide the revision data as 1900-01-01
Dim lstVariables = new System.Collections.Generic.List(of String)()
For Each elemVariable As IEntity In colVariables
nameVariable = elemVariable.GetValue("Name").String 'e.g. dprRevisionDateEmployees
nameSchema = string.Format("Type[{0}]", nameVariable.Trim().Substring(15)) 'e.g. Type[Employees]
If dictRevStore.TryGetValue(nameSchema, variableValue) then
values(nameVariable) = variableValue.Replace(" ", "T")
Else
values(nameVariable) = "1900-01-01"
End If
lstVariables.Add(nameVariable)
Next
values("OverrideVariables") = string.Join(";", lstVariables.ToArray())
End If
-
Under 'Run Synchronization' select 'Parameters' tab and provide the below script under 'OverrideVariables'.
If not String.IsNullOrEmpty(values("OverrideVariables").ToString()) then
Imports System.Data.Common
Dim sb as DbConnectionStringBuilder = new DbConnectionStringBuilder(false)
For each varName as String in values("OverrideVariables").ToString().Split(";"c)
sb.Add(varName, values(varName).ToString())
Next
Value = sb.ConnectionString
End if
-
'Commit to database' and then 'Compile database'.
Modifying the synchronization project
-
Make sure that the local cache is turned off for the Synchronization project.
NOTE: This is applicable for employees and DeltaSyncEmployees endpoint.
-
Select the SCIM synchronization project and select 'Variables' to add a new variable similar to 'dprRevisionDateEmployees' (the variable name should be dprRevisionDate<schema name>).
-
Create a new 'Schema Class' from the supported endpoints in the 'Target system'. For example: "Employees for Delta Sync".
-
On the Schema Class set the System Filter: meta.LastModified gt $dprRevisionDate<Schema name>$. Under 'Select Objects' tab, use 'meta_lastModified' as the attribute, '>' as the operator and $dprRevisionDate<Schema name>$ as the text field value.
NOTE:
To get the all the updates from DeltaSyncEmployee Endpoint, please follow the additional step
-
Create two new 'Schema Class' from Employee in the 'Target system'. For example:
"Manual Update Employees for Delta Sync" & "Effective Update Employees for Delta Sync"
-
On the respective Schema Classes set the System Filter: meta.LastModified gt
$dprRevisionDateDeltaSyncEmployees$ and manualUpdate eq 'true' for manualUpdate, meta.LastModified gt
$dprRevisionDateDeltaSyncEmployees$ and manualUpdate eq 'false' for effective update.
Under 'Select Objects' tab, use 'meta_lastModified' as the attribute, '>' as the operator and $dprRevisionDateDeltaSyncEmployees$ as the text field value.
-
-
As required, other supported attributes also can be added under filters.
-
Create a new Mapping using the new Schema Class dialog box.
-
Create a new Workflow using the new mapping. This workflow updates the existing records based on the revision filter.
-
To improve the syncs performance, remove the update steps from the existing default Initial sync Work Flow.
-
Create a new Startup Config using the new workflow. Select 'One Identity Manager' for the 'Synchronization in direction'. Use 'default variable set' for the 'Variable Set'.
-
Use hotfix #33601 on One Identity Manager version 8.1.2 and 8.1.4.
Connector limitations
- It supports GET operation.
-
Currently, Update functionality is available only for the following attributes of the Employees object:
- Work phone and mobile numbers
- username
-
SAMAccount ID (Custom ID for SAMAccount Name)
NOTE:Update of phone information supports work and home based on the attribute being updated, phoneNumbersWork and phoneNumbers respectively until v2.0 and only work phone and mobile numbers are updatable in from v3.0 onwards.
-
CREATE and DELETE operations are not supported by any object.
-
Any changes to the updatable employee attributes for contact information listed above will be performed effective immediately (EffectiveDate = today). Updates will only be successful if no future dated event is pending, that may conflict with the attribute update.
-
There is no meta.LastModified attribute available for Employees and Location endpoint. Delta sync could be performed by following the steps in One IM Configuration for Delta Synchronization.
-
When using futurehire filter, delta sync cannot be used as it will affect the future hire results returned from WorkdayHR API.
-
The target system WorkdayHR API supports:-
-
OR operation only within the same filter type.
-
AND operation only across different filter type.
For example, costCenter and region belongs to Organization type. WorkdayHR API will perform OR operation and return employees that belong to either of the Organization. Conversely, in case of costCenter and country, WorkdayHR will perform AND operation and return employees that belong to Costcenter and Country.
-
NOTE:The Get Employee endpoint fetches the primary work email, primary cellphone and landline for home and work. The Update Employee endpoint sets the default value for email to type work and public to false, when the values for type and public flag are not provided. IsPrimary is always set to true (until version 2.0).
-
Due to impact in the performance, the below listed attributes are not returned in the LIST response of Employees and FutureDatedEmployees (in v3.2). These attributes are available in GET by Id response.
- departmentReferenceId
- divisionReferenceId
- deskReferenceId
- costCenterReferenceId
- companyReferenceId
- regionReferenceId
- personalAssistantReferenceId
- assetClassReferenceId
- departmentHeadReferenceId
- costCenterHierarchyReferenceId
- matrixReferenceId
- customOrgReferences[].OrgReferenceID
- departmentName
- divisionName
- deskName
- costCenterName
- companyName
- regionName
- personalAssistantName
- assetClassName
- costCenterHierarchyName
- matrixName
- customOrgReferences[].organizationName
Connector versions and features
The following subsections describe the different connector version(s) and features available with them.
Features available exclusively in Workday HR v.1.0
Following are the features that are available exclusively in Workday HRv.1.0:
- From v1.0 onwards, the maximum page size (count ) supported is 999 for all the endpoints LIST request.
- If count is not provided in the request, then a default value of 500 is considered.
Features available exclusively in Workday HR v.2.0
Following are the features that are available exclusively in Workday HRv.2.0:
-
The Employee endpoint is enhanced to support the PATCH operation to update the Employee details.
NOTE:The supported attributes for Employee PATCH operation will be same as the UPDATE.
-
The Employee endpoint is enhanced to support the DELETE functionality for following attributes:
-
SamAccountName
-
Email
-
PhoneNumbers
NOTE:Set the supported attributes value to blank in One Identity Manager to delete them from target system.
-
Features available exclusively in Workday HR v.3.0
Following are the features that are available exclusively in Workday HRv.3.0:
-
The Employee endpoint is enhanced to support non primary work phone numbers.
-
The Create, Update and Delete operations are supported for non primary work phone numbers along with other previously supported attributes.
NOTE: Please check the section Values for customer-specific configuration parameters for more details.
Features available exclusively in Workday HR v.3.1
- This version does not support PATCH for modifying the resources, instead supports PUT for updating.
NOTE: The supported attributes for updating an Employee are userName, emails and samAccountName.
Features available exclusively in Workday HR v.3.2
- This version supports updating work phone numbers of employees. Schema properties related to employee phone numbers have been modified.
- New attributes added:
- workPhoneMobilePrimary
- pronounID
- jobCategoryID
- supplierReferenceID
- jobExempt
- supervisorManagementChainData~organizationReferenceId
- supervisorManagementChainData~managerId
- supervisorManagementChainData~managerDescriptor
- departmentReferenceId
- divisionReferenceId
- deskReferenceId
- costCenterReferenceId
- companyReferenceId
- regionReferenceId
- personalAssistantReferenceId
- assetClassReferenceId
- departmentHeadReferenceId
- costCenterHierarchyReferenceId
- matrixReferenceId
- customOrgReferences[].OrgReferenceID (Not available in LIST response)
- jobProfileName
- locationID
- locationName
- positionID
- departmentName
- divisionName
- deskName
- costCenterName
- companyName
- regionName
- personalAssistantName
- assetClassName
- costCenterHierarchyName
- matrixName
- customOrgReferences[].organizationName
- workerJobDetails.primaryJob
- workerJobDetails.positionTitle
- workerJobDetails.businessTitle
- Attributes removed:
- phoneNumbers
- phoneNumbersWork
- This version supports updating work phone numbers of employees following PUT. Schemas related to phone numbers have been modified and couple of schema attributes available in lower version have been removed in this version. The obsolete schema attributes are phoneNumbers and phoneNumbersWork (including sub attributes).
NOTE:
- The schema attributes phoneNumbers, phoneNumbers~businessPhone, phoneNumbers~cellPhone, phoneNumbers~isBusinessPhonePublic, phoneNumbers~countryPhoneISOCode, phoneNumbers~internationalPhoneCode, phoneNumbers~isCellPhonePublic, phoneNumbers~type are deprecated and will not return data any longer.
- These attributes are still available in schemas to gracefully allow the creation of synchronization project in Identity Manager using the Workday HR template.
- These attributes will be removed when updating the Synchronization Templates.
Features available exclusively in Workday HR v.4.0
- New resource types JobFamilies and JobFamilyGroups with READ operations are supported.
Features available exclusively in Workday HR v.5.0
- A new UI tag 'Get Minimal List of All Users' is available to choose while calling for Get All Employees and Get All Future Dated Employees. If enabled, this feature allows customers to see minimal information about employees and future dated employees in the list and also retrieved faster.
Features available exclusively in Workday HR v.6.0
- A new UI tag 'Exclude Inactive Employees' is available to exclude the inactive employees from the Employees, FutureDatedEmployee and DeltaSyncEmployees endpoint.