SSF_CAN_TAX_BAL (SQL View)	Index Back
EE CAN Tax Balance Student Financials Product View of Payroll - North America record CAN_TAX_BALANCE. View is used by SF to interface with PNA data for Canadian Tax Balances.

SSF_CAN_TAX_BAL

(SQL View)

EE CAN Tax Balance

Student Financials Product View of Payroll - North America record CAN_TAX_BALANCE. View is used by SF to interface with PNA data for Canadian Tax Balances.

SELECT EMPLID ,COMPANY ,BALANCE_ID ,BALANCE_YEAR ,WAGE_LOSS_PLAN ,PROVINCE ,BALANCE_QTR ,BALANCE_PERIOD ,TAX_CLASS_CAN ,NLGRS_YTD ,NLGRS_QTD ,NLGRS_MTD ,TXGRS_YTD ,TXGRS_QTD ,TXGRS_MTD ,TAX_YTD ,TAX_QTD ,TAX_MTD FROM PS_CAN_TAX_BALANCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: HCR_PERSON_I

2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: HCR_COMPANY_I

3 BALANCE_ID Character(2) VARCHAR2(2) NOT NULL Balance ID
Prompt Table: SSF_BAL_ID_TBL

4 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year
Prompt Table: SSF_BAL_ID_DEF

5 WAGE_LOSS_PLAN Character(3) VARCHAR2(3) NOT NULL Wage Loss Replacement Plan
Prompt Table: SSF_WAGELS_PLN

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

7 BALANCE_QTR Number(3,0) SMALLINT NOT NULL Balances for Quarter
Prompt Table: SSF_BAL_ID_QTR

8 BALANCE_PERIOD Number(3,0) SMALLINT NOT NULL Balances for Period
Prompt Table: SSF_BAL_ID_DEF

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 NLGRS_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL No Limit Gross YTD

11 NLGRS_QTD Signed Number(12,2) DECIMAL(10,2) NOT NULL No Limit Gross QTD

12 NLGRS_MTD Signed Number(12,2) DECIMAL(10,2) NOT NULL No Limit Gross MTD

13 TXGRS_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Taxable Gross YTD

14 TXGRS_QTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Taxable Gross QTD

15 TXGRS_MTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Taxable Gross MTD

16 TAX_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax YTD

17 TAX_QTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax QTD

18 TAX_MTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax MTD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: HCR_PERSON_I
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: HCR_COMPANY_I
3	BALANCE_ID	Character(2)	VARCHAR2(2) NOT NULL	Balance ID Prompt Table: SSF_BAL_ID_TBL
4	BALANCE_YEAR	Number(4,0)	SMALLINT NOT NULL	Balances for Year Prompt Table: SSF_BAL_ID_DEF
5	WAGE_LOSS_PLAN	Character(3)	VARCHAR2(3) NOT NULL	Wage Loss Replacement Plan Prompt Table: SSF_WAGELS_PLN
6	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province
7	BALANCE_QTR	Number(3,0)	SMALLINT NOT NULL	Balances for Quarter Prompt Table: SSF_BAL_ID_QTR
8	BALANCE_PERIOD	Number(3,0)	SMALLINT NOT NULL	Balances for Period Prompt Table: SSF_BAL_ID_DEF
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	NLGRS_YTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	No Limit Gross YTD
11	NLGRS_QTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	No Limit Gross QTD
12	NLGRS_MTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	No Limit Gross MTD
13	TXGRS_YTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Taxable Gross YTD
14	TXGRS_QTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Taxable Gross QTD
15	TXGRS_MTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Taxable Gross MTD
16	TAX_YTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Tax YTD
17	TAX_QTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Tax QTD
18	TAX_MTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Tax MTD