Financial Aid Demographics - January, May, October
# REF NO Input File Field Name Non Input File Field Name CDW Table Name CDW Field Name Field Description Code Values UCDW Star-Schema Name UCDW Star Table Name UCDW Star Field Name
1 N/A   Year Registered AY Stu_FAI_AY_Demo_Tbl Year_Registered_AY The academic year during which the student is registered for classes NOT APPLICABLE STUD_BI
FILE_CYCLE_D FILE_CYCLE_ACAD_YR
2 A010 Campus Registered Code   Stu_FAI_AY_Demo_Tbl Campus_Registered_Code Code indicating the campus at which the student or postdoctoral scholar is registered 01 = Berkeley
02 = San Francisco
03 = Davis
04 = Los Angeles
05 = Riverside
06 = San Diego
07 = Santa Cruz
08 = Santa Barbara
09 = Irvine
10 = Merced
STUD_BI
CAMPUS_LOCATION_D
STUDENT_D
CMP_LOC_LOC1_CD
STUD_LOC_CMP_CD
3 N/A   Campus Name Stu_FAI_AY_Demo_Tbl Campus_Name Name indicating the campus at which the student or postdoctoral scholar is registered. BERKELEY
DAVIS
IRVINE
LOS ANGELES
MERCED
RIVERSIDE
SAN DIEGO
SAN FRANCISCO
SANTA BARBARA
SANTA CRUZ
STUD_BI
CAMPUS_LOCATION_D CMP_LOC_LOC1_LNG_DESC
4 N/A   Campus Name Abbreviation Stu_FAI_AY_Demo_Tbl Campus_Name_Abbreviation Two-character abbreviation of campus name 01 = Berkeley - BK
02 = San Francisco - SF
03 = Davis - DV
04 = Los Angeles - LA
05 = Riverside - RV
06 = San Diego - SD
07 = Santa Cruz - SC
08 = Santa Barbara - SB
09 = Irvine - IR
10 = Merced - MC
STUD_BI
CAMPUS_LOCATION_D CMP_LOC_LOC1_ABRV_DESC
5 A020 Identification Number - Student   Stu_FAI_AY_Demo_Tbl Identification_Number_REG Character string which uniquely identifies a student in the UCOP database.Student Identification Number varies in length from campus to campus NOT APPLICABLE STUD_BI
STUDENT_D STUD_ID
6 N/A   Student Name Stu_FAI_AY_Demo_Tbl Name_Student The name of the student, applicant, or postdoctoral scholar.Last Name (comma) First Name (space) Middle Names (comma) Suffix NOT APPLICABLE STUD_BI
STUDENT_D STUD_FST_NAM
STUD_LST_NAM
7 N/A   Social Security Number - Student Stu_FAI_AY_Demo_Tbl Social_Security_Number The current number assigned to an individual by the Social Security Administration NOT APPLICABLE STUD_BI
STUDENT_D STUD_SOC_SEC_NUM
8 N/A   Sex Code Stu_FAI_AY_Demo_Tbl Sex_Code Code identifying a person as male or female F = Female
M = Male
U or blank=Unknown
STUD_BI
STUDENT_D STUD_GNDR_CD
STUD_GNDR_DESC
9 N/A   Date of Birth YYMMDD Stu_FAI_AY_Demo_Tbl Birthdate The year, month and day on which the person was born. Converted to YYYY/MM/DD for data warehouse tables NOT APPLICABLE STUD_BI
STUDENT_D STUD_DT_OF_BTH
10 N/A   Home Location Code Stu_FAI_AY_Demo_Tbl Home_Location_Code Code indicating for U.S. citizens, permanent residents, and refugees, the country (if address is outside the U.S.), state (if outside California), or county (if within California) for the student's permanent address. For visa holders, code indicating the country of permanent residence. Countries listed in the Location table must be on the State Department or the UN list of valid countries Refer to Location Table
STUD_BI
STUDENT_D STUD_HM_LOC_CD
11 N/A   Ethnic Origin Code-Registration Stu_FAI_AY_Demo_Tbl Ethnic_Origin_Code_Reg Code indicating the ethnic background of the student as recorded at the time of registration 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
STUD_BI
UC_ETHNIC_CODE_LEVEL_1_D
UC_ETHNIC_CODE_LEVEL_1_V
ETHNIC_CODE_V
UC_ETN_CD_LVL_1_CD
12 N/A   Ethnic Origin Name-Registration Stu_FAI_AY_Demo_Tbl Ethnic_Origin_Name_Reg Name of race/ethnicity category at registration 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
STUD_BI
UC_ETHNIC_CODE_LEVEL_1_D
UC_ETHNIC_CODE_LEVEL_1_V
ETHNIC_CODE_V
UC_ETN_CD_LVL_1_CD_NAM
13 N/A   Ethnic Origin Name - 9 CAT Stu_FAI_AY_Demo_Tbl Ethnic_Origin_Name_Reg_9CAT Name of race/ethnicity category at registration - 9 categories. AI = American Indian
BLACK = Black
CHIC = Chicano
LAT = Latino
PIL = Filipino
ASIAN = Asian
WHITE = White
DTS = Decline to State
OTHER = Other
STUD_BI
UC_ETHNIC_CODE_LEVEL_1_D
UC_ETHNIC_CODE_LEVEL_1_V
ETHNIC_CODE_V
UC_ETN_CD_LVL_1_9CAT_NAM
14 N/A   Ethnic Origin Name-IPEDS Stu_FAI_AY_Demo_Tbl Ethnic_Origin_Name_IPEDS Race/ethnic origin category name for purposes of IPEDS reporting. Note: If the IPEDS ethnicity is unknown then the UC ethnicity hierarchy rules are used to define IPEDS ethnicity. If the UC ethnicity is also unknown, then IPEDS ethnicity is set to 'UNKWN' AI
ASIAN
BLACK
HISP
MULTI (Two or More Races)
NORES (Non-Resident Alien)
PI
UNKWN
WHITE
STUD_BI ETHNIC_CODE_V
IPEDS_ETHNIC_CODE_V
IPEDS_ETHNIC_CODE_D
IPEDS_ETN_CD
IPEDS_ETN_CD_NAM
15 N/A   Citizenship Status Code - Reg Stu_FAI_AY_Demo_Tbl Citizenship_Status_Code_Reg Code indicating student's citizenship status with respect to the United States at the time of registration. Refer to Citizenship/Visa Status Code Table
STUD_BI
STUDENT_D STUD_CZ_STAT_CD
STUD_CZ_STAT_DESC
16 N/A   Citizenship Status Code - 2CAT Stu_FAI_AY_Demo_Tbl Citizenship_Status_Code_2CAT Two-category code indicating domestic or foreign citizenship/visa status. D = Domestic
F = Foreign
STUD_BI
STUDENT_D STUD_DMSTC_FGN_CZ_STAT_CD
STUD_DMSTC_FGN_CZ_STAT_DESC
17 N/A   Country of Citizenship Code Stu_FAI_AY_Demo_Tbl Country_of_Citizenship_Code Code indicating the country of citizenship of a student visa holder or the former country of citizenship of a student refugee. Based on Location Code table Refer to Location Table
STUD_BI
STUDENT_D
COUNTRY_STATE_COUNTY_D
CTRY_ST_CNTY_LOC_CD
STUD_CZ_CTRY_CD
18 N/A   Source School Code Stu_FAI_AY_Demo_Tbl Source_School_Code Code indicating the school charged with greatest responsibility for undergraduate applicant's eligibility or, if no school is charged, then the last school attended Refer to ATP School Code Table
STUD_BI
ATP_SCHOOL_D ATP_SCH_ATP_CD
19 N/A   Source School Name Stu_FAI_AY_Demo_Tbl Source_School_Name Name of the school of origin attributed to the undergraduate applicant. Refer to ATP School Code Table
STUD_BI
ATP_SCHOOL_D ATP_SCH_NAM
20 N/A   Source School SDE Code Stu_FAI_AY_Demo_Tbl Source_School_SDE_Code State of California Department of Education Code indicating the school of origin of the undergraduate applicant or student. Refer to ATP School Code Table
STUD_BI
ATP_SCHOOL_D ATP_SCH_SDE_CD
21 N/A   Source School Area Type Stu_FAI_AY_Demo_Tbl Source_School_Area_Type Area type code for the school of origin attributed to the undegraduate applicant Refer to ATP School Code Table
STUD_BI
ATP_SCHOOL_D ATP_SCH_AREA_TY_CD
22 N/A   Source School City Stu_FAI_AY_Demo_Tbl Source_School_City City location for the school of origin attributed to the undergraduate applicant Refer to ATP School Code Table
STUD_BI
ATP_SCHOOL_D ATP_SCH_CTY_NAM
23 N/A   Source School District Stu_FAI_AY_Demo_Tbl Source_School_District California school district code for the school of origin attributed to the undergraduate applicant Refer to ATP School Code Table
STUD_BI
ATP_SCHOOL_D ATP_SCH_DSTR_CD
24 N/A   Source School Location Code Stu_FAI_AY_Demo_Tbl Source_School_Location_Code Location code for the school of origin attributed to the undergraduate applicant Refer to ATP School Code Table
STUD_BI
ATP_SCHOOL_D ATP_SCH_LOC_CD
25 N/A   Source School State Stu_FAI_AY_Demo_Tbl Source_School_State State location for the school of origin attributed to the undergraduate applicant Refer to ATP School Code Table
STUD_BI
ATP_SCHOOL_D ATP_SCH_ST_CD
26 N/A   Source School Status Code Stu_FAI_AY_Demo_Tbl Source_School_Status_Code Status code (public, private or unknown) for the school of origin attributed to the undergraduate applicant Refer to ATP School Code Table
STUD_BI
ATP_SCHOOL_D ATP_SCH_STAT_CD
27 N/A   Source School Type Defined Stu_FAI_AY_Demo_Tbl Source_School_Type_Defined Code indicating the type of school of origin A, B, C, D, E, F, G, H, K, L
STUD_BI
ATP_SCHOOL_D ATP_SCH_DRVD_TY_CD
28 N/A   Source School Type Name Stu_FAI_AY_Demo_Tbl Source_School_Type_Name Name corresponding to Source School Type Defined A = California Public High School
B = California Private High School
C = California Public 2-Year College
D = California Private 2-Year College
E = California Public 4-Year College (CSU)
F = California Private 4-Year College
G = University of California
H = Other (not to include unknown)
K = Non-California Institution (US)
L = Foreign Institution
STUD_BI
ATP_SCHOOL_D ATP_SCH_DRVD_TY_DESC
29 N/A   Applicant Level Code Stu_FAI_AY_Demo_Tbl Applicant_Level_Code Code indicating the academic status for which the applicant qualifies 1 = EXAP - Early Admission Accelerated Program
2 = Freshman
3 = Advanced Standing-Freshman
4 = Advanced Standing-Sophomore
5 = Advanced Standing-Junior
6 = Advanced Standing-Senior
7 = Limited
8 = Special
9 = 2nd Baccalaureate
0 = DAP (Dual Admission)
UAD_BI CAMPUS_ELIGIBILITY_D CMP_ELGBLTY_AL_LVL_CD
30 N/A   Applicant Level Code 3CAT Stu_FAI_AY_Demo_Tbl Applicant_Level_Code_3CAT Code indicating three-category academic status for which the applicant qualifies F = Freshman
T = Transfer
O = Other
Unknown/Blank
UAD_BI CAMPUS_ELIGIBILITY_D CMP_ELGBLTY_AL_LVL_3CAT_CD
31 N/A   Eligibility Campus Decision Stu_FAI_AY_Demo_Tbl Eligibility_Campus_Decision Code indicating eligibility status (admit/defer) of applicant for admission 01 - 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 doesn't want to consider appl. further for adm. Doesn't meet camp. criteria. Appl. 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 - Othr Alt Adm offr #2 CCC cntrct with prrty or guar. Adm. as advncd stndng stdnt pndng good acdmc work. Stdnt hasn't ncssrly accptd the offr
35 - Cancel - Applicant Voluntary cancellation by applicant (before evaluation)
36 - Cancel - Campus-Death Campus cancels application. Code can only show actual cancellation of an admit due to death
37 - Cancel - Campus- Campus cancels application. Code can Falsification only show actual cancellation of an admit due to student falsification
38 - Cancel-Offer Withdrawn Campus withdraws admission offer - provision not met by applicant
40 - OP Cancellation due to Verification non-response
41 - OP cancellation due to Verification falsification
42 - OP cancellation due to other falsification
50 - Alternate admissions offer - Dual Admissions
51 - Campus reviewed; DAP eligible, not retained (for DAP Referral)
UAD_BI CAMPUS_ELIGIBILITY_D CMP_ELGBLTY_CMP_DECN_CD
32 N/A   Eligibility Campus 2CAT Stu_FAI_AY_Demo_Tbl Eligibility_Campus_2CAT Code indicating two-category admission type (regular or special) R = Regular Admit
S = Special Admit
Unknown/Blank
UAD_BI CAMPUS_ELIGIBILITY_D CMP_ELGBLTY_CMP_2CAT_CD
33 N/A   Income of Applicant of Admissions Stu_FAI_AY_Demo_Tbl Income_Applicant_ADM Annual gross income of applicant for undergraduate admission in calendar year preceding academic year NOT APPLICABLE UAD_BI APPLICATION_F APPL_AL_CUR_YR_INC_AMT
34 N/A   Income of Applicant Unknown Flag Stu_FAI_AY_Demo_Tbl Income_Applicant_ADM_Unknown_Flg Income of applicant missing from the application for undergraduate admission Y = Yes
N = No
Blank/Unknown
UAD_BI APPLICATION_F APPL_INC_AL_UNKN_IND
35 N/A   Income of Parent of Admissions Stu_FAI_AY_Demo_Tbl Income_Parent_ADM Annual gross income of parents of applicant for undergraduate admission in calendar year preceding academic year NOT APPLICABLE UAD_BI APPLICATION_F APPL_FMY_CUR_YR_INC_AMT
36 N/A   Income of Parent Unknown Flag Stu_FAI_AY_Demo_Tbl Income_Parent_ADM_Unknown_Flag Income of parent missing from the application for undergraduate admission Y = Yes
N = No
Blank/Unknown
UAD_BI APPLICATION_F APPL_INC_PARS_UNKN_IND
37 N/A   GPA Freshman Self Reported Stu_FAI_AY_Demo_Tbl GPA_Freshman_SR The overall GPA (excluding physical education) reported by the freshman applicant for the 10th and 11th grades of high school NOT APPLICABLE UAD_BI APPLICATION_F APPL_SLFRPTED_FRSHMN_GPA_SCO
38 N/A   Transfer Grade Points-Total Stu_FAI_AY_Demo_Tbl Trans_Grade_Points_Total Total grade points (in quarter units) earned for college level graded work attempted at all institutions, including U.C NOT APPLICABLE UAD_BI CAMPUS_APPLIED_F CMP_APPLD_TOT_TR_GRD_PNTS
39 N/A   Transfer Units Attempted-Graded-Total Stu_FAI_AY_Demo_Tbl Trans_Units_Attmptd_Grded_Ttl College level graded work (in quarter units) attempted at all institutions, including U.C NOT APPLICABLE UAD_BI CAMPUS_APPLIED_F CMP_APPLD_TOT_TR_ATM_UNTS
40 N/A   Transfer Units Accepted-Total Stu_FAI_AY_Demo_Tbl Trans_Units_Accepted_Total College level graded and pass/not pass work(in quarter units) accepted from all institutions, including U.C NOT APPLICABLE UAD_BI CAMPUS_APPLIED_F CMP_APPLD_TOT_TR_ACD_UNTS
41 N/A   ACT Composite Score-Best Stu_FAI_AY_Demo_Tbl ACT_Composite_Score_Best Score which is the average of four test scores of ACT, rounded to the nearest whole number NOT APPLICABLE UAD_BI TEST_F TST_SCO
42 N/A   SATI Math Exam Score-Best Stu_FAI_AY_Demo_Tbl SATI_Math_Score_Best Score received on the College Entrance Examination Board scholastic aptitude mathematics test in the sitting at which the best total score was received NOT APPLICABLE UAD_BI TEST_F TST_SCO
43 N/A   SATI Verbal Score-Best Stu_FAI_AY_Demo_Tbl SATI_Verbal_Score_Best Score received on the College Entrance Examination Board scholastic aptitude verbal test in the sitting at which the best total score was received NOT APPLICABLE UAD_BI TEST_F TST_SCO
44 N/A   Units Attempted First Term Stu_FAI_AY_Demo_Tbl Units_Attempted_First_Term 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 NOT APPLICABLE STUD_BI
SFS_ENROLLMENT_F SFS_ENRL_ATM_FST_T_IN_AY_UNTS
45 N/A   Units Attempted-Total to Date-Graded-UC-End of Term Stu_FAI_AY_Demo_Tbl Units_Attempted_TTD_Grded_UC_EOT 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 NOT APPLICABLE STUD_BI
SFS_ENROLLMENT_F SFS_ENRL_ATM_TTD_GRDD_UC_UNTS
46 N/A   Grade Points-Total to Date-UC-End of Term Stu_FAI_AY_Demo_Tbl Grade_Points_TTD_UC_EOT The sum of the grade points earned to date at UC in letter graded courses, as of the end of the specified term NOT APPLICABLE STUD_BI
SFS_ENROLLMENT_F SFS_ENRL_TTD_UC_GRD_PNTS
47 N/A   Disability Code Stu_FAI_AY_Demo_Tbl Disability_Permanent_Code 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 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
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)
STUD_BI
STUDENT_D STUD_DSBLTY_CD
48 N/A   Term First Enrolled Stu_FAI_AY_Demo_Tbl Term_First_Enrolled The year and quarter in which undergraduate student was admitted NOT APPLICABLE STUD_BI
TERM_D ACAD_T_CD
ACAD_T_ACAD_YR
49 N/A   Term Entered UC Stu_FAI_AY_Demo_Tbl Term_Entered_Code Quarter/Semester in which the student first enrolled in a graduate or undergraduate program NOT APPLICABLE STUD_BI
TERM_D ACAD_T_CD
50 N/A   Academic Year Entered UC Stu_FAI_AY_Demo_Tbl Year_Entered_AY Academic year in which a student first entered an undergraduate program at UC. Also known as Cohort year NOT APPLICABLE STUD_BI
TERM_D ACAD_T_ACAD_YR
51 N/A   Registered-Fall Term Stu_FAI_AY_Demo_Tbl Registered_Fall_Term Code indicating that student was registered at third week or later during the fall term 1 - Yes
0 - No
STUD_BI SFS_ENROLLMENT_F SFS_ENRL_REGD_FALL_EOT_FL
52 N/A   Registered-Winter Term Stu_FAI_AY_Demo_Tbl Registered_Winter_Term Code indicating that student was registered at third week or later during the winter term 1 - Yes
0 - No
STUD_BI SFS_ENROLLMENT_F SFS_ENRL_REGD_WINTER_EOT_FL
53 N/A   Registered-Spring Term Stu_FAI_AY_Demo_Tbl Registered_Spring_Term Code indicating that student was registered at third week or later during the spring term 1 - Yes
0 - No
STUD_BI SFS_ENROLLMENT_F SFS_ENRL_REGD_SPR_EOT_FL
54 N/A   Registered-Fall 3rd Week Stu_FAI_AY_Demo_Tbl Registered_Fall_3WK Code indicating that student was registered at third week during the fall term 1 - Yes
0 - No
STUD_BI SFS_ENROLLMENT_F SFS_ENRL_REGD_FALL_3WK_FL
55 N/A   Registered-Winter 3rd Week Stu_FAI_AY_Demo_Tbl Registered_Winter_3WK Code indicating that student was registered at third week during the winter term 1 - Yes
0 - No
STUD_BI SFS_ENROLLMENT_F SFS_ENRL_REGD_WINTER_3WK_FL
56 N/A   Registered-Spring 3rd Week Stu_FAI_AY_Demo_Tbl Registered_Spring_3WK Code indicating that student was registered at third week during the spring term 1 - Yes
0 - No
STUD_BI SFS_ENROLLMENT_F SFS_ENRL_REGD_SPR_3WK_FL
57 N/A   Registration Status Code-3rd Week Stu_FAI_AY_Demo_Tbl Registration_Status_Code_3WK Code indicating registration status of the student as of the end of the thrid week of classes 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)
STUD_BI ENROLLMENT_STATUS_D ENRL_STAT_REG_STAT_CD
ENRL_STAT_REG_STAT_DESC
58 N/A   Student Level Code-3rd Week Stu_FAI_AY_Demo_Tbl Student_Level_Code_3WK 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 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
STUD_BI STUDENT_LEVEL_D STUD_LVL_CD
59 N/A   Student Level Code-3rd Week-Label Stu_FAI_AY_Demo_Tbl Student_Level_Code_3WK_L 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 Freshman (0 to 44.9 completed units)
Sophomore (45.0 to 89.9 completed units)
Junior (90.0 to 134.9 completed units)
Senior (135.0 or more completed units)
Special
Limited
Postbaccalaureate: student holds a baccalaureate degree and sole degree objective is teacher education credential.
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
Doctoral 1: Degree objective is academic or professional doctorate, but student has not been advanced to candidacy
Doctoral 2: Degree objective is academic or professional doctorate, and student has been advanced to candidacy (enrolled 9 quarters or less)
Doctoral 2A: Student enrolled for more than 9 quarters (6 semesters) as Doctoral 2
Resident
STUD_BI STUDENT_LEVEL_D STUD_LVL_DESC
60 N/A   Residence Status Code-Registration-3rd Week Stu_FAI_AY_Demo_Tbl Residence_Status_Code_Reg_3WK Code indicating an applicant's Californis residence status for use in determination of tuition and fees, as of third week R = California resident
N = Not California resident
STUD_BI
STUDENT_D STUD_RESI_STAT_FEES_CD
STUD_RESI_STAT_FEES_DESC
61 N/A   Residence Status Fees 3WK 3CAT Stu_FAI_AY_Demo_Tbl Residence_Status_Reg_3WK_3CAT Three-category code indicating residency status and citizenship/visa status as of the end of the 3rd week of classes CA RES
NR-DOM
NR-FOR
UNK
STUD_BI
STUDENT_D STUD_3CAT_RESI_STAT_NAM
62 N/A   Self-Supporting Program 3WK Stu_FAI_AY_Demo_Tbl Program_Self_Supporting Code indicating student is enrolled in a self-supporting program et third week Y = Yes
N = No
STUD_BI
CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_SLF_SUPPORTING_PGM_FL
63 N/A   Professional School Fee Amount Stu_FAI_AY_Demo_Tbl Professional_School_Fees The amount assessed the student for Professional School Fees for the term specified. Amounts should be reported in whole dollars only. This data element should be included on both the Third Week and End-of-Term enrollment files NOT APPLICABLE STUD_BI SFS_ENROLLMENT_F SFS_ENRL_ASED_PRO_SCH_FEE_AMT
64 N/A   College Code-3rd Week Stu_FAI_AY_Demo_Tbl College_Code_3WK 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. Refer to College Code Table
STUD_BI
CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_LOC_CG_CD
65 N/A   College Name-3rd Week Stu_FAI_AY_Demo_Tbl College_Name_3WK 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 Refer to College Code Table
STUD_BI
CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_LOC_CG_NAM
66 N/A   Major Code-3rd Week Stu_FAI_AY_Demo_Tbl Major_Code_3WK Code indicating the academic program (major) in which the student is enrolled as of the end of the third week of classes Refer to Major Code Table
STUD_BI
CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_MAJ_CD
67 N/A   Major Name-3rd Week Stu_FAI_AY_Demo_Tbl Major_Name_3WK Name of the academic program(major) in which the student is enrolled as of the end of the third week of classes Refer to Major Code Table
STUD_BI
CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_ID_LNG_NAM
CMP_CG_MAJ_CD_ID_SHRT_NAM
68 N/A   CIP Code - 3WK Stu_FAI_AY_Demo_Tbl CIP_Code_3WK 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 Refer to CIP Code Table
STUD_BI
CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_CIP_CD
69 N/A   CIP Name - 3WK Stu_FAI_AY_Demo_Tbl CIP_Name_3WK 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 Refer to CIP Code Table
STUD_BI
CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_CIP_NAM
70 N/A   CIP Category Code - 3WK Stu_FAI_AY_Demo_Tbl CIP_Category_Code_3WK Two-digit Classification of Instructional Programs code, indicating disciplinary area, as of third week NOT APPLICABLE STUD_BI
CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_CIP_FMY_CD
71 N/A   CIP Category Name - 3WK Stu_FAI_AY_Demo_Tbl CIP_Category_Name_3WK Discipline name for two-digit Classification of Instructional Programs code, indicating disciplinary area, as of third week NOT APPLICABLE STUD_BI
CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_CIP_FMY_NAM
72 N/A   Subcampus Code-3rd Week Stu_FAI_AY_Demo_Tbl Subcampus_Code_3WK Code indicating whether a student's program of study is considered, for budgetary purposes, a general campus, a health science, or a marine science program, as of the end of the third week of classes G = General Campus
H = Health Science
M = Marine Science
STUD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_HLTH_SCI_IND
73 N/A   Degree Program Code-1 Stu_FAI_AY_Demo_Tbl Degree_Program_Code_1 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 Refer to Degree Code Table
STUD_BI ACADEMIC_DEGREE_D ACAD_DGR_CD
74 N/A   Full Year Equivalent Stu_FAI_AY_Demo_Tbl Full_Year_Equivalent Number reflecting the number of primary terms the student was enrolled in during the academic year. 1 means the student was enrolled in all terms. NOT APPLICABLE STUD_BI SFS_ENROLLMENT_F SFS_ENRL_FU_YR_EQUIV_UNTS
75 N/A   Program-Student Athlete Stu_FAI_AY_Demo_Tbl Pgm_Student_Athlete Code indicating student is a student athlete. Y = Yes
Blank = No
STUD_BI
STUDENT_D STUD_SPEC_PGM_ATHLETE_CD
STUD_SPEC_PGM_ATHLETE_DESC
76 N/A   Program-Physically Disabled Stu_FAI_AY_Demo_Tbl Pgm_Physically_Disabled Code indicating student is physically disabled. Y = Yes
Blank = No
STUD_BI
STUDENT_D STUD_SPEC_PGM_PHYSLY_DISABLE_CD
STUD_SPEC_PGM_PHYSLY_DISABLE_DESC
77 N/A   Program-Enrolled Abroad Program Stu_FAI_AY_Demo_Tbl Pgm_Enrolled_Abroad Code indicating student is enrolled in the Education Abroad Program. Y = Yes
Blank = No
STUD_BI
STUDENT_D STUD_SPEC_PGM_EDU_ABRD_CD
STUD_SPEC_PGM_EDU_ABRD_DESC
78 N/A   Program-Postbaccalaureate Credential Stu_FAI_AY_Demo_Tbl Pgm_Postbacc_Credential Code indicating student is enrolled in a postbaccalaureate program. Y = Yes
Blank = No
STUD_BI
STUDENT_D STUD_SPEC_PGM_PST_BCCLRT_CD
STUD_SPEC_PGM_PST_BCCLRT_DESC
79 N/A   Program-UCDC Stu_FAI_AY_Demo_Tbl Pgm_UCDC Code indicating student is enrolled in at UCDC. Y = Yes
Blank = No
STUD_BI
STUDENT_D STUD_SPEC_PGM_UCDC_CD
STUD_SPEC_PGM_UCDC_DESC
80 N/A   Program-Visitor Stu_FAI_AY_Demo_Tbl Pgm_Visitor Code indicating student is a visiting student. Y = Yes
Blank = No
STUD_BI
STUDENT_D STUD_SPEC_PGM_VSTR_CD
STUD_SPEC_PGM_VSTR_DESC
81 N/A   Graduate Academic Program Flag Stu_FAI_AY_Demo_Tbl Graduate_Academic_Program_Flag NOT APPLICABLE NOT APPLICABLE NOT IN UCDW STAR NOT IN UCDW STAR NOT IN UCDW STAR
82 R100 Amount Student Budget   Stu_FAI_AY_Demo_Tbl Budget_Amount_Student 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) NOT APPLICABLE STUD_BI STUDENT_DEMOGRAPHIC_F STUD_DEMOGR_STUD_BDG_AMT
83 N/A   Student Budget Flag Stu_FAI_AY_Demo_Tbl Student_Budget_Flag Flag indicator for Student Budget element to distinguish values that were true zeroes from those which were blank or missing R = Real Zero
M = Missing
NOT IN UCDW STAR NOT IN UCDW STAR NOT IN UCDW STAR
84 R200 Budget-Computer   Stu_FAI_AY_Demo_Tbl Budget_Amount_Computer 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 NOT APPLICABLE STUD_BI STUDENT_DEMOGRAPHIC_F STUD_DEMOGR_COMPUTER_BDG_AMT
85 N/A   Computer Budget Flag Stu_FAI_AY_Demo_Tbl Budget_Amount_Computer_Flag Flag indicator for Amount Budget-Computer-Financial Aid element to distinguish values that were true zeros from those which were blank or missing R = Real Zero
M = Missing
NOT IN UCDW STAR NOT IN UCDW STAR NOT IN UCDW STAR
86 R010 Student's Household Size   Stu_FAI_AY_Demo_Tbl Household_Size 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. 0
1
2
3
4
5
6
7
8
9
STUD_BI STUDENT_DEMOGRAPHIC_F STUD_DEMOGR_HOHLD_SZ
87 N/A   Household Size Flag Stu_FAI_AY_Demo_Tbl Household_Size_Flag Flag indicator for Household Size element to distinguish values that are real zeroes from those which are blank or missing R = Real Zero
M = Missing
NOT IN UCDW STAR NOT IN UCDW STAR NOT IN UCDW STAR
88 R030 Dependent/Self Support Code-Federal   Stu_FAI_AY_Demo_Tbl Dependency_Status_Code_Federal Code indicating the Financial Aid Office determination of whether student is self-supporting or dependent upon family for support according to federal regulations. D = Dependent
I = Independent
Blank
STUD_BI DEMOGRAPHIC_REFERENCE_D DEMOGR_REF_FED_DPNDT_SLF_SUPPORT_CD
DEMOGR_REF_FED_DPNDT_SLF_SUPPORT_DESC
89 R190 Expected Family Contribution Amount(EFC)   Stu_FAI_AY_Demo_Tbl Expected_Family_Contrib_Amount A numerical value which is reported on the Student Aid report (SAR) and is calculated by Federal Methodology that establishes the level of student eligibility in the determination of the amount of the student's Federal grant, loan, or work study award NOT APPLICABLE STUD_BI STUDENT_DEMOGRAPHIC_F STUD_DEMOGR_EXPD_FMY_CTRB_AMT
90 N/A   Expected Family Contribution Flag Stu_FAI_AY_Demo_Tbl Expected_Family_Contrib_Flag Flag indicator for Expected Family Contribution element to distinguish values that are real zeroes from those which are blank or missing. R = Real Zero
M = Missing
NOT IN UCDW STAR NOT IN UCDW STAR NOT IN UCDW STAR
91 R230 FAFSA   Stu_FAI_AY_Demo_Tbl FAFSA Code indicating whether or not the student (financial aid recipient or applicant) filed a FAFSA or CA Dream Act Application before or after March 2nd. Y = FAFSA filed by March 2nd
L = FAFSA filed after March 2nd
N = FAFSA not filed
D = CA Dream Act App filed by March 2nd
P = CA Dream Act Appl filed after March 2nd
STUD_BI DEMOGRAHPIC_MISCELLANEOUS_D DEMOGR_MISC_FAFSA_CD
92 R050 Housing Type Code   Stu_FAI_AY_Demo_Tbl Housing_Type_Code Code indicating the student's type of housing while enrolled. C = Commuter (living with parents)
R = Residence Hall
O = Off Campus
STUD_BI DEMOGRAPHIC_REFERENCE_D DEMOGR_REF_HSG_TY_CD
DEMOGR_REF_HSG_TY_DESC
93 R020 Marital Status Code   Stu_FAI_AY_Demo_Tbl Marital_Status_Code Code indicating an individual's marital status. M = Married
S = Single
STUD_BI DEMOGRAPHIC_REFERENCE_D DEMOGR_REF_MRTL_STAT_CD
DEMOGR_REF_MRTL_STAT_DESC
94 N/A   Veteran Code Stu_FAI_AY_Demo_Tbl Veteran_Code Code indicating whether or not individual has served with the US Armed Forces. As of Fall 2007, this element is no longer populated Y = Yes
N = No
NOT IN UCDW STAR NOT IN UCDW STAR NOT IN UCDW STAR
95 R240 Need-Based Aid Application   Stu_FAI_AY_Demo_Tbl Need_Based_Aid_Application Code indicating whether or not the student filed and completed his/her financial aid application on-time, late or not at all. Note: Aid Application includes both the FAFSA & CA Dream Act Application. C = Aid application filed with complete on-time application
L = Aid application filed with complete late application
I = Aid application filed with incomplete information
N = No Aid Application filed
STUD_BI DEMOGRAHPIC_MISCELLANEOUS_D DEMOGR_MISC_ND_BSD_AID_APPL_CD
DEMOGR_MISC_ND_BSD_AID_APPL_DESC
96 N/A   Aid Type Indicator Stu_FAI_AY_Demo_Tbl Financial_Aid_Received_Indicator Code indicating that financial aid recipient has received aid other than non-work study earnings. Y = Yes
N = No
STUD_BI DEMOGRAHPIC_MISCELLANEOUS_D DEMOGR_MISC_FINL_AID_RECD_FL
97 N/A   Aid Need Based Indicator Stu_FAI_AY_Demo_Tbl Aid_Need_Based_Indicator Code indicating that financial aid recipient has received at least one need-based award. Y = Yes
N = No
STUD_BI DEMOGRAHPIC_MISCELLANEOUS_D DEMOGR_MISC_AID_ND_BSD_FL
98 N/A   Aid Non-need Based Indicator Stu_FAI_AY_Demo_Tbl Aid_Non_Need_Based_Indicator Code indicating that financial aid recipient has received at least one non-need-based award. Y = Yes
N = No
STUD_BI DEMOGRAHPIC_MISCELLANEOUS_D DEMOGR_MISC_AID_NON_ND_BSD_FL
99 R080 Parent Contribution Amount   Stu_FAI_AY_Demo_Tbl Contribution_Parent The amount of support the Financial Aid Office expects parents of a dependent Financial Aid applicant to contribute. For an independent student this is the amount of parental support reported by the student NOT APPLICABLE STUD_BI STUDENT_DEMOGRAPHIC_F STUD_DEMOGR_PARAL_CTRB_AMT
100 N/A   Parent Contribution Flag Stu_FAI_AY_Demo_Tbl Contribution_Parent_Flag Flag indicator for Parental Contribution element to distinguish values that were real zeroes from those that were blank or missing. R = Real Zero
M = Missing
NOT IN UCDW STAR NOT IN UCDW STAR NOT IN UCDW STAR
101 R090 Student Contribution Amount   Stu_FAI_AY_Demo_Tbl Contribution_Student The amount the Financial Aid Office expects the student to contribute to his or her own support. (Outside agency benefits or awards are not included in this category.) NOT APPLICABLE STUD_BI STUDENT_DEMOGRAPHIC_F STUD_DEMOGR_STUD_CTRB_AMT
102 N/A   Student Contribution Flag Stu_FAI_AY_Demo_Tbl Contribution_Student_Flag Flag indicator for Student Contribution element to distinguish values that were real zeroes from those which were blank or missing. R = Real Zero
M = Missing
NOT IN UCDW STAR NOT IN UCDW STAR NOT IN UCDW STAR
103 R060 Parent Income Amount   Stu_FAI_AY_Demo_Tbl Income_Parent_FAI The amount of annual gross taxable and non-taxable income of the parents of the dependent student (dependent as defined by Federal regulations), or of the parents of an independent student if available or required. Amount Parent Income should reflect the actual amount used in performing need analysis in accordance with Federal Methodology. For most students this should represent the verified income not the self-reported income (FAFSA). NOT APPLICABLE STUD_BI STUDENT_DEMOGRAPHIC_F STUD_DEMOGR_PAR_INC_AMT
104 N/A   Parent Income Flag Stu_FAI_AY_Demo_Tbl Income_Parent_FAI_Flag Flag indicator for Parent's Income element distinguishing values that were real zeroes from those that were blank or missing. R = Real Zero
M = Missing
NOT IN UCDW STAR NOT IN UCDW STAR NOT IN UCDW STAR
105 R070 Student Income Amount   Stu_FAI_AY_Demo_Tbl Income_Student_FAI The amount of annual gross taxable and non-taxable income of a dependent or an independent student, including spouse's income if student is married. Amount Student Income should reflect the actual amount used in performing need analysis in accordance with Federal Methodology. Research and Teaching Assistant earnings, as well as any other earnings from employment other than College Work Study should be included. Only Federal, State of California, and University Work Study earnings should be excluded. NOT APPLICABLE STUD_BI STUDENT_DEMOGRAPHIC_F STUD_DEMOGR_STUD_INC_AMT
106 N/A   Student Income Flag Stu_FAI_AY_Demo_Tbl Income_Student_FAI_Flag Flag indicator for Student Income element to distinguish values that were real zeroes from those that were blank or missing. R = Real Zero
M = Missing
NOT IN UCDW STAR NOT IN UCDW STAR NOT IN UCDW STAR
107 R210 Special Programs Code-Financial Aid   Stu_FAI_AY_Demo_Tbl Special_Programs_FAI Code indicating student's participation in special programs other than EOP or AAP and receiving Financial Aid. NOT APPLICABLE STUD_BI DEMOGRAHPIC_MISCELLANEOUS_D DEMOGR_MISC_SPEC_PGM_CD
DEMOGR_MISC_SPEC_PGM_DESC
108 N/A   Academic Professional Status 3WK Stu_FAI_AY_Demo_Tbl Acad_Prof_Status_3WK 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. A = Academic
P = Professional
U = Unknown
STUD_BI CAMPUS_COLLEGE_MAJOR_CODE_D CMP_CG_MAJ_CD_MAST_ACAD_PRO_CD
CMP_CG_MAJ_CD_DCTRT_ACAD_PRO_CD
109 N/A   Military Service Status Stu_FAI_AY_Demo_Tbl Military_Service Code Indicating the military service status of applicant. Self-reported 1 = Veteran
2 = Active Military Duty
3 = Reserves or National Guard
4 = Veteran and Active Military Duty
5 = Veteran and Reserves or National Guard
6 = Active Military Duty and Reserves or National Guard
7 = Veteran and Active Military Duty and Reserves or National Guard
Blank
UAD_BI APPLICANT_D AL_STAT_MILIT_RELHIP_CD
AL_STAT_MILIT_RELHIP_DESC
110 R250 Parent_AGI   Stu_FAI_AY_Demo_Tbl Parent_AGI_Amount Amount of the Adjusted Gross Income of the parents of the dependent student (dependent as defined by Federal regulations), or of the parents of an independent student if available or required. Should reflect the actual amount used in performing need analysis in accordance with Federal Methodology. For some students this should represent the verified income and not the self-reported income (FAFSA). NOT APPLICABLE STUD_BI STUDENT_DEMOGRAPHIC_F STUD_DEMOGR_PAR_ADJD_GRS_INC_AMT
111 N/A   Parent AGI Flag Stu_FAI_AY_Demo_Tbl Parent_AGI_Flag Flag indicator for Parent's AGI element distinguishing values that were real zeroes from those that were blank or missing R = Real Zero
M = Missing
NOT IN UCDW STAR NOT IN UCDW STAR NOT IN UCDW STAR
112 R260 Student_AGI   Stu_FAI_AY_Demo_Tbl Student_AGI_Amount Amount of the Adjusted Gross Income of a dependent or an independent student, including spouse's income if student is married. Should reflect the actual amount used in performing need analysis in accordance with Federal Methodology. For some students this should represent the verified income and not the self-reported income (FAFSA). NOT APPLICABLE STUD_BI STUDENT_DEMOGRAPHIC_F STUD_DEMOGR_STUD_ADJD_GRS_INC_AMT
113 N/A   Student AGI Flag Stu_FAI_AY_Demo_Tbl Student_AGI_Flag Flag indicator for Student's AGI element distinguishing values that were real zeroes from those that were blank or missing. R = Real Zero
M = Missing
NOT IN UCDW STAR NOT IN UCDW STAR NOT IN UCDW STAR
114 R270 Blue_And_Gold_Flag   Stu_FAI_AY_Demo_Tbl Blue_And_Gold_Flag Indicator showing whether the student is eligible for Blue and Gold Opportunity Plan. This element is not applicable in the summer period. Y = Yes
N = No
STUD_BI DEMOGRAHPIC_MISCELLANEOUS_D DEMOGR_MISC_BLUE_AND_GO_IND
DEMOGR_MISC_BLUE_AND_GO_DESC
115 R280 SHIP_Flag   Stu_FAI_AY_Demo_Tbl SHIP_Flag Indicator showing whether the student is eligible for SHIP Y = Yes
N = No
STUD_BI DEMOGRAHPIC_MISCELLANEOUS_D DEMOGR_MISC_SHIP_IND
DEMOGR_MISC_SHIP_DESC