# REF INFO 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 UCDW Data Mart Schema Name UCDW Data Mart Table Name UCDW Data Mart Field Name
1   Year Applied   Stu_UAD_All_Applic2_Tbl Year_Applied     UAD_BI TERM_D T_CLND_YR       CALENDAR_YR
2 N020 Term Applied For   Stu_UAD_All_Applic2_Tbl Term_Applied_Code Code indicating the academic quarter in which the applicant wishes to commence his/her studies. 1 = Summer
2 = Fall
3 = Winter
4 = Spring
UAD_BI TERM_D T_CD       TERM_CD
3 N210 Identification Number-ETS   Stu_UAD_All_Applic2_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
This column exists in all fact tables.     APPLICATION_ID
4   IGETC_SR   Stu_UAD_All_Applic2_Tbl IGETC_SR Indicates completion of IGETC. This is a self-reported data item.   UAD_BI APPLICATION_F APPL_I_GET_C_CPLTD_IND        
5   Index Score Total (Vendor)   Stu_UAD_All_Applic2_Tbl Index_Score_Total_Vendor Index Score Total provided by vendor.   UAD_BI APPLICATION_F APPL_IDX_TOT_SCO        
6   SAT Reading Score Self-Reported   Stu_UAD_All_Applic2_Tbl SAT_Reading_Score_SR Self-reported score on the SAT Reading test.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SAT'
TST_CATLG_M_TST_EVAL_NAM='SAT_READING'
TST_CATLG_M_TST_CD = 'SATReading'
     
7   SAT Math Score Self-Reported   Stu_UAD_All_Applic2_Tbl SAT_Math_Score_SR  Self-reported score on the SAT Math test.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SAT'
TST_CATLG_M_TST_EVAL_NAM='SAT_MATH'
TST_CATLG_M_TST_CD = 'SATMath'
     
8   SAT Writing Score Self-Reported   Stu_UAD_All_Applic2_Tbl SAT_Writing_Score_SR Self-reported score on the SAT Math test.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SAT'
TST_CATLG_M_TST_EVAL_NAM='SAT_MATH'
TST_CATLG_M_TST_CD = 'SATMath'

Note: There are 2 dimension rows (due to SCD II)for this test.
One row has an incorrect TST_CATLG_ETS_BUS_NAM.
     
9   SAT US History Score Self-Reported   Stu_UAD_All_Applic2_Tbl SAT_US_History_Score_SR Self-reported score on the SAT US History test.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SATSubject'
TST_CATLG_M_TST_EVAL_NAM='SAT_US_HISTORY'
TST_CATLG_M_TST_CD = 'SATUSHistory'
     
10   SAT World History Score Self-Reported   Stu_UAD_All_Applic2_Tbl SAT_World_History_Score_SR Self-reported score on the SAT World History test.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SATSubject'
TST_CATLG_M_TST_EVAL_NAM='SAT_WORLD_HISTORY'
TST_CATLG_M_TST_CD = 'SATHistoryWorld'
     
11   SAT European History Score Self-Reported   Stu_UAD_All_Applic2_Tbl SAT_European_History_Score_SR Self-reported score on the SAT European History test.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SATSubject'
TST_CATLG_M_TST_EVAL_NAM='SAT_EUROPEAN_HISTORY'
TST_CATLG_M_TST_CD = 'SATEuropeanHistory'
     
12   SAT Literature Score Self-Reported   Stu_UAD_All_Applic2_Tbl SAT_Literature_Score_SR Self-reported score on the SAT Literature test.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SATSubject'
TST_CATLG_M_TST_EVAL_NAM='SAT_LITERATURE'
TST_CATLG_M_TST_CD = 'SATLiterature'
     
13   SAT Math 2 Score Self-Reported   Stu_UAD_All_Applic2_Tbl SAT_Math2_Score_SR Self-reported score on the SAT Math Level 2 test.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SATSubject'
TST_CATLG_M_TST_EVAL_NAM='SAT_MATH2'
TST_CATLG_M_TST_CD = 'SATMath2'
     
14   SAT Biology Ecological Score Self-Reported   Stu_UAD_All_Applic2_Tbl SAT_Biology_E_Score_SR  Self-reported score on the SAT Biology Ecological test.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SATSubject'
TST_CATLG_M_TST_EVAL_NAM='SAT_BIOLOGY'
TST_CATLG_M_TST_CD = 'SATBiology'
     
15   SAT Biology Ecological Score Self-Reported   Stu_UAD_All_Applic2_Tbl SAT_Biology_M_Score_SR Self-reported score on the SAT Biology Molecular test   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SATSubject'
TST_CATLG_M_TST_EVAL_NAM='SAT_MOLECULAR_BIOLOGY'
TST_CATLG_M_TST_CD = 'SATMolecularBiology'
     
16   SAT Chemistry Score Self-Reported   Stu_UAD_All_Applic2_Tbl SAT_Chemistry_Score_SR Self-reported score on the SAT Chemistry test.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SATSubject'
TST_CATLG_M_TST_EVAL_NAM='SAT_CHEMISTRY'
TST_CATLG_M_TST_CD = 'SATChemistry'
     
17   SAT Physics Score Self-Reported   Stu_UAD_All_Applic2_Tbl SAT_Physics_Score_SR SAT Physics Score Self-Reported   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SATSubject'
TST_CATLG_M_TST_EVAL_NAM='SAT_PHYSICS'
TST_CATLG_M_TST_CD = 'SATPhysics'
     
18   SAT Language 1 Score Self-Reported   Stu_UAD_All_Applic2_Tbl SAT_Language_1_Score_SR Self-reported score on the SAT Language I test.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SATSubject'
TST_CATLG_M_TST_EVAL_NAM='SAT_LANG_1'
TST_CATLG_M_TST_CD = <any code in below cell>
     
19   SAT Language 1 Code   Stu_UAD_All_Applic2_Tbl SAT_Language_1_Code SAT Language I test code reported by applicant. CL = CHINESE LISTENING
FL = FRENCH LISTENING
FR = FRENCH
GL = GERMAN LISTENING
GM = GERMAN
IT = ITALIAN
JL = JAPANESE LISTENING
KL = KOREAN LISTENING
LT = LATIN
MH = MODERN HEBREW
SL = SPANISH LISTENING
SP = SPANISH
or blank
UAD_BI TEST_CATALOG_D TST_CATLG_M_TST_CD
Valid Values:
SATChineseListening
SATFrench
SATFrenchListening
SATGerman
SATGermanListening
SATHebrewModern
SATItalian
SATJapaneseListening
SATKoreanListening
SATLatin
SATSpanish
SATSpanishListening
SATUnk
SATHebrewModern
     
20   SAT Language 2 Score Self-Reported   Stu_UAD_All_Applic2_Tbl SAT_Language_2_Score_SR Self-reported score on the SAT Language II test.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SATSubject'
TST_CATLG_M_TST_EVAL_NAM='SAT_LANG_2'
TST_CATLG_M_TST_CD = <any code in below cell>
     
21   SAT Language 2 Code   Stu_UAD_All_Applic2_Tbl SAT_Language_2_Code SAT Language II test code reported by applicant. CL = CHINESE LISTENING
FL = FRENCH LISTENING
FR = FRENCH
GL = GERMAN LISTENING
GM = GERMAN
IT = ITALIAN
JL = JAPANESE LISTENING
KL = KOREAN LISTENING
LT = LATIN
MH = MODERN HEBREW
SL = SPANISH LISTENING
SP = SPANISH
or blank
UAD_BI TEST_CATALOG_D TST_CATLG_M_TST_CD
Valid Values:
SATChineseListening
SATFrench
SATFrenchListening
SATGerman
SATGermanListening
SATHebrewModern
SATItalian
SATJapaneseListening
SATKoreanListening
SATLatin
SATSpanish
SATSpanishListening
SATUnk
SATHebrewModern
     
22   SAT Language 3 Score Self-Reported   Stu_UAD_All_Applic2_Tbl SAT_Language_3_Score_SR Self-reported score on the SAT Language III test.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SATSubject'
TST_CATLG_M_TST_EVAL_NAM='SAT_LANG_3'
TST_CATLG_M_TST_CD = <any code in below cell>
     
23   SAT Language 3 Code   Stu_UAD_All_Applic2_Tbl SAT_Language_3_Code SAT Language III test code reported by applicant. "CL = CHINESE LISTENING
FL = FRENCH LISTENING
FR = FRENCH
GL = GERMAN LISTENING
GM = GERMAN
IT = ITALIAN
JL = JAPANESE LISTENING
KL = KOREAN LISTENING
LT = LATIN
MH = MODERN HEBREW
SL = SPANISH LISTENING
SP = SPANISH
or blank
UAD_BI TEST_CATALOG_D TST_CATLG_M_TST_CD
Valid Values:
SATChineseListening
SATFrench
SATFrenchListening
SATGerman
SATGermanListening
SATHebrewModern
SATItalian
SATJapaneseListening
SATKoreanListening
SATLatin
SATSpanish
SATSpanishListening
SATUnk
SATHebrewModern
     
24   ACT English Writing Score Self-reported   Stu_UAD_All_Applic2_Tbl ACT_EngWrit_Score_SR ACT score for combined English/writing reported by applicant   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='ACT'
TST_CATLG_M_TST_EVAL_NAM = 'ACT_WRITING'
TST_CATLG_M_TST_CD = 'ACTWriting'
     
25   CETAD Evaluated GPA SR   Stu_UAD_All_Applic2_Tbl CETAD_Evaluated_GPA_SR CETAD EVALUATED Transfer GPA   UAD_BI APPLICATION_F APPL_CETAD_EVALD_SLFRPTED_GPA_SCO       CETAD_EVALD_TRF_GPA_SCORE
26   CETAD Evaluated Quarter Units   Stu_UAD_All_Applic2_Tbl CETAD_Evaluated_QTR_Units CETAD Evaluated Quarter Units   UAD_BI APPLICATION_F APPL_CERT_XFRBL_QTR_UNTS        
27   CETAD Evaluated Math Transfer Course   Stu_UAD_All_Applic2_Tbl CETAD_Evaluated_Math_Trans_Crse CETAD Evaluated Math Transfer Course C=Complete
I=In Progress
N=Not complete or in progress
blank=Not reviewed
UAD_BI CETAD_D CETAD_MATH_RQMT_STAT_UCAP_CD        
28   CETAD Evaluated English Transfer Course   Stu_UAD_All_Applic2_Tbl CETAD_Evaluated_Engl_Trans_Crse CETAD Evaluated English Composition Transfer Course C=Complete
I=In Progress
N=Not complete or in progress
blank=Not reviewed
UAD_BI CETAD_D CETAD_ENG_RQMT_STAT_UCAP_CD        
29   CETAD Evaluated Transfer Courses   Stu_UAD_All_Applic2_Tbl CETAD_Evaluated_Trans_Crses CETAD evaluated other transfer courses C=Complete
I=In Progress
N=Not complete or in progress
blank=Not reviewed
UAD_BI CETAD_D CETAD_SUBJ_AREA_RQMT_STAT_UCAP_CD        
30   CETAD Reason Code   Stu_UAD_All_Applic2_Tbl CETAD_Reason_Code CETAD Reason Code 01=Student is clearly ineligible, no further review
02=Student in bad standing
03=International work included
04=No WIP is needed
05=Non-CCC or UC work present that should exclude appl from CETAD data exchange
06=Missing information; cannot complete review
07-Evaluator alert; see comments
08-Does not meet CETAD criteria; remove from CETAD pool
blank=Not reviewed
UAD_BI CETAD_D CETAD_RSN_UCAP_CD        
31   Permanent Street   Stu_UAD_All_Applic2_Tbl Permanent_Street Applicant's permanent street address   UAD_BI APPLICAT_D AL_PERM_ADDR_LN1_TXT       APPL_PERM_ADDR_ST_1
32   Permanent City   Stu_UAD_All_Applic2_Tbl Permanent_City Applicant's permanent address city   UAD_BI APPLICAT_D AL_PERM_CTY_NAM       APPL_PERM_CITY
33   Permanent State   Stu_UAD_All_Applic2_Tbl Permanent_State Applicant's permanent address State   UAD_BI APPLICAT_D AL_PERM_ST_PRVNC_NAM       APPL_PERM_ST
34   Permanent ZIP   Stu_UAD_All_Applic2_Tbl Permanent_Zip Applicant's permanent address ZIP code   UAD_BI APPLICAT_D AL_PERM_PSTL_CD       APPL_PERM_ZIP
35   Permanent Country   Stu_UAD_All_Applic2_Tbl Permanent_Country Applicant's permanent address ZIP code   UAD_BI APPLICAT_D AL_PERM_CTRY_CD        
36   Applicant Alert   Stu_UAD_All_Applic2_Tbl Applicant_Alert Flag indicating a problem with the Application. Contains up to 5 permanent codes. A=Test scores delayed, not applicant's fault B=applicant affect by program error, Central Processor C=applicant affected by program error, Pathways
D=Student Initiated Early Referral (formally Early Referral Offer)
E=Possible academic comments available (Pathways only)
blank=no problem
UAD_BI APPLICANT_ALERT_D AL_ALRT_1_UCAP_CD
AL_ALRT_2_UCAP_CD
AL_ALRT_3_UCAP_CD
AL_ALRT_4_UCAP_CD
       
37   Military Service Status   Stu_UAD_All_Applic2_Tbl Military_Service Code Indicating the military service status of applicant. Self-reported 1=Veteran
2=Active Military Duty
3=Reserves or National Guard
4=Veteran and Active Military Duty
5=Veteran and Reserves or National Guard
6=Active Military Duty and Reserves or National Guard
7=Veteran and Active Military Duty and Reserves or National Guard
blank=no response
UAD_BI APPLICAT_D AL_STAT_MILIT_RELHIP_UCAP_CD       MILITARY_STATUS_CD
38   ACT English Score-Self-reported   Stu_UAD_All_Applic2_Tbl ACT_English_Score_SR ACT English subscore reported by applicant.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='ACT'
TST_CATLG_M_TST_EVAL_NAM = 'ACT_ENGLISH'
TST_CATLG_M_TST_CD = 'ACTEnglish'
     
39   ACT Math Score-Self-reported   Stu_UAD_All_Applic2_Tbl ACT_Math_Score_SR ACT Math subscore reported by applicant.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='ACT'
TST_CATLG_M_TST_EVAL_NAM = 'ACT_MATH'
TST_CATLG_M_TST_CD = 'ACTMath'
     
40   ACT Reading Score-Self-reported   Stu_UAD_All_Applic2_Tbl ACT_Reading_Score_SR ACT Reading subscore reported by applicant.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='ACT'
TST_CATLG_M_TST_EVAL_NAM = 'ACT_READING'
TST_CATLG_M_TST_CD = 'ACTReading'
     
41   ACT Science Score-Self-reported   Stu_UAD_All_Applic2_Tbl ACT_Science_Score_SR ACT Science subscore reported by applicant.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='ACT'
TST_CATLG_M_TST_EVAL_NAM = 'ACT_SCIENCE'
TST_CATLG_M_TST_CD = 'ACTScience'
     
42     ACT Composite Score with Writing-Self-reported Stu_UAD_All_Applic2_Tbl ACT_CompWrit_Score_SR ACT Composite score reported by applicant.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='ACT'
TST_CATLG_M_TST_EVAL_NAM = 'ACT_COMPOSITION_WRITING'
TST_CATLG_M_TST_CD = 'ACTCompositionWriting'
     
43   Converted Honors 10   Stu_UAD_All_Applic2_Tbl Conv_Honors_10 Sum of AP, HL, and IB honors attached to 10th grade courses, converted to semester format.   UAD_BI HS_COURSE_TYPE_D HS_CRSE_TY=ConvertedHonors10        
44   Converted Honors 11   Stu_UAD_All_Applic2_Tbl Conv_Honors_11 Sum of AP, HL, and IB honors attached to 11th grade courses, converted to semester format.   UAD_BI HS_COURSE_TYPE_D HS_CRSE_TY=ConvertedHonors11        
45   Converted Honors 12   Stu_UAD_All_Applic2_Tbl Conv_Honors_12 Sum of AP, HL, and IB honors attached to 12th grade courses, converted to semester format.   UAD_BI HS_COURSE_TYPE_D HS_CRSE_TY=ConvertedHonors12        
46   Converted Total Courses - AG   Stu_UAD_All_Applic2_Tbl Conv_Total_AG  Total high school courses in A through G subject area, converted to semester format.   UAD_BI HS_COURSE_TYPE_D HS_CRSE_TY=ConvertedTotalCoursesAg       HSCRSE_TYP_CONV_TOT_CRSE_A_G
47   Converted Semester Total   Stu_UAD_All_Applic2_Tbl Conv_Semester_Total Total high school courses, converted to semester format.   UAD_BI HS_COURSE_TYPE_D HS_CRSE_TY=ConvertedSemCoursesTotal       HSCRSE_TYP_CONV_TOT_SEMCRSE
48   UC Score Core   Stu_UAD_All_Applic2_Tbl UC_Score_Core The translated ACT total score or SAT total score, whichever is higher. Official if present, otherwise self-reported.   UAD_BI APPLICATION_F APPL_UC_CORE_SCO       CORE_SCO
49   UC Score Total   Stu_UAD_All_Applic2_Tbl UC_Score_Total Sum of the UC-CORE-SCORE and the two highest translated SAT subject test scores.   UAD_BI APPLICATION_F APPL_UC_TOT_SCO       TOT_SCO
50   ACT EngWrit Score Best   Stu_UAD_All_Applic2_Tbl ACT_EngWrit_Score_Best ACT score for combined English/writing. Rollup from campus provided information   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='ACT'
TST_CATLG_M_TST_EVAL_NAM = 'ACT_WRITING_BEST'
TST_CATLG_M_TST_CD = 'ACTWriting'
     
51     ACT Composite Score with Writing - Best Stu_UAD_All_Applic2_Tbl ACT_CompWrit_Score_Best ACT Composite score calculated from rollup of ACT scores submitted by campuses.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='ACT'
TST_CATLG_M_TST_EVAL_NAM ='ACT_COMPOSITION_WRITING_BEST'
TST_CATLG_M_TST_CD ='ACTCompositionWriting' 
     
52     SAT Reading Score Highest System Stu_UAD_All_Applic2_Tbl SAT_Reading_Score_Highest_Sys Highest SAT Reading Score from best sitting. Rollup from data reported and used by the campus for determining admissions.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='ACT'
TST_CATLG_M_TST_EVAL_NAM = 'SAT_READING_HIGH'
TST_CATLG_M_TST_CD = 'SATReading'
     
53     SAT Math Score Highest System Stu_UAD_All_Applic2_Tbl SAT_Math_Score_Highest_Sys Highest SAT Math Score from best sitting. Rollup from data reported and used by the campus for determining admissions.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='ACT'
TST_CATLG_M_TST_EVAL_NAM = 'SAT_MATH_HIGH'
TST_CATLG_M_TST_CD = 'SATMath'
     
54     SAT Writing Score Highest System Stu_UAD_All_Applic2_Tbl SAT_Writing_Score_Highest_Sys Highest SAT Writing Score from best sitting. Rollup from data reported and used by the campus for determining admissions.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='ACT'
TST_CATLG_M_TST_EVAL_NAM = 'SAT_WRITING_HIGH'
TST_CATLG_M_TST_CD = 'SATWriting'
     
55     SAT Subject Code Highest System Stu_UAD_All_Applic2_Tbl SAT_Subject_Code_Highest_Sys Subject Code for the SAT Subject Highest Score. Rollup form data reported and used by the campus for determining admissions. AH - AMERICAN HISTORY AND SOCIAL STUDIES
BY - BIOLOGY
EB - BIOLOGY - ECOLOGICAL
MB - BIOLOGY - MOLECULAR
CH - CHEMISTRY
CL - CHINESE LISTENING
EH - EUROPEAN HISTORY AND WORLD CULTURES
FL - FRENCH LISTENING
FR - FRENCH
GL - GERMAN LISTENING
GM - GERMAN
IT - ITALIAN
JL - JAPANESE LISTENING
KL - KOREAN LISTENING
LR - LITERATURE
LT - LATIN
M2 - MATH LEVEL 2
2C - MATH LEVEL 2
MH - MODERN HEBREW
PH - PHYSICS
SL - SPANISH LISTENING
SP - SPANISH
UH - US HISTORY
WH - WORLD HISTORY
UAD_BI TEST_CATALOG_D TST_CATLG_M_TST_CD Valid Values:
SATBiology
SATChemistry
SATChineseListening
SATEcologicalBiology
SATEuropeanHistory
SATFrench
SATFrenchListening
SATGerman
SATGermanListening
SATHebrewModern
SATHistoryWorld
SATItalian
SATJapaneseListening
SATJapaneseWithListening
SATKoreanListening
SATLatin
SATLiterature
SATMath2
SATMath2Calculator
SATMolecularBiology
SATPhysics
SATSpanish
SATSpanishListening
SATUSHistory
SATUnk
SATUsHistory
    SAT_SUBJ_1_HIGH_CD
56     SAT Subject Score Highest System Stu_UAD_All_Applic2_Tbl SAT_Subject_Score_Highest_Sys Highest SAT Subject Score. Rollup from data reported and used by the campus for determining admissions.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SATSubject'
TST_CATLG_M_TST_EVAL_NAM = 'SAT_SUBJ_1_HIGH'
TST_CATLG_M_TST_CD = <any code value in above cell>
     
57     SAT Subject2 Code Highest System Stu_UAD_All_Applic2_Tbl SAT_Subject2_Code_Highest_Sys Subject Code for the SAT Subject 2 Highest Score. Rollup form data reported and used by the campus for determining admissions. AH - AMERICAN HISTORY AND SOCIAL STUDIES
BY - BIOLOGY
EB - BIOLOGY - ECOLOGICAL
MB - BIOLOGY - MOLECULAR
CH - CHEMISTRY
CL - CHINESE LISTENING
EH - EUROPEAN HISTORY AND WORLD CULTURES
FL - FRENCH LISTENING
FR - FRENCH
GL - GERMAN LISTENING
GM - GERMAN
IT - ITALIAN
JL - JAPANESE LISTENING
KL - KOREAN LISTENING
LR - LITERATURE
LT - LATIN
M2 - MATH LEVEL 2
2C - MATH LEVEL 2
MH - MODERN HEBREW
PH - PHYSICS
SL - SPANISH LISTENING
SP - SPANISH
UH - US HISTORY
WH - WORLD HISTORY
UAD_BI TEST_CATALOG_D TST_CATLG_M_TST_CD Valid Values:
SATBiology
SATChemistry
SATChineseListening
SATEcologicalBiology
SATEuropeanHistory
SATFrench
SATFrenchListening
SATGerman
SATGermanListening
SATHebrewModern
SATHistoryWorld
SATItalian
SATJapaneseListening
SATJapaneseWithListening
SATKoreanListening
SATLatin
SATLiterature
SATMath2
SATMath2Calculator
SATMolecularBiology
SATPhysics
SATSpanish
SATSpanishListening
SATUSHistory
SATUnk
SATUsHistory
    SAT_SUBJ_2_HIGH_CD
58     SAT Subject2 Score Highest System Stu_UAD_All_Applic2_Tbl SAT_Subject2_Score_Highest_Sys Highest SAT Subject 2 Score. Rollup from data reported and used by the campus for determining admissions.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SATSubject'
TST_CATLG_M_TST_EVAL_NAM = 'SAT_SUBJ_1_HIGH'
TST_CATLG_M_TST_CD = <any code value in above cell>
     
59   Foster Care Status   Stu_UAD_All_Applic2_Tbl Foster_Care Code Indicating the foster care status of applicant. Self-reported.   UAD_BI APPLICANT_D AL_FSTR_CARE_FL       FOSTER_CARE_FL
60   Student Organization Release flag   Stu_UAD_All_Applic2_Tbl Student_Organization_Release Code Indicating that applicant allows the release of data to student organizations.   UAD_BI APPLICANT_RELEASE_CODE_D AL_RL_TO_STUD_ORGS_FL=Y        
61   Permanent Address Street line 2   Stu_UAD_All_Applic2_Tbl Permanent_Street2 Second line of permanent address street information   UAD_BI APPLICANT_D AL_PERM_ADDR_LN2_TXT       APPL_PERM_ADDR_ST_2
62   Rollover ETSNO   Stu_UAD_All_Applic2_Tbl Rollover_ETSNO Original CPID for a rollover application   UAD_BI APPLICATION_F APPL_RLVR_UC_APPL_ID        
63 E045 Ethnic Hierarchy Code-Admission   Stu_UAD_All_Applic2_Tbl Ethnic_Hierarchy Code indicating the ethnic hierarchy code of the student as recorded at the time of application for admission. 01 = African American/Black
02 = Caribbean Black
03 = African
04 = Other African American/Black
05 = Mexican/Mexican American/Chicano
06 = Latin American/Latino
07 = Puerto Rican
08 = Cuban
09 = Other Spanish American/Latino
10 = American Indian/Alaskan Native
11 = Filipino/Filipino American
12 = Vietnamese
13 = Chinese (except Taiwanese)
14 = Taiwanese
15 = Asian Indian
16 = Pakistani
17=- Japanese/Japanese American
18 = Korean
19 = Fijian
20 = Guamanian/Chamorro
21 = Hawaiian
22 = Samoan
23 = Tongan
24 = Other Pacific Islander
25 = Bangladeshi
26 = Cambodian
27 = Hmong
28 = Indonesian
29 = Laotian
30 = Malaysian
31 = Sri Lankan
32 = Thai
33 = Other Asian
34 = European/White
35 = Middle Eastern/White
36 = North African/White
37 = Other White
blank = Other
UAD_BI UC_ETHNIC_CODE_LEVEL_2_D UC_ETN_CD_LVL_2_APPLYUC_CD        
64   Ethnic Hierarchy Code-Admission Ethnic Hierarchy Name Stu_UAD_All_Applic2_Tbl Ethnic_Hierarchy_Name Ethnic Hierarchy name   UAD_BI UC_ETHNIC_CODE_LEVEL_2_D UC_ETN_CD_LVL_2_CD_NAM        
65     Tribal Member Stu_UAD_All_Applic2_Tbl Tribal_Member Indicates the applicant’s American Indian./Alaskan Native tribal status. 1=Federal
2=State
3=Other
<Blank>=Unknown
Null
UAD_BI APPLICANT_D AL_TRBL_MBR_STAT_UCAP_CD        
66     Tribal Enrollment Number Stu_UAD_All_Applic2_Tbl Tribal_Enrollment_Number American Indian./Alaskan Native tribal enrollment number for federally recognized tribes.   UAD_BI APPLICATION_F APPL_TRBL_ENRL_NUM        
67     AG Eleven Stu_UAD_All_Applic2_Tbl AG_Eleven Applicant has a minimum of 11 a-g courses through the end of the 11th grade.  D/F courses have been cleared by repeat and/or validated by advanced course or exam. Y,<Blank>,Null UAD_BI APPLICANT_D AL_AGE_ELEVN_FL        
68     AG Fifteen Stu_UAD_All_Applic2_Tbl AG_Fifteen Applicant met/will meet the minimum 15 a-g courses requirement at the end of the 12th grade.  D/F courses have been cleared by repeat and/or validated by advanced course or exam.  Y,<Blank>,Null UAD_BI APPLICANT_D AL_AGE_FIFTEEN_FL        
69     ELC Percent Stu_UAD_All_Applic2_Tbl ELC_Percent ELC Percent 1,2,3,4,5,6,7,8,9,blank,null UAD_BI APPLICATION_F APPL_ELC_PCT        
70     Fee Waiver Flag Stu_UAD_All_Applic2_Tbl Fee_Waiver_Flag Fee waiver flag 1,Y,E,<Blank>,Null UAD_BI FEE_D FEE_WVR_FL        
71     Referral Offer Flag Stu_UAD_All_Applic2_Tbl Referral_Offer_Flag Referral offer flag Y,<Blank>,Null UAD_BI APPLICATION_F APPL_REFRL_OFFR_FL       REFRL_OFFR_IND
72     Perm Intl St Stu_UAD_All_Applic2_Tbl Perm_Intl_St Permanent international state LN, SH,HN,HE,CQ,GD,ZJ,BJ,GJ,GS,MD,FJ,HL,DL,SC,ON,JL,SN,KA,JS,WB,UP,HB,SD,TN,HA,BC,TJ,AP,YN,AH,HR,KL,CH,HI,GZ,AB,QH,NX,AS
PB,RJ,NS,NM,NL,HP,JH,JK,OR,QC,BR,MZ
SK,CT,GA,MB,UT,NT,XZ,TR,PY,
UAD_BI APPLICANT_D AL_PERM_INTL_ST_CD        
73     Is Milt Depnd Stu_UAD_All_Applic2_Tbl Is_Milt_Depnd Military dependent indicator Y,<Blank>,Null UAD_BI APPLICANT_D AL_MILIT_DPNDT_IND        
74     Referral Status Stu_UAD_All_Applic2_Tbl Referral_Status Referral status code 1,2,<Blank>,Null UAD_BI APPLICANT_D AL_REFRL_STAT_CD        
75     Geometry Req Met Stu_UAD_All_Applic2_Tbl Geometry_Req_Met Geometry requirements met code Y,<Blank>,Null       New element Not in BI schema yet      
76     Toefl IBT Highest Score Stu_UAD_All_Applic2_Tbl Toefl_IBT_Highest_Score TOEFL IBT highest test score   UAD_BI TEST_F TST_SCO Additional research required for this test      
77     Toefl PBT Highest Score Stu_UAD_All_Applic2_Tbl Toefl_PBT_Highest_Score TOEFL PBT highest test score 593-443,Null UAD_BI TEST_F TST_SCO Additional research required for this test