GL_CPP_EE_X_VW

(SQL View)
Index Back

GL_CPP_EE_EXP view

GL_CPP_EE_EXP view for Canadian Chartfield Distribution

SELECT COMPANY, WAGE_LOSS_PLAN, EFFDT, TAX_CLASS_CAN, GL_NBR FROM PS_WGLS_EXP_GL_ACC WHERE TAX_CLASS_CAN = 'CPP'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 WAGE_LOSS_PLAN Character(3) VARCHAR2(3) NOT NULL Wage Loss Replacement Plan
3 EFFDT Date(10) DATE Effective Date
4 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
5 GL_NBR Character(35) VARCHAR2(35) NOT NULL GL Account #