PY_CAN_TAX_CALC

(SQL Table)
 Index Back

Canadian Pay Calculation

This is the record to store Canadian Pay Calculation factors, for troubleshooting purposes.

  • Parent record: PAY_LINE

    • # 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

    Prompt Table: PAY_PAGE

    6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr

    Prompt Table: PAY_LINE

    7 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    8 PY_ITERATION Number(3,0) SMALLINT NOT NULL Step in Payroll Calculation.
    9 TAX_METHOD Character(1) VARCHAR2(1) NOT NULL Tax method.
    A=Annualized
    B=Bonus
    C=Cumulative
    G=Aggregate
    L=Lump Sum
    M=Commission
    P=Specified on Paysheet
    S=Supplemental
    X=Special Supplemental
    10 PY_CROSS_PROVINCE Character(1) VARCHAR2(1) NOT NULL Cross Province.

    Y/N Table Edit

    Default Value: N

    11 PAY_PDS_PER_YEAR Number(3,0) SMALLINT NOT NULL Pay Periods Per Year
    12 PY_PAY_PDS_REMAIN Number(3,0) SMALLINT NOT NULL Pay Periods Remaining
    13 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    14 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    15 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
    16 PY_CIT_C2 Signed Number(15,2) DECIMAL(13,2) NOT NULL CIT Second Additional CPP/QPP Contribution.
    17 PY_CIT_F5 Signed Number(15,2) DECIMAL(13,2) NOT NULL Canada Pension Plan additional contributions for the pay period.
    18 PY_CIT_F5A Signed Number(15,2) DECIMAL(13,2) NOT NULL Deductions for Canada (or Quebec) Pension Plan additional contributions for the pay period deducted from the periodic income.
    19 PY_CIT_F5B Signed Number(15,2) DECIMAL(13,2) NOT NULL Deductions for Canada (or Quebec) Pension Plan additional contributions for the pay period deducted from the nonperiodic payment.
    20 PY_CIT_A Signed Number(15,2) DECIMAL(13,2) NOT NULL Annual taxable income.
    21 PY_CBT_TXGRS_CUR Signed Number(15,2) DECIMAL(13,2) NOT NULL Taxable Gross for Bonus calculation - current.
    22 PY_CIT_R Number(7,5) DECIMAL(6,5) NOT NULL CIT Tax Rate.
    23 PY_CIT_K2_PEN Signed Number(15,2) DECIMAL(13,2) NOT NULL CPP/QPP Non-Refundable Tax Credit in K2.
    24 PY_CIT_K2_PU Signed Number(15,2) DECIMAL(13,2) NOT NULL EI Non-refundable Tax Credit in K2.
    25 PY_CIT_K2_PQ Signed Number(15,2) DECIMAL(13,2) NOT NULL QPIP Non-Refundable Tax Credit in K2.
    26 CIT_K Number(10,2) DECIMAL(9,2) NOT NULL Federal Constant (K)
    27 PY_CIT_TAX_CREDITS Signed Number(15,2) DECIMAL(13,2) NOT NULL Annual taxable income.
    28 PY_CIT_K4 Signed Number(15,2) DECIMAL(13,2) NOT NULL Federal non-refundable tax credit calculated using the Canada employment amount (the lowest federal tax rate is used to calculate this credit).
    29 PY_CIT_K1 Signed Number(15,2) DECIMAL(13,2) NOT NULL Annual federal tax deduction.
    30 PY_CIT_T3 Signed Number(15,2) DECIMAL(13,2) NOT NULL Annual basic federal tax.
    31 PIT_V Number(7,5) DECIMAL(6,5) NOT NULL Prov. Tax Rate (V)
    32 PIT_KP Signed Number(11,2) DECIMAL(9,2) NOT NULL Prov. Constant (KP)
    33 PY_CIT_T4 Signed Number(15,2) DECIMAL(13,2) NOT NULL Annual basic provincial or territorial tax.
    34 PY_CIT_T1 Signed Number(15,2) DECIMAL(13,2) NOT NULL Annual federal tax deduction.
    35 PY_CIT_K1P Signed Number(15,2) DECIMAL(13,2) NOT NULL Provincial or territorial non-refundable personal tax credit (the lowest tax rate of the province or territory is used to calculate this credit).
    36 PY_CIT_K2P Signed Number(15,2) DECIMAL(13,2) NOT NULL Provincial or territorial Canada Pension Plan base contributions and employment insurance premiums tax credits for the year (the lowest provincial or territorial tax rate is used to calculate this credit).
    37 PY_CIT_K3P Signed Number(15,2) DECIMAL(13,2) NOT NULL Other provincial or territorial non-refundable tax credits (such as medical expenses and charitable donations) authorized by a tax services office or tax centre
    38 PY_CIT_K4P Signed Number(15,2) DECIMAL(13,2) NOT NULL Territorial non-refundable tax credit calculated using the provincial or territorial Canada employment amount (the lowest territorial tax rate is used to calculate this credit).
    39 PY_CIT_T2 Signed Number(15,2) DECIMAL(13,2) NOT NULL Annual provincial or territorial tax deduction (except Quebec).
    40 PY_CIT Signed Number(15,2) DECIMAL(13,2) NOT NULL Canadian Income Tax (T4).
    41 PY_QIT_CSA Signed Number(15,2) DECIMAL(13,2) NOT NULL Additional employee QPP contributions on the employee�s gross pensionable income for the pay period, excluding gratuities, retroactive pay or similar lump-sum payments.
    42 PY_QIT_CSB Signed Number(15,2) DECIMAL(13,2) NOT NULL Additional employee QPP contributions on gratuities, retroactive pay or similar lump-sum payments during the pay period.
    43 PY_QIT_I Signed Number(15,2) DECIMAL(13,2) NOT NULL Annual taxable income.
    44 PY_QBT_TXGRS_CUR Signed Number(15,2) DECIMAL(13,2) NOT NULL Taxable Gross for Bonus calculation - current.
    45 PY_QIT Signed Number(15,2) DECIMAL(13,2) NOT NULL Quebec Income Tax (RL-1).