C O R P O R A T E * S T U D E N T * S Y S T E M   
Warehouse Table Codebook:
Warehouse Name - Courses_Academic_Grade_A
Element Name:  Academic Courses-Grade A
Programming Name:  ACADCRSA
Master Format F2
Unique Values:  <50
Source: ETS
Define Code: 
Description:  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.
Comment: 
Code Interpretation: 

Warehouse Name - Courses_Academic_Grade_B
Element Name:  Academic Courses-Grade B
Programming Name:  ACADCRSB
Master Format F2
Unique Values:  <50
Source: ETS
Define Code: 
Description:  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.
Comment: 
Code Interpretation: 

Warehouse Name - Courses_Academic_Grade_C
Element Name:  Academic Courses-Grade C
Programming Name:  ACADCRSC
Master Format F2
Unique Values:  <50
Source: ETS
Define Code: 
Description:  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.
Comment: 
Code Interpretation: 

Warehouse Name - Courses_Academic_Grade_D
Element Name:  Academic Courses-Grade D
Programming Name:  ACADCRSD
Master Format F2
Unique Values:  <50
Source: ETS
Define Code: 
Description:  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.
Comment: 
Code Interpretation: 

Warehouse Name - Courses_Academic_Grade_F
Element Name:  Academic Courses-Grade F
Programming Name:  ACADCRSF
Master Format F2
Unique Values:  <50
Source: ETS
Define Code: 
Description:  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.
Comment: 
Code Interpretation: 

Warehouse Name - Courses_Honors_10th_Grade
Element Name:  Honors Courses-10th Grade
Programming Name:  ACADHON10
Master Format F2
Unique Values:  <50
Source: ETS
Define Code: 
Description:  The number of self-reported honors level semester courses in the A-F Subject Areas taken in the 10th grade.
Comment: 
Code Interpretation: 

Warehouse Name - Courses_Honors_1011_Grade
Element Name:  Honors Courses-10th and 11th Grade
Programming Name:  ACADHON1011
Master Format F2
Unique Values:  <50
Source: ETS
Define Code: 
Description:  The number of self-reported honors level semester courses in the A-F Subject Areas taken in the 10th & 11th grade.
Comment: 
Code Interpretation: 

Warehouse Name - Courses_Honors_11th_Grade
Element Name:  Honors Courses-11th Grade
Programming Name:  ACADHON11
Master Format F2
Unique Values:  <50
Source: ETS
Define Code: 
Description:  The number of self-reported honors level semester courses in the A-F Subject Areas taken in the 11th grade.
Comment: 
Code Interpretation: 

Warehouse Name - Courses_Honors_12th_Grade
Element Name:  Honors Courses-12th Grade
Programming Name:  ACADHON12
Master Format F2
Unique Values:  <50
Source: ETS
Define Code: 
Description:  The number of self-reported honors level semester courses in the A-F Subject Areas in progress or planned in the 12th grade.
Comment: 
Code Interpretation: 

Warehouse Name - Acad_Prof_Status_3WK
Element Name:  Academic Professional Status 3WK
Programming Name:  ACADPROF3
Master Format A1
Unique Values:  4
Source: MF define
Define Code: 
Description:  Code indicating whether the graduate student is enrolled in an academic or professional program at census. Computed from all CCM data present in the enrollment record. See Code Table for academic/professional characteristics of each CCM.
Comment:  Not applicable to undergraduate students
Code Interpretation: A=Academic
P=Professional
B=both
U=Unknown
blank=non-applicable(undergraduate student)

Warehouse Name - Doctorate_Acad_Prof_Status
Element Name:  Doctorate Academic/Professional Status
Programming Name:  ACADPROFD
Master Format A1
Unique Values:  4
Source: CSX Web application
Define Code: 
Description:  Code indicating the academic or professional status of program/major at the doctorate level
Comment: 
Code Interpretation: A = Academic
P = Professional
U = Unknown
blank = Undergraduate major

Warehouse Name - Acad_Prof_Status_EOT
Element Name:  Academic Professional Status EOT
Programming Name:  ACADPROFE
Master Format A1
Unique Values:  4
Source: MF define
Define Code: 
Description:  Code indicating whether the graduate student is enrolled in an academic or professional program at end of term. Computed from all CCM data present in the enrollment record. See Code Table for academic/professional characteristics of each CCM.
Comment:  Not applicable to undergraduate students
Code Interpretation: A=Academic
P=Professional
B=both
U=Unknown
blank=non-applicable(undergraduate student)

Warehouse Name - Master_Acad_Prof_Status
Element Name:  Master Academic/Professional Status
Programming Name:  ACADPROFM
Master Format A1
Unique Values:  4
Source: CSX Web application
Define Code: 
Description:  Code indicating the academic or professional status of program/major at the master level
Comment: 
Code Interpretation: A = Academic
P = Professional
U = Unknown
blank = Undergraduate major

Warehouse Name - Academic_Unit_Name
Element Name:  Academic Unit Name
Programming Name:  ACADUNIT
Master Format A30
Unique Values: 
Source: Campus Input
Define Code: 
Description:  The name of the academic department or Organized Research Unit (ORU) in which a postdoctoral scholar is pursuing a program of research and training.
Comment: 
Code Interpretation: 

Warehouse Name - Year_Registered_AY
Element Name:  Year Registered
Programming Name:  ACADYEAR
Master Format A2
Unique Values:  1
Source: Define_MF
Define Code: 
Description:  The academic year during which the student is registered for classes. 2 digits on mainframe. 4 digits in data warehouse. Note that input files contains calendar year, NOT academic year.
Comment: 
Code Interpretation: 

Warehouse Name - Account
Element Name:  Account Number
Programming Name:  ACCOUNT
Master Format A6
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Number identifying the account from which a student's financial aid award is paid.
Comment: 
Code Interpretation: Refer to Accounting Manual Chapter A-115-2.

Warehouse Name - SATII_Writing_Score_Best
Element Name:  SATII Writing Exam Score-Best
Programming Name:  ACHSCRENG
Master Format I3
Unique Values:  ~60
Source: Campus Input
Define Code: 
Description:  Best score received on the College Entrance Examination Board SAT II achievement test in English composition.
Comment: 
Code Interpretation: 

Warehouse Name - SATII_Writing_Score_Best_Campus
Element Name:  SATII Writing Exam Score Best - Campus
Programming Name:  ACHSCRENGC
Master Format I3
Unique Values:  ~60
Source: Campus Input
Define Code: 
Description:  Best score received on the College Entrance Examination Board SAT II achievement test in English composition.
Comment: 
Code Interpretation: 

Warehouse Name - SATII_3rd_Score_Best
Element Name:  SATII Third Exam Score-Best
Programming Name:  ACHSCRLSS
Master Format I3
Unique Values:  ~60
Source: Campus Input
Define Code: 
Description:  Best score received on the College Entrance Examination Board SAT II achievement test in foreign language, social science, science or literature.
Comment: 
Code Interpretation: 

Warehouse Name - SATII_3rd_Score_Best_Campus
Element Name:  SATII Third Exam Score Best - Campus
Programming Name:  ACHSCRLSSC
Master Format I3
Unique Values:  ~60
Source: Campus Input
Define Code: 
Description:  Best score received on the College Entrance Examination Board SAT II achievement test in foreign language, social science, science or literature.
Comment: 
Code Interpretation: 

Warehouse Name - SATII_Math_Score_Best
Element Name:  SATII Math Exam Score-Best
Programming Name:  ACHSCRMTH
Master Format I3
Unique Values:  ~60
Source: Campus Input
Define Code: 
Description:  Best score received on the College Entrance Examination Board SAT II achievement test in mathematics.
Comment: 
Code Interpretation: 

Warehouse Name - SATII_Math1_Score_Best
Element Name:  SATII Math1 Score-Best
Programming Name:  ACHSCRMTH1
Master Format F3
Unique Values:  61
Source: Define-DWH
Define Code:  IF CACHSBJMTH EQ 'Q' THEN ACHSCRMTH;
Description:  Best SATII Math1 score.
Comment: 
Code Interpretation: 

Warehouse Name - SATII_Math2_Score_Best
Element Name:  SATII Math2 Score-Best
Programming Name:  ACHSCRMTH2
Master Format F3
Unique Values:  61
Source: Define-DWH
Define Code:  IF CACHSBJMTH EQ 'R' THEN ACHSCRMTH;
Description:  Best SATII Math2 score.
Comment: 
Code Interpretation: 

Warehouse Name - SATII_Math_Score_Best_Campus
Element Name:  SATII Math Exam Score Best - Campus
Programming Name:  ACHSCRMTHC
Master Format I3
Unique Values:  ~60
Source: Campus Input
Define Code: 
Description:  Best score received on the College Entrance Examination Board SAT II achievement test in mathematics.
Comment: 
Code Interpretation: 

Warehouse Name - ACT_Composite_Score_Best
Element Name:  ACT Composite Score-Best
Programming Name:  ACTSCRCMP
Master Format I2
Unique Values:  37
Source: Define MF
Define Code: 
Description:  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) ..
Comment: 
Code Interpretation: 

Warehouse Name - ACT_Composite_Score_Best_Campus
Element Name:  ACT Composite Score Best - Campus
Programming Name:  ACTSCRCMPC
Master Format I2
Unique Values:  37
Source: Define MF
Define Code: 
Description:  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) .
Comment: 
Code Interpretation: 

Warehouse Name - ACT_CompWrit_Score_Best
Element Name:  ACT Composite Score with Writing - Best
Programming Name:  ACTSCRCWW
Master Format F2
Unique Values:  ~37
Source: Define MF
Define Code: 
Description:  ACT Composite score calculated from rollup of ACT scores submitted by campuses.
Comment:  IF ACTSCRMTH GT 0 AND ACTSCRREA GT 0 AND ACTSCRSCI GT 0 AND ACTSCRENW GT 0 THEN (ACTSCRMTH + ACTSCRSOC + ACTSCRNAT + ACTSCRENW) / 4 ; (rounded )
Code Interpretation: 

Warehouse Name - ACT_CompWrit_Score_Best_Campus
Element Name:  ACT Composite Score with Writing - Best Campus
Programming Name:  ACTSCRCWWC
Master Format F2
Unique Values:  ~37
Source: Define MF
Define Code: 
Description:  ACT composite score calculated from ACT scores submitted by campuses.
Comment:  IF ACTSCRMTHC GT 0 AND ACTSCRREAC GT 0 AND ACTSCRSCIC GT 0 AND ACTSCRENWC GT 0 THEN (ACTSCRMTHC + ACTSCRSOCC + ACTSCRNATC + ACTSCRENWC) / 4 ; (rounded )
Code Interpretation: 

Warehouse Name - ACT_English_Score_Best
Element Name:  ACT English Score-Best
Programming Name:  ACTSCRENG
Master Format I2
Unique Values:  37
Source: Campus Input
Define Code: 
Description:  Score received in the American College Testing Program's English aptitude test in the sitting at which the best composite score was received.
Comment: 
Code Interpretation: 

Warehouse Name - ACT_English_Score_Best_Campus
Element Name:  ACT English Score Best - Campus
Programming Name:  ACTSCRENGC
Master Format I2
Unique Values:  37
Source: Campus Input
Define Code: 
Description:  Score received in the American College Testing Program's English aptitude test in the sitting at which the best composite score was received.
Comment: 
Code Interpretation: 

Warehouse Name - ACT_EngWrit_Score_Best
Element Name:  ACT EngWrit Score Best
Programming Name:  ACTSCRENW
Master Format F2
Unique Values: 
Source: Campus Input
Define Code: 
Description:  ACT score for combined English/writing. Rollup from campus provided information
Comment:  renamed from ACT_WRIT_HT
Code Interpretation: 

Warehouse Name - ACT_EngWrit_Score_Best_Campus
Element Name:  ACT EngWrit Score Best Campus
Programming Name:  ACTSCRENWC
Master Format F2
Unique Values: 
Source: Campus input
Define Code: 
Description:  ACT score for combined English/writing. Campus provided information
Comment:  renamed from ACT_WRIT_HT
Code Interpretation: 

Warehouse Name - ACT_Math_Score_Best
Element Name:  ACT Math Score-Best
Programming Name:  ACTSCRMTH
Master Format I2
Unique Values:  37
Source: Campus Input
Define Code: 
Description:  Score received in the American College Testing Program's mathematical aptitude test in the sitting at which the best composite score was received.
Comment: 
Code Interpretation: 

Warehouse Name - ACT_Math_Score_Best_Campus
Element Name:  ACT Math Score Best - Campus
Programming Name:  ACTSCRMTHC
Master Format I2
Unique Values:  37
Source: Campus Input
Define Code: 
Description:  Score received in the American College Testing Program's mathematical aptitude test in the sitting at which the best composite score was received.
Comment: 
Code Interpretation: 

Warehouse Name - ACT_NatSci_Score_Best
Element Name:  ACT Natural Science Score-Best
Programming Name:  ACTSCRNAT
Master Format I2
Unique Values:  37
Source: Campus Input
Define Code: 
Description:  Score received on the American College Testing Program's natural sciences aptitude test in the sitting at which the best composite score was received.
Comment: 
Code Interpretation: 

Warehouse Name - ACT_NatSci_Score_Best_Campus
Element Name:  ACT Natural Science Score Best - Campus
Programming Name:  ACTSCRNATC
Master Format I2
Unique Values:  37
Source: Campus Input
Define Code: 
Description:  Score received on the American College Testing Program's natural sciences aptitude test in the sitting at which the best composite score was received.
Comment: 
Code Interpretation: 

Warehouse Name - ACT_Reading_Score_Best
Element Name:  ACT Reading Score-Best
Programming Name:  ACTSCRREA
Master Format F2
Unique Values:  ~37
Source: Define MF
Define Code: 
Description:  ACT Reading subscore. Rollup from campus reported information.
Comment: 
Code Interpretation: 

Warehouse Name - ACT_Reading_Score_Best_Campus
Element Name:  ACT Reading Score-Best Campus
Programming Name:  ACTSCRREAC
Master Format F2
Unique Values:  ~37
Source: Campus Input
Define Code: 
Description:  ACT Reading subscore. Campus reported information.
Comment: 
Code Interpretation: 

Warehouse Name - ACT_Science_Score_Best
Element Name:  ACT Science Score-Best
Programming Name:  ACTSCRSCI
Master Format F2
Unique Values:  ~37
Source: Define MF
Define Code: 
Description:  ACT Science subscore. Rollup from campus provided information
Comment: 
Code Interpretation: 

Warehouse Name - ACT_Science_Score_Best_Campus
Element Name:  ACT Science Score-Best Campus
Programming Name:  ACTSCRSCIC
Master Format F2
Unique Values:  ~37
Source: Campus Input
Define Code: 
Description:  ACT Science subscore. Campus provided information
Comment: 
Code Interpretation: 

Warehouse Name - ACT_SocStud_Score_Best
Element Name:  ACT Social Studies Score-Best
Programming Name:  ACTSCRSOC
Master Format I2
Unique Values:  37
Source: Campus Input
Define Code: 
Description:  Score received on the American College Testing Program's social studies aptitude test in the sitting at which the best composite score was received.
Comment: 
Code Interpretation: 

Warehouse Name - ACT_SocStud_Score_Best_Campus
Element Name:  ACT Social Studies Score Best - Campus
Programming Name:  ACTSCRSOCC
Master Format I2
Unique Values:  37
Source: Campus Input
Define Code: 
Description:  Score received on the American College Testing Program's social studies aptitude test in the sitting at which the best composite score was received.
Comment: 
Code Interpretation: 

Warehouse Name - First_Year_Offered
Element Name:  First Year Offered
Programming Name:  ACTYEAR
Master Format A4
Unique Values:  >100
Source: CSX Web application
Define Code: 
Description:  First academic Year a program/major was offered at campus. ex: 2005 = program was first offered in academic year 2005-2006.
Comment: 
Code Interpretation: 

Warehouse Name - ACT_English_Score_Highest
Element Name:  ACT English Score Highest
Programming Name:  ACT_ENG_HT
Master Format F2
Unique Values:  37
Source: Campus Input
Define Code: 
Description:  Highest ACT English Score reported and used by the campus for determining admissions.
Comment: 
Code Interpretation: 

Warehouse Name - ACT_Math_Score_Highest
Element Name:  ACT Math Score Highest
Programming Name:  ACT_MATH_HT
Master Format F2
Unique Values:  37
Source: Campus Input
Define Code: 
Description:  Highest ACT Math Score reported and used by the campus for determining admissions.
Comment: 
Code Interpretation: 

Warehouse Name - ACT_Reading_Score_Highest
Element Name:  ACT Reading Score Highest
Programming Name:  ACT_READ_HT
Master Format F2
Unique Values:  37
Source: Campus Input
Define Code: 
Description:  highest ACT Reading Score reported and used by the campus for determining admissions.
Comment: 
Code Interpretation: 

Warehouse Name - ACT_Science_Score_Highest
Element Name:  ACT Science Score Highest
Programming Name:  ACT_SCI_HT
Master Format F2
Unique Values:  37
Source: Campus Input
Define Code: 
Description:  highest ACT Science Score reported and used by the campus for determining admissions.
Comment: 
Code Interpretation: 

Warehouse Name - ACT_EngWrit_Score_Highest
Element Name:  ACT English Writing Score Highest
Programming Name:  ACT_WRIT_HT
Master Format F2
Unique Values:  37
Source: Campus Input
Define Code: 
Description:  Highest ACT Writing Score reported and used by the campus for determining admissions.
Comment: 
Code Interpretation: 

Warehouse Name - Admit_BK
Element Name:  Admit-Berkeley
Programming Name:  ADMITBK
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  ADMREGBK + ADMSPCBK;
Description:  Flag indicating student was admitted to the Berkeley campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Count
Element Name:  Admit Count
Programming Name:  ADMITCT
Master Format I1
Unique Values:  10
Source: Define-DWH
Define Code:  ADMREGCT + ADMSPCCT;
Description:  Count of campuses to which the student was admitted.
Comment: 
Code Interpretation: 

Warehouse Name - Admit_DV
Element Name:  Admit-Davis
Programming Name:  ADMITDV
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  ADMREGDV + ADMSPCDV;
Description:  Flag indicating student was admitted to the Davis campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_IR
Element Name:  Admit-Irvine
Programming Name:  ADMITIR
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  ADMREGIR + ADMSPCIR;
Description:  Flag indicating student was admitted to the Irvine campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_LA
Element Name:  Admit-Los Angeles
Programming Name:  ADMITLA
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  ADMREGLA + ADMSPCLA;
Description:  Flag indicating student was admitted to the Los Angeles campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_MR
Element Name:  Admit-Merced
Programming Name:  ADMITMR
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  ADMREGMR + ADMSPCMR;
Description:  Flag indicating student was admitted to the Merced campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_RV
Element Name:  Admit-Riverside
Programming Name:  ADMITRV
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  ADMREGRV + ADMSPCRV;
Description:  Flag indicating student was admitted to the Riverside campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_SB
Element Name:  Admit-Santa Barbara
Programming Name:  ADMITSB
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  ADMREGSB + ADMSPCSB;
Description:  Flag indicating student was admitted to the Santa Barbara campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_SC
Element Name:  Admit-Santa Cruz
Programming Name:  ADMITSC
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  ADMREGSC + ADMSPCSC;
Description:  Flag indicating student was admitted to the Santa Cruz campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_SD
Element Name:  Admit-San Diego
Programming Name:  ADMITSD
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  ADMREGSD + ADMSPCSD;
Description:  Flag indicating student was admitted to the San Diego campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Regular_BK
Element Name:  Admit Regular-Berkeley
Programming Name:  ADMREGBK
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '01' AND (CELIGADM EQ '02' OR '03') THEN 1 ELSE 0;
Description:  Flag indicating student was a regular admit at the Berkeley campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Regular_Count
Element Name:  Admit Regular Count
Programming Name:  ADMREGCT
Master Format I1
Unique Values:  10
Source: Define-DWH
Define Code:  ADMREGBK + ADMREGDV + ADMREGIR + ADMREGLA + ADMREGRV + ADMREGSB + ADMREGSC + ADMREGSD + ADMREGMR ;
Description:  Count of campuses to which the student was reguarly admitted.
Comment: 
Code Interpretation: 

Warehouse Name - Admit_Regular_DV
Element Name:  Admit Regular-Davis
Programming Name:  ADMREGDV
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '03' AND (CELIGADM EQ '02' OR '03') THEN 1 ELSE 0;
Description:  Flag indicating student was a regular admit at the Davis campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Regular_IR
Element Name:  Admit Regular-Irvine
Programming Name:  ADMREGIR
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '09' AND (CELIGADM EQ '02' OR '03') THEN 1 ELSE 0;
Description:  Flag indicating student was a regular admit at the Irvine campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Regular_LA
Element Name:  Admit Regular-Los Angeles
Programming Name:  ADMREGLA
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '04' AND (CELIGADM EQ '02' OR '03') THEN 1 ELSE 0;
Description:  Flag indicating student was a regular admit at the Los Angeles campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Regular_MR
Element Name:  Admit Regular-Merced
Programming Name:  ADMREGMR
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  0;
Description:  Flag indicating student was a regular admit at the Merced campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Regular_RV
Element Name:  Admit Regular-Riverside
Programming Name:  ADMREGRV
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '05' AND (CELIGADM EQ '02' OR '03') THEN 1 ELSE 0;
Description:  Flag indicating student was a regular admit at the Riverside campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Regular_SB
Element Name:  Admit Regular-Santa Barbara
Programming Name:  ADMREGSB
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '08' AND (CELIGADM EQ '02' OR '03') THEN 1 ELSE 0;
Description:  Flag indicating student was a regular admit at the Santa Barbara campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Regular_SC
Element Name:  Admit Regular-Santa Cruz
Programming Name:  ADMREGSC
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '07' AND (CELIGADM EQ '02' OR '03') THEN 1 ELSE 0;
Description:  Flag indicating student was a regular admit at the Santa Cruz campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Regular_SD
Element Name:  Admit Regular-San Diego
Programming Name:  ADMREGSD
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '06' AND (CELIGADM EQ '02' OR '03') THEN 1 ELSE 0;
Description:  Flag indicating student was a regular admit at the San Diego campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Selective_Flag
Element Name:  Admit Selective Flag
Programming Name:  ADMSELECT
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  ADMITBK + ADMITLA + ADMITSD;
Description:  Flag indicating the student was admitted to a selective campus (BK, LA, SD).
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Special_BK
Element Name:  Admit Special-Berkeley
Programming Name:  ADMSPCBK
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '01' AND CELIGADM GE '04' AND CELIGADM LE '18' THEN 1 ELSE 0;
Description:  Flag indicating student was a special admit at the Berkeley campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Special_Count
Element Name:  Admit Special Count
Programming Name:  ADMSPCCT
Master Format I1
Unique Values:  10
Source: Define-DWH
Define Code:  ADMSPCBK + ADMSPCDV + ADMSPCIR + ADMSPCLA + ADMSPCRV + ADMSPCSB + ADMSPCSC + ADMSPCSD + ADMSPCMR ;
Description:  Count of campuses to which the student was specially admitted.
Comment: 
Code Interpretation: 

Warehouse Name - Admit_Special_DV
Element Name:  Admit Special-Davis
Programming Name:  ADMSPCDV
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '03' AND CELIGADM GE '04' AND CELIGADM LE '18' THEN 1 ELSE 0;
Description:  Flag indicating student was a special admit at the Davis campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Special_IR
Element Name:  Admit Special-Irvine
Programming Name:  ADMSPCIR
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '09' AND CELIGADM GE '04' AND CELIGADM LE '18' THEN 1 ELSE 0;
Description:  Flag indicating student was a special admit at the Irvine campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Special_LA
Element Name:  Admit Special-Los Angeles
Programming Name:  ADMSPCLA
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '04' AND CELIGADM GE '04' AND CELIGADM LE '18' THEN 1 ELSE 0;
Description:  Flag indicating student was a special admit at the Los Angeles campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Special_MR
Element Name:  Admit Special-Merced
Programming Name:  ADMSPCMR
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  0;
Description:  Flag indicating student was a special admit at the Merced campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Special_RV
Element Name:  Admit Special-Riverside
Programming Name:  ADMSPCRV
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '05' AND CELIGADM GE '04' AND CELIGADM LE '18' THEN 1 ELSE 0;
Description:  Flag indicating student was a special admit at the Riverside campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Special_SB
Element Name:  Admit Special-Santa Barbara
Programming Name:  ADMSPCSB
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '08' AND CELIGADM GE '04' AND CELIGADM LE '18' THEN 1 ELSE 0;
Description:  Flag indicating student was a special admit at the Santa Barbara campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Special_SC
Element Name:  Admit Special-Santa Cruz
Programming Name:  ADMSPCSC
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '07' AND CELIGADM GE '04' AND CELIGADM LE '18' THEN 1 ELSE 0;
Description:  Flag indicating student was a special admit at the Santa Cruz campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Admit_Special_SD
Element Name:  Admit Special-San Diego
Programming Name:  ADMSPCSD
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '06' AND CELIGADM GE '04' AND CELIGADM LE '18' THEN 1 ELSE 0;
Description:  Flag indicating student was a special admit at the San Diego campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Date_Adv_to_Candidacy
Element Name:  Date Advanced To Candidacy
Programming Name:  ADVDT
Master Format A3
Unique Values: 
Source: Define-MF
Define Code: 
Description:  Date on which student was advanced to candidacy.
Comment: 
Code Interpretation: YY is Year and Q is term
1 = Summer
2 Fall
3 Winter
4 Spring

Warehouse Name - HS_Grade_Points_AtoF
Element Name:  High School Grade Points Used-Subjects A-F
Programming Name:  AFGP
Master Format F4.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  Grade points earned for high school units in the A-F pattern used to determine eligibility for admission.
Comment: 
Code Interpretation: 

Warehouse Name - HS_Units_AtoF
Element Name:  High School Units Used-Subjects A-F
Programming Name:  AFUNITS
Master Format F4.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  The total number of high school units in the A-F pattern used to determine eligibility for admission.
Comment: 
Code Interpretation: 

Warehouse Name - Term_First_Enrolled
Element Name:  Term First Enrolled
Programming Name:  AFYQ
Master Format A3
Unique Values:  ~30
Source: Define-MF
Define Code: 
Description:  The year and quarter in which undergraduate student was admitted.
Comment: 
Code Interpretation: YY is Year and Q is term
1 = Summer
2 Fall
3 Winter
4 Spring

Warehouse Name - Age_on_October 15
Element Name:  Age on October 15
Programming Name:  AGECEN
Master Format 
Unique Values:  99
Source: Define-DWH
Define Code: 
Description:  Age of student on October 15 of the academic year.
Comment: 
Code Interpretation: 

Warehouse Name - Financial_Aid_Received_Indicator
Element Name:  Aid Type Indicator
Programming Name:  AIDTYPE
Master Format A1
Unique Values:  2
Source: Define-MF
Define Code: 
Description:  Code indicating that financial aid recipient has received aid other than non-work study earnings.
Comment: 
Code Interpretation: Y = Yes
N = No

Warehouse Name - Amount_Paid_or_Method
Element Name:  Amount Paid or Method Paid
Programming Name:  AMTCHK
Master Format A1
Unique Values:  3
Source: ETS
Define Code: 
Description:  The code identifying the dollar amount received with an application, or the payment method used for the application.
Comment:  Added to UADM Database from ETS input effective for Fall 1998 applicants.
Code Interpretation: 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

Warehouse Name - Award_Type_Amount_Earnings
Element Name:  Award Type Amount-Earnings
Programming Name:  AMTEARN
Master Format I6
Unique Values:  number
Source: Define-DWH
Define Code:  IF CAWDGRP EQ '22' OR '23' OR '41' OR '42' THEN AWDGRPAMT ELSE 0;
Description:  Total amount of student earnings during the academic year.
Comment: 
Code Interpretation: 

Warehouse Name - Award_Type_Amount_Grants
Element Name:  Award Type Amount-Grants
Programming Name:  AMTGRNT
Master Format I6
Unique Values:  number
Source: Define-DWH
Define Code:  IF CAWDGRP EQ '06' OR '08' OR '09' OR '10' OR '12' OR '13' OR '21' OR '24' OR '27' OR '28' OR '31' OR '32' OR '33' OR '43' OR '81' OR '82' OR '83' OR
Description:  Total amount of grants awarded to the student during the academic year.
Comment: 
Code Interpretation: 

Warehouse Name - Award_Type_Amount_Loans
Element Name:  Award Type Amount-Loans
Programming Name:  AMTLOAN
Master Format I6
Unique Values:  number
Source: Define-DWH
Define Code:  IF CAWDGRP EQ '14' OR '15' OR '16' OR '17' OR '29' OR '39' OR '40' OR '44' OR '45' OR '46' OR '47' OR '48' OR '49' OR '60' OR '61' OR '62' OR '63' OR
Description:  Total amount of loans awarded to the student during the academic year.
Comment: 
Code Interpretation: 

Warehouse Name - Award_Type_Amount_Other
Element Name:  Award Type Amount-Other
Programming Name:  AMTOTH
Master Format I6
Unique Values:  number
Source: Define-DWH
Define Code:  IF CAWDGRP EQ '69' OR '70' OR '71' OR '72' OR '73' OR '74' OR '75' OR '76' OR '77' OR '78' OR '79' OR '80' OR '93' OR '94' THEN AWDGRPAMT ELSE 0;
Description:  Total amount of other aid awarded to the student during the academic year.
Comment: 
Code Interpretation: 

Warehouse Name - Award_Type_Amount_RATA_Remission
Element Name:  Award Type Amount-RATA Remission
Programming Name:  AMTRATA
Master Format I6
Unique Values:  number
Source: Define-DWH
Define Code:  IF CAWDGRP EQ '35' OR '36' OR '37' OR '38' THEN AWDGRPAMT ELSE 0;
Description:  Total amount of RA/TA remission awarded to the student during the academic year.
Comment: 
Code Interpretation: 

Warehouse Name - Award_Type_Amount_SFT
Element Name:  Award Type Amount-SFT
Programming Name:  AMTSFT
Master Format I6
Unique Values:  number
Source: Define-DWH
Define Code:  IF CAWDGRP EQ '01' OR '02' OR '03' OR '04' OR '05' OR '07' OR '11' OR '20' OR '25' OR '26' OR '50' OR '51' OR '52' OR '53' OR '54' OR '55' OR '56' OR
Description:  Total amount of scholarships, fellowships and traineeships awarded to the student during the academic year.
Comment: 
Code Interpretation: 

Warehouse Name - Award_Type_Amount_Work_Study
Element Name:  Award Type Amount-Work Study
Programming Name:  AMTWKST
Master Format I6
Unique Values:  number
Source: Define-DWH
Define Code:  IF CAWDGRP EQ '18' OR '19' OR '34' THEN AWDGRPAMT ELSE 0;
Description:  Total amount of scholarships, fellowships and traineeships awarded to the student during the academic year.
Comment: 
Code Interpretation: 

Warehouse Name - AP_Language_Score
Element Name:  AP English Language Exam Score
Programming Name:  APENGLANG
Master Format A1
Unique Values:  6
Source: ETS
Define Code: 
Description:  The score on the Advanced Placement English Language Examination.
Comment: 
Code Interpretation: 

Warehouse Name - AP_Literature_Score
Element Name:  AP English Literature Exam Score
Programming Name:  APENGLIT
Master Format A1
Unique Values:  6
Source: ETS
Define Code: 
Description:  The score on the Advanced Placement English Literature Examination.
Comment: 
Code Interpretation: 

Warehouse Name - App_Count
Element Name:  Application Count
Programming Name:  APPCOUNT
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF ((CAPPRCVD NE ' ') OR (CMAJPRP NE ' ')) THEN 1 ELSE 0;
Description:  Count of campuses to which the student applied.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - App_Original_Count
Element Name:  App Original Count
Programming Name:  APPCOUNTOR
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF (CAPPRCVD EQ '1') THEN 1 ELSE 0;
Description:  Count of campuses to which the student originally applied.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Applicant_Alert
Element Name:  Applicant Alert
Programming Name:  APPL_ALERT
Master Format A5
Unique Values:  9
Source: ETS
Define Code: 
Description:  Flag indicating a problem with the Application. Contains up to 5 permanent codes.
Comment: 
Code Interpretation: "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"

Warehouse Name - App_Selective_Flag
Element Name:  App Selective Flag
Programming Name:  APPSELECT
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF (CCAMPUSAPBK EQ 1) OR (CCAMPUSAPLA EQ 1) OR (CCAMPUSAPSD EQ 1) THEN 1 ELSE 0;
Description:  Flag indicating student applied to a selective campus (BK, LA or SD).
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Applicant_Transfer_Level
Element Name:  Applicant_Transfer_Level
Programming Name:  APPTRLVL
Master Format A2
Unique Values: 
Source: Define-DWH
Define Code:  IF CADMCAT EQ '3' OR '4' THEN 'LD' ELSE IF CADMCAT EQ '5' OR '6' THEN 'UD' ELSE ' ';
Description:  Advanced standing applicant level for transfer students.
Comment: 
Code Interpretation: 

Warehouse Name - Application_Fee_Type
Element Name:  Application_Fee_Type
Programming Name:  APP_FEE_TYPE
Master Format A1
Unique Values:  2
Source: ETS
Define Code: 
Description:  Application Fee Type
Comment: 
Code Interpretation:  D=Domestic Fee
F=International Fee

Warehouse Name - Units_Attempted_CURR_3WK
Element Name:  Units Attempted-Current Term-3rd Week
Programming Name:  ATTC3
Master Format F4.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  The sum of the units for letter graded courses and pass/not pass courses attempted in the specified term, as of the end of the third week of classes.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Attempted_CURR_Grded_EOT
Element Name:  Units Attempted-Current Term-Graded-End of Term
Programming Name:  ATTCGE
Master Format F4.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  The sum of the units for letter graded courses attempted in the specified term as of the end of the term.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Attempted_Summer_Grded_EOT
Element Name:  Units Attempted-Summer-Graded-End of Term
Programming Name:  ATTCGSU
Master Format F5.1
Unique Values:  number
Source: Define MF
Define Code: 
Description:  The sum of the units for letter graded courses attempted in the specified summer as of the end of the term.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Attempted_CURR_Non_Degree
Element Name:  Units Attempted-Current Term - Non-Degree
Programming Name:  ATTCN
Master Format F4.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  The sum of the non-degree applicable units attempted in the specified term.
Comment:  Not Provided by Merced in 2007-2008. See REG Problem Log .
Code Interpretation: 

Warehouse Name - Units_Attempted_CURR_PNP_EOT
Element Name:  Units Attempted-Current Term-P/NP-End of Term
Programming Name:  ATTCPE
Master Format F4.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  The sum of the units for pass/not pass and satisfactory/unsatisfactory courses which were attempted in the specified term, as of the end of the term.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Attempted_Summer_PNP_EOT
Element Name:  Units Attempted-Summer-P/NP-End of Term
Programming Name:  ATTCPSU
Master Format F5.1
Unique Values:  number
Source: Define MF
Define Code: 
Description:  The sum of the units for pass/not pass and satisfactory/unsatisfactory courses which were attempted in the specified summer, as of the end of the term.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Attempted_CURR_Ttl_EOT
Element Name:  Units Attempted–Current Term–Total to Date-End of Term
Programming Name:  ATTCTE
Master Format 
Unique Values:  number
Source: Define-DWH
Define Code: 
Description:  Total units attempted during the current term as of end of term. Sum of ATTCGE and ATTCPE.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Attempted_YTD_PNP_UC_EOT
Element Name:  Units Attempted-Year to Date-P/NP- UC-End of Term
Programming Name:  ATTCUE
Master Format F5.1
Unique Values:  number
Source: Define-MF
Define Code: 
Description:  The sum of the units for pass/not pass and satisfactory/unsatisfactory courses attempted in the academic year.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Attempted_First_Term
Element Name:  Units Attempted-First Term Enrolled
Programming Name:  ATTEMPT
Master Format F4.1
Unique Values:  number
Source: Define-MF
Define Code: 
Description:  The sum of Units Attempted - Graded - End of Term and Units Attempted - P/NP - End of Term for the 1st quarter financial aid recipient was registered. If Units Attempted - Graded - End of Term plus Units Attempted - P/NP - End of Term is zero, then Units Attempted-Current Term-3rd Week (ATTC3).
Comment: 
Code Interpretation: 

Warehouse Name - Units_Attempted_TTD_Grded_UC_3WK
Element Name:  Units Attempted-Total to Date-Graded-UC-3rd Week
Programming Name:  ATTTGU3
Master Format F5.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  The sum of the units attempted to date at UC in letter-graded courses, as of the end of the previous term.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Attempted_TTD_Grded_UC_EOT
Element Name:  Units Attempted-Total to Date-Graded-UC-End of Term
Programming Name:  ATTTGUE
Master Format F5.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  The sum of the units attempted to date in letter-graded courses, as of the end of the last term enrolled in the academic year.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Attempted_YTD_Grded_UC_EOT
Element Name:  Units Attempted-Year to Date-Graded-UC-End of Term
Programming Name:  ATTTGUYTD
Master Format F4.1
Unique Values:  number
Source: Define-MF
Define Code: 
Description:  The sum of the units in letter graded courses attempted in the academic year.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Attempted_TTD_PNP_UC_EOT
Element Name:  Units Attempted-Total to Date- P/NP- UC-End of Term
Programming Name:  ATTTPUE
Master Format F5.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  The sum of the units for pass/not pass and satisfactory/unsatisfactory courses attempted at the current campus to date, as of the end of the specified term.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Attempted_TTD_Ttl_EOT
Element Name:  Units Attempted–Total to Date–Total-End of Term
Programming Name:  ATTTUE
Master Format 
Unique Values:  number
Source: Define-DWH
Define Code: 
Description:  Total-to-date units attempted as of end of term. Sum of ATTTGUE and ATTTPUE.
Comment: 
Code Interpretation: 

Warehouse Name - Award_Amount
Element Name:  Award Amount
Programming Name:  AWARDAMT
Master Format D8.2
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  The total amount of a student's financial aid award as identified by a particular account, fund, sub-account, and award code.
Comment: 
Code Interpretation: 

Warehouse Name - Award_Apportionment_Code
Element Name:  Award Apportionment Code
Programming Name:  AWDAPP
Master Format A1
Unique Values:  7
Source: Campus Input
Define Code: 
Description:  Code indicating the part of the student budget that is offset by the financial support award. The Financial Aid Office is not tracking this data, so will use the 'U' code on all awards.
Comment:  Established May 2000. Discontinued beginning academic year 2001.
Code Interpretation: E = Exemptions
F = Fees
G = GSHIP Waivers
S = Stipend/General Living
T = Tuition
W = Waiver
U = Unrestricted

Warehouse Name - Award_Type_Indicator_Earnings
Element Name:  Award Type Indicator-Earnings
Programming Name:  AWDEARN
Master Format A1
Unique Values:  2
Source: Define-DWH
Define Code:  IF AMTEARN GT 0 THEN '1' ELSE '0';
Description:  Flag indicating student earnings during the academic year.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Award_Period_Fall
Element Name:  Award Period-Fall
Programming Name:  AWDFALL
Master Format A1
Unique Values:  2
Source: Campus Input
Define Code: 
Description:  Code indicating that the financial aid award covers the Fall quarter.
Comment:  Discontinued beginning academic year 2001.
Code Interpretation: Y = Yes
blank = No

Warehouse Name - Award_Type_Indicator_Grants
Element Name:  Award Type Indicator-Grants
Programming Name:  AWDGRNT
Master Format A1
Unique Values:  2
Source: Define-DWH
Define Code:  IF AMTGRNT GT 0 THEN '1' ELSE '0';
Description:  Flag indicating grants awarded to the student during the academic year.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Award_Group_Amount
Element Name:  Award Group Amount
Programming Name:  AWDGRPAMT
Master Format I5
Unique Values:  number
Source: Define-MF
Define Code: 
Description:  The amount of financial aid paid to the student year-to-date from the associated award group type.
Comment: 
Code Interpretation: 

Warehouse Name - Award_Type_Indicator_Loans
Element Name:  Award Type Indicator-Loans
Programming Name:  AWDLOAN
Master Format A1
Unique Values:  2
Source: Define-DWH
Define Code:  IF AMTLOAN GT 0 THEN '1' ELSE '0';
Description:  Flag indicating loans awarded to the student during the academic year.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Award_Name
Element Name:  Award Name
Programming Name:  AWDNAME
Master Format A40
Unique Values:  ~300
Source: X-Reference
Define Code: 
Description:  Name of the financial aid award that has been made to a student.
Comment: 
Code Interpretation: 

Warehouse Name - Award_Type_Indicator_Other
Element Name:  Award Type Indicator-Other
Programming Name:  AWDOTH
Master Format A1
Unique Values:  2
Source: Define-DWH
Define Code:  IF AMTOTH GT 0 THEN '1' ELSE '0';
Description:  Flag indicating other aid awarded to the student during the academic year.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Award_Type_Indicator_RATA_Remission
Element Name:  Award Type Indicator-RATA Remission
Programming Name:  AWDRATA
Master Format A1
Unique Values:  2
Source: Define-DWH
Define Code:  IF AMTRATA GT 0 THEN '1' ELSE '0';
Description:  Flag indicating RA/TA remission awarded to the student during the academic year.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Award_Type_Indicator_SFT
Element Name:  Award Type Indicator-SFT
Programming Name:  AWDSFT
Master Format A1
Unique Values:  2
Source: Define-DWH
Define Code:  IF AMTSFT GT 0 THEN '1' ELSE ‘0';
Description:  Flag indicating scholarships, fellowships and traineeships awarded to the student during the academic year.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Award_Period_Spring
Element Name:  Award Period-Spring
Programming Name:  AWDSPR
Master Format A1
Unique Values:  2
Source: Campus Input
Define Code: 
Description:  Code indicating that the financial aid award covers the spring quarter.
Comment:  Discontinued beginning academic year 2001.
Code Interpretation: Y = Yes
blank = No

Warehouse Name - Award_Period_Summer
Element Name:  Award Period-Summer
Programming Name:  AWDSUM
Master Format A1
Unique Values:  2
Source: Campus Input
Define Code: 
Description:  Code indicating that the financial aid award covers the summer quarter.
Comment:  Discontinued beginning academic year 2001.
Code Interpretation: Y = Yes
blank = No

Warehouse Name - Award_Period_Winter
Element Name:  Award Period-Winter
Programming Name:  AWDWIN
Master Format A1
Unique Values:  2
Source: Campus Input
Define Code: 
Description:  Code indicating that the financial aid award covers the winter quarter.
Comment:  Discontinued beginning academic year 2001.
Code Interpretation: Y = Yes
blank = No

Warehouse Name - Award_Type_Indicator_Work_Study
Element Name:  Award Type Indicator-Work Study
Programming Name:  AWDWKST
Master Format A1
Unique Values:  2
Source: Define-DWH
Define Code:  IF AMTWKST GT 0 THEN '1' ELSE '0';
Description:  Flag indicating scholarships, fellowships and traineeships awarded to the student during the academic year.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Birthdate
Element Name:  Date of Birth
Programming Name:  BIRTHDATE
Master Format A6
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  The year, month and day on which the person was born.
Comment:  Converted to YYYY/MM/DD for data warehouse tables.
Code Interpretation: 

Warehouse Name - Blue_And_Gold_Flag
Element Name:  Blue And Gold Flag
Programming Name:  BLUEGOLD
Master Format A1
Unique Values:  3
Source: Define-MF
Define Code: 
Description:  Y = student is eligible for Blue and Gold Opportunity Plan N = student is not eligible for Blue and Gold Opportunity Plan
Comment:  This element is not applicable in the summer period.
Code Interpretation: 

Warehouse Name - Budget_Amount_Computer
Element Name:  Computer Budget Amount
Programming Name:  BUDCOMP
Master Format I6
Unique Values:  it represents the c
Source: Campus Input
Define Code: 
Description:  This amount is a subset of data element R100 - BUDGET; it represents the cost of purchasing a new computer (hardware). Software costs can be included if it was part of the new computer package. Otherwise, the cost of any additional software, peripheral equipment or internet connectivity is to be excluded. (Note: for 1999-2000, if a student already has a computer and is purchasing new peripheral equipment, software or obtaining internet connectivity, the cost is to be treated as an add-on in BUDGET, but not included in BUDGCOMP. Beginning 2000-2001, there will be an allowance for these items within the Books/Supplies/Tech Allowance. Missing budget amounts should be reported as a string of six 'blanks' in the field.
Comment:  New element effective May 1, 2000.
Code Interpretation: 

Warehouse Name - Budget_Flag_Computer
Element Name:  Computer Budget Flag
Programming Name:  BUDCOMPFLG
Master Format A1
Unique Values:  2
Source: Define-MF
Define Code: 
Description:  Flag indicator for Amount Budget-Computer-Financial Aid element to disintguish values that were true zeroes from those which were blank or missing.
Comment: 
Code Interpretation: R = Real Zero
M= Missing

Warehouse Name - Budget_Amount_Student
Element Name:  Student Budget Amount
Programming Name:  BUDGET
Master Format I6
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  The amount budgeted by the Financial Aid Office for a student to cover the period for which student has received financial aid (Fall, Winter, Spring, Summer, or any combination thereof). Missing budget amounts should be reported as a string of six 'blanks' in the field.
Comment: 
Code Interpretation: 

Warehouse Name - Budget_Flag_Student
Element Name:  Student Budget Flag
Programming Name:  BUDGETFLG
Master Format A1
Unique Values:  2
Source: Define-MF
Define Code: 
Description:  Flag indicator for Student Budget element to disintguish values that were true zeroes from those which were blank or missing.
Comment: 
Code Interpretation: R = Real Zero
M= Missing

Warehouse Name - Award_Accept_Code
Element Name:  Award Accept Code
Programming Name:  CACCEPT
Master Format A1
Unique Values:  2
Source: Campus Input
Define Code: 
Description:  Code indicating whether award has been offered or has been accepted or rejected.
Comment: 
Code Interpretation: O = Offered
A = Accepted
R = Rejected

Warehouse Name - SATII_Writing_Code_Best
Element Name:  SATII Writing Exam Code-Best
Programming Name:  CACHSBJENG
Master Format A1
Unique Values:  2
Source: Campus Input
Define Code: 
Description:  Code indicating subject of the College Entrance Examination Board SAT II achievement test in English Composition with the best score.
Comment:  Formerly called Best Achievement Subject Code - English Composition
Code Interpretation: A = English Composition
V = English Composition with essay
W = Writing

Warehouse Name - SATII_Writing_Code_Best_Campus
Element Name:  SATII Writing Exam Code Best - Campus
Programming Name:  CACHSBJENGC
Master Format A1
Unique Values:  2
Source: Campus Input
Define Code: 
Description:  Code indicating subject of the College Entrance Examination Board SAT II achievement test in English Composition with the best score.
Comment:  Formerly called Best Achievement Subject Code - English Composition
Code Interpretation: A = English Composition
V = English Composition with essay
W = Writing

Warehouse Name - SATII_3rd_Code_Best
Element Name:  SATII Third Exam Code-Best
Programming Name:  CACHSBJLSS
Master Format A1
Unique Values:  18
Source: Campus Input
Define Code: 
Description:  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.
Comment:  Codes U and V added effective with the Fall 1998 applicant class. Formerly called Best Achievement Subject Code - Language/Social Science.
Code Interpretation: 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)

Warehouse Name - SATII_3rd_Code_Best_Campus
Element Name:  SATII Third Exam Code Best - Campus
Programming Name:  CACHSBJLSSC
Master Format A1
Unique Values:  18
Source: Campus Input
Define Code: 
Description:  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.
Comment:  Codes U and V added effective with the Fall 1998 applicant class. Formerly called Best Achievement Subject Code - Language/Social Science.
Code Interpretation: 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)

Warehouse Name - SATII_Math_Code_Best
Element Name:  SATII Math Exam Code-Best
Programming Name:  CACHSBJMTH
Master Format A1
Unique Values:  2
Source: Campus Input
Define Code: 
Description:  Code indicating subject (i.e., math level) of the SAT II College Entrance Examination Board Achievement test in math with the best score.
Comment:  Formerly called Best Achievement Subject Code - Mathematics
Code Interpretation: Q = Math Level I
R = Math Level II

Warehouse Name - SATII_Math_Code_Best_Campus
Element Name:  SATII Math Exam Code Best - Campus
Programming Name:  CACHSBJMTHC
Master Format A1
Unique Values:  2
Source: Campus Input
Define Code: 
Description:  Code indicating subject (i.e., math level) of the SAT II College Entrance Examination Board Achievement test in math with the best score.
Comment:  Formerly called Best Achievement Subject Code - Mathematics
Code Interpretation: Q = Math Level I
R = Math Level II

Warehouse Name - Campus_Code
Element Name:  Campus Code
Programming Name:  CACODE
Master Format A2
Unique Values:  10
Source: CSX Web application
Define Code: 
Description:  Code indicating the campus at which the program/major is offered
Comment: 
Code Interpretation: 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

Warehouse Name - Applicant_Level_Code
Element Name:  Applicant Level Code
Programming Name:  CADMCAT
Master Format A1
Unique Values:  7
Source: Define-MF
Define Code: 
Description:  Code indicating the academic status for which the applicant qualifies.
Comment:  define code: CADMCAT = IF IFIN_AP_LEV EQ '0' THEN '0' ELSE IF IFIN_AP_LEV EQ '1' OR '2' THEN '1' ELSE IF IFIN_AP_LEV EQ '3' OR '4' OR '5' THEN '2' ELSE IF IFIN_AP_LEV EQ '7' OR '8' OR '9' THEN IFIN_AP_LEV ELSE DECODE IUND_GR_LEV (1 3, 2 4, 3 5,4 6,ELSE 5)
Code Interpretation: 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)

Warehouse Name - Applicant_Level_Code_3CAT
Element Name:  Applicant Level Code - 3CAT
Programming Name:  CADMCAT2
Master Format A1
Unique Values:  3
Source: DWH-Define
Define Code:  see comment
Description:  Code indicating the academic status for which the applicant qualifies.
Comment:  CADMCAT2/A1 = IF CADMCAT EQ '0' THEN 'D' ELSE IF CADMCAT EQ '1' OR '2' THEN 'F' ELSE IF CADMCAT EQ '3' OR '4' OR '5' OR '6' THEN 'T' ELSE IF CADMCAT EQ '7' OR '8' OR '9' THEN 'O' ELSE ' ';
Code Interpretation: F = Freshman
T = Transfer
O = Other

Warehouse Name - Applicant_Freshman_CAHS
Element Name:  Applicant Freshman-CA High School
Programming Name:  CAFROSH
Master Format A1
Unique Values:  2
Source: Define-DWH
Define Code:  IF (CADMCAT EQ '1' OR '2') AND (SCHTYPE EQ 'A' OR 'B') THEN 'Y' ELSE ' ';
Description:  Code indicating student was admitted as a freshman and whose source school was a California high school.
Comment: 
Code Interpretation: Y = Yes
blank = No

Warehouse Name - Super_Agency_Code
Element Name:  Super Agency Code
Programming Name:  CAGENCY
Master Format A2
Unique Values: 
Source: AFPFUND file
Define Code: 
Description: 
Comment: 
Code Interpretation: 

Warehouse Name - GPA_Freshman_Capped
Element Name:  Grade Point Average-Freshman-Capped
Programming Name:  CALCGPA
Master Format F4.2
Unique Values:  number
Source: ETS
Define Code: 
Description:  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.
Comment: 
Code Interpretation: 

Warehouse Name - GPA_Freshman_Capped_Rep
Element Name:  Grade Point Average-Freshman-Capped-Repeats
Programming Name:  CALCGPA_R
Master Format F4.2
Unique Values:  number
Source: ETS
Define Code: 
Description:  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.
Comment:  Added for fall 2002 applicants.
Code Interpretation: 

Warehouse Name - Year_Registered_CY
Element Name:  Calendar Year
Programming Name:  CALYEAR
Master Format A2
Unique Values: 
Source: Input file
Define Code: 
Description:  Calendar year during which the student was enrolled.
Comment:  Reg input files contain calendar year, NOT Academic year.
Code Interpretation: 

Warehouse Name - Year_Registered_CY
Element Name:  Calendar Year Registered
Programming Name:  CALYR
Master Format A2
Unique Values:  1
Source: Input file
Define Code: 
Description:  The calendar year during which the student is registered for classes. 2 digits in input files. 4 digits in data warehouse. Note that input files contains calendar year, NOT academic year.
Comment: 
Code Interpretation: 

Warehouse Name - California_Resident_1_Year
Element Name:  California_Resident_1_Year
Programming Name:  CAL_RES_1YR
Master Format A1
Unique Values: 
Source: ETS
Define Code: 
Description:  California Resident Time ( Indicates if applicant has lived in CA for at least one year.)
Comment: 
Code Interpretation: Y = Yes
N = No

Warehouse Name - Campus_Name
Element Name:  Campus Name
Programming Name:  CAMPUS
Master Format 
Unique Values:  9
Source: Define-DWH
Define Code: 
Description:  Campus name.
Comment: 
Code Interpretation: 

Warehouse Name - Campus_Name_Abbreviation
Element Name:  Campus Name Abbreviation
Programming Name:  CAMPUSAB
Master Format 
Unique Values:  9
Source: Define-DWH
Define Code: 
Description:  Two-character abbreviation of campus name.
Comment: 
Code Interpretation: 

Warehouse Name - Campus_Name
Element Name:  Campus Name
Programming Name:  CAMPUSNM
Master Format 
Unique Values:  9
Source: Define-DWH
Define Code: 
Description:  Campus name.
Comment: 
Code Interpretation: 

Warehouse Name - Cancelled_by_Student_Flag
Element Name:  Cancelled by Student Flag
Programming Name:  CANAFLAG
Master Format I1
Unique Values:  3
Source: Define-MF
Define Code: 
Description:  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.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Cancelled_Death_Flag
Element Name:  Cancelled Death Flag
Programming Name:  CANDFLAG
Master Format I1
Unique Values:  3
Source: Define-MF
Define Code: 
Description:  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.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Cancelled_Falsification_Flag
Element Name:  Cancelled Falsification Flag
Programming Name:  CANFFLAG
Master Format I1
Unique Values:  3
Source: Define-MF
Define Code: 
Description:  Code indicating a campus has cancelled an application due to student falsification. Student did not register, submit a SIR, or defer at another campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Cancelled_Offer_Withdrawn_Flag
Element Name:  Cancelled Offer Withdrawn Flag
Programming Name:  CANOFLAG
Master Format I1
Unique Values:  3
Source: Define-MF
Define Code: 
Description:  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.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Applicant_Level_Code
Element Name:  Applicant Level Code
Programming Name:  CAPPCAT
Master Format A1
Unique Values:  7
Source: Define-MF
Define Code: 
Description:  Code indicating the academic status for which the applicant qualifies.
Comment: 
Code Interpretation: 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)

Warehouse Name - Application_Received_Code
Element Name:  Application Received Code
Programming Name:  CAPPRCVD
Master Format A1
Unique Values: 
Source: Define-MF
Define Code: 
Description:  Code indicating the type of applicant received at a campus.
Comment: 
Code Interpretation: 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.

Warehouse Name - Application_Received_Code_BK
Element Name:  Application Recevied Code-Berkeley
Programming Name:  CAPPRCVDBK
Master Format A1
Unique Values:  2
Source: ETS
Define Code: 
Description:  Code indicating the type of undergraduate application received at the Berkeley campus.
Comment: 
Code Interpretation: 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.

Warehouse Name - Application_Received_Code_DV
Element Name:  Application Recevied Code-Davis
Programming Name:  CAPPRCVDDV
Master Format A1
Unique Values:  2
Source: ETS
Define Code: 
Description:  Code indicating the type of undergraduate application received at the Berkeley campus.
Comment: 
Code Interpretation: 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.

Warehouse Name - Application_Received_Code_IR
Element Name:  Application Recevied Code-Irvine
Programming Name:  CAPPRCVDIR
Master Format A1
Unique Values:  2
Source: ETS
Define Code: 
Description:  Code indicating the type of undergraduate application received at the Irvine campus.
Comment: 
Code Interpretation: 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.

Warehouse Name - Application_Received_Code_LA
Element Name:  Application Recevied Code-Los Angeles
Programming Name:  CAPPRCVDLA
Master Format A1
Unique Values:  2
Source: ETS
Define Code: 
Description:  Code indicating the type of undergraduate application received at the Los Angeles campus.
Comment: 
Code Interpretation: 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.

Warehouse Name - Application_Received_Code_MC
Element Name:  Application Received Code-Merced
Programming Name:  CAPPRCVDMC
Master Format A1
Unique Values:  2
Source: ETS
Define Code: 
Description:  Code indicating the type of undergraduate application received at the Merced campus.
Comment: 
Code Interpretation: 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.

Warehouse Name - Application_Received_Code_RV
Element Name:  Application Recevied Code-Riverside
Programming Name:  CAPPRCVDRV
Master Format A1
Unique Values:  2
Source: ETS
Define Code: 
Description:  Code indicating the type of undergraduate application received at the Riverside campus.
Comment: 
Code Interpretation: 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.

Warehouse Name - Application_Received_Code_SB
Element Name:  Application Recevied Code-Santa Barbara
Programming Name:  CAPPRCVDSB
Master Format A1
Unique Values:  2
Source: ETS
Define Code: 
Description:  Code indicating the type of undergraduate application received at the Santa Barbara campus.
Comment: 
Code Interpretation: 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.

Warehouse Name - Application_Received_Code_SC
Element Name:  Application Recevied Code-Santa Cruz
Programming Name:  CAPPRCVDSC
Master Format A1
Unique Values:  2
Source: ETS
Define Code: 
Description:  Code indicating the type of undergraduate application received at the Santa Cruz campus.
Comment: 
Code Interpretation: 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.

Warehouse Name - Application_Received_Code_SD
Element Name:  Application Recevied Code-San Diego
Programming Name:  CAPPRCVDSD
Master Format A1
Unique Values:  2
Source: ETS
Define Code: 
Description:  Code indicating the type of undergraduate application received at the San Diego campus.
Comment: 
Code Interpretation: 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.

Warehouse Name - Applicant_Direct_ICT_Code
Element Name:  Applicant Direct Intercampus Transfer
Programming Name:  CAPPTYPE
Master Format A1
Unique Values:  2
Source: Define-MF
Define Code: 
Description:  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.
Comment: 
Code Interpretation: 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

Warehouse Name - No longer used.
Element Name:  High School Eligibility Adv Stg Applicant
Programming Name:  CASHSELIG
Master Format A1
Unique Values:  <30
Source: No longer used.
Define Code: 
Description:  Code indicating an advanced standing applicant's eligibility to enter the University of California on the basis of high school records only. NO LONGER USED?
Comment: 
Code Interpretation: Codes effective after 7/15/85
A = Regularly admissable
B = Eligible only from tests (CEEB eligible)
D = Subject deficiency
E = Scholarship/subject deficiency
F = Other (includes no test, high school not approved, not high school grad)

Warehouse Name - Award_Group_Code
Element Name:  Award Group Code
Programming Name:  CAWDGRP
Master Format A2
Unique Values:  <200
Source: Define-MF
Define Code: 
Description:  Code indicating a related group of financial aid award types.
Comment: 
Code Interpretation:  Refer to Financial Aid Award Group Code Table.

Warehouse Name - Award_Maximum
Element Name:  Award Maximum
Programming Name:  CAWDMAX
Master Format N6
Unique Values: 
Source: CSF Web Application
Define Code: 
Description:  Current maximum dollar amount for specific award. Zero or nul if no maximum.
Comment: 
Code Interpretation: 

Warehouse Name - Award_Code
Element Name:  Award Code
Programming Name:  CAWDTYPE
Master Format A3
Unique Values:  ~300
Source: Campus Input
Define Code: 
Description:  Code indicating the financial aid award which has been made to a student.
Comment:  "Effective with the May 1, 2000 files this field has been expanded to 3 characters"
Code Interpretation: Refer to Financial Aid Award Code Table.

Warehouse Name - Campus_Registered_Code
Element Name:  Campus Registered Code
Programming Name:  CCAMPUS
Master Format A2
Unique Values:  9
Source: Campus Input
Define Code: 
Description:  Code indicating the campus at which the student or postdoctoral scholar is registered.
Comment: 
Code Interpretation: 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

Warehouse Name - Campus_Applied_to_Code
Element Name:  Campus Applied to Code
Programming Name:  CCAMPUSAP
Master Format A2
Unique Values:  9
Source: Campus Input
Define Code: 
Description:  Code indicating campus responsible for applicant record.
Comment: 
Code Interpretation: 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

Warehouse Name - Campus_Name_Abbreviation_App
Element Name:  Campus Name Abbreviation App
Programming Name:  CCAMPUSAPAB
Master Format A2
Unique Values:  10
Source: Define-DWH
Define Code:  DECODE CCAMPUSAP
Description:  Two-character abbreviation of campus name at which student applied.
Comment: 
Code Interpretation: 

Warehouse Name - Applicant_BK
Element Name:  Applicant-Berkeley
Programming Name:  CCAMPUSAPBK
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '01' AND ((CAPPRCVD NE ' ') OR (CMAJPRP NE ' ')) THEN 1 ELSE 0;
Description:  Flag indicating student applied to Berkeley campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Applicant_DV
Element Name:  Applicant-Davis
Programming Name:  CCAMPUSAPDV
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '03' AND ((CAPPRCVD NE ' ') OR (CMAJPRP NE ' ')) THEN 1 ELSE 0;
Description:  Flag indicating student applied to Davis campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Applicant_IR
Element Name:  Applicant-Irvine
Programming Name:  CCAMPUSAPIR
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '09' AND ((CAPPRCVD NE ' ') OR (CMAJPRP NE ' ')) THEN 1 ELSE 0;
Description:  Flag indicating student applied to Irvine campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Applicant_LA
Element Name:  Applicant-Los Angeles
Programming Name:  CCAMPUSAPLA
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '04' AND ((CAPPRCVD NE ' ') OR (CMAJPRP NE ' ')) THEN 1 ELSE 0;
Description:  Flag indicating student applied to Los Angeles campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Applicant_MR
Element Name:  Applicant-Merced
Programming Name:  CCAMPUSAPMR
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  0;
Description:  Flag indicating student applied to Merced campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Campus_Name_App
Element Name:  Campus Name App
Programming Name:  CCAMPUSAPNM
Master Format A15
Unique Values:  10
Source: Define-DWH
Define Code:  DECODE CCAMPUSAP
Description:  Name of campus at which campus applied.
Comment: 
Code Interpretation: 

Warehouse Name - Applicant_RV
Element Name:  Applicant-Riverside
Programming Name:  CCAMPUSAPRV
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '05' AND ((CAPPRCVD NE ' ') OR (CMAJPRP NE ' ')) THEN 1 ELSE 0;
Description:  Flag indicating student applied to Riverside campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Applicant_SB
Element Name:  Applicant-Santa Barbara
Programming Name:  CCAMPUSAPSB
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '08' AND ((CAPPRCVD NE ' ') OR (CMAJPRP NE ' ')) THEN 1 ELSE 0;
Description:  Flag indicating student applied to Santa Barbara campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Applicant_SC
Element Name:  Applicant-Santa Cruz
Programming Name:  CCAMPUSAPSC
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '07' AND ((CAPPRCVD NE ' ') OR (CMAJPRP NE ' ')) THEN 1 ELSE 0;
Description:  Flag indicating student applied to Santa Cruz campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Applicant_SD
Element Name:  Applicant-San Diego
Programming Name:  CCAMPUSAPSD
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CCAMPUSAP EQ '06' AND ((CAPPRCVD NE ' ') OR (CMAJPRP NE ' ')) THEN 1 ELSE 0;
Description:  Flag indicating student applied to San Diego campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Cancelled_Application_Flag
Element Name:  Cancelled Application Flag
Programming Name:  CCANCEL
Master Format A1
Unique Values:  2
Source: Campus Input
Define Code: 
Description:  Code indicating by whom an application was cancelled.
Comment: 
Code Interpretation: A = Cancelled by administration
V = Voluntarily cancelled by applicant

Warehouse Name - Applicant_Transfer_CCC
Element Name:  Applicant Transfer-CA Community College
Programming Name:  CCCTRANS
Master Format A1
Unique Values:  2
Source: Define-DWH
Define Code:  IF (CADMCAT EQ '3' OR '4' OR '5' OR '6') AND SCHTYPE EQ 'C' THEN 'Y' ELSE ' ';
Description:  Code indicating student was admitted as a transfer and whose source school was a California Community College.
Comment: 
Code Interpretation: Y = Yes
blank = No

Warehouse Name - CCM_Code_3WK
Element Name:  Campus-College-Major-3rd Week
Programming Name:  CCM3
Master Format A7
Unique Values:  >1000
Source: Define-MF
Define Code: 
Description:  Campus-college-major code combination, as of the end of the third week of classes.
Comment: 
Code Interpretation:  Refer to Campus-College-Major Code Table.

Warehouse Name - CCM_Code
Element Name:  CCM Code
Programming Name:  CCMCODE
Master Format A7
Unique Values:  >1000
Source: CSX Web application
Define Code: 
Description:  Campus College Major table unique key. Consists of Campus Code + College Code + Major Code.
Comment: 
Code Interpretation: 

Warehouse Name - CCM_Code_Degree
Element Name:  Campus-College-Major-Degree
Programming Name:  CCMD
Master Format A7
Unique Values:  >1000
Source: Define-MF
Define Code: 
Description:  Campus-college-major code combination for degree awarded.
Comment: 
Code Interpretation:  Refer to Campus-College-Major Code Table.

Warehouse Name - CCM_Code_EOT
Element Name:  Campus-College-Major-End of Term
Programming Name:  CCME
Master Format A7
Unique Values:  >1000
Source: Define-MF
Define Code: 
Description:  Campus-college-major code combination, as of the end of the term.
Comment: 
Code Interpretation:  Refer to Campus-College-Major Code Table.

Warehouse Name - CCM_Code_Proposed_GAD
Element Name:  Campus-College-Major-GAD
Programming Name:  CCMG
Master Format A7
Unique Values:  >1000
Source: Define-MF
Define Code: 
Description:  Campus-college-major code combination proposed on graduate admission application.
Comment: 
Code Interpretation:  Refer to Campus-College-Major Code Table.

Warehouse Name - Campus_ICT_Applicant
Element Name:  Campus of Most Recent Attendance Code
Programming Name:  CCMPRCNTAT
Master Format A2
Unique Values:  9
Source: Rename
Define Code: 
Description:  Code indicating UC campus of applicant's current or most recent attendance.
Comment: 
Code Interpretation: 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

Warehouse Name - Country_of_Citizenship_Code
Element Name:  Citizenship Country Code-Student
Programming Name:  CCOFC
Master Format A3
Unique Values:  ~360
Source: Campus Input
Define Code: 
Description:  Code indicating the country of citizenship of a student visa holder or the former country of citizenship of a student refugee.
Comment: 
Code Interpretation: Refer to Location Code Table.

Warehouse Name - College_Code_3WK
Element Name:  College Code-3rd Week
Programming Name:  CCOL3
Master Format A2
Unique Values:  ~65
Source: Campus Input
Define Code: 
Description:  Code indicating the administrative unit above department level and below campus level to which the student is charged for budgetary purposes, as of the end of the third week of classes.
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - College_Code_3WK_1
Element Name:  College Code-3rd Week-1
Programming Name:  CCOL31
Master Format A2
Unique Values:  ~65
Source: Campus Input
Define Code: 
Description:  Code indicating the administrative unit above department level and below campus level associated with the first component of a student's double, triple, or joint major, as of the end of the third week of classes.
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - College_Code_3WK_2
Element Name:  College Code-3rd Week-2
Programming Name:  CCOL32
Master Format A2
Unique Values:  ~65
Source: Campus Input
Define Code: 
Description:  Code indicating the administrative unit above department level and below campus level associated with the second component of a student's double, triple, or joint major, as of the end of the third week of classes.
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - College_Code_3WK_3
Element Name:  College Code-3rd Week-2
Programming Name:  CCOL33
Master Format A2
Unique Values:  ~65
Source: Campus Input
Define Code: 
Description:  Code indicating the administrative unit above department level and below campus level associated with the third component of a student's triple major, as of the end of the third week of classes.
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - College_Code_EOT
Element Name:  College Code-End of Term
Programming Name:  CCOLE
Master Format A2
Unique Values:  ~65
Source: Campus Input
Define Code: 
Description:  Code indicating the administrative unit above department level and below campus level to which the student is charged for budgetary purposes, as of the end of the term.
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - College_Code_EOT_1
Element Name:  College Code-End of Term-1
Programming Name:  CCOLE1
Master Format A2
Unique Values:  ~65
Source: Campus Input
Define Code: 
Description:  Code indicating the administrative unit above department level and below campus level associated with the first component of a student's double, triple, or joint major, as of the end of term.
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - College_Code_EOT_2
Element Name:  College Code-End of Term-2
Programming Name:  CCOLE2
Master Format A2
Unique Values:  ~65
Source: Campus Input
Define Code: 
Description:  Code indicating the administrative unit above department level and below campus level associated with the second component of a student's double, triple, or joint major, as of the end of term.
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - College_Code_EOT_3
Element Name:  College Code-End of Term-3
Programming Name:  CCOLE3
Master Format A2
Unique Values:  ~65
Source: Campus Input
Define Code: 
Description:  Code indicating the administrative unit above department level and below campus level associated with the third component of a student's triple major, as of the end of term.
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - College_Code_EOT
Element Name:  College Code-End of Term
Programming Name:  CCOLLEGE
Master Format A2
Unique Values:  ~65
Source: Rename
Define Code: 
Description:  Code indicating the administrative unit above department level and below campus level to which the student is charged for budgetary purposes.
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - College_Code_Proposed
Element Name:  College Code Proposed
Programming Name:  CCOLPRP
Master Format A2
Unique Values:  ~65
Source: Campus Input
Define Code: 
Description:  Name of the college in which applicant plans to enroll.
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - College_Code_Proposed_1
Element Name:  College Code Proposed-1
Programming Name:  CCOLPRP1
Master Format A2
Unique Values:  ~65
Source: Campus Input
Define Code: 
Description:  Code indicating the college in which applicant plans to enroll; or, the first college in which applicant plans to enroll if enrolling in a joint or concurrent degree program.
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - College_Code_Proposed_2
Element Name:  College Code Proposed-2
Programming Name:  CCOLPRP2
Master Format A2
Unique Values:  ~65
Source: Campus Input
Define Code: 
Description:  Code indicating the second college in which applicant plans to enroll, if enrolling in a joint or concurrent degree program.
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - College_Code_Proposed_3
Element Name:  College Code Proposed-3
Programming Name:  CCOLPRP3
Master Format A2
Unique Values:  ~65
Source: Campus Input
Define Code: 
Description:  Code indicating the third college in which applicant plans to enroll, if enrolling in a joint or concurrent degree program.
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - College_Code_Degree
Element Name:  College Code for Degree Awarded
Programming Name:  CDEGCOL
Master Format A2
Unique Values:  ~65
Source: Campus Input
Define Code: 
Description:  Code indicating the administrative unit above department level and below campus level associated with the academic program in which student was awarded U.C. degree.
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - College_Code_Degree_1
Element Name:  College Code for Degree Awarded-1
Programming Name:  CDEGCOL1
Master Format A2
Unique Values:  ~65
Source: Campus Input
Define Code: 
Description:  Code indicating the administrative unit above department level and below campus level associated with the first component of the double, triple or joint major in which student was awarded U.C. degree.
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - College_Code_Degree_2
Element Name:  College Code for Degree Awarded-2
Programming Name:  CDEGCOL2
Master Format A2
Unique Values:  ~65
Source: Campus Input
Define Code: 
Description:  Code indicating the administrative unit above department level and below campus level associated with the second component of the double, triple or joint major in which student was awarded U.C. degree.
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - College_Code_Degree_3
Element Name:  College Code for Degree Awarded-3
Programming Name:  CDEGCOL3
Master Format A2
Unique Values:  ~65
Source: Campus Input
Define Code: 
Description:  Code indicating the administrative unit above department level and below campus level associated with the second component of the double, triple or joint major in which student was awarded U.C. degree.
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - College_Code_Degree_1
Element Name:  College Code Degree-1
Programming Name:  CDEGCOL_1
Master Format A2
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Code indicating college or school in which the student earned the first baccalaureate degree.
Comment: 
Code Interpretation: 

Warehouse Name - Major_Code_Degree
Element Name:  Major Code for Degree Awarded
Programming Name:  CDEGMAJ
Master Format A3
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Code indicating academic program (major) in which student was awarded U.C. degree.
Comment: 
Code Interpretation: Refer to Major Code Table.

Warehouse Name - Major_Code_Degree_1
Element Name:  Major Code for Degree Awarded-1
Programming Name:  CDEGMAJ1
Master Format A3
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Code indicating the first component of the double, triple or joint major in which student was awarded U.C. degree.
Comment: 
Code Interpretation: Refer to Major Code Table.

Warehouse Name - Major_Code_Degree_2
Element Name:  Major Code for Degree Awarded-2
Programming Name:  CDEGMAJ2
Master Format A3
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Code indicating the second component of the double, triple or joint major in which the student was awarded U.C. degree.
Comment: 
Code Interpretation: Refer to Major Code Table.

Warehouse Name - Major_Code_Degree_3
Element Name:  Major Code for Degree Awarded-3
Programming Name:  CDEGMAJ3
Master Format A3
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Code indicating the third component of the triple major in which student was awarded U.C. degree.
Comment: 
Code Interpretation: Refer to Major Code Table.

Warehouse Name - Major_Code_Degree_1
Element Name:  Major Code Degree-1
Programming Name:  CDEGMAJ_1
Master Format A3
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Code indicating the major field of study in which the student earned the first baccalaureate degree.
Comment: 
Code Interpretation: 

Warehouse Name - Degree_Program_Code_1
Element Name:  Degree Program Code-1
Programming Name:  CDEGPGM1
Master Format A2
Unique Values:  ~75
Source: Campus Input
Define Code: 
Description:  Code indicating the degree program in which the student has been admitted or enrolled; or, the first degree program of a joint or concurrent degree program in which the student has been admitted or enrolled.
Comment: 
Code Interpretation: Refer to Degree Code Table.

Warehouse Name - Degree_Program_Code_2
Element Name:  Degree Program Code-2
Programming Name:  CDEGPGM2
Master Format A2
Unique Values:  ~75
Source: Campus Input
Define Code: 
Description:  Code indicating the second degree program in which the student has been admitted or enrolled, if enrolled in a joint or concurrent degree program.
Comment: 
Code Interpretation: Refer to Degree Code Table.

Warehouse Name - Degree_Program_Code_3
Element Name:  Degree Program Code-3
Programming Name:  CDEGPGM3
Master Format A2
Unique Values:  ~75
Source: Campus Input
Define Code: 
Description:  Code indicating the third degree program in which the student has been admitted or enrolled, if enrolled in a joint or concurrent degree program.
Comment: 
Code Interpretation: Refer to Degree Code Table.

Warehouse Name - Term_Degree_Awarded
Element Name:  Term Degree Awarded
Programming Name:  CDEGQTR
Master Format A1
Unique Values:  4
Source: Define-MF
Define Code: 
Description:  Code indicating the academic term during which the student was awarded a degree.
Comment: 
Code Interpretation: 1 = Summer
2 = Fall
3 = Winter
4 = Spring

Warehouse Name - Degree_Awarded_Code
Element Name:  Degree Awarded Code
Programming Name:  CDEGREE
Master Format A2
Unique Values:  ~75
Source: Campus Input
Define Code: 
Description:  Code indicating the type of degree awarded by the University of California.
Comment: 
Code Interpretation: Refer to Degree Code Table.

Warehouse Name - Disability_Code
Element Name:  Disability Type Code
Programming Name:  CDISABILITY
Master Format A1
Unique Values:  9
Source: Not Collected
Define Code: 
Description:  Code indicating the nature of the disability possessed by those individuals who have identified themselves as being disabled.
Comment:  08/13/2008 This data element has never been collected and so is currently empty.
Code Interpretation: 

Warehouse Name - Disability_Code
Element Name:  Disability Type Code
Programming Name:  CDISABILTY
Master Format A1
Unique Values:  9
Source: Rename
Define Code: 
Description:  Code indicating the nature of the disability possessed by those individuals who have identified themselves as being disabled. Rename from UADM element CDISABILITY.
Comment: 
Code Interpretation: 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.

Warehouse Name - Disability_Permanent_Code
Element Name:  Disability Code
Programming Name:  CDISTYPE
Master Format A1
Unique Values:  9
Source: Campus Input
Define Code: 
Description:  Code indicating the type of permanent or temporary disability of the student served by the Disabled Student Service Office. For students with multiple disabilities, only the primary disability is reported by the Disabled Student Service Office.
Comment: 
Code Interpretation: A = Vision - Blind
B = Mobility
C = Other Functional Impairment
D = Acquired/Traumatic Brain Injury
E = Speech/Other Communication Disability
F = Deaf
G = Other Hearing Impairment
H = Other communication disability (no longer used as of Summer 2010, see “E”)
I = Learning disability
J= Vision – Low Vision (effective Summer 2010)
K= Attention Deficit/Hyperactivity Disorder (effective Summer 2010)
L= Autism/Aspergers Syndrome (effective Summer 2010)
M= Psychological Disability (effective Summer 2010)

Warehouse Name - Award_Basis_Diversity
Element Name:  Award Basis-Diversity
Programming Name:  CDIV
Master Format A1
Unique Values:  2
Source: X-Reference
Define Code: 
Description:  Code indicating whether financial aid award is diversity based.
Comment: 
Code Interpretation: Y = Yes
N = No

Warehouse Name - Eligibility_Campus_Decision
Element Name:  Eligibility for Admission-Campus Determination
Programming Name:  CELIGADM
Master Format A2
Unique Values:  ~25
Source: Define-MF
Define Code: 
Description:  Code indicating eligibility status (admit/defer) of applicant for admission.
Comment:  define code: CELIGADM = IF INEW_SPEC NE ' ' THEN (IF INEW_SPEC EQ '02' AND ISPECPROGA CONTAINS '1' THEN '08' ELSE DECODE INEW_SPEC (01 07, 02 09, 03 11, 04 12, 05 17, 06 18, 07 10, 08 04, 09 05, 10 06, 11 13, 12 14, 13 15, 14 16)) ELSE DECODE INEW_ELIG(' ' ' ', 04 02, 05 03, 06 18, 07 19, 08 20, 09 21, 10 22, 13 23, 15 24, 21 25, 25 26, 26 27, 27 28, 28 19, 35 35, 36 36, 37 37, 38 38, 40 40, 41 41, 42 42, 50 50, 51 51);
Code Interpretation: 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)

Warehouse Name - Eligibility_Campus_2CAT
Element Name:  Eligibility Campus-2 Category
Programming Name:  CELIGADM2
Master Format 
Unique Values:  3
Source: Define-DWH
Define Code:  IF (CELIGADM EQ '02' OR '03') THEN 'R' ELSE IF (CELIGADM GE '04' AND CELIGADM LE '18') THEN 'S' ELSE ' ' ;
Description:  Code indicating two-category admission type (regular or special). Recode of CELIGADM.
Comment: 
Code Interpretation: R = Regular Admit
S = Special Admit

Warehouse Name - Eligibility_Campus_Decision_Reg
Element Name:  Eligibility Campus Decision Reg
Programming Name:  CELIGADMR
Master Format A2
Unique Values:  ~25
Source: Define-DWH
Define Code:  IF CREGISTER EQ 'Y' THEN CELIGADM ELSE ' ';
Description:  Eligibility for admission at the campus to which the student registered.
Comment: 
Code Interpretation: 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)

Warehouse Name - Eligibility_Campus_Reg_2CAT
Element Name:  Eligibility Campus Reg 2CAT
Programming Name:  CELIGADMR2
Master Format A1
Unique Values:  3
Source: Define-DWH
Define Code:  IF (CELIGADMR EQ '02' OR '03') THEN 'R' ELSE IF (CELIGADMR GE '04' AND CELIGADMR LE '18') THEN 'S' ELSE ' ';
Description:  Code indicating two-category admission type (regular or special) at the campus at which the student registered. Recode of CELIGADMR.
Comment: 
Code Interpretation: R = Regular Admit
S = Special Admit

Warehouse Name - Eligibility_Transfer_Estimated
Element Name:  Eligibility Transfer Estimated
Programming Name:  CELIGETSAS
Master Format A1
Unique Values:  10
Source: ETS
Define Code: 
Description:  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.
Comment: 
Code Interpretation: 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.

Warehouse Name - Eligibility_Freshman_Estimated
Element Name:  Eligibility Freshman Estimated
Programming Name:  CELIGETSHS
Master Format A1
Unique Values:  13
Source: ETS
Define Code: 
Description:  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.
Comment: 
Code Interpretation: Criteria will be applied and the indicator set in the order listed below. For example, if both I and B are true, the indicator will be I. If criteria are updated, eligibility indicator may be revised.
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).

Warehouse Name - CETAD_Identified
Element Name:  CETAD Identified
Programming Name:  CETAD
Master Format A1
Unique Values:  number
Source: ETS
Define Code: 
Description:  CETAD Identifed (Record has been identifed for central evaluation by campuses.)
Comment: 
Code Interpretation: 

Warehouse Name - CETAD_Evaluated_Engl_Trans_Crse
Element Name:  CETAD Evaluated English Transfer Course
Programming Name:  CETAD_ENG_CR
Master Format A1
Unique Values: 
Source: Vendor
Define Code: 
Description:  CETAD Evaluated English Composition Transfer Course
Comment: 
Code Interpretation: C=Complete
I=In Progress
N=Not complete or in progress
blank=Not reviewed

Warehouse Name - CETAD_Evaluated_GPA_SR
Element Name:  CETAD Evaluated GPA SR
Programming Name:  CETAD_GPA_SR
Master Format F4.2
Unique Values: 
Source: Vendor
Define Code: 
Description:  CETAD EVALUATED Transfer GPA
Comment: 
Code Interpretation: 

Warehouse Name - CETAD_Evaluated_Math_Trans_Crse
Element Name:  CETAD Evaluated Math Transfer Course
Programming Name:  CETAD_MTH_CR
Master Format A1
Unique Values: 
Source: Vendor
Define Code: 
Description:  CETAD Evaluated Math Transfer Course
Comment: 
Code Interpretation: C=Complete
I=In Progress
N=Not complete or in progress
blank=Not reviewed

Warehouse Name - CETAD_Reason_Code
Element Name:  CETAD Reason Code
Programming Name:  CETAD_REASON
Master Format A2
Unique Values: 
Source: Vendor
Define Code: 
Description:  CETAD Reason Code
Comment: 
Code Interpretation: 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

Warehouse Name - CETAD_Evaluated_Trans_Crses
Element Name:  CETAD Evaluated Transfer Courses
Programming Name:  CETAD_TRN_CR
Master Format A1
Unique Values: 
Source: Vendor
Define Code: 
Description:  CETAD evaluated other transfer courses
Comment: 
Code Interpretation: C=Complete
I=In Progress
N=Not complete or in progress
blank=Not reviewed

Warehouse Name - CETAD_Evaluated_QTR_Units
Element Name:  CETAD Evaluated Quarter Units
Programming Name:  CETAD_U_Q
Master Format F5.1
Unique Values: 
Source: Vendor
Define Code: 
Description:  CETAD Evaluated Quarter Units
Comment: 
Code Interpretation: 

Warehouse Name - Ethnic_Origin_Code
Element Name:  Ethnic Origin Code
Programming Name:  CETHNIC
Master Format A1
Unique Values: 
Source: Campus Input
Define Code: 
Description:  Code indicating the ethnic background of the postdoctoral scholar.
Comment: 
Code Interpretation: A = American Indian/Alaskan Native
B = Black/African American
C = Chicano/Mexican-American
D = Chinese/Chinese-American
E = Decline to State
F = East Indian/Pakistani
G = Japanese/Japanese-American
H = Korean
J = Latino/Other Spanish-American
K = Other
L = Pilipino/Filipino
M = Polynesian (Pacific Islander-Fall 88)
N = Thai/Other Asian
P = White/Caucasian
V = Vietnamese

Warehouse Name - Ethnic_Origin_Code_Adm
Element Name:  Ethnic Origin Code-Admission
Programming Name:  CETHNICA
Master Format A1
Unique Values:  16
Source: ETS
Define Code: 
Description:  Code indicating the ethnic background of the student as recorded at the time of application for admission.
Comment:  Effective Fall 2010 (previous source was Campus Input)
Code Interpretation: A = American Indian/Alaskan Native
B = Black/African American
C = Chicano/Mexican-American
D = Chinese/Chinese-American
E = Decline to State
F = East Indian/Pakistani
G = Japanese/Japanese-American
H = Korean
J = Latino/Other Spanish-American
K = Other
L = Pilipino/Filipino
M = Polynesian (Pacific Islander-Fall 88)
N = Thai/Other Asian
P = White/Caucasian
V = Vietnamese

Warehouse Name - Ethnic_Origin_Code_Reg
Element Name:  Ethnic Origin Code-Registration
Programming Name:  CETHNICR
Master Format A1
Unique Values:  16
Source: Campus Input
Define Code: 
Description:  Code indicating the ethnic background of the student as recorded at the time of registration.
Comment: 
Code Interpretation: A = American Indian/Alaskan Native
B = Black/African American
C = Chicano/Mexican-American
D = Chinese/Chinese-American
E = Decline to State
F = East Indian/Pakistani
G = Japanese/Japanese-American
H = Korean
J = Latino/Other Spanish-American
K = Other
L = Pilipino/Filipino
M = Polynesian (Pacific Islander-Fall 88)
N = Thai/Other Asian
P = White/Caucasian
V = Vietnamese

Warehouse Name - Ethnic_Hierarchy
Element Name:  Ethnic Hierarchy Code-Admission
Programming Name:  CETH_HIER
Master Format A2
Unique Values:  38
Source: ETS
Define Code: 
Description:  Code indicating the ethnic hierarchy code of the student as recorded at the time of application for admission.
Comment: 
Code Interpretation: 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

Warehouse Name - CFDA_Code
Element Name:  Catalog of Federal Domestic Assistance (CFDA) Number
Programming Name:  CFDA_CODE
Master Format A5
Unique Values: 
Source: AFPFUND file
Define Code: 
Description:  Code indicating the program of federal assistance assigned by the Federal agencies. Refer to http://www.ucop.edu/raohome/cgmanual for more detail
Comment: 
Code Interpretation: 

Warehouse Name - Graduate_Admit_Code
Element Name:  Graduate Admit Code
Programming Name:  CGRADADM
Master Format A1
Unique Values:  2
Source: Campus Input
Define Code: 
Description:  Code indicating whether a graduate applicant has been admitted.
Comment: 
Code Interpretation: Y = Yes
N = No

Warehouse Name - Source_School_Charged_Code
Element Name:  Source School Charged Code
Programming Name:  CHARGED
Master Format A1
Unique Values:  3
Source: Define-MF
Define Code:  CHARGED = IF ISCH_CHG EQ ' ' THEN 'N' ELSE 'Y';
Description:  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.
Comment: 
Code Interpretation: Y = Yes
N = No

Warehouse Name - Charged_School_Accredited
Element Name:  Charged School Accredited Code
Programming Name:  CHGACCCODE
Master Format A1
Unique Values:  2
Source: X-Reference
Define Code: 
Description:  Accreditation indicator for the school of origin attributed to the undergraduate applicant.
Comment: 
Code Interpretation: Y = Yes
blank = No

Warehouse Name - Charged_School_Address1
Element Name:  Charged School Address Line 1
Programming Name:  CHGADD1
Master Format A30
Unique Values:  >1000
Source: X-Reference
Define Code: 
Description:  First line of the address for the school of origin attributed to the undergraduate applicant.
Comment: 
Code Interpretation: 

Warehouse Name - Charged_School_Address2
Element Name:  Charged School Address Line 2
Programming Name:  CHGADD2
Master Format A30
Unique Values:  >1000
Source: X-Reference
Define Code: 
Description:  Second line of the address for the school of origin attributed to the undergraduate applicant.
Comment: 
Code Interpretation: 

Warehouse Name - Charged_School_Approved
Element Name:  Charged School Approved Code
Programming Name:  CHGAPPCODE
Master Format A1
Unique Values:  2
Source: X-Reference
Define Code: 
Description:  Approval indicator for the school of origin attributed to the undergraduate applicant.
Comment: 
Code Interpretation: Y = Yes
blank = No

Warehouse Name - Charged_School_Area_Type
Element Name:  Charged School Area Type
Programming Name:  CHGAREATYPE
Master Format A1
Unique Values:  2
Source: X-Reference
Define Code: 
Description:  Area type code for the school of origin attributed to the undergraduate applicant.
Comment: 
Code Interpretation: 1 = Rural
2 = Suburban
3 = Urban

Warehouse Name - Charged_School_City
Element Name:  Charged School City
Programming Name:  CHGCITY
Master Format A19
Unique Values:  >1000
Source: X-Reference
Define Code: 
Description:  City location for the school of origin attributed to the undergraduate applicant.
Comment: 
Code Interpretation: 

Warehouse Name - Charged_School_District_Code
Element Name:  Charged School California District Code
Programming Name:  CHGDIST
Master Format A5
Unique Values:  >1000
Source: X-Reference
Define Code: 
Description:  California school district code for the school of origin attributed to the undergraduate applicant.
Comment: 
Code Interpretation: Refer to School District Code Table.

Warehouse Name - Charged_School_Location_Code
Element Name:  Charged School Location Code
Programming Name:  CHGLOCCD
Master Format A3
Unique Values:  ~350
Source: X-Reference
Define Code: 
Description:  Location code for the school of origin attributed to the undergraduate applicant.
Comment: 
Code Interpretation: Refer to Location Code Table.

Warehouse Name - Charged_School_Name
Element Name:  Charged School Name
Programming Name:  CHGNAME
Master Format A35
Unique Values:  >1000
Source: X-Reference
Define Code: 
Description:  Name of the school of origin attributed to the undergraduate applicant.
Comment: 
Code Interpretation: 

Warehouse Name - Charged_School_State
Element Name:  Charged School State
Programming Name:  CHGSTATE
Master Format A2
Unique Values:  55
Source: X-Reference
Define Code: 
Description:  State location for the school of origin attributed to the undergraduate applicant.
Comment: 
Code Interpretation: 

Warehouse Name - Charged_School_Status
Element Name:  Charged School Status Code
Programming Name:  CHGSTATUS
Master Format A2
Unique Values:  3
Source: X-Reference
Define Code: 
Description:  Status code (public, private or unknown) for the school of origin attributed to the undergraduate applicant.
Comment: 
Code Interpretation: PR = Private
PU = Public
UN = Unknown
School Type

Warehouse Name - Charged_School_ATP_Type
Element Name:  Charged School ATP Type Code
Programming Name:  CHGTYPE
Master Format A2
Unique Values:  11
Source: X-Reference
Define Code: 
Description:  ATP type code (HS, 2Y, 4Y, etc) for the school of origin attributed to the undergraduate applicant.
Comment: 
Code Interpretation: 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

Warehouse Name - Charged_School_Zip
Element Name:  Charged School Zip Code
Programming Name:  CHGZIP
Master Format A9
Unique Values:  >1000
Source: X-Reference
Define Code: 
Description:  Zip code for the school of origin attributed to the undergraduate applicant.
Comment: 
Code Interpretation: 

Warehouse Name - Charged_School_SDE_Code
Element Name:  Charged School SDE Code
Programming Name:  CHG_SDE_CD
Master Format A6
Unique Values:  >1000
Source: X-Reference
Define Code: 
Description:  State Department of Education code for the school of origin attributed to the undergraduate applicant.
Comment: 
Code Interpretation: 

Warehouse Name - Home_Location_Code
Element Name:  Home Location Code
Programming Name:  CHOMELOC
Master Format A3
Unique Values:  ~360
Source: Campus Input
Define Code: 
Description:  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.
Comment:  Countries listed in the Location table must be on the State Department or the UN list of valid countries.
Code Interpretation: Refer to Location Code Table.

Warehouse Name - No longer used.
Element Name:  High School Eligibility Adv Stg Applicant
Programming Name:  CHSELIG
Master Format A1
Unique Values:  <30
Source: No longer used.
Define Code: 
Description:  Code indicating an advanced standing applicant's eligibility to enter the University of California on the basis of high school records only. Renamed from UAD element CASHSELIG. No longer used.
Comment: 
Code Interpretation: 

Warehouse Name - High_School_ATP_Code
Element Name:  High School ATP Code
Programming Name:  CHSGRAD
Master Format A6
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  American Testing Program code indicating the high school from which the student graduated.
Comment: 
Code Interpretation: Refer to School Code Table.

Warehouse Name - CIP_Category_Code_3WK
Element Name:  CIP Category Code-3rd Week
Programming Name:  CIPCAT3
Master Format 
Unique Values:  ~52
Source: Define-DWH
Define Code: 
Description:  Two-digit Classification of Instructional Programs code, indicating disciplinary area, as of third week.
Comment: 
Code Interpretation: 

Warehouse Name - CIP_Category_Code_Degree
Element Name:  CIP Category Code-Degree
Programming Name:  CIPCATD
Master Format 
Unique Values:  ~52
Source: Define-DWH
Define Code: 
Description:  Two-digit Classification of Instructional Programs code, indicating disciplinary area, for major field of earned degree.
Comment: 
Code Interpretation: 

Warehouse Name - CIP_Category_Code_Degree_1
Element Name:  CIP Category Code Degree-1
Programming Name:  CIPCATD_1
Master Format A2
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Code indicating the CIP category in which the student earned the first baccalaureate degree.
Comment: 
Code Interpretation: 

Warehouse Name - CIP_Category_Code_EOT
Element Name:  CIP Category Code-EOT
Programming Name:  CIPCATE
Master Format A2
Unique Values: 
Source: 
Define Code:  EDIT (CIPCODEE,'99$$$$');
Description:  Code indicating the CIP (Classification of Instructional Programs) discipline in which a student's program study is classified, as of end of term of the first term enrolled during the year.
Comment: 
Code Interpretation: 

Warehouse Name - CIP_Category_Name_3WK
Element Name:  CIP Category Name-3rd Week
Programming Name:  CIPCATNM3
Master Format 
Unique Values:  ~52
Source: Define-DWH
Define Code: 
Description:  Discipline name for two-digit Classification of Instructional Programs code, indicating disciplinary area, as of third week.
Comment: 
Code Interpretation: 

Warehouse Name - CIP_Category_Name_Degree
Element Name:  CIP Category Name-Degree
Programming Name:  CIPCATNMD
Master Format 
Unique Values:  ~52
Source: Define-DWH
Define Code: 
Description:  Discipline name for two-digit Classification of Instructional Programs code, for major field of earned degree.
Comment: 
Code Interpretation: 

Warehouse Name - CIP_Category_Name_Degree_1
Element Name:  CIP Category Name Degree-1
Programming Name:  CIPCATNMD_1
Master Format A20
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Name of the CIP category in which the student earned the first baccalaureate degree.
Comment: 
Code Interpretation: 

Warehouse Name - CIP_Category_Name_EOT
Element Name:  CIP Category Name-EOT
Programming Name:  CIPCATNME
Master Format A20
Unique Values: 
Source: Define-DWH
Define Code:  IF CIPCODEE GE '510401' AND CIPCODEE LE '510499' THEN 'DENTISTRY' ELSE IF CIPCODEE GE '511201' AND CIPCODEE LE '511299' THEN 'MEDICINE' ELSE IF CIPCOD
Description:  Name of the CIP (Classification of Instructional Programs) discipline in which a student's program of study is classified, as of end of term of the first term enrolled during the year.
Comment: 
Code Interpretation: 

Warehouse Name - CIP_Category_Name_Proposed
Element Name:  CIP Category Name Proposed
Programming Name:  CIPCATNMP
Master Format A20
Unique Values:  ~52
Source: X-reference
Define Code: 
Description:  Name of the two-digit Classification of Instructional Programs code, indicating disciplinary area, proposed by the applicant.
Comment: 
Code Interpretation: 

Warehouse Name - CIP_Category_Code_Proposed
Element Name:  CIP Category Code Proposed
Programming Name:  CIPCATP
Master Format A2
Unique Values:  ~52
Source: X-reference
Define Code:  EDIT (CIPCODEP,'99$$$$');
Description:  Two-digit Classification of Instructional Programs code, indicating disciplinary area, proposed by the applicant.
Comment: 
Code Interpretation: 

Warehouse Name - CIP_Code
Element Name:  CIP Code
Programming Name:  CIPCODE
Master Format A6
Unique Values:  >1000
Source: CSX Web application
Define Code: 
Description:  Code indicating the CIP (Classification of Instructional Programs) discipline of aprogram of study/major.
Comment: 
Code Interpretation: Refer to CIP Code Table.

Warehouse Name - CIP_Code_3WK
Element Name:  CIP Code-3rd Week
Programming Name:  CIPCODE3
Master Format A6
Unique Values:  >1000
Source: X-Reference
Define Code: 
Description:  Code indicating the CIP (Classification of Instructional Programs) discipline in which a student's program of study is classified, as of the end of the third week of classes.
Comment: 
Code Interpretation: Refer to CIP Code Table.

Warehouse Name - CIP_Code_Degree
Element Name:  CIP Code for Degree Awarded
Programming Name:  CIPCODED
Master Format A6
Unique Values:  >1000
Source: X-Reference
Define Code: 
Description:  Code indicating the CIP (Classification of Instructional Programs) discipline associated with the academic program in which student was awarded U.C. degree.
Comment: 
Code Interpretation: Refer to CIP Code Table.

Warehouse Name - CIP_Code_Degree_1
Element Name:  CIP Code Degree 1
Programming Name:  CIPCODED_1
Master Format A6
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Code indicating the CIP field of study in which the student earned the first baccalaureate degree.
Comment: 
Code Interpretation: 

Warehouse Name - CIP_Code_EOT
Element Name:  CIP Code-End of Term
Programming Name:  CIPCODEE
Master Format A6
Unique Values:  >1000
Source: X-Reference
Define Code: 
Description:  Code indicating the CIP (Classification of Instructional Programs) discipline in which a student's program study is classified, as of the first enrolled term of the academic year.
Comment: 
Code Interpretation: Refer to CIP Code Table.

Warehouse Name - CIP_Code_Proposed
Element Name:  CIP Code Proposed
Programming Name:  CIPCODEG
Master Format A6
Unique Values:  >1000
Source: X-Reference
Define Code: 
Description:  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.
Comment: 
Code Interpretation: Refer to CIP Code Table.

Warehouse Name - CIP_Code_Proposed
Element Name:  CIP Code Proposed
Programming Name:  CIPCODEP
Master Format A6
Unique Values:  >1000
Source: X-reference
Define Code: 
Description:  Code indicating the CIP (Classification of Instructional Programs) discipline proposed by the applicant.
Comment: 
Code Interpretation: Refer to CIP Code Table.

Warehouse Name - CIP_Name_3WK
Element Name:  CIP Name-3rd Week
Programming Name:  CIPNAME3
Master Format A55
Unique Values:  >1000
Source: X-Reference
Define Code: 
Description:  Name of the CIP (Classification of Instructional Programs) discipline in which a student's program of study is classified, as of the end of the third week of classes.
Comment: 
Code Interpretation: 

Warehouse Name - CIP_Name_Degree
Element Name:  CIP Name for Degree Awarded
Programming Name:  CIPNAMED
Master Format A55
Unique Values:  >1000
Source: X-Reference
Define Code: 
Description:  Name of the CIP (Classification of Instructional Programs) associated with the academic program in which student was awarded U.C. Degree.
Comment: 
Code Interpretation: 

Warehouse Name - CIP_Name_Degree_1
Element Name:  CIP Name Degree 1
Programming Name:  CIPNAMED_1
Master Format A55
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Name of the CIP field of study in which the student earned the first baccalaureate degree.
Comment: 
Code Interpretation: 

Warehouse Name - CIP_Name_EOT
Element Name:  CIP Name-End of Term
Programming Name:  CIPNAMEE
Master Format A55
Unique Values:  >1000
Source: X-Reference
Define Code: 
Description:  Name of the CIP (Classification of Instructional Programs) discipline in which a student's program of study is classified, as of the end of the term.
Comment: 
Code Interpretation: 

Warehouse Name - CIP_Name_Proposed
Element Name:  CIP Name Proposed
Programming Name:  CIPNAMEG
Master Format A55
Unique Values:  >1000
Source: X-Reference
Define Code: 
Description:  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.
Comment: 
Code Interpretation: Refer to CIP Code Table.

Warehouse Name - CIP_Name_Proposed
Element Name:  CIP Name Proposed
Programming Name:  CIPNAMEP
Master Format A55
Unique Values:  >1000
Source: X-reference
Define Code: 
Description:  Name of the CIP (Classification of Instructional Programs) discipline proposed by the applicant.
Comment: 
Code Interpretation: 

Warehouse Name - Citizenship_Status_Code
Element Name:  Citizenship Status Code
Programming Name:  CITSTAT
Master Format A1
Unique Values: 
Source: Campus Input
Define Code: 
Description:  Code indicating postdoctoral scholar's citizenship status with respect to the United States.
Comment: 
Code Interpretation: 1 = Domestic - U.S. Citizen
2 = Domestic Other - includes permanent residents (PR), refugees (RF), asylees (AS), approved petitioners (AP), and amnesty recipients (AM)
3 = Foreign (non-resident alien)

Warehouse Name - Citizenship_Status_Code_Adm
Element Name:  Citizenship Status Code-Admission
Programming Name:  CITSTATA
Master Format A2
Unique Values:  37
Source: UAD: Mainframe define, GAD: Input file
Define Code: 
Description:  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';
Comment:  Because of a campus coding problem, this data item is unreliable in UAD for year 2004-05. See UAD Problem Log
Code Interpretation: Refer to Citizenship/Visa Status Code Table.

Warehouse Name - Citizenship_Status_Code_Reg
Element Name:  Citizenship Status Code-Registration
Programming Name:  CITSTATR
Master Format A2
Unique Values:  37
Source: Campus Input
Define Code: 
Description:  Code indicating student's citizenship status with respect to the United States at the time of registration.
Comment: 
Code Interpretation: Refer to Citizenship/Visa Status Code Table.

Warehouse Name - Citizenship_Status_Year_1
Element Name:  Citizenship Status Year 1
Programming Name:  CITSTATR_1
Master Format A2
Unique Values:  37
Source: DWH define
Define Code: 
Description:  Code indicating student's citizenship status with respect to the United States at the time of registration in the term entered.
Comment: 
Code Interpretation: Refer to Citizenship/Visa Status Code Table.

Warehouse Name - Citizenship_Status_Code_2CAT
Element Name:  Citizenship Status-2CAT
Programming Name:  CITSTATUS
Master Format 
Unique Values:  2
Source: Define-DWH
Define Code:  see comment
Description:  Two-category code indicating domestic or foreign citizenship/visa status. Recode of CITSTATR.
Comment:  CITSTATUS/A1 = IF CITSTATR EQ 'US' OR 'PR' OR ' ' OR 'RF' OR 'AM' OR 'AS' OR 'AP' THEN 'D' ELSE 'F';
Code Interpretation: D = Domestic
F = Foreign

Warehouse Name - Citizenship_Status_Adm_2CAT
Element Name:  Citizenship Status Adm-2CAT
Programming Name:  CITSTATUSA
Master Format A1
Unique Values:  3
Source: Define-DWH
Define Code:  IF CITSTATA EQ 'US' OR 'PR' OR ' ' OR 'RF' OR 'AM' OR 'AS' OR 'AP' THEN 'D' ELSE 'F';
Description:  Two-category code indicating domestic or foreign citizenship/visa status. Recode of CITSTATA.
Comment:  Because of a campus coding problem, this data item is unreliable in UAD for year 2004-05. See UAD Problem Log
Code Interpretation: D = Domestic
F = Foreign

Warehouse Name - Citizenship_Status_Code_Year_1_2CAT
Element Name:  Citizenship Status Year 1 2CAT
Programming Name:  CITSTATUSA_1
Master Format A1
Unique Values:  3
Source: Define-DWH
Define Code:  IF CITSTATA EQ 'US' OR 'PR' OR ' ' OR 'RF' OR 'AM' OR 'AS' OR 'AP' THEN 'D' ELSE 'F';
Description:  Two-category code indicating domestic or foreign citizenship/visa status during term entered. Recode of CITSTATA.
Comment:  Because of a campus coding problem, this data item is unreliable in UAD for year 2004-05. See UAD Problem Log
Code Interpretation: D = Domestic
F = Foreign

Warehouse Name - Class_Year_Prof_Pgm
Element Name:  Class Year Code
Programming Name:  CLASSYR
Master Format A1
Unique Values:  7
Source: Campus Input
Define Code: 
Description:  Code indicating the class year in the professional program in which the student is enrolled. For residents, this is the year of residency.
Comment: 
Code Interpretation: 1 = 1st year
2 = 2nd year
3 = 3rd year
4 = 4th year
5 = 5th year
6 = 6th year

Warehouse Name - Campus_ICT_Applicant
Element Name:  Prior Campus-ICT Applicant
Programming Name:  CLASTCAM
Master Format A2
Unique Values:  9
Source: Campus Input
Define Code: 
Description:  Code indicating UC campus of applicant's current or most recent attendance.
Comment: 
Code Interpretation: 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

Warehouse Name - Last_School_Type_Code
Element Name:  Last School Type Code
Programming Name:  CLSTSCHTYP
Master Format A1
Unique Values:  9
Source: ETS
Define Code: 
Description:  Code indicating the type of school last attended.
Comment: 
Code Interpretation: Effective Fall 1987
1 = Public High School
2 = Private High School
3 = Community College
4 = Four Year College
5 = UC Campus
Effective Fall 1988
1 = Public High School
2 = Private High School
3 = California Community College/2 year college
4 = Out-of-State Community College/2 year college
5 = Four Year College/University
6 = UC Campus
7 = Code 3 unconfirmed on crossfield check (current or last school not a California Community College)

Warehouse Name - Major_Code_3WK
Element Name:  Major Code-3rd Week
Programming Name:  CMAJ3
Master Format A3
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Code indicating the academic program (major) in which the student is enrolled as of the end of the third week of classes.
Comment: 
Code Interpretation: Refer to Major Code Table.

Warehouse Name - Major_Code_3WK_1
Element Name:  Major Code-3rd Week-1
Programming Name:  CMAJ31
Master Format A3
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Code indicating the first component of a student's double, triple or joint major as of the end of the third week of classes.
Comment: 
Code Interpretation: Refer to Major Code Table.

Warehouse Name - Major_Code_3WK_2
Element Name:  Major Code-3rd Week-2
Programming Name:  CMAJ32
Master Format A3
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Code indicating the second component of a student's double, triple or joint major as of the end of the third week of classes.
Comment: 
Code Interpretation: Refer to Major Code Table.

Warehouse Name - Major_Code_3WK_3
Element Name:  Major Code-3rd Week-3
Programming Name:  CMAJ33
Master Format A3
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Code indicating the third component of a student's triple major as of the end of the third week of classes.
Comment: 
Code Interpretation: Refer to Major Code Table.

Warehouse Name - Major_Code_EOT
Element Name:  Major Code-End of Term
Programming Name:  CMAJE
Master Format A3
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Code indicating the academic program (Major) in which the student is enrolled at the end of the term.
Comment: 
Code Interpretation: Refer to Major Code Table.

Warehouse Name - Major_Code_EOT_1
Element Name:  Major Code-End of Term-1
Programming Name:  CMAJE1
Master Format A3
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Code indicating the first component of a student's double, triple or joint major as of the end of the term.
Comment: 
Code Interpretation: Refer to Major Code Table.

Warehouse Name - Major_Code_EOT_2
Element Name:  Major Code-End of Term-2
Programming Name:  CMAJE2
Master Format A3
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Code indicating the second component of a student's double, triple or joint major as of the end of the term.
Comment: 
Code Interpretation: Refer to Major Code Table.

Warehouse Name - Major_Code_EOT_3
Element Name:  Major Code-End of Term-3
Programming Name:  CMAJE3
Master Format A3
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Code indicating the third component of a student's triple major as of the end of the term.
Comment: 
Code Interpretation: Refer to Major Code Table.

Warehouse Name - Major_Code_EOT
Element Name:  Major Code-End of Term
Programming Name:  CMAJOR
Master Format A3
Unique Values:  >1000
Source: Rename
Define Code: 
Description:  Code indicating the academic program (major) in which the student is enrolled.
Comment: 
Code Interpretation: Refer to Major Code Table.

Warehouse Name - Major_Code_Proposed
Element Name:  Major Code Proposed
Programming Name:  CMAJPRP
Master Format A3
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Code indicating the academic program (major) in which the applicant plans to enroll.
Comment: 
Code Interpretation: Refer to Major Code Table.

Warehouse Name - Major_Code_Proposed_1
Element Name:  Major Code Proposed-1
Programming Name:  CMAJPRP1
Master Format A3
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Code indicating the major in which the applicant plans to enroll or the first major of a joint or concurrent degree program in which the applicant plans to enroll.
Comment: 
Code Interpretation: Refer to Major Code Table.

Warehouse Name - Major_Code_Proposed_2
Element Name:  Major Code Proposed-2
Programming Name:  CMAJPRP2
Master Format A3
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Code indicating the second major in which the applicant plans to enroll, if enrolling in a joint or concurrent degree program.
Comment: 
Code Interpretation: Refer to Major Code Table.

Warehouse Name - Major_Code_Proposed_3
Element Name:  Major Code Proposed-3
Programming Name:  CMAJPRP3
Master Format A3
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Code indicating the third major in which the applicant plans to enroll, if enrolling in a joint or concurrent degree program.
Comment: 
Code Interpretation: Refer to Major Code Table.

Warehouse Name - Award_Basis_Merit
Element Name:  Award Basis-Merit
Programming Name:  CMERIT
Master Format A1
Unique Values:  2
Source: X-Reference
Define Code: 
Description:  Code indicating whether financial aid award is merit based.
Comment: 
Code Interpretation: Y = Yes
N = No

Warehouse Name - Award_Basis_Need
Element Name:  Award Basis-Need
Programming Name:  CNEED
Master Format A1
Unique Values:  2
Source: X-Reference
Define Code: 
Description:  Code indicating whether financial aid award is need based.
Comment: 
Code Interpretation: Y = Yes
N = No

Warehouse Name - College_Code
Element Name:  College Code
Programming Name:  COCODE
Master Format A2
Unique Values:  ~65
Source: CSX Web application
Define Code: 
Description:  Code indicating the administrative unit above department level and below campus level at which the program/major is offered
Comment: 
Code Interpretation: Refer to College Code Table.

Warehouse Name - Country_of_Citizenship_Name
Element Name:  Country of Citizenship Name
Programming Name:  COFC
Master Format A28
Unique Values:  ~360
Source: X-Reference
Define Code: 
Description:  Name of the country of citizenship of a student visa holder or student permanent resident, or the former country of citizenship of a student refugee.
Comment: 
Code Interpretation: 

Warehouse Name - College_Name_EOT
Element Name:  College Name-End of Term
Programming Name:  COL
Master Format A38
Unique Values:  ~65
Source: X-Reference
Define Code: 
Description:  Name of the administrative unit above department level and below campus level to which the student is charged for budgetary purposes, as of the end of the term.
Comment: 
Code Interpretation: 

Warehouse Name - College_Name_3WK
Element Name:  College Name-3rd Week
Programming Name:  COL3
Master Format A38
Unique Values:  ~65
Source: X-Reference
Define Code: 
Description:  Name of the administrative unit above department level and below campus level to which the student is charged for budgetary purposes, as of the end of the third week of classes.
Comment: 
Code Interpretation: 

Warehouse Name - College_Name_EOT
Element Name:  College Name-End of Term
Programming Name:  COLE
Master Format A38
Unique Values:  ~65
Source: X-Reference
Define Code: 
Description:  Name of the administrative unit above department level and below campus level to which the student is charged for budgetary purposes, as of the end of the term.
Comment: 
Code Interpretation: 

Warehouse Name - Trans_Grade_Points_Total
Element Name:  Transfer Grade Points-Total
Programming Name:  COLGP
Master Format F5.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  Total grade points (in quarter units) earned for college level graded work attempted at all institutions, including U.C.
Comment: 
Code Interpretation: 

Warehouse Name - College_Name_Proposed
Element Name:  College Name Proposed
Programming Name:  COLPRP
Master Format A38
Unique Values:  ~65
Source: X-Reference
Define Code: 
Description:  Name of the college in which applicant plans to enroll.
Comment: 
Code Interpretation: 

Warehouse Name - College_Name_Proposed_1
Element Name:  College Name Proposed-1
Programming Name:  COLPRP1
Master Format A38
Unique Values:  or the name of the
Source: X-Reference
Define Code: 
Description:  The name of the college in which applicant plans to enroll
Comment: 
Code Interpretation: 

Warehouse Name - College_Name_Proposed_2
Element Name:  College Name Proposed-2
Programming Name:  COLPRP2
Master Format A38
Unique Values:  ~65
Source: X-Reference
Define Code: 
Description:  The name of the second college in which applicant plans to enroll, if enrolling in a joint or concurrent degree program.
Comment: 
Code Interpretation: 

Warehouse Name - College_Name_Proposed_3
Element Name:  College Name Proposed-3
Programming Name:  COLPRP3
Master Format A38
Unique Values:  ~65
Source: X-Reference
Define Code: 
Description:  The name of the third college in which applicant plans to enroll, if enrolling in a joint or concurrent degree program.
Comment: 
Code Interpretation: 

Warehouse Name - Trans_Units_Attmptd_Grded_Ttl
Element Name:  Transfer Units Attempted-Graded-Total
Programming Name:  COLUNITA
Master Format F5.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  College level graded work (in quarter units) attempted at all institutions, including U.C.
Comment: 
Code Interpretation: 

Warehouse Name - Trans_Units_Accepted_Total
Element Name:  Transfer Units Accepted-Total
Programming Name:  COLUNITAC
Master Format F5.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  College level graded and pass/not pass work (in quarter units) accepted from all institutions, including U.C.
Comment: 
Code Interpretation: 

Warehouse Name - Trans_Units_Accepted_Total
Element Name:  Transfer Units Accepted-Total
Programming Name:  COLUNITACC
Master Format F5.1
Unique Values:  number
Source: Rename
Define Code: 
Description:  College level graded and pass/not pass work (in quarter units) accepted from all institutions, including U.C.
Comment: 
Code Interpretation: 

Warehouse Name - Trans_Units_Passed_Total
Element Name:  Transfer Units Passed-Total
Programming Name:  COLUNITP
Master Format F5.1
Unique Values:  does not include P/
Source: Campus Input
Define Code: 
Description:  Total advanced standing transfer units passed at all previously attended institutions. (Used to determine eligibility for admissions
Comment: 
Code Interpretation: 

Warehouse Name - Units_Completed_TTD_3WK
Element Name:  Units Completed-Total to Date-3rd Week
Programming Name:  COMT3
Master Format F5.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  The sum of the units completed to date toward the degree, as of the end of the third week of classes. Includes UC units passed at current campus and transfer UC units, UC P/NP units passed and other advanced standing transfer units.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Completed_TTD_EOT
Element Name:  Units Completed-Total to Date-End of Term
Programming Name:  COMTE
Master Format F5.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  The sum of the units completed to date toward the degree as of the end of the last term enrolled in the academic year. Includes UC units passed at current campus and transfer UC units, UC P/NP units passed and other advanced standing transfer units.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Completed_TTD_Year_1
Element Name:  Units Completed TTD Year-1
Programming Name:  COMTE_1
Master Format F5.1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Total-to-date units completed by the student, as of the end of the last term enrolled during the first year.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Completed_TTD_Year_2
Element Name:  Units Completed TTD Year-2
Programming Name:  COMTE_2
Master Format F5.1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Total-to-date units completed by the student, as of the end of the last term enrolled during the second year.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Completed_TTD_Year_3
Element Name:  Units Completed TTD Year-3
Programming Name:  COMTE_3
Master Format F5.1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Total-to-date units completed by the student, as of the end of the last term enrolled during the third year.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Completed_TTD_Year_4
Element Name:  Units Completed TTD Year-4
Programming Name:  COMTE_4
Master Format F5.1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Total-to-date units completed by the student, as of the end of the last term enrolled during the fourth year.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Completed_TTD_Year_5
Element Name:  Units Completed TTD Year-5
Programming Name:  COMTE_5
Master Format F5.1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Total-to-date units completed by the student, as of the end of the last term enrolled during the fifth year.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Completed_TTD_Year_6
Element Name:  Units Completed TTD Year-6
Programming Name:  COMTE_6
Master Format F5.1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Total-to-date units completed by the student, as of the end of the last term enrolled during the sixth year.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Completed_TTD_Year_7
Element Name:  Units Completed TTD Year-7
Programming Name:  COMTE_7
Master Format F5.1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Total-to-date units completed by the student, as of the end of the last term enrolled during the seventh year.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Completed_YTD_EOT
Element Name:  Units Completed-Year to Date-End of Term
Programming Name:  COMYTD
Master Format F4.1
Unique Values:  number
Source: Define-MF
Define Code: 
Description:  The sum of the units completed to date during the academic year toward the degree as of the end of the last term enrolled in the academic year. Includes UC units passed at current campus and transfer UC units, UC P/NP units passed and other advanced standing transfer units.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Completed_YTD_Year_1
Element Name:  Units Completed YTD Year-1
Programming Name:  COMYTD_1
Master Format F5.1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Year-to-date units completed by the student, as of the end of the last term enrolled during the first year.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Completed_YTD_Year_2
Element Name:  Units Completed YTD Year-2
Programming Name:  COMYTD_2
Master Format F5.1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Year-to-date units completed by the student, as of the end of the last term enrolled during the second year.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Completed_YTD_Year_3
Element Name:  Units Completed YTD Year-3
Programming Name:  COMYTD_3
Master Format F5.1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Year-to-date units completed by the student, as of the end of the last term enrolled during the third year.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Completed_YTD_Year_4
Element Name:  Units Completed YTD Year-4
Programming Name:  COMYTD_4
Master Format F5.1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Year-to-date units completed by the student, as of the end of the last term enrolled during the fourth year.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Completed_YTD_Year_5
Element Name:  Units Completed YTD Year-5
Programming Name:  COMYTD_5
Master Format F5.1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Year-to-date units completed by the student, as of the end of the last term enrolled during the fifth year.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Completed_YTD_Year_6
Element Name:  Units Completed YTD Year-6
Programming Name:  COMYTD_6
Master Format F5.1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Year-to-date units completed by the student, as of the end of the last term enrolled during the sixth year.
Comment: 
Code Interpretation: 

Warehouse Name - Units_Completed_YTD_Year_7
Element Name:  Units Completed YTD Year-7
Programming Name:  COMYTD_7
Master Format F5.1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Year-to-date units completed by the student, as of the end of the last term enrolled during the seventh year.
Comment: 
Code Interpretation: 

Warehouse Name - Conv_Honors_10
Element Name:  Converted Honors 10
Programming Name:  CONV_HON_10
Master Format F4.1
Unique Values: 
Source: Vendor
Define Code: 
Description:  Sum of AP, HL, and IB honors attached to 10th grade courses, converted to semester format.
Comment: 
Code Interpretation: 

Warehouse Name - Conv_Honors_11
Element Name:  Converted Honors 11
Programming Name:  CONV_HON_11
Master Format F4.1
Unique Values: 
Source: Vendor
Define Code: 
Description:  Sum of AP, HL, and IB honors attached to 11th grade courses, converted to semester format.
Comment: 
Code Interpretation: 

Warehouse Name - Conv_Honors_12
Element Name:  Converted Honors 12
Programming Name:  CONV_HON_12
Master Format F4.1
Unique Values: 
Source: Vendor
Define Code: 
Description:  Sum of AP, HL, and IB honors attached to 12th grade courses, converted to semester format.
Comment: 
Code Interpretation: 

Warehouse Name - Conv_Semester_Total
Element Name:  Converted Semester Total
Programming Name:  CONV_SEM_TTL
Master Format F5.1
Unique Values: 
Source: Vendor
Define Code: 
Description:  Total high school courses, converted to semester format.
Comment: 
Code Interpretation: 

Warehouse Name - Conv_Total_AG
Element Name:  Converted Total Courses - AG
Programming Name:  CONV_TTL_AG
Master Format F5.1
Unique Values: 
Source: Vendor
Define Code: 
Description:  Total high school courses in A through G subject area, converted to semester format.
Comment: 
Code Interpretation: 

Warehouse Name - Persistence_Status
Element Name:  Persistence Status
Programming Name:  CPERSTATSTD
Master Format A1
Unique Values:  8
Source: Define-MF
Define Code: 
Description:  Code indicating the status of a student based on standard criteria of degrees earned, continued enrollment and academic standing. Note: in DWH, CPERSTATSTD is in fact a redefine with only 3 values: C=continuing, D=Degree Granted, L=left;
Comment: 
Code Interpretation: UNDERGRADUATE:
1 = Degree granted
2 = In academic difficulty - current year
3 = In good standing - current year
4 = In academic difficulty - continuing
5 = In good standing = continuing
6 = In academic difficulty - left
7 = In good standing - left
? = Not classified
A = Current year - academic status unknown
B = Continuing - academic status unknown
C = Left - academic status unknown
GRADUATE:
A = Current year - Doctorate granted
B = Current year - Candidate in Philosophy granted
C = Current year - Advanced to Candidacy and Masters or credential granted
D = Current year - Advanced to Candidacy, no degree granted
E = Current year - Masters granted
F = Current year - Credential granted
G = Current year - Enrolled
H = Continuing - Doctorate granted
I = Continuing - Candidate in Philosophy granted
J = Continuing - Advanced to Candidacy and Masters or credential granted
K = Continuing - Advanced to Candidacy, no degree granted
L = Continuing - Masters granted
M = Continuing - Credential granted
N = Continuing - Enrolled
O = Left - Doctorate granted
P = Left - Candidate in Philosophy granted
Q = Left - Advanced to Candidacy and Masters or credential granted
R = Left - Advanced to Candidacy, no degree granted
S = Left - Masters granted
T = Left - Credential granted
U = Left - Enrolled
Y = Left - Enrolled (Current Year)

Warehouse Name - Previous_Medical_School
Element Name:  Previous Medical School Code
Programming Name:  CPREVMDSCH
Master Format A3
Unique Values:  ~300?
Source: Campus Input
Define Code: 
Description:  Code indicating the school at which medical resident received the M.D. degree.
Comment: 
Code Interpretation: Refer to School Code Table.

Warehouse Name - Source_School_ATP_Code
Element Name:  Source School Code
Programming Name:  CPREVSCH
Master Format A6
Unique Values:  >1000
Source: Define-MF
Define Code: 
Description:  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.
Comment:  "Formerly ""Source School Code (Calif Code)""" Define Code: CPREVSCH = IF ISCH_CHG NE ' ' THEN ISCH_CHG ELSE IF ((CADMCAT EQ '1' OR '2') OR COLUNITP LT 12) AND CHSGRAD NE ' ' THEN CHSGRAD ELSE ILAST_SCH;
Code Interpretation: Refer to School Code Table.

Warehouse Name - Term_Registered
Element Name:  Term Registered
Programming Name:  CQTR
Master Format N/A
Unique Values: 
Source: Campus Input
Define Code: 
Description:  Code indicating the quarter, semester, or session in which the student is registered for classes.
Comment: 
Code Interpretation: 1 = Summer
2 = Fall
3 = Winter
4 = Spring

Warehouse Name - Registered_Summer_term
Element Name:  Registered Summer - 3rd Week
Programming Name:  CQTR1ST
Master Format I1
Unique Values:  2
Source: Define
Define Code:  IF (CREGSTAT3 NE ' ' ) AND (CQTR EQ '1') THEN 1 ELSE 0
Description:  Code indicating whether whether student was enrolled at third week in summer
Comment:  1 = Student enrolled at 3wk summer 0 = not enrolled at 3rd week summer
Code Interpretation: 

Warehouse Name - Registered_Fall_3WK
Element Name:  Registered-Fall 3rd Week
Programming Name:  CQTR2TH
Master Format I1
Unique Values:  2
Source: Define-MF
Define Code: 
Description:  Code indicating that student was registered at third week during the fall term.
Comment: 
Code Interpretation: 1 - Yes
blank - No

Warehouse Name - Registered_Winter_3WK
Element Name:  Registered-Winter 3rd Week
Programming Name:  CQTR3TH
Master Format I1
Unique Values:  2
Source: Define-MF
Define Code: 
Description:  Code indicating that student was registered at third week during the winter term.
Comment: 
Code Interpretation: 1 - Yes
blank - No

Warehouse Name - Registered_Spring_3WK
Element Name:  Registered-Spring 3rd Week
Programming Name:  CQTR4TH
Master Format I1
Unique Values:  2
Source: Define-MF
Define Code: 
Description:  Code indicating that student was registered at third week during the spring term.
Comment: 
Code Interpretation: 1 - Yes
blank - No

Warehouse Name - Term_Applied_Code
Element Name:  Term Applied For
Programming Name:  CQUARTERAP
Master Format A1
Unique Values:  1
Source: Campus Input
Define Code: 
Description:  Code indicating the academic quarter in which the applicant wishes to commence his/her studies.
Comment: 
Code Interpretation: 1 = Summer
2 = Fall
3 = Winter
4 = Spring

Warehouse Name - Units_Credited_By_Exam_AP
Element Name:  Units Credited By Exam - AP
Programming Name:  CREDUAP
Master Format F5.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  Total units credited from Adanced Placement exam to the undergraduate student transcript.
Comment:  Not Provided by Merced in 2007-2008. See REG Problem Log .
Code Interpretation: 

Warehouse Name - Units_Credited_From_CCC
Element Name:  Units Credited From CCC
Programming Name:  CREDUCC
Master Format F5.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  Total units credited from California Community Colleges to the undergraduate student transcript.
Comment:  Not Provided by Merced in 2007-2008. See REG Problem Log .
Code Interpretation: 

Warehouse Name - Units_Credited_By_Exam_IB
Element Name:  Units Credited By Exam - IB
Programming Name:  CREDUIB
Master Format F5.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  Total units credited from International Baccalaureate exam to the undergraduate student transcript.
Comment:  Not Provided by Merced in 2007-2008. See REG Problem Log .
Code Interpretation: 

Warehouse Name - Units_Credited_From_Other_Non_UC
Element Name:  Units Credited From Other Non-UC
Programming Name:  CREDUOT
Master Format F5.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  Total units credited to the undergraduate student transcript from Non-UC Institutions but not from California Community Colleges.
Comment:  Not Provided by Merced in 2007-2008. See REG Problem Log .
Code Interpretation: 

Warehouse Name - Units_Credited_By_Exam_UC
Element Name:  Units Credited By Exam - UC
Programming Name:  CREDUUC
Master Format F5.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  Total units credited from UC exam to the undergraduate student transcript.
Comment:  Not Provided by Merced in 2007-2008. See REG Problem Log .
Code Interpretation: 

Warehouse Name - Registered_Code
Element Name:  Registered Code
Programming Name:  CREGISTER
Master Format A1
Unique Values:  2
Source: Define-MF
Define Code: 
Description:  Code indicating that the applicant has registered at UC.
Comment: 
Code Interpretation: Y = Yes
blank = No

Warehouse Name - Registered_Flag
Element Name:  Registered Flag
Programming Name:  CREGISTERS
Master Format I1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CREGISTER EQ 'Y' THEN 1 ELSE 0;
Description:  Flag indicating student registered at a UC campus.
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Registration_Status_Code_3WK
Element Name:  Registration Status Code-3rd Week
Programming Name:  CREGSTAT3
Master Format A1
Unique Values:  3
Source: Campus Input
Define Code: 
Description:  Code indicating registration status of the student as of the end of the third week of classes (official census enrollment date).
Comment: 
Code Interpretation: N = New, first enrollment on campus
C = Continuing at same campus
R = Re-entrant to same campus
V = Visiting non-UC student (Computed by UCOP -Summer only)
P = Fall pre-admit (Computed by UCOP - Summer only)
W = Withdrawn (EOT only)

Warehouse Name - Registration_Status_Code_EOT
Element Name:  Registration Status Code-End of Term
Programming Name:  CREGSTATE
Master Format A1
Unique Values:  3
Source: Campus Input
Define Code: 
Description:  Code indicating registration status of the student as of the end of the term.
Comment: 
Code Interpretation: N = New, first enrollment on campus
C = Continuing at same campus
R = Re-entrant to same campus
V = Visiting non-UC student (Computed by UCOP -Summer only)
P = Fall pre-admit (Computed by UCOP - Summer only)
W = Withdrawn (EOT only)

Warehouse Name - Registration_Status_Code_Fall
Element Name:  Registration Status Code-Fall
Programming Name:  CREGSTATF
Master Format A1
Unique Values:  3
Source: Define-MF
Define Code: 
Description:  Code indicating registration status of the student as of the fall term.
Comment: 
Code Interpretation: N = New, first enrollment on campus
C = Continuing at same campus
R = Re-entrant to same campus
V = Visiting non-UC student (Computed by UCOP -Summer only)
P = Fall pre-admit (Computed by UCOP - Summer only)
W = Withdrawn (EOT only)

Warehouse Name - Registration_Status_Code_EOT_Wdr
Element Name:  Registration Status Code-Prior To Withdrawal
Programming Name:  CREGSTATP
Master Format A1
Unique Values:  4
Source: Campus Input
Define Code: 
Description:  Code indicating registration status of the student prior to withdrawal, if both registration and subsequent withdrawal occurred after the end of the third week of classes.
Comment: 
Code Interpretation: N = New, first enrollment on campus
C = Continuing at same campus
R = Re-entrant to same campus
V = Visiting non-UC student (Computed by UCOP -Summer only)
P = Fall pre-admit (Computed by UCOP - Summer only)
W = Withdrawn (EOT only)

Warehouse Name - Registration_Status_Code_Winter
Element Name:  Registration Status Code-Spring
Programming Name:  CREGSTATS
Master Format A1
Unique Values:  3
Source: Define-MF
Define Code: 
Description:  Code indicating registration status of the student as of the spring term.
Comment: 
Code Interpretation: N = New, first enrollment on campus
C = Continuing at same campus
R = Re-entrant to same campus
V = Visiting non-UC student (Computed by UCOP -Summer only)
P = Fall pre-admit (Computed by UCOP - Summer only)
W = Withdrawn (EOT only)

Warehouse Name - Registration_Status_Code_Summer
Element Name:  Registration Status Code-Summer
Programming Name:  CREGSTATSU
Master Format A1
Unique Values:  3
Source: Define-MF
Define Code: 
Description:  Code indicating registration status of the student as of the summer term. reflects end of term status if there, third week status otherwise.
Comment: 
Code Interpretation: N = New, first enrollment on campus
C = Continuing at same campus
R = Re-entrant to same campus
V = Visiting non-UC student (Computed by UCOP -Summer only)
P = Fall pre-admit (Computed by UCOP - Summer only)
W = Withdrawn (EOT only)

Warehouse Name - Registration_Status_Code_Spring
Element Name:  Registration Status Code-Winter
Programming Name:  CREGSTATW
Master Format A1
Unique Values:  3
Source: Define-MF
Define Code: 
Description:  Code indicating registration status of the student as of the winter term.
Comment: 
Code Interpretation: N = New, first enrollment on campus
C = Continuing at same campus
R = Re-entrant to same campus
V = Visiting non-UC student (Computed by UCOP -Summer only)
P = Fall pre-admit (Computed by UCOP - Summer only)
W = Withdrawn (EOT only)

Warehouse Name - Counselor_Release_Flag
Element Name:  Counselor Release Flag
Programming Name:  CREL
Master Format A1
Unique Values:  3
Source: ETS
Define Code: 
Description:  Code indicating the applicant has authorized release of information to school or college counselor/counseling office.
Comment: 
Code Interpretation: Y = Yes
blank = No

Warehouse Name - SIR_Code
Element Name:  SIR Response Code
Programming Name:  CSIR
Master Format A1
Unique Values:  7
Source: Define-MF
Define Code: 
Description:  Code indicating applicant's response to offer of admission (Statement of Intention to Register).
Comment: 
Code Interpretation: 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)

Warehouse Name - Authorizing_Agency_Code
Element Name:  Authorizing Agency Code
Programming Name:  CSOURCE
Master Format A1
Unique Values:  8
Source: X-Reference
Define Code: 
Description:  Code indicating the authorizing agency of the financial aid award that has been made to a student.
Comment: 
Code Interpretation: 1 = Federal Government
2 = State of CA Government
3 = Other Government
4 = UCOP
5 = UC campus
6 = Outside Agency = For-profit
7 = Outside Agency = Non-profit
8 = Outside Agency = Individual

Warehouse Name - Resident_Specialty_Code
Element Name:  Specialty Code-Residents
Programming Name:  CSPECIALTY
Master Format A2
Unique Values:  ~30
Source: Campus Input
Define Code: 
Description:  Code indicating specialty for medical residents.
Comment: 
Code Interpretation: 04 = Medicine - Other
05 = Medicine - Flexible
06 = Medicine - Allergy and Immunology
07 = Medicine - Anesthesiology
08 = Medicine - Colon and Rectal Surgery
09 = Medicine - Dermatology
10 = Medicine - Emergency Medicine
11 = Medicine - Family Practice
12 = Medicine - Internal Medicine
13 = Medicine - Medical Specialist
14 = Medicine - Neurology
15 = Medicine - Neurology with Special Competence in Child Neurology
16 = Medicine - Neurological Surgery
17 = Medicine - Nuclear Medicine
18 = Medicine - Obstetrics and Gynecology
19 = Medicine - Opthalmology
20 = Medicine - Orthopedic Surgery
21 = Medicine - Otolaryngology
22 = Medicine - Pathology
23 = Medicine - Pediatrics
24 = Medicine - Pediatric Specialty
25 = Medicine - Physical Medicine and Rehabilitation
26 = Medicine - Plastic Surgery
27 = Medicine - Psychiatry
28 = Medicine - Child Psychiatry
29 = Medicine - Diagnostic Radiology
30 = Medicine - Therapeutic Radiology/Radiation Oncology
31 = Medicine - General Surgery
32 = Medicine - Thoracic Surgery
33 = Medicine - Vascular Surgery
34 = Medicine - Urology

Warehouse Name - Sponsor_Category_Code
Element Name:  Sponsor Category Code
Programming Name:  CSPONCAT
Master Format A02
Unique Values: 
Source: AFPFUND file
Define Code: 
Description:  Code indicating the type of organization sponsoring an extramurally-funded project:
Comment: 
Code Interpretation: '01' Federal Government
'02' State Government
'03' Other Government Agency
'04' Business/Profit Entity
'05' Non-Profit, Business-Related
'06' Foundation/Charitable Trust
'07' Other Charitable Organization
'08' Higher Education Institution/Association
'09' Campus-Related Organization
'10' Individual
'11' UC Foundation
'12' Marketing orders
'13' Major UC DOE laboratories (LBL, LLNL, LANL)
' ' Unknown/to be assigned

Warehouse Name - Source_School_Name
Element Name:  Source School Name
Programming Name:  CSRCNAME
Master Format A35
Unique Values:  >1000
Source: X-Reference
Define Code: 
Description:  Name of the school of origin attributed to the undergraduate applicant.
Comment: 
Code Interpretation: 

Warehouse Name - Source_School_ATP_Code
Element Name:  Source School ATP Code
Programming Name:  CSRCSCH
Master Format A6
Unique Values:  >1000
Source: Rename
Define Code: 
Description:  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.
Comment:  Formerly Source School Code (Calif Code).
Code Interpretation: Refer to School Code Table.

Warehouse Name - Source_of_Support_Code
Element Name:  Source of Support Code
Programming Name:  CSRCSUP
Master Format A2
Unique Values: 
Source: Campus Input
Define Code: 
Description:  Code indicating the primary source of support for a postdoctoral scholar.
Comment: 
Code Interpretation: 01 = Federal government
02 = State/Local government
03 = Private agency/business or industry
04 = UC Campus/Institutional funds
05 = Foreign government
06 = Self-supporting
07 = Other

Warehouse Name - Student_Level_Code_3WK
Element Name:  Student Level Code-3rd Week
Programming Name:  CSTUDLVL3
Master Format A1
Unique Values:  12
Source: Campus Input
Define Code: 
Description:  Code indicating level (or progress) within degree program, as of the end of the 3rd week of classes. If not enrolled in a degree program, the student's academic status.
Comment: 
Code Interpretation: 1 = Freshman (0 to 44.9 completed units)
2 = Sophomore (45.0 to 89.9 completed units)
3 = Junior (90.0 to 134.9 completed units)
4 = Senior (135.0 or more completed units)
S = Special
L = Limited
P = Postbaccalaureate: student holds a baccalaureate degree and sole degree objective is teacher education credential.
5 = Masters: Degree objective is academic or professional masters, certification credential, non-doctoral first professional degree (e.g., JD), or no degree objective. Includes students enrolled in joint masters and teacher eduacation credential programs, but not students whose sole objective is a teacher credential.
6 = Doctoral 1: Degree objective is academic or professional doctorate, but student has not been advanced to candidacy.
7 = Doctoral 2: Degree objective is academic or professional doctorate, and student has been advanced to candidacy (enrolled 9 quarters or less).
8 = Doctoral 2A: Student enrolled for more than 9 quarters (6 semesters) as Doctoral 2.
R = Resident

Warehouse Name - Student_Level_Code_3WK_L
Element Name:  Student Level Code-3rd Week-Label
Programming Name:  CSTUDLVL3L
Master Format 
Unique Values:  11
Source: Define-DWH
Define Code: 
Description:  Name for code indicating level (or progress) within degree program, as of the end of the 3rd week of classes. If not enrolled in a degree program, the student's academic status.
Comment: 
Code Interpretation: 

Warehouse Name - Student_Level_Code_3WK_S
Element Name:  Student Level Code-3rd Week-Sort
Programming Name:  CSTUDLVL3S
Master Format 
Unique Values:  11
Source: Define-DWH
Define Code: 
Description:  Sort element for code indicating level (or progress) within degree program, as of the end of the 3rd week of classes. If not enrolled in a degree program, the student's academic status.
Comment: 
Code Interpretation: A = Freshman
B = Sophomore
C = Special
D = Junior
E = Senior
F = Limited
G = Postbaccalaureate
H = Masters
I = Doctoral 1
J = Doctoral 2
K = Doctoral 2A
L = Resident

Warehouse Name - Student_Level_Code_EOT
Element Name:  Student Level Code-End of Term
Programming Name:  CSTUDLVLE
Master Format A1
Unique Values:  12
Source: Campus Input
Define Code: 
Description:  Code indicating level (or progress) within degree program as of the end of the specified term. If not enrolled in a degree program, the student's academic status.
Comment: 
Code Interpretation: 1 = Freshman (0 to 44.9 completed units)
2 = Sophomore (45.0 to 89.9 completed units)
3 = Junior (90.0 to 134.9 completed units)
4 = Senior (135.0 or more completed units)
S = Special
L = Limited
P = Postbaccalaureate: student holds a baccalaureate degree and sole degree objective is teacher education credential.
5 = Masters: Degree objective is academic or professional masters, certification credential, non-doctoral first professional degree (e.g., JD), or no degree objective. Includes students enrolled in joint masters and teacher eduacation credential programs, but not students whose sole objective is a teacher credential.
6 = Doctoral 1: Degree objective is academic or professional doctorate, but student has not been advanced to candidacy.
7 = Doctoral 2: Degree objective is academic or professional doctorate, and student has been advanced to candidacy (enrolled 9 quarters or less).
8 = Doctoral 2A: Student enrolled for more than 9 quarters (6 semesters) as Doctoral 2.
R = Resident

Warehouse Name - Student_Level_Code_Fall
Element Name:  Student Level Code-Fall
Programming Name:  CSTUDLVLF
Master Format A1
Unique Values:  12
Source: Define-MF
Define Code: 
Description:  Code indicating level (or progress) within degree program, as of the Fall term. If not enrolled in a degree program, the student's academic status.
Comment: 
Code Interpretation: 1 = Freshman (0 to 44.9 completed units)
2 = Sophomore (45.0 to 89.9 completed units)
3 = Junior (90.0 to 134.9 completed units)
4 = Senior (135.0 or more completed units)
S = Special
L = Limited
P = Postbaccalaureate: student holds a baccalaureate degree and sole degree objective is teacher education credential.
5 = Masters: Degree objective is academic or professional masters, certification credential, non-doctoral first professional degree (e.g., JD), or no degree objective. Includes students enrolled in joint masters and teacher eduacation credential programs, but not students whose sole objective is a teacher credential.
6 = Doctoral 1: Degree objective is academic or professional doctorate, but student has not been advanced to candidacy.
7 = Doctoral 2: Degree objective is academic or professional doctorate, and student has been advanced to candidacy (enrolled 9 quarters or less).
8 = Doctoral 2A: Student enrolled for more than 9 quarters (6 semesters) as Doctoral 2.
R = Resident

Warehouse Name - Student_Level_Code_Spring
Element Name:  Student Level Code-Spring
Programming Name:  CSTUDLVLS
Master Format A1
Unique Values:  12
Source: Define-MF
Define Code: 
Description:  Code indicating level (or progress) within degree program, as of the spring term. If not enrolled in a degree program, the student's academic status.
Comment: 
Code Interpretation: 1 = Freshman (0 to 44.9 completed units)
2 = Sophomore (45.0 to 89.9 completed units)
3 = Junior (90.0 to 134.9 completed units)
4 = Senior (135.0 or more completed units)
S = Special
L = Limited
P = Postbaccalaureate: student holds a baccalaureate degree and sole degree objective is teacher education credential.
5 = Masters: Degree objective is academic or professional masters, certification credential, non-doctoral first professional degree (e.g., JD), or no degree objective. Includes students enrolled in joint masters and teacher eduacation credential programs, but not students whose sole objective is a teacher credential.
6 = Doctoral 1: Degree objective is academic or professional doctorate, but student has not been advanced to candidacy.
7 = Doctoral 2: Degree objective is academic or professional doctorate, and student has been advanced to candidacy (enrolled 9 quarters or less).
8 = Doctoral 2A: Student enrolled for more than 9 quarters (6 semesters) as Doctoral 2.
R = Resident

Warehouse Name - Student_Level_Code_Summer
Element Name:  Student Level Code-Summer
Programming Name:  CSTUDLVLSU
Master Format A1
Unique Values:  12
Source: Define-MF
Define Code: 
Description:  Code indicating level (or progress) within degree program, as of the Summer term. If not enrolled in a degree program, the student's academic status. Reflects end of term status if present, thrid week status otherwise.
Comment: 
Code Interpretation: 1 = Freshman (0 to 44.9 completed units)
2 = Sophomore (45.0 to 89.9 completed units)
3 = Junior (90.0 to 134.9 completed units)
4 = Senior (135.0 or more completed units)
S = Special
L = Limited
P = Postbaccalaureate: student holds a baccalaureate degree and sole degree objective is teacher education credential.
5 = Masters: Degree objective is academic or professional masters, certification credential, non-doctoral first professional degree (e.g., JD), or no degree objective. Includes students enrolled in joint masters and teacher eduacation credential programs, but not students whose sole objective is a teacher credential.
6 = Doctoral 1: Degree objective is academic or professional doctorate, but student has not been advanced to candidacy.
7 = Doctoral 2: Degree objective is academic or professional doctorate, and student has been advanced to candidacy (enrolled 9 quarters or less).
8 = Doctoral 2A: Student enrolled for more than 9 quarters (6 semesters) as Doctoral 2.
R = Resident

Warehouse Name - Student_Level_Code_Winter
Element Name:  Student Level Code-Winter
Programming Name:  CSTUDLVLW
Master Format A1
Unique Values:  12
Source: Define-MF
Define Code: 
Description:  Code indicating level (or progress) within degree program, as of the winter term. If not enrolled in a degree program, the student's academic status.
Comment: 
Code Interpretation: 1 = Freshman (0 to 44.9 completed units)
2 = Sophomore (45.0 to 89.9 completed units)
3 = Junior (90.0 to 134.9 completed units)
4 = Senior (135.0 or more completed units)
S = Special
L = Limited
P = Postbaccalaureate: student holds a baccalaureate degree and sole degree objective is teacher education credential.
5 = Masters: Degree objective is academic or professional masters, certification credential, non-doctoral first professional degree (e.g., JD), or no degree objective. Includes students enrolled in joint masters and teacher eduacation credential programs, but not students whose sole objective is a teacher credential.
6 = Doctoral 1: Degree objective is academic or professional doctorate, but student has not been advanced to candidacy.
7 = Doctoral 2: Degree objective is academic or professional doctorate, and student has been advanced to candidacy (enrolled 9 quarters or less).
8 = Doctoral 2A: Student enrolled for more than 9 quarters (6 semesters) as Doctoral 2.
R = Resident

Warehouse Name - Student_Level_Year_1
Element Name:  Student Level Year-1
Programming Name:  CSTUDLVL_1
Master Format A1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Student level, as of the first term enrolled during the first year.
Comment: 
Code Interpretation: 

Warehouse Name - Student_Level_Year_2
Element Name:  Student Level Year-2
Programming Name:  CSTUDLVL_2
Master Format A1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Student level, as of the first term enrolled during the second year.
Comment: 
Code Interpretation: 

Warehouse Name - Student_Level_Year_3
Element Name:  Student Level Year-3
Programming Name:  CSTUDLVL_3
Master Format A1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Student level, as of the first term enrolled during the third year.
Comment: 
Code Interpretation: 

Warehouse Name - Student_Level_Year_4
Element Name:  Student Level Year-4
Programming Name:  CSTUDLVL_4
Master Format A1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Student level, as of the first term enrolled during the fourth year.
Comment: 
Code Interpretation: 

Warehouse Name - Student_Level_Year_5
Element Name:  Student Level Year-5
Programming Name:  CSTUDLVL_5
Master Format A1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Student level, as of the first term enrolled during the fifth year.
Comment: 
Code Interpretation: 

Warehouse Name - Student_Level_Year_6
Element Name:  Student Level Year-6
Programming Name:  CSTUDLVL_6
Master Format A1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Student level, as of the first term enrolled during the sixth year.
Comment: 
Code Interpretation: 

Warehouse Name - Student_Level_Year_7
Element Name:  Student Level Year-7
Programming Name:  CSTUDLVL_7
Master Format A1
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Student level, as of the first term enrolled during the seventh year.
Comment: 
Code Interpretation: 

Warehouse Name - Sub_Super_Agency_Code
Element Name:  Sub Super Agency Code
Programming Name:  CSUBAGENCY
Master Format A2
Unique Values: 
Source: AFPFUND file
Define Code: 
Description: 
Comment: 
Code Interpretation: 

Warehouse Name - SubjectA_Requirement_Met
Element Name:  Subject A Requirement Code
Programming Name:  CSUBJAR
Master Format A1
Unique Values:  9
Source: Define-MF
Define Code: 
Description:  Code indicating the means by which an applicant satisfied the Subject A requirement.
Comment:  Effective for Fall 1997 applicants, code value 1 represents a SAT II score of 660 or greater, effective Fall 1998, it will represent a score of 680 or greater. Because of a campus coding problem, this data item is unreliable in UAD for Fall 2006. See UAD Problem Log
Code Interpretation: 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)

Warehouse Name - SubjectA_Requirement_Met_Reg
Element Name:  Subject A Requirement Met - Campus Reg
Programming Name:  CSUBJARR
Master Format A2
Unique Values: 
Source: Define-DWH
Define Code:  IF CREGISTER EQ 'Y' THEN CSUBJAR ELSE ' ';
Description:  Code indicating the means by which an applicant satisfied the Subject A requirement at the campus registered.
Comment:  Because of a campus coding problem, this data item is unreliable in UAD for Fall 2006. See UAD Problem Log
Code Interpretation: 

Warehouse Name - Term_Registered_Code
Element Name:  Term Registered Code
Programming Name:  CTERM
Master Format A1
Unique Values:  4
Source: Campus Input
Define Code: 
Description:  Code indicating the quarter, semester, or session in which the student is registered for classes.
Comment: 
Code Interpretation: 1 = Summer
2 = Fall
3 = Winter
4 = Spring

Warehouse Name - Term_Entered_Code
Element Name:  Term Entered UC
Programming Name:  CTERMENTR
Master Format A1
Unique Values:  3
Source: Define-MF
Define Code: 
Description:  Quarter/Semester in which the student first enrolled in a graduate or undergraduate program. Note: A student may be admitted several times. In the ADMISS table, this will result in several rows, each with a different year/term entered.
Comment: 
Code Interpretation: 1 = Summer
2 = Fall
3 = Winter
4 = Spring

Warehouse Name - Award_Type_Code
Element Name:  Award Type Code
Programming Name:  CTYPE
Master Format A1
Unique Values:  7
Source: X-Reference
Define Code: 
Description:  Code indicating type of financial aid award that has been made to a student.
Comment: 
Code Interpretation: 1 = Scholarship/Fellowship/Traineeship
2 = Grants
3 = Loans
4 = Work Study
5 = RA/TA Remission
6 = Earnings
7 = Other

Warehouse Name - Undergraduate_School_ATP_Code
Element Name:  Undergraduate School ATP Code
Programming Name:  CUGDEGSCH
Master Format A6
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Code indicating the institution awarding a graduate applicant's undergraduate degree.
Comment:  Refer to Schools - High Schools and Colleges in CSS Code Tables.
Code Interpretation: 

Warehouse Name - Current_Phone_Number
Element Name:  Current Phone Number
Programming Name:  CURRPHONE
Master Format A10
Unique Values:  >1000
Source: ETS
Define Code: 
Description:  Area code and telephone number the individual has designated for receipt of calls from the University.
Comment: 
Code Interpretation: 

Warehouse Name - Deactivation_Year
Element Name:  Deactivation Year
Programming Name:  DEACTYEAR
Master Format A4
Unique Values:  >100
Source: CSX Web application
Define Code: 
Description:  Academic year a program/major was deactivated. ex: 2005 = program was no longer offered in 2005-2006.
Comment: 
Code Interpretation: 

Warehouse Name -
Element Name:  Award Deactivation Year
Programming Name:  DEACTYEAR FAI
Master Format A4
Unique Values: 
Source: SFS
Define Code: 
Description:  Code indicating the academic year when an award was de-activated (ex 2000 = AY 2000-2001). Blank if award is still active.
Comment:  Field added May 2004.
Code Interpretation: 

Warehouse Name - Deferment_Flag
Element Name:  Deferment Flag
Programming Name:  DEFERFLAG
Master Format I1
Unique Values:  3
Source: Define-MF
Define Code: 
Description:  Code indicating applicant has been deferred or not retained on at least one campus and has not been retained or admitted on any campus.
Comment: 
Code Interpretation: Y = Yes
N = No

Warehouse Name - Deferred_by_College_Flag
Element Name:  Deferred by College Flag
Programming Name:  DEFNRETFLAG
Master Format I1
Unique Values:  3
Source: Define-MF
Define Code: 
Description:  No longer used?
Comment: 
Code Interpretation: Y = Yes
N = No

Warehouse Name - Doctoral_Institution_2_Location_Name
Element Name:  Doctoral Institution 2 Location Name
Programming Name:  DEG2LOCNME
Master Format A28
Unique Values: 
Source: X-Reference
Define Code: 
Description:  Location name for the institution awarding the second doctoral degree to the postdoctoral scholar.
Comment: 
Code Interpretation: 

Warehouse Name - Degree_Awarded_Category
Element Name:  Degree Awarded Category
Programming Name:  DEGCAT
Master Format 
Unique Values:  11
Source: Define-DWH
Define Code: 
Description:  Code indicating degree awarded in categories used in the Statistical Summary. Recode of CDEGREE.
Comment: 
Code Interpretation: A = Bachelor
B = Master
C = Doctor
D = Cand. In Philosophy
E = Engineer
F = Juris Doctor
G = Doctor of Dental Surgery
H = Doctor of Medicine
I = Doctor of Optometry
J = Doctor of Veterinary Medicine
K = Doctor of Pharmacy
L = Credentials and Certificates
M=Doctor of Physical Therapy
O=Doctor of Audiology

Warehouse Name - Degree_Awarded_Category_L
Element Name:  Degree Awarded Category-Label
Programming Name:  DEGCATLAB
Master Format 
Unique Values:  11
Source: Define-DWH
Define Code: 
Description:  Name of degree category for degree awarded in categories used in the Statistical Summary. Recode of CDEGREE.
Comment: 
Code Interpretation: 

Warehouse Name - Degree_Category_Name_Proposed
Element Name:  Degree Category Name Proposed
Programming Name:  DEGCATLABP
Master Format A4
Unique Values:  12
Source: Define-DWH
Define Code: 
Description:  Name of the degree category for which the applicant has applied; or, the first degree program of a joint or concurrent degree program to which the applicant has applied.
Comment: 
Code Interpretation: 

Warehouse Name - Degree_Category_Name_Proposed_2
Element Name:  Degree Category Name Proposed-2
Programming Name:  DEGCATLABP2
Master Format A4
Unique Values:  14
Source: Define-DWH
Define Code: 
Description:  Name of the degree category for which the applicant has applied; or, the first degree program of a joint or concurrent degree program to which the applicant has applied.
Comment:  Includes Ed.D. and M.B.A. as separate categories.
Code Interpretation: 

Warehouse Name - Degree_Category_Code_Proposed
Element Name:  Degree Category Code Proposed
Programming Name:  DEGCATP
Master Format A1
Unique Values:  12
Source: Define-DWH
Define Code: 
Description:  Code indicating the degree category for which the applicant has applied; or, the first degree program of a joint or concurrent degree program to which the applicant has applied.
Comment: 
Code Interpretation: A = Bachelor
B = Master
C = Doctor
D = Cand. In Philosophy
E = Engineer
F = Juris Doctor
G = Doctor of Dental Surgery
H = Doctor of Medicine
I = Doctor of Optometry
J = Doctor of Veterinary Medicine
K = Doctor of Pharmacy
L = Credentials and Certificates
M=Doctor of Physical Therapy
O=Doctor of Audiology

Warehouse Name - College_Name_Degree
Element Name:  College Name for Degree Awarded
Programming Name:  DEGCOL
Master Format A38
Unique Values:  ~65
Source: X-Reference
Define Code: 
Description:  Name of the administrative unit above department level and below campus level associated with the academic program in which student was awarded U.C. degree.
Comment: 
Code Interpretation: 

Warehouse Name - College_Name_Degree_1
Element Name:  College Name Degree-1
Programming Name:  DEGCOL_1
Master Format A38
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Name of the college or school in which the student earned the first baccalaureate degree.
Comment: 
Code Interpretation: 

Warehouse Name - Major_Name_Degree
Element Name:  Major Name for Degree Awarded
Programming Name:  DEGMAJ
Master Format A25
Unique Values:  >1000
Source: X-Reference
Define Code: 
Description:  Name of the academic program (Major) in which student was awarded U.C. degree.
Comment: 
Code Interpretation: 

Warehouse Name - Major_Name_Degree_1
Element Name:  Major Name Degree-1
Programming Name:  DEGMAJ_1
Master Format A25
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Name of the major field of study in which the student earned the first baccalaureate degree.
Comment: 
Code Interpretation: 

Warehouse Name - Degree_Program_Code
Element Name:  Degree Program Code
Programming Name:  DEGPGM
Master Format A2
Unique Values:  ~75
Source: Copy of DEGPGM1
Define Code: 
Description:  Code indicating the degree program in which the student is enrolled.
Comment: 
Code Interpretation: Refer to Degree Code Table.

Warehouse Name - Degree_Program_Code_1
Element Name:  Degree Program Code-1
Programming Name:  DEGPGM1
Master Format A2
Unique Values:  ~75
Source: Campus Input
Define Code: 
Description:  Code indicating the degree program in which the student has been admitted or enrolled; or, the first degree program of a joint or concurrent degree program in which the student has been admitted or enrolled.
Comment: 
Code Interpretation: Refer to Degree Code Table.

Warehouse Name - Degree_Program_Abbr_1
Element Name:  Degree Program Abbreviation-1
Programming Name:  DEGPGM1ABBR
Master Format A9
Unique Values: 
Source: X-Reference
Define Code: 
Description:  The abbreviated name of the degree program in which the student has been admitted or enrolled
Comment:  Degree Abbreviation
Code Interpretation: 

Warehouse Name - Degree_Program_Name_1
Element Name:  Degree Program Name-1
Programming Name:  DEGPGM1NM
Master Format A50
Unique Values:  ~75
Source: X-Reference
Define Code: 
Description:  The name of the first degree program in which the student has been admitted or enrolled; or, the name of the first degree program of a joint or concurrent degree program in which the student has been admitted or enrolled.
Comment: 
Code Interpretation: 

Warehouse Name - Degree_Program_Code_2
Element Name:  Degree Program Code-2
Programming Name:  DEGPGM2
Master Format A2
Unique Values:  72
Source: Campus Input
Define Code: 
Description:  Code indicating the second degree program in which the student has been admitted or enrolled, if enrolled in a joint or concurrent degree program.
Comment: 
Code Interpretation: Refer to Degree Code Table.

Warehouse Name - Degree_Program_Abbr_2
Element Name:  Degree Program Abbreviation-2
Programming Name:  DEGPGM2ABBR
Master Format A9
Unique Values: 
Source: X-Reference
Define Code: 
Description:  The abbreviated name of the degree program in which the student has been admitted or enrolled
Comment:  Degree Abbreviation
Code Interpretation: 

Warehouse Name - Degree_Program_Name_2
Element Name:  Degree Program Name-2
Programming Name:  DEGPGM2NM
Master Format A50
Unique Values:  ~75
Source: X-Reference
Define Code: 
Description:  The name of the second degree program in which the student has been admitted or enrolled, if enrolled in a joint or concurrent degree program.
Comment: 
Code Interpretation: 

Warehouse Name - Degree_Program_Code_3
Element Name:  Degree Program Code-3
Programming Name:  DEGPGM3
Master Format A2
Unique Values:  72
Source: Campus Input
Define Code: 
Description:  Code indicating the third degree program in which the student has been admitted or enrolled, if enrolled in a joint or concurrent degree program.
Comment: 
Code Interpretation: Refer to Degree Code Table.

Warehouse Name - Degree_Program_Abbr_3
Element Name:  Degree Program Abbreviation-3
Programming Name:  DEGPGM3ABBR
Master Format A9
Unique Values: 
Source: X-Reference
Define Code: 
Description:  The abbreviated name of the degree program in which the student has been admitted or enrolled
Comment:  Degree Abbreviation
Code Interpretation: 

Warehouse Name - Degree_Program_Name_3
Element Name:  Degree Program Name-3
Programming Name:  DEGPGM3NM
Master Format A50
Unique Values:  ~75
Source: X-Reference
Define Code: 
Description:  The name of the third degree program in which the student has been admitted or enrolled, if enrolled in a joint or concurrent degree program.
Comment: 
Code Interpretation: 

Warehouse Name -
Element Name:  Term Degree Awarded
Programming Name:  DEGQTR
Master Format N/A
Unique Values: 
Source: Campus Input
Define Code: 
Description:  Code indicating the academic term during which the student was awarded a degree.
Comment: 
Code Interpretation: 1 = Summer
2 = Fall
3 = Winter
4 = Spring

Warehouse Name - Degree_Awarded_Name
Element Name:  Degree Awarded Name
Programming Name:  DEGREE
Master Format A50
Unique Values:  ~75
Source: X-Reference
Define Code: 
Description:  Name of the degree awarded by U.C.
Comment: 
Code Interpretation: 

Warehouse Name - Degree_Program_Name_1
Element Name:  Degree Program Name-1
Programming Name:  DEGREE1
Master Format A50
Unique Values:  72
Source: X-Reference
Define Code: 
Description:  The name of the first degree program in which the student has been admitted or enrolled; or, the name of the first degree program of a joint or concurrent degree program in which the student has been admitted or enrolled.
Comment: 
Code Interpretation: 

Warehouse Name - Degree_Program_Name_2
Element Name:  Degree Program Name-2
Programming Name:  DEGREE2
Master Format A50
Unique Values:  72
Source: X-Reference
Define Code: 
Description:  The name of the second degree program in which the student has been admitted or enrolled, if enrolled in a joint or concurrent degree program.
Comment: 
Code Interpretation: Refer to Degree Code Table.

Warehouse Name - Degree_Program_Name_3
Element Name:  Degree Program Name-3
Programming Name:  DEGREE3
Master Format A50
Unique Values:  72
Source: X-Reference
Define Code: 
Description:  The name of the third degree program in which the student has been admitted or enrolled, if enrolled in a joint or concurrent degree program.
Comment: 
Code Interpretation: 

Warehouse Name - Degree_Program_Abbr_1
Element Name:  Degree Program Abbreviation-1
Programming Name:  DEGREEABB1
Master Format A9
Unique Values:  or the abbreviated
Source: X-Reference
Define Code: 
Description:  The abbreviated name of the degree program in which the student has been admitted or enrolled
Comment:  Degree Abbreviation
Code Interpretation: 

Warehouse Name - Degree_Program_Abbr_2
Element Name:  Degree Program Abbreviation-2
Programming Name:  DEGREEABB2
Master Format A9
Unique Values:  72
Source: X-Reference
Define Code: 
Description:  The abbreviated name of the second degree program in which the student has been admitted or enrolled, if enrolled in a joint or concurrent degree program.
Comment: 
Code Interpretation: Refer to Degree Code Table.

Warehouse Name - Degree_Program_Abbr_3
Element Name:  Degree Program Abbreviation-3
Programming Name:  DEGREEABB3
Master Format A9
Unique Values:  72
Source: X-Reference
Define Code: 
Description:  The abbreviated name of the third degree program in which the student has been admitted or enrolled, if enrolled in a joint or concurrent degree program.
Comment: 
Code Interpretation: Refer to Degree Code Table.

Warehouse Name - Degree_Awarded_Abbr
Element Name:  Degree Awarded Abbreviated Name
Programming Name:  DEGREEABBR
Master Format A9
Unique Values:  ~75
Source: X-Reference
Define Code: 
Description:  The abbreviated name of the degree awarded by U.C.
Comment: 
Code Interpretation: Refer to Degree Code Table.

Warehouse Name - Degree_Program_Name
Element Name:  Degree Program Name
Programming Name:  DEGREEP
Master Format A50
Unique Values:  72
Source: X-Reference
Define Code: 
Description:  The name of the degree program in which the student is enrolled.
Comment: 
Code Interpretation: 

Warehouse Name - Degree_Program_Abbr
Element Name:  Degree Program Abbreviation
Programming Name:  DEGREEPABB
Master Format A9
Unique Values:  72
Source: X-Reference
Define Code: 
Description:  The abbreviated name of the degree program in which the student is enrolled or the abbreviated name of the first degree program of a joint or concurrent degree program in which the student is enrolled.
Comment: 
Code Interpretation: Refer to Degree Code Table.

Warehouse Name - Degree_Term
Element Name:  Degree Term
Programming Name:  DEGTERM
Master Format A1
Unique Values:  4
Source: Define MF
Define Code: 
Description:  Code indicating the quarter, semester, or session in which the student obtained the degree recorded in the Undergraduate Longitudinal database.
Comment: 
Code Interpretation: 1 = Summer
2 = Fall
3 = Winter
4 = Spring

Warehouse Name -
Element Name:  Year Degree Awarded
Programming Name:  DEGYR
Master Format N/A
Unique Values: 
Source: Campus Input
Define Code: 
Description:  The year in which the student was awarded a degree.
Comment: 
Code Interpretation: 

Warehouse Name - Household_Size
Element Name:  Household Size
Programming Name:  DEPEND
Master Format I1
Unique Values:  <20
Source: Campus Input
Define Code: 
Description:  The number of people dependent on the student, including the student, his or her spouse, and the children of the student and the spouse if they receive more than half of their support from the student. Also includes other people if they currently live with the student, get more than half their support from the student, and will continue to receive this support between July 1 and June 30 of the academic year. Missing student household size values should be reported as 'blank' in the field.
Comment:  Formerly Number of Dependents.
Code Interpretation: 

Warehouse Name - Household_Size_Flag
Element Name:  Household Size Flag
Programming Name:  DEPENDFLG
Master Format A1
Unique Values:  2
Source: Define-MF
Define Code: 
Description:  Flag indicator for Household Size element to distinguish values that are real zeroes from those which are blank or missing.
Comment: 
Code Interpretation: R = Real Zero
M= Missing

Warehouse Name - Dependents_Applicant
Element Name:  Dependents of Applicant
Programming Name:  DEPEND_APP
Master Format F2
Unique Values:  <20
Source: ETS
Define Code: 
Description:  Family size of independent student, including applicant, spouse, and other dependents, in calendar year preceding academic year.
Comment: 
Code Interpretation: 

Warehouse Name - Dependents_Applicant_Previous
Element Name:  Dependents of Applicant - Previous Year
Programming Name:  DEPEND_APP_PR
Master Format F2
Unique Values:  <20
Source: ETS
Define Code: 
Description:  Family size of independent student, including applicant, spouse, and other dependents, in calendar year preceding academic year.
Comment:  Added for fall 2002 applicants.
Code Interpretation: 

Warehouse Name - Dependents_Parents
Element Name:  Dependents of Parents of Applicant
Programming Name:  DEPEND_PAR
Master Format F2
Unique Values:  <20
Source: ETS
Define Code: 
Description:  Family size of dependent student, including applicant, parents, and other dependents, in calendar year preceding academic year.
Comment: 
Code Interpretation: 

Warehouse Name - Dependents_Parents_Previous
Element Name:  Dependents of Parents of Applicant - Previous Year
Programming Name:  DEPEND_PAR_PR
Master Format F2
Unique Values:  <20
Source: ETS
Define Code: 
Description:  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).
Comment:  Added for fall 2002 applicants.
Code Interpretation: 

Warehouse Name - Dependency_Status_Code_Federal
Element Name:  Dependency Status Code-Federal
Programming Name:  DEPSTATF
Master Format A1
Unique Values:  2
Source: Campus Input
Define Code: 
Description:  Code indicating the Financial Aid Office determination of whether student is self-supporting or dependent upon family for support according to federal regulations.
Comment: 
Code Interpretation: I = Independent D = Dependent

Warehouse Name - Dependency_Status_State
Element Name:  Dependency Status Code-State
Programming Name:  DEPSTATS
Master Format A1
Unique Values:  2
Source: Campus Input
Define Code: 
Description:  Code indicating the Financial Aid Office determination of whether student is self-supporting or dependent upon family for support according to state regulations.
Comment: 
Code Interpretation: I = Independent D = Dependent

Warehouse Name - Doctorate_Completion_10YR_Flag
Element Name:  Tenth Year Doctorate Completion Flag
Programming Name:  DOCCOMP10YR
Master Format A1
Unique Values:  2
Source: Define-DWH
Define Code:  see comment
Description:  Indicates whether doctorate seeking graduate student graduated within ten years.
Comment:  DOCGOAL/A1 = IF ((DEGPGM1 EQ '34' OR '36' OR '37' OR '38' OR '40' OR '43' OR '44' OR '45' OR '48' OR '49' OR '50' OR '59' OR '66' OR '74') OR (DEGPGM2 EQ '34' OR '36' OR '37' OR '38' OR '40' OR '43' OR '44' OR '45' OR '48' OR '49' OR '50' OR '59' OR '66' OR '74') OR (DEGPGM3 EQ '34' OR '36' OR '37' OR '38' OR '40' OR '43' OR '44' OR '45' OR '48' OR '49' OR '50' OR '59' OR '66' OR '74')) THEN 'Y' ELSE 'N'; DOCCOMP/A1 = IF (CDEGREE EQ '34' OR '36' OR '37' OR '38' OR '40' OR '43' OR '44' OR '45' OR '48' OR '49' OR '50' OR '59' OR '66' OR '74') THEN 'Y' ELSE 'N'; DOCCOMP10YR/A1 = IF DOCGOAL EQ 'Y' AND DOCCOMP EQ 'Y' AND (YEAR LE ENTERYR + 9 OR (YEAR EQ ENTERYR + 10 AND CREGSTATF EQ ' ' AND CREGSTATW EQ ' ' AND CREGSTATS EQ ' ')) THEN 'Y' ELSE 'N';
Code Interpretation: Y = Yes
N = No

Warehouse Name - Doctoral_Degree_Awarded_1_Type
Element Name:  Doctoral Degree Awarded 1 Type
Programming Name:  DOCDEG1
Master Format A1
Unique Values: 
Source: Campus Input
Define Code: 
Description:  Code indicating the type of doctoral degree awarded to a postdoctoral scholar.
Comment: 
Code Interpretation: 1 = Ph.D or equivalent
2 = Health Sciences professional doctorate or equivalent (e.g., M.D., D.D.S., D.N.S., D.V.M., D.Pharm.)
3 = Other professional doctorate or equivalent (e.g., Ed.D., D.Engr., D.S.W., D.L.S)
4 = Other (e.g., unknown type of foreign doctorate)

Warehouse Name - Doctoral_Degree_Awarded_2_Type
Element Name:  Doctoral Degree Awarded 2 Type
Programming Name:  DOCDEG2
Master Format A1
Unique Values: 
Source: Campus Input
Define Code: 
Description:  Code indicating the type of second doctoral degree awarded to a postdoctoral scholar.
Comment: 
Code Interpretation: 1 = Ph.D or equivalent
2 = Health Sciences professional doctorate or equivalent (e.g., M.D., D.D.S., D.N.S., D.V.M., D.Pharm.)
3 = Other professional doctorate or equivalent (e.g., Ed.D., D.Engr., D.S.W., D.L.S)
4 = Other (e.g., unknown type of foreign doctorate)

Warehouse Name - Doctoral_Degree_Awarded_1_Year
Element Name:  Doctoral Degree Awarded 1 Year
Programming Name:  DOCDEGYR1
Master Format A2Y
Unique Values: 
Source: Campus Input
Define Code: 
Description:  Year doctoral degree was awarded to a postdoctoral scholar.
Comment: 
Code Interpretation: 

Warehouse Name - Doctoral_Degree_Awarded_2_Year
Element Name:  Doctoral Degree Awarded 2 Year
Programming Name:  DOCDEGYR2
Master Format A2Y
Unique Values: 
Source: Campus Input
Define Code: 
Description:  Year second doctoral degree was awarded to a postdoctoral scholar.
Comment: 
Code Interpretation: 

Warehouse Name - SATI_Math_Score_Drv
Element Name:  SATI Math Score-Derived
Programming Name:  DSAT1MS
Master Format F3
Unique Values:  61
Source: Define-DWH
Define Code:  IF SATSCRMTH NE 0 THEN SATSCRMTH ELSE SSATSCRMTH;
Description:  Best SATI Math score. If not available, the self-reported SATI Math score.
Comment: 
Code Interpretation: 

Warehouse Name - SATI_Total_Score_Drv
Element Name:  SATI Total Score-Derived
Programming Name:  DSAT1TS
Master Format F4
Unique Values:  121
Source: Define-DWH
Define Code:  DSAT1VS + DSAT1MS;
Description:  Total of derived SATI Verbal and SATI Math scores.
Comment: 
Code Interpretation: 

Warehouse Name - SATI_Verbal_Score_Drv
Element Name:  SATI Verbal Score-Derived
Programming Name:  DSAT1VS
Master Format F3
Unique Values:  61
Source: Define-DWH
Define Code:  IF SATSCRVRB NE 0 THEN SATSCRVRB ELSE SSATSCRVRB;
Description:  Best SATI Verbal score. If not available, the self-reported SATI Verbal score.
Comment: 
Code Interpretation: 

Warehouse Name - SATII_3rd_Code_Drv
Element Name:  SATII 3rd Code-Derived
Programming Name:  DSAT23C
Master Format A2
Unique Values:  19
Source: Define-DWH
Define Code:  IF ACHSCRLSS NE 0 THEN CACHSBJLSS ELSE DECODE SACH3RDCD (‘BY’ ‘B’ ‘CH’ ‘C’ ‘PH’ ‘D’ ‘FL’ ‘E’ ‘FR’ ‘E’ ‘GM’ ‘F’ ‘GL’ ‘F’ ‘LT’ ‘G’ ‘SL’ ‘H’ ‘SP
Description:  Subject code for the best SATII 3rd exam score. If not available, the subject code for the self-reported SATII 3rd exam score.
Comment: 
Code Interpretation: 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)

Warehouse Name - SATII_3rd_Score_Drv
Element Name:  SATII 3rd Score-Derived
Programming Name:  DSAT23S
Master Format F3
Unique Values:  61
Source: Define-DWH
Define Code:  IF ACHSCRLSS NE 0 THEN ACHSCRLSS ELSE SACHSCR3RD;
Description:  Best SATII 3rd exam score. If not available, the self-reported SATII 3rd exam score.
Comment: 
Code Interpretation: 

Warehouse Name - SATII_Math2_Score_Drv
Element Name:  SATII Math2 Score-Derived
Programming Name:  DSAT2M2S
Master Format F3
Unique Values:  61
Source: Define-DWH
Define Code:  IF ACHSCRMTH2 NE 0 THEN ACHSCRMTH ELSE SACHSCRMTH2;
Description:  Best SATII Math2 score. If not available, the self-reported SATII Math2 score.
Comment: 
Code Interpretation: 

Warehouse Name - SATII_Math1_Score_Drv
Element Name:  SATII Math1 Score-Derived
Programming Name:  DSAT2MS
Master Format F3
Unique Values:  61
Source: Define-DWH
Define Code:  IF ACHSCRMTH1 NE 0 THEN ACHSCRMTH ELSE SACHSCRMTH;
Description:  Best SATII Math1 score. If not available, the self-reported SATII Math1 score.
Comment: 
Code Interpretation: 

Warehouse Name - SATII_Writing_Score_Drv
Element Name:  SATII Writing Score-Derived
Programming Name:  DSAT2WS
Master Format F3
Unique Values:  61
Source: Define-DWH
Define Code:  IF ACHSCRENG NE 0 THEN ACHSCRENG ELSE SACHSCRENG;
Description:  Best SATII Writing score. If not available, the self-reported SATII Writing score.
Comment: 
Code Interpretation: 

Warehouse Name - Application_Received_Date
Element Name:  Application Received Date
Programming Name:  DTAPPRCD
Master Format A6
Unique Values:  >1000
Source: Define-MF
Define Code: 
Description:  Date an application was received by the undergraduate admission office.
Comment: 
Code Interpretation: 

Warehouse Name - Application_Received_Date
Element Name:  Application Received Date
Programming Name:  DTAPPRCVD
Master Format A6
Unique Values:  ~30
Source: Vendor
Define Code: 
Description:  Date an application was received by the undergraduate admission office.
Comment:  Although this data item is stored at the campus level, it is in fact provided by the vendor. If this data item contains a valid date, you can conclude that the vendor submitted a record for the applicant.
Code Interpretation: 

Warehouse Name -
Element Name:  Application Recevied Date-Berkeley
Programming Name:  DTAPRCVDBK
Master Format N/A
Unique Values: 
Source: ETS
Define Code: 
Description:  Date record initially sent to Berkeley campus.
Comment: 
Code Interpretation: 

Warehouse Name -
Element Name:  Application Recevied Date-Davis
Programming Name:  DTAPRCVDDV
Master Format N/A
Unique Values: 
Source: ETS
Define Code: 
Description:  Date record initially sent to Davis campus.
Comment: 
Code Interpretation: 

Warehouse Name -
Element Name:  Application Recevied Date-Irvine
Programming Name:  DTAPRCVDIR
Master Format N/A
Unique Values: 
Source: ETS
Define Code: 
Description:  Date record initially sent to Irvine campus.
Comment: 
Code Interpretation: 

Warehouse Name -
Element Name:  Application Recevied Date-Los Angeles
Programming Name:  DTAPRCVDLA
Master Format N/A
Unique Values: 
Source: ETS
Define Code: 
Description:  Date record initially sent to Los Angeles campus.
Comment: 
Code Interpretation: 

Warehouse Name -
Element Name:  Application Recevied Date-Riverside
Programming Name:  DTAPRCVDRV
Master Format N/A
Unique Values: 
Source: ETS
Define Code: 
Description:  Date record initially sent to Riverside campus.
Comment: 
Code Interpretation: 

Warehouse Name -
Element Name:  Application Recevied Date-Santa Barbara
Programming Name:  DTAPRCVDSB
Master Format N/A
Unique Values: 
Source: ETS
Define Code: 
Description:  Date record initially sent to Santa Barbara campus.
Comment: 
Code Interpretation: 

Warehouse Name -
Element Name:  Application Recevied Date-Santa Cruz
Programming Name:  DTAPRCVDSC
Master Format N/A
Unique Values: 
Source: ETS
Define Code: 
Description:  Date record initially sent to Santa Cruz campus.
Comment: 
Code Interpretation: 

Warehouse Name -
Element Name:  Application Recevied Date-San Diego
Programming Name:  DTAPRCVDSD
Master Format N/A
Unique Values: 
Source: ETS
Define Code: 
Description:  Date record initially sent to San Diego campus.
Comment: 
Code Interpretation: 

Warehouse Name - Email_Address
Element Name:  Email Address
Programming Name:  E-MAIL
Master Format A35
Unique Values: 
Source: ETS
Define Code: 
Description:  E-mail address of the applicant.
Comment: 
Code Interpretation: 

Warehouse Name - Education_Highest_Parent
Element Name:  Education_Highest_Parent
Programming Name:  EDHI_PARENT
Master Format A25
Unique Values: 
Source: Define-DWH
Define Code:  IF EDUC_LVL_DAD GT EDUC_LVL_MOM THEN EDUC_LVL_DAD ELSE EDUC_LVL_MOM; DECODE EDHI_PARENTC ('1' 'No High School' '2' 'Some High School' '3' 'High School
Description:  Higher educational attainment among parents of student.
Comment: 
Code Interpretation: 

Warehouse Name - Education_Level_Code_Father
Element Name:  Education Level of Father of Applicant
Programming Name:  EDUC_LVL_DAD
Master Format A1
Unique Values:  7
Source: ETS
Define Code: 
Description:  Highest level of education attained by the father of the applicant.
Comment: 
Code Interpretation: 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

Warehouse Name - Education_Level_Code_Mother
Element Name:  Education Level of Mother of Applicant
Programming Name:  EDUC_LVL_MOM
Master Format A1
Unique Values:  7
Source: ETS
Define Code: 
Description:  Highest level of education attained by the mother of the applicant.
Comment: 
Code Interpretation: 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

Warehouse Name - Expected_Family_Contrib_Amount
Element Name:  Expected Family Contribution Amount (EFC)
Programming Name:  EFCNUM
Master Format I6
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  A numerical value which is reported on the Student Aid report (SAR) and is calculated by Federal Methodology that establishes the level of student eligibility in the determination of the amount of the student's Federal grant, loan, or work study award.
Comment:  Formerly PELLINDEX
Code Interpretation: 

Warehouse Name - Expected_Family_Contrib_Flag
Element Name:  Expected Family Contribution Flag
Programming Name:  EFCNUMFLG
Master Format A1
Unique Values:  2
Source: Define-MF
Define Code: 
Description:  Flag indicator for Expected Family Contribution element to distinguish values that are real zeroes from those which are blank or missing.
Comment: 
Code Interpretation: R = Real Zero
M= Missing

Warehouse Name - Elapsed_Months_to_Graduation
Element Name:  Elapsed Months to Graduation
Programming Name:  ELAPSED
Master Format I2
Unique Values: 
Source: Define-DWH
Define Code:  see comment
Description:  Number of months elapsed from first enrollment at UC until the student earned the first baccalaureate degree.
Comment:  ELAPSED/I2 = IF YEARDEG EQ 0 THEN 0 ELSE (IF (CREGSTATF EQ ' ' AND CREGSTATW EQ ' ' AND CREGSTATS EQ ' ') THEN (YEARDEG-ENTERYR)*12 ELSE IF (CREGSTATS NE ' ') THEN (YEARDEG-ENTERYR+1)*12-3 ELSE IF (CREGSTATW NE ' ') THEN (YEARDEG-ENTERYR+1)*12-6 ELSE IF (CREGSTATF NE ' ') THEN (YEARDEG-ENTERYR+1)*12-9 ELSE 0);
Code Interpretation: 

Warehouse Name - ELC_Student_District_Code
Element Name:  ELC Student District Code
Programming Name:  ELCDIST
Master Format A5
Unique Values: 
Source: ETS
Define Code: 
Description:  School District Code Number of ELC-identified applicant.
Comment: 
Code Interpretation: Refer to School District Code Table.

Warehouse Name - ELC_Eligible_Applicant
Element Name:  ELC Eligible Applicant
Programming Name:  ELCELIG
Master Format A1
Unique Values:  2
Source: ETS
Define Code: 
Description:  Code indicating eligibility of student for admission under the Eligibility in the Local Context (ELC) program.
Comment: 
Code Interpretation: Y - Evaluated as ELC eligible
L - Evaluated as ELC eligible, coded late
S - Evaluated as ELC eligible special
Q - ELC Evaluated, Qualified on Track
N - Matched to ELC file, but not ELC or DAP eligible
blank - Not ELC eligible
D - On track for dual admission
L - Evaluated as ELC eligible, coded late
S - Evaluated as ELC eligible, special process

Warehouse Name - ELC_Student_GPA
Element Name:  ELC Student Grade Point Average
Programming Name:  ELCGPA
Master Format F5.3
Unique Values: 
Source: ETS
Define Code: 
Description:  Final evaluated GPA for ELC determination. This GPA is based on the minimum A-F units required by the ELC program.
Comment: 
Code Interpretation: 

Warehouse Name - ELC_Graduation_Date
Element Name:  ELC Student Graduation Date
Programming Name:  ELCGRADDT
Master Format A6
Unique Values: 
Source: ETS
Define Code: 
Description:  High school graduate date of ELC-identified applicant.
Comment: 
Code Interpretation: 

Warehouse Name - ELC_Magnet_School_Code
Element Name:  ELC Magnet School Code
Programming Name:  ELCMAGCD
Master Format A1
Unique Values: 
Source: ETS
Define Code: 
Description:  Code indicating that the high school listed in ELCSCHOOL has a magnet program.
Comment: 
Code Interpretation: 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.

Warehouse Name - ELC_Magnet_School_Name
Element Name:  ELC Magnet School Name
Programming Name:  ELCMAGNAME
Master Format A35
Unique Values: 
Source: ETS
Define Code: 
Description:  Name of magnet program listed in element ELCMAGCD.
Comment: 
Code Interpretation: 

Warehouse Name - ELC_Student_School_Code
Element Name:  ELC Student School Code
Programming Name:  ELCSCHOOL
Master Format A6
Unique Values: 
Source: ETS
Define Code: 
Description:  ATP school code of high school attended by ELC-identified applicant.
Comment: 
Code Interpretation: 

Warehouse Name - ELC_Code_Self_Report
Element Name:  ELC Code Self Report
Programming Name:  ELCSELF
Master Format A12
Unique Values: 
Source: ETS
Define Code: 
Description:  ELC identification number as self-reported by applicant.
Comment: 
Code Interpretation: 

Warehouse Name - ELC_Student_ID_Number
Element Name:  ELC Student Idenfification Number
Programming Name:  ELCSID
Master Format A12
Unique Values:  >1000
Source: ETS
Define Code: 
Description:  Student Identification Number for Eligibility in the Local Context (ELC) program. If ELCelig is not blank and not 'N', applicant is potential candidate for DAP.
Comment: 
Code Interpretation: 

Warehouse Name - Enrollment_Begin_Date
Element Name:  Enrollment Begin Date
Programming Name:  ENRBEGDT
Master Format A4YM
Unique Values: 
Source: Campus Input
Define Code: 
Description:  Date on which individual was first appointed as a postdoctoral scholar.
Comment: 
Code Interpretation: 

Warehouse Name - Term_Entered_AY
Element Name:  Term Entered UC
Programming Name:  ENTERQTR
Master Format A1
Unique Values:  3
Source: Define-MF
Define Code: 
Description:  Quarter/Semester in which the student first enrolled in a graduate or undergraduate program.
Comment: 
Code Interpretation: 1 = Summer
2 = Fall
3 = Winter
4 = Spring

Warehouse Name - Year_Entered_AY
Element Name:  Academic Year Entered UC
Programming Name:  ENTERYEARAY
Master Format I4
Unique Values:  7
Source: Define-MF
Define Code: 
Description:  Academic year in which a student first entered an undergraduate or graduate program at UC. Also known as Cohort Year.
Comment: 
Code Interpretation: 

Warehouse Name - Year_Entered_AY
Element Name:  Academic Year Entered UC
Programming Name:  ENTERYR
Master Format I4
Unique Values:  7
Source: Define-MF
Define Code: 
Description:  Academic year in which a student first entered an undergraduate or graduate program at UC. Also known as Cohort Year.
Comment: 
Code Interpretation: 

Warehouse Name - EOP_AAP_Code_Adm
Element Name:  EOP/AAP Participation Code-Admission
Programming Name:  EOPA
Master Format A1
Unique Values:  3
Source: Define-MF
Define Code: 
Description:  Code indicating assignment of applicant to a special program such as the Educational Opportunity or Academic Advancement Program.
Comment: 
Code Interpretation: 1 - Yes
blank - No

Warehouse Name - EOP_AAP_Code_Adm
Element Name:  EOP/AAP Participation Code-Admission
Programming Name:  EOPAAPA
Master Format A1
Unique Values:  2
Source: Rename
Define Code: 
Description:  Code indicating assignment of applicant to a special program such as the Educational Opportunity or Academic Advancement Program. Renamed from UADM element EOPA.
Comment: 
Code Interpretation: Y = Yes
blank = No

Warehouse Name - EOP_AAP_Code_Reg
Element Name:  EOP/AAP Participation Code-Registration
Programming Name:  EOPAAPR
Master Format A1
Unique Values:  3
Source: Campus Input
Define Code: 
Description:  Code indicating whether student is a participant in educational opportunity program or academic advance program at the time of registration.
Comment:  3/8/2005 Obsolete
Code Interpretation: Y = Yes
blank = No

Warehouse Name - Trans_Units_Completed_CCC
Element Name:  Transfer Units Completed-CCC
Programming Name:  ESTCCCUNIT
Master Format F4.1
Unique Values:  number
Source: ETS
Define Code: 
Description:  Total quarter units completed at California Community Colleges prior to transfer.
Comment: 
Code Interpretation: 

Warehouse Name - GPA_Transfer_SR
Element Name:  Grade Point Average-Transfer-Self-reported
Programming Name:  ESTCOLGPA
Master Format F4.2
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  The overall college GPA reported by the advanced standing applicant.
Comment: 
Code Interpretation: 

Warehouse Name - Trans_Units_Estimated_SR
Element Name:  Transfer Units Estimated-Self-reported
Programming Name:  ESTCOLUNIT
Master Format F5.1
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  The total completed college quarter units reported by the advanced standing applicant.
Comment:  Note: before August 2006, this data item was converted to quarter units for Berkeley. This is no longer the case. All units included in a campus file are assumed to be quarter units for quarter campuses, and semester units for semester campuses.
Code Interpretation: 

Warehouse Name - GPA_Freshman_SR
Element Name:  Grade Point Average-Freshman-Self Reported
Programming Name:  ESTHSGPA
Master Format F4.2
Unique Values:  number
Source: MF-define
Define Code:  ESTHSGPA = IF FROSHGPA NE 0 THEN FROSHGPA ELSE IF CALCGPA_R NE 0 THEN CALCGPA_R ELSE IF CALCGPA NE 0 THEN CALCGPA ELSE 0;
Description:  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)
Comment: 
Code Interpretation: 

Warehouse Name - GPA_Freshman_SR_Campus
Element Name:  GPA Freshman SR Campus
Programming Name:  ESTHSGPAC
Master Format F4.2
Unique Values:  number
Source: Campus Input
Define Code: 
Description:  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.
Comment: 
Code Interpretation: 

Warehouse Name - Ethnic_Origin_Name_Reg
Element Name:  Ethnic Origin Name–REG
Programming Name:  ETHNIC
Master Format 
Unique Values:  16
Source: Define-DWH
Define Code: 
Description:  Name of race/ethnicity category at registration.
Comment: 
Code Interpretation: 

Warehouse Name - Ethnic_Origin_Name_Reg_9CAT
Element Name:  Ethnic Origin Name-REG-9 Category
Programming Name:  ETHNIC2
Master Format 
Unique Values:  9
Source: Define-DWH
Define Code: 
Description:  Name of race/ethnicity category at registration - 9 categories.
Comment: 
Code Interpretation: AI = American Indian
BLACK = Black
CHIC = Chicano
LAT = Latino
PIL = Filipino
ASIAN = Asian
WHITE = White
DTS = Decline to State
OTHER = Other

Warehouse Name - Ethnic_Origin_Name_Adm
Element Name:  Ethnic Origin Name Adm
Programming Name:  ETHNICA
Master Format A20
Unique Values:  16
Source: Define-DWH
Define Code:  DECODE CETHNICA
Description:  Name of race/ethnicity category provided on the application.
Comment: 
Code Interpretation: 

Warehouse Name - Ethnic_Origin_Name_Adm_9CAT
Element Name:  Ethnic Origin Name Adm 9CAT
Programming Name:  ETHNICA2
Master Format A5
Unique Values:  9
Source: Define-DWH
Define Code:  IF CETHNICA IS 'A' THEN 'AI' ELSE IF CETHNICA IS 'B' THEN 'BLACK' ELSE IF CETHNICA IS 'C' THEN 'CHIC' ELSE IF CETHNICA IS 'J' THEN 'LAT' ELSE IF CETHN
Description:  Name of race/ethnicity category provided on the application - 9 categories.
Comment: 
Code Interpretation: 

Warehouse Name - Ethnic_Origin_Code_Adm_URM
Element Name:  Ethnic Origin Code Adm URM
Programming Name:  ETHNICAURM
Master Format A1
Unique Values:  2
Source: Define-DWH
Define Code:  IF CETHNICA EQ 'A' OR 'B' OR 'C' OR 'J' THEN '1' ELSE '0';
Description:  Flag indicating applicant is a member of an underrepresented minority (American Indian, African American, Chicano, or Latino).
Comment: 
Code Interpretation: 1 - Yes
0 - No

Warehouse Name - Ethnic_Origin_Name_Reg
Element Name:  Ethnic Origin Name–REG
Programming Name:  ETHNICR
Master Format 
Unique Values:  16
Source: Define-DWH
Define Code: 
Description:  Name of race/ethnicity category at registration.
Comment: 
Code Interpretation: 

Warehouse Name - Ethnic_Origin_Name_Reg_9CAT
Element Name:  Ethnic Origin Name-REG-9 Category
Programming Name:  ETHNICR2
Master Format 
Unique Values:  9
Source: Define-DWH
Define Code:  see comment
Description:  Name of race/ethnicity category at registration - 9 categories.
Comment:  ETHNICR2/A5=IF CETHNICR IS 'A' THEN 'AI' ELSE IF CETHNICR IS 'B' THEN 'BLACK' ELSE IF CETHNICR IS 'C' THEN 'CHIC' ELSE IF CETHNICR IS 'J' THEN 'LAT' ELSE IF CETHNICR IS 'L' THEN 'PIL' ELSE IF CETHNICR IS 'D' OR 'F' OR 'G' OR 'H' OR 'M' OR 'N' OR 'V' THEN 'ASIAN' ELSE IF CETHNICR IS 'P' THEN 'WHITE' ELSE IF CETHNICR IS 'E' OR ' ' THEN 'DTS' ELSE 'OTHER';
Code Interpretation: AI = American Indian
BLACK = Black
CHIC = Chicano
LAT = Latino
PIL = Filipino
ASIAN = Asian
WHITE = White
DTS = Decline to State
OTHER = Other

Warehouse Name - Identification_Number_ETS
Element Name:  Identification Number-ETS
Programming Name:  ETSNO
Master Format A7
Unique Values:  >1000
Source: ETS, Campus Input
Define Code: 
Description:  Number assigned by the Educational Testing Service (ETS) to uniquely identify an undergraduate student applicant.
Comment: 
Code Interpretation: 

Warehouse Name - Evaluation_Rev_Freshman
Element Name:  Evaluation Review For Eligible Freshmen
Programming Name:  EVALREV
Master Format A1
Unique Values:  3
Source: ETS
Define Code: 
Description:  Code indicating status of freshman eligibility code '9' and '-'. Discontinued after 1999.
Comment: 
Code Interpretation: 

Warehouse Name - FAFSA
Element Name:  FAFSA
Programming Name:  FAFSA
Master Format A1
Unique Values:  3
Source: Campus Input
Define Code: 
Description:  Code indicating whether or not the student (financial aid recipient or applicant) filed a FAFSA or CA Dream Act Application before or after March 2nd.
Comment: 
Code Interpretation: Y = FAFSA filed by March 2nd
L = FAFSA filed after March 2nd
N = FAFSA not filed
D=CA Dream Act App filed by March 2nd
P= CA Dream Act App filed after March 2nd

Warehouse Name - Registered_Fall_Term
Element Name:  Registered-Fall Term
Programming Name:  FCQTR
Master Format A1
Unique Values:  2
Source: Define-MF
Define Code: 
Description:  Code indicating that student was registered at third week or later during the fall term.
Comment: 
Code Interpretation: 1 - Yes
blank - No

Warehouse Name - Fees_Owed
Element Name:  Fees Owed
Programming Name:  FEESOWED
Master Format F3
Unique Values:  number
Source: ETS
Define Code: 
Description:  Amount applicant owes, rounded to whole dollars.
Comment:  Added for fall 2002 applicants.
Code Interpretation: 

Warehouse Name - Freshman_GPA_Course_Summ
Element Name:  Freshman GPA and Coursework Summary
Programming Name:  FGPACRS
Master Format A1
Unique Values: 
Source: ETS
Define Code: 
Description:  Code providing summary of grade point average and A-F coursework of applicant.
Comment: 
Code Interpretation: 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.

Warehouse Name -
Element Name:  Financial Aid File Type
Programming Name:  FILETYP
Master Format A1
Unique Values:  2
Source: Define
Define Code:  If &QTR EQ '1' THEN 'S' ELSE 'A';
Description:  Code indicating whether Financial Aid contains summer ('S') or yearlong ('A') date
Comment: 
Code Interpretation: 

Warehouse Name - Freshman_Score_Index
Element Name:  Freshman Score Index
Programming Name:  FINDEX
Master Format F4
Unique Values:  number
Source: ETS
Define Code: 
Description:  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.
Comment: 
Code Interpretation: 

Warehouse Name - Identification_Number_REG
Element Name:  Identification Number-FAI
Programming Name:  FKEY
Master Format A12
Unique Values:  >1000
Source: Define-MF
Define Code: 
Description:  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.
Comment:  Student Identification Number varies in length from campus to campus. Social Security Number may be used on some campuses.
Code Interpretation: 

Warehouse Name - Foster_Care
Element Name:  Foster Care Status
Programming Name:  FOSTER_CARE
Master Format A1
Unique Values:  3
Source: ETS
Define Code: 
Description:  Code Indicating the foster care status of applicant. Self-reported.
Comment:  Y = foster care applicant. N or blank. Not foster care applicant.
Code Interpretation: 

Warehouse Name - GPA_Freshman_Campus
Element Name:  Grade Point Average-Freshman-Campus Calculated
Programming Name:  FROSHGPA
Master Format F4.2
Unique Values:  number
Source: ETS
Define Code: 
Description:  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.
Comment: 
Code Interpretation: 

Warehouse Name - Freshman_Score_Indicator
Element Name:  Freshman Score Indicator
Programming Name:  FSCORES
Master Format A1
Unique Values: 
Source: ETS
Define Code: 
Description:  Code indicating the presence and type of required test scores.
Comment: 
Code Interpretation: 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

Warehouse Name - Registration_Full_Time_Equivalnt
Element Name:  Registration Full Time Equivalent
Programming Name:  FTE
Master Format 
Unique Values:  2
Source: Define-DWH
Define Code: 
Description:  Full-time equivalency of student, based on student level and units attempted as of third week.
Comment: 
Code Interpretation: 

Warehouse Name - Full_Time_Resident
Element Name:  Full Time Code-Residents
Programming Name:  FULLTIME
Master Format A1
Unique Values:  3
Source: Campus Input
Define Code: 
Description:  Code indicating whether the level of work activity undertaken by a resident is full time (100% time) or not.
Comment: 
Code Interpretation: Y = Yes
N = No

Warehouse Name - Registration_Full_Time
Element Name:  Registration Full Time
Programming Name:  FULLTMSTU
Master Format 
Unique Values:  2
Source: Define-DWH
Define Code:  see comment
Description:  Code indicating student is enrolled full-time or part-time according to definition used for reporting in the Statistical Summary.
Comment:  FULLTMSTU/A1 = IF (CSTUDLVL3 EQ '7' OR '8' OR 'R') OR (HSIND3 EQ 'H') OR (SPECPROGR CONTAINS '6') OR ((CSTUDLVL3 EQ '1' OR '2' OR '3' OR '4' OR 'L' OR 'S' OR 'P') AND (ATTC3 GE 12.0)) OR ((CSTUDLVL3 EQ '5' OR '6') AND (ATTC3 GE 8.0)) THEN 'Y' ELSE 'N';
Code Interpretation: Y = Yes
N = No

Warehouse Name - Full_Year_Equivalent_Enrollment
Element Name:  Full-Year Equivalent Enrollment
Programming Name:  FULLYREQ
Master Format F4.2
Unique Values: 
Source: Define-DWH
Define Code:  REGF/I1=IF CREGSTATF NE ' ' THEN 1 ELSE 0; REGW/I1=IF CREGSTATW NE ' ' THEN 1 ELSE 0; REGS/I1=IF CREGSTATS NE ' ' THEN 1 ELSE 0; FULLYREQ = IF CCAMPUS
Description:  Proportion of the year the student was enrolled. 1.0 indicates the student was enrolled for all terms during the year. 0.5 indicates the student was enrolled for one term at a semester campus. 0.67 and 0.33 indicate the student was enrolled for two terms or one terms, respectively, at a quarter campus. 0.00 indicates the student was not enrolled during the year.
Comment: 
Code Interpretation: 

Warehouse Name - Fund
Element Name:  Fund Number
Programming Name:  FUND
Master Format A5
Unique Values:  >1000
Source: Campus Input
Define Code: 
Description:  Number identifying a specific source of funding.
Comment: 
Code Interpretation: Refer to Accounting Manual Chapter A-115-2.

Warehouse Name - Fund_Group_Code
Element Name:  Fund Group Code
Programming Name:  FUND_GROUP
Master Format A6
Unique Values: 
Source: AFPFUND file
Define Code: 
Description:  Code indicating the category to which a fund belongs in the University's accounting structure. Go to http://www.ucop.edu/irc/dd/cdw/financial/ for more details
Comment: 
Code Interpretation: 

Warehouse Name - Full_Year_Equivalent
Element Name:  Full Year Equivalent
Programming Name:  FYE
Master Format D10.8
Unique Values: 
Source: Define
Define Code: 
Description:  Number reflecting the number of primary terms the student was enrolled in during the academic year. 1 means the student was enrolled in all terms.
Comment:  Define code in DWHSFEDF FOCEXEC: TERMDIV/I1 = IF CCAMPUS EQ '01' OR '10' OR ((CCAMPUS EQ '03' OR '04') AND CCOL3 EQ '84') OR ( CCAMPUS EQ '04' AND CSTUDLVL3 NE 'R' AND CCOL3 EQ '85' AND (CMAJ3 EQ '009' OR '558' OR '560')) THEN 2 ELSE 3; FCQTRI/I1 = EDIT(FCQTR); WCQTRI/I1 = EDIT(WCQTR); SCQTRI/I1 = EDIT(SCQTR); SUCQTRI/I1 = EDIT(SUCQTR); CQTR1ST/I1 = EDIT(CQTR1ST); ENRTERMS/I1 = FCQTRI + WCQTRI + SCQTRI; FYET/D10.8 = ENRTERMS / TERMDIV; FYE/D10.8 = IF FYET GT 1 THEN 1 ELSE FYET;
Code Interpretation: 

Warehouse Name - Identification_Number_GAD
Element Name:  Identification Number-GAD
Programming Name:  GKEY
Master Format A12
Unique Values:  >1000
Source: Define-MF
Define Code: 
Description:  Number that identifies applicant on the campus applied to. For applicants who have registered, this must be the number which identifies the person in the population of registrants.
Comment:  Applicant Identification Number varies in length from campus to campus. Social Security Number is used on some campuses.
Code Interpretation: 

Warehouse Name - GPA_CURR_EOT
Element Name:  GPA-Current Term-End of Term
Programming Name:  GPAEOT2
Master Format 
Unique Values:  999
Source: Define-DWH
Define Code: 
Description:  Grade point average based on units attempted and grade points for the current term, as of end of term.
Comment: 
Code Interpretation: 

Warehouse Name - GPA_Freshman_Total
Element Name:  GPA Freshman-Total
Programming Name:  GPAFROSH
Master Format 
Unique Values:  999
Source: Define-DWH
Define Code:  GPAFROSH/F4.2 = HSGPAF/HSUAF
Description:  Grade point average of entering freshmen based on units and grade points in high school courses in subjects A-F.
Comment: 
Code Interpretation: 

Warehouse Name - GPA_Summer_EOT
Element Name:  GPA-Summer-EOT
Programming Name:  GPASU
Master Format F4.2
Unique Values: 
Source: Define-DWH
Define Code:  see comment
Description:  Grade point average based on Summer units attempted and grade points, as of end of term.
Comment:  GPASU/F4.2 = IF (GPCSU GT 0) AND (ATTCGSU GT 0) THEN (GPCSU/ATTCGSU) ELSE 0; GPASU/F4.2 = IF GPASU GT 5.00 THEN 9.99 ELSE GPASU ;
Code Interpretation: 

Warehouse Name - GPA_Transfer_Total
Element Name:  GPA Transfer-Total
Programming Name:  GPATRAN
Master Format 
Unique Values:  999
Source: Define-DWH
Define Code:  GPATRAN/F4.2 = TOTASTGP/TOTASTUA
Description:  Grade point average of entering transfers based on units and grade points in transfer courses.
Comment: 
Code Interpretation: 

Warehouse Name - GPA_TTD_UC_3WK
Element Name:  GPA-Total to Date-UC-3rd Week
Programming Name:  GPATTD32
Master Format 
Unique Values:  999
Source: Define-DWH
Define Code: 
Description:  Grade point average based on total units attempted and grade points to date, as of third week.
Comment: 
Code Interpretation: 

Warehouse Name - GPA_TTD_UC_EOT
Element Name:  GPA-Total to Date-UC-End of Term
Programming Name:  GPATTDE2
Master Format 
Unique Values:  999
Source: Define-DWH
Define Code: 
Description:  Grade point average based on total units attempted and grade points to date, as of end of term.
Comment: 
Code Interpretation: 

Warehouse Name - GPA_TTD_UC_Year_1
Element Name:  GPA TTD Year-1
Programming Name:  GPATTDE2_1
Master Format F4.2
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Total-to-date GPA as of the end of the last term enrolled during the first year.
Comment: 
Code Interpretation: 

Warehouse Name - GPA_TTD_UC_Year_2
Element Name:  GPA TTD Year-2
Programming Name:  GPATTDE2_2
Master Format F4.2
Unique Values: 
Source: Define-DWH
Define Code: 
Description:  Total-to-date GPA as of the end of the last term enrolled during the second year.
Comment: 
Code Interpretation: 

Warehouse Name - GPA_TTD_UC_Year_3
Element Name:  GPA TTD Year-3
Programming Name:  GPATTDE2_3
Master Format F4.2
Unique Values: