VIEW: APPS.HR_EDW_WRK_RCTMNT_FCV

Source

View Text - Preformatted

SELECT 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 ,movement_crrnt_stage_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 ,reason_crrnt_stage_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 ,time_crrnt_stage_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 ,offer_result_pending ,accept_occurred ,accept_fail_occurred ,accept_result_pending ,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

View Text - HTML Formatted

SELECT 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
, MOVEMENT_CRRNT_STAGE_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
, REASON_CRRNT_STAGE_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
, TIME_CRRNT_STAGE_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
, OFFER_RESULT_PENDING
, ACCEPT_OCCURRED
, ACCEPT_FAIL_OCCURRED
, ACCEPT_RESULT_PENDING
, 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