[Home] [Help]
View: HR_EDW_WRK_RCTMNT_FCV
Product: | HRI - Human Resources Intelligence (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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
Columns
Name |
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 |
USER_MEASURE1 |
USER_MEASURE2 |
USER_MEASURE3 |
USER_MEASURE4 |
USER_MEASURE5 |
USER_ATTRIBUTE1 |
USER_ATTRIBUTE2 |
USER_ATTRIBUTE3 |
USER_ATTRIBUTE4 |
USER_ATTRIBUTE5 |
USER_ATTRIBUTE6 |
USER_ATTRIBUTE7 |
USER_ATTRIBUTE8 |
USER_ATTRIBUTE9 |
USER_ATTRIBUTE10 |
USER_ATTRIBUTE11 |
USER_ATTRIBUTE12 |
USER_ATTRIBUTE13 |
USER_ATTRIBUTE14 |
USER_ATTRIBUTE15 |
USER_FK1 |
USER_FK2 |
USER_FK3 |
USER_FK4 |
USER_FK5 |