HP_CTX_ACCT_DTL

(SQL Table)
Index Back

Canadian Tax Account Detail

Specify ACCOUNT per company and wage loss plan at the tax class level.

  • Parent record: HP_CTX_ACCT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 WAGE_LOSS_PLAN Character(3) VARCHAR2(3) NOT NULL Wage Loss Replacement Plan

    Prompt Table: WAGELS_PLAN_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 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
    5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    6 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCOUNT_TBL