TC_MAP_TAXC_TAO

(SQL Table)
Index Back

Comp Mapping for Benefits

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number
4 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
5 COMPENSATION_ID Character(10) VARCHAR2(10) NOT NULL Compensation ID

Prompt Table: TC_COMP_DEFN

6 TC_COMP_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Compensation Source
7 TAX_CLASS_CAN Character(3) VARCHAR2(3) NOT NULL Canadian Tax Class
ALL=Total Gross
CBT=Canadian Bonus Tax
CIT=Canadian Income Tax (T4)
CPA=Pension Adjustment
CPP=Canada Pension Plan Employee
CPR=Canada Pension Plan 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)
QPP=Quebec Pension Plan Employee
QPR=Quebec Pension Plan Employer
RV2=Quebec Income Tax (RL-2)
T4A=Canadian Income Tax (T4A)
TRV=True RL
TT4=True T4
8 GROSSUP Character(1) VARCHAR2(1) NOT NULL Gross-Up