Click HERE to see how Saviynt Intelligence is transforming the industry. |
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"
}
}
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'
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
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.