Candidate information table name?

Question

Hi Team,

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

Thank you.

3046012 · Answer

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.

Thomas Dodds · Answer

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 · Answer

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.