W2_PR_VW

(SQL View)
Index Back

W-2PR Data View -Summary

This view selects federal tax data summed by W-2PR reporting company for on-line display of employee W-2PR information

SELECT B.W2_REPORTING_CO ,A.CALENDAR_YEAR ,A.EMPLID ,A.TAXFORM_ID ,A.SEQUENCE_NUMBER ,A.BOX ,SUM(A.W2_AMOUNT) FROM PS_W2_AMOUNTS_PR A ,PS_W2_COMPANY B WHERE A.COMPANY = B.COMPANY AND A.CALENDAR_YEAR = B.CALENDAR_YEAR AND A.TAXFORM_ID = 'P' AND A.TAXFORM_ID = B.TAXFORM_ID AND A.BOX > '06' AND A.BOX NOT IN ('12 ','17') GROUP BY B.W2_REPORTING_CO ,A.CALENDAR_YEAR ,A.EMPLID ,A.TAXFORM_ID ,A.SEQUENCE_NUMBER ,A.BOX

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
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
Y=1099-R
Z=1042-S
5 SEQUENCE_NUMBER Number(2,0) SMALLINT NOT NULL Sequence Number
6 BOX Character(4) VARCHAR2(4) NOT NULL Box
7 W2_AMOUNT Signed Number(15,2) DECIMAL(13,2) NOT NULL W-2 Amount