WorkDay Employee Status Attribute || IDN

ahmednasr · December 21, 2023, 3:33am

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?

zachm117 · December 21, 2023, 3:20pm

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

rajeshs · December 26, 2023, 9:11am

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

ahmednasr · December 26, 2023, 9:17am

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.

rajeshs · December 26, 2023, 9:26am

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 ?

ahmednasr · December 26, 2023, 10:13am

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 ?

rajeshs · December 27, 2023, 5:36am

Hi @ahmednasr

Were you able to resolve this issue?

ahmednasr · December 27, 2023, 9:18am

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”
}

system · February 25, 2024, 9:19am

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

Topic		Replies	Views
Workday Attribute Sync ISC Discussion and Questions aggregation , identity-security-cloud	10	447	December 26, 2023
Workday Attribute not Shown in Sailpoint ISC Discussion and Questions identity-security-cloud , sources	2	407	July 19, 2023
Identity Attribute "SailPoint Username" Results in Identity "cycle" ISC Discussion and Questions identity-security-cloud , provisioning	1	123	February 29, 2024
Workday Employee Status Attribute ISC Discussion and Questions	5	662	July 19, 2023
Workday to IDN Custom Values Contain Reference Field Data ISC Discussion and Questions	6	1775	July 19, 2023

WorkDay Employee Status Attribute || IDN

Related Topics