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: HR.PAY_GB_YEAR_END_PAYROLLS#

Source

View Text - Preformatted


select PAYROLL_ID PAYROLL_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ECON ECON, EMPLOYERS_ADDRESS_LINE EMPLOYERS_ADDRESS_LINE, EMPLOYERS_NAME EMPLOYERS_NAME, END_PREVIOUS_YEAR END_PREVIOUS_YEAR, END_YEAR END_YEAR, MAX_PERIOD_NUMBER MAX_PERIOD_NUMBER, PAYROLL_NAME PAYROLL_NAME, PERIOD_TYPE PERIOD_TYPE, PERMIT_NUMBER PERMIT_NUMBER, SMP_COMPENSATION SMP_COMPENSATION, SMP_RECOVERED SMP_RECOVERED, SSP_RECOVERED SSP_RECOVERED, START_PREVIOUS_YEAR START_PREVIOUS_YEAR, START_YEAR START_YEAR, TAX_DISTRICT_NAME TAX_DISTRICT_NAME, TAX_DISTRICT_REFERENCE TAX_DISTRICT_REFERENCE, TAX_REFERENCE_NUMBER TAX_REFERENCE_NUMBER, TAX_YEAR TAX_YEAR from "HR"."PAY_GB_YEAR_END_PAYROLLS"

View Text - HTML Formatted

SELECT PAYROLL_ID PAYROLL_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ECON ECON
, EMPLOYERS_ADDRESS_LINE EMPLOYERS_ADDRESS_LINE
, EMPLOYERS_NAME EMPLOYERS_NAME
, END_PREVIOUS_YEAR END_PREVIOUS_YEAR
, END_YEAR END_YEAR
, MAX_PERIOD_NUMBER MAX_PERIOD_NUMBER
, PAYROLL_NAME PAYROLL_NAME
, PERIOD_TYPE PERIOD_TYPE
, PERMIT_NUMBER PERMIT_NUMBER
, SMP_COMPENSATION SMP_COMPENSATION
, SMP_RECOVERED SMP_RECOVERED
, SSP_RECOVERED SSP_RECOVERED
, START_PREVIOUS_YEAR START_PREVIOUS_YEAR
, START_YEAR START_YEAR
, TAX_DISTRICT_NAME TAX_DISTRICT_NAME
, TAX_DISTRICT_REFERENCE TAX_DISTRICT_REFERENCE
, TAX_REFERENCE_NUMBER TAX_REFERENCE_NUMBER
, TAX_YEAR TAX_YEAR
FROM "HR"."PAY_GB_YEAR_END_PAYROLLS"