Candidate Type field in BIP Report
Summary:
Need to fetch the candidate type field for all candidates in a BIP report. Need help in finding the table column field for seeded Candidate Type (Ex-Contingent Workers / Ex-Pending Workers / Employees etc.)
Content (required):
Hello Experts,
Upon initial research I could find the lookup (ORA_IRC_PERSON_TYPE) from where the candidate types are being derived and the corresponding system person type. Also the per_person_types_usages_m has multiple rows of history for the candidate person_id, however I could not find a way to find out proper joining conditions as I see multiple rows extending till 4712.