Graduate Admissions
# REF NO Input File Field Name Non Input File Field Name CDW Table Name CDW Field Name Field Description Code Values UCDW Star-Schema Name UCDW Star Table Name UCDW Star Field Name Comments
1 N/A N/A Year Applied Stu_GAD_Applic_Tbl Year_Applied Calendar year applied for   GAD_BI TERM_D T_CLND_YR  
2 N020 Quarter Applied for Code N/A Stu_GAD_Applic_Tbl Term_Applied_Code Code indicating the academic quarter in which the applicant wishes to commence his/her studies. 1' = Summer
'
2' = Fall
'
3' = Winter
'
4' = Spring
       
3 N060 Identification Number - Applicant N/A Stu_GAD_Applic_Tbl Identification_Number_GAD Number that identifies applicant on the campus applied to. For applicants who have registered, this must be the number which identifies the person in the population of registrants.
Note: Applicant Identification Number varies in length from campus to campus. Social Security Number is used on some campuses.
  GAD_BI APPLICANT_D AL_IDENT_NUM  
4 N/A N/A N/A Stu_GAD_Applic_Tbl GKEY_Seq_No N/A N/A N/A N/A N/A  
5 N/A N/A Age on October 15 Stu_GAD_Applic_Tbl Age_on_October_15 Age of student on October 15 of the academic year.   GAD_BI APPLICANT_D AL_AGE_ON_OCT_15  
6 N/A N/A Age on October 15-Category Stu_GAD_Applic_Tbl Age_on_October_15_Category Code indicating category of age of student on October 15 of the academic year.   GAD_BI AGE_BAND_D AGE_BAND_RNG_DESC  
7 H010 Date of Birth N/A Stu_GAD_Applic_Tbl Birthdate The year, month and day on which the person was born. Converted to YYYY/MM/DD for data warehouse tables. GAD_BI APPLICANT_D AL_BTH_DT  
8 N180 Campus Applied to code N/A Stu_GAD_Applic_Tbl Campus_Applied_to_Code Code indicating campus responsible for applicant record. 01' = Berkeley
'
02' = San Francisco
'
03' = Davis
'
04' = Los Angeles
'
05' = Riverside
'
06' = San Diego
'
07' = Santa Cruz
'
08' = Santa Barbara
'
09' = Irvine
'
10' = Merced
GAD_BI CAMPUS_LOCATION_D CMP_LOC_LOC1_CD  
9 N/A N/A Campus Name Abbreviation App Stu_GAD_Applic_Tbl Campus_Name_Abbreviation_App Two-character abbreviation of campus name at which student applied. BK' = Berkeley
'
SF' = San Francisco
'DV' = Davis
'LA' = Los Angeles
'RV' = Riverside
'SD' = San Diego
'SC' = Santa Cruz
'SB' = Santa Barbara
'IR' = Irvine
'MC' = Merced
GAD_BI CAMPUS_LOCATION_D CMP_LOC_LOC1_ABRV_DESC  
10 N/A N/A Campus Name App Stu_GAD_Applic_Tbl Campus_Name_App Name of campus at which campus applied. BERKELEY
SAN FRANCISCO
DAVIS
LOS ANGELES
RIVERSIDE
SAN DIEGO
SANTA CRUZ
SANTA BARBARA
IRVINE
MERCED
GAD_BI CAMPUS_LOCATION_D CMP_LOC_LOC1_LNG_DESC  
11 F220 Cancelled Appl Code N/A Stu_GAD_Applic_Tbl Cancelled_Application_Flag Code indicating by whom an application was cancelled. A' = Cancelled by administration
'
V' = Voluntarily cancelled by applicant
       
12 N/A N/A Campus-College-Major-GAD Stu_GAD_Applic_Tbl CCM_Code_Proposed_GAD Campus-college-major code combination proposed on graduate admission application. Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_CCM_CD  
13 N/A N/A CIP Category Code Proposed Stu_GAD_Applic_Tbl CIP_Category_Code_Proposed Two-digit Classification of Instructional Programs code, indicating disciplinary area, proposed by the applicant. Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_CIP_FMY_CD  
14 N/A N/A CIP Category Name Proposed Stu_GAD_Applic_Tbl CIP_Category_Name_Proposed Name of the two-digit Classification of Instructional Programs code, indicating disciplinary area, proposed by the applicant. Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_CIP_FMY_NAM  
15 N/A N/A CIP Code Proposed Stu_GAD_Applic_Tbl CIP_Code_Proposed Code for the CIP (Classification of Instructional Programs) discipline associated with the major in which the applicant plans to enroll or the first major of a joint or concurrent degree program in which the applicant plans to enroll. Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_CIP_CD  
16 N/A N/A CIP Name Proposed Stu_GAD_Applic_Tbl CIP_Name_Proposed Name of the CIP (Classification of Instructional Programs) discipline associated with the major in which the applicant plans to enroll or the first major of a joint or concurrent degree program in which the applicant plans to enroll. Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_CIP_NAM  
17 F060 N/A Citizenship Status Code-Admission Stu_GAD_Applic_Tbl Citizenship_Status_Adm Code indicating student's citizenship status with respect to the United States at the time of application for admission   GAD_BI APPLICANT_D AL_CZ_STAT_ADM_CD  
18 N/A N/A Citizenship Status Adm-2CAT Stu_GAD_Applic_Tbl Citizenship_Status_Adm_2CAT Two-category code indicating domestic or foreign citizenship/visa status D' = Domestic
'
F' = Foreign
GAD_BI APPLICANT_D AL_CZ_STAT_ADM_2CAT_CD  
19 Q010 College Proposed Code_1 N/A Stu_GAD_Applic_Tbl College_Code_Proposed_1 Code indicating the college in which applicant plans to enroll; or, the first college in which applicant plans to enroll if enrolling in a joint or concurrent degree program. Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_LOC_CG_CD  
20 Q020 College Proposed Code_2 N/A Stu_GAD_Applic_Tbl College_Code_Proposed_2 Code indicating the second college in which applicant plans to enroll, if enrolling in a joint or concurrent degree program. Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_LOC_CG_CD Students applying for multiple colleges will have the same APPLICATION_F.APPL_REC_LINK_ID values and pivoted into multiple rows in APPLICATION_REFERENCE_D
21 Q030 College Proposed Code_3 N/A Stu_GAD_Applic_Tbl College_Code_Proposed_3 Code indicating the third college in which applicant plans to enroll, if enrolling in a joint or concurrent degree program. Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_LOC_CG_CD Students applying for multiple colleges will have the same APPLICATION_F.APPL_REC_LINK_ID values and pivoted into multiple rows in APPLICATION_REFERENCE_D
22 N/A N/A College Name Proposed-1 Stu_GAD_Applic_Tbl College_Name_Proposed_1 The name of the college in which applicant plans to enroll Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_LOC_CG_NAM  
23 N/A N/A College Name Proposed-2 Stu_GAD_Applic_Tbl College_Name_Proposed_2 The name of the college in which applicant plans to enroll Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_LOC_CG_NAM Students applying for multiple colleges will have the same APPLICATION_F.APPL_REC_LINK_ID values and pivoted into multiple rows in APPLICATION_REFERENCE_D
24 N/A N/A College Name Proposed-3 Stu_GAD_Applic_Tbl College_Name_Proposed_3 The name of the college in which applicant plans to enroll Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_LOC_CG_NAM Students applying for multiple colleges will have the same APPLICATION_F.APPL_REC_LINK_ID values and pivoted into multiple rows in APPLICATION_REFERENCE_D
25 N/A N/A Degree Category Code Proposed Stu_GAD_Applic_Tbl Degree_Category_Code_Proposed Code indicating the degree category for which the applicant has applied; or, the first degree program of a joint or concurrent degree program to which the applicant has applied. A' = Bachelor
'B' = Master
'C' = Doctor
'D' = Cand. In Philosophy
'E' = Engineer
'F' = Juris Doctor
'G' = Doctor of Dental Surgery
'H' = Doctor of Medicine
'I' = Doctor of Optometry
'J' = Doctor of Veterinary Medicine
'K' = Doctor of Pharmacy
'L' = Credentials and Certificates
'M' = Doctor of Physical Therapy
'O' = Doctor of Audiology
GAD_BI ACADEMIC_DEGREE_D ACAD_DGR_CATG_CD  
26 N/A N/A N/A Stu_GAD_Applic_Tbl Degree_Category_Name_Proposed_L N/A   N/A N/A N/A  
27 N/A N/A N/A Stu_GAD_Applic_Tbl Degree_Category_Name_Proposed_L2 N/A   N/A N/A N/A  
28 N/A N/A Degree Program Abbreviation-1 Stu_GAD_Applic_Tbl Degree_Program_Abbr_1 The abbreviated name of the degree program in which the student has been admitted or enrolled Refer to Academic Degree Code Table GAD_BI ACADEMIC_DEGREE_D ACAD_DGR_SHRT_NAM  
29 N/A N/A Degree Program Abbreviation-2 Stu_GAD_Applic_Tbl Degree_Program_Abbr_2 The abbreviated name of the second degree program in which the student has been admitted or enrolled, if enrolled in a joint or concurrent degree program. Refer to Academic Degree Code Table GAD_BI ACADEMIC_DEGREE_D ACAD_DGR_SHRT_NAM Students applying for multiple degrees will have the same APPLICATION_F.APPL_REC_LINK_ID values and pivoted into multiple rows in APPLICATION_REFERENCE_D
30 N/A N/A Degree Program Abbreviation-3 Stu_GAD_Applic_Tbl Degree_Program_Abbr_3 The abbreviated name of the third degree program in which the student has been admitted or enrolled, if enrolled in a joint or concurrent degree program. Refer to Academic Degree Code Table GAD_BI ACADEMIC_DEGREE_D ACAD_DGR_SHRT_NAM Students applying for multiple degrees will have the same APPLICATION_F.APPL_REC_LINK_ID values and pivoted into multiple rows in APPLICATION_REFERENCE_D
31 H640 Degree Program Code-1 N/A Stu_GAD_Applic_Tbl Degree_Program_Code_1 Code indicating the degree program in which the student has been admitted or enrolled; or, the first degree program of a joint or concurrent degree program in which the student has been admitted or enrolled.
Refer to Academic Degree Code Table GAD_BI ACADEMIC_DEGREE_D ACAD_DGR_CD  
32 H650 Degree Program Code-2 N/A Stu_GAD_Applic_Tbl Degree_Program_Code_2 Code indicating the second degree program in which the student has been admitted or enrolled, if enrolled in a joint or concurrent degree program. Refer to Academic Degree Code Table GAD_BI ACADEMIC_DEGREE_D ACAD_DGR_CD Students applying for multiple degrees will have the same APPLICATION_F.APPL_REC_LINK_ID values and pivoted into multiple rows in APPLICATION_REFERENCE_D
33 H660 Degree Program Code-3 N/A Stu_GAD_Applic_Tbl Degree_Program_Code_3 Code indicating the third degree program in which the student has been admitted or enrolled, if enrolled in a joint or concurrent degree program. Refer to Academic Degree Code Table GAD_BI ACADEMIC_DEGREE_D ACAD_DGR_CD Students applying for multiple degrees will have the same APPLICATION_F.APPL_REC_LINK_ID values and pivoted into multiple rows in APPLICATION_REFERENCE_D
34 N/A N/A Degree Program Name-1 Stu_GAD_Applic_Tbl Degree_Program_Name_1 The name of the first degree program in which the student has been admitted or enrolled; or, the name of the first degree program of a joint or concurrent degree program in which the student has been admitted or enrolled. Refer to Academic Degree Code Table GAD_BI ACADEMIC_DEGREE_D ACAD_DGR_LNG_NAM  
35 N/A N/A Degree Program Name-2 Stu_GAD_Applic_Tbl Degree_Program_Name_2 The name of the second degree program in which the student has been admitted or enrolled, if enrolled in a joint or concurrent degree program. Refer to Academic Degree Code Table GAD_BI ACADEMIC_DEGREE_D ACAD_DGR_LNG_NAM Students applying for multiple degrees will have the same APPLICATION_F.APPL_REC_LINK_ID values and pivoted into multiple rows in APPLICATION_REFERENCE_D
36 N/A N/A Degree Program Name-3 Stu_GAD_Applic_Tbl Degree_Program_Name_3 The name of the third degree program in which the student has been admitted or enrolled, if enrolled in a joint or concurrent degree program. Refer to Academic Degree Code Table GAD_BI ACADEMIC_DEGREE_D ACAD_DGR_LNG_NAM Students applying for multiple degrees will have the same APPLICATION_F.APPL_REC_LINK_ID values and pivoted into multiple rows in APPLICATION_REFERENCE_D
37 F030 Ethnic Origin Code-Admission N/A Stu_GAD_Applic_Tbl Ethnic_Origin_Code_Adm Code indicating the ethnic background of the student as recorded at the time of application for admission. A = American Indian/Alaskan Native
B = Black/African American
C = Chicano/Mexican-American
D = Chinese/Chinese-American
E = Decline to State
F = East Indian/Pakistani
G = Japanese/Japanese-American
H = Korean
J = Latino/Other Spanish-American
K = Other
L = Pilipino/Filipino
M = Polynesian (Pacific Islander-Fall 88)
N = Thai/Other Asian
P = White/Caucasian
V = Vietnamese
N/A N/A N/A No longer used as per input file specs
38 N/A N/A N/A Stu_GAD_Applic_Tbl Ethnic_Origin_Code_Adm_URM Flag indicating applicant is a member of an underrepresented minority (American Indian, African American, Chicano, or Latino). 1 - Yes
0 - No
N/A N/A N/A  
39 N/A N/A Ethnic Origin Name Adm Stu_GAD_Applic_Tbl Ethnic_Origin_Name_Adm Name of race/ethnicity category provided on the application.   N/A N/A N/A  
40 N/A N/A Ethnic Origin Name Adm 9CAT Stu_GAD_Applic_Tbl Ethnic_Origin_Name_Adm_9CAT Name of race/ethnicity category provided on the application - 9 categories AI' = American Indian
'
BLACK' = Black
'
CHIC' = Chicano
'
LAT' = Latino
'
PIL' = Filipino
'
ASIAN' = Asian
'
WHITE' = White
'
DTS' = Decline to State
'
OTHER' = Other
GAD_BI UC_ETHNIC_CODE_LEVEL_1_D UC_ETN_CD_LVL_1_9CAT_NAM  
41 N/A N/A Ethnic Origin Name Adm IPEDS Stu_GAD_Applic_Tbl Ethnic_Origin_Name_Adm_IPEDS Name of race/ethnicity category provided on the application - IPEDS categories. HISPANIC/LATINO
AFRICAN AMERICAN/BLACK
AMERICAN INDIAN/ALASKA NATIVE
ASIAN
NATIVE HAWAIIAN/OTHER PACIFIC ISLANDER
WHITE
UNKNOWN
NON-RESIDENT ALIEN
TWO OR MORE RACES
GAD_BI IPEDS_ETHNIC_CODE_D IPEDS_ETN_CD_NAM  
42 Q070 Graduate Admit Code N/A Stu_GAD_Applic_Tbl Graduate_Admit_Code Code indicating whether a graduate applicant has been admitted. Y' = Yes
'
N' = No
GAD_BI APPLICATION_REFERENCE_D APPL_REF_GRAD_ADT_FL  
43 N/A N/A N/A Stu_GAD_Applic_Tbl HEGIS_Code_Proposed_GAD N/A   N/A N/A N/A  
44 N/A N/A N/A Stu_GAD_Applic_Tbl HEGIS_Name_Proposed_GAD N/A   N/A N/A N/A  
45 Q040 Major Code Proposed_1 N/A Stu_GAD_Applic_Tbl Major_Code_Proposed_1 Code indicating the major in which the applicant plans to enroll or the first major of a joint or concurrent degree program in which the applicant plans to enroll. Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_MAJ_CD Students applying for multiple majorswill have the same APPLICATION_F.APPL_REC_LINK_ID values and pivoted into multiple rows in APPLICATION_REFERENCE_D
46 Q050 Major Code Proposed_2 N/A Stu_GAD_Applic_Tbl Major_Code_Proposed_2 Code indicating the second major in which the applicant plans to enroll, if enrolling in a joint or concurrent degree program. Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_MAJ_CD Students applying for multiple majorswill have the same APPLICATION_F.APPL_REC_LINK_ID values and pivoted into multiple rows in APPLICATION_REFERENCE_D
47 Q060 Major Code Proposed_3 N/A Stu_GAD_Applic_Tbl Major_Code_Proposed_3 Code indicating the third major in which the applicant plans to enroll, if enrolling in a joint or concurrent degree program. Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_MAJ_CD Students applying for multiple majorswill have the same APPLICATION_F.APPL_REC_LINK_ID values and pivoted into multiple rows in APPLICATION_REFERENCE_D
48 N/A N/A Major Name Proposed-1 Stu_GAD_Applic_Tbl Major_Name_Proposed_1 The name of the major in which the applicant plans to enroll or the name of the first major of a joint or concurrent degree program in which the applicant plans to enroll. Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_ID_SHRT_NAM Students applying for multiple majorswill have the same APPLICATION_F.APPL_REC_LINK_ID values and pivoted into multiple rows in APPLICATION_REFERENCE_D
49 N/A N/A Major Name Proposed-2 Stu_GAD_Applic_Tbl Major_Name_Proposed_2 The name of the major in which the applicant plans to enroll or the name of the second major of a joint or concurrent degree program in which the applicant plans to enroll. Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_ID_SHRT_NAM Students applying for multiple majorswill have the same APPLICATION_F.APPL_REC_LINK_ID values and pivoted into multiple rows in APPLICATION_REFERENCE_D
50 N/A N/A Major Name Proposed-3 Stu_GAD_Applic_Tbl Major_Name_Proposed_3 The name of the major in which the applicant plans to enroll or the name of the third major of a joint or concurrent degree program in which the applicant plans to enroll. Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_ID_SHRT_NAM Students applying for multiple majorswill have the same APPLICATION_F.APPL_REC_LINK_ID values and pivoted into multiple rows in APPLICATION_REFERENCE_D
51 N/A N/A Program Category Code Proposed Stu_GAD_Applic_Tbl Program_Category_Code_Proposed_GAD Code indicating whether a student's proposed program of study is considered, for budgetary purposes, a general campus, a health science, or a marine science program, as of the end of the third week of classes. G' = General Campus
'
H' = Health Science
'
M' = Marine Science
GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_HLTH_SCI_IND  
52 N070 Registered Code N/A Stu_GAD_Applic_Tbl Registered_Code Code indicating that the applicant has registered at UC. Y' = Yes
'
N' = No
GAD_BI APPLICATION_REFERENCE_D APPL_REF_REGD_FL  
53 H020 Gender N/A Stu_GAD_Applic_Tbl Sex_Code Code identifying a person as male or female. F' = Female
'
M' = Male
'
U' or ' '=Unknown
GAD_BI APPLICANT_D AL_GNDR_CD  
54 N/A N/A Source School Location Name Stu_GAD_Applic_Tbl Source_School_Location_Name Name of the country (if school is outside the U.S.), state (if outside California), or county (if within California) of the school of origin.    N/A N/A N/A  
55 N020 Quarter Applied for Code N/A Stu_GAD_Applic_Tbl Term_Applied Term student applied for Fall
Spring
Summer
Winter
GAD_BI TERM_D T_NAM  
56 N/A N/A UC Discipline Code Proposed-1 Stu_GAD_Applic_Tbl UC_Discipline_Code_Proposed_GAD Code indicating the U.C. discipline in which a graduate applicant plans to enroll. Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_UC_DISCIPLN_CD  
57 N/A N/A UC Discipline Name Proposed-1 Stu_GAD_Applic_Tbl UC_Discipline_Name_Proposed_GAD Name of the U.C. discipline in which a graduate applicant plans to enroll. Refer to Campus College Major Code Table GAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_UC_DISCIPLN_NAM  
58 Q090 Date UG Degree Awarded N/A Stu_GAD_Applic_Tbl Undergraduate_Degree_Date Year the most recent undergraduate degree was awarded to a graduate applicant.   GAD_BI APPLICATION_F APPL_UGRAD1_YR  
59 N/A N/A Undergraduate School Accredited Stu_GAD_Applic_Tbl Undergraduate_School_Accredited Accreditation indicator for the institution where the graduate student earned an undergraduate degree. Y' = Accredited
'
N' = Not Accredited
GAD_BI ATP_SCHOOL_D ATP_SCH_ACCRED_FL  
60 N/A N/A Undergraduate School Address1 Stu_GAD_Applic_Tbl Undergraduate_School_Address1 First line of the address for the institution where the graduate student earned an undergraduate degree.   GAD_BI ATP_SCHOOL_D ATP_SCH_ADDR_LN1  
61 N/A N/A Undergraduate School Address2 Stu_GAD_Applic_Tbl Undergraduate_School_Address2 Second line of the address for the institution where the graduate student earned an undergraduate degree.   GAD_BI ATP_SCHOOL_D ATP_SCH_ADDR_LN2  
62 Q080 Institution Awarding UG Degree N/A Stu_GAD_Applic_Tbl Undergraduate_School_ATP_Code Code indicating the institution awarding a graduate applicant's undergraduate degree. Refer to ATP School Code Table GAD_BI ATP_SCHOOL_D ATP_SCH_ATP_CD  
63 N/A N/A Undergraduate School ATP Type Stu_GAD_Applic_Tbl Undergraduate_School_ATP_Type ATP type code for the institution where the graduate student earned an undergraduate degree. 2Y' = Two-year College
'
4Y' = Four-year College or University
'
AS' = Other College or University - Unspecified
'
CC' = California Community College
'
CS' = California State University
'
FH' = Foreign High School
'
FR' = Foreign Institution - Unspecified
'
FS' = Foreign Two/Four-year College or University
'
HS' = High School
'
OT' = Other
'
UC' = University of California
GAD_BI ATP_SCHOOL_D ATP_SCH_TY_CD  
64 N/A N/A Undergraduate School City Stu_GAD_Applic_Tbl Undergraduate_School_City City location for the institution where the graduate student earned an undergraduate degree. Refer to ATP School Code Table GAD_BI ATP_SCHOOL_D ATP_SCH_CTY_NAM  
65 N/A N/A Undergraduate School Location Code Stu_GAD_Applic_Tbl Undergraduate_School_Location_Code School location code as outlined in the Corporate Student System (CSS) Location Code table. Refer to ATP School Code Table GAD_BI ATP_SCHOOL_D ATP_SCH_LOC_CD  
66 N/A N/A Undergraduate School Name Stu_GAD_Applic_Tbl Undergraduate_School_Name Name of the institution where the graduate student earned an undergraduate degree. Refer to ATP School Code Table GAD_BI ATP_SCHOOL_D ATP_SCH_NAM  
67 N/A N/A Undergraduate School SDE Code Stu_GAD_Applic_Tbl Undergraduate_School_SDE_Code State Department of Education code for the institution where the graduate student earned an undergraduate degree. Refer to ATP School Code Table GAD_BI ATP_SCHOOL_D ATP_SCH_SDE_CD  
68 N/A N/A Undergraduate School State Stu_GAD_Applic_Tbl Undergraduate_School_State State location for the institution where the graduate student earned an undergraduate degree. Refer to ATP School Code Table GAD_BI ATP_SCHOOL_D ATP_SCH_ST_CD  
69 N/A N/A Undergraduate School Status Stu_GAD_Applic_Tbl Undergraduate_School_Status Status code (public, private or unknown) for the institution where the graduate student earned an undergraduate degree. PR' = Private
'
PU' = Public
'
UN' = Unknown
School Type
GAD_BI ATP_SCHOOL_D ATP_SCH_STAT_CD  
70 N/A N/A Undergraduate School Zip Stu_GAD_Applic_Tbl Undergraduate_School_Zip Zip code for the institution where the graduate student earned an undergraduate degree.   GAD_BI ATP_SCHOOL_D ATP_SCH_ZIP_CD  
71 N010 Year Applied For N/A Stu_GAD_Applic_Tbl Year_Applied_AY Academic year student applied for   GAD_BI TERM_D T_ACAD_YR  
72 Q120 Military_Service_Status N/A Stu_GAD_Applic_Tbl Military_Status Code Indicating the military service status of applicant. 1' = Veteran (discharged; no longer serving on active duty or in the Reserve or National Guard)
'
2' = On Active Duty
'
3' = Reservist
'
8' = National Guard Member
" " = None of the above/blank
GAD_BI APPLICANT_D AL_MILIT_STAT_CD  
73 Q121 Applicant_Name N/A Stu_GAD_Applic_Tbl Applicant_Name Applicant Name   GAD_BI APPLICANT_D AL_AL_FST_NAM
AL_AL_MID_NAM
AL_AL_LST_NAM