eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HRI_OBI_MDS_WRKFC_DAY_V

Source

View Text - Preformatted


SELECT CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.wevt_evtypcmb_fk ELSE -1 END wevt_evtypcmb_fk ,wevt.asg_assgnmnt_fk ,wevt.per_person_fk ,wevt.per_person_mgr_fk ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.per_person_mgr_prv_fk ELSE wevt.per_person_mgr_fk END per_person_mgr_prv_fk ,wevt.mgr_mngrsc_fk ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.mgr_mngrsc_prv_fk ELSE wevt.mgr_mngrsc_fk END mgr_mngrsc_prv_fk ,wevt.org_organztn_fk ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.org_organztn_prv_fk ELSE wevt.org_organztn_fk END org_organztn_prv_fk ,wevt.job_job_fk ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.job_job_prv_fk ELSE wevt.job_job_fk END job_job_prv_fk ,wevt.grd_grade_fk ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.grd_grade_prv_fk ELSE wevt.grd_grade_fk END grd_grade_prv_fk ,wevt.pos_position_fk ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.pos_position_prv_fk ELSE wevt.pos_position_fk END pos_position_prv_fk ,wevt.geo_location_fk ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.geo_location_prv_fk ELSE wevt.geo_location_fk END geo_location_prv_fk ,wevt.asgrsn_asgrsn_fk ,wevt.sprn_sprtnrsn_fk ,wevt.scat_spcatgry_fk ,wevt.ptyp_pertyp_fk ,wevt.prfm_perfband_fk ,wevt.pow_powband_fk ,cal.report_date time_day_snp_fk ,wevt.time_day_evt_fk time_day_last_evt_fk ,wevt.cur_currency_fk ,wevt.headcount headcount_start ,wevt.headcount headcount_end ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.headcount_hire ELSE 0 END headcount_hire ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.headcount_term ELSE 0 END headcount_term ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_voluntary_ind * wevt.headcount_term ELSE 0 END headcount_sep_vol ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_involuntary_ind * wevt.headcount_term ELSE 0 END headcount_sep_invol ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.headcount * wevt.promotion_ind ELSE 0 END headcount_prmtn_emp ,wevt.headcount * wevt.employee_ind headcount_start_emp ,wevt.headcount * wevt.employee_ind headcount_end_emp ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.headcount_hire * wevt.employee_ind ELSE 0 END headcount_hire_emp ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.headcount_term * wevt.employee_ind ELSE 0 END headcount_term_emp ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_voluntary_ind * wevt.headcount_term * wevt.employee_ind ELSE 0 END headcount_sep_vol_emp ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_involuntary_ind * wevt.headcount_term * wevt.employee_ind ELSE 0 END headcount_sep_invol_emp ,wevt.headcount * wevt.contingent_ind headcount_start_cwk ,wevt.headcount * wevt.contingent_ind headcount_end_cwk ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.headcount_hire * wevt.contingent_ind ELSE 0 END headcount_hire_cwk ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.headcount_term * wevt.contingent_ind ELSE 0 END headcount_term_cwk ,wevt.fte fte_start ,wevt.fte fte_end ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.fte_hire ELSE 0 END fte_hire ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.fte_term ELSE 0 END fte_term ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_voluntary_ind * wevt.fte_term ELSE 0 END fte_sep_vol ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_involuntary_ind * wevt.fte_term ELSE 0 END fte_sep_invol ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.fte * wevt.promotion_ind ELSE 0 END fte_prmtn_emp ,wevt.fte * wevt.employee_ind fte_start_emp ,wevt.fte * wevt.employee_ind fte_end_emp ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.fte_hire * wevt.employee_ind ELSE 0 END fte_hire_emp ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.fte_term * wevt.employee_ind ELSE 0 END fte_term_emp ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_voluntary_ind * wevt.fte_term * wevt.employee_ind ELSE 0 END fte_sep_vol_emp ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_involuntary_ind * wevt.fte_term * wevt.employee_ind ELSE 0 END fte_sep_invol_emp ,wevt.fte * wevt.contingent_ind fte_start_cwk ,wevt.fte * wevt.contingent_ind fte_end_cwk ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.fte_hire * wevt.contingent_ind ELSE 0 END fte_hire_cwk ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.fte_term * wevt.contingent_ind ELSE 0 END fte_term_cwk ,(1 - wevt.term_or_end_ind) * wevt.primary_ind * wevt.employee_ind count_pasg_end_emp ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.hire_or_start_ind * wevt.primary_ind * wevt.employee_ind ELSE 0 END count_pasg_hire_emp ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_or_end_ind * wevt.primary_ind ELSE 0 END count_pasg_term_emp ,(1 - wevt.term_or_end_ind) * wevt.employee_ind count_asg_end_emp ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.hire_or_start_ind * wevt.employee_ind ELSE 0 END count_asg_hire_emp ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_or_end_ind * wevt.employee_ind ELSE 0 END count_asg_term_emp ,(1 - wevt.term_or_end_ind) * wevt.primary_ind * wevt.contingent_ind count_pasg_end_cwk ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.hire_or_start_ind * wevt.primary_ind * wevt.contingent_ind ELSE 0 END count_pasg_hire_cwk ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_or_end_ind * wevt.primary_ind * wevt.contingent_ind ELSE 0 END count_pasg_term_cwk ,(1 - wevt.term_or_end_ind) * wevt.contingent_ind count_asg_end_cwk ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.hire_or_start_ind * wevt.contingent_ind ELSE 0 END count_asg_hire_cwk ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_or_end_ind * wevt.contingent_ind ELSE 0 END count_asg_term_cwk ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_voluntary_ind * wevt.primary_ind ELSE 0 END count_pasg_sep_vol ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_involuntary_ind * wevt.primary_ind ELSE 0 END count_pasg_sep_invol ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_voluntary_ind * wevt.primary_ind * wevt.employee_ind ELSE 0 END count_pasg_sep_vol_emp ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_involuntary_ind * wevt.primary_ind * wevt.employee_ind ELSE 0 END count_pasg_sep_invol_emp ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_voluntary_ind ELSE 0 END count_asg_sep_vol ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_involuntary_ind ELSE 0 END count_asg_sep_invol ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_voluntary_ind * wevt.employee_ind ELSE 0 END count_asg_sep_vol_emp ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.term_involuntary_ind * wevt.employee_ind ELSE 0 END count_asg_sep_invol_emp ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.promotion_ind ELSE 0 END count_asg_prmtn_emp ,((cal.report_date - wevt.time_day_evt_fk) + wevt.pow_days_on_event_date) * employee_ind pos_days_on_end_date ,(MONTHS_BETWEEN(cal.report_date, wevt.time_day_evt_fk - wevt.pow_days_on_event_date)) * employee_ind pos_months_on_end_date ,(MONTHS_BETWEEN(cal.report_date, wevt.time_day_evt_fk - wevt.pow_days_on_event_date) / 12) * employee_ind pos_years_on_end_date ,((cal.report_date - wevt.time_day_evt_fk) + wevt.pow_days_on_event_date) * contingent_ind pop_days_on_end_date ,(MONTHS_BETWEEN(cal.report_date, wevt.time_day_evt_fk - wevt.pow_days_on_event_date)) * contingent_ind pop_months_on_end_date ,(MONTHS_BETWEEN(cal.report_date, wevt.time_day_evt_fk - wevt.pow_days_on_event_date) / 12) * contingent_ind pop_years_on_end_date ,((cal.report_date - wevt.time_day_evt_fk) + wevt.days_since_last_prmtn) days_since_last_prmtn ,(MONTHS_BETWEEN(cal.report_date, wevt.time_day_evt_fk - wevt.days_since_last_prmtn)) months_since_last_prmtn ,(MONTHS_BETWEEN(cal.report_date, wevt.time_day_evt_fk - wevt.days_since_last_prmtn) / 12) years_since_last_prmtn ,wevt.anl_slry anl_slry_start ,wevt.anl_slry anl_slry_end ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.assignment_change_ind ELSE 0 END assignment_change_ind ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.headcount_gain_ind ELSE 0 END headcount_gain_ind ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.headcount_loss_ind ELSE 0 END headcount_loss_ind ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.fte_gain_ind ELSE 0 END fte_gain_ind ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.fte_loss_ind ELSE 0 END fte_loss_ind ,wevt.contingent_ind ,wevt.employee_ind ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.grade_change_ind ELSE 0 END grade_change_ind ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.job_change_ind ELSE 0 END job_change_ind ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.position_change_ind ELSE 0 END position_change_ind ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.location_change_ind ELSE 0 END location_change_ind ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.organization_change_ind ELSE 0 END organization_change_ind ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.supervisor_change_ind ELSE 0 END supervisor_change_ind ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.worker_hire_ind ELSE 0 END worker_hire_ind ,wevt.term_voluntary_ind ,wevt.term_involuntary_ind ,wevt.worker_term_ind ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.start_asg_sspnsn_ind ELSE 0 END start_asg_sspnsn_ind ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.end_asg_sspnsn_ind ELSE 0 END end_asg_sspnsn_ind ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.post_hire_asgn_start_ind ELSE 0 END post_hire_asgn_start_ind ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.pre_sprtn_asgn_end_ind ELSE 0 END pre_sprtn_asgn_end_ind ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.prsntyp_change_ind ELSE 0 END prsntyp_change_ind ,CASE WHEN cal.report_date = wevt.time_day_evt_fk THEN wevt.mgrh_node_change_ind ELSE 0 END mgrh_node_change_ind ,hri_oltp_view_currency.convert_to_primary_crnc (wevt.cur_currency_fk, anl_slry) anl_slry_start_prm ,hri_oltp_view_currency.convert_to_primary_crnc (wevt.cur_currency_fk, anl_slry) anl_slry_end_prm ,hri_oltp_view_currency.convert_to_secondary_crnc (wevt.cur_currency_fk, anl_slry) anl_slry_start_sec ,hri_oltp_view_currency.convert_to_secondary_crnc (wevt.cur_currency_fk, anl_slry) anl_slry_end_sec ,wevt.worker_hire_ind last_event_hire_ind FROM hri_mb_wrkfc_evt_ct wevt ,fii_time_day cal WHERE cal.report_date BETWEEN wevt.time_day_evt_fk AND wevt.time_day_evt_end_fk AND cal.report_date <= DECODE(wevt.worker_term_ind + wevt.pre_sprtn_asgn_end_ind, 0, wevt.time_day_evt_end_fk, wevt.time_day_evt_fk)

View Text - HTML Formatted

SELECT CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.WEVT_EVTYPCMB_FK ELSE -1 END WEVT_EVTYPCMB_FK
, WEVT.ASG_ASSGNMNT_FK
, WEVT.PER_PERSON_FK
, WEVT.PER_PERSON_MGR_FK
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.PER_PERSON_MGR_PRV_FK ELSE WEVT.PER_PERSON_MGR_FK END PER_PERSON_MGR_PRV_FK
, WEVT.MGR_MNGRSC_FK
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.MGR_MNGRSC_PRV_FK ELSE WEVT.MGR_MNGRSC_FK END MGR_MNGRSC_PRV_FK
, WEVT.ORG_ORGANZTN_FK
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.ORG_ORGANZTN_PRV_FK ELSE WEVT.ORG_ORGANZTN_FK END ORG_ORGANZTN_PRV_FK
, WEVT.JOB_JOB_FK
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.JOB_JOB_PRV_FK ELSE WEVT.JOB_JOB_FK END JOB_JOB_PRV_FK
, WEVT.GRD_GRADE_FK
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.GRD_GRADE_PRV_FK ELSE WEVT.GRD_GRADE_FK END GRD_GRADE_PRV_FK
, WEVT.POS_POSITION_FK
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.POS_POSITION_PRV_FK ELSE WEVT.POS_POSITION_FK END POS_POSITION_PRV_FK
, WEVT.GEO_LOCATION_FK
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.GEO_LOCATION_PRV_FK ELSE WEVT.GEO_LOCATION_FK END GEO_LOCATION_PRV_FK
, WEVT.ASGRSN_ASGRSN_FK
, WEVT.SPRN_SPRTNRSN_FK
, WEVT.SCAT_SPCATGRY_FK
, WEVT.PTYP_PERTYP_FK
, WEVT.PRFM_PERFBAND_FK
, WEVT.POW_POWBAND_FK
, CAL.REPORT_DATE TIME_DAY_SNP_FK
, WEVT.TIME_DAY_EVT_FK TIME_DAY_LAST_EVT_FK
, WEVT.CUR_CURRENCY_FK
, WEVT.HEADCOUNT HEADCOUNT_START
, WEVT.HEADCOUNT HEADCOUNT_END
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.HEADCOUNT_HIRE ELSE 0 END HEADCOUNT_HIRE
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.HEADCOUNT_TERM ELSE 0 END HEADCOUNT_TERM
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_VOLUNTARY_IND * WEVT.HEADCOUNT_TERM ELSE 0 END HEADCOUNT_SEP_VOL
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_INVOLUNTARY_IND * WEVT.HEADCOUNT_TERM ELSE 0 END HEADCOUNT_SEP_INVOL
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.HEADCOUNT * WEVT.PROMOTION_IND ELSE 0 END HEADCOUNT_PRMTN_EMP
, WEVT.HEADCOUNT * WEVT.EMPLOYEE_IND HEADCOUNT_START_EMP
, WEVT.HEADCOUNT * WEVT.EMPLOYEE_IND HEADCOUNT_END_EMP
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.HEADCOUNT_HIRE * WEVT.EMPLOYEE_IND ELSE 0 END HEADCOUNT_HIRE_EMP
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.HEADCOUNT_TERM * WEVT.EMPLOYEE_IND ELSE 0 END HEADCOUNT_TERM_EMP
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_VOLUNTARY_IND * WEVT.HEADCOUNT_TERM * WEVT.EMPLOYEE_IND ELSE 0 END HEADCOUNT_SEP_VOL_EMP
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_INVOLUNTARY_IND * WEVT.HEADCOUNT_TERM * WEVT.EMPLOYEE_IND ELSE 0 END HEADCOUNT_SEP_INVOL_EMP
, WEVT.HEADCOUNT * WEVT.CONTINGENT_IND HEADCOUNT_START_CWK
, WEVT.HEADCOUNT * WEVT.CONTINGENT_IND HEADCOUNT_END_CWK
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.HEADCOUNT_HIRE * WEVT.CONTINGENT_IND ELSE 0 END HEADCOUNT_HIRE_CWK
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.HEADCOUNT_TERM * WEVT.CONTINGENT_IND ELSE 0 END HEADCOUNT_TERM_CWK
, WEVT.FTE FTE_START
, WEVT.FTE FTE_END
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.FTE_HIRE ELSE 0 END FTE_HIRE
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.FTE_TERM ELSE 0 END FTE_TERM
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_VOLUNTARY_IND * WEVT.FTE_TERM ELSE 0 END FTE_SEP_VOL
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_INVOLUNTARY_IND * WEVT.FTE_TERM ELSE 0 END FTE_SEP_INVOL
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.FTE * WEVT.PROMOTION_IND ELSE 0 END FTE_PRMTN_EMP
, WEVT.FTE * WEVT.EMPLOYEE_IND FTE_START_EMP
, WEVT.FTE * WEVT.EMPLOYEE_IND FTE_END_EMP
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.FTE_HIRE * WEVT.EMPLOYEE_IND ELSE 0 END FTE_HIRE_EMP
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.FTE_TERM * WEVT.EMPLOYEE_IND ELSE 0 END FTE_TERM_EMP
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_VOLUNTARY_IND * WEVT.FTE_TERM * WEVT.EMPLOYEE_IND ELSE 0 END FTE_SEP_VOL_EMP
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_INVOLUNTARY_IND * WEVT.FTE_TERM * WEVT.EMPLOYEE_IND ELSE 0 END FTE_SEP_INVOL_EMP
, WEVT.FTE * WEVT.CONTINGENT_IND FTE_START_CWK
, WEVT.FTE * WEVT.CONTINGENT_IND FTE_END_CWK
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.FTE_HIRE * WEVT.CONTINGENT_IND ELSE 0 END FTE_HIRE_CWK
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.FTE_TERM * WEVT.CONTINGENT_IND ELSE 0 END FTE_TERM_CWK
, (1 - WEVT.TERM_OR_END_IND) * WEVT.PRIMARY_IND * WEVT.EMPLOYEE_IND COUNT_PASG_END_EMP
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.HIRE_OR_START_IND * WEVT.PRIMARY_IND * WEVT.EMPLOYEE_IND ELSE 0 END COUNT_PASG_HIRE_EMP
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_OR_END_IND * WEVT.PRIMARY_IND ELSE 0 END COUNT_PASG_TERM_EMP
, (1 - WEVT.TERM_OR_END_IND) * WEVT.EMPLOYEE_IND COUNT_ASG_END_EMP
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.HIRE_OR_START_IND * WEVT.EMPLOYEE_IND ELSE 0 END COUNT_ASG_HIRE_EMP
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_OR_END_IND * WEVT.EMPLOYEE_IND ELSE 0 END COUNT_ASG_TERM_EMP
, (1 - WEVT.TERM_OR_END_IND) * WEVT.PRIMARY_IND * WEVT.CONTINGENT_IND COUNT_PASG_END_CWK
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.HIRE_OR_START_IND * WEVT.PRIMARY_IND * WEVT.CONTINGENT_IND ELSE 0 END COUNT_PASG_HIRE_CWK
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_OR_END_IND * WEVT.PRIMARY_IND * WEVT.CONTINGENT_IND ELSE 0 END COUNT_PASG_TERM_CWK
, (1 - WEVT.TERM_OR_END_IND) * WEVT.CONTINGENT_IND COUNT_ASG_END_CWK
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.HIRE_OR_START_IND * WEVT.CONTINGENT_IND ELSE 0 END COUNT_ASG_HIRE_CWK
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_OR_END_IND * WEVT.CONTINGENT_IND ELSE 0 END COUNT_ASG_TERM_CWK
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_VOLUNTARY_IND * WEVT.PRIMARY_IND ELSE 0 END COUNT_PASG_SEP_VOL
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_INVOLUNTARY_IND * WEVT.PRIMARY_IND ELSE 0 END COUNT_PASG_SEP_INVOL
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_VOLUNTARY_IND * WEVT.PRIMARY_IND * WEVT.EMPLOYEE_IND ELSE 0 END COUNT_PASG_SEP_VOL_EMP
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_INVOLUNTARY_IND * WEVT.PRIMARY_IND * WEVT.EMPLOYEE_IND ELSE 0 END COUNT_PASG_SEP_INVOL_EMP
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_VOLUNTARY_IND ELSE 0 END COUNT_ASG_SEP_VOL
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_INVOLUNTARY_IND ELSE 0 END COUNT_ASG_SEP_INVOL
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_VOLUNTARY_IND * WEVT.EMPLOYEE_IND ELSE 0 END COUNT_ASG_SEP_VOL_EMP
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.TERM_INVOLUNTARY_IND * WEVT.EMPLOYEE_IND ELSE 0 END COUNT_ASG_SEP_INVOL_EMP
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.PROMOTION_IND ELSE 0 END COUNT_ASG_PRMTN_EMP
, ((CAL.REPORT_DATE - WEVT.TIME_DAY_EVT_FK) + WEVT.POW_DAYS_ON_EVENT_DATE) * EMPLOYEE_IND POS_DAYS_ON_END_DATE
, (MONTHS_BETWEEN(CAL.REPORT_DATE
, WEVT.TIME_DAY_EVT_FK - WEVT.POW_DAYS_ON_EVENT_DATE)) * EMPLOYEE_IND POS_MONTHS_ON_END_DATE
, (MONTHS_BETWEEN(CAL.REPORT_DATE
, WEVT.TIME_DAY_EVT_FK - WEVT.POW_DAYS_ON_EVENT_DATE) / 12) * EMPLOYEE_IND POS_YEARS_ON_END_DATE
, ((CAL.REPORT_DATE - WEVT.TIME_DAY_EVT_FK) + WEVT.POW_DAYS_ON_EVENT_DATE) * CONTINGENT_IND POP_DAYS_ON_END_DATE
, (MONTHS_BETWEEN(CAL.REPORT_DATE
, WEVT.TIME_DAY_EVT_FK - WEVT.POW_DAYS_ON_EVENT_DATE)) * CONTINGENT_IND POP_MONTHS_ON_END_DATE
, (MONTHS_BETWEEN(CAL.REPORT_DATE
, WEVT.TIME_DAY_EVT_FK - WEVT.POW_DAYS_ON_EVENT_DATE) / 12) * CONTINGENT_IND POP_YEARS_ON_END_DATE
, ((CAL.REPORT_DATE - WEVT.TIME_DAY_EVT_FK) + WEVT.DAYS_SINCE_LAST_PRMTN) DAYS_SINCE_LAST_PRMTN
, (MONTHS_BETWEEN(CAL.REPORT_DATE
, WEVT.TIME_DAY_EVT_FK - WEVT.DAYS_SINCE_LAST_PRMTN)) MONTHS_SINCE_LAST_PRMTN
, (MONTHS_BETWEEN(CAL.REPORT_DATE
, WEVT.TIME_DAY_EVT_FK - WEVT.DAYS_SINCE_LAST_PRMTN) / 12) YEARS_SINCE_LAST_PRMTN
, WEVT.ANL_SLRY ANL_SLRY_START
, WEVT.ANL_SLRY ANL_SLRY_END
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.ASSIGNMENT_CHANGE_IND ELSE 0 END ASSIGNMENT_CHANGE_IND
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.HEADCOUNT_GAIN_IND ELSE 0 END HEADCOUNT_GAIN_IND
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.HEADCOUNT_LOSS_IND ELSE 0 END HEADCOUNT_LOSS_IND
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.FTE_GAIN_IND ELSE 0 END FTE_GAIN_IND
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.FTE_LOSS_IND ELSE 0 END FTE_LOSS_IND
, WEVT.CONTINGENT_IND
, WEVT.EMPLOYEE_IND
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.GRADE_CHANGE_IND ELSE 0 END GRADE_CHANGE_IND
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.JOB_CHANGE_IND ELSE 0 END JOB_CHANGE_IND
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.POSITION_CHANGE_IND ELSE 0 END POSITION_CHANGE_IND
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.LOCATION_CHANGE_IND ELSE 0 END LOCATION_CHANGE_IND
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.ORGANIZATION_CHANGE_IND ELSE 0 END ORGANIZATION_CHANGE_IND
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.SUPERVISOR_CHANGE_IND ELSE 0 END SUPERVISOR_CHANGE_IND
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.WORKER_HIRE_IND ELSE 0 END WORKER_HIRE_IND
, WEVT.TERM_VOLUNTARY_IND
, WEVT.TERM_INVOLUNTARY_IND
, WEVT.WORKER_TERM_IND
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.START_ASG_SSPNSN_IND ELSE 0 END START_ASG_SSPNSN_IND
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.END_ASG_SSPNSN_IND ELSE 0 END END_ASG_SSPNSN_IND
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.POST_HIRE_ASGN_START_IND ELSE 0 END POST_HIRE_ASGN_START_IND
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.PRE_SPRTN_ASGN_END_IND ELSE 0 END PRE_SPRTN_ASGN_END_IND
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.PRSNTYP_CHANGE_IND ELSE 0 END PRSNTYP_CHANGE_IND
, CASE WHEN CAL.REPORT_DATE = WEVT.TIME_DAY_EVT_FK THEN WEVT.MGRH_NODE_CHANGE_IND ELSE 0 END MGRH_NODE_CHANGE_IND
, HRI_OLTP_VIEW_CURRENCY.CONVERT_TO_PRIMARY_CRNC (WEVT.CUR_CURRENCY_FK
, ANL_SLRY) ANL_SLRY_START_PRM
, HRI_OLTP_VIEW_CURRENCY.CONVERT_TO_PRIMARY_CRNC (WEVT.CUR_CURRENCY_FK
, ANL_SLRY) ANL_SLRY_END_PRM
, HRI_OLTP_VIEW_CURRENCY.CONVERT_TO_SECONDARY_CRNC (WEVT.CUR_CURRENCY_FK
, ANL_SLRY) ANL_SLRY_START_SEC
, HRI_OLTP_VIEW_CURRENCY.CONVERT_TO_SECONDARY_CRNC (WEVT.CUR_CURRENCY_FK
, ANL_SLRY) ANL_SLRY_END_SEC
, WEVT.WORKER_HIRE_IND LAST_EVENT_HIRE_IND
FROM HRI_MB_WRKFC_EVT_CT WEVT
, FII_TIME_DAY CAL
WHERE CAL.REPORT_DATE BETWEEN WEVT.TIME_DAY_EVT_FK
AND WEVT.TIME_DAY_EVT_END_FK
AND CAL.REPORT_DATE <= DECODE(WEVT.WORKER_TERM_IND + WEVT.PRE_SPRTN_ASGN_END_IND
, 0
, WEVT.TIME_DAY_EVT_END_FK
, WEVT.TIME_DAY_EVT_FK)