| Topic | Category | Variable | Description |
|---|---|---|---|
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: MOD_CREDITS_EARNED_SESSION | Description: NULL |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: SESSION_TYPE | Description: NULL |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: STUDENT_HOME_STATE | Description: NULL |
| Topic: Postsecondary | Category: Enrollment and Attendance | Variable: STUDENT_LEVEL_CODE | Description: NULL |
| Topic: Postsecondary | Category: Program Participation | Variable: IS_STARR_PROGRAM | Description: NULL |
| Topic: Postsecondary | Category: Program Participation | Variable: PROGRAM_CIP_CATEGORY | Description: NULL |
| Topic: Postsecondary | Category: Program Participation | Variable: PROGRAM_CIP_CODE | Description: NULL |
| Topic: Postsecondary | Category: Program Participation | Variable: PROGRAM_CIP_DESCRIPTION | Description: NULL |
| Topic: Postsecondary | Category: Program Participation | Variable: PROGRAM_NAME | Description: NULL |
| Topic: Postsecondary | Category: Program Participation | Variable: PROGRAM_TYPE | Description: NULL |
| 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: NULL |
| Topic: Staff | Category: Demographics | Variable: GENDER | Description: NULL |
| Topic: Staff | Category: Demographics | Variable: RACE_ETHNICITY | Description: NULL |
| 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 |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_AUTHORIZATION_1 | Description: The first endorsed authorization of the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_AUTHORIZATION_2 | Description: The second endorsed authorization of the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_AUTHORIZATION_3 | Description: The third endorsed authorization of the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_AUTHORIZATION_4 | Description: The fourth endorsed authorization of the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_AUTHORIZATION_5 | Description: The fifth endorsed authorization of the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CERTIFICATION_1 | Description: The first endorsement certificate for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CERTIFICATION_10 | Description: The tenth endorsement certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CERTIFICATION_11 | Description: The eleventh endorsement certificate for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CERTIFICATION_12 | Description: The twelfth endorsement certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CERTIFICATION_13 | Description: Thirteenth endorsement certificate for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CERTIFICATION_2 | Description: The second endorsement certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CERTIFICATION_3 | Description: The third endorsement certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CERTIFICATION_4 | Description: The fourth endorsement certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CERTIFICATION_5 | Description: The fifth endorsement certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CERTIFICATION_6 | Description: The sixth endorsement certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CERTIFICATION_7 | Description: The seventh endorsement certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CERTIFICATION_8 | Description: The eighth endorsement certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CERTIFICATION_9 | Description: The ninth endorsement certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CODE_1 | Description: The first endorsement code for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CODE_10 | Description: The tenth endorsement code for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CODE_11 | Description: The eleventh endorsement code for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CODE_12 | Description: The twelfth endorsement code for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CODE_13 | Description: The thirteenth endorsement code for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CODE_2 | Description: The second endorsement code for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CODE_3 | Description: The third endorsement code for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CODE_4 | Description: The fourth endorsement code for the staff member sorted alphabetically |
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.