Active\Inactive Employees with assigned Line Managers

Summary

A requirement for a BIP report to show all employees and their Line Managers

Content

Hi All,

I have a requirement to create a BIP report to display all Active and Inactive employees and their Line managers.

When I run the below report it only shows active assignments but the leavers are missing.

If I comment out\remove the PER_ASSIGNMENT_SUPERVISORS_F as well as any other reference relating to the manager the report runs correctly showing both active and Inactive employees.

Is there a way to fix this or use the table PER_MANAGER_HRCHY_DN as an alternative? if so how do I show employees and their line managers?