PAY_NA_CTX_E_VW (SQL View)	Index Back
NA Payroll Dist Cdn Tax Exp Vw NA Payroll Distribution Canadian Tax Expense View

PAY_NA_CTX_E_VW

(SQL View)

NA Payroll Dist Cdn Tax Exp Vw

NA Payroll Distribution Canadian Tax Expense View

SELECT A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.SEPCHK , A.PROVINCE , A.TAX_CLASS_CAN , A.ACCT_CD , A.SEQNO , A.ADDL_NBR , A.ERNCD , A.TAX_CUR FROM PS_PAY_NA_CTX_DIST A WHERE A.PY_LIABEXPFLG = 'E'

# 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(4,0) SMALLINT NOT NULL Page #

6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #

7 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.

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

9 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

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

11 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

12 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line #

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

14 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(4,0)	SMALLINT NOT NULL	Page #
6	LINE_NUM	Number(2,0)	SMALLINT NOT NULL	Line #
7	SEPCHK	Number(1,0)	SMALLINT NOT NULL	Separate check number.
8	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province
9	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
10	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code Prompt Table: ACCT_CD_TBL
11	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
12	ADDL_NBR	Number(3,0)	SMALLINT NOT NULL	Additional Pay Line #
13	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
14	TAX_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Tax