| Topic | Category | Variable | Description |
|---|---|---|---|
| Topic: K12 Student | Category: All | Variable: ISD_CODE | Description: The district name, as recorded in the Educational Entity Master (EEM). |
| Topic: K12 Student | Category: All | Variable: LAST_COLLECTION_ID | Description: The collection in which the student was last reported by any district |
| Topic: K12 Student | Category: All | Variable: LAST_COLLECTION_NAME | Description: The collection in which the student was last reported by any district. |
| Topic: K12 Student | Category: All | Variable: OPERATIONAL_DISTRICT_CODE | Description: state-assigned 5-digit number which identifies student's public school district |
| Topic: K12 Student | Category: All | Variable: OPERATIONAL_DISTRICT_NAME | Description: Public school district recorded by EEM for the reported student |
| Topic: K12 Student | Category: All | Variable: OPERATIONAL_ISD_CODE | Description: Number recorded by EEM to identify school district in which program is located |
| Topic: K12 Student | Category: All | Variable: OPERATIONAL_ISD_NAME | Description: District (ISD, ESA) name recorded by EEM in which program is located |
| Topic: K12 Student | Category: All | Variable: REPORTING_PERIOD | Description: Reporting period (fall, spring, school year) the data represents |
| Topic: K12 Student | Category: All | Variable: RIC | Description: The unique student identifier--Research Identification Code. |
| Topic: K12 Student | Category: All | Variable: SCHOOL_CODE | Description: 5-digit building code assigned to the building in EEM |
| Topic: K12 Student | Category: All | Variable: SCHOOL_NAME | Description: The five-digit code assigned to the building in the Educational Entity Master |
| Topic: K12 Student | Category: All | Variable: SCHOOL_YEAR | Description: Description of the school year that the data represents. |
| Topic: K12 Student | Category: All | Variable: START_YEAR | Description: The calendar year in which the school year began. |
| Topic: K12 Student | Category: All | Variable: SUBMITTING_DISTRICT_CODE | Description: EEM code of certifying entity; applies to EC collection only. |
| Topic: K12 Student | Category: All | Variable: SUBMITTING_SCHOOL_CODE | Description: EEM code of certifying building; optional for community programs; EC only. |
| Topic: K12 Student | Category: Census Block | Variable: CENSUS_BLOCK_2010 | Description: Combined state, county, 2010 census tract and block codes. |
| Topic: K12 Student | Category: Census Block | Variable: CENSUS_BLOCK_2020 | Description: Combined state, county, 2020 census tract and block codes. |
| Topic: K12 Student | Category: Census Block | Variable: COLLECTION | Description: General collection (Fall, Spring, Year) or SRM identifier. |
| Topic: K12 Student | Category: Course Taking | Variable: ACADEMIC_SCHOOL_YEAR | Description: The school year in which the data was reported by the district. |
| Topic: K12 Student | Category: Course Taking | Variable: COLLEGE_CREDIT | Description: Number of college credit hours earned in dual/concurrent enrollment |
| Topic: K12 Student | Category: Course Taking | Variable: COMPLETION_STATUS_CODE | Description: Code representing student's final status for the course being reported |
| Topic: K12 Student | Category: Course Taking | Variable: COURSE_FUNDING_CODE | Description: The code for any programs that provide funding to the student course. |
| Topic: K12 Student | Category: Course Taking | Variable: COURSE_TYPE_CODE | Description: Code for the course type representing rigor of instruction provided |
| Topic: K12 Student | Category: Course Taking | Variable: IS_VIRTUAL_DELIVERY | Description: Flag indicates whether student is receiving instruction virtually. |
| Topic: K12 Student | Category: Course Taking | Variable: LOCAL_COURSE_GRADE | Description: Grade assigned by education entities for student achievement in a course |
| Topic: K12 Student | Category: Course Taking | Variable: LOCAL_COURSE_ID | Description: The code assigned by the educating entity to identify a particular course. |
| Topic: K12 Student | Category: Course Taking | Variable: LOCAL_COURSE_SECTION_ID | Description: Used by education entities when the local course ID cannot identify a course |
| Topic: K12 Student | Category: Course Taking | Variable: LOCAL_COURSE_TITLE | Description: The title assigned by the educating entity to identify a particular course. |
| Topic: K12 Student | Category: Course Taking | Variable: LOCAL_CREDITS_GRANTED | Description: Carnegie unit of credits measured in seat time granted to a student |
| Topic: K12 Student | Category: Course Taking | Variable: RPIC_1 | Description: Research Personnel Identification Code assigned for each teacher for the course |
| Topic: K12 Student | Category: Course Taking | Variable: RPIC_2 | Description: Research Personal Identification code assigned for each teacher. 2nd possible |
| Topic: K12 Student | Category: Course Taking | Variable: RPIC_3 | Description: Research Personal Identification Code assigned to each teacher. 3rd possible |
| Topic: K12 Student | Category: Course Taking | Variable: SUBJECT_COURSE_CODE | Description: SCED code is comprised of 2-digit subject area and 3-digit course identifier |
| Topic: K12 Student | Category: Course Taking | Variable: VIRTUAL_METHOD_NAME | Description: The type of virtual instruction the student is receiving |
| Topic: K12 Student | Category: Demographics | Variable: COHORT_STATUS_CODE | Description: Code assigned to a student based on grade and exit status |
| Topic: K12 Student | Category: Demographics | Variable: COHORT_STATUS_NAME | Description: Name assigned to a student based on grade and exit status |
| Topic: K12 Student | Category: Demographics | Variable: COHORT_YEAR | Description: The cohort year the student is grouped into for tracking graduation outcomes |
| Topic: K12 Student | Category: Demographics | Variable: ECONOMICALLY_DISADVANTAGED | Description: Indicates if the student is economically disadvantaged. |
| Topic: K12 Student | Category: Demographics | Variable: ETHNICITY_CODE_RAW | Description: A 6-digit field indicating race/ethnicity |
| Topic: K12 Student | Category: Demographics | Variable: ETHNICITY_RACE | Description: The ethnicity or race of the student. |
| Topic: K12 Student | Category: Demographics | Variable: GENDER | Description: The gender of the student. |
| Topic: K12 Student | Category: Demographics | Variable: GENDER_RAW | Description: Indicates if the student is male or female |
| Topic: K12 Student | Category: Demographics | Variable: Grade | Description: The grade of the student. |
| Topic: K12 Student | Category: Demographics | Variable: GRADE_RAW | Description: The grade level or the educational setting in which the student is enrolled. |
| Topic: K12 Student | Category: Demographics | Variable: GRADE_SY | Description: Student's primary grade selected for reporting by CEPI |
| Topic: K12 Student | Category: Demographics | Variable: GRADUATION_COHORT_YEAR | Description: The cohort year the student is grouped into for tracking graduation outcomes |
| Topic: K12 Student | Category: Demographics | Variable: HOMELESS_CODE | Description: Primary nighttime residence of a student identified as homeless |
| Topic: K12 Student | Category: Demographics | Variable: IS_COHORT_YEAR_CONFLICT | Description: indicates whether students graduation cohort year has changed |
| Topic: K12 Student | Category: Demographics | Variable: IS_ECONOMICALLY_DISADVANTAGED | Description: Student eligible for free/reduced meal, SNAP/TANF, homeless, migrant or foster |
| Topic: K12 Student | Category: Demographics | Variable: IS_GRADUATED_SY | Description: Indicates student graduated in this school year (SCHOOL_YEAR) |
| Topic: K12 Student | Category: Demographics | Variable: IS_MILITARY_CONNECTED | Description: Indicates parent is a member of Armed Force on active duty |
| Topic: K12 Student | Category: Demographics | Variable: IS_STABLE_DATE_BIRTH_CONFLICT | Description: indicates if conflicting DOB values have ever been repoted for the student |
| Topic: K12 Student | Category: Demographics | Variable: IS_STABLE_GENDER_CONFLICT | Description: indicates if conflicting gender values have been reported for the student |
| Topic: K12 Student | Category: Demographics | Variable: IS_STABLE_RACE_ETHNIC_CONFLICT | Description: Indicates conflicting racial/ethnic category values reported for student |
| Topic: K12 Student | Category: Demographics | Variable: IS_UNACCOMPANIED_YOUTH | Description: an individual who is not in the physical custody of a parent or guardian |
| Topic: K12 Student | Category: Demographics | Variable: LEP | Description: Indicates if the student has limited English proficiency. |
| Topic: K12 Student | Category: Demographics | Variable: MONTH_YEAR_BIRTH_RAW | Description: Date that student was born as on legal documents |
| Topic: K12 Student | Category: Demographics | Variable: MONTH_YEAR_BIRTH_STABLE | Description: The latest MSDS-recorded date of birth for the student for all time |
| Topic: K12 Student | Category: Demographics | Variable: PRIMARY_DISABILITY_CODE_RAW | Description: Primary disability code identified on student's IEP defined by MARSE |
| Topic: K12 Student | Category: Demographics | Variable: PRIMARY_DISABILITY_CODE_SY | Description: Student's primary disability selected for federal reporting by CEPI |
| Topic: K12 Student | Category: Demographics | Variable: PRIMARY_ED_SETTING_CODE_RAW | Description: Name of facility where student participates in special education programs |
| Topic: K12 Student | Category: Demographics | Variable: PRIMARY_ED_SETTING_SY | Description: Student's primary special education setting selected for reporting by CEPI |
| Topic: K12 Student | Category: Demographics | Variable: PRIMARY_LEP_LANGUAGE_SY | Description: Student's native language selected for federal reporting by CEPI |
| Topic: K12 Student | Category: Demographics | Variable: RACIAL_ETHNIC_CODE_RAW | Description: The ethnicity or race of the student. |
| Topic: K12 Student | Category: Demographics | Variable: READING_DEFICIENCY_CONTINUATION | Description: Indicates whether student had reading deficiency at the end of the year |
| Topic: K12 Student | Category: Demographics | Variable: READING_DEFICIENCY_IDENTIFIED | Description: Indicates whether student had a reading deficiency at the start of the year |
| Topic: K12 Student | Category: Demographics | Variable: RESIDENCY_CODE | Description: Code for the student's residency related to the district's geographic boundary |
| Topic: K12 Student | Category: Demographics | Variable: RESIDENCY_NAME | Description: The student's residency related to the geographic boundaries of the district |
| Topic: K12 Student | Category: Demographics | Variable: RESIDENCY_STATUS_CODE | Description: Indicates students residency related to district boundaries |
| Topic: K12 Student | Category: Demographics | Variable: RESIDENT_DISTRICT_CODE | Description: 5-digit code for geographic district in which student's guardian resides |
| Topic: K12 Student | Category: Demographics | Variable: STABLE_GENDER | Description: The latest MSDS-recorded gender for the student for all time |
| Topic: K12 Student | Category: Demographics | Variable: STABLE_GRAD_YEAR | Description: The latest recorded graduation year for the student for all time |
| Topic: K12 Student | Category: Demographics | Variable: STABLE_RACE_ETHNIC | Description: The latest MSDS-recorded racial/ethnic category for the student for all time |
| Topic: K12 Student | Category: Demographics | Variable: ZIP_CODE | Description: 5 or 9-digit ZIP code where the student lives |
| Topic: K12 Student | Category: Discipline Records | Variable: DISCIPLINARY_ACTION_CODE_1 | Description: Reported code for disciplinary action taken for the incident |
| Topic: K12 Student | Category: Discipline Records | Variable: DISCIPLINARY_ACTION_CODE_2 | Description: Second reported code for disciplinary action taken for the incident |
| Topic: K12 Student | Category: Discipline Records | Variable: DISCIPLINARY_ACTION_CODE_3 | Description: Third reported code for teh disciplinary action taken for the incident |
| Topic: K12 Student | Category: Discipline Records | Variable: DISCIPLINARY_ACTION_NAME_1 | Description: First reported name of the disciplinary action taken for the incident |
| Topic: K12 Student | Category: Discipline Records | Variable: DISCIPLINARY_ACTION_NAME_2 | Description: Second reported name for disciplinary action taken for the incident |
| Topic: K12 Student | Category: Discipline Records | Variable: DISCIPLINARY_ACTION_NAME_3 | Description: Third reported name of the discplinary action taken for the incident |
| Topic: K12 Student | Category: Discipline Records | Variable: FOLLOW_UP_CODE_1 | Description: Code for type of follow-up services provided after first disciplinary action |
| Topic: K12 Student | Category: Discipline Records | Variable: FOLLOW_UP_CODE_2 | Description: Code for follow-up services provided to student after second discplinary action |
| Topic: K12 Student | Category: Discipline Records | Variable: FOLLOW_UP_CODE_3 | Description: Code for follow-up services provided to student after third discplinary action |
| Topic: K12 Student | Category: Discipline Records | Variable: FOLLOW_UP_CODE_4 | Description: Code for follow-up services provided to student after 4th disciplinary action |
| Topic: K12 Student | Category: Discipline Records | Variable: FOLLOW_UP_NAME_1 | Description: Name of follow-up service provided to student post first discplinary action |
| Topic: K12 Student | Category: Discipline Records | Variable: FOLLOW_UP_NAME_2 | Description: Name for follow-up services provided to student after second discplinary action |
| Topic: K12 Student | Category: Discipline Records | Variable: FOLLOW_UP_NAME_3 | Description: Name for follow-up services provided to student after third discplinary action |
| Topic: K12 Student | Category: Discipline Records | Variable: FOLLOW_UP_NAME_4 | Description: Name for follow-up services provided to student after 4th discplinary action |
| Topic: K12 Student | Category: Discipline Records | Variable: INCIDENT_DATE | Description: The day the incident that led to the disciplinary action occurred. |
| Topic: K12 Student | Category: Discipline Records | Variable: INCIDENT_TYPE_CODE_1 | Description: The code of the first incident with the reason that led to disciplinary action |
| Topic: K12 Student | Category: Discipline Records | Variable: INCIDENT_TYPE_CODE_2 | Description: Code of the second incident with the reason that led to disciplinary action |
| Topic: K12 Student | Category: Discipline Records | Variable: INCIDENT_TYPE_CODE_3 | Description: Code of the third incident with the reason that led to disciplinary action |
| Topic: K12 Student | Category: Discipline Records | Variable: INCIDENT_TYPE_CODE_4 | Description: Code of the fourth incident with the reason that led to disciplinary action |
| Topic: K12 Student | Category: Discipline Records | Variable: INCIDENT_TYPE_NAME_1 | Description: The name of the first incident with the reason that led to disciplinary action |
| Topic: K12 Student | Category: Discipline Records | Variable: INCIDENT_TYPE_NAME_2 | Description: Name of the second incident with the reason that led to discplinary action |
| Topic: K12 Student | Category: Discipline Records | Variable: INCIDENT_TYPE_NAME_3 | Description: Name of the third incident with reason that led to disciplinary action |
| Topic: K12 Student | Category: Discipline Records | Variable: INCIDENT_TYPE_NAME_4 | Description: Name of the fourth incident with the reason that led to disciplinary action |
| Topic: K12 Student | Category: Discipline Records | Variable: IS_SERIOUS_BODILY_INJURY | Description: Flag indicating when incident type involves physical violence with injury |
| Topic: K12 Student | Category: Discipline Records | Variable: IS_SEXUAL_ASSAULT | Description: Flag indicates incident of physical violence involving nonconsentual pentration |
| Topic: K12 Student | Category: Discipline Records | Variable: LENGTH_OF_ACTION_1 | Description: Numbers of days assigned for first reported consequence in half-day increments |
Codebook
The MEDC codebook contains a comprehensive listing of variables available to researchers with approved projects. During the research application process, you will select groups of variables as identified in the Category column. It is also available as a CSV Download.