Product: | HRI - Human Resources Intelligence |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HR_EDW_WRK_RCTMNT_FCV |
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ RECRUITMENT_GAIN_PK
, APPLICATION_ID
, ASSIGNMENT_ID
, BUSINESS_GROUP_ID
, PERSON_ID
, AGE_BAND_FK
, ASSIGNMENT_FK
, GEOGRAPHY_FK
, GRADE_FK
, INSTANCE_FK
, JOB_FK
, ORGNZTN_ASSGNMNT_FK
, ORGNZTN_CRDNTNG_FK
, PERSON_APPLICANT_FK
, PERSON_AUTHORISER_FK
, PERSON_CONTACT_FK
, PERSON_RECRUITER_FK
, PERSON_ORIGINATOR_FK
, PERSON_TYPE_FK
, POSITION_FK
, MOVEMENT_APPLICATION_FK
, MOVEMENT_INTERVIEW1_FK
, MOVEMENT_INTERVIEW2_FK
, MOVEMENT_OFFER_FK
, MOVEMENT_ACCEPT_FK
, MOVEMENT_HIRE_FK
, MOVEMENT_TERMINATION_FK
, MOVEMENT_EMPLYMNT_END_FK
, REASON_APPLICATION_FK
, REASON_INTERVIEW1_FK
, REASON_INTERVIEW2_FK
, REASON_OFFER_FK
, REASON_ACCEPT_FK
, REASON_HIRE_FK
, REASON_TERMINATION_FK
, REASON_EMPLYMNT_END_FK
, REQUISITION_VACANCY_FK
, RECRUITMENT_ACTIVITY_FK
, SERVICE_BAND_FK
, TIME_APPLICATION_FK
, TIME_INTERVIEW1_FK
, TIME_INTERVIEW2_FK
, TIME_OFFER_FK
, TIME_ACCEPTED_FK
, TIME_HIRE_FK
, TIME_TERMINATED_FK
, TIME_EMPLOYMENT_ENDED_FK
, APPLICATION_START_DATE
, APPLICATION_END_DATE
, HIRE_DATE
, PLANNED_START_DATE
, CREATION_DATE
, LAST_UPDATE_DATE
, APPLICANT_HEADCOUNT
, APPLICANT_FTE
, DAYS_TO_INTERVIEW1
, DAYS_TO_INTERVIEW2
, DAYS_TO_OFFER
, DAYS_TO_ACCEPT
, DAYS_TO_HIRE
, DAYS_TO_TERM_APL
, DAYS_TO_END_EMP
, APPLICATION_OCCURRED
, APPLICATION_RESULT_PENDING
, APPLICATION_PASS_OCCURRED
, APPLICATION_FAIL_OCCURRED
, INTERVIEW1_OCCURRED
, INTERVIEW1_RESULT_PENDING
, INTERVIEW1_PASS_OCCURRED
, INTERVIEW1_FAIL_OCCURRED
, INTERVIEW2_OCCURRED
, INTERVIEW2_RESULT_PENDING
, INTERVIEW2_PASS_OCCURRED
, INTERVIEW2_FAIL_OCCURRED
, OFFER_OCCURRED
, OFFER_FAIL_OCCURRED
, ACCEPT_OCCURRED
, ACCEPT_FAIL_OCCURRED
, HIRE_OCCURRED
, APPLICATION_TERMINATED
, FINISHED_VALUE
, END_EMP_OCCURRED
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM HR_EDWBV_WRK_RCTMNT_FCV