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.

[Home] [Help]

VIEW: HR.PAY_IE_TAX_TRAILER_INTERFACE#

Source

View Text - Preformatted


select RECORD_TYPE RECORD_TYPE, RECORD_ID RECORD_ID, EMPLOYER_NUMBER EMPLOYER_NUMBER, RECORD_NO RECORD_NO, TOTAL_MTH_RATE_CUTOFF TOTAL_MTH_RATE_CUTOFF, TOTAL_WK_RATE_CUTOFF TOTAL_WK_RATE_CUTOFF, TOTAL_MTH_TAX_CREDIT TOTAL_MTH_TAX_CREDIT, TOTAL_WK_TAX_CREDIT TOTAL_WK_TAX_CREDIT, FILLER FILLER, TC_TOT_YEARLY_TAX_CRED TC_TOT_YEARLY_TAX_CRED, TOT_YEARLY_TAX_RATE_1 TOT_YEARLY_TAX_RATE_1, TOT_YEARLY_TAX_RATE_2 TOT_YEARLY_TAX_RATE_2, TOT_MONTHLY_TAX_RATE_2 TOT_MONTHLY_TAX_RATE_2, TOT_WEEKLY_TAX_RATE_2 TOT_WEEKLY_TAX_RATE_2, TOT_YEARLY_TAX_RATE_3 TOT_YEARLY_TAX_RATE_3, TOT_MONTHLY_TAX_RATE_3 TOT_MONTHLY_TAX_RATE_3, TOT_WEEKLY_TAX_RATE_3 TOT_WEEKLY_TAX_RATE_3, TOT_YEARLY_TAX_RATE_4 TOT_YEARLY_TAX_RATE_4, TOT_MONTHLY_TAX_RATE_4 TOT_MONTHLY_TAX_RATE_4, TOT_WEEKLY_TAX_RATE_4 TOT_WEEKLY_TAX_RATE_4, TOT_YEARLY_USC_RATE_1 TOT_YEARLY_USC_RATE_1, TOT_YEARLY_USC_RATE_2 TOT_YEARLY_USC_RATE_2, TOT_YEARLY_USC_RATE_3 TOT_YEARLY_USC_RATE_3, TOT_YEARLY_USC_RATE_4 TOT_YEARLY_USC_RATE_4 from "HR"."PAY_IE_TAX_TRAILER_INTERFACE"

View Text - HTML Formatted

SELECT RECORD_TYPE RECORD_TYPE
, RECORD_ID RECORD_ID
, EMPLOYER_NUMBER EMPLOYER_NUMBER
, RECORD_NO RECORD_NO
, TOTAL_MTH_RATE_CUTOFF TOTAL_MTH_RATE_CUTOFF
, TOTAL_WK_RATE_CUTOFF TOTAL_WK_RATE_CUTOFF
, TOTAL_MTH_TAX_CREDIT TOTAL_MTH_TAX_CREDIT
, TOTAL_WK_TAX_CREDIT TOTAL_WK_TAX_CREDIT
, FILLER FILLER
, TC_TOT_YEARLY_TAX_CRED TC_TOT_YEARLY_TAX_CRED
, TOT_YEARLY_TAX_RATE_1 TOT_YEARLY_TAX_RATE_1
, TOT_YEARLY_TAX_RATE_2 TOT_YEARLY_TAX_RATE_2
, TOT_MONTHLY_TAX_RATE_2 TOT_MONTHLY_TAX_RATE_2
, TOT_WEEKLY_TAX_RATE_2 TOT_WEEKLY_TAX_RATE_2
, TOT_YEARLY_TAX_RATE_3 TOT_YEARLY_TAX_RATE_3
, TOT_MONTHLY_TAX_RATE_3 TOT_MONTHLY_TAX_RATE_3
, TOT_WEEKLY_TAX_RATE_3 TOT_WEEKLY_TAX_RATE_3
, TOT_YEARLY_TAX_RATE_4 TOT_YEARLY_TAX_RATE_4
, TOT_MONTHLY_TAX_RATE_4 TOT_MONTHLY_TAX_RATE_4
, TOT_WEEKLY_TAX_RATE_4 TOT_WEEKLY_TAX_RATE_4
, TOT_YEARLY_USC_RATE_1 TOT_YEARLY_USC_RATE_1
, TOT_YEARLY_USC_RATE_2 TOT_YEARLY_USC_RATE_2
, TOT_YEARLY_USC_RATE_3 TOT_YEARLY_USC_RATE_3
, TOT_YEARLY_USC_RATE_4 TOT_YEARLY_USC_RATE_4
FROM "HR"."PAY_IE_TAX_TRAILER_INTERFACE"