PYGL_CF_CTX_VW (SQL View)	Index Back
CDN Tax GL ChartField View View for Canadian Tax GL ChartField

PYGL_CF_CTX_VW

(SQL View)

CDN Tax GL ChartField View

View for Canadian Tax GL ChartField

SELECT A.COMPANY , A.BUSINESS_UNIT , A.COMPANY_LEVEL_INDC , A.DEPTID , A.JOBCODE , A.POSITION_NBR , A.EMPLID , A.EMPL_RCD , B.PYGL_GROUPNAME , C.STATE , C.WAGE_LOSS_PLAN , C.PYGL_TAX_CLASS , A.EFFDT , C.EFFDT , A.EFF_STATUS , B.ACCT_CD FROM PS_PYGL_CF_CPNYLEV A , PS_PYGL_CF_CPNYCTX B , PS_PYGL_ACTIVTAXMP C WHERE A.COMPANY = B.COMPANY AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.DEPTID = B.DEPTID AND A.JOBCODE = B.JOBCODE AND A.POSITION_NBR = B.POSITION_NBR AND A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EFFDT = B.EFFDT AND B.COMPANY = C.COMPANY AND B.PYGL_GROUPNAME = C.PYGL_GROUPNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 COMPANY_LEVEL_INDC Character(1) VARCHAR2(1) NOT NULL Mapping Level Indicator for Expense Mapping
A=Employee Level
C=Company Level
D=Department Level
J=Job Code Level
P=Position Level

4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

5 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

6 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

8 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

9 PYGL_GROUPNAME Character(30) VARCHAR2(30) NOT NULL GL Group Name

10 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province

11 WAGE_LOSS_PLAN Character(3) VARCHAR2(3) NOT NULL Wage Loss Replacement Plan

12 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

13 EFFDT Date(10) DATE Effective Date
Default Value: %date

14 EFFDT_GL_MAP Date(10) DATE Effective Date of GL Activity Mapping

15 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

16 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	COMPANY_LEVEL_INDC	Character(1)	VARCHAR2(1) NOT NULL	Mapping Level Indicator for Expense Mapping A=Employee Level C=Company Level D=Department Level J=Job Code Level P=Position Level
4	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
5	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
6	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
9	PYGL_GROUPNAME	Character(30)	VARCHAR2(30) NOT NULL	GL Group Name
10	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province
11	WAGE_LOSS_PLAN	Character(3)	VARCHAR2(3) NOT NULL	Wage Loss Replacement Plan
12	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
13	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
14	EFFDT_GL_MAP	Date(10)	DATE	Effective Date of GL Activity Mapping
15	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
16	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code