EOS_SPS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
2	TEST_DT	Date(10)	DATE NOT NULL	Test Date
3	CAUSE_CREATION	Character(1)	VARCHAR2(1) NOT NULL	Personal Data Impacts N=No Personal Data Impact U=Caused Personal Data Update Y=Caused Personal Data Creation Y/N Table Edit Default Value: N
4	LAST_NAME_EOS	Character(25)	VARCHAR2(25) NOT NULL	Last Name
5	FIRST_NAME_EOS	Character(16)	VARCHAR2(16) NOT NULL	First Name
6	MIDDLE_INIT_EOS	Character(1)	VARCHAR2(1) NOT NULL	Middle Initial
7	SSN_EOS	Character(9)	VARCHAR2(9) NOT NULL	EOS SSN
8	BIRTHDATE_EOS	Character(8)	VARCHAR2(8) NOT NULL	EOS Birthdate
9	SEX_EOS	Character(1)	VARCHAR2(1) NOT NULL	EOS Gender
10	ADDRESS1_EOS	Character(40)	VARCHAR2(40) NOT NULL	EOS Address
11	CITY_EOS	Character(25)	VARCHAR2(25) NOT NULL	EOS City
12	STATE_EOS	Character(2)	VARCHAR2(2) NOT NULL	EOS State
13	POSTAL_EOS	Character(9)	VARCHAR2(9) NOT NULL	EOS Postal Code
14	HS_CODE_EOS	Character(6)	VARCHAR2(6) NOT NULL	High School Code
15	INTEND_MAJOR_EOS	Character(3)	VARCHAR2(3) NOT NULL	Intended Major
16	OCCUPAT_CHOICE_EOS	Character(3)	VARCHAR2(3) NOT NULL	Occupational Choice
17	GRADE_CLASS_EOS	Character(2)	VARCHAR2(2) NOT NULL	Grade Classification
18	STATE_CODE_EOS	Character(2)	VARCHAR2(2) NOT NULL	Numeric State Code
19	BATCH_PROC_NBR_EOS	Character(4)	VARCHAR2(4) NOT NULL	Batch Processing Number
20	GRAD_YR_EOS	Character(4)	VARCHAR2(4) NOT NULL	Graduation Year
21	POSTAL_CORRECT_EOS	Character(1)	VARCHAR2(1) NOT NULL	Postal Correction
22	POSTAL_DEL_PNT_EOS	Character(2)	VARCHAR2(2) NOT NULL	Postal Delivery Point
23	INST_CD_EOS	Character(4)	VARCHAR2(4) NOT NULL	Institution Code
24	SUFX_INDICATOR_EOS	Character(4)	VARCHAR2(4) NOT NULL	Suffix Indicator
25	ETHNICITY_EOS	Character(1)	VARCHAR2(1) NOT NULL	EOS Ethnicity
26	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address