| Topic | Category | Variable | Description |
|---|---|---|---|
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IHE_LEVEL | Description: Designates whether an IHE is a 2-year or 4-year institution. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IHE_MILITARY_STATUS | Description: The student’s military status at the time of enrollment. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IHE_PELL_STATUS | Description: Indicates if student was eligible for or received a Pell Grant for the session. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IHE_RESIDENCY_STATUS | Description: A student’s residency status for tuition purposes. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IHE_TOTAL_CREDITS | Description: Total (cumulative) credits earned at an IHE according to STARR data only. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IHE_UNDER_OVER_AGE_25 | Description: The student's age status as of September 30th of the enrollment year. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IS_CC_SEEKING_TRNSFR_TO_4YR | Description: Indicates if student at a CC intends to transfer to a 4-year institution. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IS_FOR_PROFIT_IHE | Description: Y/N field that designates whether an IHE operates on a for-profit basis. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IS_FULL_TIME_24 | Description: Indicates if student is full-time, based on 24 attempted credits per year |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IS_FULL_TIME_30 | Description: Indicates if student is full-time, based on 30 attempted credits per year |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IS_LEAVE_OF_ABSENCE | Description: Indicates if all courses in session had enrollment status of ‘Leave of Absence’ |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IS_REMEDIAL_ESL_SESSION | Description: Y/N indicator if course is a remedial English as a Second Language (ESL) course |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IS_REMEDIAL_MATH_SESSION | Description: Y/N indicator if remedial math courses were taken during the session. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IS_REMEDIAL_READING_SESSION | Description: Y/N indicator if remedial reading courses were taken during the session. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IS_REMEDIAL_SCIENCE_SESSION | Description: Y/N indicator if remedial science courses were taken during the session. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IS_REMEDIAL_SESSION | Description: Y/N indicator if any remedial courses were taken during the session. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IS_REMEDIAL_WRITING_SESSION | Description: Y/N indicator if remedial writing courses were taken during the session. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IS_STARR_SESSION | Description: Designates if the session record came from the STARR collection. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: IS_TRANSFER_NOGRADE | Description: Indicates if all courses in the session had a grade status of ‘TransferNoGrade’ |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: MOD_CREDITS_ATTEMPTED_SESSION | Description: Total STARR credits attempted or NSC FTE days converted to session credits. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: MOD_CREDITS_EARNED_2YR_CUM | Description: Cumulative STARR credits and NSC FTE days earned at all 2-year institutions. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: MOD_CREDITS_EARNED_4YR_CUM | Description: Cumulative STARR credits and NSC FTE days earned at all 4-year institutions. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: MOD_CREDITS_EARNED_CUM | Description: Cumulative total of STARR credits and NSC FTE days converted to credits earned. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: MOD_CREDITS_EARNED_INSTATE_CUM | Description: Cumulative STARR credits and NSC FTE days earned at all Michigan institutions. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: MOD_CREDITS_EARNED_OUTSTATE_CUM | Description: Cumulative STARR credits and NSC FTE days earned at out-of-state institutions. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: MOD_CREDITS_EARNED_PRIVATE_CUM | Description: Cumulative STARR credits and NSC FTE days earned at all private institutions. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: MOD_CREDITS_EARNED_PUBLIC_CUM | Description: Cumulative STARR credits and NSC FTE days earned at all public institutions. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: MOD_CREDITS_EARNED_SESSION | Description: Total STARR credits earned or NSC FTE days converted to session credits. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: SESSION_TYPE | Description: Type of academic session (e.g., Semester, Quarter), per IHE or CEPI records. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: STUDENT_HOME_STATE | Description: The name of the student's legal home permanent state or province. |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: STUDENT_LEVEL_CODE | Description: Education level the student is pursuing during the academic session. |
| Topic: Postsecondary | Category: Program Participation | Variable: IS_STARR_PROGRAM | Description: Designates if the session record came from the STARR collection. |
| Topic: Postsecondary | Category: Program Participation | Variable: PROGRAM_CIP_CATEGORY | Description: High-level (2-digit CIP) field of study description per NCES for student prog |
| Topic: Postsecondary | Category: Program Participation | Variable: PROGRAM_CIP_CODE | Description: CIP code for the student’s academic program, as submitted by the IHE. |
| Topic: Postsecondary | Category: Program Participation | Variable: PROGRAM_CIP_DESCRIPTION | Description: Description of field of study per CIP by NCES for the student’s program. |
| Topic: Postsecondary | Category: Program Participation | Variable: PROGRAM_NAME | Description: Institution’s internal name for the program, major, minor, or field of study |
| Topic: Staff | Category: All | Variable: ASSIGNED_DISTRICT_CODE | Description: The official state assigned five digit code denoting the district of the entity |
| Topic: Staff | Category: All | Variable: ASSIGNED_DISTRICT_NAME | Description: Official district name denoting district the educator is assigned to |
| Topic: Staff | Category: All | Variable: ASSIGNED_ISD_NAME | Description: Name recorded in EEM that identifies in which district ISD or ESA is located |
| Topic: Staff | Category: All | Variable: COLLECTION | Description: Name of Collection during which the data in a given record were reported. |
| Topic: Staff | Category: All | Variable: DISTRICT_CODE | Description: Operational District Code (i.e., the Employing District) |
| Topic: Staff | Category: All | Variable: DISTRICT_NAME | Description: Operational District Name |
| Topic: Staff | Category: All | Variable: EMPLOYED_DISTRICT_CODE | Description: The official state assigned five digit code denoting the district of the entity |
| Topic: Staff | Category: All | Variable: EMPLOYED_DISTRICT_NAME | Description: District name denoting district educator is employed by |
| Topic: Staff | Category: All | Variable: EMPLOYED_ISD_CODE | Description: Assigned 5-digit number recorded in EEM that identifies school district |
| Topic: Staff | Category: All | Variable: EMPLOYED_ISD_NAME | Description: Name recorded in EEM that identifies ISD or ESA in which district is located |
| Topic: Staff | Category: All | Variable: ENTITY_TYPE | Description: Indicates if staff assignment is to private, public, etc entity |
| Topic: Staff | Category: All | Variable: ISD_CODE | Description: Operational Intermediate School District Code |
| Topic: Staff | Category: All | Variable: ISD_NAME | Description: Operational Intermediate School District Name |
| Topic: Staff | Category: All | Variable: MOECS_EDUCATOR_ID | Description: A unique ID assigned to educators when they enter their information in MOECS |
| Topic: Staff | Category: All | Variable: RPIC | Description: Research Personnel Identification Code is unique ID to identify staff |
| Topic: Staff | Category: All | Variable: SCHOOL_CLOSE_DATE | Description: The actual closing date of the entity or when it ended business. |
| Topic: Staff | Category: All | Variable: SCHOOL_CODE | Description: Code assigned to building in EEM, aka Building Code |
| Topic: Staff | Category: All | Variable: SCHOOL_NAME | Description: The name as assigned to the building in the official Educational Entity Master |
| Topic: Staff | Category: All | Variable: SCHOOL_OPEN_DATE | Description: The actual opening date of the school or when it begins to do business. |
| Topic: Staff | Category: All | Variable: SCHOOL_YEAR | Description: Description of School Year which the data represents. |
| Topic: Staff | Category: All | Variable: START_YEAR | Description: The calendar year in which the school year began. |
| Topic: Staff | Category: Assignments | Variable: ASSIGNED_GRADE_01 | Description: Flag designating that the staff member was assigned to teach first grade. |
| Topic: Staff | Category: Assignments | Variable: ASSIGNED_GRADE_02 | Description: Flag designating that the staff member was assigned to teach second grade. |
| Topic: Staff | Category: Assignments | Variable: ASSIGNED_GRADE_03 | Description: Flag designating that the staff member was assigned to teach third grade. |
| Topic: Staff | Category: Assignments | Variable: ASSIGNED_GRADE_04 | Description: Flag designating that the staff member was assigned to teach fourth grade. |
| Topic: Staff | Category: Assignments | Variable: ASSIGNED_GRADE_05 | Description: Flag designating that the staff member was assigned to teach fifth grade. |
| Topic: Staff | Category: Assignments | Variable: ASSIGNED_GRADE_06 | Description: Flag designating that the staff member was assigned to teach sixth grade. |
| Topic: Staff | Category: Assignments | Variable: ASSIGNED_GRADE_07 | Description: Flag designating that the staff member was assigned to teach seventh grade. |
| Topic: Staff | Category: Assignments | Variable: ASSIGNED_GRADE_08 | Description: Flag designating that the staff member was assigned to teach eighth grade. |
| Topic: Staff | Category: Assignments | Variable: ASSIGNED_GRADE_09 | Description: Flag designating that the staff member was assigned to teach ninth grade. |
| Topic: Staff | Category: Assignments | Variable: ASSIGNED_GRADE_10 | Description: Flag designating that the staff member was assigned to teach tenth grade. |
| Topic: Staff | Category: Assignments | Variable: ASSIGNED_GRADE_11 | Description: Flag designating that the staff member was assigned to teach eleventh grade. |
| Topic: Staff | Category: Assignments | Variable: ASSIGNED_GRADE_12 | Description: Flag designating that the staff member was assigned to teach twelfth grade. |
| Topic: Staff | Category: Assignments | Variable: ASSIGNED_GRADE_K | Description: Flag designating that the staff member was assigned to teach Kindergarten. |
| Topic: Staff | Category: Assignments | Variable: ASSIGNED_GRADE_RK | Description: Flag designating staff member assigned to teach retentive kindergarten |
| Topic: Staff | Category: Assignments | Variable: ASSIGNED_ISD_CODE | Description: Assigned number reocrded in EEM for which district ISD or ESA is located |
| Topic: Staff | Category: Assignments | Variable: ASSIGNMENT_CODE | Description: The code that indicates the position held by the employee. |
| Topic: Staff | Category: Assignments | Variable: ASSIGNMENT_DESCRIPTION | Description: The description of the position held by the employee. |
| Topic: Staff | Category: Assignments | Variable: EDUCATIONAL_SETTING_DESC | Description: The description for the educational setting |
| Topic: Staff | Category: Assignments | Variable: EFFECTIVENESS_DESC | Description: Description used to categorize Educator Effectiveness ranking |
| Topic: Staff | Category: Assignments | Variable: FEDERAL_GRANT_PARTICIPATION | Description: Field identifies teachers funded by Title I or Title II who teach core subjects |
| Topic: Staff | Category: Assignments | Variable: FID_FUNCTION_CODE | Description: Accounting/function code for employee for accounting purposes by district |
| Topic: Staff | Category: Assignments | Variable: FID_FUNCTION_CODE_DESC | Description: Accounting description for employee for accounting purposes by district |
| Topic: Staff | Category: Assignments | Variable: FTE | Description: Proportion of time required for assignment divided by normal full time |
| Topic: Staff | Category: Assignments | Variable: IS_HIGHLY_QUALIFIED | Description: Reports whether staff meets the requirements for being highly qualified |
| Topic: Staff | Category: Assignments | Variable: IS_MDE_TEACHER | Description: Flag identifying teachers according to the MDE definition. |
| Topic: Staff | Category: Assignments | Variable: IS_PRINCIPAL | Description: Flag identifying principals according to the REP manual. |
| Topic: Staff | Category: Assignments | Variable: SUMMARY_GROUP_NAME | Description: The name for a grouping of assignment codes |
| Topic: Staff | Category: Demographics | Variable: BIRTH_YEAR | Description: Reported year of birth |
| Topic: Staff | Category: Demographics | Variable: GENDER | Description: Reported gender |
| Topic: Staff | Category: Demographics | Variable: RACE_ETHNICITY | Description: Reported ethnicity at the time the MTTC test were taken |
| Topic: Staff | Category: Employment | Variable: ANNUAL_SALARY | Description: Full-time base salary for employee to meet No Child Left Behind Act |
| Topic: Staff | Category: Employment | Variable: EMPLOYMENT_STATUS_DESC | Description: Desc. of employment status of staff member ex. separation reason or new teacher |
| Topic: Staff | Category: Employment | Variable: FUNDED_POS_STATUS_CODE | Description: Code for assignment status as permanent employee, substitute, or contractor |
| Topic: Staff | Category: Employment | Variable: FUNDED_POS_STATUS_DESC | Description: Description of assignment status as permanent employee, substitute, contractor |
| Topic: Staff | Category: Employment | Variable: HIGHEST_EDUCATION_DEGREE_NAME | Description: This is the highest degree earned by a staff member. |
| Topic: Staff | Category: Employment | Variable: HIRE_DATE | Description: The initial date of hire for the staff member within the district |
| Topic: Staff | Category: Employment | Variable: IS_FUNDED_POSITION | Description: Flag to specify if the personnel position is funded (Y or N). |
| Topic: Staff | Category: Employment | Variable: TERMINATION_DATE | Description: The date of termination/retirement/resignation of the staff member. |
| Topic: Staff | Category: Endorsements | Variable: AUTHORIZATION_STATUS | Description: Authorization status description (e.g., Valid, Expired, etc.). |
| Topic: Staff | Category: Endorsements | Variable: AUTHORIZATION_TYPE | Description: Name of Authorization type (There are four different types of authorizations) |
| Topic: Staff | Category: Endorsements | Variable: CERTIFICATE_EXPIRATION_DATE | Description: Date certificate will/has expired |
| Topic: Staff | Category: Endorsements | Variable: CERTIFICATE_ISSUE_DATE | Description: Date certificate was issued |
| Topic: Staff | Category: Endorsements | Variable: CERTIFICATE_REINSTATEMENT_DATE | Description: Date certificate reinstated |
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.