Need to get the Direct Reports when Manager is selected as an Employee in HCM Extract

Content

Hi All,

We have a requirement in HCM Extract to fetch the Employee and Manager details. We are using "PER_EXT_PAY_EMPLOYEES_UE" as root data block to fetch the employee details and "PER_EXT_PERSON_MANAGERS_HIERARCHY_UE" to get the manager information.

However, we have another column in the extract output "Direct Reports" where we need to display Direct reports when manager is selected as Employee in "PER_EXT_PAY_EMPLOYEES_UE" .

Please advice how to get the 'Direct Reports" data.

Employee Number	Manager Name	Direct Reports
John	Paul
David	Paul
Paul	Smith	John,David
Smith