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

Source

View Text - Preformatted


SELECT pai.action_context_id, pai.tax_unit_id, pai.effective_date, pai.assignment_id, pai.action_information1 Full_Name, pai.action_information2 organization_id, pai.action_information4 national_identifier, pai.action_information5 pay_basis, pai.action_information6 frequency, pai.action_information7 grade, pai.action_information8 bargaining_unit, pai.action_information9 collective_agreement, pai.action_information10 employee_number, pay_ac_util.format_to_date( pai.action_information11) employee_date_start, pay_ac_util.format_to_date(pai.action_information12) original_hire_date, pay_ac_util.format_to_date( pai.action_information13) adjusted_service_date, pai.action_information14 assignment_number, pai.action_information15 organization_name, pai.action_information17 job, pai.action_information18 gre_name, pai.action_information19 position, pai.action_information30 location_name, pai.action_information20 contract, pai.action_information21 working_hours_start, pai.action_information22 working_hours_end, pai.action_information23 pay_calculation_method, pai.action_information24 shift, pai.action_information25 employer_phone_number, pai.action_information26 hourly_salaried_code, pai.action_information27 agreement_grade, to_number(NVL(pai.action_information28,0)) pay_rate, (NVL(pai.action_information28,0) * NVL(pai.action_information29,0)) annual_salary, pai.effective_date payment_date from pay_action_information pai WHERE pai.action_context_type = 'AAP' and pai.action_information_category = 'EMPLOYEE DETAILS' with read only

View Text - HTML Formatted

SELECT PAI.ACTION_CONTEXT_ID
, PAI.TAX_UNIT_ID
, PAI.EFFECTIVE_DATE
, PAI.ASSIGNMENT_ID
, PAI.ACTION_INFORMATION1 FULL_NAME
, PAI.ACTION_INFORMATION2 ORGANIZATION_ID
, PAI.ACTION_INFORMATION4 NATIONAL_IDENTIFIER
, PAI.ACTION_INFORMATION5 PAY_BASIS
, PAI.ACTION_INFORMATION6 FREQUENCY
, PAI.ACTION_INFORMATION7 GRADE
, PAI.ACTION_INFORMATION8 BARGAINING_UNIT
, PAI.ACTION_INFORMATION9 COLLECTIVE_AGREEMENT
, PAI.ACTION_INFORMATION10 EMPLOYEE_NUMBER
, PAY_AC_UTIL.FORMAT_TO_DATE( PAI.ACTION_INFORMATION11) EMPLOYEE_DATE_START
, PAY_AC_UTIL.FORMAT_TO_DATE(PAI.ACTION_INFORMATION12) ORIGINAL_HIRE_DATE
, PAY_AC_UTIL.FORMAT_TO_DATE( PAI.ACTION_INFORMATION13) ADJUSTED_SERVICE_DATE
, PAI.ACTION_INFORMATION14 ASSIGNMENT_NUMBER
, PAI.ACTION_INFORMATION15 ORGANIZATION_NAME
, PAI.ACTION_INFORMATION17 JOB
, PAI.ACTION_INFORMATION18 GRE_NAME
, PAI.ACTION_INFORMATION19 POSITION
, PAI.ACTION_INFORMATION30 LOCATION_NAME
, PAI.ACTION_INFORMATION20 CONTRACT
, PAI.ACTION_INFORMATION21 WORKING_HOURS_START
, PAI.ACTION_INFORMATION22 WORKING_HOURS_END
, PAI.ACTION_INFORMATION23 PAY_CALCULATION_METHOD
, PAI.ACTION_INFORMATION24 SHIFT
, PAI.ACTION_INFORMATION25 EMPLOYER_PHONE_NUMBER
, PAI.ACTION_INFORMATION26 HOURLY_SALARIED_CODE
, PAI.ACTION_INFORMATION27 AGREEMENT_GRADE
, TO_NUMBER(NVL(PAI.ACTION_INFORMATION28
, 0)) PAY_RATE
, (NVL(PAI.ACTION_INFORMATION28
, 0) * NVL(PAI.ACTION_INFORMATION29
, 0)) ANNUAL_SALARY
, PAI.EFFECTIVE_DATE PAYMENT_DATE
FROM PAY_ACTION_INFORMATION PAI
WHERE PAI.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE DETAILS' WITH READ ONLY