CAN_TAX_TBL

(SQL Table)
 Index Back

CAN Federal Tax Table

Tax formula parameters for Canadian federal income tax calculations.

  • Parent Record Of CAN_TAX_CITLUMP CAN_TAX_CITRATE CAN_TAX_PROV CAN_TAX_PROV_AB CAN_TAX_PROV_BC CAN_TAX_PROV_MB CAN_TAX_PROV_NB CAN_TAX_PROV_NF CAN_TAX_PROV_NN CAN_TAX_PROV_NS CAN_TAX_PROV_NT CAN_TAX_PROV_ON CAN_TAX_PROV_PE CAN_TAX_PROV_QC CAN_TAX_PROV_SK CAN_TAX_PROV_YT CAN_TAX_PROV_ZZ CAN_TAX_QITLUMP CAN_TAX_QITRATE CAN_USR_TAX_PRV

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

    Default Value: %date

    2 CPP_MAX_EARNS Number(10,2) DECIMAL(9,2) NOT NULL Max Annl Pensionable Earnings
    3 CPP_BASIC_EXEM Number(8,2) DECIMAL(7,2) NOT NULL Basic Annual Exemption Amount
    4 CPP_EE_PCT Number(6,3) DECIMAL(5,3) NOT NULL Employee Contribution Percent
    5 CPP_MIN_AGE Number(3,0) SMALLINT NOT NULL Minimum Age
    6 CPP_MAX_AGE Number(3,0) SMALLINT NOT NULL Maximum Age
    7 UI_EE_PREMIUM_PCT Number(8,5) DECIMAL(7,5) NOT NULL Employee Premium Percent
    8 UI_STD_ER_PREM_RT Number(6,4) DECIMAL(5,4) NOT NULL Standard Employer Premium Rate
    9 UI_MAX_ANNL_EARNS Number(10,2) DECIMAL(9,2) NOT NULL Max Annual Insurable Earnings
    10 UI_MIN_WKLY_HOURS Number(6,3) DECIMAL(5,3) NOT NULL Minimum Hours Per Week
    11 UI_PCT_MAX_EARNS Number(6,3) DECIMAL(5,3) NOT NULL % of Max Insurable Earnings
    12 UI_MAX_AGE Number(3,0) SMALLINT NOT NULL Maximum Age
    13 QIT_H_DED_RT Number(6,5) DECIMAL(5,5) NOT NULL Deduction for Employment Rate
    14 QIT_H_DED_MAX Number(8,2) DECIMAL(7,2) NOT NULL Deduction for Employment Max
    15 QIT_CUM_TX_CREDIT Number(6,5) DECIMAL(5,5) NOT NULL Cumulative Net Claim Credit Rt
    16 MR19V_BASIC_AMT Number(8,2) DECIMAL(7,2) NOT NULL Quebec Basic Amount
    17 CIT_T3 Number(10,2) DECIMAL(9,2) NOT NULL Annual Basic Federal Tax (T3)
    18 CIT_ANN_BASIC_RT Number(6,5) DECIMAL(5,5) NOT NULL Basic Rate (Annualized)
    19 CIT_ANN_EXCESS_RT Number(6,5) DECIMAL(5,5) NOT NULL Excess Rate (Annualized)
    20 CIT_CUM_BASIC_RT Number(6,5) DECIMAL(5,5) NOT NULL Basic Rate (Cumulative)
    21 CIT_CUM_EXCESS_RT Number(6,5) DECIMAL(5,5) NOT NULL Excess Rate (Cumulative)
    22 TD1_BASIC_AMT Number(8,2) DECIMAL(7,2) NOT NULL TD1 Basic Amount
    23 GST_PCT Number(5,2) DECIMAL(4,2) NOT NULL Goods and Services Tax Percent
    24 WGE_CLAIM_PROT_PCT Number(6,3) DECIMAL(5,3) NOT NULL Wage Claim Protection Percent
    25 LCF_MAX Number(8,2) DECIMAL(7,2) NOT NULL Labour Sponsd Funds Tx Cred Mx
    26 LCF_RT Number(6,5) DECIMAL(5,5) NOT NULL Labour Sponsd Funds Tx Cred Rt
    27 QPP_EE_PCT Number(6,3) DECIMAL(5,3) NOT NULL Employee Contribution Percent
    28 QPP_BASIC_EXEM Number(8,2) DECIMAL(7,2) NOT NULL Basic Annual Exemption Amount
    29 QPP_MAX_AGE Number(3,0) SMALLINT NOT NULL Maximum Age
    30 QPP_MAX_EARNS Number(10,2) DECIMAL(9,2) NOT NULL Max Annl Pensionable Earnings
    31 QPP_MIN_AGE Number(3,0) SMALLINT NOT NULL Minimum Age
    32 QEI_EE_PREMIUM_PCT Number(8,5) DECIMAL(7,5) NOT NULL Employee Premium Percent
    33 QEI_MAX_AGE Number(3,0) SMALLINT NOT NULL Maximum Age
    34 QEI_MAX_ANNL_EARNS Number(10,2) DECIMAL(9,2) NOT NULL Max Annual Insurable Earnings
    35 QEI_MIN_WKLY_HOURS Number(6,3) DECIMAL(5,3) NOT NULL Minimum Hours Per Week
    36 QEI_PCT_MAX_EARNS Number(6,3) DECIMAL(5,3) NOT NULL % of Max Insurable Earnings
    37 QEI_STD_ER_PREM_RT Number(6,4) DECIMAL(5,4) NOT NULL Quebec EI Employer Rate
    38 CIT_F_FACTOR Number(10,2) DECIMAL(9,2) NOT NULL RPP/RRSP Limit (F Factor)
    39 PRESCRIBED_INT_PCT Number(6,3) DECIMAL(5,3) NOT NULL Prescribed Interest Percent
    40 QPIP_EE_PREM_PCT Number(8,5) DECIMAL(7,5) NOT NULL QPIP Employee Premium Percent
    41 QPIP_ER_PREM_PCT Number(8,5) DECIMAL(7,5) NOT NULL QPIP Employer Premium Percent
    42 QPIP_MAX_ANNL_EARN Number(10,2) DECIMAL(9,2) NOT NULL QPIP Max Insurable Earnings