VIEW: HRI.HRI_MB_REC_CAND_PIPLN_CT#

Source

View Text - Preformatted

select TIME_DAY_EVT_FK TIME_DAY_EVT_FK, TIME_DAY_EVT_END_FK TIME_DAY_EVT_END_FK, TIME_DAY_STG_EVT_EFF_END_FK TIME_DAY_STG_EVT_EFF_END_FK, PER_PERSON_CAND_FK PER_PERSON_CAND_FK, PER_PERSON_MNGR_FK PER_PERSON_MNGR_FK, PER_PERSON_RCRT_FK PER_PERSON_RCRT_FK, PER_PERSON_RMGR_FK PER_PERSON_RMGR_FK, ORG_ORGANZTN_FK ORG_ORGANZTN_FK, GEO_LOCATION_FK GEO_LOCATION_FK, JOB_JOB_FK JOB_JOB_FK, GRD_GRADE_FK GRD_GRADE_FK, POS_POSITION_FK POS_POSITION_FK, PRFM_PERFBAND_FK PRFM_PERFBAND_FK, RVAC_VACNCY_FK RVAC_VACNCY_FK, RACT_RECACTVY_FK RACT_RECACTVY_FK, REV_RECEVENT_FK REV_RECEVENT_FK, TARN_TRMAPLRN_FK TARN_TRMAPLRN_FK, RERN_RECEVTRN_FK RERN_RECEVTRN_FK, HEADCOUNT HEADCOUNT, FTE FTE, POST_HIRE_NRMLSD_PERF_RTNG POST_HIRE_NRMLSD_PERF_RTNG, EVENT_SEQ EVENT_SEQ, APPL_IND APPL_IND, APPL_NEW_IND APPL_NEW_IND, APPL_EMP_IND APPL_EMP_IND, APPL_CWK_IND APPL_CWK_IND, APPL_STRT_EVNT_IND APPL_STRT_EVNT_IND, APPL_STRT_NEVNT_IND APPL_STRT_NEVNT_IND, ASMT_STRT_EVNT_IND ASMT_STRT_EVNT_IND, ASMT_STRT_NEVNT_IND ASMT_STRT_NEVNT_IND, ASMT_END_EVNT_IND ASMT_END_EVNT_IND, ASMT_END_NEVNT_IND ASMT_END_NEVNT_IND, OFFR_EXTD_EVNT_IND OFFR_EXTD_EVNT_IND, OFFR_EXTD_NEVNT_IND OFFR_EXTD_NEVNT_IND, OFFR_RJCT_EVNT_IND OFFR_RJCT_EVNT_IND, OFFR_RJCT_NEVNT_IND OFFR_RJCT_NEVNT_IND, OFFR_ACPT_EVNT_IND OFFR_ACPT_EVNT_IND, OFFR_ACPT_NEVNT_IND OFFR_ACPT_NEVNT_IND, APPL_TERM_EVNT_IND APPL_TERM_EVNT_IND, APPL_TERM_NEVNT_IND APPL_TERM_NEVNT_IND, APPL_TERM_VOL_EVNT_IND APPL_TERM_VOL_EVNT_IND, APPL_TERM_VOL_NEVNT_IND APPL_TERM_VOL_NEVNT_IND, APPL_TERM_INVOL_EVNT_IND APPL_TERM_INVOL_EVNT_IND, APPL_TERM_INVOL_NEVNT_IND APPL_TERM_INVOL_NEVNT_IND, APPL_HIRE_EVNT_IND APPL_HIRE_EVNT_IND, APPL_HIRE_NEVNT_IND APPL_HIRE_NEVNT_IND, HIRE_EVNT_IND HIRE_EVNT_IND, HIRE_NEVNT_IND HIRE_NEVNT_IND, POST_HIRE_POW1_END_EVNT_IND POST_HIRE_POW1_END_EVNT_IND, POST_HIRE_POW1_END_NEVNT_IND POST_HIRE_POW1_END_NEVNT_IND, POST_HIRE_PERF_EVNT_IND POST_HIRE_PERF_EVNT_IND, POST_HIRE_PERF_NEVNT_IND POST_HIRE_PERF_NEVNT_IND, EMP_SPRTN_EVNT_IND EMP_SPRTN_EVNT_IND, EMP_SPRTN_NEVNT_IND EMP_SPRTN_NEVNT_IND, HIRE_ORG_CHNG_IND HIRE_ORG_CHNG_IND, HIRE_JOB_CHNG_IND HIRE_JOB_CHNG_IND, HIRE_POS_CHNG_IND HIRE_POS_CHNG_IND, HIRE_GRD_CHNG_IND HIRE_GRD_CHNG_IND, HIRE_LOC_CHNG_IND HIRE_LOC_CHNG_IND, CURRENT_RECORD_IND CURRENT_RECORD_IND, CURRENT_STAGE_STRT_IND CURRENT_STAGE_STRT_IND, GEN_RECORD_IND GEN_RECORD_IND, APPL_STRT_TO_ASMT_STRT_DAYS APPL_STRT_TO_ASMT_STRT_DAYS, APPL_STRT_TO_ASMT_END_DAYS APPL_STRT_TO_ASMT_END_DAYS, APPL_STRT_TO_OFFR_EXTD_DAYS APPL_STRT_TO_OFFR_EXTD_DAYS, APPL_STRT_TO_OFFR_RJCT_DAYS APPL_STRT_TO_OFFR_RJCT_DAYS, APPL_STRT_TO_OFFR_ACPT_DAYS APPL_STRT_TO_OFFR_ACPT_DAYS, APPL_STRT_TO_HIRE_DAYS APPL_STRT_TO_HIRE_DAYS, APPL_STRT_TO_TERM_DAYS APPL_STRT_TO_TERM_DAYS, APPL_STRT_DATE APPL_STRT_DATE, ASMT_STRT_DATE ASMT_STRT_DATE, ASMT_END_DATE ASMT_END_DATE, OFFR_EXTD_DATE OFFR_EXTD_DATE, OFFR_RJCT_DATE OFFR_RJCT_DATE, OFFR_ACPT_DATE OFFR_ACPT_DATE, APPL_TERM_DATE APPL_TERM_DATE, HIRE_DATE HIRE_DATE, EMP_SPRTN_DATE EMP_SPRTN_DATE, EVENT_DATE EVENT_DATE, ADT_ASSIGNMENT_ID ADT_ASSIGNMENT_ID, ADT_ASG_EFFCTV_START_DATE ADT_ASG_EFFCTV_START_DATE, ADT_ASG_EFFCTV_END_DATE ADT_ASG_EFFCTV_END_DATE, ADT_APPLICATION_ID ADT_APPLICATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, PER_PERSON_AUTH_FK PER_PERSON_AUTH_FK, PER_PERSON_MRGD_FK PER_PERSON_MRGD_FK, PER_PERSON_REFR_FK PER_PERSON_REFR_FK, PER_PERSON_RSED_FK PER_PERSON_RSED_FK, ORG_ORGANZTN_MRGD_FK ORG_ORGANZTN_MRGD_FK, ORG_ORGANZTN_RECR_FK ORG_ORGANZTN_RECR_FK, STAGE_START_DATE STAGE_START_DATE, INIT_APPL_STG_IND INIT_APPL_STG_IND, ASMT_STG_IND ASMT_STG_IND, OFFR_EXTD_STG_IND OFFR_EXTD_STG_IND, STRT_PNDG_STG_IND STRT_PNDG_STG_IND, HIRE_STG_IND HIRE_STG_IND from "HRI"."HRI_MB_REC_CAND_PIPLN_CT"

View Text - HTML Formatted

SELECT TIME_DAY_EVT_FK TIME_DAY_EVT_FK
, TIME_DAY_EVT_END_FK TIME_DAY_EVT_END_FK
, TIME_DAY_STG_EVT_EFF_END_FK TIME_DAY_STG_EVT_EFF_END_FK
, PER_PERSON_CAND_FK PER_PERSON_CAND_FK
, PER_PERSON_MNGR_FK PER_PERSON_MNGR_FK
, PER_PERSON_RCRT_FK PER_PERSON_RCRT_FK
, PER_PERSON_RMGR_FK PER_PERSON_RMGR_FK
, ORG_ORGANZTN_FK ORG_ORGANZTN_FK
, GEO_LOCATION_FK GEO_LOCATION_FK
, JOB_JOB_FK JOB_JOB_FK
, GRD_GRADE_FK GRD_GRADE_FK
, POS_POSITION_FK POS_POSITION_FK
, PRFM_PERFBAND_FK PRFM_PERFBAND_FK
, RVAC_VACNCY_FK RVAC_VACNCY_FK
, RACT_RECACTVY_FK RACT_RECACTVY_FK
, REV_RECEVENT_FK REV_RECEVENT_FK
, TARN_TRMAPLRN_FK TARN_TRMAPLRN_FK
, RERN_RECEVTRN_FK RERN_RECEVTRN_FK
, HEADCOUNT HEADCOUNT
, FTE FTE
, POST_HIRE_NRMLSD_PERF_RTNG POST_HIRE_NRMLSD_PERF_RTNG
, EVENT_SEQ EVENT_SEQ
, APPL_IND APPL_IND
, APPL_NEW_IND APPL_NEW_IND
, APPL_EMP_IND APPL_EMP_IND
, APPL_CWK_IND APPL_CWK_IND
, APPL_STRT_EVNT_IND APPL_STRT_EVNT_IND
, APPL_STRT_NEVNT_IND APPL_STRT_NEVNT_IND
, ASMT_STRT_EVNT_IND ASMT_STRT_EVNT_IND
, ASMT_STRT_NEVNT_IND ASMT_STRT_NEVNT_IND
, ASMT_END_EVNT_IND ASMT_END_EVNT_IND
, ASMT_END_NEVNT_IND ASMT_END_NEVNT_IND
, OFFR_EXTD_EVNT_IND OFFR_EXTD_EVNT_IND
, OFFR_EXTD_NEVNT_IND OFFR_EXTD_NEVNT_IND
, OFFR_RJCT_EVNT_IND OFFR_RJCT_EVNT_IND
, OFFR_RJCT_NEVNT_IND OFFR_RJCT_NEVNT_IND
, OFFR_ACPT_EVNT_IND OFFR_ACPT_EVNT_IND
, OFFR_ACPT_NEVNT_IND OFFR_ACPT_NEVNT_IND
, APPL_TERM_EVNT_IND APPL_TERM_EVNT_IND
, APPL_TERM_NEVNT_IND APPL_TERM_NEVNT_IND
, APPL_TERM_VOL_EVNT_IND APPL_TERM_VOL_EVNT_IND
, APPL_TERM_VOL_NEVNT_IND APPL_TERM_VOL_NEVNT_IND
, APPL_TERM_INVOL_EVNT_IND APPL_TERM_INVOL_EVNT_IND
, APPL_TERM_INVOL_NEVNT_IND APPL_TERM_INVOL_NEVNT_IND
, APPL_HIRE_EVNT_IND APPL_HIRE_EVNT_IND
, APPL_HIRE_NEVNT_IND APPL_HIRE_NEVNT_IND
, HIRE_EVNT_IND HIRE_EVNT_IND
, HIRE_NEVNT_IND HIRE_NEVNT_IND
, POST_HIRE_POW1_END_EVNT_IND POST_HIRE_POW1_END_EVNT_IND
, POST_HIRE_POW1_END_NEVNT_IND POST_HIRE_POW1_END_NEVNT_IND
, POST_HIRE_PERF_EVNT_IND POST_HIRE_PERF_EVNT_IND
, POST_HIRE_PERF_NEVNT_IND POST_HIRE_PERF_NEVNT_IND
, EMP_SPRTN_EVNT_IND EMP_SPRTN_EVNT_IND
, EMP_SPRTN_NEVNT_IND EMP_SPRTN_NEVNT_IND
, HIRE_ORG_CHNG_IND HIRE_ORG_CHNG_IND
, HIRE_JOB_CHNG_IND HIRE_JOB_CHNG_IND
, HIRE_POS_CHNG_IND HIRE_POS_CHNG_IND
, HIRE_GRD_CHNG_IND HIRE_GRD_CHNG_IND
, HIRE_LOC_CHNG_IND HIRE_LOC_CHNG_IND
, CURRENT_RECORD_IND CURRENT_RECORD_IND
, CURRENT_STAGE_STRT_IND CURRENT_STAGE_STRT_IND
, GEN_RECORD_IND GEN_RECORD_IND
, APPL_STRT_TO_ASMT_STRT_DAYS APPL_STRT_TO_ASMT_STRT_DAYS
, APPL_STRT_TO_ASMT_END_DAYS APPL_STRT_TO_ASMT_END_DAYS
, APPL_STRT_TO_OFFR_EXTD_DAYS APPL_STRT_TO_OFFR_EXTD_DAYS
, APPL_STRT_TO_OFFR_RJCT_DAYS APPL_STRT_TO_OFFR_RJCT_DAYS
, APPL_STRT_TO_OFFR_ACPT_DAYS APPL_STRT_TO_OFFR_ACPT_DAYS
, APPL_STRT_TO_HIRE_DAYS APPL_STRT_TO_HIRE_DAYS
, APPL_STRT_TO_TERM_DAYS APPL_STRT_TO_TERM_DAYS
, APPL_STRT_DATE APPL_STRT_DATE
, ASMT_STRT_DATE ASMT_STRT_DATE
, ASMT_END_DATE ASMT_END_DATE
, OFFR_EXTD_DATE OFFR_EXTD_DATE
, OFFR_RJCT_DATE OFFR_RJCT_DATE
, OFFR_ACPT_DATE OFFR_ACPT_DATE
, APPL_TERM_DATE APPL_TERM_DATE
, HIRE_DATE HIRE_DATE
, EMP_SPRTN_DATE EMP_SPRTN_DATE
, EVENT_DATE EVENT_DATE
, ADT_ASSIGNMENT_ID ADT_ASSIGNMENT_ID
, ADT_ASG_EFFCTV_START_DATE ADT_ASG_EFFCTV_START_DATE
, ADT_ASG_EFFCTV_END_DATE ADT_ASG_EFFCTV_END_DATE
, ADT_APPLICATION_ID ADT_APPLICATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, PER_PERSON_AUTH_FK PER_PERSON_AUTH_FK
, PER_PERSON_MRGD_FK PER_PERSON_MRGD_FK
, PER_PERSON_REFR_FK PER_PERSON_REFR_FK
, PER_PERSON_RSED_FK PER_PERSON_RSED_FK
, ORG_ORGANZTN_MRGD_FK ORG_ORGANZTN_MRGD_FK
, ORG_ORGANZTN_RECR_FK ORG_ORGANZTN_RECR_FK
, STAGE_START_DATE STAGE_START_DATE
, INIT_APPL_STG_IND INIT_APPL_STG_IND
, ASMT_STG_IND ASMT_STG_IND
, OFFR_EXTD_STG_IND OFFR_EXTD_STG_IND
, STRT_PNDG_STG_IND STRT_PNDG_STG_IND
, HIRE_STG_IND HIRE_STG_IND
FROM "HRI"."HRI_MB_REC_CAND_PIPLN_CT"