Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry. Saviynt Copilot Icon
This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Org Structure (supervisor) import from workday to Saviynt

navneetv
Regular Contributor II
Regular Contributor II

‎10/23/2023 08:06 AM - edited ‎10/25/2023 11:40 PM

Hi Saviynt Team,

We have a use case where we want to get the report. here is what we want to set up.

"There are 16 people who report to one of our C-Level members directly. 
Is there a way to pull out all the  employees who report to those 16 officers"

We are importing the manager ID from the workday by using a soap WORKDAY connection. Do we need to add mapping in Saviynt, if so could you please help us get the XPath of the attribute? 

Import mapping 

 

{
"ImportType": "SOAP",
"ResponsePath": "Body.Get_Workers_Response.Response_Data.Worker",
"ImportMapping": {
"USERNAME": "Worker_Data.Worker_ID",
"SYSTEMUSERNAME": "Worker_Data.Worker_ID",
"FIRSTNAME": "Worker_Data.Personal_Data.Name_Data.Legal_Name_Data.Name_Detail_Data.First_Name",
"LASTNAME": "Worker_Data.Personal_Data.Name_Data.Legal_Name_Data.Name_Detail_Data.Last_Name",
"LOCATION": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Business_Site_Summary_Data.Name",
"CUSTOMPROPERTY46": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Business_Site_Summary_Data.Name",
"COUNTRY": "Worker_Data.Personal_Data.Contact_Data.Address_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK').Country_Reference.ID(@type=='ISO_3166-1_Alpha-3_Code')",
"COSTCENTER": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Organizations_Data.Position_Organization_Data.Organization_Data.Organization_Code",
"CITY": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Business_Site_Summary_Data.Name",
"CUSTOMPROPERTY45": "Worker_Data.Personal_Data.Contact_Data.Address_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK').Municipality",
"TITLE": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Business_Title",
"DISPLAYNAME": "Worker_Data.Personal_Data.Name_Data.Legal_Name_Data.Name_Detail_Data.@Formatted_Name",
"PREFEREDFIRSTNAME": "Worker_Data.Personal_Data.Name_Data.Preferred_Name_Data.Name_Detail_Data.First_Name",
"PHONENUMBER": "Worker_Data.Personal_Data.Contact_Data.Phone_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK').Phone_Number",
"SECONDARYPHONE": "Worker_Data.Personal_Data.Contact_Data.Phone_Data(Usage_Data->Type_Data->Type_Reference->ID=='HOME').@Formatted_Phone",
"EMAIL": "Worker_Data.Personal_Data.Contact_Data.Email_Address_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK').Email_Address",
"EMPLOYEETYPE": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Worker_Type_Reference.ID(@type=='Employee_Type_ID')",
"COMPANYNAME": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Organizations_Data.Position_Organization_Data.Organization_Data(Organization_Type_Reference->ID=='Company').Organization_Name",
"CUSTOMPROPERTY1": "Worker_Data.Management_Chain_Data.Worker_Supervisory_Management_Chain_Data.Management_Chain_Data(-1).Manager.Worker_Reference.ID(@type=='Employee_ID')",
"MIDDLENAME": "Worker_Data.Personal_Data.Name_Data.Legal_Name_Data.Name_Detail_Data.Middle_Name",
"CREATEDATE": "Worker_Data.Employment_Data.Worker_Status_Data.Hire_Date",
"JOBCODE": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Job_Profile_Summary_Data.Job_Profile_Reference.ID(@type=='Job_Profile_ID')",
"DEPARTMENTNAME": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Organizations_Data.Position_Organization_Data.Organization_Data.Organization_Name",
"STATE": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Business_Site_Summary_Data.Address_Data.Country_Region_Reference.ID(@type=='Country_Region_ID')",
"STARTDATE": "Worker_Data.Employment_Data.Worker_Status_Data.Hire_Date",
"EMPLOYEECLASS": "Worker_Data.Employment_Data.Position_Data.Position_Title.Worker_Data.Employment_Data.Position_Data.Position_Time_Type_Reference.ID(@type=='Position_Time_Type_ID')",
"JOBDESCRIPTION": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Position_Title",
"STREET": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Business_Site_Summary_Data.Address_Data.Address_Line_Data(@Type=='ADDRESS_LINE_1')",
"ENDDATE": "Worker_Data.Employment_Data.Worker_Status_Data.Termination_Last_Day_of_Work",
"REGIONCODE": "Worker_Data.Personal_Data.Contact_Data.Address_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK').Postal_Code",
"CUSTOMPROPERTY2": "Worker_Data.Personal_Data.Name_Data.Preferred_Name_Data.Name_Detail_Data.Last_Name",
"DEPARTMENTNUMBER": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Organizations_Data.Position_Organization_Data.Organization_Data.Organization_Code",
"CUSTOMPROPERTY27": "Worker_Data.Employment_Data.Worker_Status_Data.Active",
"CUSTOMPROPERTY4": "Worker_Data.Organization_Data.Worker_Organization_Data.Organization_Data(Organization_Type_Reference->ID=='Business Unit').Organization_Name",
"CUSTOMPROPERTY5": "Worker_Data.Personal_Data.Name_Data.Legal_Name_Data.Name_Detail_Data.@Formatted_Name",
"CUSTOMPROPERTY6": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Job_Profile_Summary_Data.Management_Level_Reference.ID(@type=='Management_Level_ID')",
"CUSTOMPROPERTY7": "Worker_Data.Integration_Field_Override_Data.Field_Reference->ID(@type=='Integration_Document_Field_Name').LATEST_WORKER_RECORD",
"CUSTOMPROPERTY8": "Worker_Descriptor",
"CUSTOMPROPERTY12": "Worker_Data.Organization_Data.Worker_Organization_Data.Organization_Data(Organization_Type_Reference->Descriptor=='Sales Channel').Organization_Name",
"CUSTOMPROPERTY14": "Worker_Data.Organization_Data.Worker_Organization_Data.Organization_Data(Organization_Type_Reference->ID=='COST_CENTER_HIERARCHY').Organization_Name",
"CUSTOMPROPERTY16": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.End_Employment_Reason_Reference.ID(@type=='Termination_Subcategory_ID')",
"TERMDATE": "Worker_Data.Employment_Data.Worker_Status_Data.Termination_Date",
"CUSTOMPROPERTY21": "Worker_Data.Personal_Data.Name_Data.Preferred_Name_Data.Name_Detail_Data.Middle_Name",
"CUSTOMPROPERTY22": "Worker_Data.Organization_Data.Worker_Organization_Data.Organization_Data(Organization_Type_Reference->Descriptor=='TEAM').Organization_Name",
"CUSTOMPROPERTY24": "Worker_Data.Employment_Data.Worker_Contract_Data.Contract_End_Date",
"CUSTOMPROPERTY25": "Worker_Data.User_ID",
"CUSTOMPROPERTY31": "Worker_Data.Employment_Data.Worker_Status_Data.Hire_Reason_Reference.ID(@type=='General_Event_Subcategory_ID')",
"MANAGER": "Worker_Data.Management_Chain_Data.Worker_Supervisory_Management_Chain_Data.Management_Chain_Data(-1).Manager.Worker_Reference.ID(@type=='Employee_ID')",
"CUSTOMPROPERTY23": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Organizations_Data.Position_Organization_Data.Organization_Data(Organization_Type_Reference->ID=='Company').Organization_Reference_ID",
"CUSTOMPROPERTY26": "Worker_Data.Personal_Data.Contact_Data.Email_Address_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK').Email_Address",
"CUSTOMPROPERTY9": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Worker_Type_Reference.ID(@type=='Employee_Type_ID')",
"CUSTOMPROPERTY10": "Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Worker_Type_Reference.ID(@type=='Contingent_Worker_Type_ID')",
"EMPLOYEEID": "Worker_Data.Worker_ID",
"CUSTOMPROPERTY35": "Worker_Data.Transaction_Log_Entry_Data.Transaction_Log_Entry.Transaction_Log_Data(Transaction_Log_Type_Reference->ID=='Hire Employee').Transaction_Effective_Moment",
"CUSTOMPROPERTY36": "Worker_Data.Transaction_Log_Entry_Data.Transaction_Log_Entry.Transaction_Log_Data(Transaction_Log_Type_Reference->ID=='Terminate Employee').Transaction_Effective_Moment",
"CUSTOMPROPERTY37": "Worker_Data.Transaction_Log_Entry_Data.Transaction_Log_Entry.Transaction_Log_Data(Transaction_Log_Type_Reference->ID=='Onboarding').Transaction_Effective_Moment",
"CUSTOMPROPERTY38": "Worker_Data.Transaction_Log_Entry_Data.Transaction_Log_Entry.Transaction_Log_Data(Transaction_Log_Type_Reference->ID=='End Contingent Worker Contract').Transaction_Effective_Moment",
"CUSTOMPROPERTY53": "Worker_Data.Transaction_Log_Entry_Data.Transaction_Log_Entry.Transaction_Log_Data(Transaction_Log_Type_Reference->ID=='Contract Contingent Worker').Transaction_Effective_Moment",
"CUSTOMPROPERTY43": "Worker_Data.Transaction_Log_Entry_Data.Transaction_Log_Entry.Transaction_Log_Data(Transaction_Log_Type_Reference->ID=='Hire Employee').ID(@type=='Business_Process_Type')",
"CUSTOMPROPERTY44": "Worker_Data.Transaction_Log_Entry_Data.Transaction_Log_Entry.Transaction_Log_Data(Transaction_Log_Type_Reference->ID=='Contract Contingent Worker').ID(@type=='Business_Process_Type')",
"CUSTOMPROPERTY47": "Worker_Data.Transaction_Log_Entry_Data.Transaction_Log_Entry.Transaction_Log_Data(Transaction_Log_Type_Reference->ID=='Terminate Employee').ID(@type=='Business_Process_Type')",
"CUSTOMPROPERTY49": "Worker_Data.Transaction_Log_Entry_Data.Transaction_Log_Entry.Transaction_Log_Data(Transaction_Log_Type_Reference->ID=='Onboarding').ID(@type=='Business_Process_Type')",
"CUSTOMPROPERTY52": "Worker_Data.Transaction_Log_Entry_Data.Transaction_Log_Entry.Transaction_Log_Data(Transaction_Log_Type_Reference->ID=='End Contingent Worker Contract').ID(@type=='Business_Process_Type')",
"CUSTOMPROPERTY54": "Worker_Data.Management_Chain_Data.Worker_Supervisory_Management_Chain_Data.Management_Chain_Data(-1).Manager.Worker_Reference.ID(@type=='Contingent_Worker_ID')",
"CUSTOMPROPERTY65": "Worker_Data.Integration_Field_Override_Data(Field_Reference->ID=='Flexible_Worker_Arrangement').Value"
}
}

 

0 Kudos
3 REPLIES 3

rushikeshvartak
All-Star
All-Star

‎10/23/2023 07:53 PM - edited ‎10/23/2023 07:53 PM

select u.username,m.username mgr from users u,users m where u.manager=m.userkey and m.title='C-Level'


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.
0 Kudos

navneetv
Regular Contributor II
Regular Contributor II

‎10/25/2023 11:49 PM - edited ‎10/25/2023 11:50 PM

Hi @rushikeshvartak thankyou for checking and working on it.

we are getting an error while running this query to Data Analyzer.  No data found 

select u.username,m.username mgr from users u,users m where u.manager=m.userkey and m.title='CEO'

could you please help me understand  from where it comes ?

m.username mgr

And

users m

0 Kudos

pmahalle
All-Star
All-Star
In response to navneetv

‎10/25/2023 11:56 PM

Hi @navneetv ,

Use below query:

select u.username, m.username  from users u,users m where u.manager=m.userkey and m.title='C-Level'

Make sure user with title C-Level have subordinates assigned.

Here we are joining users table with itself one for normal user and one for manager.


Pandharinath Mahalle(Paddy)
If this reply helps your question, please consider selecting Accept As Solution and hit Kudos 🙂
0 Kudos
Copyright © 2024 Khoros, LLC