| Topic | Category | Variable | Description |
|---|---|---|---|
| Topic: Infrastructure | Category: K12 Building | Variable: SCHOOL_BASED_HEALTH_CENTER | Description: Flag denoting that this entity has a school-based health center |
| Topic: Infrastructure | Category: K12 Building | Variable: SCHOOL_CODE | Description: The five-digit code assigned to the building in the Educational Entity Master |
| Topic: Infrastructure | Category: K12 Building | Variable: SCHOOL_NAME | Description: The official name assigned to entity in the EEM |
| Topic: Infrastructure | Category: K12 Building | Variable: SCHOOL_PHYS_ADD_LINE_ONE | Description: The first line of the physical address for the entity. |
| Topic: Infrastructure | Category: K12 Building | Variable: SCHOOL_PHYS_ADD_LINE_TWO | Description: The second line of the physical address for the entity. |
| Topic: Infrastructure | Category: K12 Building | Variable: SCHOOL_PHYS_CITY | Description: The city of the physical address for the entity. |
| Topic: Infrastructure | Category: K12 Building | Variable: SCHOOL_PHYS_STATE | Description: The state of the physical address for the entity. |
| Topic: Infrastructure | Category: K12 Building | Variable: SCHOOL_PHYS_ZIP_LINE_ONE | Description: The zip code of the physical address for the entity. |
| Topic: Infrastructure | Category: K12 Building | Variable: SCHOOL_PHYS_ZIP_LINE_TWO | Description: The +4 zip code of the physical address for the entity. |
| Topic: Infrastructure | Category: K12 Building | Variable: SCHOOLS_OF_CHOICE_OFFERED | Description: Flag denoting that this entity participates in schools of choice |
| Topic: Infrastructure | Category: K12 Building | Variable: SPECIAL_EDUCATION | Description: Flag to specify if the entity provides special education programs |
| Topic: Infrastructure | Category: K12 Building | Variable: SPECIAL_EDUCATION_CENTER_PGM | Description: Specifies if the entity provides special education center programs. |
| Topic: Infrastructure | Category: K12 Building | Variable: SUPPLEMENTAL_VIRTUAL_SCHOOL | Description: A face-to-face school with supplemental virtual options. |
| Topic: Infrastructure | Category: K12 Building | Variable: TUITION_BEFORE_AFTER_SCH_PGM | Description: Entity offers programs for K-12 when school is not in session and charges fees. |
| Topic: Infrastructure | Category: K12 Building | Variable: TWENTY_FIRST_CENTURY_COMM_CNT | Description: Flag denoting this entity is used as a 21st century community learning center |
| Topic: Infrastructure | Category: K12 District Finance | Variable: AMOUNT | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: BUILDING_CODE | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: BUILDING_NAME | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: EXPENDITURE_FUNCTION_CAT | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: EXPENDITURE_FUNCTION_CODE | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: EXPND_CAT | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: EXPND_HEADER_CODE | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: EXPND_HEADER_DESC | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: EXPND_SUBHEADER_CODE | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: EXPND_SUBHEADER_DESC | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: FISCAL_YEAR | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: FUNCTION_CODE | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: FUNCTION_DESC | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: FUND_CODE | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: FUND_DESC | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: HEADER_OBJECT_CODE | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: HEADER_OBJECT_DESC | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: INDICATOR_CODE | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: MAJOR_CLASS_CODE | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: MAJOR_CLASS_CODE_DESC | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: OBJECT_CODE | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: OBJECT_CODE_TYPE | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: OBJECT_DESC | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: OPERATIONAL_DISTRICT_TYPE | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: STATE_GRANT_CODE | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: STATE_GRANT_DESC | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: SUBHEADER_OBECT_DESC | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: SUBHEADER_OBJECT_CODE | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: SUFFIX_CODE | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: SUFFIX_DESC | Description: NULL |
| Topic: Infrastructure | Category: K12 District Finance | Variable: TRANSACTION_TYPE | Description: NULL |
| Topic: Infrastructure | Category: Postsecondary Building | Variable: HIGHER_ED_CODE | Description: The unique identifier of the IHE entity in the Educational Entity Master (EEM). |
| Topic: Infrastructure | Category: Postsecondary Building | Variable: IHE_CONTROL | Description: Designates whether an IHE is publicly or privately controlled. |
| Topic: Infrastructure | Category: Postsecondary Building | Variable: IHE_LEVEL | Description: Designates whether an IHE is a 2-year or 4-year institution. |
| Topic: Infrastructure | Category: Postsecondary Building | Variable: IHE_NAME | Description: The official or legal name of the institution. |
| Topic: Infrastructure | Category: Postsecondary Building | Variable: IHE_PHYS_ADD_LINE_ONE | Description: The first line of the physical address for the entity. |
| Topic: Infrastructure | Category: Postsecondary Building | Variable: IHE_PHYS_ADD_LINE_TWO | Description: The second line of the physical address for the entity. |
| Topic: Infrastructure | Category: Postsecondary Building | Variable: IHE_PHYS_CITY | Description: The city of the physical address for the entity. |
| Topic: Infrastructure | Category: Postsecondary Building | Variable: IHE_PHYS_STATE | Description: The state of the physical address for the entity. |
| Topic: Infrastructure | Category: Postsecondary Building | Variable: IHE_PHYS_ZIP_LINE_ONE | Description: The zip code of the physical address for the entity. |
| Topic: Infrastructure | Category: Postsecondary Building | Variable: IPEDS_CODE | Description: IPEDS (Integrated Postsecondary Education Data Systems) IHE identification code |
| Topic: Infrastructure | Category: Postsecondary Building | Variable: IS_OPEN | Description: A Y or N flag stating the Open Status of most Michigan Institutions. |
| Topic: Infrastructure | Category: Postsecondary Building | Variable: SNAPSHOT_DAY | Description: The date in which the snapshot was created |
| Topic: K12 Student | Category: All | Variable: BUILDING_CODE | Description: NULL |
| Topic: K12 Student | Category: All | Variable: COLLECTION_SCHOOL_YEAR | Description: The academic school year in which the course was completed by the student. |
| Topic: K12 Student | Category: All | Variable: COLLECTION_SOURCE | Description: NULL |
| Topic: K12 Student | Category: All | Variable: DISTRICT_CODE | Description: NULL |
| Topic: K12 Student | Category: All | Variable: FIRST_COLLECTION_ID | Description: The first Collection the student was assigned to a graduation cohort |
| Topic: K12 Student | Category: All | Variable: FIRST_COLLECTION_NAME | Description: First MSDS Collection in which the student was assigned to a graduation cohort. |
| Topic: K12 Student | Category: All | Variable: ISD_CODE | Description: NULL |
| 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: The official state assigned five digit code denoting the district |
| Topic: K12 Student | Category: All | Variable: OPERATIONAL_DISTRICT_NAME | Description: The district of the entity held accountable for the student's graduation status |
| 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: The school held accountable for the student's graduation status |
| Topic: K12 Student | Category: All | Variable: SCHOOL_NAME | Description: Entity type of the school held accountable for the student's graduation status |
| 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: NULL |
| Topic: K12 Student | Category: All | Variable: SUBMITTING_SCHOOL_CODE | Description: NULL |
| Topic: K12 Student | Category: Census Block | Variable: CENSUS_BLOCK_2010 | Description: NULL |
| Topic: K12 Student | Category: Census Block | Variable: CENSUS_BLOCK_2020 | Description: NULL |
| Topic: K12 Student | Category: Census Block | Variable: COLLECTION | Description: NULL |
| 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_CLASSIFICATION | Description: The NCES designation as either primary/secondary level course |
| 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 |
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.