Candidate information table name?

3046012

Hi Team,

I am working on HR Analytics, if external candidate applies for the job where his details will be saved?

Thank you.

Thomas Dodds

Completely up to the HR system you are using ....

3046012

Thanks Thomas, Sorry..

I want to know where these external candidate information stores in OBIA Datawarehouse Schema. I am looking for table name where these details will be stored.

Lot of people referring to W_EMPLOYEE_D, But i am not satisfied since external candidate don't have EMPLOYEE NUMBER then how can i place a record of candidate in W_EMPLOYEE_D.

Thanks in advance.

Thomas Dodds

You'll need to go through the ETL mappings to see if externals are being brought over (if at all).  I can't recall off the top of my head for HR Apps ...

If they aren't coming over, follow Oracle's prescribed customization approach so you don't run into upgrade/patch issues in the future.

I happened to have 11.1.1.8.1 docs on a thumb drive ... did you also look in W_PERON_D / W_PERSON_LEG_D?  It maybe they indeed are getting into W_EMPLOYEE_D as there is a RPD Logical Table for Dim_W_EMPLOYEE_D_Applicant - despite not having one of your company employee numbers ...

3046012

Thanks Thomas.. I just compared the data W_HR_PERSON_D and W_EMPLOYEE_D and see the same what you mentioned.. W_EMPLOYEE_D is having idle values of W_HR_PERSON_D.

I am analyzing the ODI interfaces how they picking these values identical.

Thank you.