OVERVIEW OF MEP BASIC DATA ELEMENTS-REVISED
2005-06
Quick Reference of Fields
Field Name / Data Type / Brief DescriptionEXPDATE / Date / Date that the file being sent to Statewide was created.
CENTERID / Text / Three digit center code
SSN / Text / Social Security number of the student.
BIRTHDAY / Date / Birthday of the student
STUNAMEL / Text / Last name of the student
STUNAMEF / Text / First name of the student
STUNAMEM / Text / Middle name of the student
P_ADDR1 / Text / Permanent street address of the student, line one.
P_ADDR2 / Text / Permanent street address of the student, line two
P_CITY / Text / City of the permanent address
P_STATE / Text / State of the permanent address
P_ZIP / Text / Zip Code of the permanent address
P_PHONE / Text / Phone number for the permanent address
C_ADDR1 / Text / If applicable, temporary street address of the student, line one
C_ADDR2 / Text / If applicable, temporary street address of the student, line two
C_CITY / Text / If applicable, city of the temporary address
C_STATE / Text / If applicable, state of the temporary address
C_ZIP / Text / If applicable, zip code of the temporary address
C_PHONE / Text / If applicable, phone number for the temporary address
EMAIL / Text / If applicable, email address for the student
GENDER / Text / One digit code for gender of the student
ETHNIC / Text / Two digit code for ethnicity of the student
TRIBALAFF / Text / Tribal Affiliation of the student, if the student is American Indian.
LANGUAGE / Number / Language spoken in student's home
EMOTHER / Text / Mother's Level of Education
EFATHER / Text / Father's Level of Education
HS_GPA / Number / High School grade point average
HS_CDS / Text / High School CDS Code
HSGRADYR / Number / High School graduation year
LCOLLEGE / Text or Number / Last college attended
SAT_1 / Number / Verbal, Math and Composite Scores
ACT / Number / % ACT Sub-scores and Composite
MESAEXPS / Number / Previous MESA STC participation
MESAEXPM / Number / Previous MESA MSP participation
MESAEXPC / Number / Previous MESA CCCP participation
MESAEXPY / Number / Total number of years of previous MESA STC/MSP/CCCP experience
TRANSGPA / Number / Transfer GPA
TRSUNITS / Number / Transfer units
MAJOR / Number / Campus Major
LEVEL / Number / Student level based on units
EXP_GRAD / Number / Expected year of graduation at entry
PROGRESS / Number / Progress toward graduation
1ST_MATH / Number / First math course taken at this college
ENROLSTAT / Number / Enrollment status current term
CONTSTAT / Number / Continuing status current term
LAST_CAY / Number / Last complete academic year
AC_STAND / Number / Status at end of last complete academic year
UNITSCOM / Number / Units completed toward graduation last complete academic year
CUMUNCOM / Number / Cumulative units completed toward graduation by end of last complete academic year
DEGREE / Number / Any degree received by the end of the last complete academic year
Detailed Explanation of Fields
EXPDATE CENTER PROVIDES
Export Date - This field indicates the date that the export file was created. Six digits (yyyymmdd).
CENTERID CENTER PROVIDES
This is the three-digit code that represents the center where the record originated. The following are the suggested codes:
Center Type / Center Name / Center IDMEP / California State Polytechnic University, Pomona / 302
MEP / California State Polytechnic University, San Luis Obispo / 303
MEP / California State University, Bakersfield / 304
MEP / California State University, Chico / 305
MEP / California State University, Fresno / 306
MEP / California State University, Fullerton / 307
MEP / California State University, Long Beach / 308
MEP / California State University, Los Angeles / 309
MEP / California State University, Northridge / 310
MEP / California State University, Sacramento / 311
MEP / California State University, San Diego / 312
MEP / California State University, San Francisco / 313
MEP / California State University, San Jose / 314
MEP / University of California, Berkeley / 315
MEP / University of California, Davis / 316
MEP / University of California, Irvine / 317
MEP / University of California, Los Angeles / 318
MEP / University of California, Riverside / 319
MEP / University of California, San Diego / 320
MEP / University of California, Santa Barbara / 321
MEP / University of Southern California / 323
MEP / University of California, Santa Cruz / 324
SSN CENTER PROVIDES or CAMPUS PROVIDES based on names provided by center or some sort of MEP flag procedure. Either way, it appears as an element on the student extract from the campus.
The student's social security number. This should be nine characters long, and contain no hyphens. An example for the way data should look is:
201228354
If the social security number is not known, or unavailable, do not leave this field blank. Instead, enter 999999999.
BIRTHDAY CAMPUS PROVIDES
The student's birthday. If not know, or unavailable, please leave blank. Must be 8 digits (yyyymmdd)
STUNAMEL CAMPUS PROVIDES based on SSNs from Center
It should appear as student's LAST name, 30 digits.
STUNAMEF CAMPUS PROVIDES based on SSNs from Center
It should appear as student's FIRST name, 30 digits. Please do not use nicknames.
STUNAMEM CAMPUS PROVIDES based on SSNs from Center
It should appear as student's MIDDLE name, 30 digits. Please do not use nicknames.
P_ADDR1 CAMPUS PROVIDES
Permanent mailing address of the student, line one, 30 digits.
P_ADDR2 CAMPUS PROVIDES
Permanent mailing address, line two. Only use this field if there is information that cannot be added to PADDR1.
P_CITY CAMPUS PROVIDES
Permanent mailing address, city, 30 digits.
P_STATE CAMPUS PROVIDES
Permanent mailing address, state. Please use the two-character abbreviation.
Example: CA
P_ZIP CAMPUS PROVIDES
Permanent mailing address, zip code, 5 digits-4digits, e.g. 94612-3550.
P_PHONE CAMPUS PROVIDES
Phone number for the student's permanent address, 10 digits (5109879138).
C_ADDR1 CAMPUS PROVIDES
Current mailing address, line one. Leave this field blank if it is the same as the permanent mailing address.
C_ADDR2 CAMPUS PROVIDES
Current mailing address, line two. Leave this field blank if it is the same as the permanent mailing address.
C_CITY CAMPUS PROVIDES
Current mailing address, city. Leave this field blank if it is the same as the permanent mailing address.
C_STATE CAMPUS PROVIDES
Current mailing address, state. Leave this field blank if it is the same as the permanent mailing address. Please use the two-character abbreviation for state. Example: CA
C_ZIP CAMPUS PROVIDES
Current mailing address, zip code. Leave this field blank if it is the same as the permanent mailing address.
C_PHONE CAMPUS PROVIDES
Phone number of the current address. Leave this field blank if it is the same as the permanent address.
EMAIL CENTER PROVIDES.
Email that the student can be reached at, if the student has an email address.
GENDER CAMPUS PROVIDES
One-digit code for student's gender.
1 - Female 2 - Male
ETHNIC CAMPUS PROVIDES
This is a two-digit MESA code for student's ethnicity. It is proposed that we use the CSU standard for ethnicity codes. Listed here is the CSU standard with its MESA counterpart.
Ethnicity / CSU CODE / MESA CODENative American / 1 / 1
African American / 2 / 2
Mexican American / 3 / 3
Central American / A / 41
South American / B / 42
Cuban / Q / 43
Puerto Rican / P / 44
Other Latino / 4 / 45
White / 7 / 51
Chinese / C / 52
Japanese / J / 53
Korean / K / 54
Asian India / R / 55
Laotian / L / 56
Cambodian / M / 57
Vietnamese / V / 58
Thai / T / 59
Filipino / F / 60
Guamanian / G / 61
Hawaiian / H / 62
Samoan / N / 63
Other Asian / 5 / 64
Other S-E Asian / S / 65
Other Pac Islander / 6 / 66
Other / 8 / 67
No Response / 9 / 99
Decline to state / D / 99
TRIBALAFF CENTER PROVIDES
For Native American Indian students only, otherwise, leave blank. Data should describe the tribe that the student is affiliated with, 30 digits.
LANGUAGE CENTER PROVIDES.
Second language that is spoken in the home. If this field is not blank, the student will be considered Bilingual. It is undetermined presently if the data in this field will be a two-digit code representing the language, or simply the name of the language.
EFATHER CAMPUS PROVIDES
One digit code represents the level of education of the father. The following corresponds to the CSU data collection format.
Code / Level1 / No High School
2 / Some High School
3 / High School graduate
4 / Some College or University
5 / Community College Degree / Associates Degree
6 / 4-Year College Degree
7 / Beyond 4-Year College Degree
8 / Don't Know / No Response
9 / M.S./ M.A. / M.B.A. / Ph. D degree
EMOTHER CAMPUS PROVIDES
Level of education of the student's mother. Same codes as above, EFATHER
HS_GPA CAMPUS PROVIDES
The student's high school grade point average in grades 10-12, three digits without decimal (325).
HS_CDS CENTER PROVIDES or CAMPUS PROVIDES (if stores data by CDS Code)
This field is the 14-digit CDS code of the high school that the student attended. ACDS code is a standard code that uniquely identifies a school, as well as giving information about the county and district of the school. If you don't know the CDS code for a given school, you can:
1. Look it up on the web. The ED-Data site has a lookup that has CDS codes, given the name and city of a school. (http://207.163.253.6/Profiles/) You may search by school name or by district and there is a lot of other information available on each school, such as test scores, class size, ethnicity of teachers.
2. Use the California public school directory, published by the California department of education.
Data in this field should not contain hyphens, and should be 14 characters long. An example of data in this field is: 01611190130229
This piece of information tells me that this student attended Alameda High, which is in Alameda county, and in Alameda City Unified school district. Having the school identified in this matter unlocks a wealth of other data about the school, which can be used in various studies.
HSGRADYR CAMPUS PROVIDES
This element, high school graduation year, should have four digits (e.g., 1998).
LCOLLEGE CENTER PROVIDES or CAMPUS PROVIDES (if stores data by standard CSU Institution of Origin code)
This is the last college, two- or four-year, that the student attended prior to enrolling at the MEP campus.
SAT_I CAMPUS PROVIDES
This should be a single string of 10 places indicating verbal, math and composite SAT I scores, i.e., vvvmmmcccc.
ACT CAMPUS PROVIDES
This should be a single string of 12 places, 2 for each of the 5 subset scores and the cumulative ACT scores.
MESAEXPS CENTER PROVIDES
These data indicate previous MESA STC experience, and should be coded as follows:
1 Yes
2 No
MESAEXPM CENTER PROVIDES
These data indicate previous MESA MSP experience, and should be coded as follows:
1 Yes
2 No
MESAEXPC CENTER PROVIDES
These data indicate previous MESA CCCP experience, and should be coded as follows:
1 Yes
2 No
MESAEXPY CENTER PROVIDES
This is the total number of years of MESA STC/MSP/CCCP experience, two digits.
TRANSGPA CAMPUS PROVIDES
This should be based on grades in all courses the institution has accepted as transferable three digits without decimal.
TRSUNITS CAMPUS PROVIDES
This should be based on all units the institution has accepted as transferable, four digits without decimal (but assumed to come after third digit, e.g. 0275=27.5 units).
MAJOR CAMPUS PROVIDES
This is the student's major as formally recognized by the campus. Changes in major are not official until they appear on the student's campus record so we prefer the campus provide these data. Please use the six-digit CIP code required for majors and degrees for IPEDS reporting.
LEVEL CAMPUS PROVIDES
This indicates the student's class level by units, one digit (1=Fr., 2=So., 3=Jr., 4=Sr., 5=post BA/S). While this information will be problematic for transfers, it is still important to know how the campus views the student.
EXP_GRAD CENTER PROVIDES
This information on expected year of graduation refers to the student's PRF response. It is a two-digit number representing the last two numbers in the year, e.g., 2000 would be 04.
PROGRESS CENTER PROVIDES
This information on progress toward graduation refers to Item 8 on the PRF.
1 not begun calculus
2 taking 1st year calculus
3 taking 2nd year calculus
4 taking junior level courses
5 taking senior level courses
1ST_MATH CAMPUS PROVIDES
Based on actual enrollment, where did student begin in this institution's math curriculum?
ENROLSTAT CENTER PROVIDES or CAMPUS PROVIDES if CSU
Is the student:
1 A continuing student
2 A returning student (originally enrolled as a first time student here, but returning after at least one term not enrolled)