# 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 NOTES Data Mart Schema Name Data Mart Table Name Data Mart Column Name MAPPED
1   Year Applied For   Stu_UAD_All_Applic_Tbl Year_Applied     UAD_BI TERM_D T_CLND_YR   IRAP_BI UAD_DM CALENDAR_YR
2 N020 Term Applied For   Stu_UAD_All_Applic_Tbl Term_Applied_Code Code indicating the academic quarter in which the applicant wishes to commence his/her studies 2 = Fall
3 = Winter
4 = Spring		 UAD_BI TERM_D T_CD   IRAP_BI UAD_DM TERM_CD
3 N210 Identification Number-ETS   Stu_UAD_All_Applic_Tbl Identification_Number_ETS Number assigned by the Educational Testing Service (ETS) to uniquely identify an undergraduate student applicant.   UAD_BI APPLICATION_F-------------------------------->
CAMPUS_APPLIED_F-------------------------->
APPLICATION_ADM_PROGRAM_F---------->
EXTRA_CURRICULAR_ACTIVITY_F----------->
HS_COURSE_COUNT_F----------------------->
TEST_F------------------------------------------>		 APPL_ID
CMP_APPLD_AL_ID
APPL_ADM_PGM_APPL_ID
XTR_CURICULR_ACTY_APPL_ID
HS_CRSE_CNT_APPL_ID
TST_APPL_ID		 Application ID exists in all fact tables. It is prefixed with the table name to which it belongs. IRAP_BI UAD_DM APPLICATION_ID
4 F380   ACT Composite Score-Best Stu_UAD_All_Applic_Tbl ACT_Composite_Score_Best IF ACTSCRMTH GT 0 AND ACTSCREA GT 0 AND ACTSCRSCI GT 0 AND ACTSCRENG GT 0 THEN (ACTSCRMTH + ACTSCRREA + ACTSCRSCI + ACTSCRENG) / 4 ELSE 0; (rounded) ..   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='ACT'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='ACT_COMPOSITE_BEST'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='ACT'
TEST_CATALOG_D.TST_CATLG_ETS_BUS_NAM='ACT Composite Score-Best'
Note: See cell comment		 IRAP_BI UAD_DM  
5 U370 ACT Composite Score-Self-reported   Stu_UAD_All_Applic_Tbl ACT_Composite_Score_SR The Composite score on the American College Test (ACT) as reported by the applicant.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='ACT'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='ACT_COMPOSITE_BEST'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='ACT'
TEST_CATALOG_D.TST_CATLG_ETS_BUS_NAM='ACT Composite Score-Self-reported'		 IRAP_BI UAD_DM  
6 F390 ACT English Score-Best   Stu_UAD_All_Applic_Tbl ACT_English_Score_Best Score received in the American College Testing Program's English aptitude test in the sitting at which the best composite score was received.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='ACT'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='ACT_ENGLISH_BEST'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='ACT'		 IRAP_BI UAD_DM  
7 F400 ACT Math Score-Best   Stu_UAD_All_Applic_Tbl ACT_Math_Score_Best Score received in the American College Testing Program's mathematical aptitude test in the sitting at which the best composite score was received.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='ACT'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='ACT_MATH_BEST'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='ACT'		 IRAP_BI UAD_DM  
8     ACT Science Score-Best Stu_UAD_All_Applic_Tbl ACT_Science_Score_Best ACT Science subscore. Rollup from campus provided information   UAD_BI TEST_F TST_SCO VTST_CATLG_M_TST_CATG_CD='ACT'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='ACT_SCIENCE_BEST'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='ACT'		 IRAP_BI UAD_DM  
9     ACT Reading Score-Best Stu_UAD_All_Applic_Tbl ACT_Reading_Score_Best ACT Reading subscore. Rollup from campus reported information.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='ACT'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='ACT_READING_BEST'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='ACT'		 IRAP_BI UAD_DM  
10     Address City Line Stu_UAD_All_Applic_Tbl Address_City_Line Applicant's city address   UAD_BI APPLICANT_D AL_CUR_ADDR_CTY_NAM   IRAP_BI UAD_DM  
11     Address Line 1 Stu_UAD_All_Applic_Tbl Address_Line_1 Applicant's street address   UAD_BI APPLICANT_D AL_CUR_ADDR_LN1_TXT   IRAP_BI UAD_DM  
12     Address Zip Stu_UAD_All_Applic_Tbl Address_Zip Applicant's ZIP code   UAD_BI APPLICANT_D AL_CUR_ADDR_PSTL_CD   IRAP_BI UAD_DM  
13     Admit Regular Flag Stu_UAD_All_Applic_Tbl Admit_Regular_Flag Code indicating applicant was regularly admitted at the campus registered if the student registered, at the campus at which the student submitted a Statement of Intent to Register (if the student SIR'ed), or at any campus if the student did not register or submit a Statement of Intent to Register. 1 - Yes
0 - No		 UAD_BI APPLICATION_F APPL_ADT_REGLR_CNT   IRAP_BI UAD_DM REGLR_ADM_CNT
14     Admit Special Flag Stu_UAD_All_Applic_Tbl Admit_Special_Flag Code indicating applicant was admitted by special action at the campus registered if the student registered, at the campus at which the student submitted a Statement of Intent to Register (if the student SIR'ed), or at any campus (and not regularly admitted at any campus) if the student did not register or submit a Statement of Intent to Register. 1 - Yes
0 - No		 UAD_BI APPLICATION_F APPL_ADT_SPEC_CNT   IRAP_BI UAD_DM SPECIAL_ADM_CNT
15     Admitted Other Priority Flag Stu_UAD_All_Applic_Tbl Admitted_Other_Priority_Flag Code indicating the campus reviewed the application and the student was eligible but not retained. Student did not register, submit a SIR, defer, have a falsified application cancelled, or have an offer of admission withdrawn due to failure to meet provision of offer, or receive alternate admission offer #2 at another campus 1 - Yes
0 - No		 UAD_BI APPLICATION_F APPL_ADTD_OTH_PRITY_FL_CNT   IRAP_BI UAD_DM  
16     Admitted Other Rollover Flag Stu_UAD_All_Applic_Tbl Admitted_Other_Rollover_Flag Code indicating student offered alternate admission #2, a community college contract with priority or guaranteed admission as an advanced standing student pending good academic work. Student has not necessarily accepted the offer. Student did not register, submit a SIR, defer, have a falsified application cancelled at, or have an offer of admission withdrawn due to failure to meet provision of offer at another campus 1 - Yes
0 - No		 UAD_BI APPLICATION_F APPL_ADTD_OTH_RLVR_FL_CNT   IRAP_BI UAD_DM  
17     Age on October 15 Stu_UAD_All_Applic_Tbl Age_on_October_15 Age of student on October 15 of the academic year   UAD_BI APPLICANT_D AL_AGE_ON_OCT15_CNT   IRAP_BI UAD_DM AGE_AT_ENTRY
18     Age on October 15-Category Stu_UAD_All_Applic_Tbl Age_on_October_15_Category Code indicating category of age of student on October 15 of the academic year.   UAD_BI APPLICANT_D AL_AGE_ON_OCT15_CATG_INTVL   IRAP_BI UAD_DM  
19 U895 Amount Paid or Method Paid   Stu_UAD_All_Applic_Tbl Amount_Paid_or_Method The code identifying the dollar amount received with an application, or the payment method used for the application. Domestic/International Fee
1 = $60/$70
2 = $120/$140
3 = $180/$210
4 = $240/$280
5 = $300/$350
6 = $360/$420
7 = $420/$490
8 = $480/$560
9 = Other (including N)
0 = $540/$630
E = EAP
P = Pathways
Q= Pathways Fee Waiver
R = Pathways Payment by Credit Card
U = UC Fee Waiver
C = CB Fee Waiver
S= EOPS/CCC FW
L = Approved Letter
Effective Fall 2006		 UAD_BI FEE_D FEE_AMT_PD_METH_CD   IRAP_BI UAD_DM  
20 U500 AP English Language Exam Score   Stu_UAD_All_Applic_Tbl AP_Language_Score The score on the Advanced Placement English Language Examination.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='AP'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='AP_LANGUAGE'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='APLanguage'		 IRAP_BI UAD_DM  
21 U510 AP English Literature Exam Score   Stu_UAD_All_Applic_Tbl AP_Literature_Score The score on the Advanced Placement English Literature Examination.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='AP'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='AP_LITERATURE'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='APLiterature'		 IRAP_BI UAD_DM  
22     Applicant Freshman-CA High School Stu_UAD_All_Applic_Tbl Applicant_Freshman_CAHS Code indicating student was admitted as a freshman and whose source school was a California high school Y = Yes
blank = No		 UAD_BI APPLICATION_F APPL_AL_FRSHMN_CAHS_IND   IRAP_BI UAD_DM  
23     Applicant Level Code Stu_UAD_All_Applic_Tbl Applicant_Level_Code Code indicating the academic status for which the applicant qualifies. 1 = EAXP-Early Admission Accelerated Program
2 = Freshman
3 = Advanced Standing-Freshman
4 = Advanced Standing-Sophomore
5 = Advanced Standing-Junior
6 = Advanced Standing-Senior
7 = Limited
8 = Special
9 = 2nd Baccalaureate
0 = DAP (Dual Admission)		 UAD_BI CAMPUS_ELIGIBILITY_D CMP_ELGBLTY_AL_LVL_CD   IRAP_BI UAD_DM APPL_LVL_CD
24     Applicant Level Code - 3CAT Stu_UAD_All_Applic_Tbl Applicant_Level_Code_3CAT Code indicating the academic status for which the applicant qualifies. F = Freshman
T = Transfer
O = Other		 UAD_BI CAMPUS_ELIGIBILITY_D CMP_ELGBLTY_AL_LVL_3CAT_CD   IRAP_BI UAD_DM  
25     Applicant Transfer-CA Community College Stu_UAD_All_Applic_Tbl Applicant_Transfer_CCC Code indicating student was admitted as a transfer and whose source school was a California Community College. Y = Yes
blank = No		 UAD_BI APPLICATION_F APPL_AL_TR_CCC_IND   IRAP_BI UAD_DM  
26 U080 Application Recevied Code-Berkeley   Stu_UAD_All_Applic_Tbl Application_Received_Code_BK Code indicating the type of undergraduate application received at the Irvine campus. 1 Original application
2 = Applicant initiated added campus choice
3 = Campus authorized added campus choice even though campus was closed
4 = Campus referral added campus choice
6 - OP/UCAP authorized ACC
7-Campus Early Referral ACC
Blank = Not released to this campus.		 UAD_BI CAMPUS_CODE_D CMP_CD_APPL_TY_UCAP_CD Join CAMPUS_PPLIED_F TO CAMPUS_LOCATION_D  and CAMPUS_CODE_D Where CMP_LOC_LOC1_CD=01
Note: See cell comment		 IRAP_BI UAD_DM  
27 U090 Application Recevied Code-Davis   Stu_UAD_All_Applic_Tbl Application_Received_Code_DV Code indicating the type of undergraduate application received at the Berkeley campus. 1 Original application
2 = Applicant initiated added campus choice
3 = Campus authorized added campus choice even though campus was closed
4 = Campus referral added campus choice
6 - OP/UCAP authorized ACC
7-Campus Early Referral ACC
Blank = Not released to this campus.		 UAD_BI CAMPUS_CODE_D CMP_CD_APPL_TY_UCAP_CD Join CAMPUS_PPLIED_F TO CAMPUS_LOCATION_D  and CAMPUS_CODE_D Where  CMP_LOC_LOC1_CD=03 IRAP_BI UAD_DM  
28 U100 Application Recevied Code-Irvine   Stu_UAD_All_Applic_Tbl Application_Received_Code_IR Code indicating the type of undergraduate application received at the Irvine campus. 1 Original application
2 = Applicant initiated added campus choice
3 = Campus authorized added campus choice even though campus was closed
4 = Campus referral added campus choice
6 - OP/UCAP authorized ACC
7-Campus Early Referral ACC
Blank = Not released to this campus.		 UAD_BI CAMPUS_CODE_D CMP_CD_APPL_TY_UCAP_CD Join CAMPUS_PPLIED_F TO CAMPUS_LOCATION_D  and CAMPUS_CODE_D Where  CMP_LOC_LOC1_CD=09 IRAP_BI UAD_DM  
29 U110 Application Recevied Code-Los Angeles   Stu_UAD_All_Applic_Tbl Application_Received_Code_LA Code indicating the type of undergraduate application received at the Los Angeles campus. 1 Original application
2 = Applicant initiated added campus choice
3 = Campus authorized added campus choice even though campus was closed
4 = Campus referral added campus choice
6 - OP/UCAP authorized ACC
7-Campus Early Referral ACC
Blank = Not released to this campus.
 UAD_BI CAMPUS_CODE_D CMP_CD_APPL_TY_UCAP_CD Join CAMPUS_PPLIED_F TO CAMPUS_LOCATION_D  and CAMPUS_CODE_D Where  CMP_LOC_LOC1_CD=04 IRAP_BI UAD_DM  
30   Application Received Code-Merced   Stu_UAD_All_Applic_Tbl Application_Received_Code_MC Code indicating the type of undergraduate application received at the Merced campus  1 Original application
2 = Applicant initiated added campus choice
3 = Campus authorized added campus choice even though campus was closed
4 = Campus referral added campus choice
6 - OP/UCAP authorized ACC
7-Campus Early Referral ACC
Blank = Not released to this campus.		 UAD_BI CAMPUS_CODE_D CMP_CD_APPL_TY_UCAP_CD Join CAMPUS_PPLIED_F TO CAMPUS_LOCATION_D  and CAMPUS_CODE_D Where  CMP_LOC_LOC1_CD=10 IRAP_BI UAD_DM  
31  U120 Application Recevied Code-Riverside   Stu_UAD_All_Applic_Tbl Application_Received_Code_RV Code indicating the type of undergraduate application received at the Riverside campus.  1 Original application
2 = Applicant initiated added campus choice
3 = Campus authorized added campus choice even though campus was closed
4 = Campus referral added campus choice
6 - OP/UCAP authorized ACC
7-Campus Early Referral ACC
Blank = Not released to this campus.		 UAD_BI CAMPUS_CODE_D CMP_CD_APPL_TY_UCAP_CD Join CAMPUS_PPLIED_F TO CAMPUS_LOCATION_D  and CAMPUS_CODE_D Where  CMP_LOC_LOC1_CD=05 IRAP_BI UAD_DM  
32 U140 Application Recevied Code-Santa Barbara   Stu_UAD_All_Applic_Tbl Application_Received_Code_SB Code indicating the type of undergraduate application received at the Santa Barbara campus. 1 Original application
2 = Applicant initiated added campus choice
3 = Campus authorized added campus choice even though campus was closed
4 = Campus referral added campus choice
6 - OP/UCAP authorized ACC
7-Campus Early Referral ACC
Blank = Not released to this campus		 UAD_BI CAMPUS_CODE_D CMP_CD_APPL_TY_UCAP_CD Join CAMPUS_PPLIED_F TO CAMPUS_LOCATION_D  and CAMPUS_CODE_D Where  CMP_LOC_LOC1_CD=08 IRAP_BI UAD_DM  
33 U150 Application Recevied Code-Santa Cruz   Stu_UAD_All_Applic_Tbl Application_Received_Code_SC Code indicating the type of undergraduate application received at the Santa Cruz campus  1 Original application
2 = Applicant initiated added campus choice
3 = Campus authorized added campus choice even though campus was closed
4 = Campus referral added campus choice
6 - OP/UCAP authorized ACC
7-Campus Early Referral ACC
Blank = Not released to this campus.
 		 UAD_BI CAMPUS_CODE_D CMP_CD_APPL_TY_UCAP_CD Join CAMPUS_PPLIED_F TO CAMPUS_LOCATION_D  and CAMPUS_CODE_D Where  CMP_LOC_LOC1_CD=07 IRAP_BI UAD_DM  
34 U130 Application Recevied Code-San Diego   Stu_UAD_All_Applic_Tbl Application_Received_Code_SD Code indicating the type of undergraduate application received at the San Diego campus. 1 Original application
2 = Applicant initiated added campus choice
3 = Campus authorized added campus choice even though campus was closed
4 = Campus referral added campus choice
6 - OP/UCAP authorized ACC
7-Campus Early Referral ACC
Blank = Not released to this campus		 UAD_BI CAMPUS_CODE_D CMP_CD_APPL_TY_UCAP_CD Join CAMPUS_PPLIED_F TO CAMPUS_LOCATION_D  and CAMPUS_CODE_D Where  CMP_LOC_LOC1_CD=06 IRAP_BI UAD_DM  
35  H010 Date of Birth   Stu_UAD_All_Applic_Tbl Birthdate The year, month and day on which the person was born.   UAD_BI APPLICANT_D AL_BTH_DT   IRAP_BI UAD_DM AL_DATE_OF_BTH
36 F170 Prior Campus-ICT Applicant   Stu_UAD_All_Applic_Tbl Campus_ICT_Applicant Code indicating UC campus of applicant's current or most recent attendance. 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		 UAD_BI APPLICATION_F/CAMPUS_LOCATION_D CMP_LOC_LOC1_CD Join CAMPUS_LOCATION_D TO APPLICATION_F (CMP_MST_RCNT_ATTD_KEY=CMP_LOC_KEY) IRAP_BI UAD_DM  
37     Campus Name Abbreviation REG Stu_UAD_All_Applic_Tbl Campus_Name_Abbreviation_REG Two-character abbreviation of campus name at which student registered.   UAD_BI APPLICATION_F/CAMPUS_LOCATION_D CMP_LOC_LOC1_ABRV_DESC Join CAMPUS_LOCATION_D TO APPLICATION_F (CMP_REGD_KEY=CMP_LOC_KEY) IRAP_BI UAD_DM  
38     Campus Name Abbreviation SIR Stu_UAD_All_Applic_Tbl Campus_Name_Abbreviation_SIR Two-character abbreviation of campus name at which student submitted a Statement of Intent to Register. ">1" if student SIRed at more than one campuses.   UAD_BI APPLICATION_F/CAMPUS_LOCATION_D CMP_LOC_LOC1_ABRV_DESC Join CAMPUS_LOCATION_D TO APPLICATION_F (CMP_SIR_KEY=CMP_LOC_KEY) IRAP_BI UAD_DM  
39     Campus Name REG Stu_UAD_All_Applic_Tbl Campus_Name_REG Name of campus at which student registered.   UAD_BI APPLICATION_F/CAMPUS_LOCATION_D CMP_LOC_LOC1_LNG_DESC Join CAMPUS_LOCATION_D TO APPLICATION_F (CMP_REGD_KEY=CMP_LOC_KEY) IRAP_BI UAD_DM  
40     Campus Name SIR Stu_UAD_All_Applic_Tbl Campus_Name_SIR Name of campus at which student submitted a Statement of Intent to Register. ">1" if student SIRed at more than one campuses.   UAD_BI APPLICATION_F/CAMPUS_LOCATION_D CMP_LOC_LOC1_LNG_DESC Join CAMPUS_LOCATION_D TO APPLICATION_F (CMP_SIR_KEY=CMP_LOC_KEY) IRAP_BI UAD_DM  
41     Cancelled by Student Flag Stu_UAD_All_Applic_Tbl Cancelled_by_Student_Flag  Code indicating an applicant has voluntarily cancelled an application prior to evaluation. Student did not register, submit a SIR, defer, have a falsified application cancelled, or have an offer of admission withdrawn due to failure to meet provision of offer, or receive alternate admission offer #2, or have application cancelled due to death at another campus.   UAD_BI APPLICATION_F APPL_CCLD_BY_STUD_FL   IRAP_BI UAD_DM  
42     Cancelled Death Flag Stu_UAD_All_Applic_Tbl Cancelled_Death_Flag Code indicating a campus has cancelled an application due to death. Student did not register, submit a SIR, defer, have a falsified application cancelled, or have an offer of admission withdrawn due to failure to meet provision of offer, or receive alternate admission offer #2 at another campus 1 - Yes
0 - No		 UAD_BI APPLICATION_F APPL_CCLD_DEATH_FL   IRAP_BI UAD_DM  
43     Cancelled Falsification Flag Stu_UAD_All_Applic_Tbl Cancelled_Falsification_Flag Code indicating a campus has cancelled an application due to student falsification. Student did not register, submit a SIR, or defer at another campus 1 - Yes
0 - No		 UAD_BI APPLICATION_F APPL_CCLD_FLSFCN_FL   IRAP_BI UAD_DM  
44     Cancelled Offer Withdrawn Flag Stu_UAD_All_Applic_Tbl Cancelled_Offer_Withdrawn_Flag Code indicating a campus has withdrawn an offer of admission due to failure of student to meet provisions of offer. Student did not register, submit a SIR, defer, or have a falsified application cancelled at another campus. 1 - Yes
0 - No		 UAD_BI APPLICATION_F APPL_CCLD_OFFR_WTDRN_FL   IRAP_BI UAD_DM  
45     Charged School Accredited Code Stu_UAD_All_Applic_Tbl Charged_School_Accredited  Accreditation indicator for the school of origin attributed to the undergraduate applicant. Y = Yes
blank = No		 UAD_BI ATP_SCHOOL_D ATP_SCH_ACCRED_FL   IRAP_BI UAD_DM  
46     Charged School Address Line 1 Stu_UAD_All_Applic_Tbl Charged_School_Address1 First line of the address for the school of origin attributed to the undergraduate applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_ADDR_LN1   IRAP_BI UAD_DM  
47     Charged School Address Line 2 Stu_UAD_All_Applic_Tbl Charged_School_Address2  Second line of the address for the school of origin attributed to the undergraduate applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_ADDR_LN2   IRAP_BI UAD_DM  
48     Charged School Approved Code Stu_UAD_All_Applic_Tbl Charged_School_Approved  Approval indicator for the school of origin attributed to the undergraduate applicant. Y = Yes
blank = No		 UAD_BI ATP_SCHOOL_D ATP_SCH_APRVL_FL   IRAP_BI UAD_DM  
49     Charged School Area Type Stu_UAD_All_Applic_Tbl Charged_School_Area_Type Area type code for the school of origin attributed to the undergraduate applicant. 1 = Rural
2 = Suburban
3 = Urban		 UAD_BI ATP_SCHOOL_D ATP_SCH_AREA_TY_CD   IRAP_BI UAD_DM  
50 T250 Charged School ATP Code   Stu_UAD_All_Applic_Tbl Charged_School_ATP_Code Code indicating the school of origin attributed to the undergraduate applicant Refer to School Code Table. UAD_BI ATP_SCHOOL_D ATP_SCH_ATP_CD   IRAP_BI UAD_DM  
51     Charged School ATP Type Code Stu_UAD_All_Applic_Tbl Charged_School_ATP_Type ATP type code (HS, 2Y, 4Y, etc) for the school of origin attributed to the undergraduate applicant. 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		 UAD_BI ATP_SCHOOL_D ATP_SCH_TY_CD   IRAP_BI UAD_DM  
52     Charged School City Stu_UAD_All_Applic_Tbl Charged_School_City City location for the school of origin attributed to the undergraduate applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_CTY_NAM   IRAP_BI UAD_DM  
53     Charged School California District Code Stu_UAD_All_Applic_Tbl Charged_School_District_Code California school district code for the school of origin attributed to the undergraduate applicant. Refer to School District Code Table. UAD_BI ATP_SCHOOL_D ATP_SCH_DSTR_CD   IRAP_BI UAD_DM  
54     Charged School Location Code Stu_UAD_All_Applic_Tbl Charged_School_Location_Code Location code for the school of origin attributed to the undergraduate applicant. Refer to Location Code Table. UAD_BI ATP_SCHOOL_D ATP_SCH_LOC_CD   IRAP_BI UAD_DM  
55     Charged School Name Stu_UAD_All_Applic_Tbl Charged_School_Name Name of the school of origin attributed to the undergraduate applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_NAM   IRAP_BI UAD_DM  
56     Charged School SDE Code Stu_UAD_All_Applic_Tbl Charged_School_SDE_Code State Department of Education code for the school of origin attributed to the undergraduate applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_SDE_CD   IRAP_BI UAD_DM  
57     Charged School State Stu_UAD_All_Applic_Tbl Charged_School_State State location for the school of origin attributed to the undergraduate applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_ST_CD   IRAP_BI UAD_DM  
58     Charged School Status Code Stu_UAD_All_Applic_Tbl Charged_School_Status Status code (public, private or unknown) for the school of origin attributed to the undergraduate applicant. PR = Private
PU = Public
UN = Unknown
School Type		 UAD_BI ATP_SCHOOL_D ATP_SCH_STAT_CD   IRAP_BI UAD_DM  
59     Charged School Type Code Stu_UAD_All_Applic_Tbl Charged_School_Type Code indicating the type of school of origin A = California Public High School
B = California Private High School
C = California Public 2-Year College
D = California Private 2-Year College
E = California Public 4-Year College (CSU)
F = California Private 4 Year College
G = University of California
H = Other (not to include unknown)
K = Non-California Institution (US) L = Foreign Institution		 UAD_BI ATP_SCHOOL_D ATP_SCH_DRVD_TY_CD   IRAP_BI UAD_DM  
60     Charged School Zip Code Stu_UAD_All_Applic_Tbl Charged_School_Zip Zip code for the school of origin attributed to the undergraduate applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_ZIP_CD   IRAP_BI UAD_DM  
61     Citizenship Status Adm-2CAT Stu_UAD_All_Applic_Tbl Citizenship_Status_Adm_2CAT Two-category code indicating domestic or foreign citizenship/visa status. Recode of CITSTATA.  D = Domestic
F = Foreign		 UAD_BI APPLICANT_D AL_CTZN_STAT_ADM_2CAT_CD   IRAP_BI UAD_DM CTZN_STAT_ADM_2CAT_CD
62 F060   Citizenship Status Code-Admission Stu_UAD_All_Applic_Tbl Citizenship_Status_Code_Adm Code indicating student's citizenship status with respect to the United States at the time of application for admission. UAD define: CITSTATA = IF IUS_CIT EQ '1' THEN 'US' ELSE IF IVISA_TYPEP EQ 'IM' THEN 'PR' ELSE IF IVISA_TYPEP NE ' ' THEN IVISA_TYPEP ELSE IF IVISA_TYPE EQ 'IM' THEN 'PR' ELSE IF IVISA_TYPE NE ' ' THEN IVISA_TYPE ELSE 'OT';  Refer to Citizenship/Visa Status Code Table. UAD_BI APPLICANT_D AL_CTZN_CD   IRAP_BI UAD_DM  
63 U880 Counselor Release Flag   Stu_UAD_All_Applic_Tbl Counselor_Release_Flag Code indicating the applicant has authorized release of information to school or college counselor/counseling office. Y = Yes
blank = No		 UAD_BI APPLICANT_RELEASE_CODE_D AL_RL_TO_CNSLRS_CD   IRAP_BI UAD_DM  
64  U010 Academic Courses-Grade A   Stu_UAD_All_Applic_Tbl Courses_Academic_Grade_A The number of self-reported academic semester courses in the A-F subject Areas, including honors level courses, in which the applicant received a grade of "A" in 10th and 11th grade.   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=AcademicCoursesA Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='AcademicCoursesA' IRAP_BI UAD_DM HSCRSE_TYP_ACADCRSE_A 
65 U020  Academic Courses-Grade B   Stu_UAD_All_Applic_Tbl Courses_Academic_Grade_B The number of self-reported academic semester courses in the A-F subject Areas, including honors level courses, in which the applicant received a grade of "B" in 10th and 11th grade.   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=AcademicCoursesB Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='AcademicCoursesB' IRAP_BI UAD_DM HSCRSE_TYP_ACADCRSE_B 
66 U030 Academic Courses-Grade C   Stu_UAD_All_Applic_Tbl Courses_Academic_Grade_C The number of self-reported academic semester courses in the A-F Subject Areas, including honors level courses, in which the applicant received a grade of "C" in 10th and 11th grade.   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=AcademicCoursesC Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='AcademicCoursesC' IRAP_BI UAD_DM HSCRSE_TYP_ACADCRSE_C 
67 U040 Academic Courses-Grade D   Stu_UAD_All_Applic_Tbl Courses_Academic_Grade_D The number of self-reported academic semester courses in the A-F Subject Area, including honors level courses, in which the applicant received a grade of "D" in 10th and 11th grade.   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=AcademicCoursesD Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='AcademicCoursesD' IRAP_BI UAD_DM HSCRSE_TYP_ACADCRSE_D
68 U050 Academic Courses-Grade F   Stu_UAD_All_Applic_Tbl Courses_Academic_Grade_F The number of self-reported academic semester courses in the A-F Subject Area, including honors level courses, in which the applicant received a grade of "F" in 10th and 11th grade.   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=AcademicCoursesF Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='AcademicCoursesF' IRAP_BI UAD_DM HSCRSE_TYP_ACADCRSE_F 
69 U060 Honors Courses-10th and 11th    Stu_UAD_All_Applic_Tbl Courses_Honors_1011_Grade The number of self-reported honors level semester courses in the A-F Subject Areas taken in the 10th & 11th grade.   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=AcademicHonors1011 Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='AcademicHonors1011' IRAP_BI UAD_DM HSCRSE_TYP_ACADHONRS_1011
70 U071 Honors Courses-10th Grade   Stu_UAD_All_Applic_Tbl Courses_Honors_10th_Grade  The number of self-reported honors level semester courses in the A-F Subject Areas taken in the 10th grade.   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=AcademicHonors10 Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='AcademicHonors10' IRAP_BI UAD_DM HSCRSE_TYP_ACADHONRS_10
71 U072
 Honors Courses-11th Grade   Stu_UAD_All_Applic_Tbl Courses_Honors_11th_Grade The number of self-reported honors level semester courses in the A-F Subject Areas taken in the 11th grade.   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=AcademicHonors11 Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='AcademicHonors11' IRAP_BI UAD_DM HSCRSE_TYP_ACADHONRS_11
72 U070 Honors Courses-12th Grade   Stu_UAD_All_Applic_Tbl Courses_Honors_12th_Grade The number of self-reported honors level semester courses in the A-F Subject Areas in progress or planned in the 12th grade.   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=AcademicHonors12 Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='AcademicHonors12' IRAP_BI UAD_DM HSCRSE_TYP_ACADHONRS_12
73 U400 Total Courses-11th Grade   Stu_UAD_All_Applic_Tbl Courses_Total_11th_Grade  The number of self-reported semester courses taken in the 11th grade in the A-F Subject Areas (U.S. history/government, English, mathematics, laboratory science, foreign language and college preparatory electives).   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=SemesterCourses11 Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='SemesterCourses11' IRAP_BI UAD_DM  
74 U380  Total Courses-12th Grade Fall   Stu_UAD_All_Applic_Tbl Courses_Total_12th_Fall The number of self-reported semester courses in progress during 12th grade, fall semester, in the A-F Subject Areas (U.S. history/government, English, mathematics, laboratory science, foreign language and college preparatory electives).   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=SemCoursesFall12 Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='SemCoursesFall12' IRAP_BI UAD_DM  
75 U390 Total Courses-12th Grade Spring   Stu_UAD_All_Applic_Tbl Courses_Total_12th_Spring The number of self-reported semester courses planned for 12th grade, spring semester, in the A-F Subject Areas (U.S. history/government, English, mathematics, laboratory science, foreign language and college preparatory electives).   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=SemCoursesSpring12 Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='SemCoursesSpring12' IRAP_BI UAD_DM  
76 U420 Total Courses-Subject A    Stu_UAD_All_Applic_Tbl Courses_Total_Subject_A Total number of U.S. history/government semester courses taken or planned from 9th grade to 12th grade. Accept as written. No attempt to correct invalid applicant response. If indeterminate, field will contain hyphen in the first position. Non-response reported as blank. For Pathways applications, the Pathways system calculates this number. Item 72 on 2002 undergrad application; item 72 on 2003 undergrad application.   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=TotalSemestersB Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='TotalSemestersA' IRAP_BI UAD_DM HSCRSE_TYP_TOTSEMS_A 
77 U430 Total Courses-Subject B    Stu_UAD_All_Applic_Tbl Courses_Total_Subject_B Total number of English semester courses taken or planned from 9th grade to 12th grade. Accept as written. No attempt to correct invalid applicant response. If indeterminate, field will contain hyphen in the first position. Non-response reported as blank. For Pathways applications, the Pathways system calculates this number. Item 73 on 2002 undergrad application; item 73 on 2003 undergrad application.   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=TotalSemestersB Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='TotalSemestersB' IRAP_BI UAD_DM HSCRSE_TYP_TOTSEMS_B 
78 U440  Total Courses-Subject C    Stu_UAD_All_Applic_Tbl Courses_Total_Subject_C Total number of mathematics semester courses taken or planned from 7th grade to 12th grade. This field contains a computer generated sum of GRADE-7-8-COURSE-C and GRADE-9-12-COURSE-C. A hyphen will appear in the first position if a hyphen appears in the first position of either two summed elements. Items 74 and 106 on 2002 undergrad application; items 74 and 107 on 2003 undergrad application.   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=TotalSemestersC Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='TotalSemestersC' IRAP_BI UAD_DM HSCRSE_TYP_TOTSEMS_C
79 U450 Total Courses-Subject D Requirement   Stu_UAD_All_Applic_Tbl Courses_Total_Subject_D Total number of laboratory science semester courses taken or planned from 9th grade to 12th grade. Accept as written. No attempt to correct invalid applicant response. If indeterminate, field will contain hyphen in the first position. Non-response reported as blank. For Pathways applications, the Pathways system calculates this number. Item 75 on 2002 undergrad application; item 75 on 2003 undergrad application.   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=TotalSemestersD Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='TotalSemestersD' IRAP_BI UAD_DM HSCRSE_TYP_TOTSEMS_D
80 U460 Total Courses-Subject E Requirement   Stu_UAD_All_Applic_Tbl Courses_Total_Subject_E Total number of foreign language semester courses taken or planned from 7th grade to 12th grade. This field contains a computer generated sum of GRADE-7-8-COURSE-E and GRADE-9-12- COURSE-E. A hyphen will appear in the first position if a hyphen appears in the first position of either two summed elements. Items 76 and 107 on 2002 undergrad application; items 76 and 108 on 2003 undergrad application.   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=TotalSemestersE Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='TotalSemestersE' IRAP_BI UAD_DM HSCRSE_TYP_TOTSEMS_E
81 U470 Total Courses-Subject F Requirement   Stu_UAD_All_Applic_Tbl Courses_Total_Subject_F Total number of visual and performing arts semester courses taken or planned from 9th grade to 12th grade. (As of Fall 2003, visual and performing arts, during prior years, college preparatory electives) Accept as written. No attempt to correct invalid applicant response. If indeterminate, field will contain hyphen in the first position. Non-response reported as blank. For Pathways applications, the Pathways system calculates this number. Not applicable for 2002; field will be blank; item 77 on 2003 undergrad application.   UAD_BI COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=TotalSemestersF Join HS_COURSE_COUNT_F TO HS_COURSE_TYPE_D WHERE HS_CRSE_TY='ACADEMIC-COURSESF' IRAP_BI UAD_DM HSCRSE_TYP_TOTSEMS_F
82  U200 Current Phone Number   Stu_UAD_All_Applic_Tbl Current_Phone_Number Area code and telephone number the individual has designated for receipt of calls from the University.   UAD_BI APPLICANT_D AL_DY_PHO_NUM   IRAP_BI UAD_DM  
83     Deferment Flag Stu_UAD_All_Applic_Tbl Deferment_Flag Code indicating applicant has been deferred or not retained on at least one campus and has not been retained or admitted on any  Y = Yes
N = No		 UAD_BI APPLICATION_F APPL_DFRMT_FL   IRAP_BI UAD_DM  
84     Deferred by College Flag Stu_UAD_All_Applic_Tbl Deferred_by_College_Flag No longer used? Y = Yes
N = No		 UAD_BI APPLICATION_F APPL_DFRED_BY_CG_FL   IRAP_BI UAD_DM  
85 U760  Dependents of Applicant   Stu_UAD_All_Applic_Tbl Dependents_Applicant Family size of independent student, including applicant, spouse, and other dependents, in calendar year preceding academic year.   UAD_BI APPLICATION_F APPL_AL_PREV_YR_DPNDT_CNT   IRAP_BI UAD_DM  
86 U750 Dependents of Parents of Applicant   Stu_UAD_All_Applic_Tbl Dependents_Parents Family size of dependent student, including applicant, parents, and other dependents, in calendar year preceding academic year.   UAD_BI APPLICATION_F APPL_FMY_PREV_YR_DPNDT_CNT   IRAP_BI UAD_DM  
87 N040   Disability Type Code Stu_UAD_All_Applic_Tbl Disability_Code Code indicating the nature of the disability possessed by those individuals who have identified themselves as being disabled.  A = Acquired brain injury
C = Other communication disability
D = Deaf
E = Other hearing impairment
F = Other functional impairment
L = Learning disability
M = Mobility impairment
S = Speech impairment
W = Other visual impairment
X = Legally blind.		 UAD_BI APPLICANT_D AL_DSBLTY_CD   IRAP_BI UAD_DM DSBLTY_CD
88 U770 Education Level of Father of Applicant   Stu_UAD_All_Applic_Tbl Education_Level_Code_Father Highest level of education attained by the father of the applicant. 1 = No High School
2 = Some High School
3 = High School Graduate
5 = Some College
6 = 2 Year College Graduate
7 = 4 Year College Graduate
8 = Post Graduate Study		 UAD_BI PARENT_EDUCATION_RESIDENCY_D PAR_EDU_RSDNCY_PAR1_EDU_LVL_CD   IRAP_BI UAD_DM  
89 U780 Education Level Code Mother   Stu_UAD_All_Applic_Tbl Education_Level_Code_Mother  Highest level of education attained by the mother of the applicant. 1 = No High School
2 = Some High School
3 = High School Graduate
5 = Some College
6 = 2 Year College Graduate
7 = 4 Year College Graduate
8 = Post Graduate Study		 UAD_BI PARENT_EDUCATION_RESIDENCY_D PAR_EDU_RSDNCY_PAR2_EDU_LVL_CD   IRAP_BI UAD_DM  
90   ELC Code Self Report   Stu_UAD_All_Applic_Tbl ELC_Code_Self_Report ELC identification number as self-reported by applicant.   UAD_BI APPLICATION_F APPL_ELC_SLFRPT_ID   IRAP_BI UAD_DM  
91   ELC Student Idenfification Number   Stu_UAD_All_Applic_Tbl ELC_Student_ID     UAD_BI APPLICATION_F APPL_ELC_STUD_ID   IRAP_BI UAD_DM  
92   ELC Student Graduation Date   Stu_UAD_All_Applic_Tbl ELC_Graduation_Date High school graduate date of ELC-identified applicant.   UAD_BI APPLICATION_F APPL_ELC_GRADN_DT   IRAP_BI UAD_DM  
93 U918 ELC Magnet School Code   Stu_UAD_All_Applic_Tbl ELC_Magnet_School_Code Code indicating that the high school listed in ELCSCHOOL has a magnet program. R = Regular program in a school with a magnet program
A = First magenet program in high school
B = Second magnet program in high school
C = Third magnet program in high school
D = Fourth magnet program in high school
E-Z = Fifth, Sixth, Seventh, etc.
Blank = High School does not have a magnet program.		 UAD_BI ELC_D ELC_MGNT_SCH_CD Join APPLICATION_F TO ELC_D ON ELC_KEY IRAP_BI UAD_DM ELC_MGNT_SCH_CD
94   ELC School Name   Stu_UAD_All_Applic_Tbl ELC_School_Name     UAD_BI ATP_SCHOOL_D ATP_SCH_NAM   IRAP_BI UAD_DM  
95   ELC Student District Code   Stu_UAD_All_Applic_Tbl ELC_Student_District_Code School District Code Number of ELC-identified applicant. Refer to School District Code Table. UAD_BI ATP_SCHOOL_D ATP_SCH_DSTR_CD   IRAP_BI UAD_DM  
96     ELC Student Eligibility Stu_UAD_All_Applic_Tbl ELC_Student_Eligibility ELC Eligible Applicant Code indicating eligibility of student for admission under the Eligibility in the Local Context (ELC) program. Y - Evaluated as ELC eligible L - Evaluated as ELC eligible, coded late S - Evaluated as ELC eligible special Q - E D=On Track for Dual Admissions
N=Matched to ELC file, but not ELC eligible
Q=Qualified on track
Y=ELC Eligible		 UAD_BI ELC_D ELC_STUD_ELGBLTY_CD Join APPLICATION_F TO ELC_D ON ELC_KEY IRAP_BI UAD_DM ELC_ELIG_CODE
97    ELC Student Grade Point Average   Stu_UAD_All_Applic_Tbl ELC_Student_GPA Final evaluated GPA for ELC determination. This GPA is based on the minimum A-F units required by the ELC program.   UAD_BI APPLICATION_F APPL_ELC_STUD_GPA_SCO   IRAP_BI UAD_DM ELC_DET_GPA_SCORE
98   ELC Student School Code   Stu_UAD_All_Applic_Tbl ELC_Student_School_Code ATP school code of high school attended by ELC-identified applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_ATP_CD Join APPLICATION_F TO ATP_SCHOOL_D ON ELC_SCH_KEY=ATP_SCH_KEY IRAP_BI UAD_DM  
99     Eligibility Campus Reg 2CAT Stu_UAD_All_Applic_Tbl Eligibility_Campus_Reg_2CAT Code indicating two-category admission type (regular or special) at the campus at which the student registered. Recode of CELIGADMR.  R = Regular Admit
S = Special Admit		 UAD_BI CAMPUS_ELIGIBILITY_D CMP_ELGBLTY_CMP_REG_2_CAT_CD   IRAP_BI UAD_DM  
100 U160 Eligibility Freshman Estimated   Stu_UAD_All_Applic_Tbl Eligibility_Freshman_Estimated Code indicating potential eligibility for admission to the University of California indicator for domestic first-time freshman applicants only. California residency is determined based on 'yes' to question on California residency, or 'yes' to parent being a current UC employee FOR CALIFORNIA RESIDENTS:
Blank = The applicant is not a domestic first-time freshman.
L = Estimated ELC eligible. The applicant's identifying information has been successfully matched to a record on the official ELC data file.
I = Estimated eligible according to the index. All official or self- reported test scores are present. The applicant's computed GPA and test score total combination are at or above the level in the index table, the minimum number of required semester courses are reported, there are no D or F grades in the 9th, 10th, or 11th grades, and applicant's high school of graduation is an approved school.
K = Estimated eligible according to the index. One or more projected test scores are present and being used. The applicant's computed GPA and test score total combination are at or above the level in the index table, the minimum number of required semester courses are reported, there are no D or F grades in the 9th, 10th, or 11th grades, and applicant's high school of graduation is an approved school - Obsolete fall 2006.
P = Estimated eligible according to the index. One of more projected test scores are present and being used. The applicant's computed GPA and test score total combination are at or above the level in the index table, the minimum number of required semester courses are reported or satisfied by exam, there are no D or F grades in the 9th, 10th or 11th grades that are not cleared by repeated course or validated by advanced course or exam, and applicant's high school of graduation is an approved school - Obsolete Fall 2006.
B = Estimated CEEB eligible. The applicant's official and/or self-reported scores are all present and are at or above the required minimums, but required courses and/ or data necessary to compute GPA are missing, invalid or below requirements.
Hyphen = Eligibility cannot be calculated. The applicant's GPA cannot be calculated, or all required test scores are not reported , or semester course (A-F) totals cannot be calculated.
Q = Estimated ELC qualified on track (QCT)
N=Estimated ELC not ELC Qualified.
S = Estimated eligible for applicant attending out-of-state school. All official, self-reported or projected test scores are present. The applicant’s computed GPA* and test score total combination are at or above the level in the index table, the minimum number of required semester courses are reported or satisfied by exam, there are no D or F grades in the 9th, 10th, or 11th grades that are not cleared by repeated course or validated by advanced course or exam, and applicant’s high school of graduation may be an out-of-state school.
O = Estimated not eligible for applicant attending out-of-state school. Applicant’s high school of graduation is neither approved nor unapproved (indicates high school may be an out-of-state school). One or more of the following applies: all official, self-reported or projected test scores are not present; the applicant’s computed GPA* and test score total combination are below the level in the index table; the minimum number of required semester courses are not reported or satisfied by exam; there are d or f grades in the 9th, 10th, or 11th grades that are not cleared by repeated course or validated by advanced course or exam.
G = Estimated not eligible. Applicant has one or more projected test scores used in calculating his/ her preliminary eligibility. Applicant is from an unaccredited or unapproved high school - Obsolete Fall 2005
H = estimated not eligible. None of the above indexes apply.
FOR OUT-OF-STATE RESIDENTS:
Blank = the applicant is not a domestic first-time freshman.
L = Estimated ELC eligible. The applicant's identifying information has been successfully matched to a record on the official ELC data file.
C = the applicant is possibly eligible. Computed GPA equals 3.4 or greater, at least the minimum number of A-F courses reported, all official or self-reported test scores are present and there are no D or F grades in the 9th, 10th or 11th grades.
T = The applicant is possibly eligible. Computed GPA equals 3.4 or greater, at least the minimum number of A-F courses reported or satisfied by exam, all official or self-reported test scores are present and are at or above the required minimums and there are no D or F grades in the 9th, 10th or 11th grades that are not cleared by repeated course or validated by advanced course or exam.
D = The applicant is possibly eligible. All official or self-reported test scores are present and are at or above the required minimums. 'CEEB' eligible.
M = The applicant's eligibility cannot be computed. The applicant lacks all or some required test scores. Computed GPA equals 3.4 or greater, there are no D or F grades in the 9th, 10th or 11th grades, and at least the minimum number of A-F courses reported.
E = The applicant's eligibility cannot be computed due to missing or invalid data and none of the above criteria applies.
F = Estimated not eligible. None of the above indexes apply.
R=Estimated eligible according to the index. All official or self-reported test scores are present. The applicant's computed gpa and test score total combination are at or above the level in the index table, the minimum number of required semester courses are reported, there are no D or F grades in the 9th, 10th, or 11th grades that are not cleared by repeated course or validated by advanced course or exam, and applicant's high school of graduation is an approved school.
Z=Graduated prior to October 2005. Applicant may have graduated prior to October 2005 and is required to meet former eligibiilty requirements (in place at the time of high school graduation).
For OUT OF STATE RESIDENTS:
J=Graduated prior to October 2005. Applicant may have graduated prior to October 2005 and is required to meet former eligibiilty requirements (in place at the time of high school graduation).		 UAD_BI ELIGIBILITY_D ELGBLTY_FRSHMN_ESTD_CD   IRAP_BI UAD_DM  
101   Eligibility Transfer Estimated   Stu_UAD_All_Applic_Tbl Eligibility_Transfer_Estimated Code indicating potential eligibility for admission to UC for both California and out-of-state transfer applicants separately. California residency is determined based on 'yes' to question on California residency, or 'yes' to parent being a current UC employee. In addition, those transfer applicants whose last school attended is a California community college (confirmed) will also be treated as bona fide California residents. Each set of criteria will be applied and the indicator set in the order listed below. If the criteria elements are updated, the eligibility indicator may be revised.
Blank = The applicant is not a domestic transfer applicant.
L = estimated ELC eligible.
1 = possibly eligible - Calif resident applicant who may meet transfer option. Two transferable college english, one college math and four courses in at least two of the following subject areas: arts and humanities, social and behavioral sciences, physical and biological sciences are completed, in progress or planned; college level units equal 90 quarter or 60 semester units or greater; gpa from college level courses is at least 2.4.
2 = Possibly eligible - out-of-state applicant who may meet transfer option. Same requirements as listed in #1 above, except gpa from college level courses is at least 2.8.
3 = Possibly eligible - calif resident applicant who is possibly qualified from high school based on high school english and math courses. GPA from college level courses is at least 2.0. Not applicable after 1999.
4 = Possibly eligible - out-of-state applicant who is possibly qualified from high school based on high school english and math courses. GPA from college level courses is at least 2.8. Not applicable after 1999.
5 = Cannot determine - Calif resident applicant who possibly qualifies on college work but appears to lack either the two english, one math or the four courses from the other subject areas. College level units equal 90 quarter or 60 semester units or greater; gpa from college level courses is at least 2.4; appears to lack english (two college) courses and/or math (college) courses and/or four college courses from at least two of the following subject areas: arts and humanities, social and behavioral sciences, physical and biological sciences.
6 = Cannot determine - out-of-state applicant. Same requirements as #5 above, except gpa from college courses is at least 2.8.
7 = Possibly ineligible - california applicant who has a college gpa less than 2.0.
8 = possibly ineligible - out-of-state applicant who has a college gpa less than 2.8.
9 = Possibly ineligible - for both california and out-of-state applicants who have less than 90 quarter or 60 semester units.
Hyphen = cannot determine. All transfer applicants who do not fall into any of the above categories.		 UAD_BI ELIGIBILITY_D ELGBLTY_TR_ESTD_CD   IRAP_BI UAD_DM  
102   Email Address   Stu_UAD_All_Applic_Tbl Email_Address E-mail address of the applicant.   UAD_BI APPLICANT_D AL_EML_ADDR   IRAP_BI UAD_DM  
103     Ethnic Origin Code Adm URM Stu_UAD_All_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		 UAD_BI APPLICANT_ETHNIC_CODE_D AL_ETN_CD_ORIG_ADM_URM_FL   IRAP_BI UAD_DM URM_IND
104     Ethnic Origin Name Adm Stu_UAD_All_Applic_Tbl Ethnic_Origin_Name_Adm Name of race/ethnicity category provided on the application.   UAD_BI UC_ETHNIC_CODE_LEVEL_1_D UC_ETN_CD_LVL_1_CD_NAM   IRAP_BI UAD_DM UAD_UC_ETHN_14_CAT
105     Ethnic Origin Name Adm 9CAT Stu_UAD_All_Applic_Tbl Ethnic_Origin_Name_Adm_9CAT Name of race/ethnicity category provided on the application - 9 categories.   UAD_BI UC_ETHNIC_CODE_LEVEL_1_D UC_ETN_CD_LVL_1_9CAT_NAM   IRAP_BI UAD_DM UAD_UC_ETHN_9_CAT
106     Ethnic Origin Name Adm IPEDS Stu_UAD_All_Applic_Tbl Ethnic_Origin_Name_Adm_IPEDS Name of race/ethnicity category provided on the application - IPEDS categories.   UAD_BI IPEDS_ETHNIC_CODE_D IPEDS_ETN_CD_NAM   IRAP_BI UAD_DM UAD_IPEDS_ETHNICITY_DERIVTN
107 U790 First Language Code   Stu_UAD_All_Applic_Tbl First_Language_Code Code indicating the language the applicant learned to speak first. 1 = English Only
2 = English and Another Language
3 = Another Language		 UAD_BI APPLICANT_D AL_LANG_USG_UCAP_CD   IRAP_BI UAD_DM  
108 U910 Freshman GPA and Coursework Summary   Stu_UAD_All_Applic_Tbl Freshman_GPA_Course_Summ Code providing summary of grade point average and A-F coursework of applicant. 1 = Computed GPA is greater than 2.79, the minimum number of required semester courses are reported, and there are no D's or F's in the 9th, 10th, or 11th grades
2 = Computed GPA is less than 2.80, the minimum number of required semester courses are reported, and there are no D's of F's in the 9th, 10th, or 11th grades
3 = Computed GPA is greater than 2.79, the minimum number of required semester courses are reported, and there is one or more D or F in the 9th, 10th, or 11th grades
4 = Computed GPA is less than 2.80, the minimum number of required semester courses are reported, and there is one or more D or F in the 9th, 10th, or 11th grades
5 = Computed GPA is greater than 2.79, the minimum number of required semester courses has not been met
6 = Computed GPA is less than 2.80, the minimum number of required semester courses has not been met.
Hyphen = Either the minimum number of required semester courses are not reported or the computed GPA cannot be calculated.
Blank = Not a California resident freshman applicant.		 UAD_BI FROSH_D FROSH_GPA_CRSE_UCAP_CD   IRAP_BI UAD_DM  
109 U911  Freshman Score Index   Stu_UAD_All_Applic_Tbl Freshman_Score_Index  Sum of the SATI total (or the concordant ACT score) and the double-weighted scores from the three required SATII tests. This index may be calculated using any combination of official, self-reported or projected score, following this hierarchy: 1 - official scores; 2 - self-reported score; 3 - projected score. This field will be blank if scores are missing or the applicant is not a domestic freshman.   UAD_BI APPLICATION_F APPL_FROSH_SCO   IRAP_BI UAD_DM  
110 U909 Freshman Score Indicator   Stu_UAD_All_Applic_Tbl Freshman_Score_Indicator  Code indicating the presence and type of required test scores. 1 = All scores are present and official
2 = All scores are present, some official, some self-reported
3 = All scores are present and self-reported
4 = Some scores are present, all official
5 = Some scores are present, self-reported or a combination of official and self-reported = no scores (official or self-reported) are present
Blank = Not a domestic freshman applicant		 UAD_BI FROSH_D FROSH_SCO_TY_UCAP_CD   IRAP_BI UAD_DM  
111 U902 Grade Point Average-Freshman-Campus Calculated   Stu_UAD_All_Applic_Tbl GPA_Freshman_Campus Campus supplied GPA for freshman applicants. Campuses will supply this corrected data via decision files. Data will be used only if different from COMPUTED-GPA. If multiple campuses supply this field, the highest values will be used.   UAD_BI APPLICATION_F APPL_FRSHMN_CMP_GPA_AVG_SCO Grade Point Average-Freshman-Campus Calculated
Campus supplied GPA for freshman applicants. Campuses will supply this corrected data via decision files. Data will be used only if different from COMPUTED-GPA. If multiple campuses supply this field, the highest values will be used.		 IRAP_BI UAD_DM  
112 U850 Grade Point Average-Freshman-Capped   Stu_UAD_All_Applic_Tbl GPA_Freshman_Capped GPA computed from self-reported information on the application. The number of AP and honors courses is limited to 8. 10th grade honors are limited to four and will not include any IB honors or HL honors for English.   UAD_BI APPLICATION_F APPL_GPA_FRSHMN_CAPPED_REP_SCO   IRAP_BI UAD_DM  
113 N080   Grade Point Average-Freshman-Self Reported Stu_UAD_All_Applic_Tbl GPA_Freshman_SR The overall GPA (excluding physical education) reported by the freshman applicant for the 10th and 11th grades of high school. As of June 2005, computed from vendor supplied data. (see define code below)   UAD_BI APPLICATION_F APPL_SLFRPTED_FRSHMN_GPA_SCO CORRESPONDING CAMPUS ELEMENTS EXIST IN CAMPUS_APPLIED_F IRAP_BI UAD_DM  
114 U906 Grade Point Average-Freshman-Uncapped   Stu_UAD_All_Applic_Tbl GPA_Freshman_Uncapped Calculated grade point average with unlimited honors. Computed from self-reported information on the application.   UAD_BI APPLICATION_F APPL_UNCPD_GPA_SCO   IRAP_BI UAD_DM UNCPD_GPA_SCORE
115 U903 Grade Point Average-Transfer-Campus Calculated   Stu_UAD_All_Applic_Tbl GPA_Transfer_Campus Campus supplied GPA for transfer applicants. Used only if different from TRANSFER-GPA-SELF-RPT. If multiple campuses supply this field, the highest value will be used.   UAD_BI APPLICATION_F APPL_TR_CMP_GPA_SCO   IRAP_BI UAD_DM CAMPUS_SUPPLD_TRF_GPA_SCORE
116 N090 Grade Point Average-Transfer-Self-reported   Stu_UAD_All_Applic_Tbl GPA_Transfer_SR The overall college GPA reported by the advanced standing applicant.   UAD_BI APPLICATION_F APPL_SLFRPTED_TR_GPA_SCO CORRESPONDING CAMPUS ELEMENTS EXIST IN CAMPUS_APPLIED_F IRAP_BI UAD_DM TRAN_COLLEGE_GPA_DTL
117     High School Accredited Code Stu_UAD_All_Applic_Tbl High_School_Accredited Accreditation indicator for the high school from which the applicant graduated. Y = Yes
blank = No		 UAD_BI ATP_SCHOOL_D ATP_SCH_ACCRED_FL   IRAP_BI UAD_DM  
118     High School Address Line 1 Stu_UAD_All_Applic_Tbl High_School_Address1 First line of the address for the high school from which the applicant graduated.   UAD_BI ATP_SCHOOL_D ATP_SCH_ADDR_LN1   IRAP_BI UAD_DM  
119     High School Address Line 2 Stu_UAD_All_Applic_Tbl High_School_Address2 Second line of the address for the high school from which the applicant graduated.   UAD_BI ATP_SCHOOL_D ATP_SCH_ADDR_LN2   IRAP_BI UAD_DM  
120     High School Approved Code Stu_UAD_All_Applic_Tbl High_School_Approved Approval indicator for the high school from which the applicant graduated. Y = Yes
blank = No		 UAD_BI ATP_SCHOOL_D ATP_SCH_APRVL_FL   IRAP_BI UAD_DM  
121     High School Area Type Stu_UAD_All_Applic_Tbl High_School_Area_Type Area type code for the high school from which the applicant graduated 1 = Rural
2 = Suburban
3 = Urban		 UAD_BI ATP_SCHOOL_D ATP_SCH_AREA_TY_CD   IRAP_BI UAD_DM  
122 L040 High School ATP Code   Stu_UAD_All_Applic_Tbl High_School_ATP_Code American Testing Program code indicating the high school from which the student graduated.  Refer to School Code Table. UAD_BI ATP_SCHOOL_D ATP_SCH_ATP_CD   IRAP_BI UAD_DM  
123     High School ATP Type Code Stu_UAD_All_Applic_Tbl High_School_ATP_Type Code indicating the type of high school from which the applicant graduated.  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		 UAD_BI ATP_SCHOOL_D ATP_SCH_TY_CD   IRAP_BI UAD_DM  
124     High School City Stu_UAD_All_Applic_Tbl High_School_City City location for the high school from which the applicant graduated   UAD_BI ATP_SCHOOL_D ATP_SCH_CTY_NAM   IRAP_BI UAD_DM  
125     High School California District Code Stu_UAD_All_Applic_Tbl High_School_District_Code California school district code for the high school from which the applicant graduated. Refer to School District Code Table. UAD_BI ATP_SCHOOL_D ATP_SCH_DSTR_CD   IRAP_BI UAD_DM  
126     High School Location Code Stu_UAD_All_Applic_Tbl High_School_Location_Code Code indicating the country (if school is outside the U.S.), state (if outside California), or county (if within California) of the high school from which student graduated. Refer to Location Code Table. UAD_BI ATP_SCHOOL_D ATP_SCH_LOC_CD   IRAP_BI UAD_DM  
127     High School Location Name Stu_UAD_All_Applic_Tbl High_School_Location_Name The country (if school is outside the U.S.), state (if outside California) or county (if within California) of the high school from which student graduated. Refer to Location Code Table. UAD_BI COUNTRY_STATE_COUNTY_D CTRY_ST_CNTY_LOC_NAM   IRAP_BI UAD_DM  
128     High School Name Stu_UAD_All_Applic_Tbl High_School_Name Name of the high school from which student graduated.   UAD_BI ATP_SCHOOL_D ATP_SCH_NAM   IRAP_BI UAD_DM  
129     High School SDE Code Stu_UAD_All_Applic_Tbl High_School_SDE_Code State Department of Education code for the high school from which the applicant graduated.   UAD_BI ATP_SCHOOL_D ATP_SCH_SDE_CD   IRAP_BI UAD_DM  
130     High School State Stu_UAD_All_Applic_Tbl High_School_State State location for the high school from which the applicant graduated.   UAD_BI ATP_SCHOOL_D ATP_SCH_ST_CD   IRAP_BI UAD_DM  
131     High School Status Code Stu_UAD_All_Applic_Tbl High_School_Status  Status code (public, private or unknown) for the high school from which the applicant graduated. PR = Private
PU = Public
UN = Unknown
School Type		 UAD_BI ATP_SCHOOL_D ATP_SCH_STAT_CD   IRAP_BI UAD_DM  
132     High School Type Stu_UAD_All_Applic_Tbl High_School_Type Code indicating the type of high school from which student graduated. A = California Public High School
B = California Private High School
C = California Public 2-Year College
D = California Private 2-Year College
E = California Public 4-Year College (CSU)
F = California Private 4 Year College
G = University of California
H = Other (not to include unknown)
K = Non-California Institution (US) L = Foreign Institution		 UAD_BI ATP_SCHOOL_D ATP_SCH_DRVD_TY_CD   IRAP_BI UAD_DM  
133     High School Zip Code Stu_UAD_All_Applic_Tbl High_School_Zip Zip code for the high school from which the applicant graduated.   UAD_BI ATP_SCHOOL_D ATP_SCH_ZIP_CD   IRAP_BI UAD_DM  
134   Home Location Code   Stu_UAD_All_Applic_Tbl Home_Location_Code Code indicating for U.S. citizens, permanent residents, and refugees, the country (if address is outside the U.S.), state (if outside California), or county (if within California) for the student's permanent address. For visa holders, code indicating the country of permanent residence. Refer to Location Code Table. UAD_BI COUNTRY_STATE_COUNTY_D CTRY_ST_CNTY_LOC_CD   IRAP_BI UAD_DM HOME_LOC_COUNTRY
135     Home Location Name Stu_UAD_All_Applic_Tbl Home_Location_Name  Name of the country (if address is outside the U.S.), state (if outside California), or county (if within California) of the student's permanent address.   UAD_BI COUNTRY_STATE_COUNTY_D CTRY_ST_CNTY_LOC_NAM   IRAP_BI UAD_DM HOME_LOC_COUNTY
HOME_LOC_STATE
HOME_LOC_COUNT
136     Home Location Name 3 Category Stu_UAD_All_Applic_Tbl Home_Location_Name_3CAT Code indicating three-category home location (CA, other state, other country). Recode of element CHOMELOC.   UAD_BI APPLICANT_D AL_HM_LOC_3CAT_NAM   IRAP_BI UAD_DM HOME_LOCATION_3CAT
137 U740 Income of Applicant   Stu_UAD_All_Applic_Tbl Income_Applicant Annual gross income of applicant for undergraduate admission in calendar year preceding academic year (e.g. calendar year 2000 for fall 2001 admission).   UAD_BI APPLICATION_F APPL_AL_PREV_YR_INC_AMT   IRAP_BI UAD_DM APPL_INCOME_PREV
138  U730 Income of Parents of Applicant   Stu_UAD_All_Applic_Tbl Income_Parents Annual gross income of parents of applicant for undergraduate admission in calendar year preceding academic year (e.g. calendar year 2000 for fall 2001 admission). Since 2005, only applicants who declare themselves as dependents are allowed to enter data in this field. This has resulted in higher average parental income for transfer applicants   UAD_BI APPLICATION_F APPL_FMY_PREV_YR_INC_AMT   IRAP_BI UAD_DM  
139     Incomplete Flag Stu_UAD_All_Applic_Tbl Incomplete_Flag Code indicating admit status codes for all campuses were blank. Student did not register, submit a SIR, defer, have a falsified application cancelled, or have an offer of admission withdrawn due to failure to meet provision of offer, or receive alternate admission offer #2, or have application cancelled due to death at another campus. 1 - Yes
0 - No		 UAD_BI APPLICATION_F APPL_INCPLT_FL   IRAP_BI UAD_DM  
140     Last School Accredited Code Stu_UAD_All_Applic_Tbl Last_School_Accredited  Accreditation indicator for the last school attended prior to admission to UC attributed to the applicant. Y = Yes
blank = No		 UAD_BI ATP_SCHOOL_D ATP_SCH_ACCRED_FL   IRAP_BI UAD_DM  
141     Last School Address Line 1 Stu_UAD_All_Applic_Tbl Last_School_Address1 First line of the address for the last school attended prior to admission to UC attributed to the applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_ADDR_LN1   IRAP_BI UAD_DM  
142     Last School Address Line 2 Stu_UAD_All_Applic_Tbl Last_School_Address2 Second line of the address for the last school attended prior to admission to UC attributed to the applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_ADDR_LN2   IRAP_BI UAD_DM  
143     Last School Approved Code Stu_UAD_All_Applic_Tbl Last_School_Approved  Approval indicator for the last school attended prior to admission to UC attributed to the applicant. Y = Yes
blank = No		 UAD_BI ATP_SCHOOL_D ATP_SCH_APRVL_FL   IRAP_BI UAD_DM  
144     Last School Area Type Stu_UAD_All_Applic_Tbl Last_School_Area_Type Area type code for the last school attended prior to admission to UC attributed to the applicant. 1 = Rural
2 = Suburban
3 = Urban		 UAD_BI ATP_SCHOOL_D ATP_SCH_AREA_TY_CD   IRAP_BI UAD_DM  
145 T230 Last School ATP Code   Stu_UAD_All_Applic_Tbl Last_School_ATP_Code American Testing Program Code indicating the last school attended (prior to admission to UC) attributed to the applicant. Refer to School Code Table. UAD_BI ATP_SCHOOL_D ATP_SCH_ATP_CD   IRAP_BI UAD_DM PREV_SCH_ATP_CD
146     Last School ATP Type Code Stu_UAD_All_Applic_Tbl Last_School_ATP_Type ATP type code (HS, 2Y, 4Y, etc) for the last school attended prior to admission to UC attributed to the applicant. 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		 UAD_BI ATP_SCHOOL_D ATP_SCH_TY_CD   IRAP_BI UAD_DM PREV_HIGH_SCH_TYP_CD
147     Last School City Stu_UAD_All_Applic_Tbl Last_School_City City location for the last school attended prior to admission to UC attributed to the applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_CTY_NAM   IRAP_BI UAD_DM  
148     Last School California District Code Stu_UAD_All_Applic_Tbl Last_School_District_Code California school district code for the last school attended prior to admission to UC attributed to the applicant. Refer to School District Code Table. UAD_BI ATP_SCHOOL_D ATP_SCH_DSTR_CD   IRAP_BI UAD_DM  
149     Last School Location Code Stu_UAD_All_Applic_Tbl Last_School_Location_Code Location code for the last school attended prior to admission to UC attributed to the applicant. Refer to Location Code Table. UAD_BI ATP_SCHOOL_D ATP_SCH_LOC_CD   IRAP_BI UAD_DM PREV_SCH_LOC_CD
150     Last School Name Stu_UAD_All_Applic_Tbl Last_School_Name Name of the last school attended prior to admission to UC attributed to the applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_NAM   IRAP_BI UAD_DM PREV_HIGH_SCH_NAME
151     Last School SDE Code Stu_UAD_All_Applic_Tbl Last_School_SDE_Code  State Department of Education code for the last school attended prior to admission to UC attributed to the applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_SDE_CD   IRAP_BI UAD_DM  
152     Last School State Stu_UAD_All_Applic_Tbl Last_School_State State location for the last school attended prior to admission to UC attributed to the applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_ST_CD   IRAP_BI UAD_DM  
153     Last School Status Code Stu_UAD_All_Applic_Tbl Last_School_Status Status code (public, private or unknown) for the last school attended prior to admission to UC attributed to the applicant. PR = Private
PU = Public
UN = Unknown
School Type		 UAD_BI ATP_SCHOOL_D ATP_SCH_STAT_CD   IRAP_BI UAD_DM  
154     Last School Type  Stu_UAD_All_Applic_Tbl Last_School_Type School type code for the last school attended prior to admission to UC attributed to the applicant. A = California Public High School
B = California Private High School
C = California Public 2-Year College
D = California Private 2-Year College
E = California Public 4-Year College (CSU)
F = California Private 4 Year College
G = University of California
H = Other (not to include unknown)
K = Non-California Institution (US) L = Foreign Institution		 UAD_BI ATP_SCHOOL_D ATP_SCH_DRVD_TY_CD   IRAP_BI UAD_DM PREV_HIGH_SCH_TYP_CD
155     Last School Zip Code Stu_UAD_All_Applic_Tbl Last_School_Zip Zip code for the last school attended prior to admission to UC attributed to the applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_ZIP_CD   IRAP_BI UAD_DM  
156 U900 Letter Recipient   Stu_UAD_All_Applic_Tbl Letter_Recipient Code indicating applicant is a recipient of outreach letter from UC President. Y = Yes
blank = No		 UAD_BI APPLICATION_F APPL_LTR_RECIPIENT_IND   IRAP_BI UAD_DM  
157 U890 Non-US School Grade 6 through 8   Stu_UAD_All_Applic_Tbl Non_US_School_Grades_6to8 Indicates whether if the applicant attended any school outside the United States during grades six through eight. Y = Yes
blank = No		 UAD_BI APPLICATION_F APPL_NON_US_SCH_GRD_68_IND   IRAP_BI UAD_DM  
158 U892 Non-US School Grade 9 through 12   Stu_UAD_All_Applic_Tbl Non_US_School_Grades_9to12 Indicates whether if the applicant attended any school outside the United States during grades nine through twelve. Y = Yes
blank = No		 UAD_BI APPLICATION_F APPL_NON_US_SCH_GRD_912_IND   IRAP_BI UAD_DM  
159 U800 Occupation of Father   Stu_UAD_All_Applic_Tbl Occupation_Code_Father Current occupation of father as reported by the applicant. A = Clerical (01)
B = Craftsman (02)
C = Farmer (03)
D = Homemaker (04)
E = Laborer (05)
F = Manager, administrator (06)
G = Military (07)
H = Operative (08)
I = Professional (09)
J = Proprietor (10)
K = Protective service (11)
L = Agent/Broker (12)
M = Services (13)
N = Technical (14)
O = Other - retired, deceased, or unemployed (15)
Blank = No response		 UAD_BI PARENT_OCCUPATION_D PAR_OCCUPN_PAR1_OCCUPN_CATG_UCAP_CD   IRAP_BI UAD_DM  
160 U810 Occupation of Mother   Stu_UAD_All_Applic_Tbl Occupation_Code_Mother Current occupation of mother as reported by the applicant.  A = Clerical (01)
B = Craftsman (02)
C = Farmer (03)
D = Homemaker (04)
E = Laborer (05)
F = Manager, administrator (06)
G = Military (07)
H = Operative (08)
I = Professional (09)
J = Proprietor (10)
K = Protective service (11)
L = Agent/Broker (12)
M = Services (13)
N = Technical (14)
O = Other - retired, deceased, or unemployed (15)
Blank = No response		 UAD_BI PARENT_OCCUPATION_D PAR_OCCUPN_PAR2_OCCUPN_CATG_UCAP_CD   IRAP_BI UAD_DM  
161 L080 Pre-College Development Program Code   Stu_UAD_All_Applic_Tbl Pre_College_Development_Pgm Code indicating the development program(s) in which the student participated prior to UC enrollment 1 = UC Early Academic Outreach Program (EAOP). Formerly UC Partnership Jr/Sr High Early Academic Outreach
2 = UCSF Health Science Enrichment Program (HSEP)
3 = MESA (Mathematics, Engineering, and Science Achievement)
4 = Community College EOPS(invalid as of Fall 05)
5 = CSUC-EOP (eliminated Fall 2003)
6 = Upward Bound
7 = Talent Search/EOP, Talent Search/EOC
8 = Talent Search(effective Fall 05)
9 = Other
A = UC AEP - Academic Enrichment Program (invalid as of Fall 05)
B = ATDP - Academic Talent Development Program (prior to Fall 1999, UC Immediate Outreach)
C = CAL - SOAP
D = PDP - Professional Development Program
E = Transfer Center (invalid as of Fall 05)
F = UCAAP
G = Gear Up (formerly UCI Academic Talent Search)
H = UC College Prep Initiative (UCCP)
I = Jack and Jill (invalid as of Fall 05)
J = University College Opportunity
K = Eastside Collaborative (invalid as of Fall 05)
L = College Bound (invalid as of Fall 05)
M = CAMP - California Alliance for Minority Participation in Science, Engineering, and Mathematics
N = Golden Ankh Scholars (invalid as of Fall 05)
P = Puente
Q = COSMOS
R = Golden Pyramid Scholars (invalid as of Fall 05)
S = SAGE (prior to Fall 1999, this value represented Scholars in Training)
T = EAst Bay Consortium (invalid as of Fall 05)
U = CBOP - The Career Based Outreach Program
V = AVID - Advancement via Individual Determination (invalid as of Fall 05)
W = Education Guidance Center
X = EAP - Education Abroad Program
Y = Young Entrepreneurs at Haas
Z = UC-LABI (invalid as of Fall 05)		 UAD_BI ACTIVITY_CODE_D ACTY_UCAP_CD   IRAP_BI UAD_DM  
162     Referral Flag Stu_UAD_All_Applic_Tbl Referral_Flag Code indicating that applicant is part of the referral pool. 1 - Yes
blank - No		 UAD_BI APPLICATION_F APPL_REFRL_FL   IRAP_BI UAD_DM  
163     Residence Status Adm-3CAT Stu_UAD_All_Applic_Tbl Residence_Status_Adm_3CAT Three-category code indicating residency status for admission evaluation and citizenship/visa status at application.   UAD_BI RESIDENCY_D RSDNCY_AL_RESI_STAT_ADM_3CAT_CD   IRAP_BI UAD_DM RESIDENCY_TYP_3_CAT
164 L170   Residence Status Code-Admission Stu_UAD_All_Applic_Tbl Residence_Status_Code_Adm Code indicating an applicant's California residence status for use in admission evaluation R = California resident
B = Bona Fide California Resident
N = Not California resident		 UAD_BI RESIDENCY_D RSDNCY_AL_RSDNCY_STAT_UCAP_CD   IRAP_BI UAD_DM  
165     Residence Status Code Fees Stu_UAD_All_Applic_Tbl Residence_Status_Code_Fees Code indicating an applicant's California residence status for use in determination of tuition and fees.  R = California resident
N = Not California resident		 UAD_BI FEE_D FEE_RESI_STAT_CD   IRAP_BI UAD_DM  
166     Residence Status Fees-3CAT Stu_UAD_All_Applic_Tbl Residence_Status_Fees_3CAT Three-category code indicating residency status for fee purposes and citizenship/visa status at application.   UAD_BI FEE_D FEE_RESI_STAT_3_CAT_CD   IRAP_BI UAD_DM  
167 F270 SATI Math Exam Score-Best   Stu_UAD_All_Applic_Tbl SATI_Math_Score_Best Score received on the College Entrance Examination Board scholastic aptitude mathematics test in the sitting at which the best total score was received.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATI'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM=SATI_MATH_BEST'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIMath'
IRAP_BI UAD_DM  
168     SATI Math Score-Derived Stu_UAD_All_Applic_Tbl SATI_Math_Score_Drv Best SATI Math score. If not available, the self-reported SATI Math score.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATI'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM=SATI_MATH_DRV'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIMath'
IRAP_BI UAD_DM  
169 U480 SATI Math Exam Score-Self-reported   Stu_UAD_All_Applic_Tbl SATI_Math_Score_SR The Math score on the Scholastic Aptitude Test (SAT) as reported by the applicant. Commencing January 1996, all scores are based on the recentered scale.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATI'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM=SATI_MATH'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIMath'
IRAP_BI UAD_DM  
170     SATI Total Score-Derived Stu_UAD_All_Applic_Tbl SATI_Total_Score_Drv Total of derived SATI Verbal and SATI Math scores.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATI'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM=SATI_MATH_DRV'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIMath'
IRAP_BI UAD_DM  
171 F260 SATI Verbal Score-Best   Stu_UAD_All_Applic_Tbl SATI_Verbal_Score_Best Score received on the College Entrance Examination Board scholastic aptitude verbal test in the sitting at which the best total score was received.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATI'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM=SATI_VERBAL_BEST'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIVerbal'
IRAP_BI UAD_DM  
172     SATI Verbal Score-Derived Stu_UAD_All_Applic_Tbl SATI_Verbal_Score_Drv Best SATI Verbal score. If not available, the self-reported SATI Verbal score.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATI'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM=SATI_VERBAL_DRV'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIVerbal'
IRAP_BI UAD_DM  
173 U410 SATI Verbal Score-Self-reported   Stu_UAD_All_Applic_Tbl SATI_Verbal_Score_SR The Verbal score on the Scholastic Aptitude Test (SAT) as reported by the applicant. Commencing January 1996, all scores are based on the recentered scale.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATI'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM=SATI_VERBAL'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIVerbal'
IRAP_BI UAD_DM  
174 F320 SATII 3rd Code Best   Stu_UAD_All_Applic_Tbl SATII_3rd_Code_Best Code indicating subject of the College Entrance Examination Board SAT II achievement test in foreign language, social science, science or literature, with the best score. B = Biology
C = Chemistry
D = Physics
E = French (& Listening)
F = German (& Listening)
G = Latin
H = Spanish (& Listening)
I = Hebrew (& Modern Hebrew)
J = Russian
K = Japanese (& Listening)
L = Chinese (& Listening)
O = American History and Social Studies
P = European History and World Cultures
Q = World History
S = Literature
T = Italian
U = Biology - Ecological/Molecular
V = Korean (& Listening)		 UAD_BI TEST_F TST_CATLG_M_TST_CD Code values:
SATIISpanishListening
SATIIPhysics
SATIIUsHistory
SATIIChemistry
SATIIChineseListening
SATIIJapaneseListening
SATIIMolecularBiology
SATIIFrenchListening
SATIIHistoryWorld
SATIIKoreanListening
SATIILiterature
SATIIBiology
SATIIFrenchListening
SATIIChemistry
SATIIChineseListening
SATIIGermanListening
SATIIJapaneseListening
SATIISpanishListening
SATIIHebrewModern
SATIIHistoryWorld
SATIIItalian
SATIILatin
SATIILiterature
SATIIPhysics
SATIIUsHistory
SATIIUnk
SATIIEuropeanHistory
SATIIKoreanListening
SATIIMolecularBiology
SATIIRussian		 IRAP_BI UAD_DM  
175     SATII 3rd Code Drv Stu_UAD_All_Applic_Tbl SATII_3rd_Code_Drv  Subject code for the best SATII 3rd exam score. If not available, the subject code for the self-reported SATII 3rd exam score.  B = Biology
C = Chemistry
D = Physics
E = French (& Listening)
F = German (& Listening)
G = Latin
H = Spanish (& Listening)
I = Hebrew (& Modern Hebrew)
J = Russian
K = Japanese (& Listening)
L = Chinese (& Listening)
O = American History and Social Studies
P = European History and World Cultures
Q = World History
S = Literature
T = Italian
U = Biology - Ecological/Molecular
V = Korean (& Listening)		 UAD_BI TEST_F TST_CATLG_M_TST_CD Code values:
SATIISpanishListening
SATIIPhysics
SATIIUsHistory
SATIIChemistry
SATIIChineseListening
SATIIJapaneseListening
SATIIMolecularBiology
SATIIFrenchListening
SATIIHistoryWorld
SATIIKoreanListening
SATIILiterature
SATIIBiology
SATIIFrenchListening
SATIIChemistry
SATIIChineseListening
SATIIGermanListening
SATIIJapaneseListening
SATIISpanishListening
SATIIHebrewModern
SATIIHistoryWorld
SATIIItalian
SATIILatin
SATIILiterature
SATIIPhysics
SATIIUsHistory
SATIIUnk
SATIIEuropeanHistory
SATIIKoreanListening
SATIIMolecularBiology
SATIIRussian		 IRAP_BI UAD_DM  
176 U916 SATII 3rd Code Proj   Stu_UAD_All_Applic_Tbl SATII_3rd_Code_Proj Exam type for the projected SAT II third subject test score. This field will be blank unless the applicant has indicated that he/she has taken or plans to take one of the valid SAT II third tests.   UAD_BI TEST_F TST_CATLG_M_TST_CD Code values:
SATIISpanishListening
SATIIPhysics
SATIIUsHistory
SATIIChemistry
SATIIChineseListening
SATIIJapaneseListening
SATIIMolecularBiology
SATIIFrenchListening
SATIIHistoryWorld
SATIIKoreanListening
SATIILiterature
SATIIBiology
SATIIFrenchListening
SATIIChemistry
SATIIChineseListening
SATIIGermanListening
SATIIJapaneseListening
SATIISpanishListening
SATIIHebrewModern
SATIIHistoryWorld
SATIIItalian
SATIILatin
SATIILiterature
SATIIPhysics
SATIIUsHistory
SATIIUnk
SATIIEuropeanHistory
SATIIKoreanListening
SATIIMolecularBiology
SATIIRussian		 IRAP_BI UAD_DM  
177 U714 SATII 3rd Code SR   Stu_UAD_All_Applic_Tbl SATII_3rd_Code_SR College Board Subject Test (SATII) third test code reported by applicant. AH = American History
BY = Biology
CH = Chemistry
CL = Chinese Listening
EB = Ecological Biology
EH = European History
FL = French Listening
FR = French
GL = German Listening
GM = German
HB = Hebrew
IT = Italian
JL = Japanese Listening
KL = Korean Listening
LR = Literature
LT = Latin
MB = Molecular Biology
MH = Modern Hebrew
PH = Physics
RN = Russian
SL = Spanish Listening
SP = Spanish
UH = U.S. History
WH = World History		 UAD_BI TEST_F TST_CATLG_M_TST_CD Code values:
SATIISpanishListening
SATIIPhysics
SATIIUsHistory
SATIIChemistry
SATIIChineseListening
SATIIJapaneseListening
SATIIMolecularBiology
SATIIFrenchListening
SATIIHistoryWorld
SATIIKoreanListening
SATIILiterature
SATIIBiology
SATIIFrenchListening
SATIIChemistry
SATIIChineseListening
SATIIGermanListening
SATIIJapaneseListening
SATIISpanishListening
SATIIHebrewModern
SATIIHistoryWorld
SATIIItalian
SATIILatin
SATIILiterature
SATIIPhysics
SATIIUsHistory
SATIIUnk
SATIIEuropeanHistory
SATIIKoreanListening
SATIIMolecularBiology
SATIIRussian		 IRAP_BI UAD_DM  
178 F330 SATII Third Exam Score-Best   Stu_UAD_All_Applic_Tbl SATII_3rd_Score_Best Best score received on the College Entrance Examination Board SAT II achievement test in foreign language, social science, science or literature.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATII'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM=SATII_3RD_BEST'
TEST_CATALOG_D.TST_CATLG_M_TST_CD=<TST_CATLG_M_TST_CD>
where TST_CATLG_M_TST_CD equals any code values in cell L175.
 IRAP_BI UAD_DM  
179     SATII 3rd Score-Derived Stu_UAD_All_Applic_Tbl SATII_3rd_Score_Drv Best SATII 3rd exam score. If not available, the self-reported SATII 3rd exam score.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATII'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM=SATII_3RD_DRV'
TEST_CATALOG_D.TST_CATLG_M_TST_CD=<TST_CATLG_M_TST_CD>
where TST_CATLG_M_TST_CD equals any code values in cell L176.
 IRAP_BI UAD_DM  
180 U915  SATII Third Exam Score-Projected   Stu_UAD_All_Applic_Tbl SATII_3rd_Score_Proj Projected SAT II third subject score. This element will be computed using one of the following two methods: (1) Produced from a concordance table when SAT I verbal scores are present and when the value of the element PROJ-SATII-3RD-CODE is 'AH' (American history), 'EB' (biology-ecological), 'LR' (literature) or 'MB' (biology-molecular). The highest official SAT I verbal score will be used if present; otherwise, the self-reported SAT I verbal score will be used. If neither the official or self-reported SAT I verbal scores are present or the element PROJ-SATII-3RD-CODE is not one of the four values above, this method will not be used. (2) An average will be taken from all available SATI (or ACT equivalent) and SATII exam scores (official, self-reported, or projected). Highest official scores will be used if present; otherwise, the self-reported scores will be used if present; otherwise, the projected scores will be used. See Central Application Processing Procedures and Specifications.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATII'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM=SATII_3RD_PROJ'
TEST_CATALOG_D.TST_CATLG_M_TST_CD=<TST_CATLG_M_TST_CD>
where TST_CATLG_M_TST_CD equals any code values in cell L177.
 IRAP_BI UAD_DM  
181 U360 SATII Third Exam Score-Self-reported   Stu_UAD_All_Applic_Tbl SATII_3rd_Score_SR The score on the College Board Subject Test (SAT-II) third test as reported by the applicant. Commencing January 1996, all scores are based on the recentered scale.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATII'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM=SATII_3RD_BEST'
TEST_CATALOG_D.TST_CATLG_M_TST_CD=<TST_CATLG_M_TST_CD>
where TST_CATLG_M_TST_CD  equals any code values in cell L178.
 IRAP_BI UAD_DM  
182 F350 SATII Math Code-Best   Stu_UAD_All_Applic_Tbl SATII_Math_Code_Best Code indicating subject (i.e., math level) of the SAT II College Entrance Examination Board Achievement test in math with the best score. Q = Math Level I
R = Math Level II		 UAD_BI TEST_F TST_CATLG_M_TST_CD Code Values:
SATIIMath1, SATIIMath2 , SATIIUnk 		 IRAP_BI UAD_DM  
183 U914 SATII Math Code-Projected   Stu_UAD_All_Applic_Tbl SATII_Math_Code_Proj Exam type for the projected SAT II math test score. This field will be blank unless the applicant has indicated that he/she has taken or plans to take one of the two SAT II math tests. If both math tests are indicated, this field will contain the value for the SAT II math level IIC.   UAD_BI TEST_F TST_CATLG_M_TST_CD Code Values:
SATIIMath1, SATIIMath2 , SATIIUnk 		 IRAP_BI UAD_DM  
184 F360 SATII Math Exam Score-Best   Stu_UAD_All_Applic_Tbl SATII_Math_Score_Best Best score received on the College Entrance Examination Board SAT II achievement test in mathematics.   UAD_BI TEST_F TST_SCO WHERE TST_CATLG_M_TST_CATG_CD='SATII' 
AND TST_CATLG_M_TST_EVAL_NAM='SATII_MATH_PROJ'
AND TST_CATLG_M_TST_CD  = <any code  in cell L183>		 IRAP_BI UAD_DM  
185     SATII Math Score-Derived Stu_UAD_All_Applic_Tbl SATII_Math_Score_Drv     UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATII'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM=SATI_MATH_DRV'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIIMath'
IRAP_BI UAD_DM  
186  U913 SATII Math Exam Score-Projected   Stu_UAD_All_Applic_Tbl SATII_Math_Score_Proj Projected SAT II math score. Produced from a concordance table when SAT I math scores are present. The highest official SAT I math score will be used if present; otherwise, the self- reported SAT I math score will be used. If neither the official or self-reported SAT I math scores are present, this field will be blank. Based upon the value of the element PROJ-SATII-MATH-CODE, either an SAT II math level IC or an SAT II math level IIC score will be projected. If the element PROJ-SATII-MATH-CODE is blank, an SAT II math level IC score will be projected. This field will be revised if: 1 - a higher official SAT I math score is received 2 - an official SAT I math score is received in place of a self- reported score 3 - a self-reported SAT I math score is received, replacing a lower or non-existent self-reported score.   UAD_BI TEST_F TST_SCO WHERE TST_CATLG_M_TST_CATG_CD='SATII' 
AND TST_CATLG_M_TST_EVAL_NAM='SATII_MATH_PROJ'
AND TST_CATLG_M_TST_CD  = <any code  in cell L184>.		 IRAP_BI UAD_DM  
187 U350 SATII Math Exam Score-Self-reported   Stu_UAD_All_Applic_Tbl SATII_Math_Score_SR College Board Subject Test (SAT II) mathematics level 1 or 1C score reported by applicant. Commencing January 1996, all scores are based on the recentered scale.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATII'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='SATII_MATH'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIIMath'
TEST_CATALOG_D.TST_CATLG_ETS_BUS_NAM='SATII Math Exam Score-Self-reported'		 IRAP_BI UAD_DM  
188     SATII Math1 Score-Best Stu_UAD_All_Applic_Tbl SATII_Math1_Score_Best Best SATII Math1 score.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATII'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='SATII_MATH1_BEST'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIIMath1'		 IRAP_BI UAD_DM  
189     SATII Math1 Score-Derived Stu_UAD_All_Applic_Tbl SATII_Math1_Score_Drv Best SATII Math1 score. If not available, the self-reported SATII Math1 score.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATII'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='SATII_MATH1_DRV'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIIMath1'		 IRAP_BI UAD_DM  
190     SATII Math2 Score-Best Stu_UAD_All_Applic_Tbl SATII_Math2_Score_Best Best SATII Math2 score.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATII'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='SATII_MATH2_BEST'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIIMath2'		 IRAP_BI UAD_DM  
191     SATII Math2 Score-Derived Stu_UAD_All_Applic_Tbl SATII_Math2_Score_Drv Best SATII Math2 score. If not available, the self-reported SATII Math2 score.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATII'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='SATII_MATH2_DRV'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIIMath2'		 IRAP_BI UAD_DM  
192 U355 SATII Math2 Score-Self-reported   Stu_UAD_All_Applic_Tbl SATII_Math2_Score_SR College Board Subject Test (SATII) mathematics level 2 or 2C score reported by applicant.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATII'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='SATII_MATH2'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIIMath2'		 IRAP_BI UAD_DM  
193 F290 SATII Writing Exam Code-Best   Stu_UAD_All_Applic_Tbl SATII_Writing_Code_Best Code indicating subject of the College Entrance Examination Board SAT II achievement test in English Composition with the best score. A = English Composition
V = English Composition with essay
W = Writing		 UAD_BI TEST_F TST_CATLG_M_TST_CD Code Values:
SATIIWritingW
SATIIWritingEnglishCompositionA
SATIIWritingEnglishCompositionwithEssayV		 IRAP_BI UAD_DM  
194 F300 SATII Writing Exam Score-Best   Stu_UAD_All_Applic_Tbl SATII_Writing_Score_Best Best score received on the College Entrance Examination Board SAT II achievement test in English composition.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATII'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='SATII_WRITING_BEST'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIIWritingW'		 IRAP_BI UAD_DM  
195     SATII Writing Score-Derived Stu_UAD_All_Applic_Tbl SATII_Writing_Score_Drv Best SATII Writing score. If not available, the self-reported SATII Writing score.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATII'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='SATII_WRITING_DRV'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIIWriting'		 IRAP_BI UAD_DM  
196 U912 SATII Writing Exam Score-Projected   Stu_UAD_All_Applic_Tbl SATII_Writing_Score_Proj Projected SAT II writing score. Produced from a concordance table when SAT I verbal scores are present. The highest official SAT I verbal score will be used if present; otherwise, the self- reported SAT I verbal score will be used. If neither the official or self-reported SAT I verbal scores are present, this field will be blank. This field will be revised if: 1 - a higher official SAT I verbal score is received 2 - an official SAT I verbal score is received in place of a self- reported score 3 - a self-reported SAT I verbal score is received, replacing a lower or non- existent self-reported score   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATII'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='SATII_WRITING_PROJ'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIIWriting'		 IRAP_BI UAD_DM  
197 U340 SATII Writing Exam Score-Self-reported   Stu_UAD_All_Applic_Tbl SATII_Writing_Score_SR The English Composition score on the College Board Achievement Test (SAT-II) as reported by the applicant. Commencing January 1996, all scores are based on the recentered scale.   UAD_BI TEST_F TST_SCO TEST_CATALOG_D.TST_CATLG_M_TST_CATG_CD='SATII'
TEST_CATALOG_D.TST_CATLG_M_TST_EVAL_NAM='SATII_WRITING'
TEST_CATALOG_D.TST_CATLG_M_TST_CD='SATIIWriting'		 IRAP_BI UAD_DM  
198 H020 Sex Code   Stu_UAD_All_Applic_Tbl Sex_Code Code identifying a person as male or female. F = Female
M = Male
U or blank=Unknown		 UAD_BI APPLICANT_D AL_GNDR_CD   IRAP_BI UAD_DM  
199 U899 Single Parent Indicator Dependent Applicant   Stu_UAD_All_Applic_Tbl Single_Parent_Depend Code indicating that the dependent applicant’s family is a single parent family. (Self Reported) 1 - Yes
blank - No		 UAD_BI APPLICATION_F APPL_SNGL_PAR_DPNDT_IND Code indicating that the dependent applicant's family is a single parent family. (Self Reported) IRAP_BI UAD_DM  
200 U898 Single Parent Indicator  Independent Applicant   Stu_UAD_All_Applic_Tbl Single_Parent_Indep Code indicating that the independent applicant?s family is a single parent family. (Self Reported) Y = Yes
blank = No		 UAD_BI APPLICATION_F APPL_SNGL_PAR_INDPNDT_IND Code indicating that the independent applicant's family is a single parent family. (Self Reported) IRAP_BI UAD_DM  
201     SIR Flag Stu_UAD_All_Applic_Tbl SIR_Flag Code indicating that the applicant has filed a Statement of Intention to Register on at least one campus. 1 - Yes
0 - No		 UAD_BI APPLICATION_F APPL_SIR_FL   IRAP_BI UAD_DM SIR_FL
202 G020 Social Security Number   Stu_UAD_All_Applic_Tbl Social_Security_Number The current number assigned to an individual by the Social Security Administration.   UAD_BI APPLICANT_D AL_SSN_NUM   IRAP_BI UAD_DM  
203     Source School Accredited Code Stu_UAD_All_Applic_Tbl Source_School_Accredited Accreditation indicator for the school of origin attributed to the undergraduate applicant Y = Yes
blank = No		 UAD_BI ATP_SCHOOL_D ATP_SCH_ACCRED_FL   IRAP_BI UAD_DM  
204     Source School Address Line 1 Stu_UAD_All_Applic_Tbl Source_School_Address1 First line of the address for the school of origin attributed to the undergraduate applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_ADDR_LN1   IRAP_BI UAD_DM  
205     Source School Address Line 2 Stu_UAD_All_Applic_Tbl Source_School_Address2 Second line of the address for the school of origin attributed to the undergraduate applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_ADDR_LN2   IRAP_BI UAD_DM  
206     Source School Approved Code Stu_UAD_All_Applic_Tbl Source_School_Approved Approval indicator for the school of origin attributed to the undergraduate applicant. Y = Yes
blank = No		 UAD_BI ATP_SCHOOL_D ATP_SCH_APRVL_FL   IRAP_BI UAD_DM  
207     Source School Area Type Stu_UAD_All_Applic_Tbl Source_School_Area_Type Area type code for the school of origin attributed to the undergraduate applicant. 1 = Rural
2 = Suburban
3 = Urban		 UAD_BI ATP_SCHOOL_D ATP_SCH_AREA_TY_CD   IRAP_BI UAD_DM ATP_SCH_AREA_TY_CD
208 L020   Source School Code Stu_UAD_All_Applic_Tbl Source_School_ATP_Code American Testing Program Code indicating the school of origin attributed to the undergraduate applicant. FORMER DEFINITION: Code indicating the school charged with greatest responsibility for undergraduate applicant's eligibility or, if no school is charged, then the last school attended. Refer to School Code Table. UAD_BI ATP_SCHOOL_D ATP_SCH_ATP_CD   IRAP_BI UAD_DM SCH_SRC_ATP_CD
209     Source School ATP Type Code Stu_UAD_All_Applic_Tbl Source_School_ATP_Type ATP type code (HS, 2Y, 4Y, etc) for the school of origin attributed to the undergraduate applicant. 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		 UAD_BI ATP_SCHOOL_D ATP_SCH_TY_CD   IRAP_BI UAD_DM  
210 L030   Source School Charged Code Stu_UAD_All_Applic_Tbl Source_School_Charged_Code Code indicating whether the source school code identifies the institution charged with having the greatest responsibility for the undergraduate applicant's eligibility. If no, the source school code is simply the last institution attended. Y = Yes
N = No		 UAD_BI ATP_SCHOOL_D     IRAP_BI UAD_DM  
211     Source School City Stu_UAD_All_Applic_Tbl Source_School_City City location for the school of origin attributed to the undergraduate applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_CTY_NAM   IRAP_BI UAD_DM SCH_SRC_CITY
212     Source School California District Code Stu_UAD_All_Applic_Tbl Source_School_District_Code California school district code for the school of origin attributed to the undergraduate applicant. Refer to School District Code Table. UAD_BI ATP_SCHOOL_D ATP_SCH_DSTR_CD   IRAP_BI UAD_DM SCH_SRC_DISTRICT
213     Source School Location Code Stu_UAD_All_Applic_Tbl Source_School_Location_Code Location code for the school of origin attributed to the undergraduate applicant. Refer to Location Code Table. UAD_BI ATP_SCHOOL_D ATP_SCH_LOC_CD   IRAP_BI UAD_DM  
214     Source School Location Name Stu_UAD_All_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. FORMER DEFINITION: Name of the country (if school is outside the U.S.), state (if outside California), or county (if within California) of the school which is charged with greatest responsibility for undergraduate applicant's eligibility or, if no school is charged, then the last school attended. Refer to Location Code Table. UAD_BI COUNTRY_STATE_COUNTY_D CTRY_ST_CNTY_LOC_NAM   IRAP_BI UAD_DM  
215     Source School Name Stu_UAD_All_Applic_Tbl Source_School_Name Name of the school of origin attributed to the undergraduate applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_NAM   IRAP_BI UAD_DM SCH_SRC_NAME
216     Source School SDE Code Stu_UAD_All_Applic_Tbl Source_School_SDE_Code State of California Department of Education Code indicating the school of origin of the undergraduate applicant or student. FORMER DEFINITION Code indicating the school charged with greatest responsibility for undergraduate applicant's eligibility or, if not school is charged, then the last school attended.   UAD_BI ATP_SCHOOL_D ATP_SCH_SDE_CD   IRAP_BI UAD_DM  
217     Source School State Stu_UAD_All_Applic_Tbl Source_School_State State location for the school of origin attributed to the undergraduate applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_ST_CD   IRAP_BI UAD_DM SCH_SRC_STATE_CD
218     Source School Status Code Stu_UAD_All_Applic_Tbl Source_School_Status  Status code (public, private or unknown) for the school of origin attributed to the undergraduate applicant. PR = Private
PU = Public
UN = Unknown
School Type		 UAD_BI ATP_SCHOOL_D ATP_SCH_STAT_CD   IRAP_BI UAD_DM  
219     Source School Type Stu_UAD_All_Applic_Tbl Source_School_Type Code indicating the type of school of origin. FORMER DEFINITION: Code indicating the type of school which is charged with greatest responsibility for undergraduate applicant's eligibility or, if no school is charged, then the type of the last school attended. A = California Public High School
B = California Private High School
C = California Public 2-Year College
D = California Private 2-Year College
E = California Public 4-Year College (CSU)
F = California Private 4 Year College
G = University of California
H = Other (not to include unknown)
K = Non-California Institution (US) L = Foreign Institution		 UAD_BI ATP_SCHOOL_D ATP_SCH_DRVD_TY_CD   IRAP_BI UAD_DM SCH_SRC_TYPE_CD 
220     Source School Zip Code Stu_UAD_All_Applic_Tbl Source_School_Zip Zip code for the school of origin attributed to the undergraduate applicant.   UAD_BI ATP_SCHOOL_D ATP_SCH_ZIP_CD   IRAP_BI UAD_DM  
221 U908 SSN Release Flag-Admissions   Stu_UAD_All_Applic_Tbl SSN_Release_Adm This flag indicates that the applicant has authorized the release of his/her social security number -- and release of his/her application information to educational research agencies for research and analysis purposes only. (Undergraduate Admissions File -- element comes in from ETS input) Y = Yes
blank = No		 UAD_BI APPLICANT_RELEASE_CODE_D AL_RL_SSN_CD   IRAP_BI UAD_DM  
222 G010 Name Student   Stu_UAD_All_Applic_Tbl Student_Name The name of the student, applicant, or postdoctoral scholar. Last Name (comma) First Name (space) Middle Names (comma) Suffix.   UAD_BI APPLICANT_D AL_FST_NAM
AL_MID_NAM
AL_LST_NAM		   IRAP_BI UAD_DM  
223 U530 Subject A ESL Indicator   Stu_UAD_All_Applic_Tbl SubjectA_ESL_Indicator Code indicating that the Universitywide Subject A Examination reader has designated the individual as an English as a Second Language (ESL) student. 1 - Yes
blank - No		 UAD_BI APPLICATION_F APPL_SUBJ_A_ESL_IND   IRAP_BI UAD_DM  
224 U540  Subject A Language in Home Code   Stu_UAD_All_Applic_Tbl SubjectA_Language_in_Home Code indicating the primary non-English language spoken by the Universitywide Subject A Test examinee. Code indicating which language, other than English, is the primary one spoken in the home of the individual. A Armenian
B Chinese (Cantonese)
C Chinese (Mandarin)
D Farsi/Persian
E Japanese
F Korean
G Russian
H Spanish
J Tagalog/Filipino
K Vietnamese
X Other		 UAD_BI ENTRY_LEVEL_WRITING_REQ_D ENT_LVL_WRTNG_REQ_SUBJ_A_NON_ENG_LANG_UCAP_CD   IRAP_BI UAD_DM  
225 U520 Analytical Writing Placement Exam Score   Stu_UAD_All_Applic_Tbl SubjectA_Test_Score Score received on the Universitywide Analytical Writing Placement Examination.   UAD_BI APPLICATION_F APPL_SUBJ_A_TST_SCO   IRAP_BI UAD_DM  
226 U550 Subject A Years in US   Stu_UAD_All_Applic_Tbl SubjectA_Years_in_US Number of years an ESL-designated Universitywide Subject A examinee has lived in the United States.   UAD_BI APPLICATION_F APPL_SUBJ_A_YRS_US_CNT   IRAP_BI UAD_DM  
227 U560 Subject A Years in US Schools   Stu_UAD_All_Applic_Tbl SubjectA_Years_in_US_Schs Number of years an ESL-designated Universitywide Subject A examinee has attended schools in the United States.   UAD_BI APPLICATION_F APPL_SUBJ_A_YRS_IN_US_SCHS_CNT   IRAP_BI UAD_DM  
228     Term Name Applied For Stu_UAD_All_Applic_Tbl Term_Applied Term Name associated to the code indicating the academic quarter in which the applicant wishes to commence his/her studies Fall, Spring, Winter UAD_BI TERM_D T_NAM   IRAP_BI UAD_DM TERM_NAME
229 U896 Transfer Courses Planned-English   Stu_UAD_All_Applic_Tbl Trans_Courses_Prel_English Code indicating the applicant has completed or intends to complete two transferable college courses in English Composition prior to transfer. 1 = Already completed with a grade of C or better
2 = In progress
3 = Planned
4 = None planned
5=Already completed with a grade of C or better (Pathways determined)
6=In progress (Pathways determined)
7=Planned (Pathways determined)
'blank'=No response Blank = No response.		 UAD_BI TRANSFER_COURSES_D TR_CRSES_ENG_RQMT_STAT_UCAP_CD   IRAP_BI UAD_DM  
230 U897 Transfer Courses Planned-Math   Stu_UAD_All_Applic_Tbl Trans_Courses_Prel_Math Code indicating the applicant has completed or intends to complete two transferable college courses in Math Concepts and Quantitative Reasoning prior to transfer. Code indicating the applicant has completed or intends to complete two transferable college courses in Math Concepts and Quantitative Reasoning prior to transfer. UAD_BI TRANSFER_COURSES_D TR_CRSES_MATH_RQMT_STAT_UCAP_CD   IRAP_BI UAD_DM  
231 U990 Transfer Courses Planned-Total   Stu_UAD_All_Applic_Tbl Trans_Courses_Prel_Total Code indicating the applicant has completed or intends to complete four transferable college courses in at least two of the following subject areas prior to transfer: Arts and Humanities; Social and Behavioral Sciences, Physical and Biological Sciences. 1 = Already completed with a grade of C or better
2 = In progress
3 = Planned
4 = None planned
5=Already completed with a grade of C or better (Pathways determined)
6=In progress (Pathways determined)
7=Planned (Pathways determined)
'blank'=No response Blank = No response.		 UAD_BI TRANSFER_COURSES_D TR_CRSES_SUBJ_AREA_RQMT_STAT_UCAP_CD   IRAP_BI UAD_DM  
232 U830 Transfer Units Completed-CCC   Stu_UAD_All_Applic_Tbl Trans_Units_Completed_CCC Total quarter units completed at California Community Colleges prior to transfer.   UAD_BI APPLICATION_F APPL_CCC_QTR_UNTS   IRAP_BI UAD_DM  
233 U904 Transfer Units Completed-Quarter   Stu_UAD_All_Applic_Tbl Trans_Units_Completed_Qtr Total quarter units completed prior to transfer.   UAD_BI APPLICATION_F APPL_TR_QTR_CMP_UNTS   IRAP_BI UAD_DM  
234   Transfer Units Completed-Semester   Stu_UAD_All_Applic_Tbl Trans_Units_Completed_Sem Total semester units completed prior to transfer.   UAD_BI APPLICATION_F APPL_TR_SMSTR_CMP_UNTS   IRAP_BI UAD_DM  
235 N100 Transfer Units Estimated-Self-reported   Stu_UAD_All_Applic_Tbl Trans_Units_Estimated_SR The total completed college quarter units reported by the advanced standing applicant.   UAD_BI APPLICATION_F APPL_TR_QTR_UNTS   IRAP_BI UAD_DM  
236 U919 Transfer Admissions Programs   Stu_UAD_All_Applic_Tbl Transfer_Programs The program(s) participated in by the transfer applicant. Up to 10 occurrences are possible though currently (Fall 2000) only 6 codes are being used. (Undergraduate Admissions File -- element comes in from ETS input) A=UCD Transfer Admission Guarantee (TAG)
B = UCB Cooperative Admissions Program (CAP)
C=UCI California Community College Honors Transfer Program
D=UCSB Transfer Admission Guarantee (TAG)
G=UCSC Transfer Admission Guarantee (TAG)
H=UCSD Honors Transfer Admission Guarantee (TAG)
J = UCSC Transfer Partnerships Program
K = UCM concurrent Admissions Program (CAP) (obsolete as of Fall 2007)
L=UCLA Transfer Alliance Program (TAP)
M = UCB Starting Point Mentoring Program
N=UCM Transfer Admission Guarantee (TAG)
O = UC Davis Transfer Opportunity Program
P=UCI Transfer Admission Guarantee (TAG)
R=UCR Transfer Admission Guarantee (TAG)
S = UCSD Transfer Admission Guarantee
T = UCB Transfer Alliance Project (TAP)
U = UCSD University Link		 UAD_BI ADM_PROGRAM_D ADM_PGM_D_UCAP_CD   IRAP_BI UAD_DM  
237 F040   Veteran Code Stu_UAD_All_Applic_Tbl Veteran_Code Code indicating whether or not individual has served with the US Armed Forces. Y = Yes
N = No		 UAD_BI APPLICANT_D AL_VET_IND   IRAP_BI UAD_DM VETERAN_FL
238     Academic Year Applied Stu_UAD_All_Applic_Tbl Year_Applied_AY Academic year student applied for   UAD_BI TERM_D T_ACAD_YR   IRAP_BI UAD_DM ACADEMIC_YR
239     Applicant-Berkeley Stu_UAD_All_Applic_Tbl Applicant_BK Flag indicating student applied to Berkeley campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_AL_CNT   IRAP_BI UAD_DM APP_01_UC_BK
240     Applicant-Davis Stu_UAD_All_Applic_Tbl Applicant_DV Flag indicating student applied to Davis campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_AL_CNT   IRAP_BI UAD_DM APP_03_UC_DV
241     Applicant-Irvine Stu_UAD_All_Applic_Tbl Applicant_IR Flag indicating student applied to Irvine campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_AL_CNT   IRAP_BI UAD_DM APP_09_UC_IR
242     Applicant-Los Angeles Stu_UAD_All_Applic_Tbl Applicant_LA Flag indicating student applied to Los Angeles campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_AL_CNT   IRAP_BI UAD_DM APP_04_UC_LA
243     Applicant-Merced Stu_UAD_All_Applic_Tbl Applicant_MC Flag indicating student applied to Merced campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_AL_CNT   IRAP_BI UAD_DM APP_10_UC_MC
244     Applicant-Riverside Stu_UAD_All_Applic_Tbl Applicant_RV Flag indicating student applied to Riverside campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_AL_CNT   IRAP_BI UAD_DM APP_05_UC_RV
245     Applicant-Santa Barbara Stu_UAD_All_Applic_Tbl Applicant_SB Flag indicating student applied to Santa Barbara campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_AL_CNT   IRAP_BI UAD_DM APP_08_UC_SB
246     Applicant-Santa Cruz Stu_UAD_All_Applic_Tbl Applicant_SC Flag indicating student applied to Santa Cruz campus 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_AL_CNT   IRAP_BI UAD_DM APP_07_UC_SC
247     Applicant-San Diego Stu_UAD_All_Applic_Tbl Applicant_SD Flag indicating student applied to San Diego campus 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_AL_CNT   IRAP_BI UAD_DM APP_06_UC_SD
248     Admit Regular-Berkeley Stu_UAD_All_Applic_Tbl Admit_Regular_BK Flag indicating student was a regular admit at the Berkeley campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_REGLR_CNT   IRAP_BI UAD_DM  
249     Admit Regular-Davis Stu_UAD_All_Applic_Tbl Admit_Regular_DV Flag indicating student was a regular admit at the Davis campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_REGLR_CNT   IRAP_BI UAD_DM  
250     Admit Regular-Irvine Stu_UAD_All_Applic_Tbl Admit_Regular_IR Flag indicating student was a regular admit at the Irvine campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_REGLR_CNT   IRAP_BI UAD_DM  
251     Admit Regular-Los Angeles Stu_UAD_All_Applic_Tbl Admit_Regular_LA Flag indicating student was a regular admit at the Los Angeles campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_REGLR_CNT   IRAP_BI UAD_DM  
252     Admit Regular-Merced Stu_UAD_All_Applic_Tbl Admit_Regular_MC Flag indicating student was a regular admit at the Merced campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_REGLR_CNT   IRAP_BI UAD_DM  
253     Admit Regular-Riverside Stu_UAD_All_Applic_Tbl Admit_Regular_RV Flag indicating student was a regular admit at the Riverside campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_REGLR_CNT   IRAP_BI UAD_DM  
254     Admit Regular-Santa Barbara Stu_UAD_All_Applic_Tbl Admit_Regular_SB Flag indicating student was a regular admit at the Santa Barbara campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_REGLR_CNT   IRAP_BI UAD_DM  
255     Admit Regular-Santa Cruz Stu_UAD_All_Applic_Tbl Admit_Regular_SC Flag indicating student was a regular admit at the Santa Cruz campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_REGLR_CNT   IRAP_BI UAD_DM  
256     Admit Regular-San Diego Stu_UAD_All_Applic_Tbl Admit_Regular_SD Flag indicating student was a regular admit at the San Diego campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_REGLR_CNT   IRAP_BI UAD_DM  
257     Admit Special-Berkeley Stu_UAD_All_Applic_Tbl Admit_Special_BK Flag indicating student was a special admit at the Berkeley campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_SPEC_CNT   IRAP_BI UAD_DM  
258     Admit Special-Davis Stu_UAD_All_Applic_Tbl Admit_Special_DV  Flag indicating student was a special admit at the Davis campus 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_SPEC_CNT   IRAP_BI UAD_DM  
259     Admit Special-Irvine Stu_UAD_All_Applic_Tbl Admit_Special_IR Flag indicating student was a special admit at the Irvine campus 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_SPEC_CNT   IRAP_BI UAD_DM  
260     Admit Special-Los Angeles Stu_UAD_All_Applic_Tbl Admit_Special_LA Flag indicating student was a special admit at the Los Angeles campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_SPEC_CNT   IRAP_BI UAD_DM  
261     Admit Special-Merced Stu_UAD_All_Applic_Tbl Admit_Special_MC Flag indicating student was a special admit at the Merced campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_SPEC_CNT   IRAP_BI UAD_DM  
262     Admit Special-Riverside Stu_UAD_All_Applic_Tbl Admit_Special_RV Flag indicating student was a special admit at the Riverside campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_SPEC_CNT   IRAP_BI UAD_DM  
263     Admit Special-Santa Barbara Stu_UAD_All_Applic_Tbl Admit_Special_SB Flag indicating student was a special admit at the Santa Barbara campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_SPEC_CNT   IRAP_BI UAD_DM  
264     Admit Special-Santa Cruz Stu_UAD_All_Applic_Tbl Admit_Special_SC Flag indicating student was a special admit at the Santa Cruz campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_SPEC_CNT   IRAP_BI UAD_DM  
265     Admit Special-San Diego Stu_UAD_All_Applic_Tbl Admit_Special_SD Flag indicating student was a special admit at the San Diego campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_SPEC_CNT   IRAP_BI UAD_DM  
266     Admit-Berkeley Stu_UAD_All_Applic_Tbl Admit_BK Flag indicating student was admitted to the Berkeley campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_CNT   IRAP_BI UAD_DM ADM_01_UC_BK
267     Admit-Davis Stu_UAD_All_Applic_Tbl Admit_DV Flag indicating student was admitted to the Davis campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_CNT   IRAP_BI UAD_DM ADM_03_UC_DV
268     Admit Special-Irvine Stu_UAD_All_Applic_Tbl Admit_IR Flag indicating student was admitted to the Irvine campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_CNT   IRAP_BI UAD_DM ADM_09_UC_IR
269     Admit Regular-Los Angeles Stu_UAD_All_Applic_Tbl Admit_LA Flag indicating student was admitted to the Los Angeles campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_CNT   IRAP_BI UAD_DM ADM_04_UC_LA
270     Admit Regular-Merced Stu_UAD_All_Applic_Tbl Admit_MC Flag indicating student was admitted to the Los Angeles campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_CNT   IRAP_BI UAD_DM ADM_10_UC_MC
271     Admit Regular-Riverside Stu_UAD_All_Applic_Tbl Admit_RV Flag indicating student was admitted to the Riverside campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_CNT   IRAP_BI UAD_DM ADM_05_UC_RV
272     Admit Regular-Santa Barbara Stu_UAD_All_Applic_Tbl Admit_SB Flag indicating student was admitted to the Santa Barbara campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_CNT   IRAP_BI UAD_DM ADM_08_UC_SB
273     Admit Special-Santa Cruz Stu_UAD_All_Applic_Tbl Admit_SC Flag indicating student was admitted to the Santa Cruz campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_CNT   IRAP_BI UAD_DM ADM_07_UC_SC
274     Admit Special-San Diego Stu_UAD_All_Applic_Tbl Admit_SD Flag indicating student was admitted to the San Diego campus. 1 - Yes
0 - No		 UAD_BI CAMPUS_APPLIED_F CMP_APPLD_ADT_CNT   IRAP_BI UAD_DM ADM_06_UC_SD
275     Application Count Stu_UAD_All_Applic_Tbl App_Count Count of campuses to which the student applied. 1 - Yes
0 - No		 UAD_BI APPLICATION_F APPL_CNT   IRAP_BI UAD_DM  
276     App Original Count Stu_UAD_All_Applic_Tbl App_Original_Count Count of campuses to which the student originally applied. 1 - Yes
0 - No		 UAD_BI APPLICATION_F APPL_APP_ORIG_CNT   IRAP_BI UAD_DM APPL_CAMPUS_CNT
277     App Selective Flag Stu_UAD_All_Applic_Tbl App_Selective_Flag Flag indicating student applied to a selective campus (BK, LA or SD). 1 - Yes
0 - No		 UAD_BI APPLICATION_F APPL_APPLD_SELTV_FL_CNT   IRAP_BI UAD_DM  
278     Admit Regular Count Stu_UAD_All_Applic_Tbl Admit_Regular_Count Count of campuses to which the student was reguarly admitted.   UAD_BI APPLICATION_F APPL_ADT_REGLR_CNT   IRAP_BI UAD_DM REGLR_ADM_CNT
279     Admit Special Count Stu_UAD_All_Applic_Tbl Admit_Special_Count Count of campuses to which the student was specially admitted.   UAD_BI APPLICATION_F APPL_ADT_SPEC_CNT   IRAP_BI UAD_DM SPECIAL_ADM_CNT
280     Admit Count Stu_UAD_All_Applic_Tbl Admit_Count Count of campuses to which the student was admitted.   UAD_BI APPLICATION_F APPL_ADT_CNT   IRAP_BI UAD_DM  
281     Admit Selective Flag Stu_UAD_All_Applic_Tbl Admit_Selective_Flag Flag indicating the student was admitted to a selective campus (BK, LA, SD). 1 - Yes
0 - No		 UAD_BI APPLICATION_F APPL_ADT_SELTV_FL_CNT   IRAP_BI UAD_DM  
282      SIR Count Stu_UAD_All_Applic_Tbl SIR_Count Count of campuses to which the student submitted a Statement of Intent to R. 1 - Yes
0 - No		 UAD_BI APPLICATION_F APPL_SIR_CNT   IRAP_BI UAD_DM  
283     SIR Campus Code Stu_UAD_All_Applic_Tbl SIR_Campus_Code Code for campus at which the student submitted a Statement of Intent to Register. ">1" if student SIRed at more than one campuses. 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		 UAD_BI APPLICATION_F/CAMPUS_LOCATION_D CAMPUS_LOCATION_D.CMP_LOC_LOC1_CD CMP_SIR_KEY=CMP_LOC_KEY IRAP_BI UAD_DM  
284     Registered Flag Stu_UAD_All_Applic_Tbl Registered_Flag Flag indicating student registered at a UC campus. 1 - Yes
0 - No		 UAD_BI APPLICATION_F APPL_AL_REGD_FL CMP_REGD_KEY=CMP_LOC_KEY IRAP_BI UAD_DM  
285 A010   Campus Registered Code Stu_UAD_All_Applic_Tbl Campus_Registered_Code Code indicating the campus at which the student or postdoctoral scholar is registered. 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		 UAD_BI APPLICATION_F/CAMPUS_LOCATION_D CAMPUS_LOCATION_D.CMP_LOC_LOC1_CD CMP_REGD_KEY=CMP_LOC_KEY IRAP_BI UAD_DM CMP_ENRL_CD
286     Identification Number-REG Stu_UAD_All_Applic_Tbl Identification_Number_Reg 12 character string which uniquely identifies a student in the UCOP database. Consists of the 2 digit campus code followed by the campus assigned ID. FKEY is the same as RKEY.   UAD_BI APPLICATION_F APPL_REG_IDENT_NUM   IRAP_BI UAD_DM  
287     Eligibility Campus Decision Reg Stu_UAD_All_Applic_Tbl Eligibility_Campus_Decision_Reg Eligibility for admission at the campus to which the student registered. Blank = No Action, retain, in progress
02 = Eligible - REGULAR Applicant meets regular admission criteria. May be based on actual or self-reported data. Includes early notification.
03 = Eligible - CEEB
04 = Eligible - Special Action-Technical Shortage
05 = Eligible - Special Action-High School Deficiency Waived
06 = Eligible - Special Action-High School Deficiency Waived- Improved Scholarship
07 = Eligible - Special Action-Disadvantaged
08 = Eligible - Special Action-Special Talents or Abilities-Athlete
09 = Eligible - Special Action-Special Talents or Abilities-Non-athlete
10 = Eligible - Special Action-Non-approved/Non-accredited School
11 = Eligible - Special Action-Administrative Committment
12 = Eligible - Special Action-Outstanding Recommendation
13 = Eligible - Special Action-High School Subject Deficiency Waived
14 = Eligible - Special Action-High School Scholarship Deficiency Waived
15 = Eligible - Special Action-High School Unit Deficiency Waived
16 = Eligible - Special Action-High School GPA Deficiency Waived
17 = Eligible - Special Action-Veteran
18 = Eligible - Special Action-Other
19 = Not Retained Campus does not want to consider applicant further for admission. May be eligible or ineligible but does not meet campus selection criteria. Applicant may become part of the referral pool.
20 = Not Eligible - Subject Deficiency
21 = Not Eligible - Scholarship/Subject Deficiency
22 = Not Eligible - 7 Unit Requirement Deficiency
23 = Not Eligible - UC eligible, Deferred by College
24 = Not Eligible - Lacks required GPA (2.42-2.8)
25 = Not Eligible - Less than 84 units
26 = Not Eligible - Other Includes not approved high school, not HS grad, less than 45 units, less than 63 units, not in good standing, 12 unit rule, etc.
27 = Eligible - Other Alternate admission offer #1 Academic year rollover or UC Extension offer. Student has not necessarily accepted the offer.
28 = Eligible - Other Alternate admission offer #2 Community college contract with priority or guaranteed admission as advanced standing student pending good academic work. Student has not necessarily accepted the offer.
35 = Cancel - Applicant Voluntary cancellation by applicant (before evaluation.
36 = Cancel - Campus-Death Campus cancels application. Code can only show actual cancellation of an admit due to death.
37 = Cancel - Campus- Campus cancels application. Code can Falsification only show actual cancellation of an admit due to student falsification.
38 = Cancel-Offer Withdrawn Campus withdraws admission offer - provision not met by applicant
40 = OP Cancellation due to Verification non-response
41 = OP cancellation due to Verification falsification
42 = OP cancellation due to other falsification
50 = Alternate admissions offer - Dual Admissions
51 = Campus reviewed; DAP eligible, not retained (for DAP Referral)		 UAD_BI CAMPUS_ELIGIBILITY_D CMP_ELGBLTY_CMP_DECN_CD   IRAP_BI UAD_DM  
288     Subject A Requirement Met - Campus Reg Stu_UAD_All_Applic_Tbl SubjectA_Requirement_Met_Reg Code indicating the means by which an applicant satisfied the Subject A requirement at the campus registered.   UAD_BI ENTRY_LEVEL_WRITING_REQ_D ENT_LVL_WRTNG_REQ_CD
ENT_LVL_WRTNG_REQ_DESC		   IRAP_BI UAD_DM  
289   Income of Parents of Applicant - Previous Year   Stu_UAD_All_Applic_Tbl Income_Parents_Previous Annual gross income of parents of applicant for undergraduate admission during previous calendar year preceding academic year (e.g. calendar year 2000 for fall 2002 applicants for admission).   UAD_BI APPLICATION_F APPL_FMY_PREV_YR_INC_AMT   IRAP_BI UAD_DM  
290   Income of Applicant - Previous Year   Stu_UAD_All_Applic_Tbl Income_Applicant_Previous Annual gross income of applicant for undergraduate admission during previous calendar year preceding academic year (e.g. calendar year 2000 for fall 2002 applicants for admission).   UAD_BI APPLICATION_F APPL_AL_PREV_YR_INC_AMT   IRAP_BI UAD_DM APPL_INCOME_PREV
291   Income of Parents of Applicant - Previous Year - Unknown Flag   Stu_UAD_All_Applic_Tbl Income_Parents_Previous_Unknown Income of parent of applicant for previous year missing from the application for undergraduate admission. Y = Yes
N = No		 UAD_BI APPLICATION_F APPL_INC_PARS_PREV_UNKN_FL   IRAP_BI UAD_DM  
292   Income of Applicant - Previous Year - Unknown Flag   Stu_UAD_All_Applic_Tbl Income_Applicant_Previous_Unknown Income of applicant for previous year missing from the application for undergraduate admission. Y = Yes
N = No		 UAD_BI APPLICATION_F APPL_INC_AL_PREV_UNKN_IND   IRAP_BI UAD_DM  
293   Dependents of Parents of Applicant - Previous Year   Stu_UAD_All_Applic_Tbl Dependents_Parents_Previous Family size of dependent student, including applicant, parents, and other dependents, in previous calendar year preceding academic year (e.g. calendar year 2000 for fall 2002 applicants).   UAD_BI APPLICATION_F APPL_FMY_PREV_YR_DPNDT_CNT   IRAP_BI UAD_DM  
294   Dependents of Applicant - Previous Year   Stu_UAD_All_Applic_Tbl Dependents_Applicant_Previous Family size of independent student, including applicant, spouse, and other dependents, in calendar year preceding academic year.   UAD_BI APPLICATION_F APPL_AL_PREV_YR_DPNDT_CNT   IRAP_BI UAD_DM  
295   Grade Point Average-Freshman-Capped-Repeats   Stu_UAD_All_Applic_Tbl GPA_Freshman_Capped_Rep GPA computed from self-reported information on the application. The number of AP and honors courses is limited to 8. 10th grade honors are limited to four and will not include any IB honors or HL honors for English. D/F grades not included if course repeated with grade of C or better. If no courses with D/F grades are repeated with C grade or better, field will be blank.   UAD_BI APPLICATION_F APPL_GPA_FRSHMN_CAPPED_REP_SCO   IRAP_BI UAD_DM  
296   Repeated Courses - Grade D   Stu_UAD_All_Applic_Tbl Repeated_Courses_D Number of 10th or 11th grade semester courses with a D grade repeated for a C grade or better.   UAD_BI HS_COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=RepeatedD HS_CRSE_TY_KEY=HS_CRSE_TY_KEY IRAP_BI UAD_DM  
297   Repeated Courses - Grade F   Stu_UAD_All_Applic_Tbl Repeated_Courses_F Number of 10th or 11th grade semester courses with F grade repeated for a C grade or better.   UAD_BI HS_COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=RepeatedF HS_CRSE_TY_KEY=HS_CRSE_TY_KEY IRAP_BI UAD_DM  
298   Fees Owed   Stu_UAD_All_Applic_Tbl Fees_Owed Amount applicant owes, rounded to whole dollars.   UAD_BI APPLICATION_F APPL_FEE_AMT   IRAP_BI UAD_DM  
299 U930 Total Courses-Subject G Requirement   Stu_UAD_All_Applic_Tbl Courses_Total_Subject_G Total number of college prep. elective semester courses taken or planned from 9th grade to 12th grade. Accept as written. No attempt to correct invalid applicant response. If indeterminate, field will contain hyphen in the first position. Non-response reported as blank. For Pathways applications, the Pathways system calculates this number. Item 77 on 2002 undergrad application; item 78 on 2003 undergrad application.   UAD_BI HS_COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=TotalSemestersG HS_CRSE_TY_KEY=HS_CRSE_TY_KEY IRAP_BI UAD_DM HSCRSE_TYP_TOTSEMS_G 
300 U931 Honors Courses - Honors Level   Stu_UAD_All_Applic_Tbl Courses_Honors_Honors_Level Total number of honors level (HL) semester courses taken, planned, or in-progress in 10th, 11th and 12th grades.   UAD_BI HS_COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=HonorsTypeTotalCountHl HS_CRSE_TY_KEY=HS_CRSE_TY_KEY IRAP_BI UAD_DM HSCRSE_TYP_HNRSTYPTTLCNT_HL
301 U932 Honors Courses - Advanced Placement   Stu_UAD_All_Applic_Tbl Courses_Honors_Advance_Placement Total number of advanced placement (AP) semester courses taken, planned, or in-progress in 10th, 11th and 12th grades.   UAD_BI HS_COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=HonorsTypeTotalCountAp HS_CRSE_TY_KEY=HS_CRSE_TY_KEY IRAP_BI UAD_DM HSCRSE_TYP_HNRSTYPTTLCNT_AP
302 U933 Honors Courses - International Baccalaureate   Stu_UAD_All_Applic_Tbl Courses_Honors_International_Bacc Total number of international baccalaureate (IB) semester courses taken, planned, or in-progress in 10th, 11th and 12th grades.   UAD_BI HS_COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=HonorsTypeTotalCountIb HS_CRSE_TY_KEY=HS_CRSE_TY_KEY IRAP_BI UAD_DM HSCRSE_TYP_HNRSTYPTTLCNT_IB
303 U934 Honors Courses - College Level   Stu_UAD_All_Applic_Tbl Courses_Honors_College_Level Total number of college level (CL) semester courses taken, planned, or in-progress in 10th, 11th and 12th grades.   UAD_BI HS_COURSE_COUNT_F/HS_COURSE_TYPE_D HS_CRSE_TY=HonorsTypeTotalCountCl HS_CRSE_TY_KEY=HS_CRSE_TY_KEY IRAP_BI UAD_DM HSCRSE_TYP_HNRSTYPTTLCNT_CL
304 T055 Visa Code - Planned   Stu_UAD_All_Applic_Tbl Visa_Code_Planned Code indicating planned non-U.S. Citizen Visa type as specified by the applicant. Refer to Citizenship/Visa Status Code Table. UAD_BI APPLICANT_D AL_NON_IMMIGRT_VSA_APPLD_CD   IRAP_BI UAD_DM  
305     Education_Highest_Parent Stu_UAD_All_Applic_Tbl Education_Highest_Parent Higher educational attainment among parents of student.   UAD_BI PARENT_EDUCATION_RESIDENCY_D PAR_EDU_RSDNCY_PAR_HGEST_EDU_LVL_CD   IRAP_BI UAD_DM HIGH_PARENT_EDU
306     Income of Parents of Applicant Unknown Flag Stu_UAD_All_Applic_Tbl Income_Parents_Unknown  Income of parent of applicant missing from the application for undergraduate admission. Y = Yes
N = No		 UAD_BI APPLICATION_F APPL_INC_PARS_UNKN_IND   IRAP_BI UAD_DM  
307     Income of Applicant Unknown Flag Stu_UAD_All_Applic_Tbl Income_Applicant_Unknown Income of applicant missing from the application for undergraduate admission. Y = Yes
N = No		 UAD_BI APPLICATION_F APPL_INC_AL_UNKN_IND   IRAP_BI UAD_DM  
308   Mixed Records Indicator   Stu_UAD_All_Applic_Tbl Mixed_Records_Indic Code indicating that student completed some of their studies outside the US Y' = Both high school and college outside US
'H' = Only high school outside US
'C' = College only outside US		 UAD_BI APPLICANT_D AL_MXD_REC_CD   IRAP_BI UAD_DM  
309 U938 High School Term Types   Stu_UAD_All_Applic_Tbl High_School_Term_Types High School Term Types. More than one type can be reported ETS will report as left-justified. S=Semester T=Trimester Q=Quarter B=Full (Block)   UAD_BI HS_TERM_D HS_T_TY_1_UCAP_CD
HS_T_TY_2_UCAP_CD
HS_T_TY_3_UCAP_CD
HS_T_TY_4_UCAP_CD		   IRAP_BI UAD_DM HS_TERM_TY_1_UCAP_CD
HS_TERM_TY_2_UCAP_CD
HS_TERM_TY_3_UCAP_CD
HS_TERM_TY_4_UCAP_CD
310  U939 Last School California   Stu_UAD_All_Applic_Tbl Last_School_California Last School California (Indicates if applicant has attended two or more years of school in California, or if the most recent school is in California.) Y = Yes
N = No		 UAD_BI RESIDENCY_D RSDNCY_AL_LST_SCH_CA_IND   IRAP_BI UAD_DM  
311 U940 California_Resident_1_Year   Stu_UAD_All_Applic_Tbl California_Resident_1_Year California Resident Time ( Indicates if applicant has lived in CA for at least one year.) Y = Yes
N = No		 UAD_BI RESIDENCY_D RSDNCY_AL_LIVED_CA_ONE_YR_IND   IRAP_BI UAD_DM  
312 U941 NOK_California_Resident   Stu_UAD_All_Applic_Tbl NOK_California_Resident  NOK California Resident (Indicates if applicant's parent or legal guardian is a California resident [for applicants 17 or younger]). Y = Yes
N = No		 UAD_BI PARENT_EDUCATION_RESIDENCY_D PAR_EDU_RSDNCY_PAR1_RSDNCY_STAT_CD   IRAP_BI UAD_DM  
313 U942 Application_Fee_Type   Stu_UAD_All_Applic_Tbl Application_Fee_Type Application Fee Type D=Domestic Fee
F=International Fee		 UAD_BI FEE_D FEE_TY_UCAP_CD   IRAP_BI UAD_DM  
314 U946 CETAD Identified   Stu_UAD_All_Applic_Tbl CETAD_Identified CETAD Identifed (Record has been identifed for central evaluation by campuses.)   UAD_BI APPLICATION_F APPL_CETAD_IDTFD_IND   IRAP_BI UAD_DM  
315 U937 Grade Point Average-Freshman-Unweighted   Stu_UAD_All_Applic_Tbl GPA_Freshman_Unweighted Grade Point Average-Freshman-Unweighted (Unweighted A-G GPA of freshman applicant does not include honors points.)   UAD_BI APPLICATION_F APPL_GPA_FRSHMN_AG_UNWTD_SCO   IRAP_BI UAD_DM HS_SCH_GPA_UNWTED_DTL
316  U943 Certified Transfer GPA   Stu_UAD_All_Applic_Tbl Certified_Transfer_GPA Calculated GPA only including courses certified transferable by ASSIST in Pathways   UAD_BI APPLICATION_F APPL_CERTD_TR_GPA_SCO   IRAP_BI UAD_DM  
317 U944 Certified Transfer Units Qtr   Stu_UAD_All_Applic_Tbl Certified_Transfer_Units_Qtr Total quarter (California community college transferable) units certified by ASSIST in Pathways   UAD_BI APPLICATION_F APPL_CERT_XFRBL_QTR_UNTS   IRAP_BI UAD_DM  
318 U945 Certified Transfer Units Sem   Stu_UAD_All_Applic_Tbl Certified_Transfer_Units_Sem  Total semester (California community college transferable) units certified by ASSIST in Pathways   UAD_BI APPLICATION_F APPL_CERT_XFRBL_SEM_UNTS   IRAP_BI UAD_DM  
319 U947 Certified Transfer Grade Pts Qtr   Stu_UAD_All_Applic_Tbl Certified_Transfer_Grade_Pts_Qtr Total quarter CT (California community college transfersable) grade points used in the Transfer_GPA_CT calculation   UAD_BI APPLICATION_F APPL_CERT_XFRBL_QTR_GRD_PTS   IRAP_BI UAD_DM  
320 U948 Certified Transfer Grade Pts Sem   Stu_UAD_All_Applic_Tbl Certified_Transfer_Grade_Pts_Sem Total semester CT (California community college transfersable) grade points used in the Transfer_GPA_CT calculation   UAD_BI APPLICATION_F APPL_CERT_XFRBL_SEM_GRD_PTS   IRAP_BI UAD_DM