W2_DATA_PR_VW

(SQL View)
 Index Back

W-2PR Data View

Thsi view is used for on-line display of employee W-2PR data.

SELECT DISTINCT A.W2_REPORTING_CO ,B.EMPLID ,B.CALENDAR_YEAR ,B.TAXFORM_ID ,B.SEQUENCE_NUMBER ,B.SSN ,B.W2_NAME ,B.ADDRESS1 ,B.ADDRESS2 ,B.CITY ,B.STATE ,B.COUNTRY ,B.POSTAL ,B.STATUTORY_EE ,B.DECEASED ,B.W2_STATE ,B.EMPLOYER_ID_SWT ,B.CONTROL_NUMBER ,B.MAR_STATUS ,B.SPOUSE_SSN ,B.MEDICARE_ONLY FROM PS_W2_COMPANY A ,PS_W2_DATA_PR B WHERE B.COMPANY = A.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
5 SEQUENCE_NUMBER Number(2,0) SMALLINT NOT NULL Sequence Number
6 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
7 W2_NAME Character(30) VARCHAR2(30) NOT NULL W-2 Name
8 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
9 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
10 CITY Character(30) VARCHAR2(30) NOT NULL City
11 STATE Character(6) VARCHAR2(6) NOT NULL State
12 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
13 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
14 STATUTORY_EE Character(1) VARCHAR2(1) NOT NULL Statutory Employee

Y/N Table Edit

Default Value: N

15 DECEASED Character(1) VARCHAR2(1) NOT NULL Deceased

Y/N Table Edit

Default Value: N

16 W2_STATE Character(2) VARCHAR2(2) NOT NULL W-2 State
17 EMPLOYER_ID_SWT Character(20) VARCHAR2(20) NOT NULL Employer ID (SWT).
18 CONTROL_NUMBER Character(12) VARCHAR2(12) NOT NULL Control Number
19 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
20 SPOUSE_SSN Character(9) VARCHAR2(9) NOT NULL Spouse SSN
21 MEDICARE_ONLY Character(1) VARCHAR2(1) NOT NULL Medicare Only

Y/N Table Edit

Default Value: N