CAN_TAX_PROV_ON

(SQL View)
 Index Back

CAN Provincial Tax Parameters

Calculation formula parameters for income tax surtax and other provincial taxes.

SELECT EFFDT , PROVINCE , CIT_V , CIT_V1A , CIT_V1B , CIT_V2 , CIT_V3 , CIT_V4 , CIT_S , CIT_N1 , CIT_N2 , CIT_NCA , CIT_TH , HEALTH_INS_RT , WCB_LIMIT , PST_PCT , PAYROLL_TAX_RT , PSTI_PCT , LCP_MAX , LCP_RT , HST_PCT , CIT_V1A2 , CIT_V1B2 , HP_STATS_PROV_CD FROM PS_CAN_TAX_PROV WHERE PROVINCE = 'ON'

  • Parent record: CAN_TAX_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    2 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
    3 CIT_V Number(7,5) DECIMAL(6,5) NOT NULL Tax Rate (V)
    4 CIT_V1A Number(7,5) DECIMAL(6,5) NOT NULL Surtax Rate (V1A)
    5 CIT_V1B Number(10,2) DECIMAL(9,2) NOT NULL Threshold Amount (V1A)
    6 CIT_V2 Number(7,5) DECIMAL(6,5) NOT NULL Flat Tax on Net Income (V2)
    7 CIT_V3 Number(7,5) DECIMAL(6,5) NOT NULL Flat Tax on Taxable Income(V3)
    8 CIT_V4 Number(8,2) DECIMAL(7,2) NOT NULL Net Income Tax Surtax (V4)
    9 CIT_S Number(8,2) DECIMAL(7,2) NOT NULL Tax Reduction (S)
    10 CIT_N1 Number(6,4) DECIMAL(5,4) NOT NULL Constant (N1)
    11 CIT_N2 Number(10,2) DECIMAL(9,2) NOT NULL Constant (N2)
    12 CIT_NCA Number(10,2) DECIMAL(9,2) NOT NULL Net Claim Amount Threshold
    13 CIT_TH Number(8,2) DECIMAL(7,2) NOT NULL Threshold Amount (TH)
    14 HEALTH_INS_RT Number(8,6) DECIMAL(7,6) NOT NULL Health Insurance Rate
    15 WCB_LIMIT Number(10,2) DECIMAL(9,2) NOT NULL WCB Limit
    16 PST_PCT Number(6,3) DECIMAL(5,3) NOT NULL Provincial Sales Tax Percent
    17 PAYROLL_TAX_RT Number(6,4) DECIMAL(5,4) NOT NULL Payroll Tax Rate
    18 PSTI_PCT Number(5,2) DECIMAL(4,2) NOT NULL Province Sales Tax - Insurance
    19 LCP_MAX Number(8,2) DECIMAL(7,2) NOT NULL Prov Labour Sponsd Tx Cred Max
    20 LCP_RT Number(6,5) DECIMAL(5,5) NOT NULL Prov Labour Sponsd Tx Cred Rt
    21 HST_PCT Number(5,2) DECIMAL(4,2) NOT NULL Harmonized Sales Tax
    22 CIT_V1A2 Number(7,5) DECIMAL(6,5) NOT NULL Surtax Rate (V1B)
    23 CIT_V1B2 Number(10,2) DECIMAL(9,2) NOT NULL Threshold Amount (V1B)
    24 HP_STATS_PROV_CD Character(5) VARCHAR2(5) NOT NULL Stats Can Province Code

    Default Value: 99999