how to get the termination date of managers

User_D9N49

step 1 : get list of managers

step 2 : add "termination date", but it's not for managers, but for workers.

question: how to get the termination date of managers

gclampitt

You could use a subquery within otbi ie "results based upon another analysis

ie the subquery returns a list of managers, then the main query gets the term date details for these people.

select worker number, term date where worker number in (select manager number…..)

John Hung-Oracle

Hi, To better serve you, please post your question in the Reporting and Analytics for HCM forum since its specific to HCM subject areas/use cases. Thank you.

User_D9N49

thank you all for answering~