TC_MAP_TAX_CAN

(SQL Table)
Index Back

Comp Mapping for Taxes

Holds Total Compensation Mapping for a Comp ID when the map is based on Tax data.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPENSATION_ID Character(10) VARCHAR2(10) NOT NULL Compensation ID

Prompt Table: TC_COMP_DEFN

2 MAP_BASED Character(1) VARCHAR2(1) NOT NULL Map Based On
D=Benefits and Deductions
E=Earnings
M=Multiple Components
N=No Mapping
T=Taxes - United States
U=Taxes - Canada
V=Variable Compensation
3 TAX_CLASS_CAN Character(3) VARCHAR2(3) NOT NULL Canadian Tax Class
ALL=Total Gross
CBT=Canadian Bonus Tax
CIT=Canadian Income Tax (T4)
CP2=CPP Second Additional Employee
CPA=Pension Adjustment
CPP=Canada Pension Plan Employee
CPR=Canada Pension Plan Employer
CR2=CPP Second Additional Employer
EIE=Employment Insurance Employee
EIR=Employment Insurance Employer
HTX=Provincial Health Tax
PYT=Payroll Tax
QBT=Quebec Bonus Tax
QCD=Quebec Tax Deduction
QIE=Quebec Parental Plan Employee
QIR=Quebec Parental Plan Employer
QIT=Quebec Income Tax (RL-1)
QP2=QPP Second Additional Employee
QPP=Quebec Pension Plan Employee
QPR=Quebec Pension Plan Employer
QR2=QPP Second Additional Employer
RV2=Quebec Income Tax (RL-2)
T4A=Canadian Income Tax (T4A)
TRV=True RL
TT4=True T4
4 GROSSUP Character(1) VARCHAR2(1) NOT NULL Gross-Up

Y/N Table Edit