Query or subject area to link internal candidate information to current assignment

Summary:

For our internal applicants in Oracle recruiting, we have many report requirements to be able to link their employee assignment to the candidate and requisition assignment details.

Content (please ensure you mask any confidential information):

I would expect some sort of link in the tables (like a source id on per_all_assignments_m where the source_id would be the candidate assignment id).

Currently I am joining candidate information to employment information by joining on person id and job id and then using filters on dates and statuses - however, I don't feel that is the best path forward and would think there would be a cleaner link.