SAD_GMS_SUS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_ID	Character(11)	VARCHAR2(11) NOT NULL	Test ID Prompt Table: SA_TEST_TBL
2	TEST_REC_NBR	Number(9,0)	DECIMAL(9) NOT NULL	Test Type Record Nbr
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
4	CD_OF_INST_GMASS	Character(4)	VARCHAR2(4) NOT NULL	Code of Institution
5	SAD_GMS_ORDER_YR	Character(4)	VARCHAR2(4) NOT NULL	GMASS Order Year
6	SAD_GMS_SEQ_NBR	Character(6)	VARCHAR2(6) NOT NULL	GMASS Sequence Number
7	SAD_GMS_ORDER_DT	Character(6)	VARCHAR2(6) NOT NULL	GMASS Order Date
8	CONTACT_NBR_GMASS	Character(8)	VARCHAR2(8) NOT NULL	Contact Number
9	SAD_LAST_NAME_LD	Character(32)	VARCHAR2(32) NOT NULL	Admissions Last Name from Test Load
10	SAD_FIRST_NAME_LD	Character(30)	VARCHAR2(30) NOT NULL	Admissions First Name from Test Load
11	SAD_MID_INIT_LD	Character(1)	VARCHAR2(1) NOT NULL	Admissions Middle Initial from Test Load
12	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix Prompt Table: NAME_PREFIX_TBL
13	SAD_ADDRESS1_LD	Character(55)	VARCHAR2(55) NOT NULL	Address 1
14	SAD_ADDRESS2_LD	Character(55)	VARCHAR2(55) NOT NULL	Address 2
15	SAD_CITY_LD	Character(40)	VARCHAR2(40) NOT NULL	Test Load City
16	SAD_STATE_LD	Character(60)	VARCHAR2(60) NOT NULL	Test Load State
17	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_NAMES_TBL
18	SAD_POSTAL_LD	Character(15)	VARCHAR2(15) NOT NULL	Test Load Postal Code
19	SAD_COUNTRY_LD	Character(30)	VARCHAR2(30) NOT NULL	Test Load Country
20	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
21	SAD_SEX_LD	Character(1)	VARCHAR2(1) NOT NULL	Test Load Gender
22	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
23	SAD_BIRTHDATE_LD	Character(10)	VARCHAR2(10) NOT NULL	Admissions Birthdate from Test Load
24	BIRTHDATE	Date(10)	DATE	Date of Birth
25	UNDGRD_MJRCD_GMASS	Character(2)	VARCHAR2(2) NOT NULL	Undergraduate Major Code
26	DEGREE_OBJ_GMASS	Character(1)	VARCHAR2(1) NOT NULL	Degree Objective
27	REGION_OF_US_GMASS	Character(12)	VARCHAR2(12) NOT NULL	Region of U.S.
28	INTENDED_AOC_GMASS	Character(4)	VARCHAR2(4) NOT NULL	Area of Concentration
29	SAD_EMAIL_LD	Character(70)	VARCHAR2(70) NOT NULL	EMail Address
30	UNDGRD_CLGCD_GMASS	Character(4)	VARCHAR2(4) NOT NULL	Undergraduate College Code
31	SAD_GMS_PLN_ENRL	Character(6)	VARCHAR2(6) NOT NULL	GMASS Planned Date of Enrollment
32	SAD_GMS_FULL_WRK	Character(2)	VARCHAR2(2) NOT NULL	GMASS Full-Time Work
33	SAD_GMS_NTV_LANG	Character(2)	VARCHAR2(2) NOT NULL	GMASS Native Language
34	SAD_GMS_PREF_DEG	Character(2)	VARCHAR2(2) NOT NULL	GMASS Preference for Pursuing Degree
35	TEST_DT	Date(10)	DATE NOT NULL	Test Date
36	SAD_TST_COMP1	Character(5)	VARCHAR2(5) NOT NULL	Test Component 1 Prompt Table: SA_TCMP_REL_TBL
37	SAD_SCORE_COMP1	Number(7,2)	DECIMAL(6,2) NOT NULL	Score
38	SAD_PERCENT_COMP1	Number(3,0)	SMALLINT NOT NULL	Percentile
39	SAD_TST_COMP1_PST	Character(1)	VARCHAR2(1) NOT NULL	Post Y/N Table Edit Default Value: N
40	SAD_TST_COMP2	Character(5)	VARCHAR2(5) NOT NULL	Test Component 2 Prompt Table: SA_TCMP_REL_TBL
41	SAD_SCORE_COMP2	Number(7,2)	DECIMAL(6,2) NOT NULL	Score
42	SAD_PERCENT_COMP2	Number(3,0)	SMALLINT NOT NULL	Percentile
43	SAD_TST_COMP2_PST	Character(1)	VARCHAR2(1) NOT NULL	Post Y/N Table Edit Default Value: N
44	TEST_ADMIN	Character(1)	VARCHAR2(1) NOT NULL	Standard Test Administration Y/N Table Edit Default Value: N