VIEW: HR.PAY_IE_TAX_BODY_INTERFACE#

Source

View Text - Preformatted

select RECORD_TYPE RECORD_TYPE, PROCESS_FLAG PROCESS_FLAG, PPS_NUMBER PPS_NUMBER, EMPLOYER_NUMBER EMPLOYER_NUMBER, WK_RATE_CUTOFF WK_RATE_CUTOFF, WORKS_NUMBER WORKS_NUMBER, MTH_TAX_CREDIT MTH_TAX_CREDIT, MTH_RATE_CUTOFF MTH_RATE_CUTOFF, WK_TAX_CREDIT WK_TAX_CREDIT, CERT_START_DATE CERT_START_DATE, CERT_END_DATE CERT_END_DATE, WK_MTH_INDICATOR WK_MTH_INDICATOR, CERT_DATE CERT_DATE, LAST_NAME LAST_NAME, FIRST_NAME FIRST_NAME, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, ADDRESS_LINE3 ADDRESS_LINE3, PROCESSED_FLAG PROCESSED_FLAG, PROCESSED_DATE PROCESSED_DATE, TOT_PAY_TO_DATE TOT_PAY_TO_DATE, TOT_TAX_TO_DATE TOT_TAX_TO_DATE, EXEMPTION_INDICATOR EXEMPTION_INDICATOR, STD_RATE_OF_TAX STD_RATE_OF_TAX, HIGHER_RATE_OF_TAX HIGHER_RATE_OF_TAX, CD_YRLY_TAX_CRED CD_YRLY_TAX_CRED, CD_YRLY_TAX_RATE_1 CD_YRLY_TAX_RATE_1, CD_YRLY_TAX_RATE_2 CD_YRLY_TAX_RATE_2, CD_MTHLY_TAX_RATE_2 CD_MTHLY_TAX_RATE_2, CD_WKLY_TAX_RATE_2 CD_WKLY_TAX_RATE_2, CD_TAX_RATE_3 CD_TAX_RATE_3, CD_YRLY_TAX_RATE_3 CD_YRLY_TAX_RATE_3, CD_MTHLY_TAX_RATE_3 CD_MTHLY_TAX_RATE_3, CD_WKLY_TAX_RATE_3 CD_WKLY_TAX_RATE_3, CD_TAX_RATE_4 CD_TAX_RATE_4, CD_YRLY_TAX_RATE_4 CD_YRLY_TAX_RATE_4, CD_MTHLY_TAX_RATE_4 CD_MTHLY_TAX_RATE_4, CD_WKLY_TAX_RATE_4 CD_WKLY_TAX_RATE_4, CD_TAX_RATE_5 CD_TAX_RATE_5, IN_EXEMPT_USC IN_EXEMPT_USC, CD_TOTAL_USC_PAY_TODATE CD_TOTAL_USC_PAY_TODATE, CD_TOTAL_USC_TAX_TODATE CD_TOTAL_USC_TAX_TODATE, CD_USC_RATE_1 CD_USC_RATE_1, AM_USC_YRLY_CUTOFF_1 AM_USC_YRLY_CUTOFF_1, AM_USC_MTHLY_CUTOFF_1 AM_USC_MTHLY_CUTOFF_1, AM_USC_WKLY_CUTOFF_1 AM_USC_WKLY_CUTOFF_1, CD_USC_RATE_2 CD_USC_RATE_2, AM_USC_YRLY_CUTOFF_2 AM_USC_YRLY_CUTOFF_2, AM_USC_MTHLY_CUTOFF_2 AM_USC_MTHLY_CUTOFF_2, AM_USC_WKLY_CUTOFF_2 AM_USC_WKLY_CUTOFF_2, CD_USC_RATE_3 CD_USC_RATE_3, AM_USC_YRLY_CUTOFF_3 AM_USC_YRLY_CUTOFF_3, AM_USC_MTHLY_CUTOFF_3 AM_USC_MTHLY_CUTOFF_3, AM_USC_WKLY_CUTOFF_3 AM_USC_WKLY_CUTOFF_3, CD_USC_RATE_4 CD_USC_RATE_4, AM_USC_YRLY_CUTOFF_4 AM_USC_YRLY_CUTOFF_4, AM_USC_MTHLY_CUTOFF_4 AM_USC_MTHLY_CUTOFF_4, AM_USC_WKLY_CUTOFF_4 AM_USC_WKLY_CUTOFF_4, CD_USC_RATE_5 CD_USC_RATE_5 from "HR"."PAY_IE_TAX_BODY_INTERFACE"

View Text - HTML Formatted

SELECT RECORD_TYPE RECORD_TYPE
, PROCESS_FLAG PROCESS_FLAG
, PPS_NUMBER PPS_NUMBER
, EMPLOYER_NUMBER EMPLOYER_NUMBER
, WK_RATE_CUTOFF WK_RATE_CUTOFF
, WORKS_NUMBER WORKS_NUMBER
, MTH_TAX_CREDIT MTH_TAX_CREDIT
, MTH_RATE_CUTOFF MTH_RATE_CUTOFF
, WK_TAX_CREDIT WK_TAX_CREDIT
, CERT_START_DATE CERT_START_DATE
, CERT_END_DATE CERT_END_DATE
, WK_MTH_INDICATOR WK_MTH_INDICATOR
, CERT_DATE CERT_DATE
, LAST_NAME LAST_NAME
, FIRST_NAME FIRST_NAME
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, ADDRESS_LINE3 ADDRESS_LINE3
, PROCESSED_FLAG PROCESSED_FLAG
, PROCESSED_DATE PROCESSED_DATE
, TOT_PAY_TO_DATE TOT_PAY_TO_DATE
, TOT_TAX_TO_DATE TOT_TAX_TO_DATE
, EXEMPTION_INDICATOR EXEMPTION_INDICATOR
, STD_RATE_OF_TAX STD_RATE_OF_TAX
, HIGHER_RATE_OF_TAX HIGHER_RATE_OF_TAX
, CD_YRLY_TAX_CRED CD_YRLY_TAX_CRED
, CD_YRLY_TAX_RATE_1 CD_YRLY_TAX_RATE_1
, CD_YRLY_TAX_RATE_2 CD_YRLY_TAX_RATE_2
, CD_MTHLY_TAX_RATE_2 CD_MTHLY_TAX_RATE_2
, CD_WKLY_TAX_RATE_2 CD_WKLY_TAX_RATE_2
, CD_TAX_RATE_3 CD_TAX_RATE_3
, CD_YRLY_TAX_RATE_3 CD_YRLY_TAX_RATE_3
, CD_MTHLY_TAX_RATE_3 CD_MTHLY_TAX_RATE_3
, CD_WKLY_TAX_RATE_3 CD_WKLY_TAX_RATE_3
, CD_TAX_RATE_4 CD_TAX_RATE_4
, CD_YRLY_TAX_RATE_4 CD_YRLY_TAX_RATE_4
, CD_MTHLY_TAX_RATE_4 CD_MTHLY_TAX_RATE_4
, CD_WKLY_TAX_RATE_4 CD_WKLY_TAX_RATE_4
, CD_TAX_RATE_5 CD_TAX_RATE_5
, IN_EXEMPT_USC IN_EXEMPT_USC
, CD_TOTAL_USC_PAY_TODATE CD_TOTAL_USC_PAY_TODATE
, CD_TOTAL_USC_TAX_TODATE CD_TOTAL_USC_TAX_TODATE
, CD_USC_RATE_1 CD_USC_RATE_1
, AM_USC_YRLY_CUTOFF_1 AM_USC_YRLY_CUTOFF_1
, AM_USC_MTHLY_CUTOFF_1 AM_USC_MTHLY_CUTOFF_1
, AM_USC_WKLY_CUTOFF_1 AM_USC_WKLY_CUTOFF_1
, CD_USC_RATE_2 CD_USC_RATE_2
, AM_USC_YRLY_CUTOFF_2 AM_USC_YRLY_CUTOFF_2
, AM_USC_MTHLY_CUTOFF_2 AM_USC_MTHLY_CUTOFF_2
, AM_USC_WKLY_CUTOFF_2 AM_USC_WKLY_CUTOFF_2
, CD_USC_RATE_3 CD_USC_RATE_3
, AM_USC_YRLY_CUTOFF_3 AM_USC_YRLY_CUTOFF_3
, AM_USC_MTHLY_CUTOFF_3 AM_USC_MTHLY_CUTOFF_3
, AM_USC_WKLY_CUTOFF_3 AM_USC_WKLY_CUTOFF_3
, CD_USC_RATE_4 CD_USC_RATE_4
, AM_USC_YRLY_CUTOFF_4 AM_USC_YRLY_CUTOFF_4
, AM_USC_MTHLY_CUTOFF_4 AM_USC_MTHLY_CUTOFF_4
, AM_USC_WKLY_CUTOFF_4 AM_USC_WKLY_CUTOFF_4
, CD_USC_RATE_5 CD_USC_RATE_5
FROM "HR"."PAY_IE_TAX_BODY_INTERFACE"