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_CS_LOW_V

Source

View Text - Preformatted


SELECT months_between(tim.report_date,pos.date_start)/12 low_in_years , months_between(tim.report_date,pos.date_start) low_in_months , tim.report_date - pos.date_start low_in_days , bnd.band_min_value low_band_min_value , bnd.band_max_value low_band_max_value /* Bridge Ids */ , pos.person_id person_id , bnd.band_min_value low_band_id , tim.report_date effective_start_date , tim.report_date effective_end_date , tim.report_date effective_date /* Other Information */ , pos.date_start person_start_date /* Parent Ids */ , pos.period_of_service_id period_of_service_id , -1 period_of_placement_id , 'Y' emp_flag_code , 'N' cwk_flag_code , pos.business_group_id business_group_id FROM hri_time_bands bnd , hri_time_day tim , per_periods_of_service pos WHERE bnd.type = 'LOW' AND months_between(tim.start_date, pos.date_start) >= bnd.band_min_value AND ( months_between(tim.start_date, pos.date_start) < bnd.band_max_value OR bnd.band_max_value IS NULL ) AND ( pos.actual_termination_date IS NULL OR tim.report_date <= pos.actual_termination_date ) UNION ALL SELECT months_between(tim.report_date,pop.date_start)/12 low_in_years , months_between(tim.report_date,pop.date_start) low_in_months , tim.report_date - pop.date_start low_in_days , bnd.band_min_value low_band_min_value , bnd.band_max_value low_band_max_value /* Bridge Ids */ , pop.person_id person_id , bnd.band_min_value low_band_id , tim.report_date effective_start_date , tim.report_date effective_end_date , tim.report_date effective_date /* Other Information */ , pop.date_start person_start_date /* Parent Ids */ , -1 period_of_service_id , pop.period_of_placement_id period_of_placement_id , 'N' emp_flag_code , 'Y' cwk_flag_code , pop.business_group_id business_group_id FROM hri_time_bands bnd , hri_time_day tim , per_periods_of_placement pop WHERE bnd.type = 'LOW' AND months_between(tim.start_date, pop.date_start) >= bnd.band_min_value AND ( months_between(tim.start_date, pop.date_start) < bnd.band_max_value OR bnd.band_max_value IS NULL ) AND ( pop.actual_termination_date IS NULL OR tim.report_date <= pop.actual_termination_date ) WITH READ ONLY

View Text - HTML Formatted

SELECT MONTHS_BETWEEN(TIM.REPORT_DATE
, POS.DATE_START)/12 LOW_IN_YEARS
, MONTHS_BETWEEN(TIM.REPORT_DATE
, POS.DATE_START) LOW_IN_MONTHS
, TIM.REPORT_DATE - POS.DATE_START LOW_IN_DAYS
, BND.BAND_MIN_VALUE LOW_BAND_MIN_VALUE
, BND.BAND_MAX_VALUE LOW_BAND_MAX_VALUE /* BRIDGE IDS */
, POS.PERSON_ID PERSON_ID
, BND.BAND_MIN_VALUE LOW_BAND_ID
, TIM.REPORT_DATE EFFECTIVE_START_DATE
, TIM.REPORT_DATE EFFECTIVE_END_DATE
, TIM.REPORT_DATE EFFECTIVE_DATE /* OTHER INFORMATION */
, POS.DATE_START PERSON_START_DATE /* PARENT IDS */
, POS.PERIOD_OF_SERVICE_ID PERIOD_OF_SERVICE_ID
, -1 PERIOD_OF_PLACEMENT_ID
, 'Y' EMP_FLAG_CODE
, 'N' CWK_FLAG_CODE
, POS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM HRI_TIME_BANDS BND
, HRI_TIME_DAY TIM
, PER_PERIODS_OF_SERVICE POS
WHERE BND.TYPE = 'LOW'
AND MONTHS_BETWEEN(TIM.START_DATE
, POS.DATE_START) >= BND.BAND_MIN_VALUE
AND ( MONTHS_BETWEEN(TIM.START_DATE
, POS.DATE_START) < BND.BAND_MAX_VALUE OR BND.BAND_MAX_VALUE IS NULL )
AND ( POS.ACTUAL_TERMINATION_DATE IS NULL OR TIM.REPORT_DATE <= POS.ACTUAL_TERMINATION_DATE ) UNION ALL SELECT MONTHS_BETWEEN(TIM.REPORT_DATE
, POP.DATE_START)/12 LOW_IN_YEARS
, MONTHS_BETWEEN(TIM.REPORT_DATE
, POP.DATE_START) LOW_IN_MONTHS
, TIM.REPORT_DATE - POP.DATE_START LOW_IN_DAYS
, BND.BAND_MIN_VALUE LOW_BAND_MIN_VALUE
, BND.BAND_MAX_VALUE LOW_BAND_MAX_VALUE /* BRIDGE IDS */
, POP.PERSON_ID PERSON_ID
, BND.BAND_MIN_VALUE LOW_BAND_ID
, TIM.REPORT_DATE EFFECTIVE_START_DATE
, TIM.REPORT_DATE EFFECTIVE_END_DATE
, TIM.REPORT_DATE EFFECTIVE_DATE /* OTHER INFORMATION */
, POP.DATE_START PERSON_START_DATE /* PARENT IDS */
, -1 PERIOD_OF_SERVICE_ID
, POP.PERIOD_OF_PLACEMENT_ID PERIOD_OF_PLACEMENT_ID
, 'N' EMP_FLAG_CODE
, 'Y' CWK_FLAG_CODE
, POP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM HRI_TIME_BANDS BND
, HRI_TIME_DAY TIM
, PER_PERIODS_OF_PLACEMENT POP
WHERE BND.TYPE = 'LOW'
AND MONTHS_BETWEEN(TIM.START_DATE
, POP.DATE_START) >= BND.BAND_MIN_VALUE
AND ( MONTHS_BETWEEN(TIM.START_DATE
, POP.DATE_START) < BND.BAND_MAX_VALUE OR BND.BAND_MAX_VALUE IS NULL )
AND ( POP.ACTUAL_TERMINATION_DATE IS NULL OR TIM.REPORT_DATE <= POP.ACTUAL_TERMINATION_DATE ) WITH READ ONLY