WorkDay Employee Status Attribute || IDN

Identity Security Cloud (ISC) ISC Discussion and Questions
1

Hi All,

We are integrating Workday with IDN and we are configuring Employee Status attribute as identity attribute using “Active” Attribute coming from workday.

the xpath we are using is ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Status_Data/ns1:Active

It is working fine with the joiners and leavers as it gives values 1 for joiners as they are active and 0 for leavers as they are not active.

the problem is on the prehire users, sailpoint always see them active although the response we see from workday is inactive.

is there anything missed in the xpath or should i edit anything to avoid this issue?

2

Hi Ahmed,

To the best of my knowledge, Workday does not have a prehire status, at least not in the Worker_Data table.

We implemented a prehire lifecycle state by checking the user’s HIREDATE and doing a DateCompare to see if that date is before today’s date minus X amount of time.

You can reference this field by using: ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Status_Data/ns1:Hire_Date

  • Zach
3 Likes
3

As @zachm117 mentioned even we implemented the pre-hire with the XPATH
ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Status_Data/ns1:Hire_Date

You can use a transform to validate the hire_date with the current date and based on your logic you can implement pre-hire and active state

4

Yes, workday doesn’t have a prehire status, the only attribute they have is the “active attribute” which should be 1 if the user is already joined and 0 if the user is terminated or still the 1st working date is still did not come.

what iam facing is that the active value in case that the user will join after 10 days for example is changed on sailpoint to be 1 although i see it in workday xml response with 0 value and this is the correct value as the user is still not active till the first working date.

5

Hi @ahmednasr

Based on your above response of getting the value as 0 from workday but it is getting updated to 1 for the user who is a future hire (after 10 days).

I would request you to check if you see any transform logic configured for the status attribute in the IdentityProfile ?

6

there is no transform configured with the status attribute.

i also created new attribute mapped to the same xpath to make sure that there is nothing changing the value but it changed also to 1.

is there a way to check from the logs what caused this change ?

7

Hi @ahmednasr

Were you able to resolve this issue?

8

unfortunately no, below is workday configuration as reference.

what iam using is employee status attribute.

{
“description”: “Workday”,
“owner”: {
“type”: “IDENTITY”,
“id”: “dba0ad8e3d224c8eb23318b352d47a87c19”,
“name”: “xxxx xxxx”
},
“cluster”: {
“type”: “CLUSTER”,
“id”: “af8826c7e34bdf34a3d4a705122c53fd4773”,
“name”: “VA Cluster1”
},
“accountCorrelationConfig”: {
“type”: “ACCOUNT_CORRELATION_CONFIG”,
“id”: “0c5c8f686fssb749779201539aea89fb9f”,
“name”: “Workday [source] Account Correlation”
},
“accountCorrelationRule”: null,
“managerCorrelationMapping”: {
“identityAttributeName”: “identificationNumber”,
“accountAttributeName”: “MANAGER_ID”
},
“managerCorrelationRule”: null,
“beforeProvisioningRule”: null,
“schemas”: [
{
“type”: “CONNECTOR_SCHEMA”,
“id”: “0ec63851124f8d94fc29be6a7419d8b84055”,
“name”: “account”
}
],
“passwordPolicies”: null,
“features”: [
“SYNC_PROVISIONING”,
“SEARCH”,
“PROVISIONING”
],
“type”: “Workday”,
“connector”: “workday-angularsc”,
“connectorClass”: “sailpoint.connector.OpenConnectorAdapter”,
“connectorAttributes”: {
“healthCheckTimeout”: 30,
“Configure_Response_Group”: {
“Include_Organizations”: “true”,
“Include_Collective_Agreement_Data”: “false”,
“Include_Personal_Information”: “true”,
“Include_Compensation”: “false”,
“Include_Subevents_for_Corrected_Transaction”: “false”,
“Include_Background_Check_Data”: “false”,
“Exclude_Business_Unit_Hierarchies”: “true”,
“Exclude_Grants”: “true”,
“Exclude_Gifts”: “true”,
“Exclude_Supervisory_Organizations”: “true”,
“Include_Benefit_Enrollments”: “false”,
“Include_Qualifications”: “false”,
“Exclude_Cost_Centers”: “false”,
“Include_Talent_Assessment”: “false”,
“Include_Career”: “false”,
“Exclude_Employees”: “false”,
“Include_Roles”: “false”,
“Include_Related_Persons”: “false”,
“Include_User_Account”: “false”,
“Exclude_Regions”: “true”,
“Include_Management_Chain_Data”: “true”,
“Include_Subevents_for_Rescinded_Transaction”: “false”,
“Include_Benefit_Eligibility”: “false”,
“Exclude_Gift_Hierarchies”: “true”,
“Exclude_Grant_Hierarchies”: “true”,
“Exclude_Funds”: “true”,
“Include_Contingent_Worker_Tax_Authority_Form_Information”: “false”,
“Include_Reference”: “true”,
“Include_Extended_Employee_Contract_Details”: “false”,
“Include_Multiple_Managers_in_Management_Chain_Data”: “false”,
“Include_Worker_Documents”: “false”,
“Include_Additional_Jobs”: “false”,
“Include_Feedback_Received”: “false”,
“Exclude_Organization_Support_Role_Data”: “true”,
“Exclude_Custom_Organizations”: “false”,
“Include_Employee_Contract_Data”: “false”,
“Exclude_Programs”: “true”,
“Include_Goals”: “false”,
“Exclude_Location_Hierarchies”: “true”,
“Exclude_Fund_Hierarchies”: “true”,
“Exclude_Company_Hierarchies”: “true”,
“Exclude_Matrix_Organizations”: “true”,
“Include_Employment_Information”: “true”,
“Include_Contracts_for_Terminated_Workers”: “false”,
“Include_Account_Provisioning”: “false”,
“Exclude_Contingent_Workers”: “false”,
“Exclude_Region_Hierarchies”: “true”,
“Exclude_Teams”: “true”,
“Include_Succession_Profile”: “false”,
“Exclude_Business_Units”: “true”,
“Include_Probation_Period_Data”: “false”,
“Exclude_Companies”: “false”,
“Include_Development_Items”: “false”,
“Include_Employee_Review”: “false”,
“Exclude_Program_Hierarchies”: “true”,
“Exclude_Cost_Center_Hierarchies”: “false”,
“Include_Skills”: “false”,
“Exclude_Pay_Groups”: “true”
},
“pullRescindedHiresPast”: true,
“deltaAggregationEnabled”: false,
“filterString”: “!( FILENUMBER == 115 || FILENUMBER == 114 || FILENUMBER == 12 ||FILENUMBER == 483 || FILENUMBER == 87 ||FILENUMBER == 128 || FILENUMBER == 283 || FILENUMBER == 446 || FILENUMBER == 283 || FILENUMBER == 363 || FILENUMBER == 463 || FILENUMBER == 555 || FILENUMBER == 267 || FILENUMBER == 158 || FILENUMBER == 270 ||FILENUMBER == 506 ||FILENUMBER == 528 ||FILENUMBER == 509 || FILENUMBER == 125 || FILENUMBER == 579 || FILENUMBER == 580 || FILENUMBER == 613 || FILENUMBER == 614 || FILENUMBER == 620 || FILENUMBER == 623 || FILENUMBER == 621 || FILENUMBER == 626 || FILENUMBER == 628 || FILENUMBER == 635 || FILENUMBER == 637 || FILENUMBER == 639 || FILENUMBER == 640 )”,
“deleteAllEmailRecord”: false,
“XpathAttributesMap”: {
“WORK_MOBILE”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Contact_Data/ns1:Phone_Data[(ns1:Usage_Data[@ns1:Public=‘true’]/ns1:Type_Data/ns1:Type_Reference/ns1:ID[@ns1:type=‘Communication_Usage_Type_ID’] =‘WORK’) and (ns1:Phone_Device_Type_Reference/ns1:ID[@ns1:type=‘Phone_Device_Type_ID’]=‘null’)]/@ns1:Workday_Traditional_Formatted_Phone”,
“ORGANIZATION_NAME”: “ns1:Worker_Data/ns1:Organization_Data/ns1:Worker_Organization_Data/ns1:Organization_Data[ns1:Organization_Type_Reference[@ns1:Descriptor =‘Business Unit’]]/ns1:Organization_Name”,
“CLASS”: “concat(ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Position_Title,ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Position_Time_Type_Reference/ns1:ID[@ns1:type=‘Position_Time_Type_ID’],ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Worker_Type_Reference/ns1:ID[@ns1:type=‘Employee_Type_ID’] | ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Position_Title,ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Position_Time_Type_Reference/ns1:ID[@ns1:type=‘Position_Time_Type_ID’],ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Worker_Type_Reference/ns1:ID[@ns1:type=‘Employee_Type_ID’])”,
“Leave Starting Date”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Status_Data/ns1:Leave_Status_Data/ns1:Leave_Start_Date”,
“WORK_TELEPHONE”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Contact_Data/ns1:Phone_Data[(ns1:Usage_Data[@ns1:Public=‘true’]/ns1:Type_Data/ns1:Type_Reference/ns1:ID[@ns1:type=‘Communication_Usage_Type_ID’] =‘WORK’) and (ns1:Phone_Device_Type_Reference/ns1:ID[@ns1:type=‘Phone_Device_Type_ID’]=‘null’)]/@ns1:Workday_Traditional_Formatted_Phone”,
“WORKER_NAME”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Name_Data/ns1:Preferred_Name_Data/ns1:Name_Detail_Data/@ns1:Formatted_Name”,
“Leave End Date”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Status_Data/ns1:Leave_Status_Data/ns1:Estimated_Leave_End_Date”,
“Terminated”: " ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Status_Data/ns1:Terminated",
“POSITION”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Position_Title | ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Position_Title”,
“HOME_MOBILE”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Contact_Data/ns1:Phone_Data[(ns1:Usage_Data[@ns1:Public=‘true’]/ns1:Type_Data/ns1:Type_Reference/ns1:ID[@ns1:type=‘Communication_Usage_Type_ID’] =‘HOME’) and (ns1:Phone_Device_Type_Reference/ns1:ID[@ns1:type=‘Phone_Device_Type_ID’]=‘null’)]/@ns1:Workday_Traditional_Formatted_Phone”,
“COUNTRY”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Contact_Data/ns1:Address_Data[ns1:Usage_Data/ns1:Type_Data/ns1:Type_Reference/ns1:ID[@ns1:type=‘Communication_Usage_Type_ID’] =‘WORK’]/ns1:Country_Reference/ns1:ID[@ns1:type=‘ISO_3166-1_Alpha-3_Code’]”,
“JOBCODE”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Job_Profile_Summary_Data/ns1:Job_Profile_Reference/ns1:ID[@ns1:type=‘Job_Profile_ID’] | ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Job_Profile_Summary_Data/ns1:Job_Profile_Reference/ns1:ID[@ns1:type=‘Job_Profile_ID’]”,
“USERID”: “ns1:Worker_Data/ns1:User_ID”,
“Worker_ID”: “ns1:Worker_Data/ns1:Worker_ID”,
“Rescinded”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Status_Data/ns1:Hire_Rescinded”,
“Employee Status”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Status_Data/ns1:Active”,
“ADDRESS_LINE_1”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Business_Site_Summary_Data/ns1:Address_Data/ns1:Address_Line_Data[@ns1:Type = ‘ADDRESS_LINE_1’] | ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Business_Site_Summary_Data/ns1:Address_Data/ns1:Address_Line_Data[@ns1:Type = ‘ADDRESS_LINE_1’]”,
“CHECK_LATEST_WORKER_RECORD”: “ns1:Worker_Data/ns1:Integration_Field_Override_Data[ns1:Field_Reference[ns1:ID[@ns1:type=‘Integration_Document_Field_Name’]=‘LATEST_WORKER_RECORD’]]”,
“LEGAL_MIDDLE_NAME”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Name_Data/ns1:Legal_Name_Data/ns1:Name_Detail_Data/ns1:Middle_Name”,
“Retired”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Status_Data/ns1:Retired”,
“activeOU”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Business_Site_Summary_Data/ns1:Name | ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Business_Site_Summary_Data/ns1:Name”,
“active”: “ns1:Worker_Data/ns1:Organization_Data/ns1:Worker_Organization_Data/ns1:Organization_Data[ns1:Organization_Type_Reference[ns1:ID[@ns1:type=‘Organization_Type_ID’]=‘HCM_Org_type_Department’]]/ns1:Organization_Name | ns1:Worker_Data/ns1:Organization_Data/ns1:Worker_Organization_Data/ns1:Organization_Data[ns1:Organization_Type_Reference[ns1:ID[@ns1:type=‘Organization_Type_ID’]=‘HCM_Org_type_Department’]]/ns1:Organization_Name”,
“DEPARTMENT”: “ns1:Worker_Data/ns1:Organization_Data/ns1:Worker_Organization_Data/ns1:Organization_Data[ns1:Organization_Type_Reference[ns1:ID[@ns1:type=‘Organization_Type_ID’]=‘HCM_Org_type_Department’]]/ns1:Organization_Name | ns1:Worker_Data/ns1:Organization_Data/ns1:Worker_Organization_Data/ns1:Organization_Data[ns1:Organization_Type_Reference[ns1:ID[@ns1:type=‘Organization_Type_ID’]=‘HCM_Org_type_Department’]]/ns1:Organization_Name”,
“MANAGER_ID”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Manager_as_of_last_detected_manager_change_Reference/ns1:ID[@ns1:type=‘Employee_ID’]”,
“COMPANY_NAME”: “ns1:Worker_Data/ns1:Organization_Data/ns1:Worker_Organization_Data/ns1:Organization_Data[ns1:Organization_Type_Reference/ns1:ID [@ns1:type=‘Organization_Type_ID’]=‘COMPANY’]/ns1:Organization_Name”,
“EMPLOYEE_TYPE”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Worker_Type_Reference/ns1:ID[@ns1:type=‘Employee_Type_ID’] | ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Worker_Type_Reference/ns1:ID[@ns1:type=‘Contingent_Worker_Type_ID’] | ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Worker_Type_Reference/ns1:ID[@ns1:type=‘Employee_Type_ID’] | ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Worker_Type_Reference/ns1:ID[@ns1:type=‘Contingent_Worker_Type_ID’]”,
“TERMINATION_DATE”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Status_Data/ns1:Termination_Date”,
“PREFERRED_LAST_NAME”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Name_Data/ns1:Preferred_Name_Data/ns1:Name_Detail_Data/ns1:Last_Name”,
“WORKER_DESCRIPTOR”: “ns1:Worker_Descriptor | ns1:Worker_Reference/@ns1:Descriptor”,
“INTERNATIONAL_ASSIGNMENT”: “ns1:Worker_Data/ns1:Employment_Data/ns1:International_Assignment_Summary_Data/ns1:Has_International_Assignment”,
“ADDITIONAL_EMAIL_ADDRESS_HOME”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Contact_Data/ns1:Email_Address_Data[ns1:Usage_Data[@ns1:Public=‘true’]/ns1:Type_Data[@ns1:Primary=‘false’]/ns1:Type_Reference/ns1:ID[@ns1:type=‘Communication_Usage_Type_ID’] =‘HOME’]/ns1:Email_Address”,
“ADDRESS_WORK”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Contact_Data/ns1:Address_Data[ns1:Usage_Data/ns1:Type_Data[@ns1:Primary=‘true’]/ns1:Type_Reference/ns1:ID[@ns1:type=‘Communication_Usage_Type_ID’] =‘WORK’]/@ns1:Formatted_Address”,
“FUTURE_ACTION”: “ns1:Worker_Data/ns1:Transaction_Log_Entry_Data/ns1:Transaction_Log_Entry/ns1:Transaction_Log_Data/ns1:Transaction_Log_Type_Reference[ns1:ID[@ns1:type=‘Business_Process_Type’]=‘Hire Employee’]/ns1:ID[@ns1:type=‘Business_Process_Type’] |ns1:Worker_Data/ns1:Transaction_Log_Entry_Data/ns1:Transaction_Log_Entry/ns1:Transaction_Log_Data/ns1:Transaction_Log_Type_Reference[ns1:ID[@ns1:type=‘Business_Process_Type’]=‘Contract Contingent Worker’]/ns1:ID[@ns1:type=‘Business_Process_Type’] | ns1:Worker_Data/ns1:Transaction_Log_Entry_Data/ns1:Transaction_Log_Entry/ns1:Transaction_Log_Data/ns1:Transaction_Log_Type_Reference[ns1:ID[@ns1:type=‘Business_Process_Type’]=‘Terminate Employee’]/ns1:ID[@ns1:type=‘Business_Process_Type’] |ns1:Worker_Data/ns1:Transaction_Log_Entry_Data/ns1:Transaction_Log_Entry/ns1:Transaction_Log_Data/ns1:Transaction_Log_Type_Reference[ns1:ID[@ns1:type=‘Business_Process_Type’]=‘Onboarding’]/ns1:ID[@ns1:type=‘Business_Process_Type’] |ns1:Worker_Data/ns1:Transaction_Log_Entry_Data/ns1:Transaction_Log_Entry/ns1:Transaction_Log_Data/ns1:Transaction_Log_Type_Reference[ns1:ID[@ns1:type=‘Business_Process_Type’]=‘End Contingent Worker Contract’]/ns1:ID[@ns1:type=‘Business_Process_Type’]”,
“ON_LEAVE”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Status_Data/ns1:Leave_Status_Data/ns1:On_Leave”,
“LOCATION”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Business_Site_Summary_Data/ns1:Name | ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Business_Site_Summary_Data/ns1:Name”,
“Business Title”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Business_Title | ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Business_Title”,
“STATE”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Business_Site_Summary_Data/ns1:Address_Data/ns1:Country_Region_Reference/ns1:ID[@ns1:type=‘Country_Region_ID’] | ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Business_Site_Summary_Data/ns1:Address_Data/ns1:Country_Region_Reference/ns1:ID[@ns1:type=‘Country_Region_ID’]”,
“LAST_NAME”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Name_Data/ns1:Legal_Name_Data/ns1:Name_Detail_Data/ns1:Last_Name”,
“DIVISION”: “ns1:Worker_Data/ns1:Organization_Data/ns1:Worker_Organization_Data/ns1:Organization_Data[ns1:Organization_Type_Reference[@ns1:Descriptor=‘Sales Channel’]]/ns1:Organization_Name”,
“FIRST_NAME”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Name_Data/ns1:Legal_Name_Data/ns1:Name_Detail_Data/ns1:First_Name”,
“FUTURE_DATE”: “ns1:Worker_Data/ns1:Transaction_Log_Entry_Data/ns1:Transaction_Log_Entry/ns1:Transaction_Log_Data[ns1:Transaction_Log_Type_Reference[ns1:ID[@ns1:type=‘Business_Process_Type’]=‘Hire Employee’]]/ns1:Transaction_Effective_Moment |ns1:Worker_Data/ns1:Transaction_Log_Entry_Data/ns1:Transaction_Log_Entry/ns1:Transaction_Log_Data[ns1:Transaction_Log_Type_Reference[ns1:ID[@ns1:type=‘Business_Process_Type’]=‘Contract Contingent Worker’]]/ns1:Transaction_Effective_Moment |ns1:Worker_Data/ns1:Transaction_Log_Entry_Data/ns1:Transaction_Log_Entry/ns1:Transaction_Log_Data[ns1:Transaction_Log_Type_Reference[ns1:ID[@ns1:type=‘Business_Process_Type’]=‘Terminate Employee’]]/ns1:Transaction_Effective_Moment |ns1:Worker_Data/ns1:Transaction_Log_Entry_Data/ns1:Transaction_Log_Entry/ns1:Transaction_Log_Data[ns1:Transaction_Log_Type_Reference[ns1:ID[@ns1:type=‘Business_Process_Type’]=‘Onboarding’]]/ns1:Transaction_Effective_Moment |ns1:Worker_Data/ns1:Transaction_Log_Entry_Data/ns1:Transaction_Log_Entry/ns1:Transaction_Log_Data[ns1:Transaction_Log_Type_Reference[ns1:ID[@ns1:type=‘Business_Process_Type’]=‘End Contingent Worker Contract’]]/ns1:Transaction_Effective_Moment”,
“EMAIL_ADDRESS_HOME”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Contact_Data/ns1:Email_Address_Data[ns1:Usage_Data[@ns1:Public=‘true’]/ns1:Type_Data[@ns1:Primary=‘true’]/ns1:Type_Reference/ns1:ID[@ns1:type=‘Communication_Usage_Type_ID’] =‘HOME’]/ns1:Email_Address”,
“POSTAL_CODE”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Contact_Data/ns1:Address_Data[ns1:Usage_Data/ns1:Type_Data/ns1:Type_Reference/ns1:ID[@ns1:type=‘Communication_Usage_Type_ID’] =‘WORK’]/ns1:Postal_Code”,
“LEAVE”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Status_Data/ns1:Leave_Status_Data/ns1:On_Leave | ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Status_Data/ns1:Leave_Status_Date[1]/@ns1:On_Leave”,
“MIDDLE_NAME”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Name_Data/ns1:Legal_Name_Data/ns1:Name_Detail_Data/ns1:Middle_Name”,
“Critical Job”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Job_Profile_Summary_Data/ns1:Critical_Job”,
“EMAIL_ADDRESS_WORK”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Contact_Data/ns1:Email_Address_Data[ns1:Usage_Data[@ns1:Public=‘true’]/ns1:Type_Data[@ns1:Primary=‘true’]/ns1:Type_Reference/ns1:ID[@ns1:type=‘Communication_Usage_Type_ID’] =‘WORK’]/ns1:Email_Address”,
“FULLPARTTIME”: “concat(ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Position_Title,’ ‘,ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Position_Time_Type_Reference/ns1:ID[@ns1:type=‘Position_Time_Type_ID’] | ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Position_Title,’ ',ns1:Worker_Data/ns1:Employment_Data/ns1:Position_Data/ns1:Position_Time_Type_Reference/ns1:ID[@ns1:type=‘Position_Time_Type_ID’])”,
“Email_Address”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Contact_Data/ns1:Email_Address_Data[ns1:Usage_Data[@ns1:Public=‘true’]/ns1:Type_Data[@ns1:Primary=‘true’]/ns1:Type_Reference/ns1:ID[@ns1:type=‘Communication_Usage_Type_ID’] =‘WORK’]/ns1:Email_Address”,
“Rehire”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Status_Data/ns1:Rehire”,
“HOME_TELEPHONE”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Contact_Data/ns1:Phone_Data[(ns1:Usage_Data[@ns1:Public=‘true’]/ns1:Type_Data/ns1:Type_Reference/ns1:ID[@ns1:type=‘Communication_Usage_Type_ID’] =‘HOME’) and (ns1:Phone_Device_Type_Reference/ns1:ID[@ns1:type=‘Phone_Device_Type_ID’]=‘null’)]/@ns1:Workday_Traditional_Formatted_Phone”,
“Preferred Name”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Name_Data/ns1:Preferred_Name_Data/ns1:Name_Detail_Data/@ns1:Formatted_Name”,
“ADDITIONAL_EMAIL_ADDRESS_WORK”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Contact_Data/ns1:Email_Address_Data[ns1:Usage_Data[@ns1:Public=‘true’]/ns1:Type_Data[@ns1:Primary=‘false’]/ns1:Type_Reference/ns1:ID[@ns1:type=‘Communication_Usage_Type_ID’] =‘WORK’]/ns1:Email_Address”,
“MANAGER_NAME”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Management_Chains_Data/ns1:Position_Supervisory_Management_Chain_Data/ns1:Management_Chain_Data/ns1:Manager/ns1:Worker_Descriptor”,
“CITY”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Contact_Data/ns1:Address_Data[ns1:Usage_Data[@ns1:Public=‘true’]/ns1:Type_Data[@ns1:Primary=‘true’]/ns1:Type_Reference/ns1:ID[@ns1:type=‘Communication_Usage_Type_ID’] =‘WORK’]/ns1:Municipality”,
“LAST_DAY_OF_WORK”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Status_Data/ns1:Termination_Last_Day_of_Work”,
“ADDRESS_HOME”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Contact_Data/ns1:Address_Data[ns1:Usage_Data/ns1:Type_Data[@ns1:Primary=‘true’]/ns1:Type_Reference/ns1:ID[@ns1:type=‘Communication_Usage_Type_ID’] =‘HOME’]/@ns1:Formatted_Address”,
“HIREDATE”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Status_Data/ns1:First_Day_of_Work”,
“JOB Title”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Job_Data/ns1:Position_Data/ns1:Position_Title”,
“PREFERRED_FIRST_NAME”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Name_Data/ns1:Preferred_Name_Data/ns1:Name_Detail_Data/ns1:First_Name”,
“PREFERRED_MIDDLE_NAME”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Name_Data/ns1:Preferred_Name_Data/ns1:Name_Detail_Data/ns1:Middle_Name”,
“TEAM”: “ns1:Worker_Data/ns1:Organization_Data/ns1:Worker_Organization_Data/ns1:Organization_Data[ns1:Organization_Type_Reference[@ns1:Descriptor=‘TEAM’]]/ns1:Organization_Name”,
"Leave Reason ": “ns1:Worker/ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Status_Data/ns1:Leave_Status_Data[ns1:On_Leave=‘1’]/ns1:Leave_of_Absence_Type_Reference/ns1:ID[@ns1:type='Leave_of_Absence_Type_ID”,
“Phone Number”: “ns1:Worker_Data/ns1:Personal_Data/ns1:Contact_Data/ns1:Phone_Data/ns1:Phone_Number”,
“SUB-DEPARTMENT”: “ns1:Worker_Data/ns1:Organization_Data/ns1:Worker_Organization_Data/ns1:Organization_Data/ns1:Organization_Subtype_Reference”,
“CONTRACT_END_DATE”: “ns1:Worker_Data/ns1:Employment_Data/ns1:Worker_Contract_Data/ns1:Contract_End_Date”
},
“aggregationThreadSize”: “4”,
“connectionType”: “direct”,
“Future_Hire_Events”: [
“Contract Contingent Worker”,
“Onboarding”,
“Hire Employee”
],
“password”: “1:HDtfLBow+jqgiso7SKajtmrjkO85uiaK4g+xwwJnvhmrr1iC5O9AMbSo/lGzT3r88qe+wasHHsgw\nyrw0k8RG0qkuu2MwCg1HX6b00CtSiVb4KE0uoctr/gqwBge5re9cozbCuPx+OPlSemcsmppg0khB\nPYK3Pwh64+veAsfWGMmOjrZMi5hDGDekvx4Jc+83L2OkBbkLF+EXr73WSSLtLTdpnKokVK4bRu5u\nIajO4MeclKFR1PlhfwOjK/P//sh3rFxQhctvtGWXnwrGlaKUv13OeNbF7RucRZLFuw/KQPQhTnmJ\nXgDRBLukgt0lpEHYWAdSyPvKaM/dMZnPjAiNK0vik7VZxePYnEJ8evtgSzcy7iHaOBKL7QJca4nh\nGH2zXrrN/LuyWJEMX6EKAdsRb8WHrxMprzOV9Q3eHlBroENgrjN2htm7yhB2Qn0PfSrri/2pL1PY\ndvMYIkKs5ZXj66NJwaKiFqK0Fofy6o0x5HPWz9mnSVnpeYwYKZuZ7+V/sACSD6pjHDV9WpPYWRxp\n8kYfHzmz9mleGFlJD98AbuZtRAa90A0IiuFa2jlqo4yD”,
“Termination_Events”: [
“Terminate Employee”,
“End Contingent Worker Contract”
],
“retryErrors”: [
“Connection reset”,
“503 Service Unavailable”
],
“Past_Termination_Offset”: “60”,
“Integration_Field”: null,
“cloudExternalId”: “2101”,
“clientSecret”: null,
“Organization_Reference_ID”: null,
“SKIP_FUTURE_TERMINATING_RECORDS”: false,
“isRestConfigEnabled”: false,
“pullRescindedHires”: true,
“sourceConnected”: true,
“primary_Work_Phone_Type”: “telephone”,
“SKIP_FUTURE_TERMINATION_RECORDS”: false,
“provisioningPassword”: “1:/0g3v7qoP/L8Nl7BTJ8V426uaMupf+LKeBe7THZ9aCSXZKBnfZGdz2gBNQq2nPAV0BwuIaugUY74\ndrDvFaGmVBmJ4skCTikfvQP91nTLrnQtLNv1OF5wLs1aGWI9HxmxbsdICVdp1VUFuA5bi185g6KE\nOR9mqWcvC7A34evBtdIh1U5chU1kgXi31rYRnZV6WyPXS6sUHN0Photf1XqUr8eDf6eDjS4yNgFf\nA9diIQ0ai51t/NsbFDnQNFo4PgRNlw8iQFaRj4aTMj5zaVggligni/ybufVhvTYcIGXh0IbppKDd\nBal8X3aqrv1Hw+uziyb1IG86vgdqnbCqzgrfio0U+G1psPRny0V8x92HGcdfTJD545yK+8cBVA+x\nfoMQHQZY7eLF3ei5C6md/WruB+hIrK00CxDTbWt8coW1Nt84TJ56u20IylB+JdDEzqrxRVRbBJm/\nev7gQe20Jb4NEQ5K+nPlIGQ40X5fuJ8gjOQTt6iAwX4UdOaFkwcgv0heVOHlOVWTcJGCCpIamNn/\ngsCSeRSCuWHG5hECPIoWFrKAJ1Xm1cNNVJl9DSgZ63UR”,
“EffectiveDateOffset”: “90”,
“FetchWorkersByOrganization”: false,
“version”: “39.1”,
“primary_Home_Phone_Type”: “telephone”,
“cloudAuthoritativeSourcePrecedence”: 20,
“formPath”: null,
“ChunkSize”: “500”,
“cloudCacheUpdate”: 1703664050476,
“connectorName”: “Workday”,
“pastEffectiveDateOffset”: null,
“isInactiveWorkersAllowed”: false,
“Integration_Field_Override_Service”: “4”,
“since”: “2023-12-23T04:00:47.433163Z”,
“status”: “SOURCE_STATE_HEALTHY”,
“supportsDeltaAgg”: “true”,
“Delta_Aggregation_Events”: null,
“customTimeOut”: “1”,
“useChangeContactInfoAPI”: true,
“Future_Termination_Events”: [
“Terminate Employee”,
“End Contingent Worker Contract”
],
“supportsEntitlementAggregation”: “false”,
“connectorClass”: “openconnector.connector.WorkDay”,
“tokenEndpoint”: null,
“grant_type”: null,
“pastRescindedOffset”: “7”,
“hasFullAggregationCompleted”: true,
“deltaAggregation”: null,
“cloudIdentityProfileName”: “xc Employees”,
“auth_type”: “Basic”,
“clientId”: null,
“defaultCountryCode”: “+1”,
“Termination_Attributes”: [
“TERMINATION_DATE”,
“LAST_DAY_OF_WORK”,
“CONTRACT_END_DATE”,
“PRIMARY_TERMINATION_REASON_REFERENCE”
],
“deleteAllPhoneRecord”: false,
“deleteThresholdPercentage”: 100,
“CustomServerTimeZone”: “UTC”,
“Organization_Type_ID”: null,
“provisioningUser”: “xxxxx”,
“url”: “xxxxx”,
“templateApplication”: “Workday”,
“IntegrationSystemID”: null,
“encrypted”: “provisioningPassword,clientSecret,refreshToken,oauth_token_info,http.proxyPassword,https.proxyPassword”,
“healthy”: true,
“cloudDisplayName”: “Workday”,
“user”: “xxxx”,
“restEndpoint”: null,
“beforeProvisioningRule”: null,
“refreshToken”: null
},
“deleteThreshold”: 100,
“authoritative”: true,
“healthy”: true,
“status”: “SOURCE_STATE_HEALTHY”,
“since”: “2023-12-23T04:00:47.433163Z”,
“connectorId”: “workday-angularsc”,
“connectorName”: “Workday”,
“connectionType”: “direct”,
“connectorImplementationId”: “workday-angularsc”,
“managementWorkgroup”: null,
“id”: “69485c874644448a95483115bf67958c”,
“name”: “Workday”,
“created”: “2023-10-30T13:01:24.134Z”,
“modified”: “2023-12-27T08:58:45.416Z”
}

9

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.