C O R P O R A T E * S T U D E N T * S Y S T E M   
Mainframe Database Codebook:
Data Element - ACADCRSA
Element Name:  Academic Courses-Grade A
Programming Name:  ACADCRSA
Segment: 
Master Format F2
Unique Values:  <50
Source: ETS
Cross Reference Table: 
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: 

Data Element - ACADCRSB
Element Name:  Academic Courses-Grade B
Programming Name:  ACADCRSB
Segment: 
Master Format F2
Unique Values:  <50
Source: ETS
Cross Reference Table: 
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: 

Data Element - ACADCRSC
Element Name:  Academic Courses-Grade C
Programming Name:  ACADCRSC
Segment: 
Master Format F2
Unique Values:  <50
Source: ETS
Cross Reference Table: 
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: 

Data Element - ACADCRSD
Element Name:  Academic Courses-Grade D
Programming Name:  ACADCRSD
Segment: 
Master Format F2
Unique Values:  <50
Source: ETS
Cross Reference Table: 
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: 

Data Element - ACADCRSF
Element Name:  Academic Courses-Grade F
Programming Name:  ACADCRSF
Segment: 
Master Format F2
Unique Values:  <50
Source: ETS
Cross Reference Table: 
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: 

Data Element - ACADHON10
Element Name:  Honors Courses-10th Grade
Programming Name:  ACADHON10
Segment: 
Master Format F2
Unique Values:  <50
Source: ETS
Cross Reference Table: 
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: 

Data Element - ACADHON1011
Element Name:  Honors Courses-10th and 11th Grade
Programming Name:  ACADHON1011
Segment: 
Master Format F2
Unique Values:  <50
Source: ETS
Cross Reference Table: 
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: 

Data Element - ACADHON11
Element Name:  Honors Courses-11th Grade
Programming Name:  ACADHON11
Segment: 
Master Format F2
Unique Values:  <50
Source: ETS
Cross Reference Table: 
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: 

Data Element - ACADHON12
Element Name:  Honors Courses-12th Grade
Programming Name:  ACADHON12
Segment: 
Master Format F2
Unique Values:  <50
Source: ETS
Cross Reference Table: 
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: 

Data Element - ACADPROF3
Element Name:  Academic Professional Status 3WK
Programming Name:  ACADPROF3
Segment: 
Master Format A1
Unique Values:  4
Source: MF define
Cross Reference Table: 
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)

Data Element - ACADPROFD
Element Name:  Doctorate Academic/Professional Status
Programming Name:  ACADPROFD
Segment: 
Master Format A1
Unique Values:  4
Source: CSX Web application
Cross Reference Table: 
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

Data Element - ACADPROFE
Element Name:  Academic Professional Status EOT
Programming Name:  ACADPROFE
Segment: 
Master Format A1
Unique Values:  4
Source: MF define
Cross Reference Table: 
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)

Data Element - ACADPROFM
Element Name:  Master Academic/Professional Status
Programming Name:  ACADPROFM
Segment: 
Master Format A1
Unique Values:  4
Source: CSX Web application
Cross Reference Table: 
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

Data Element - ACADUNIT
Element Name:  Academic Unit Name
Programming Name:  ACADUNIT
Segment: 
Master Format A30
Unique Values: 
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - ACADYEAR
Element Name:  Year Registered
Programming Name:  ACADYEAR
Segment: 
Master Format A2
Unique Values:  1
Source: Define_MF
Cross Reference Table: 
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: 

Data Element - ACCOUNT
Element Name:  Account Number
Programming Name:  ACCOUNT
Segment: 
Master Format A6
Unique Values:  >1000
Source: Campus Input
Cross Reference Table: 
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.

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

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

Data Element - ACHSCRLSS
Element Name:  SATII Third Exam Score-Best
Programming Name:  ACHSCRLSS
Segment: 
Master Format I3
Unique Values:  ~60
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - ACHSCRLSSC
Element Name:  SATII Third Exam Score Best - Campus
Programming Name:  ACHSCRLSSC
Segment: 
Master Format I3
Unique Values:  ~60
Source: Campus Input
Cross Reference Table: 
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: 

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

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

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

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

Data Element - ACTSCRCMP
Element Name:  ACT Composite Score-Best
Programming Name:  ACTSCRCMP
Segment: 
Master Format I2
Unique Values:  37
Source: Define MF
Cross Reference Table: 
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: 

Data Element - ACTSCRCMPC
Element Name:  ACT Composite Score Best - Campus
Programming Name:  ACTSCRCMPC
Segment: 
Master Format I2
Unique Values:  37
Source: Define MF
Cross Reference Table: 
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: 

Data Element - ACTSCRCWW
Element Name:  ACT Composite Score with Writing - Best
Programming Name:  ACTSCRCWW
Segment: 
Master Format F2
Unique Values:  ~37
Source: Define MF
Cross Reference Table: 
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: 

Data Element - ACTSCRCWWC
Element Name:  ACT Composite Score with Writing - Best Campus
Programming Name:  ACTSCRCWWC
Segment: 
Master Format F2
Unique Values:  ~37
Source: Define MF
Cross Reference Table: 
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: 

Data Element - ACTSCRENG
Element Name:  ACT English Score-Best
Programming Name:  ACTSCRENG
Segment: 
Master Format I2
Unique Values:  37
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - ACTSCRENGC
Element Name:  ACT English Score Best - Campus
Programming Name:  ACTSCRENGC
Segment: 
Master Format I2
Unique Values:  37
Source: Campus Input
Cross Reference Table: 
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: 

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

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

Data Element - ACTSCRMTH
Element Name:  ACT Math Score-Best
Programming Name:  ACTSCRMTH
Segment: 
Master Format I2
Unique Values:  37
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - ACTSCRMTHC
Element Name:  ACT Math Score Best - Campus
Programming Name:  ACTSCRMTHC
Segment: 
Master Format I2
Unique Values:  37
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - ACTSCRNAT
Element Name:  ACT Natural Science Score-Best
Programming Name:  ACTSCRNAT
Segment: 
Master Format I2
Unique Values:  37
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - ACTSCRNATC
Element Name:  ACT Natural Science Score Best - Campus
Programming Name:  ACTSCRNATC
Segment: 
Master Format I2
Unique Values:  37
Source: Campus Input
Cross Reference Table: 
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: 

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

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

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

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

Data Element - ACTSCRSOC
Element Name:  ACT Social Studies Score-Best
Programming Name:  ACTSCRSOC
Segment: 
Master Format I2
Unique Values:  37
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - ACTSCRSOCC
Element Name:  ACT Social Studies Score Best - Campus
Programming Name:  ACTSCRSOCC
Segment: 
Master Format I2
Unique Values:  37
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - ACTYEAR
Element Name:  First Year Offered
Programming Name:  ACTYEAR
Segment: 
Master Format A4
Unique Values:  >100
Source: CSX Web application
Cross Reference Table: 
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: 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Data Element - ADMREGBK
Element Name:  Admit Regular-Berkeley
Programming Name:  ADMREGBK
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - ADMREGCT
Element Name:  Admit Regular Count
Programming Name:  ADMREGCT
Segment: 
Master Format I1
Unique Values:  10
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - ADMREGDV
Element Name:  Admit Regular-Davis
Programming Name:  ADMREGDV
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - ADMREGIR
Element Name:  Admit Regular-Irvine
Programming Name:  ADMREGIR
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - ADMREGLA
Element Name:  Admit Regular-Los Angeles
Programming Name:  ADMREGLA
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

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

Data Element - ADMREGRV
Element Name:  Admit Regular-Riverside
Programming Name:  ADMREGRV
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - ADMREGSB
Element Name:  Admit Regular-Santa Barbara
Programming Name:  ADMREGSB
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - ADMREGSC
Element Name:  Admit Regular-Santa Cruz
Programming Name:  ADMREGSC
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - ADMREGSD
Element Name:  Admit Regular-San Diego
Programming Name:  ADMREGSD
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - ADMSELECT
Element Name:  Admit Selective Flag
Programming Name:  ADMSELECT
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - ADMSPCBK
Element Name:  Admit Special-Berkeley
Programming Name:  ADMSPCBK
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - ADMSPCCT
Element Name:  Admit Special Count
Programming Name:  ADMSPCCT
Segment: 
Master Format I1
Unique Values:  10
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - ADMSPCDV
Element Name:  Admit Special-Davis
Programming Name:  ADMSPCDV
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - ADMSPCIR
Element Name:  Admit Special-Irvine
Programming Name:  ADMSPCIR
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - ADMSPCLA
Element Name:  Admit Special-Los Angeles
Programming Name:  ADMSPCLA
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

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

Data Element - ADMSPCRV
Element Name:  Admit Special-Riverside
Programming Name:  ADMSPCRV
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - ADMSPCSB
Element Name:  Admit Special-Santa Barbara
Programming Name:  ADMSPCSB
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - ADMSPCSC
Element Name:  Admit Special-Santa Cruz
Programming Name:  ADMSPCSC
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - ADMSPCSD
Element Name:  Admit Special-San Diego
Programming Name:  ADMSPCSD
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - ADVDT
Element Name:  Date Advanced To Candidacy
Programming Name:  ADVDT
Segment: 
Master Format A3
Unique Values: 
Source: Define-MF
Cross Reference Table: 
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

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

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

Data Element - AFYQ
Element Name:  Term First Enrolled
Programming Name:  AFYQ
Segment: 
Master Format A3
Unique Values:  ~30
Source: Define-MF
Cross Reference Table: 
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

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

Data Element - AIDTYPE
Element Name:  Aid Type Indicator
Programming Name:  AIDTYPE
Segment: 
Master Format A1
Unique Values:  2
Source: Define-MF
Cross Reference Table: 
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

Data Element - AMTCHK
Element Name:  Amount Paid or Method Paid
Programming Name:  AMTCHK
Segment: 
Master Format A1
Unique Values:  3
Source: ETS
Cross Reference Table: 
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

Data Element - AMTEARN
Element Name:  Award Type Amount-Earnings
Programming Name:  AMTEARN
Segment: 
Master Format I6
Unique Values:  number
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - AMTGRNT
Element Name:  Award Type Amount-Grants
Programming Name:  AMTGRNT
Segment: 
Master Format I6
Unique Values:  number
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - AMTLOAN
Element Name:  Award Type Amount-Loans
Programming Name:  AMTLOAN
Segment: 
Master Format I6
Unique Values:  number
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - AMTOTH
Element Name:  Award Type Amount-Other
Programming Name:  AMTOTH
Segment: 
Master Format I6
Unique Values:  number
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - AMTRATA
Element Name:  Award Type Amount-RATA Remission
Programming Name:  AMTRATA
Segment: 
Master Format I6
Unique Values:  number
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - AMTSFT
Element Name:  Award Type Amount-SFT
Programming Name:  AMTSFT
Segment: 
Master Format I6
Unique Values:  number
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - AMTWKST
Element Name:  Award Type Amount-Work Study
Programming Name:  AMTWKST
Segment: 
Master Format I6
Unique Values:  number
Source: Define-DWH
Cross Reference Table: 
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: 

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

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

Data Element - APPCOUNT
Element Name:  Application Count
Programming Name:  APPCOUNT
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - APPCOUNTOR
Element Name:  App Original Count
Programming Name:  APPCOUNTOR
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - APPL_ALERT
Element Name:  Applicant Alert
Programming Name:  APPL_ALERT
Segment: 
Master Format A5
Unique Values:  9
Source: ETS
Cross Reference Table: 
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"

Data Element - APPSELECT
Element Name:  App Selective Flag
Programming Name:  APPSELECT
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - APPTRLVL
Element Name:  Applicant_Transfer_Level
Programming Name:  APPTRLVL
Segment: 
Master Format A2
Unique Values: 
Source: Define-DWH
Cross Reference Table: 
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: 

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

Data Element - ATTC3
Element Name:  Units Attempted-Current Term-3rd Week
Programming Name:  ATTC3
Segment: 
Master Format F4.1
Unique Values:  number
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - ATTCGE
Element Name:  Units Attempted-Current Term-Graded-End of Term
Programming Name:  ATTCGE
Segment: 
Master Format F4.1
Unique Values:  number
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - ATTCGSU
Element Name:  Units Attempted-Summer-Graded-End of Term
Programming Name:  ATTCGSU
Segment: 
Master Format F5.1
Unique Values:  number
Source: Define MF
Cross Reference Table: 
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: 

Data Element - ATTCN
Element Name:  Units Attempted-Current Term - Non-Degree
Programming Name:  ATTCN
Segment: 
Master Format F4.1
Unique Values:  number
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - ATTCPE
Element Name:  Units Attempted-Current Term-P/NP-End of Term
Programming Name:  ATTCPE
Segment: 
Master Format F4.1
Unique Values:  number
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - ATTCPSU
Element Name:  Units Attempted-Summer-P/NP-End of Term
Programming Name:  ATTCPSU
Segment: 
Master Format F5.1
Unique Values:  number
Source: Define MF
Cross Reference Table: 
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: 

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

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

Data Element - ATTEMPT
Element Name:  Units Attempted-First Term Enrolled
Programming Name:  ATTEMPT
Segment: 
Master Format F4.1
Unique Values:  number
Source: Define-MF
Cross Reference Table: 
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: 

Data Element - ATTTGU3
Element Name:  Units Attempted-Total to Date-Graded-UC-3rd Week
Programming Name:  ATTTGU3
Segment: 
Master Format F5.1
Unique Values:  number
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - ATTTGUE
Element Name:  Units Attempted-Total to Date-Graded-UC-End of Term
Programming Name:  ATTTGUE
Segment: 
Master Format F5.1
Unique Values:  number
Source: Campus Input
Cross Reference Table: 
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: 

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

Data Element - ATTTPUE
Element Name:  Units Attempted-Total to Date- P/NP- UC-End of Term
Programming Name:  ATTTPUE
Segment: 
Master Format F5.1
Unique Values:  number
Source: Campus Input
Cross Reference Table: 
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: 

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

Data Element - AWARDAMT
Element Name:  Award Amount
Programming Name:  AWARDAMT
Segment: 
Master Format D8.2
Unique Values:  number
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - AWDAPP
Element Name:  Award Apportionment Code
Programming Name:  AWDAPP
Segment: 
Master Format A1
Unique Values:  7
Source: Campus Input
Cross Reference Table: 
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

Data Element - AWDEARN
Element Name:  Award Type Indicator-Earnings
Programming Name:  AWDEARN
Segment: 
Master Format A1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - AWDFALL
Element Name:  Award Period-Fall
Programming Name:  AWDFALL
Segment: 
Master Format A1
Unique Values:  2
Source: Campus Input
Cross Reference Table: 
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

Data Element - AWDGRNT
Element Name:  Award Type Indicator-Grants
Programming Name:  AWDGRNT
Segment: 
Master Format A1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

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

Data Element - AWDLOAN
Element Name:  Award Type Indicator-Loans
Programming Name:  AWDLOAN
Segment: 
Master Format A1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

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

Data Element - AWDOTH
Element Name:  Award Type Indicator-Other
Programming Name:  AWDOTH
Segment: 
Master Format A1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - AWDRATA
Element Name:  Award Type Indicator-RATA Remission
Programming Name:  AWDRATA
Segment: 
Master Format A1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - AWDSFT
Element Name:  Award Type Indicator-SFT
Programming Name:  AWDSFT
Segment: 
Master Format A1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - AWDSPR
Element Name:  Award Period-Spring
Programming Name:  AWDSPR
Segment: 
Master Format A1
Unique Values:  2
Source: Campus Input
Cross Reference Table: 
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

Data Element - AWDSUM
Element Name:  Award Period-Summer
Programming Name:  AWDSUM
Segment: 
Master Format A1
Unique Values:  2
Source: Campus Input
Cross Reference Table: 
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

Data Element - AWDWIN
Element Name:  Award Period-Winter
Programming Name:  AWDWIN
Segment: 
Master Format A1
Unique Values:  2
Source: Campus Input
Cross Reference Table: 
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

Data Element - AWDWKST
Element Name:  Award Type Indicator-Work Study
Programming Name:  AWDWKST
Segment: 
Master Format A1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - BIRTHDATE
Element Name:  Date of Birth
Programming Name:  BIRTHDATE
Segment: 
Master Format A6
Unique Values:  >1000
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - BLUEGOLD
Element Name:  Blue And Gold Flag
Programming Name:  BLUEGOLD
Segment: 
Master Format A1
Unique Values:  3
Source: Define-MF
Cross Reference Table: 
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: 

Data Element - BUDCOMP
Element Name:  Computer Budget Amount
Programming Name:  BUDCOMP
Segment: 
Master Format I6
Unique Values:  it represents the c
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - BUDCOMPFLG
Element Name:  Computer Budget Flag
Programming Name:  BUDCOMPFLG
Segment: 
Master Format A1
Unique Values:  2
Source: Define-MF
Cross Reference Table: 
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

Data Element - BUDGET
Element Name:  Student Budget Amount
Programming Name:  BUDGET
Segment: 
Master Format I6
Unique Values:  number
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - BUDGETFLG
Element Name:  Student Budget Flag
Programming Name:  BUDGETFLG
Segment: 
Master Format A1
Unique Values:  2
Source: Define-MF
Cross Reference Table: 
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

Data Element - CACCEPT
Element Name:  Award Accept Code
Programming Name:  CACCEPT
Segment: 
Master Format A1
Unique Values:  2
Source: Campus Input
Cross Reference Table: 
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

Data Element - CACHSBJENG
Element Name:  SATII Writing Exam Code-Best
Programming Name:  CACHSBJENG
Segment: 
Master Format A1
Unique Values:  2
Source: Campus Input
Cross Reference Table: 
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

Data Element - CACHSBJENGC
Element Name:  SATII Writing Exam Code Best - Campus
Programming Name:  CACHSBJENGC
Segment: 
Master Format A1
Unique Values:  2
Source: Campus Input
Cross Reference Table: 
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

Data Element - CACHSBJLSS
Element Name:  SATII Third Exam Code-Best
Programming Name:  CACHSBJLSS
Segment: 
Master Format A1
Unique Values:  18
Source: Campus Input
Cross Reference Table: 
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)

Data Element - CACHSBJLSSC
Element Name:  SATII Third Exam Code Best - Campus
Programming Name:  CACHSBJLSSC
Segment: 
Master Format A1
Unique Values:  18
Source: Campus Input
Cross Reference Table: 
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)

Data Element - CACHSBJMTH
Element Name:  SATII Math Exam Code-Best
Programming Name:  CACHSBJMTH
Segment: 
Master Format A1
Unique Values:  2
Source: Campus Input
Cross Reference Table: 
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

Data Element - CACHSBJMTHC
Element Name:  SATII Math Exam Code Best - Campus
Programming Name:  CACHSBJMTHC
Segment: 
Master Format A1
Unique Values:  2
Source: Campus Input
Cross Reference Table: 
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

Data Element - CACODE
Element Name:  Campus Code
Programming Name:  CACODE
Segment: 
Master Format A2
Unique Values:  10
Source: CSX Web application
Cross Reference Table: 
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

Data Element - CADMCAT
Element Name:  Applicant Level Code
Programming Name:  CADMCAT
Segment: 
Master Format A1
Unique Values:  7
Source: Define-MF
Cross Reference Table: 
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)

Data Element - CADMCAT2
Element Name:  Applicant Level Code - 3CAT
Programming Name:  CADMCAT2
Segment: 
Master Format A1
Unique Values:  3
Source: DWH-Define
Cross Reference Table: 
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

Data Element - CAFROSH
Element Name:  Applicant Freshman-CA High School
Programming Name:  CAFROSH
Segment: 
Master Format A1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - CAGENCY
Element Name:  Super Agency Code
Programming Name:  CAGENCY
Segment: 
Master Format A2
Unique Values: 
Source: AFPFUND file
Cross Reference Table: 
Define Code: 
Description: 
Comment: 
Code Interpretation: 

Data Element - CALCGPA
Element Name:  Grade Point Average-Freshman-Capped
Programming Name:  CALCGPA
Segment: 
Master Format F4.2
Unique Values:  number
Source: ETS
Cross Reference Table: 
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: 

Data Element - CALCGPA_R
Element Name:  Grade Point Average-Freshman-Capped-Repeats
Programming Name:  CALCGPA_R
Segment: 
Master Format F4.2
Unique Values:  number
Source: ETS
Cross Reference Table: 
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: 

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

Data Element - CALYR
Element Name:  Calendar Year Registered
Programming Name:  CALYR
Segment: 
Master Format A2
Unique Values:  1
Source: Input file
Cross Reference Table: 
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: 

Data Element - CAL_RES_1YR
Element Name:  California_Resident_1_Year
Programming Name:  CAL_RES_1YR
Segment: 
Master Format A1
Unique Values: 
Source: ETS
Cross Reference Table: 
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

Data Element - CAMPUS
Element Name:  Campus Name
Programming Name:  CAMPUS
Segment: 
Master Format 
Unique Values:  9
Source: Define-DWH
Cross Reference Table: 
Define Code: 
Description:  Campus name.
Comment: 
Code Interpretation: 

Data Element - CAMPUSAB
Element Name:  Campus Name Abbreviation
Programming Name:  CAMPUSAB
Segment: 
Master Format 
Unique Values:  9
Source: Define-DWH
Cross Reference Table: 
Define Code: 
Description:  Two-character abbreviation of campus name.
Comment: 
Code Interpretation: 

Data Element - CAMPUSNM
Element Name:  Campus Name
Programming Name:  CAMPUSNM
Segment: 
Master Format 
Unique Values:  9
Source: Define-DWH
Cross Reference Table: 
Define Code: 
Description:  Campus name.
Comment: 
Code Interpretation: 

Data Element - CANAFLAG
Element Name:  Cancelled by Student Flag
Programming Name:  CANAFLAG
Segment: 
Master Format I1
Unique Values:  3
Source: Define-MF
Cross Reference Table: 
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

Data Element - CANDFLAG
Element Name:  Cancelled Death Flag
Programming Name:  CANDFLAG
Segment: 
Master Format I1
Unique Values:  3
Source: Define-MF
Cross Reference Table: 
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

Data Element - CANFFLAG
Element Name:  Cancelled Falsification Flag
Programming Name:  CANFFLAG
Segment: 
Master Format I1
Unique Values:  3
Source: Define-MF
Cross Reference Table: 
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

Data Element - CANOFLAG
Element Name:  Cancelled Offer Withdrawn Flag
Programming Name:  CANOFLAG
Segment: 
Master Format I1
Unique Values:  3
Source: Define-MF
Cross Reference Table: 
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

Data Element - CAPPCAT
Element Name:  Applicant Level Code
Programming Name:  CAPPCAT
Segment: 
Master Format A1
Unique Values:  7
Source: Define-MF
Cross Reference Table: 
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)

Data Element - CAPPRCVD
Element Name:  Application Received Code
Programming Name:  CAPPRCVD
Segment: 
Master Format A1
Unique Values: 
Source: Define-MF
Cross Reference Table: 
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.

Data Element - CAPPRCVDBK
Element Name:  Application Recevied Code-Berkeley
Programming Name:  CAPPRCVDBK
Segment: 
Master Format A1
Unique Values:  2
Source: ETS
Cross Reference Table: 
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.

Data Element - CAPPRCVDDV
Element Name:  Application Recevied Code-Davis
Programming Name:  CAPPRCVDDV
Segment: 
Master Format A1
Unique Values:  2
Source: ETS
Cross Reference Table: 
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.

Data Element - CAPPRCVDIR
Element Name:  Application Recevied Code-Irvine
Programming Name:  CAPPRCVDIR
Segment: 
Master Format A1
Unique Values:  2
Source: ETS
Cross Reference Table: 
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.

Data Element - CAPPRCVDLA
Element Name:  Application Recevied Code-Los Angeles
Programming Name:  CAPPRCVDLA
Segment: 
Master Format A1
Unique Values:  2
Source: ETS
Cross Reference Table: 
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.

Data Element - CAPPRCVDMC
Element Name:  Application Received Code-Merced
Programming Name:  CAPPRCVDMC
Segment: 
Master Format A1
Unique Values:  2
Source: ETS
Cross Reference Table: 
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.

Data Element - CAPPRCVDRV
Element Name:  Application Recevied Code-Riverside
Programming Name:  CAPPRCVDRV
Segment: 
Master Format A1
Unique Values:  2
Source: ETS
Cross Reference Table: 
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.

Data Element - CAPPRCVDSB
Element Name:  Application Recevied Code-Santa Barbara
Programming Name:  CAPPRCVDSB
Segment: 
Master Format A1
Unique Values:  2
Source: ETS
Cross Reference Table: 
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.

Data Element - CAPPRCVDSC
Element Name:  Application Recevied Code-Santa Cruz
Programming Name:  CAPPRCVDSC
Segment: 
Master Format A1
Unique Values:  2
Source: ETS
Cross Reference Table: 
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.

Data Element - CAPPRCVDSD
Element Name:  Application Recevied Code-San Diego
Programming Name:  CAPPRCVDSD
Segment: 
Master Format A1
Unique Values:  2
Source: ETS
Cross Reference Table: 
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.

Data Element - CAPPTYPE
Element Name:  Applicant Direct Intercampus Transfer
Programming Name:  CAPPTYPE
Segment: 
Master Format A1
Unique Values:  2
Source: Define-MF
Cross Reference Table: 
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

Data Element - CASHSELIG
Element Name:  High School Eligibility Adv Stg Applicant
Programming Name:  CASHSELIG
Segment: 
Master Format A1
Unique Values:  <30
Source: No longer used.
Cross Reference Table: 
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)

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

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

Data Element - CAWDTYPE
Element Name:  Award Code
Programming Name:  CAWDTYPE
Segment: 
Master Format A3
Unique Values:  ~300
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CCAMPUS
Element Name:  Campus Registered Code
Programming Name:  CCAMPUS
Segment: 
Master Format A2
Unique Values:  9
Source: Campus Input
Cross Reference Table: 
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

Data Element - CCAMPUSAP
Element Name:  Campus Applied to Code
Programming Name:  CCAMPUSAP
Segment: 
Master Format A2
Unique Values:  9
Source: Campus Input
Cross Reference Table: 
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

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

Data Element - CCAMPUSAPBK
Element Name:  Applicant-Berkeley
Programming Name:  CCAMPUSAPBK
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - CCAMPUSAPDV
Element Name:  Applicant-Davis
Programming Name:  CCAMPUSAPDV
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - CCAMPUSAPIR
Element Name:  Applicant-Irvine
Programming Name:  CCAMPUSAPIR
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - CCAMPUSAPLA
Element Name:  Applicant-Los Angeles
Programming Name:  CCAMPUSAPLA
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

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

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

Data Element - CCAMPUSAPRV
Element Name:  Applicant-Riverside
Programming Name:  CCAMPUSAPRV
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - CCAMPUSAPSB
Element Name:  Applicant-Santa Barbara
Programming Name:  CCAMPUSAPSB
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - CCAMPUSAPSC
Element Name:  Applicant-Santa Cruz
Programming Name:  CCAMPUSAPSC
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - CCAMPUSAPSD
Element Name:  Applicant-San Diego
Programming Name:  CCAMPUSAPSD
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

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

Data Element - CCCTRANS
Element Name:  Applicant Transfer-CA Community College
Programming Name:  CCCTRANS
Segment: 
Master Format A1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - CCM3
Element Name:  Campus-College-Major-3rd Week
Programming Name:  CCM3
Segment: 
Master Format A7
Unique Values:  >1000
Source: Define-MF
Cross Reference Table: 
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.

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

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

Data Element - CCME
Element Name:  Campus-College-Major-End of Term
Programming Name:  CCME
Segment: 
Master Format A7
Unique Values:  >1000
Source: Define-MF
Cross Reference Table: 
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.

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

Data Element - CCMPRCNTAT
Element Name:  Campus of Most Recent Attendance Code
Programming Name:  CCMPRCNTAT
Segment: 
Master Format A2
Unique Values:  9
Source: Rename
Cross Reference Table: 
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

Data Element - CCOFC
Element Name:  Citizenship Country Code-Student
Programming Name:  CCOFC
Segment: 
Master Format A3
Unique Values:  ~360
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CCOL3
Element Name:  College Code-3rd Week
Programming Name:  CCOL3
Segment: 
Master Format A2
Unique Values:  ~65
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CCOL31
Element Name:  College Code-3rd Week-1
Programming Name:  CCOL31
Segment: 
Master Format A2
Unique Values:  ~65
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CCOL32
Element Name:  College Code-3rd Week-2
Programming Name:  CCOL32
Segment: 
Master Format A2
Unique Values:  ~65
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CCOL33
Element Name:  College Code-3rd Week-2
Programming Name:  CCOL33
Segment: 
Master Format A2
Unique Values:  ~65
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CCOLE
Element Name:  College Code-End of Term
Programming Name:  CCOLE
Segment: 
Master Format A2
Unique Values:  ~65
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CCOLE1
Element Name:  College Code-End of Term-1
Programming Name:  CCOLE1
Segment: 
Master Format A2
Unique Values:  ~65
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CCOLE2
Element Name:  College Code-End of Term-2
Programming Name:  CCOLE2
Segment: 
Master Format A2
Unique Values:  ~65
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CCOLE3
Element Name:  College Code-End of Term-3
Programming Name:  CCOLE3
Segment: 
Master Format A2
Unique Values:  ~65
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CCOLLEGE
Element Name:  College Code-End of Term
Programming Name:  CCOLLEGE
Segment: 
Master Format A2
Unique Values:  ~65
Source: Rename
Cross Reference Table: 
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.

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

Data Element - CCOLPRP1
Element Name:  College Code Proposed-1
Programming Name:  CCOLPRP1
Segment: 
Master Format A2
Unique Values:  ~65
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CCOLPRP2
Element Name:  College Code Proposed-2
Programming Name:  CCOLPRP2
Segment: 
Master Format A2
Unique Values:  ~65
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CCOLPRP3
Element Name:  College Code Proposed-3
Programming Name:  CCOLPRP3
Segment: 
Master Format A2
Unique Values:  ~65
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CDEGCOL
Element Name:  College Code for Degree Awarded
Programming Name:  CDEGCOL
Segment: 
Master Format A2
Unique Values:  ~65
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CDEGCOL1
Element Name:  College Code for Degree Awarded-1
Programming Name:  CDEGCOL1
Segment: 
Master Format A2
Unique Values:  ~65
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CDEGCOL2
Element Name:  College Code for Degree Awarded-2
Programming Name:  CDEGCOL2
Segment: 
Master Format A2
Unique Values:  ~65
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CDEGCOL3
Element Name:  College Code for Degree Awarded-3
Programming Name:  CDEGCOL3
Segment: 
Master Format A2
Unique Values:  ~65
Source: Campus Input
Cross Reference Table: 
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.

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

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

Data Element - CDEGMAJ1
Element Name:  Major Code for Degree Awarded-1
Programming Name:  CDEGMAJ1
Segment: 
Master Format A3
Unique Values:  >1000
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CDEGMAJ2
Element Name:  Major Code for Degree Awarded-2
Programming Name:  CDEGMAJ2
Segment: 
Master Format A3
Unique Values:  >1000
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CDEGMAJ3
Element Name:  Major Code for Degree Awarded-3
Programming Name:  CDEGMAJ3
Segment: 
Master Format A3
Unique Values:  >1000
Source: Campus Input
Cross Reference Table: 
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.

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

Data Element - CDEGPGM1
Element Name:  Degree Program Code-1
Programming Name:  CDEGPGM1
Segment: 
Master Format A2
Unique Values:  ~75
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CDEGPGM2
Element Name:  Degree Program Code-2
Programming Name:  CDEGPGM2
Segment: 
Master Format A2
Unique Values:  ~75
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CDEGPGM3
Element Name:  Degree Program Code-3
Programming Name:  CDEGPGM3
Segment: 
Master Format A2
Unique Values:  ~75
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CDEGQTR
Element Name:  Term Degree Awarded
Programming Name:  CDEGQTR
Segment: 
Master Format A1
Unique Values:  4
Source: Define-MF
Cross Reference Table: 
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

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

Data Element - CDISABILITY
Element Name:  Disability Type Code
Programming Name:  CDISABILITY
Segment: 
Master Format A1
Unique Values:  9
Source: Not Collected
Cross Reference Table: 
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: 

Data Element - CDISABILTY
Element Name:  Disability Type Code
Programming Name:  CDISABILTY
Segment: 
Master Format A1
Unique Values:  9
Source: Rename
Cross Reference Table: 
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.

Data Element - CDISTYPE
Element Name:  Disability Code
Programming Name:  CDISTYPE
Segment: 
Master Format A1
Unique Values:  9
Source: Campus Input
Cross Reference Table: 
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)

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

Data Element - CELIGADM
Element Name:  Eligibility for Admission-Campus Determination
Programming Name:  CELIGADM
Segment: 
Master Format A2
Unique Values:  ~25
Source: Define-MF
Cross Reference Table: 
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)

Data Element - CELIGADM2
Element Name:  Eligibility Campus-2 Category
Programming Name:  CELIGADM2
Segment: 
Master Format 
Unique Values:  3
Source: Define-DWH
Cross Reference Table: 
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

Data Element - CELIGADMR
Element Name:  Eligibility Campus Decision Reg
Programming Name:  CELIGADMR
Segment: 
Master Format A2
Unique Values:  ~25
Source: Define-DWH
Cross Reference Table: 
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)

Data Element - CELIGADMR2
Element Name:  Eligibility Campus Reg 2CAT
Programming Name:  CELIGADMR2
Segment: 
Master Format A1
Unique Values:  3
Source: Define-DWH
Cross Reference Table: 
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

Data Element - CELIGETSAS
Element Name:  Eligibility Transfer Estimated
Programming Name:  CELIGETSAS
Segment: 
Master Format A1
Unique Values:  10
Source: ETS
Cross Reference Table: 
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.

Data Element - CELIGETSHS
Element Name:  Eligibility Freshman Estimated
Programming Name:  CELIGETSHS
Segment: 
Master Format A1
Unique Values:  13
Source: ETS
Cross Reference Table: 
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).

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

Data Element - CETAD_ENG_CR
Element Name:  CETAD Evaluated English Transfer Course
Programming Name:  CETAD_ENG_CR
Segment: 
Master Format A1
Unique Values: 
Source: Vendor
Cross Reference Table: 
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

Data Element - CETAD_GPA_SR
Element Name:  CETAD Evaluated GPA SR
Programming Name:  CETAD_GPA_SR
Segment: 
Master Format F4.2
Unique Values: 
Source: Vendor
Cross Reference Table: 
Define Code: 
Description:  CETAD EVALUATED Transfer GPA
Comment: 
Code Interpretation: 

Data Element - CETAD_MTH_CR
Element Name:  CETAD Evaluated Math Transfer Course
Programming Name:  CETAD_MTH_CR
Segment: 
Master Format A1
Unique Values: 
Source: Vendor
Cross Reference Table: 
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

Data Element - CETAD_REASON
Element Name:  CETAD Reason Code
Programming Name:  CETAD_REASON
Segment: 
Master Format A2
Unique Values: 
Source: Vendor
Cross Reference Table: 
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

Data Element - CETAD_TRN_CR
Element Name:  CETAD Evaluated Transfer Courses
Programming Name:  CETAD_TRN_CR
Segment: 
Master Format A1
Unique Values: 
Source: Vendor
Cross Reference Table: 
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

Data Element - CETAD_U_Q
Element Name:  CETAD Evaluated Quarter Units
Programming Name:  CETAD_U_Q
Segment: 
Master Format F5.1
Unique Values: 
Source: Vendor
Cross Reference Table: 
Define Code: 
Description:  CETAD Evaluated Quarter Units
Comment: 
Code Interpretation: 

Data Element - CETHNIC
Element Name:  Ethnic Origin Code
Programming Name:  CETHNIC
Segment: 
Master Format A1
Unique Values: 
Source: Campus Input
Cross Reference Table: 
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

Data Element - CETHNICA
Element Name:  Ethnic Origin Code-Admission
Programming Name:  CETHNICA
Segment: 
Master Format A1
Unique Values:  16
Source: ETS
Cross Reference Table: 
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

Data Element - CETHNICR
Element Name:  Ethnic Origin Code-Registration
Programming Name:  CETHNICR
Segment: 
Master Format A1
Unique Values:  16
Source: Campus Input
Cross Reference Table: 
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

Data Element - CETH_HIER
Element Name:  Ethnic Hierarchy Code-Admission
Programming Name:  CETH_HIER
Segment: 
Master Format A2
Unique Values:  38
Source: ETS
Cross Reference Table: 
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

Data Element - CFDA_CODE
Element Name:  Catalog of Federal Domestic Assistance (CFDA) Number
Programming Name:  CFDA_CODE
Segment: 
Master Format A5
Unique Values: 
Source: AFPFUND file
Cross Reference Table: 
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: 

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

Data Element - CHARGED
Element Name:  Source School Charged Code
Programming Name:  CHARGED
Segment: 
Master Format A1
Unique Values:  3
Source: Define-MF
Cross Reference Table: 
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

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

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

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

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

Data Element - CHGAREATYPE
Element Name:  Charged School Area Type
Programming Name:  CHGAREATYPE
Segment: 
Master Format A1
Unique Values:  2
Source: X-Reference
Cross Reference Table: 
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

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

Data Element - CHGDIST
Element Name:  Charged School California District Code
Programming Name:  CHGDIST
Segment: 
Master Format A5
Unique Values:  >1000
Source: X-Reference
Cross Reference Table: 
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.

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

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

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

Data Element - CHGSTATUS
Element Name:  Charged School Status Code
Programming Name:  CHGSTATUS
Segment: 
Master Format A2
Unique Values:  3
Source: X-Reference
Cross Reference Table: 
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

Data Element - CHGTYPE
Element Name:  Charged School ATP Type Code
Programming Name:  CHGTYPE
Segment: 
Master Format A2
Unique Values:  11
Source: X-Reference
Cross Reference Table: 
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

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

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

Data Element - CHOMELOC
Element Name:  Home Location Code
Programming Name:  CHOMELOC
Segment: 
Master Format A3
Unique Values:  ~360
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CHSELIG
Element Name:  High School Eligibility Adv Stg Applicant
Programming Name:  CHSELIG
Segment: 
Master Format A1
Unique Values:  <30
Source: No longer used.
Cross Reference Table: 
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: 

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

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

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

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

Data Element - CIPCATE
Element Name:  CIP Category Code-EOT
Programming Name:  CIPCATE
Segment: 
Master Format A2
Unique Values: 
Source: 
Cross Reference Table: 
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: 

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

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

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

Data Element - CIPCATNME
Element Name:  CIP Category Name-EOT
Programming Name:  CIPCATNME
Segment: 
Master Format A20
Unique Values: 
Source: Define-DWH
Cross Reference Table: 
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: 

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

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

Data Element - CIPCODE
Element Name:  CIP Code
Programming Name:  CIPCODE
Segment: 
Master Format A6
Unique Values:  >1000
Source: CSX Web application
Cross Reference Table: 
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.

Data Element - CIPCODE3
Element Name:  CIP Code-3rd Week
Programming Name:  CIPCODE3
Segment: 
Master Format A6
Unique Values:  >1000
Source: X-Reference
Cross Reference Table: 
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.

Data Element - CIPCODED
Element Name:  CIP Code for Degree Awarded
Programming Name:  CIPCODED
Segment: 
Master Format A6
Unique Values:  >1000
Source: X-Reference
Cross Reference Table: 
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.

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

Data Element - CIPCODEE
Element Name:  CIP Code-End of Term
Programming Name:  CIPCODEE
Segment: 
Master Format A6
Unique Values:  >1000
Source: X-Reference
Cross Reference Table: 
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.

Data Element - CIPCODEG
Element Name:  CIP Code Proposed
Programming Name:  CIPCODEG
Segment: 
Master Format A6
Unique Values:  >1000
Source: X-Reference
Cross Reference Table: 
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.

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

Data Element - CIPNAME3
Element Name:  CIP Name-3rd Week
Programming Name:  CIPNAME3
Segment: 
Master Format A55
Unique Values:  >1000
Source: X-Reference
Cross Reference Table: 
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: 

Data Element - CIPNAMED
Element Name:  CIP Name for Degree Awarded
Programming Name:  CIPNAMED
Segment: 
Master Format A55
Unique Values:  >1000
Source: X-Reference
Cross Reference Table: 
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: 

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

Data Element - CIPNAMEE
Element Name:  CIP Name-End of Term
Programming Name:  CIPNAMEE
Segment: 
Master Format A55
Unique Values:  >1000
Source: X-Reference
Cross Reference Table: 
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: 

Data Element - CIPNAMEG
Element Name:  CIP Name Proposed
Programming Name:  CIPNAMEG
Segment: 
Master Format A55
Unique Values:  >1000
Source: X-Reference
Cross Reference Table: 
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.

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

Data Element - CITSTAT
Element Name:  Citizenship Status Code
Programming Name:  CITSTAT
Segment: 
Master Format A1
Unique Values: 
Source: Campus Input
Cross Reference Table: 
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)

Data Element - CITSTATA
Element Name:  Citizenship Status Code-Admission
Programming Name:  CITSTATA
Segment: 
Master Format A2
Unique Values:  37
Source: UAD: Mainframe define, GAD: Input file
Cross Reference Table: 
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.

Data Element - CITSTATR
Element Name:  Citizenship Status Code-Registration
Programming Name:  CITSTATR
Segment: 
Master Format A2
Unique Values:  37
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CITSTATR_1
Element Name:  Citizenship Status Year 1
Programming Name:  CITSTATR_1
Segment: 
Master Format A2
Unique Values:  37
Source: DWH define
Cross Reference Table: 
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.

Data Element - CITSTATUS
Element Name:  Citizenship Status-2CAT
Programming Name:  CITSTATUS
Segment: 
Master Format 
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - CITSTATUSA
Element Name:  Citizenship Status Adm-2CAT
Programming Name:  CITSTATUSA
Segment: 
Master Format A1
Unique Values:  3
Source: Define-DWH
Cross Reference Table: 
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

Data Element - CITSTATUSA_1
Element Name:  Citizenship Status Year 1 2CAT
Programming Name:  CITSTATUSA_1
Segment: 
Master Format A1
Unique Values:  3
Source: Define-DWH
Cross Reference Table: 
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

Data Element - CLASSYR
Element Name:  Class Year Code
Programming Name:  CLASSYR
Segment: 
Master Format A1
Unique Values:  7
Source: Campus Input
Cross Reference Table: 
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

Data Element - CLASTCAM
Element Name:  Prior Campus-ICT Applicant
Programming Name:  CLASTCAM
Segment: 
Master Format A2
Unique Values:  9
Source: Campus Input
Cross Reference Table: 
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

Data Element - CLSTSCHTYP
Element Name:  Last School Type Code
Programming Name:  CLSTSCHTYP
Segment: 
Master Format A1
Unique Values:  9
Source: ETS
Cross Reference Table: 
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)

Data Element - CMAJ3
Element Name:  Major Code-3rd Week
Programming Name:  CMAJ3
Segment: 
Master Format A3
Unique Values:  >1000
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CMAJ31
Element Name:  Major Code-3rd Week-1
Programming Name:  CMAJ31
Segment: 
Master Format A3
Unique Values:  >1000
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CMAJ32
Element Name:  Major Code-3rd Week-2
Programming Name:  CMAJ32
Segment: 
Master Format A3
Unique Values:  >1000
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CMAJ33
Element Name:  Major Code-3rd Week-3
Programming Name:  CMAJ33
Segment: 
Master Format A3
Unique Values:  >1000
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CMAJE
Element Name:  Major Code-End of Term
Programming Name:  CMAJE
Segment: 
Master Format A3
Unique Values:  >1000
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CMAJE1
Element Name:  Major Code-End of Term-1
Programming Name:  CMAJE1
Segment: 
Master Format A3
Unique Values:  >1000
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CMAJE2
Element Name:  Major Code-End of Term-2
Programming Name:  CMAJE2
Segment: 
Master Format A3
Unique Values:  >1000
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CMAJE3
Element Name:  Major Code-End of Term-3
Programming Name:  CMAJE3
Segment: 
Master Format A3
Unique Values:  >1000
Source: Campus Input
Cross Reference Table: 
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.

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

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

Data Element - CMAJPRP1
Element Name:  Major Code Proposed-1
Programming Name:  CMAJPRP1
Segment: 
Master Format A3
Unique Values:  >1000
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CMAJPRP2
Element Name:  Major Code Proposed-2
Programming Name:  CMAJPRP2
Segment: 
Master Format A3
Unique Values:  >1000
Source: Campus Input
Cross Reference Table: 
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.

Data Element - CMAJPRP3
Element Name:  Major Code Proposed-3
Programming Name:  CMAJPRP3
Segment: 
Master Format A3
Unique Values:  >1000
Source: Campus Input
Cross Reference Table: 
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.

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

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

Data Element - COCODE
Element Name:  College Code
Programming Name:  COCODE
Segment: 
Master Format A2
Unique Values:  ~65
Source: CSX Web application
Cross Reference Table: 
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.

Data Element - COFC
Element Name:  Country of Citizenship Name
Programming Name:  COFC
Segment: 
Master Format A28
Unique Values:  ~360
Source: X-Reference
Cross Reference Table: 
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: 

Data Element - COL
Element Name:  College Name-End of Term
Programming Name:  COL
Segment: 
Master Format A38
Unique Values:  ~65
Source: X-Reference
Cross Reference Table: 
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: 

Data Element - COL3
Element Name:  College Name-3rd Week
Programming Name:  COL3
Segment: 
Master Format A38
Unique Values:  ~65
Source: X-Reference
Cross Reference Table: 
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: 

Data Element - COLE
Element Name:  College Name-End of Term
Programming Name:  COLE
Segment: 
Master Format A38
Unique Values:  ~65
Source: X-Reference
Cross Reference Table: 
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: 

Data Element - COLGP
Element Name:  Transfer Grade Points-Total
Programming Name:  COLGP
Segment: 
Master Format F5.1
Unique Values:  number
Source: Campus Input
Cross Reference Table: 
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: 

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

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

Data Element - COLPRP2
Element Name:  College Name Proposed-2
Programming Name:  COLPRP2
Segment: 
Master Format A38
Unique Values:  ~65
Source: X-Reference
Cross Reference Table: 
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: 

Data Element - COLPRP3
Element Name:  College Name Proposed-3
Programming Name:  COLPRP3
Segment: 
Master Format A38
Unique Values:  ~65
Source: X-Reference
Cross Reference Table: 
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: 

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

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

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

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

Data Element - COMT3
Element Name:  Units Completed-Total to Date-3rd Week
Programming Name:  COMT3
Segment: 
Master Format F5.1
Unique Values:  number
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - COMTE
Element Name:  Units Completed-Total to Date-End of Term
Programming Name:  COMTE
Segment: 
Master Format F5.1
Unique Values:  number
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - COMTE_1
Element Name:  Units Completed TTD Year-1
Programming Name:  COMTE_1
Segment: 
Master Format F5.1
Unique Values: 
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - COMTE_2
Element Name:  Units Completed TTD Year-2
Programming Name:  COMTE_2
Segment: 
Master Format F5.1
Unique Values: 
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - COMTE_3
Element Name:  Units Completed TTD Year-3
Programming Name:  COMTE_3
Segment: 
Master Format F5.1
Unique Values: 
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - COMTE_4
Element Name:  Units Completed TTD Year-4
Programming Name:  COMTE_4
Segment: 
Master Format F5.1
Unique Values: 
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - COMTE_5
Element Name:  Units Completed TTD Year-5
Programming Name:  COMTE_5
Segment: 
Master Format F5.1
Unique Values: 
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - COMTE_6
Element Name:  Units Completed TTD Year-6
Programming Name:  COMTE_6
Segment: 
Master Format F5.1
Unique Values: 
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - COMTE_7
Element Name:  Units Completed TTD Year-7
Programming Name:  COMTE_7
Segment: 
Master Format F5.1
Unique Values: 
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - COMYTD
Element Name:  Units Completed-Year to Date-End of Term
Programming Name:  COMYTD
Segment: 
Master Format F4.1
Unique Values:  number
Source: Define-MF
Cross Reference Table: 
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: 

Data Element - COMYTD_1
Element Name:  Units Completed YTD Year-1
Programming Name:  COMYTD_1
Segment: 
Master Format F5.1
Unique Values: 
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - COMYTD_2
Element Name:  Units Completed YTD Year-2
Programming Name:  COMYTD_2
Segment: 
Master Format F5.1
Unique Values: 
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - COMYTD_3
Element Name:  Units Completed YTD Year-3
Programming Name:  COMYTD_3
Segment: 
Master Format F5.1
Unique Values: 
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - COMYTD_4
Element Name:  Units Completed YTD Year-4
Programming Name:  COMYTD_4
Segment: 
Master Format F5.1
Unique Values: 
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - COMYTD_5
Element Name:  Units Completed YTD Year-5
Programming Name:  COMYTD_5
Segment: 
Master Format F5.1
Unique Values: 
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - COMYTD_6
Element Name:  Units Completed YTD Year-6
Programming Name:  COMYTD_6
Segment: 
Master Format F5.1
Unique Values: 
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - COMYTD_7
Element Name:  Units Completed YTD Year-7
Programming Name:  COMYTD_7
Segment: 
Master Format F5.1
Unique Values: 
Source: Define-DWH
Cross Reference Table: 
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: 

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

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

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

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

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

Data Element - CPERSTATSTD
Element Name:  Persistence Status
Programming Name:  CPERSTATSTD
Segment: 
Master Format A1
Unique Values:  8
Source: Define-MF
Cross Reference Table: 
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)

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

Data Element - CPREVSCH
Element Name:  Source School Code
Programming Name:  CPREVSCH
Segment: 
Master Format A6
Unique Values:  >1000
Source: Define-MF
Cross Reference Table: 
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.

Data Element - CQTR
Element Name:  Term Registered
Programming Name:  CQTR
Segment: 
Master Format N/A
Unique Values: 
Source: Campus Input
Cross Reference Table: 
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

Data Element - CQTR1ST
Element Name:  Registered Summer - 3rd Week
Programming Name:  CQTR1ST
Segment: 
Master Format I1
Unique Values:  2
Source: Define
Cross Reference Table: 
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: 

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

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

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

Data Element - CQUARTERAP
Element Name:  Term Applied For
Programming Name:  CQUARTERAP
Segment: 
Master Format A1
Unique Values:  1
Source: Campus Input
Cross Reference Table: 
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

Data Element - CREDUAP
Element Name:  Units Credited By Exam - AP
Programming Name:  CREDUAP
Segment: 
Master Format F5.1
Unique Values:  number
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - CREDUCC
Element Name:  Units Credited From CCC
Programming Name:  CREDUCC
Segment: 
Master Format F5.1
Unique Values:  number
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - CREDUIB
Element Name:  Units Credited By Exam - IB
Programming Name:  CREDUIB
Segment: 
Master Format F5.1
Unique Values:  number
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - CREDUOT
Element Name:  Units Credited From Other Non-UC
Programming Name:  CREDUOT
Segment: 
Master Format F5.1
Unique Values:  number
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - CREDUUC
Element Name:  Units Credited By Exam - UC
Programming Name:  CREDUUC
Segment: 
Master Format F5.1
Unique Values:  number
Source: Campus Input
Cross Reference Table: 
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: 

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

Data Element - CREGISTERS
Element Name:  Registered Flag
Programming Name:  CREGISTERS
Segment: 
Master Format I1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - CREGSTAT3
Element Name:  Registration Status Code-3rd Week
Programming Name:  CREGSTAT3
Segment: 
Master Format A1
Unique Values:  3
Source: Campus Input
Cross Reference Table: 
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)

Data Element - CREGSTATE
Element Name:  Registration Status Code-End of Term
Programming Name:  CREGSTATE
Segment: 
Master Format A1
Unique Values:  3
Source: Campus Input
Cross Reference Table: 
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)

Data Element - CREGSTATF
Element Name:  Registration Status Code-Fall
Programming Name:  CREGSTATF
Segment: 
Master Format A1
Unique Values:  3
Source: Define-MF
Cross Reference Table: 
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)

Data Element - CREGSTATP
Element Name:  Registration Status Code-Prior To Withdrawal
Programming Name:  CREGSTATP
Segment: 
Master Format A1
Unique Values:  4
Source: Campus Input
Cross Reference Table: 
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)

Data Element - CREGSTATS
Element Name:  Registration Status Code-Spring
Programming Name:  CREGSTATS
Segment: 
Master Format A1
Unique Values:  3
Source: Define-MF
Cross Reference Table: 
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)

Data Element - CREGSTATSU
Element Name:  Registration Status Code-Summer
Programming Name:  CREGSTATSU
Segment: 
Master Format A1
Unique Values:  3
Source: Define-MF
Cross Reference Table: 
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)

Data Element - CREGSTATW
Element Name:  Registration Status Code-Winter
Programming Name:  CREGSTATW
Segment: 
Master Format A1
Unique Values:  3
Source: Define-MF
Cross Reference Table: 
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)

Data Element - CREL
Element Name:  Counselor Release Flag
Programming Name:  CREL
Segment: 
Master Format A1
Unique Values:  3
Source: ETS
Cross Reference Table: 
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

Data Element - CSIR
Element Name:  SIR Response Code
Programming Name:  CSIR
Segment: 
Master Format A1
Unique Values:  7
Source: Define-MF
Cross Reference Table: 
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)

Data Element - CSOURCE
Element Name:  Authorizing Agency Code
Programming Name:  CSOURCE
Segment: 
Master Format A1
Unique Values:  8
Source: X-Reference
Cross Reference Table: 
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

Data Element - CSPECIALTY
Element Name:  Specialty Code-Residents
Programming Name:  CSPECIALTY
Segment: 
Master Format A2
Unique Values:  ~30
Source: Campus Input
Cross Reference Table: 
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

Data Element - CSPONCAT
Element Name:  Sponsor Category Code
Programming Name:  CSPONCAT
Segment: 
Master Format A02
Unique Values: 
Source: AFPFUND file
Cross Reference Table: 
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

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

Data Element - CSRCSCH
Element Name:  Source School ATP Code
Programming Name:  CSRCSCH
Segment: 
Master Format A6
Unique Values:  >1000
Source: Rename
Cross Reference Table: 
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.

Data Element - CSRCSUP
Element Name:  Source of Support Code
Programming Name:  CSRCSUP
Segment: 
Master Format A2
Unique Values: 
Source: Campus Input
Cross Reference Table: 
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

Data Element - CSTUDLVL3
Element Name:  Student Level Code-3rd Week
Programming Name:  CSTUDLVL3
Segment: 
Master Format A1
Unique Values:  12
Source: Campus Input
Cross Reference Table: 
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

Data Element - CSTUDLVL3L
Element Name:  Student Level Code-3rd Week-Label
Programming Name:  CSTUDLVL3L
Segment: 
Master Format 
Unique Values:  11
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - CSTUDLVL3S
Element Name:  Student Level Code-3rd Week-Sort
Programming Name:  CSTUDLVL3S
Segment: 
Master Format 
Unique Values:  11
Source: Define-DWH
Cross Reference Table: 
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

Data Element - CSTUDLVLE
Element Name:  Student Level Code-End of Term
Programming Name:  CSTUDLVLE
Segment: 
Master Format A1
Unique Values:  12
Source: Campus Input
Cross Reference Table: 
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

Data Element - CSTUDLVLF
Element Name:  Student Level Code-Fall
Programming Name:  CSTUDLVLF
Segment: 
Master Format A1
Unique Values:  12
Source: Define-MF
Cross Reference Table: 
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

Data Element - CSTUDLVLS
Element Name:  Student Level Code-Spring
Programming Name:  CSTUDLVLS
Segment: 
Master Format A1
Unique Values:  12
Source: Define-MF
Cross Reference Table: 
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

Data Element - CSTUDLVLSU
Element Name:  Student Level Code-Summer
Programming Name:  CSTUDLVLSU
Segment: 
Master Format A1
Unique Values:  12
Source: Define-MF
Cross Reference Table: 
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

Data Element - CSTUDLVLW
Element Name:  Student Level Code-Winter
Programming Name:  CSTUDLVLW
Segment: 
Master Format A1
Unique Values:  12
Source: Define-MF
Cross Reference Table: 
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

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

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

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

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

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

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

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

Data Element - CSUBAGENCY
Element Name:  Sub Super Agency Code
Programming Name:  CSUBAGENCY
Segment: 
Master Format A2
Unique Values: 
Source: AFPFUND file
Cross Reference Table: 
Define Code: 
Description: 
Comment: 
Code Interpretation: 

Data Element - CSUBJAR
Element Name:  Subject A Requirement Code
Programming Name:  CSUBJAR
Segment: 
Master Format A1
Unique Values:  9
Source: Define-MF
Cross Reference Table: 
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)

Data Element - CSUBJARR
Element Name:  Subject A Requirement Met - Campus Reg
Programming Name:  CSUBJARR
Segment: 
Master Format A2
Unique Values: 
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - CTERM
Element Name:  Term Registered Code
Programming Name:  CTERM
Segment: 
Master Format A1
Unique Values:  4
Source: Campus Input
Cross Reference Table: 
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

Data Element - CTERMENTR
Element Name:  Term Entered UC
Programming Name:  CTERMENTR
Segment: 
Master Format A1
Unique Values:  3
Source: Define-MF
Cross Reference Table: 
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

Data Element - CTYPE
Element Name:  Award Type Code
Programming Name:  CTYPE
Segment: 
Master Format A1
Unique Values:  7
Source: X-Reference
Cross Reference Table: 
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

Data Element - CUGDEGSCH
Element Name:  Undergraduate School ATP Code
Programming Name:  CUGDEGSCH
Segment: 
Master Format A6
Unique Values:  >1000
Source: Campus Input
Cross Reference Table: 
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: 

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

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

Data Element - DEACTYEAR FAI
Element Name:  Award Deactivation Year
Programming Name:  DEACTYEAR FAI
Segment: 
Master Format A4
Unique Values: 
Source: SFS
Cross Reference Table: 
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: 

Data Element - DEFERFLAG
Element Name:  Deferment Flag
Programming Name:  DEFERFLAG
Segment: 
Master Format I1
Unique Values:  3
Source: Define-MF
Cross Reference Table: 
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

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

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

Data Element - DEGCAT
Element Name:  Degree Awarded Category
Programming Name:  DEGCAT
Segment: 
Master Format 
Unique Values:  11
Source: Define-DWH
Cross Reference Table: 
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

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

Data Element - DEGCATLABP
Element Name:  Degree Category Name Proposed
Programming Name:  DEGCATLABP
Segment: 
Master Format A4
Unique Values:  12
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - DEGCATLABP2
Element Name:  Degree Category Name Proposed-2
Programming Name:  DEGCATLABP2
Segment: 
Master Format A4
Unique Values:  14
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - DEGCATP
Element Name:  Degree Category Code Proposed
Programming Name:  DEGCATP
Segment: 
Master Format A1
Unique Values:  12
Source: Define-DWH
Cross Reference Table: 
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

Data Element - DEGCOL
Element Name:  College Name for Degree Awarded
Programming Name:  DEGCOL
Segment: 
Master Format A38
Unique Values:  ~65
Source: X-Reference
Cross Reference Table: 
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: 

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

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

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

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

Data Element - DEGPGM1
Element Name:  Degree Program Code-1
Programming Name:  DEGPGM1
Segment: 
Master Format A2
Unique Values:  ~75
Source: Campus Input
Cross Reference Table: 
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.

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

Data Element - DEGPGM1NM
Element Name:  Degree Program Name-1
Programming Name:  DEGPGM1NM
Segment: 
Master Format A50
Unique Values:  ~75
Source: X-Reference
Cross Reference Table: 
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: 

Data Element - DEGPGM2
Element Name:  Degree Program Code-2
Programming Name:  DEGPGM2
Segment: 
Master Format A2
Unique Values:  72
Source: Campus Input
Cross Reference Table: 
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.

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

Data Element - DEGPGM2NM
Element Name:  Degree Program Name-2
Programming Name:  DEGPGM2NM
Segment: 
Master Format A50
Unique Values:  ~75
Source: X-Reference
Cross Reference Table: 
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: 

Data Element - DEGPGM3
Element Name:  Degree Program Code-3
Programming Name:  DEGPGM3
Segment: 
Master Format A2
Unique Values:  72
Source: Campus Input
Cross Reference Table: 
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.

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

Data Element - DEGPGM3NM
Element Name:  Degree Program Name-3
Programming Name:  DEGPGM3NM
Segment: 
Master Format A50
Unique Values:  ~75
Source: X-Reference
Cross Reference Table: 
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: 

Data Element - DEGQTR
Element Name:  Term Degree Awarded
Programming Name:  DEGQTR
Segment: 
Master Format N/A
Unique Values: 
Source: Campus Input
Cross Reference Table: 
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

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

Data Element - DEGREE1
Element Name:  Degree Program Name-1
Programming Name:  DEGREE1
Segment: 
Master Format A50
Unique Values:  72
Source: X-Reference
Cross Reference Table: 
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: 

Data Element - DEGREE2
Element Name:  Degree Program Name-2
Programming Name:  DEGREE2
Segment: 
Master Format A50
Unique Values:  72
Source: X-Reference
Cross Reference Table: 
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.

Data Element - DEGREE3
Element Name:  Degree Program Name-3
Programming Name:  DEGREE3
Segment: 
Master Format A50
Unique Values:  72
Source: X-Reference
Cross Reference Table: 
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: 

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

Data Element - DEGREEABB2
Element Name:  Degree Program Abbreviation-2
Programming Name:  DEGREEABB2
Segment: 
Master Format A9
Unique Values:  72
Source: X-Reference
Cross Reference Table: 
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.

Data Element - DEGREEABB3
Element Name:  Degree Program Abbreviation-3
Programming Name:  DEGREEABB3
Segment: 
Master Format A9
Unique Values:  72
Source: X-Reference
Cross Reference Table: 
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.

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

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

Data Element - DEGREEPABB
Element Name:  Degree Program Abbreviation
Programming Name:  DEGREEPABB
Segment: 
Master Format A9
Unique Values:  72
Source: X-Reference
Cross Reference Table: 
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.

Data Element - DEGTERM
Element Name:  Degree Term
Programming Name:  DEGTERM
Segment: 
Master Format A1
Unique Values:  4
Source: Define MF
Cross Reference Table: 
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

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

Data Element - DEPEND
Element Name:  Household Size
Programming Name:  DEPEND
Segment: 
Master Format I1
Unique Values:  <20
Source: Campus Input
Cross Reference Table: 
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: 

Data Element - DEPENDFLG
Element Name:  Household Size Flag
Programming Name:  DEPENDFLG
Segment: 
Master Format A1
Unique Values:  2
Source: Define-MF
Cross Reference Table: 
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

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

Data Element - DEPEND_APP_PR
Element Name:  Dependents of Applicant - Previous Year
Programming Name:  DEPEND_APP_PR
Segment: 
Master Format F2
Unique Values:  <20
Source: ETS
Cross Reference Table: 
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: 

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

Data Element - DEPEND_PAR_PR
Element Name:  Dependents of Parents of Applicant - Previous Year
Programming Name:  DEPEND_PAR_PR
Segment: 
Master Format F2
Unique Values:  <20
Source: ETS
Cross Reference Table: 
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: 

Data Element - DEPSTATF
Element Name:  Dependency Status Code-Federal
Programming Name:  DEPSTATF
Segment: 
Master Format A1
Unique Values:  2
Source: Campus Input
Cross Reference Table: 
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

Data Element - DEPSTATS
Element Name:  Dependency Status Code-State
Programming Name:  DEPSTATS
Segment: 
Master Format A1
Unique Values:  2
Source: Campus Input
Cross Reference Table: 
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

Data Element - DOCCOMP10YR
Element Name:  Tenth Year Doctorate Completion Flag
Programming Name:  DOCCOMP10YR
Segment: 
Master Format A1
Unique Values:  2
Source: Define-DWH
Cross Reference Table: 
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

Data Element - DOCDEG1
Element Name:  Doctoral Degree Awarded 1 Type
Programming Name:  DOCDEG1
Segment: 
Master Format A1
Unique Values: 
Source: Campus Input
Cross Reference Table: 
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)

Data Element - DOCDEG2
Element Name:  Doctoral Degree Awarded 2 Type
Programming Name:  DOCDEG2
Segment: 
Master Format A1
Unique Values: 
Source: Campus Input
Cross Reference Table: 
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)

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

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

Data Element - DSAT1MS
Element Name:  SATI Math Score-Derived
Programming Name:  DSAT1MS
Segment: 
Master Format F3
Unique Values:  61
Source: Define-DWH
Cross Reference Table: 
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: 

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

Data Element - DSAT1VS
Element Name:  SATI Verbal Score-Derived
Programming Name:  DSAT1VS
Segment: 
Master Format F3
Unique Values:  61
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - DSAT23C
Element Name:  SATII 3rd Code-Derived
Programming Name:  DSAT23C
Segment: 
Master Format A2
Unique Values:  19
Source: Define-DWH
Cross Reference Table: 
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)

Data Element - DSAT23S
Element Name:  SATII 3rd Score-Derived
Programming Name:  DSAT23S
Segment: 
Master Format F3
Unique Values:  61
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - DSAT2M2S
Element Name:  SATII Math2 Score-Derived
Programming Name:  DSAT2M2S
Segment: 
Master Format F3
Unique Values:  61
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - DSAT2MS
Element Name:  SATII Math1 Score-Derived
Programming Name:  DSAT2MS
Segment: 
Master Format F3
Unique Values:  61
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - DSAT2WS
Element Name:  SATII Writing Score-Derived
Programming Name:  DSAT2WS
Segment: 
Master Format F3
Unique Values:  61
Source: Define-DWH
Cross Reference Table: 
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: 

Data Element - DTAPPRCD
Element Name:  Application Received Date
Programming Name:  DTAPPRCD
Segment: 
Master Format A6