CAN_YE_RV2_VW (SQL View)	Index Back
Can YE Slip - Releve 2 info View of CAN_YE_SLIP table for online panel displaying Releve 2 slip data only.

CAN_YE_RV2_VW

(SQL View)

Can YE Slip - Releve 2 info

View of CAN_YE_SLIP table for online panel displaying Releve 2 slip data only.

SELECT company ,emplid ,calendar_year ,sequence_number ,taxform_id ,can_ye_slip_seq ,reporting_id ,releve2_slip_no ,provenance ,provenance2 ,sin_contrb_spouse ,name_contrb_spouse ,ye_slip_process FROM PS_CAN_YE_SLIP WHERE taxform_id = 'V'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year

4 SEQUENCE_NUMBER Number(2,0) SMALLINT NOT NULL Sequence Number

5 TAXFORM_ID Character(1) VARCHAR2(1) NOT NULL Tax Form Identification
A=T4A Slip
B=Business Payrolls Survey - CAN
C=WCB Assessable Earnings
E=Record of Employment
F=940 - Annual Employer's FUTA
I=W-2VI
J=W-2cVI
M=W-2GU
N=W-2cGU
P=W-2PR
Q=W-2cPR
R=RL-1 Slip
S=W-2AS
T=T4 Slip
U=W-2cAS
V=RL-2 Slip
W=W-2
X=W-2c

6 CAN_YE_SLIP_SEQ Number(2,0) SMALLINT NOT NULL This is the Canadian year-end slip sequence number. For T4 and T4A, they have a slip sequence number of 0 (default value). As for RL-1 and RL-2, if a box amount exceeds maximum box amount allowed by MRQ, additional slip will have incremental slip number.

7 REPORTING_ID Character(16) VARCHAR2(16) NOT NULL Tax Reporting ID

8 RELEVE2_SLIP_NO Character(9) VARCHAR2(9) NOT NULL RL-2 Slip Number

9 PROVENANCE Character(6) VARCHAR2(6) NOT NULL RL-2 Provenance

10 PROVENANCE2 Character(6) VARCHAR2(6) NOT NULL RL-2 Provenance 2

11 SIN_CONTRB_SPOUSE Character(9) VARCHAR2(9) NOT NULL Spouse SIN

12 NAME_CONTRB_SPOUSE Character(12) VARCHAR2(12) NOT NULL Spouse Last Name

13 YE_SLIP_PROCESS Character(1) VARCHAR2(1) NOT NULL Slip Process Type
A=Amended
C=Cancelled
D=Delete
N=Newly Reissued
O=Original

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
4	SEQUENCE_NUMBER	Number(2,0)	SMALLINT NOT NULL	Sequence Number
5	TAXFORM_ID	Character(1)	VARCHAR2(1) NOT NULL	Tax Form Identification A=T4A Slip B=Business Payrolls Survey - CAN C=WCB Assessable Earnings E=Record of Employment F=940 - Annual Employer's FUTA I=W-2VI J=W-2cVI M=W-2GU N=W-2cGU P=W-2PR Q=W-2cPR R=RL-1 Slip S=W-2AS T=T4 Slip U=W-2cAS V=RL-2 Slip W=W-2 X=W-2c
6	CAN_YE_SLIP_SEQ	Number(2,0)	SMALLINT NOT NULL	This is the Canadian year-end slip sequence number. For T4 and T4A, they have a slip sequence number of 0 (default value). As for RL-1 and RL-2, if a box amount exceeds maximum box amount allowed by MRQ, additional slip will have incremental slip number.
7	REPORTING_ID	Character(16)	VARCHAR2(16) NOT NULL	Tax Reporting ID
8	RELEVE2_SLIP_NO	Character(9)	VARCHAR2(9) NOT NULL	RL-2 Slip Number
9	PROVENANCE	Character(6)	VARCHAR2(6) NOT NULL	RL-2 Provenance
10	PROVENANCE2	Character(6)	VARCHAR2(6) NOT NULL	RL-2 Provenance 2
11	SIN_CONTRB_SPOUSE	Character(9)	VARCHAR2(9) NOT NULL	Spouse SIN
12	NAME_CONTRB_SPOUSE	Character(12)	VARCHAR2(12) NOT NULL	Spouse Last Name
13	YE_SLIP_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	Slip Process Type A=Amended C=Cancelled D=Delete N=Newly Reissued O=Original