VIEW: APPS.HR_EDW_WRK_SPRTN_FCV

Source

View Text - Preformatted

SELECT separation_pk, assignment_fk, age_band_fk, service_band_fk, geography_fk, grade_fk, instance_fk, job_fk, organization_fk, person_fk, person_type_fk, position_fk, time_trm_ntfd_fk, time_emp_strt_fk, time_trm_accptd_fk, time_trm_prjctd_fk, time_trm_prcss_fk, time_trm_occrd_fk, reason_fk, movement_type_fk, asg_assignment_id, asg_business_group_id, asg_grade_id, asg_job_id, asg_location_id, asg_organization_id, asg_person_id, asg_position_id, pps_prd_of_srvc_id, pps_trm_acptd_prsn_id, date_of_birth, last_update_date, creation_date, emp_start_fte, emp_start_hdcnt, sprtn_ntfd_fte, sprtn_ntfd_hdcnt, sprtn_accptd_fte, sprtn_accptd_hdcnt, sprtn_prjctd_fte, sprtn_prjctd_hdcnt, emp_sprtn_fte, emp_sprtn_hdcnt, final_prcss_fte, final_prcss_hdcnt, separation_fte, separation_headcount, dys_frm_strt_to_lst_updt, dys_frm_strt_to_lst_updt_asg, latest_asg_duration, sprtn_ntfd_vl, sprtn_accptd_vl, sprtn_plnd_vl, sprtn_cncld_vl, sprtn_occrrd_vl, sprtn_fnl_prcssng_vl, dys_frm_strt_to_ntfd_asg, dys_frm_strt_to_accptd_asg, dys_frm_strt_to_plnd_asg, dys_frm_strt_to_trm_asg, dys_frm_strt_to_prcss_asg, dys_frm_strt_to_ntfd, dys_frm_strt_to_accptd, dys_frm_strt_to_plnd, dys_frm_strt_to_trm, dys_frm_strt_to_prcss, dys_frm_ntfd_to_acptd, dys_frm_ntfd_to_plnd, dys_frm_ntfd_to_ocrd, dys_frm_acptd_to_plnd, dys_frm_acptd_to_ocrd, ntfd_trmntn_dt, accptd_trmntn_dt, prjctd_trmntn_dt, actual_trmntn_dt, final_process_dt, leaving_reason, 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_sprtn_fcv

View Text - HTML Formatted

SELECT SEPARATION_PK
, ASSIGNMENT_FK
, AGE_BAND_FK
, SERVICE_BAND_FK
, GEOGRAPHY_FK
, GRADE_FK
, INSTANCE_FK
, JOB_FK
, ORGANIZATION_FK
, PERSON_FK
, PERSON_TYPE_FK
, POSITION_FK
, TIME_TRM_NTFD_FK
, TIME_EMP_STRT_FK
, TIME_TRM_ACCPTD_FK
, TIME_TRM_PRJCTD_FK
, TIME_TRM_PRCSS_FK
, TIME_TRM_OCCRD_FK
, REASON_FK
, MOVEMENT_TYPE_FK
, ASG_ASSIGNMENT_ID
, ASG_BUSINESS_GROUP_ID
, ASG_GRADE_ID
, ASG_JOB_ID
, ASG_LOCATION_ID
, ASG_ORGANIZATION_ID
, ASG_PERSON_ID
, ASG_POSITION_ID
, PPS_PRD_OF_SRVC_ID
, PPS_TRM_ACPTD_PRSN_ID
, DATE_OF_BIRTH
, LAST_UPDATE_DATE
, CREATION_DATE
, EMP_START_FTE
, EMP_START_HDCNT
, SPRTN_NTFD_FTE
, SPRTN_NTFD_HDCNT
, SPRTN_ACCPTD_FTE
, SPRTN_ACCPTD_HDCNT
, SPRTN_PRJCTD_FTE
, SPRTN_PRJCTD_HDCNT
, EMP_SPRTN_FTE
, EMP_SPRTN_HDCNT
, FINAL_PRCSS_FTE
, FINAL_PRCSS_HDCNT
, SEPARATION_FTE
, SEPARATION_HEADCOUNT
, DYS_FRM_STRT_TO_LST_UPDT
, DYS_FRM_STRT_TO_LST_UPDT_ASG
, LATEST_ASG_DURATION
, SPRTN_NTFD_VL
, SPRTN_ACCPTD_VL
, SPRTN_PLND_VL
, SPRTN_CNCLD_VL
, SPRTN_OCCRRD_VL
, SPRTN_FNL_PRCSSNG_VL
, DYS_FRM_STRT_TO_NTFD_ASG
, DYS_FRM_STRT_TO_ACCPTD_ASG
, DYS_FRM_STRT_TO_PLND_ASG
, DYS_FRM_STRT_TO_TRM_ASG
, DYS_FRM_STRT_TO_PRCSS_ASG
, DYS_FRM_STRT_TO_NTFD
, DYS_FRM_STRT_TO_ACCPTD
, DYS_FRM_STRT_TO_PLND
, DYS_FRM_STRT_TO_TRM
, DYS_FRM_STRT_TO_PRCSS
, DYS_FRM_NTFD_TO_ACPTD
, DYS_FRM_NTFD_TO_PLND
, DYS_FRM_NTFD_TO_OCRD
, DYS_FRM_ACPTD_TO_PLND
, DYS_FRM_ACPTD_TO_OCRD
, NTFD_TRMNTN_DT
, ACCPTD_TRMNTN_DT
, PRJCTD_TRMNTN_DT
, ACTUAL_TRMNTN_DT
, FINAL_PROCESS_DT
, LEAVING_REASON
, 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_SPRTN_FCV