W2_EE_VW (SQL View)	Index Back
Employee W-2 View This view selects unique employee/company/calendar year combinations for on-line display of employee W-2 data.

W2_EE_VW

(SQL View)

Employee W-2 View

This view selects unique employee/company/calendar year combinations for on-line display of employee W-2 data.

SELECT DISTINCT A.W2_REPORTING_CO ,B.EMPLID ,B.CALENDAR_YEAR ,B.TAXFORM_ID ,B.PROCESS_FLAG FROM PS_W2_COMPANY A ,PS_W2_EE B WHERE A.COMPANY = B.COMPANY AND A.CALENDAR_YEAR = B.CALENDAR_YEAR AND A.TAXFORM_ID = B.TAXFORM_ID

# 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 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
Default Value: W

5 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
C=Complete
V=Void
X=W-2c Issued

#	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	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 Default Value: W
5	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag C=Complete V=Void X=W-2c Issued