# 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 UCDW Data Mart Schema Name UCDW Data Mart Table Name UCDW Data Mart Field Name
1     Year Applied Stu_UAD_All_ApplicCmp_Tbl Year_Applied     UAD_BI TERM_D T_CLND_YR       CALENDAR_YR
2 N020 Term Applied For   Stu_UAD_All_ApplicCmp_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_ApplicCmp_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 N180 Campus Applied to Code   Stu_UAD_All_ApplicCmp_Tbl Campus_Applied_to_Code Code indicating campus responsible for applicant record. 01 = Berkeley
02 = San Francisco
03 = Davis
04 = Los Angeles
05 = Riverside
06 = San Diego
07 = Santa Cruz
08 = Santa Barbara
09 = Irvine
10 = Merced
UAD_BI CAMPUS_LOCATION_D CMP_LOC_LOC1_CD        
5 L140   Applicant Direct Intercampus Transfer Stu_UAD_All_ApplicCmp_Tbl Applicant_Direct_ICT_Code Code indicating the status of an applicant in terms of previous attendance at the University. This element is a recode of element IAP_TYPE submitted by the campus. 1 = Direct = No previous UC attendance or UC attendance at another campus and attended non-UC college while absent
3 = ICT = Inter-campus transfer and no previous attendance at this campus
These codes became effective 07/15/85.
4 = Academic year rollover (effective Fall 2007)
Previous codes may be attached.
EFFECTIVE PRIOR TO 07/15/86
1 Direct/New No previous UC attendance
2 Direct/Returning UC attendance at another campus and attended non-UC college while absent
3 ICT/New Intercampus transfer and no previous attendance at this campus
4 ICT/Readmit Intercampus transfer and previous attendance at this campus
5 Readmit UC attendance at this campus, but absent for on
UAD_BI CAMPUS_INFO_D CMP_INFO_AL_DIREC_ICT_CD        
6     Application Received Code Stu_UAD_All_ApplicCmp_Tbl Application_Received_Code Code indicating the type of applicant received at a 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        APPL_RECVD_TY_CD_BK,
 APPL_RECVD_TY_CD_DV,
 APPL_RECVD_TY_CD_LA,
 APPL_RECVD_TY_CD_RV,
 APPL_RECVD_TY_CD_SD,
 APPL_RECVD_TY_CD_SC,
 APPL_RECVD_TY_CD_SB,
 APPL_RECVD_TY_CD_IR,
 APPL_RECVD_TY_CD_MC
7 F140 Application Received Date   Stu_UAD_All_ApplicCmp_Tbl Application_Received_Date Date an application was received by the undergraduate admission office.   UAD_BI APPLICATION_F APPL_RECD_DT        
8     Campus Name Abbreviation App Stu_UAD_All_ApplicCmp_Tbl Campus_Name_Abbreviation_App Two-character abbreviation of campus name at which student applied.   UAD_BI CAMPUS_LOCATION_D CMP_LOC_LOC1_ABRV_DESC        
9     Campus Name App Stu_UAD_All_ApplicCmp_Tbl Campus_Name_App Name of campus at which campus applied.   UAD_BI CAMPUS_LOCATION_D CMP_LOC_LOC1_LNG_DESC        
10 F220 Cancelled Application Flag   Stu_UAD_All_ApplicCmp_Tbl Cancelled_Application_Flag Code indicating by whom an application was cancelled. A = Cancelled by administration
V = Voluntarily cancelled by applicant
UAD_BI CAMPUS_APPLIED_F CMP_APPLD_CCL_FL        
11     CCM_Code_Proposed Stu_UAD_All_ApplicCmp_Tbl CCM_Code_Proposed     UAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_CCM_CD        
12     CIP Category Code Proposed Stu_UAD_All_ApplicCmp_Tbl CIP_Category_Code_Proposed Two-digit Classification of Instructional Programs code, indicating disciplinary area, proposed by the applicant.   UAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_CIP_FMY_CD        
13     CIP Category Name Proposed Stu_UAD_All_ApplicCmp_Tbl CIP_Category_Name_Proposed Name of the two-digit Classification of Instructional Programs code, indicating disciplinary area, proposed by the applicant.   UAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_CIP_FMY_NAM        
14     CIP Code Proposed Stu_UAD_All_ApplicCmp_Tbl CIP_Code_Proposed Code for the CIP (Classification of Instructional Programs) discipline associated with the major in which the applicant plans to enroll or the first major of a joint or concurrent degree program in which the applicant plans to enroll. Refer to CIP Code Table. UAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_CIP_CD        CMP_CG_MAJ_CIP_CD_BK,
 CMP_CG_MAJ_CIP_CD_DV,
 CMP_CG_MAJ_CIP_CD_LA,
 CMP_CG_MAJ_CIP_CD_RV,
 CMP_CG_MAJ_CIP_CD_SD,
 CMP_CG_MAJ_CIP_CD_SC,
 CMP_CG_MAJ_CIP_CD_SB,
 CMP_CG_MAJ_CIP_CD_IR,
 CMP_CG_MAJ_CIP_CD_MC
15     CIP Name Proposed Stu_UAD_All_ApplicCmp_Tbl CIP_Name_Proposed Name of the CIP (Classification of Instructional Programs) discipline associated with the major in which the applicant plans to enroll or the first major of a joint or concurrent degree program in which the applicant plans to enroll. Refer to CIP Code Table. UAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_CIP_NAM        CMP_CG_MAJ_CIP_NAM_BK,
 CMP_CG_MAJ_CIP_NAM_DV,
 CMP_CG_MAJ_CIP_NAM_LA,
 CMP_CG_MAJ_CIP_NAM_RV,
 CMP_CG_MAJ_CIP_NAM_SD,
 CMP_CG_MAJ_CIP_NAM_SC,
 CMP_CG_MAJ_CIP_NAM_SB,
 CMP_CG_MAJ_CIP_NAM_IR,
 CMP_CG_MAJ_CIP_NAM_MC
16 F150 College Code Proposed   Stu_UAD_All_ApplicCmp_Tbl College_Code_Proposed Name of the college in which applicant plans to enroll. Refer to College Code Table. UAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_LOC_CG_CD        
17     College Name Proposed Stu_UAD_All_ApplicCmp_Tbl College_Name_Proposed Name of the college in which applicant plans to enroll.   UAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_LOC_CG_NAM        
18 N200 Honors Courses-Total   Stu_UAD_All_ApplicCmp_Tbl Courses_Honors_Total Number of semester courses used in computing the A-F GPA.   UAD_BI CAMPUS_APPLIED_F CMP_APPLD_CRSES_HNR_TOT_CNT        
19     Eligibility Campus-2 Category Stu_UAD_All_ApplicCmp_Tbl Eligibility_Campus_2CAT Code indicating two-category admission type (regular or special). Recode of CELIGADM. R = Regular Admit
S = Special Admit
UAD_BI CAMPUS_ELIGIBILITY_D CMP_ELGBLTY_CMP_REG_2_CAT_CD        
20 L120   Eligibility for Admission-Campus Determination Stu_UAD_All_ApplicCmp_Tbl Eligibility_Campus_Decision Code indicating eligibility status (admit/defer) of applicant for Code indicating eligibility status (admit/defer) of applicant for admission. 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          ELGBLITY_CMP_BK_DECN_CD,
   ELGBLITY_CMP_DV_DECN_CD,
   ELGBLITY_CMP_LA_DECN_CD,
   ELGBLITY_CMP_RV_DECN_CD,
   ELGBLITY_CMP_SD_DECN_CD,
   ELGBLITY_CMP_SC_DECN_CD,
   ELGBLITY_CMP_SB_DECN_CD,
   ELGBLITY_CMP_IR_DECN_CD,
   ELGBLITY_CMP_MC_DECN_CD
21 L150   EOP/AAP Participation Code-Admission Stu_UAD_All_ApplicCmp_Tbl EOP_AAP_Code_Adm Code indicating assignment of applicant to a special program such as the Educational Opportunity or Academic Advancement Program. 1 - Yes
blank - No
UAD_BI CAMPUS_APPLIED_F CMP_APPLD_APPL_INFO_EOP_IND        
22 L070 High School Grade Points Used-Subjects A-F   Stu_UAD_All_ApplicCmp_Tbl HS_Grade_Points_AtoF Grade points earned for high school units in the A-F pattern used to determine eligibility for admission.   UAD_BI CAMPUS_APPLIED_F CMP_APPLD_HS_ATOF_PNT_GRD        
23 L060 High School Units Used-Subjects A-F   Stu_UAD_All_ApplicCmp_Tbl HS_Units_AtoF The total number of high school units in the A-F pattern used to determine eligibility for admission. Renamed from UADM element AFUNITS.   UAD_BI CAMPUS_APPLIED_F CMP_APPLD_HS_ATOF_UNT        CMP_APPLD_HS_ATOF_UNT_BK,
 CMP_APPLD_HS_ATOF_UNT_DV,
 CMP_APPLD_HS_ATOF_UNT_LA,
 CMP_APPLD_HS_ATOF_UNT_RV,
 CMP_APPLD_HS_ATOF_UNT_SD,
 CMP_APPLD_HS_ATOF_UNT_SC,
 CMP_APPLD_HS_ATOF_UNT_SB,
 CMP_APPLD_HS_ATOF_UNT_IR,
 CMP_APPLD_HS_ATOF_UNT_MC
24 N060 Identification Number-UAD   Stu_UAD_All_ApplicCmp_Tbl Identification_Number_UAD Number which identifies applicant on the campus. For applicants who have registered, this must be number which identifies the person in the population of registrants.   UAD_BI CAMPUS_APPLIED_F CMP_APPLD_AL_ID        
25 F160 Major Code Proposed   Stu_UAD_All_ApplicCmp_Tbl Major_Code_Proposed Code indicating the academic program (major) in which the applicant plans to enroll. Refer to Major Code Table. UAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_MAJ_CD        CMP_CG_MAJ_BK_CD,
 CMP_CG_MAJ_DV_CD,
 CMP_CG_MAJ_LA_CD,
 CMP_CG_MAJ_RV_CD,
 CMP_CG_MAJ_SD_CD,
 CMP_CG_MAJ_SC_CD,
 CMP_CG_MAJ_SB_CD,
 CMP_CG_MAJ_IR_CD,
 CMP_CG_MAJ_MC_CD
26     Major Name Proposed Stu_UAD_All_ApplicCmp_Tbl Major_Name_Proposed Name of the academic program (major) in which the applicant plans to enroll. Refer to Major Code Table. UAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_ID_SHRT_NAM        CMP_CG_MAJ_CD_ID_SHRT_NAM_BK,
 CMP_CG_MAJ_CD_ID_SHRT_NAM_DV,
 CMP_CG_MAJ_CD_ID_SHRT_NAM_LA,
 CMP_CG_MAJ_CD_ID_SHRT_NAM_RV,
 CMP_CG_MAJ_CD_ID_SHRT_NAM_SD,
 CMP_CG_MAJ_CD_ID_SHRT_NAM_SC,
 CMP_CG_MAJ_CD_ID_SHRT_NAM_SB,
 CMP_CG_MAJ_CD_ID_SHRT_NAM_IR,
 CMP_CG_MAJ_CD_ID_SHRT_NAM_MC
27 N070   Registered Code Stu_UAD_All_ApplicCmp_Tbl Registered_Code Code indicating that the applicant has registered at UC. Y = Yes
blank = No
UAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_APPLD_APPL_REGD_FL        
28 F230   SIR Response Code Stu_UAD_All_ApplicCmp_Tbl SIR_Code Code indicating applicant's response to offer of admission (Statement of Intention to Register). 1 = Accepted admission
2 = Declined - registering at other school
3 = Declined - not enrolling in any school
4 = Declined - staying at current school
5 = Declined - other reason
6 = Declined - after SIR acceptance
7 = Accepted Shared Experience Program Offer, Receiving Campus (UC Merced only), effective Fall 2007. [Formerly, for Fall 2004, Accepted Dual Admission]
8 = Accepted Alternate Admission Offer: Rollover, UC Extension, CCC Contract/Guarantee or Shared Experience-Sending Campus. (Shared Experience-Sending Campus added Fall 2007)
UAD_BI APPLICATION_F APPL_AL_SIR_CNT        
29     Special Programs Code-Admission Stu_UAD_All_ApplicCmp_Tbl Special_Programs_Adm Code indicating applicant's assignment to special programs other than EOP/AAP. 1 = Athlete
2 = Self-reported disability (obsolete)
4 = Physically Disabled (HOPE)
5 = Student Affirmative Action
UAD_BI CAMPUS_INFO_D CMP_INFO_SPEC_PGM_ADM_1_CD
CMP_INFO_SPEC_PGM_ADM_2_CD
CMP_INFO_SPEC_PGM_ADM_3_CD
       
30 F240   Subject A Requirement Code Stu_UAD_All_ApplicCmp_Tbl SubjectA_Requirement_Met Code indicating the means by which an applicant satisfied the Subject A requirement. A = Score of 680 or better on CEEB Achievement Test (SAT II)
B = Score of 3, 4, or 5 on CEEB Advanced Placement Test
C = Completion with grade of C or better of four quarter-unit or three semester-unit college level course in English composition at another institution
D = Subject A Exam administered by the campus
E = Completion of course in Subject A or equivalent
F = CSUC English examination (Effective Fall 1997 this code is no longer used)
G = Score of 600 on TOEFL (eliminated in 1999)
H = Subject A passed, method unknown
J = Universitywide Subject A Exam
U=Score of 30 or better on the ACT Combined English/Writing Test
V = Score of 680 or better on SAT II Writing Test
W = Satisfaction by International Baccalaureate - Standard Level (SL)
X = Satisfaction by International Baccalaureate Exam - Higher Level (HL)
UAD_BI ENTRY_LEVEL_WRITING_REQ_D UAD_CMP_APPLD_B_ENT_LVL_WRTNG_RQMT_CD        
31 F100 Transfer Grade Points-Source School    Stu_UAD_All_ApplicCmp_Tbl Trans_Grade_Points_Src Grade points earned for quarter units of college level graded work attempted at the source school.   UAD_BI CAMPUS_APPLIED_F CMP_APPLD_SRC_SCH_TR_GRD_PNTS        
32 L100 Transfer Grade Points-Total   Stu_UAD_All_ApplicCmp_Tbl Trans_Grade_Points_Total Total grade points (in quarter units) earned for college level graded work attempted at all institutions, including U.C. Renamed from UADM element COLGP.   UAD_BI CAMPUS_APPLIED_F CMP_APPLD_TOT_TR_GRD_PNTS        CMP_APPLD_TOT_TR_GRD_PNTS_BK,
 CMP_APPLD_TOT_TR_GRD_PNTS_DV,
 CMP_APPLD_TOT_TR_GRD_PNTS_LA,
 CMP_APPLD_TOT_TR_GRD_PNTS_RV,
 CMP_APPLD_TOT_TR_GRD_PNTS_SD,
 CMP_APPLD_TOT_TR_GRD_PNTS_SC,
 CMP_APPLD_TOT_TR_GRD_PNTS_SB,
 CMP_APPLD_TOT_TR_GRD_PNTS_IR,
 CMP_APPLD_TOT_TR_GRD_PNTS_MC
33 F120 Transfer Grade Points-Graded-UC   Stu_UAD_All_ApplicCmp_Tbl Trans_Grade_Points_UC Total grade points earned for graded work (in quarter units) attempted at UC campuses previously attended, excluding UC Extension. Renamed from UADM element UCGP.   UAD_BI CAMPUS_APPLIED_F CMP_APPLD_TOT_TR_UC_GRD_PNTS        
34   Transfer Units Accepted-Source School   Stu_UAD_All_ApplicCmp_Tbl Trans_Units_Accepted_Src Number of quarter units of college level graded and pass/not pass work accepted from the source school. Renamed from UADM element PCOLUNITAC.   UAD_BI CAMPUS_APPLIED_F CMP_APPLD_SRC_SCH_TR_ACD_UNTS        
35 L095 Transfer Units Accepted-Total   Stu_UAD_All_ApplicCmp_Tbl Trans_Units_Accepted_Total College level graded and pass/not pass work (in quarter units) accepted from all institutions, including U.C. Renamed from UADM element COLUNITACC.   UAD_BI CAMPUS_APPLIED_F CMP_APPLD_TOT_TR_ACD_UNTS        
36 F090 Transfer Units Attempted-Graded-Source School   Stu_UAD_All_ApplicCmp_Tbl Trans_Units_Attmptd_Grded_Src Number of quarter units of college level graded work attempted at the source school. Renamed from UADM element PCOLUNITA.   UAD_BI CAMPUS_APPLIED_F CMP_APPLD_SRC_SCH_TR_ATM_UNTS        TRANS_UNITS_ATTMPTD_SRC_BK,
 TRANS_UNITS_ATTMPTD_SRC_DV,
 TRANS_UNITS_ATTMPTD_SRC_LA,
 TRANS_UNITS_ATTMPTD_SRC_RV,
 TRANS_UNITS_ATTMPTD_SRC_SD,
 TRANS_UNITS_ATTMPTD_SRC_SC,
 TRANS_UNITS_ATTMPTD_SRC_SB,
 TRANS_UNITS_ATTMPTD_SRC_IR,
 TRANS_UNITS_ATTMPTD_SRC_MC
37 L090 Transfer Units Attempted-Graded-Total   Stu_UAD_All_ApplicCmp_Tbl Trans_Units_Attmptd_Grded_Ttl College level graded work (in quarter units) attempted at all institutions, including U.C. Renamed from UADM element COLUNITA.   UAD_BI CAMPUS_APPLIED_F CMP_APPLD_TOT_TR_ATM_UNTS        TRANS_UNITS_ATTMPTD_TTL_BK,
 TRANS_UNITS_ATTMPTD_TTL_DV,
 TRANS_UNITS_ATTMPTD_TTL_LA,
 TRANS_UNITS_ATTMPTD_TTL_RV,
 TRANS_UNITS_ATTMPTD_TTL_SD,
 TRANS_UNITS_ATTMPTD_TTL_SC,
 TRANS_UNITS_ATTMPTD_TTL_SB,
 TRANS_UNITS_ATTMPTD_TTL_IR,
 TRANS_UNITS_ATTMPTD_TTL_MC
38 F110 Transfer Units Attempted-Graded-UC   Stu_UAD_All_ApplicCmp_Tbl Trans_Units_Attmptd_Grded_UC Total graded work (in quarter units) attempted at UC campuses previously attended, excluding UC Extension. Renamed from UADM element UCUNITS.   UAD_BI CAMPUS_APPLIED_F CMP_APPLD_TOT_TR_UC_ATM_UNTS        
39 N120 Transfer Units Passed-Graded-Source School   Stu_UAD_All_ApplicCmp_Tbl Trans_Units_Passed_Grded_Src Number of advanced standing units passed at the source school. Does not include P/NP units passed at source school.   UAD_BI CAMPUS_APPLIED_F CMP_APPLD_SRC_SCH_TR_PED_UNTS        
40 F130 Transfer Units Passed-Graded-UC   Stu_UAD_All_ApplicCmp_Tbl Trans_Units_Passed_Grded_UC Total graded work (in quarter units) passed at UC campuses previously attended, excluding UC Extension. Renamed from UADM element UCPASS.   UAD_BI CAMPUS_APPLIED_F UAD_CMP_APPLD_B_TOT_TR_UC_PED_UNTS        
41 N130 Transfer Units Passed Pass/No pass-Source School   Stu_UAD_All_ApplicCmp_Tbl Trans_Units_Passed_PNP_Src Number of advanced standing units for pass/fail courses at the source school.   UAD_BI CAMPUS_APPLIED_F CMP_APPLD_SRC_SCH_TR_PNP_UNTS        
42 N140 Transfer Units Passed-Total   Stu_UAD_All_ApplicCmp_Tbl Trans_Units_Passed_Total Total advanced standing transfer units passed at all previously attended institutions. (Used to determine eligibility for admissions   UAD_BI CAMPUS_APPLIED_F CMP_APPLD_TOT_TR_PED_UNTS        
43     UC Discipline Code Proposed Stu_UAD_All_ApplicCmp_Tbl UC_Discipline_Code_Proposed Code indicating the UC discipline proposed by the applicant. Refer to UC Discipline Code Table. UAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_UC_DISCIPLN_CD        
44     UC Discipline Name Proposed Stu_UAD_All_ApplicCmp_Tbl UC_Discipline_Name_Proposed Name of the UC discipline proposed by the applicant.   UAD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_UC_DISCIPLN_NAM        
45     Guaranteed Transfer Option Stu_UAD_All_ApplicCmp_Tbl Guaranteed_Transfer_Option Code Indicating Guaranteed Transfer Status of Applicants at campus level. 1 = Offered GTO (No Further Action)
2 = Offered GTO; GTO Offer Cancelled
3 = Offered GTO; Offered Freshman
4 = Offered GTO; Offered Freshman; Freshman Offer Retracted; GTO Offer Stands
5 = Offered GTO; Offered Freshman; Freshman Offer Cancelled
6 = Offered Freshman (Appeal, Yield, Restoration)
7 = Offered Freshman; Freshman Offer Cancelled
UAD_BI CAMPUS_INFO_D CMP_INFO_GTD_TR_OPT_CD        
46 N080 GPA Freshman SR Campus   Stu_UAD_All_ApplicCmp_Tbl GPA_Freshman_SR_Campus The overall GPA (excluding physical education) reported by the freshman applicant for the 10th and 11th grades of high school. Supplied by campus. Should be same as CALCGPA.   UAD_BI CAMPUS_APPLIED_F CMP_APPLD_SLF_RPTED_FRSHMN_GPA_SCO        
47 F390 ACT English Score Best - Campus   Stu_UAD_All_ApplicCmp_Tbl ACT_English_Score_Best_Campus 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 TST_CATLG_M_TST_CATG_CD='ACT'
TST_CATLG_M_TST_EVAL_NAM='ACT_ENGLISH_BEST'
TST_CATLG_M_TST_CD = 'ACTEnglish'
     
48 F400 ACT Math Score Best - Campus   Stu_UAD_All_ApplicCmp_Tbl ACT_Math_Score_Best_Campus 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 TST_CATLG_M_TST_CATG_CD='ACT'
TST_CATLG_M_TST_EVAL_NAM='ACT_MATH_BEST'
TST_CATLG_M_TST_CD = 'ACTMath'
     
49   ACT Reading Score-Best Campus   Stu_UAD_All_ApplicCmp_Tbl ACT_Reading_Score_Best_Campus ACT Reading subscore. Campus reported information.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='ACT'
TST_CATLG_M_TST_EVAL_NAM='ACT_READING_BEST'
TST_CATLG_M_TST_CD = 'ACTReading'
     
50   ACT Science Score-Best Campus   Stu_UAD_All_ApplicCmp_Tbl ACT_Science_Score_Best_Campus ACT Science subscore. Campus provided information   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='ACT'
TST_CATLG_M_TST_EVAL_NAM='ACT_SCIENCE_BEST'
TST_CATLG_M_TST_CD = 'ACTScience'
     
51 F380   ACT Composite Score Best - Campus Stu_UAD_All_ApplicCmp_Tbl ACT_Composite_Score_Best_Campus IF ACTSCRMTHC GT 0 AND ACTSCREAC GT 0 AND ACTSCRSCIC GT 0 AND ACTSCRENGC GT 0 THEN (ACTSCRMTHC + ACTSCRREAC + ACTSCRSCIC + ACTSCRENGC) / 4 ELSE 0; (rounded) .   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='ACT'
TST_CATLG_M_TST_EVAL_NAM='ACT_COMPOSITE_BEST'
TST_CATLG_M_TST_CD = 'ACT'
     
52 F290 SATII Writing Exam Code Best - Campus   Stu_UAD_All_ApplicCmp_Tbl SATII_Writing_Code_Best_Campus 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_CATALOG_D TST_CATLG_M_TST_CD
Code Values:
SATIIWritingEnglishCompositionA
SATIIWritingEnglishCompositionwithEssayV
SATIIWritingUnk
SATIIWritingW
     
53 F300 SATII Writing Exam Score Best - Campus   Stu_UAD_All_ApplicCmp_Tbl SATII_Writing_Score_Best_Campus Best score received on the College Entrance Examination Board SAT II achievement test in English composition.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SATII'
TST_CATLG_M_TST_EVAL_NAM='SATII_WRITING_BEST'
TST_CATLG_M_TST_CD = <any code from above cell>
     
54 F320 SATII Third Exam Code Best - Campus   Stu_UAD_All_ApplicCmp_Tbl SATII_3rd_Code_Best_Campus 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_CATALOG_D TST_CATLG_M_TST_CD
Code Values:
SATIIBiology
SATIIChemistry
SATIIChineseListening
SATIIEuropeanHistory
SATIIFrenchListening
SATIIGermanListening
SATIIHebrewModern
SATIIHistoryWorld
SATIIItalian
SATIIJapaneseListening
SATIIKoreanListening
SATIILatin
SATIILiterature
SATIIMolecularBiology
SATIIPhysics
SATIIRussian
SATIISpanishListening
SATIIUnk
SATIIUsHistory
     
55 F330 SATII Third Exam Score Best - Campus   Stu_UAD_All_ApplicCmp_Tbl SATII_3rd_Score_Best_Campus 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 TST_CATLG_M_TST_CATG_CD='SATII'
TST_CATLG_M_TST_EVAL_NAM='SATII_3RD_BEST'
TST_CATLG_M_TST_CD = <any code from above cell>
     
56 F350 SATII Math Exam Code Best - Campus   Stu_UAD_All_ApplicCmp_Tbl SATII_Math_Code_Best_Campus 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_CATALOG_D TST_CATLG_M_TST_CD
Code Values:
SATIIMath1
SATIIMath2
SATIIUnk
     
57 F360 SATII Math Exam Score Best - Campus   Stu_UAD_All_ApplicCmp_Tbl SATII_Math_Score_Best_Campus Best score received on the College Entrance Examination Board SAT II achievement test in mathematics.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD='SATII'
TST_CATLG_M_TST_EVAL_NAM='SATII_MATH_BEST'
TST_CATLG_M_TST_CD = <any code from above cell>
     
58 F260 SATI Verbal Score Best - Campus   Stu_UAD_All_ApplicCmp_Tbl SATI_Verbal_Score_Best_Campus 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 TST_CATLG_M_TST_CATG_CD='SATI'
TST_CATLG_M_TST_EVAL_NAM='SATI_VERBAL_BEST'
TST_CATLG_M_TST_CD = 'SATIVerbal
     
59 F270 SATI Math Exam Score Best - Campus   Stu_UAD_All_ApplicCmp_Tbl SATI_Math_Score_Best_Campus 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 TST_CATLG_M_TST_CATG_CD='SATI'
TST_CATLG_M_TST_EVAL_NAM='SATI_MATH_BEST'
TST_CATLG_M_TST_CD = 'SATIMath
     
60 F430 Index Score total   Stu_UAD_All_ApplicCmp_Tbl Index_Score_Total Code is the score used to determine UC eligibility. Score is the sum of: a) the SAT total score or translated ACT total score (translated ACT_AC plus ACT Writing), and b) the two highest SAT Subject test scores   UAD_BI CAMPUS_APPLIED_F CMP_APPLD_IDX_TOT_SCO        
61 F431 ACT English Score Highest   Stu_UAD_All_ApplicCmp_Tbl ACT_English_Score_Highest Highest ACT English Score 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= 'ACT_ENGLISH_HIGH'
TST_CATLG_M_TST_CD = 'ACTEnglish'
     
62  F432 ACT Math Score Highest   Stu_UAD_All_ApplicCmp_Tbl ACT_Math_Score_Highest Highest ACT Math Score 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= 'ACT_MATH_HIGH'
TST_CATLG_M_TST_CD = 'ACTMath'
     
63 F433 ACT Reading Score Highest   Stu_UAD_All_ApplicCmp_Tbl ACT_Reading_Score_Highest highest ACT Reading Score 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= 'ACT_READING_HIGH'
TST_CATLG_M_TST_CD = 'ACTReading'
     
64 F434 ACT Science Score Highest   Stu_UAD_All_ApplicCmp_Tbl ACT_Science_Score_Highest highest ACT Science Score 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= 'ACT_SCIENCE_HIGH'
TST_CATLG_M_TST_CD = 'ACTScience'
     
65   ACT EngWrit Score Best Campus   Stu_UAD_All_ApplicCmp_Tbl ACT_EngWrit_Score_Best_Campus  ACT score for combined English/writing. Campus provided information   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD= 'ACT'
TST_CATLG_M_TST_EVAL_NAM= 'ACT_ENGLISH_WRITING_BEST'
TST_CATLG_M_TST_CD = 'ACTEnglishWriting'
     
66  F436 SAT Reading Score Highest   Stu_UAD_All_ApplicCmp_Tbl SAT_Reading_Score_Highest Highest SAT Reading Score from best sitting reported and used by the campus for determining admissions.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD= 'SAT'
TST_CATLG_M_TST_EVAL_NAM= 'SAT_READING_HIGH'
TST_CATLG_M_TST_CD = 'SATReading'
     
67 F437 SAT Math Score Highest   Stu_UAD_All_ApplicCmp_Tbl SAT_Math_Score_Highest Highest SAT Math Score from best sitting reported and used by the campus for determining admissions.   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD= 'SAT'
TST_CATLG_M_TST_EVAL_NAM= 'SAT_MATH_HIGH'
TST_CATLG_M_TST_CD = 'SATMath'
     
68 F438 SAT Writing Score Highest   Stu_UAD_All_ApplicCmp_Tbl SAT_Writing_Score_Highest Highest SAT Writing Score from best sitting reported and used by the campus for determining admissions   UAD_BI TEST_F TST_SCO TST_CATLG_M_TST_CATG_CD= 'SAT'
TST_CATLG_M_TST_EVAL_NAM= 'SAT_WRITING_HIGH'
TST_CATLG_M_TST_CD = 'SATWriting'
     
69 F439 SAT Subject Code Highest   Stu_UAD_All_ApplicCmp_Tbl SAT_Subject_Code_Highest Subject Code for the SAT Subject Highest Score 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
Code 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
70 F440 SAT Subject Score Highest   Stu_UAD_All_ApplicCmp_Tbl SAT_Subject_Score_Highest Highest SAT Subject Score 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 from above list>
     
71 F441 SAT Subject2 Code Highest   Stu_UAD_All_ApplicCmp_Tbl SAT_Subject2_Code_Highest Subject Code for the SAT Subject 2 highest Score 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
Code 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
72 F442 SAT Subject2 Score Highest   Stu_UAD_All_ApplicCmp_Tbl SAT_Subject2_Score_Highest Highest SAT Subject 2 Score 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_2_HIGH'
TST_CATLG_M_TST_CD = <Any code from above list>
     
73     ACT Composite Score with Writing - Best Campus Stu_UAD_All_ApplicCmp_Tbl ACT_CompWrit_Score_Best_Campus ACT composite score calculated from 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'