SAD_GRE_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	INST_CODE_GRE	Character(4)	VARCHAR2(4) NOT NULL	GRE Institution Code.
5	INST_NAME_GRE	Character(30)	VARCHAR2(30) NOT NULL	Institution Name
6	INST_TYPE_GRE	Character(2)	VARCHAR2(2) NOT NULL	GRE Institution Type
7	DPT_CODE_GRE	Character(4)	VARCHAR2(4) NOT NULL	GRE Department Code.
8	DPT_NAME_GRE	Character(30)	VARCHAR2(30) NOT NULL	GRE department name
9	SAD_MAJORCD_GRE	Character(4)	VARCHAR2(4) NOT NULL	Intended Graduate Major Code
10	SAD_MAJORNM_GRE	Character(30)	VARCHAR2(30) NOT NULL	Intended Graduate Major Name
11	SAD_LAST_NAME_LD	Character(32)	VARCHAR2(32) NOT NULL	Admissions Last Name from Test Load
12	SAD_FIRST_NAME_LD	Character(30)	VARCHAR2(30) NOT NULL	Admissions First Name from Test Load
13	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix Prompt Table: NAME_PREFIX_TBL
14	SAD_MID_INIT_LD	Character(1)	VARCHAR2(1) NOT NULL	Admissions Middle Initial from Test Load
15	SAD_ADDRESS1_LD	Character(55)	VARCHAR2(55) NOT NULL	Address 1
16	SAD_ADDRESS2_LD	Character(55)	VARCHAR2(55) NOT NULL	Address 2
17	SAD_ADDRESS3_LD	Character(55)	VARCHAR2(55) NOT NULL	Address 3
18	SAD_CITY_LD	Character(40)	VARCHAR2(40) NOT NULL	Test Load City
19	SAD_STATE_LD	Character(60)	VARCHAR2(60) NOT NULL	Test Load State
20	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_NAMES_TBL
21	SAD_POSTAL_LD	Character(15)	VARCHAR2(15) NOT NULL	Test Load Postal Code
22	SAD_COUNTRY_LD	Character(30)	VARCHAR2(30) NOT NULL	Test Load Country
23	SAD_CNTRYCD_GRE	Character(3)	VARCHAR2(3) NOT NULL	ISO Country Code
24	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
25	SAD_BIRTHDATE_LD	Character(10)	VARCHAR2(10) NOT NULL	Admissions Birthdate from Test Load
26	BIRTHDATE	Date(10)	DATE	Date of Birth
27	SAD_SEX_LD	Character(1)	VARCHAR2(1) NOT NULL	Test Load Gender
28	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
29	SAD_SSN_LD	Character(9)	VARCHAR2(9) NOT NULL	Admissions Test Load SSN
30	SSN	Character(9)	VARCHAR2(9) NOT NULL	Social Security #
31	SAD_TELEPHONE_LD	Character(20)	VARCHAR2(20) NOT NULL	Telephone Number
32	SAD_EMAIL_LD	Character(70)	VARCHAR2(70) NOT NULL	EMail Address
33	REG_NBR_GRE	Character(7)	VARCHAR2(7) NOT NULL	Registration Number
34	SAD_TEST_DT_LD	Character(10)	VARCHAR2(10) NOT NULL	Test Load Test Date
35	TEST_DT	Date(10)	DATE NOT NULL	Test Date
36	TEST_CODE_GRE	Character(2)	VARCHAR2(2) NOT NULL	GRE Test Code
37	TEST_NAME_GRE	Character(20)	VARCHAR2(20) NOT NULL	GRE Test Name
38	SAD_TST_SCR_COMP1	Character(3)	VARCHAR2(3) NOT NULL	Test Component 1 Score
39	SAD_SCORE_COMP1	Number(7,2)	DECIMAL(6,2) NOT NULL	Score
40	SAD_TST_COMP1	Character(5)	VARCHAR2(5) NOT NULL	Test Component 1 Prompt Table: SA_TCMP_REL_TBL
41	SAD_TST_COMP1_PST	Character(1)	VARCHAR2(1) NOT NULL	Post Y/N Table Edit Default Value: N
42	SAD_TST_EST_COMP1	Character(3)	VARCHAR2(3) NOT NULL	Estimated Score - Verbal
43	SAD_TST_COMP1_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Y/N Table Edit Default Value: N
44	SAD_TST_PER_COMP1	Character(2)	VARCHAR2(2) NOT NULL	Percentile
45	SAD_PERCENT_COMP1	Number(3,0)	SMALLINT NOT NULL	Percentile
46	SAD_TST_SCR_COMP2	Character(3)	VARCHAR2(3) NOT NULL	Test Component 2 Score
47	SAD_SCORE_COMP2	Number(7,2)	DECIMAL(6,2) NOT NULL	Score
48	SAD_TST_COMP2	Character(5)	VARCHAR2(5) NOT NULL	Test Component 2 Prompt Table: SA_TCMP_REL_TBL
49	SAD_TST_COMP2_PST	Character(1)	VARCHAR2(1) NOT NULL	Post Y/N Table Edit Default Value: N
50	SAD_TST_EST_COMP2	Character(3)	VARCHAR2(3) NOT NULL	Estimated Score - Quantitative
51	SAD_TST_COMP2_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Y/N Table Edit Default Value: N
52	SAD_TST_PER_COMP2	Character(2)	VARCHAR2(2) NOT NULL	Percentile
53	SAD_PERCENT_COMP2	Number(3,0)	SMALLINT NOT NULL	Percentile
54	SAD_TST_SCR_COMP3	Character(3)	VARCHAR2(3) NOT NULL	Test Component 3 Score
55	SAD_SCORE_COMP3	Number(7,2)	DECIMAL(6,2) NOT NULL	Score
56	SAD_TST_COMP3	Character(5)	VARCHAR2(5) NOT NULL	Test Component 3 Prompt Table: SA_TCMP_REL_TBL
57	SAD_TST_COMP3_PST	Character(1)	VARCHAR2(1) NOT NULL	Post Y/N Table Edit Default Value: N
58	SAD_TST_COMP3_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Y/N Table Edit Default Value: N
59	SAD_TST_PER_COMP3	Character(2)	VARCHAR2(2) NOT NULL	Percentile
60	SAD_PERCENT_COMP3	Number(3,0)	SMALLINT NOT NULL	Percentile
61	SAD_TST_SCR_COMP4	Character(3)	VARCHAR2(3) NOT NULL	Test Component 4 Score
62	SAD_SCORE_COMP4	Number(7,2)	DECIMAL(6,2) NOT NULL	Score
63	SAD_TST_COMP4	Character(5)	VARCHAR2(5) NOT NULL	Test Component 4 Prompt Table: SA_TCMP_REL_TBL
64	SAD_TST_COMP4_PST	Character(1)	VARCHAR2(1) NOT NULL	Post Y/N Table Edit Default Value: N
65	SAD_TST_COMP4_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Y/N Table Edit Default Value: N
66	SAD_TST_PER_COMP4	Character(2)	VARCHAR2(2) NOT NULL	Percentile
67	SAD_PERCENT_COMP4	Number(3,0)	SMALLINT NOT NULL	Percentile
68	SAD_TST_SCR_COMP5	Character(3)	VARCHAR2(3) NOT NULL	Test Component 5 Score
69	SAD_SCORE_COMP5	Number(7,2)	DECIMAL(6,2) NOT NULL	Score
70	SAD_TST_COMP5	Character(5)	VARCHAR2(5) NOT NULL	Test Component 5 Prompt Table: SA_TCMP_REL_TBL Set Control Field: DESCR
71	SAD_TST_COMP5_PST	Character(1)	VARCHAR2(1) NOT NULL	Post Y/N Table Edit Default Value: N
72	SAD_TST_COMP5_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Y/N Table Edit Default Value: N
73	SAD_TST_PER_COMP5	Character(2)	VARCHAR2(2) NOT NULL	Percentile
74	SAD_PERCENT_COMP5	Number(3,0)	SMALLINT NOT NULL	Percentile
75	EXMNEE_SQNBR_GRE	Character(4)	VARCHAR2(4) NOT NULL	GRE Examinee Sequence Number.
76	REC_SRL_NBR_GRE	Character(2)	VARCHAR2(2) NOT NULL	GRE Record Serial Number
77	CYCLE_NBR_GRE	Character(4)	VARCHAR2(4) NOT NULL	GRE Cycle Number
78	PROCESS_DT_GRE	Character(8)	VARCHAR2(8) NOT NULL	GRE Process Date