SAD_ADA_SUS_COL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_ID	Character(11)	VARCHAR2(11) NOT NULL	Test ID
2	TEST_REC_NBR	Number(9,0)	DECIMAL(9) NOT NULL	Test Type Record Nbr Prompt Table: SAD_ADA_SUS
3	SCHL_PERD_NBR	Number(2,0)	SMALLINT NOT NULL	School Attended Nbr
4	COL_ATND_FRM_AADSA	Character(5)	VARCHAR2(5) NOT NULL	AADSAS College Attended From
5	COL_ATND_TO_AADSAS	Character(5)	VARCHAR2(5) NOT NULL	AADSAS College Attended To
6	COL_NAME_AADSAS	Long Character(255)	VARCHAR2(255)	College Name
7	HRS_ATTMP_AADSAS	Character(6)	VARCHAR2(6) NOT NULL	AADSAS Hours Attempted
8	COL_GPA_AADSAS	Character(4)	VARCHAR2(4) NOT NULL	AADSAS College GPA
9	COLG_CODE_AADSAS	Character(6)	VARCHAR2(6) NOT NULL	College Code
10	SAD_FOREIGN_COL_NM	Character(50)	VARCHAR2(50) NOT NULL	Name of non-U.S./non-Canadian institution if applicable
11	SAD_FIRST_DEG_CD	Character(2)	VARCHAR2(2) NOT NULL	Degree Code for First Degree
12	SAD_FIRST_DEG_NM	Character(50)	VARCHAR2(50) NOT NULL	Degree Name for First Degree
13	SAD_FIRST_DEG_STAT	Character(20)	VARCHAR2(20) NOT NULL	Status of the First Degree
14	SAD_1STDEG_MJR1_CD	Character(3)	VARCHAR2(3) NOT NULL	Major Code for First Major of First Degree
15	SAD_1STDEG_MJR1_NM	Character(50)	VARCHAR2(50) NOT NULL	Major Name for First Major of First Degree
16	SAD_1STDEG_MJR2_CD	Character(3)	VARCHAR2(3) NOT NULL	Major Code for Second Major of First Degree
17	SAD_1STDEG_MJR2_NM	Character(50)	VARCHAR2(50) NOT NULL	Major Name for Second Major of First Degree
18	SAD_FIRST_DEG_DT	Date(10)	DATE	Date of First Degree Earned or Anticipated
19	SAD_SCND_DEG_CD	Character(2)	VARCHAR2(2) NOT NULL	Degree Code for Second Degree
20	SAD_SCND_DEG_NM	Character(50)	VARCHAR2(50) NOT NULL	Degree Name for Second Degree
21	SAD_SCND_DEG_ST	Character(20)	VARCHAR2(20) NOT NULL	Status of the Second Degree
22	SAD_2NDDEG_MJR1_CD	Character(3)	VARCHAR2(3) NOT NULL	Major Code for Second Degree
23	SAD_2NDDEG_MJR1_NM	Character(50)	VARCHAR2(50) NOT NULL	Major Name for Second Degree
24	SAD_2NDDEG_MJR2_CD	Character(3)	VARCHAR2(3) NOT NULL	Major Code for Second Major of Second Degree
25	SAD_2NDDEG_MJR2_NM	Character(50)	VARCHAR2(50) NOT NULL	Major Name for Second Major of Second Degree
26	SAD_SCND_DEG_DT	Date(10)	DATE	Date Second Degree Earned or Anticipated
27	DENTAL_CERT_AADSAS	Character(50)	VARCHAR2(50) NOT NULL	AADSAS Dental Certificate
28	SAD_INST_STATE	Character(2)	VARCHAR2(2) NOT NULL	State or Province of the College or University
29	SAD_COMMENTARY	Character(150)	VARCHAR2(150) NOT NULL	Commentary that appears on the transcript (If any)
30	SAD_TRN_DT_RECD	Date(10)	DATE	Transcript Date Received by AADSAS