You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL query to get the candidate's education details

Accepted answer
857
Views
3
Comments

Summary:

Hi All,

I am facing an issue to get the candidate's education data using the SQL query:

SELECT U.*

    FROM IRC_CAND_PROFILE_USAGES_M R,

      IRC_PROFILE_EDUCATION_ITEMS_V U

    WHERE R.PROFILE_ID (+)= U.PROFILE_ID

    AND R.PROFILE_TYPE (+)='ORA_CANDIDATE_PROFILE'

     AND R.PERSON_ID = 300003920830965

Query gives the results perfectly whenever

  1. candidate applies from career site and provide the education detail.
  2. Recruiter creates the candidate profile and provide the education details immediately while creating the profile.

I am facing the issue in a scenario where the candidate profile is created in the past without education details and now recruiter is adding the Degree information. In that case table "IRC_CAND_PROFILE_USAGES_M" is not getting updated with the latest profile_ID.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!