HP_FRINGE_CTX

(SQL Table)
Index Back

Canadian Taxes Exclusion

Canadian Taxes excluded for the earnings funding source during distribution

  • Parent record: HP_FRINGE_GROUP
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HP_FRINGE_GROUP Character(5) VARCHAR2(5) NOT NULL Fringe Group
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 TAX_CLASS_CAN Character(3) VARCHAR2(3) NOT NULL Canadian 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