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(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
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