PAY_CTX_OVRD

(SQL Table)
Index Back

CAN Payroll Tax Override

This record contains one-time Canadian tax overrides for employee paycheck processing

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

    Prompt Table: COMPANY_TBL

    2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date

    Prompt Table: PAY_CALENDAR

    4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

    Y/N Table Edit

    5 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
    6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
    7 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line #
    8 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
    9 CTX_CLASS Character(1) VARCHAR2(1) NOT NULL Canadian Tax Type
    A=Canadian Income Tax (T4A)
    B=Canadian Bonus Tax
    C=Canadian Income Tax (T4)
    E=Employee EI Premium
    H=Health Tax
    I=Quebec Income Tax
    J=Quebec Parental Insurance - EE
    K=Quebec Parental Insurance - ER
    N=Quebec Bonus Tax
    P=Canada Pension Plan
    Q=Quebec Pension Plan
    R=Employer EI Premium
    T=Payroll Tax
    V=Quebec Income Tax (RL-2)
    X=Take No CPP/QPP Exemption
    Y=Canadian Pension Plan - ER
    Z=Quebec Pension Plan - ER
    10 ONE_TIME_CD Character(1) VARCHAR2(1) NOT NULL PaySheet One-Time Code
    A=Addition
    O=Override
    P=Arrears Payback
    R=Refund

    Default Value: O

    11 TAX_AMT Number(11,2) DECIMAL(10,2) NOT NULL One-Time Tax Amount