WRK_CTX_OVRD

(SQL Table)
Index Back

Work Record - CAN Tax Override

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

# 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
11 TAX_AMT Number(11,2) DECIMAL(10,2) NOT NULL One-Time Tax Amount