Assistance Needed for Custom Query Mapping in ORC to CORE HR

Hi Team,

I hope this message finds you well.

I wanted to reach out regarding a custom query I created for the offer creation page in ORC. While I’ve made some progress, I’m encountering a challenge when it comes to mapping the data to CORE HR.

Currently, the query only retrieves candidates who have a PERSON_NUMBER. This limitation means it does not include candidates for whom an offer has been created but who have not yet transitioned to the HR state. I suspect that I might be missing a necessary table that would enable a more comprehensive mapping between ORC and CORE HR.