Need to get referrer Job Title and Referrer assignment status in OTBI

Rama123-Oracle

We are using "Recruiting - Recruiting Real Time" subject area to get Requistion number, requistion title, referrer person number, referrer person name, worker person number and worker person name etc.. and now the customer wanted pull other two columns referrer Job Title and Referrer assignment status to this report. Would you please suggest me which is the other subject area can we use to pull referrer assignment details.. when we use assignment real time SA - it is pulling worker assignment details instead of the Referrer assignment details.. Please suggest.

sample report format:

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24389/need-to-get-referrer-job-title-and-referrer-assignment-status-in-otbi

I think the only way is to get the required data using logical SQL.

Thanks.