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.HRBV_PERIOD_OF_SERVICE

Source

View Text - Preformatted


SELECT pps.date_start date_start ,pps.accepted_termination_date accepted_termination_date ,pps.actual_termination_date actual_termination_date ,pps.comments comments ,pps.final_process_date final_process_date ,pps.last_standard_process_date last_standard_process_date ,hr_bis.bis_decode_lookup('LEAV_REAS',pps.leaving_reason) leaving_reason ,pps.notified_termination_date notified_termination_date ,pps.projected_termination_date projected_termination_date ,pps.adjusted_svc_date adjusted_svc_date ,pps.prior_employment_ssp_paid_to prior_employment_ssp_paid_to ,pps.prior_employment_ssp_weeks prior_employment_ssp_weeks ,pps.leaving_reason leaving_reason_code ,pps.pds_information_category pds_information_category ,pps.pds_information1 pds_information1 ,pps.pds_information2 pds_information2 ,pps.pds_information3 pds_information3 ,pps.pds_information4 pds_information4 ,pps.pds_information5 pds_information5 ,pps.pds_information6 pds_information6 ,pps.pds_information7 pds_information7 ,pps.pds_information8 pds_information8 ,pps.pds_information9 pds_information9 ,pps.pds_information10 pds_information10 ,pps.pds_information11 pds_information11 ,pps.pds_information12 pds_information12 ,pps.pds_information13 pds_information13 ,pps.pds_information14 pds_information14 ,pps.pds_information15 pds_information15 ,pps.pds_information16 pds_information16 ,pps.pds_information17 pds_information17 ,pps.pds_information18 pds_information18 ,pps.pds_information19 pds_information19 ,pps.pds_information20 pds_information20 ,pps.pds_information21 pds_information21 ,pps.pds_information22 pds_information22 ,pps.pds_information23 pds_information23 ,pps.pds_information24 pds_information24 ,pps.pds_information25 pds_information25 ,pps.pds_information26 pds_information26 ,pps.pds_information27 pds_information27 ,pps.pds_information28 pds_information28 ,pps.pds_information29 pds_information29 ,pps.pds_information30 pds_information30 ,'_DF:PER:PER_PERIODS_OF_SERVICE:pps' ,hr_api.return_legislation_code(pps.business_group_id) legislation_code ,pps.period_of_service_id period_of_service_id ,pps.business_group_id business_group_id ,pps.termination_accepted_person_id termination_accepted_person_id ,pps.person_id person_id ,pps.last_update_date last_update_date ,pps.last_updated_by last_updated_by ,pps.last_update_login last_update_login ,pps.created_by created_by ,pps.creation_date creation_date ,CASE WHEN (pps.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, pps.business_group_id)) THEN 'Y' ELSE 'N' END bg_Security_flag_code FROM per_periods_of_service pps WITH READ ONLY

View Text - HTML Formatted

SELECT PPS.DATE_START DATE_START
, PPS.ACCEPTED_TERMINATION_DATE ACCEPTED_TERMINATION_DATE
, PPS.ACTUAL_TERMINATION_DATE ACTUAL_TERMINATION_DATE
, PPS.COMMENTS COMMENTS
, PPS.FINAL_PROCESS_DATE FINAL_PROCESS_DATE
, PPS.LAST_STANDARD_PROCESS_DATE LAST_STANDARD_PROCESS_DATE
, HR_BIS.BIS_DECODE_LOOKUP('LEAV_REAS'
, PPS.LEAVING_REASON) LEAVING_REASON
, PPS.NOTIFIED_TERMINATION_DATE NOTIFIED_TERMINATION_DATE
, PPS.PROJECTED_TERMINATION_DATE PROJECTED_TERMINATION_DATE
, PPS.ADJUSTED_SVC_DATE ADJUSTED_SVC_DATE
, PPS.PRIOR_EMPLOYMENT_SSP_PAID_TO PRIOR_EMPLOYMENT_SSP_PAID_TO
, PPS.PRIOR_EMPLOYMENT_SSP_WEEKS PRIOR_EMPLOYMENT_SSP_WEEKS
, PPS.LEAVING_REASON LEAVING_REASON_CODE
, PPS.PDS_INFORMATION_CATEGORY PDS_INFORMATION_CATEGORY
, PPS.PDS_INFORMATION1 PDS_INFORMATION1
, PPS.PDS_INFORMATION2 PDS_INFORMATION2
, PPS.PDS_INFORMATION3 PDS_INFORMATION3
, PPS.PDS_INFORMATION4 PDS_INFORMATION4
, PPS.PDS_INFORMATION5 PDS_INFORMATION5
, PPS.PDS_INFORMATION6 PDS_INFORMATION6
, PPS.PDS_INFORMATION7 PDS_INFORMATION7
, PPS.PDS_INFORMATION8 PDS_INFORMATION8
, PPS.PDS_INFORMATION9 PDS_INFORMATION9
, PPS.PDS_INFORMATION10 PDS_INFORMATION10
, PPS.PDS_INFORMATION11 PDS_INFORMATION11
, PPS.PDS_INFORMATION12 PDS_INFORMATION12
, PPS.PDS_INFORMATION13 PDS_INFORMATION13
, PPS.PDS_INFORMATION14 PDS_INFORMATION14
, PPS.PDS_INFORMATION15 PDS_INFORMATION15
, PPS.PDS_INFORMATION16 PDS_INFORMATION16
, PPS.PDS_INFORMATION17 PDS_INFORMATION17
, PPS.PDS_INFORMATION18 PDS_INFORMATION18
, PPS.PDS_INFORMATION19 PDS_INFORMATION19
, PPS.PDS_INFORMATION20 PDS_INFORMATION20
, PPS.PDS_INFORMATION21 PDS_INFORMATION21
, PPS.PDS_INFORMATION22 PDS_INFORMATION22
, PPS.PDS_INFORMATION23 PDS_INFORMATION23
, PPS.PDS_INFORMATION24 PDS_INFORMATION24
, PPS.PDS_INFORMATION25 PDS_INFORMATION25
, PPS.PDS_INFORMATION26 PDS_INFORMATION26
, PPS.PDS_INFORMATION27 PDS_INFORMATION27
, PPS.PDS_INFORMATION28 PDS_INFORMATION28
, PPS.PDS_INFORMATION29 PDS_INFORMATION29
, PPS.PDS_INFORMATION30 PDS_INFORMATION30
, '_DF:PER:PER_PERIODS_OF_SERVICE:PPS'
, HR_API.RETURN_LEGISLATION_CODE(PPS.BUSINESS_GROUP_ID) LEGISLATION_CODE
, PPS.PERIOD_OF_SERVICE_ID PERIOD_OF_SERVICE_ID
, PPS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PPS.TERMINATION_ACCEPTED_PERSON_ID TERMINATION_ACCEPTED_PERSON_ID
, PPS.PERSON_ID PERSON_ID
, PPS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PPS.LAST_UPDATED_BY LAST_UPDATED_BY
, PPS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PPS.CREATED_BY CREATED_BY
, PPS.CREATION_DATE CREATION_DATE
, CASE WHEN (PPS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PPS.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_PERIODS_OF_SERVICE PPS WITH READ ONLY