SQL Query to fetch Supervisor Direct and Indirect reportees

  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 12, 2020
  • Reading time:5 mins read

In this article we will look into getting in the Direct and Indirect reportees of a Supervisor using SQL Query. We assign the Supervisor on the Employment screen and they get stored in the PER_ASSIGNMENT_SUPERVISORS_F table. We will have to join the PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_M and PER_ASSIGNMENT_SUPERVISORS_F tables to get the manager information of an employee. However Fusion has a scheduled…

Continue ReadingSQL Query to fetch Supervisor Direct and Indirect reportees