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(5,0) INTEGER NOT NULL Page Nbr
    6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
    7 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line Nbr
    8 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    9 CTX_CLASS Character(1) VARCHAR2(1) NOT NULL Canadian Tax Class.
    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
    L=CPP Second Addition EE
    M=CPP Second Addition ER
    N=Quebec Bonus Tax
    P=Canada Pension Plan
    Q=Quebec Pension Plan
    R=Employer EI Premium
    S=QPP Second Addition EE
    T=Payroll Tax
    U=QPP Second Addition ER
    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
    12 PU_SOURCE Character(2) VARCHAR2(2) NOT NULL Paysheet update source.
    AM=Absence Management
    ER=Recruiting Interface
    EX=Expense Interface
    IM=SIM Interface
    OT=Other Sources
    PL=Lifetime Balance Payout USF
    RP=Rapid Paysheets
    SP=Stock Admin - ESPP Refunds
    ST=Stock Admin - Options & ESPP
    VC=Variable Compensation
    VF=Bonus from Fusion
    WI=What-If