GMASS_ACI

#	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_GMASS	Character(12)	VARCHAR2(12) NOT NULL	Last Name
5	FIRST_NAME_GMASS	Character(10)	VARCHAR2(10) NOT NULL	First Name
6	MIDDLE_INIT_GMASS	Character(1)	VARCHAR2(1) NOT NULL	Middle Initial
7	ADDRESS1_GMASS	Character(30)	VARCHAR2(30) NOT NULL	GMASS Address
8	CITY_GMASS	Character(15)	VARCHAR2(15) NOT NULL	GMASS City
9	STATE_GMASS	Character(2)	VARCHAR2(2) NOT NULL	GMASS State
10	POSTAL_GMASS	Character(9)	VARCHAR2(9) NOT NULL	GMASS Postal Code
11	COUNTRY_GMASS	Character(25)	VARCHAR2(25) NOT NULL	GMASS Country
12	BIRTHDATE_GMASS	Character(6)	VARCHAR2(6) NOT NULL	Birthdate
13	SEX_GMASS	Character(1)	VARCHAR2(1) NOT NULL	GMASS Gender
14	SSN_GMASS	Character(9)	VARCHAR2(9) NOT NULL	GMASS SSN
15	CD_OF_INST_GMASS	Character(4)	VARCHAR2(4) NOT NULL	Code of Institution
16	CONTACT_NBR_GMASS	Character(8)	VARCHAR2(8) NOT NULL	Contact Number
17	PRTCPTN_NBR_GMASS	Character(2)	VARCHAR2(2) NOT NULL	GMASS Participation Form Nbr
18	UNDGRD_CLGCD_GMASS	Character(4)	VARCHAR2(4) NOT NULL	Undergraduate College Code
19	UNDGRD_MJRCD_GMASS	Character(2)	VARCHAR2(2) NOT NULL	Undergraduate Major Code
20	DEGREE_OBJ_GMASS	Character(1)	VARCHAR2(1) NOT NULL	Degree Objective
21	REGION_OF_US_GMASS	Character(12)	VARCHAR2(12) NOT NULL	Region of U.S.
22	INTENDED_AOC_GMASS	Character(4)	VARCHAR2(4) NOT NULL	Area of Concentration