W2_DATA

#	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 Y=1099-R Z=1042-S
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	PENSION_PLAN	Character(1)	VARCHAR2(1) NOT NULL	Retirement Plan Y/N Table Edit Default Value: N
17	LEGAL_REP	Character(1)	VARCHAR2(1) NOT NULL	Legal Representative Y/N Table Edit Default Value: N
18	DEFERRED_COMP	Character(1)	VARCHAR2(1) NOT NULL	Deferred Compensation Y/N Table Edit Default Value: N
19	W2_STATE	Character(2)	VARCHAR2(2) NOT NULL	W-2 State
20	EMPLOYER_ID_SWT	Character(20)	VARCHAR2(20) NOT NULL	Employer ID (SWT).
21	CONTROL_NUMBER	Character(12)	VARCHAR2(12) NOT NULL	Control Number
22	MEDICARE_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Medicare Only Y/N Table Edit Default Value: N