YE_W2CP_DATA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	W2C_BATCH_NBR	Number(4,0)	SMALLINT NOT NULL	W-2c Batch Number
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
3	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
4	W2C_ADD_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Emplid (preferred) Prompt Table: PERSON
5	PRV_SSN	Character(9)	VARCHAR2(9) NOT NULL	or SSN
6	W2C_TAXFORM_ID	Character(1)	VARCHAR2(1) NOT NULL	Tax Form Identification I=W-2VI M=W-2GU P=W-2PR S=W-2AS W=W-2 Default Value: P
7	PRV_YE_FNAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
8	PRV_YE_MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIddle Name
9	PRV_YE_LNAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
10	PRV_YE_SUFFIX	Character(5)	VARCHAR2(5) NOT NULL	Suffix
11	PRV_ADDRESS1	Character(35)	VARCHAR2(35) NOT NULL	Previous Address1
12	PRV_ADDRESS2	Character(35)	VARCHAR2(35) NOT NULL	Previous Address2
13	PRV_CITY	Character(30)	VARCHAR2(30) NOT NULL	Previous City
14	PRV_STATE	Character(2)	VARCHAR2(2) NOT NULL	Previous State
15	PRV_COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Previous Country
16	PRV_POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Previous Postal Code
17	PRV_ER_ID_SWT	Character(20)	VARCHAR2(20) NOT NULL	Previous Employer ID
18	PRV_CONTROL_NBR	Character(12)	VARCHAR2(12) NOT NULL	Previous Control Number
19	PRV_MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Marital Status
20	PRV_SPOUSE_SSN	Character(9)	VARCHAR2(9) NOT NULL	Spouse SSN
21	W2C_SSN	Character(9)	VARCHAR2(9) NOT NULL	Corrected SSN
22	W2C_FNAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
23	W2C_MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Middle Name
24	W2C_LNAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
25	W2C_SUFFIX	Character(5)	VARCHAR2(5) NOT NULL	Suffix
26	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
27	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
28	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
29	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
30	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
31	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
32	EMPLOYER_ID_SWT	Character(20)	VARCHAR2(20) NOT NULL	Employer ID (SWT).
33	CONTROL_NUMBER	Character(12)	VARCHAR2(12) NOT NULL	Control Number
34	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
35	SPOUSE_SSN	Character(9)	VARCHAR2(9) NOT NULL	Spouse SSN
36	ELEC_FILE_CONF_NO	Character(7)	VARCHAR2(7) NOT NULL	Puerto Rico Electronic Filing Confirmation Number
37	W2C_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status C=Closed O=Open V=Void Default Value: O
38	DESCRLONG	Long Character	CLOB	Long Description