CAN_TAX_HLCLASS

(SQL Table)
Index Back

Tax Class (Canada)

Tax Class (Canada).

  • Parent record: CAN_TAX_TYPE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TAX_TYPE_CAN Character(4) VARCHAR2(4) NOT NULL Tax Type
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 TAX_CLASS_CAN Character(3) VARCHAR2(3) NOT NULL Tax Class
    ALL=Total Gross
    CBT=Canadian Bonus Tax
    CIT=Canadian Income Tax (T4)
    CP2=CPP Second Additional Employee
    CPA=Pension Adjustment
    CPP=Canada Pension Plan Employee
    CPR=Canada Pension Plan Employer
    CR2=CPP Second Additional Employer
    EIE=Employment Insurance Employee
    EIR=Employment Insurance Employer
    HTX=Provincial Health Tax
    PYT=Payroll Tax
    QBT=Quebec Bonus Tax
    QCD=Quebec Tax Deduction
    QIE=Quebec Parental Plan Employee
    QIR=Quebec Parental Plan Employer
    QIT=Quebec Income Tax (RL-1)
    QP2=QPP Second Additional Employee
    QPP=Quebec Pension Plan Employee
    QPR=Quebec Pension Plan Employer
    QR2=QPP Second Additional Employer
    RV2=Quebec Income Tax (RL-2)
    T4A=Canadian Income Tax (T4A)
    TRV=True RL
    TT4=True T4

    Prompt Table: CAN_TAX_HLT_VW