WGLS_EXP_GL_ACC

(SQL Table)
Index Back

Wage Loss Plan Exp Accts

Unemployement contribution expense general ledger account codes by Wage Loss Plan.

  • Parent record: WAGELS_PLAN_TBL
  • # 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
    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)
    CPA=Pension Adjustment
    CPP=Canada Pension Plan Employee
    CPR=Canada Pension Plan 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)
    QPP=Quebec Pension Plan Employee
    QPR=Quebec Pension Plan Employer
    RV2=Quebec Income Tax (RL-2)
    T4A=Canadian Income Tax (T4A)
    TRV=True RL
    TT4=True T4
    5 GL_NBR Character(35) VARCHAR2(35) NOT NULL GL Account #