PAY_NA_CTX_D_VW (SQL View)	Index Back
Can Tax Distribution NA Payroll Distribution - Canadian Tax liability

PAY_NA_CTX_D_VW

(SQL View)

Can Tax Distribution

NA Payroll Distribution - Canadian Tax liability

SELECT A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.ADDL_NBR , A.SEPCHK , A.PROVINCE , A.TAX_CLASS_CAN , A.PY_LIABEXPFLG , A.ERNCD , A.ACCT_CD , B.BUSINESS_UNIT , B.EMPLID , B.EMPL_RCD , B.DEPTID , B.POSITION_NBR , B.JOBCODE , A.ACCOUNT , A.TAX_CUR FROM PS_PAY_NA_CTX_DIST A , PS_PAY_NA_EARNINGS B WHERE A.COMPANY = B.COMPANY AND A.PAYGROUP = B.PAYGROUP AND A.PAY_END_DT = B.PAY_END_DT AND A.OFF_CYCLE = B.OFF_CYCLE AND A.PAGE_NUM = B.PAGE_NUM AND A.LINE_NUM = B.LINE_NUM AND A.ADDL_NBR = B.ADDL_NBR AND A.SEPCHK = B.SEPCHK AND A.ERNCD = B.ERNCD AND A.PY_LIABEXPFLG IN ('L','R')

# 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

4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

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 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province

10 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

11 PY_LIABEXPFLG Character(1) VARCHAR2(1) NOT NULL Liability / Expense Flag
E=GL Expense
L=GL Liability
R=GL Employer's Liability

12 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

13 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
Prompt Table: ACCT_CD_TBL

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

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

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

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

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

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

20 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

21 TAX_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Tax

#	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
4	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?
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	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province
10	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
11	PY_LIABEXPFLG	Character(1)	VARCHAR2(1) NOT NULL	Liability / Expense Flag E=GL Expense L=GL Liability R=GL Employer's Liability
12	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
13	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code Prompt Table: ACCT_CD_TBL
14	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
15	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
16	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
17	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
18	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
19	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
20	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
21	TAX_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Tax