| Topic | Category | Variable | Description |
|---|---|---|---|
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CODE_5 | Description: The fifth endorsement code for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CODE_6 | Description: The sixth endorsement code for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CODE_7 | Description: The seventh endorsement code for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CODE_8 | Description: The eighth endorsement code for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_CODE_9 | Description: The ninth endorsement code for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_GRADE_LEVEL_1 | Description: The first endorsement grade level for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_GRADE_LEVEL_10 | Description: The tenth endorsement grade level for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_GRADE_LEVEL_11 | Description: The eleventh endorsement grade level for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_GRADE_LEVEL_12 | Description: The twelfth endorsement grade level for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_GRADE_LEVEL_13 | Description: Thirteenth endorsement grade level for staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_GRADE_LEVEL_2 | Description: The second endorsement grade level for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_GRADE_LEVEL_3 | Description: The third endorsement grade level for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_GRADE_LEVEL_4 | Description: The fourth endorsement grade level for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_GRADE_LEVEL_5 | Description: The fifth endorsement grade level for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_GRADE_LEVEL_6 | Description: The sixth endorsement grade level for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_GRADE_LEVEL_7 | Description: The seventh endorsement grade level for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_GRADE_LEVEL_8 | Description: The eighth endorsement grade level for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_GRADE_LEVEL_9 | Description: The ninth endorsement grade level for the staff member sorted alphabetically |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_1 | Description: The first endorsed permit of the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_10 | Description: The tenth permit certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_11 | Description: The eleventh permit certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_12 | Description: The twelfth permit certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_13 | Description: The thirteenth permit certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_2 | Description: The second endorsed permit of the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_3 | Description: The third endorsed permit of the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_4 | Description: The fourth endorsed permit of the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_5 | Description: The fifth endorsed permit of the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_6 | Description: The sixth permit certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_7 | Description: The seventh permit certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_8 | Description: The eighth permit certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_9 | Description: The ninth permit certificate for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_CODE_1 | Description: The first permit code for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_CODE_10 | Description: The tenth permit code for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_CODE_11 | Description: The eleventh permit code for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_CODE_12 | Description: The twelfth permit code for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_CODE_13 | Description: The thirteenth permit code for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_CODE_2 | Description: The second permit grade level for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_CODE_3 | Description: The third permit code for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_CODE_4 | Description: The fourth permit code for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_CODE_5 | Description: The fifth permit code for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_CODE_6 | Description: The sixth permit code for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_CODE_7 | Description: The seventh permit code for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_CODE_8 | Description: The eighth permit code for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: ENDORSE_PERMIT_CODE_9 | Description: The ninth permit code for the staff member sorted alphabetically. |
| Topic: Staff | Category: Endorsements | Variable: INSTITUTION_NAME | Description: Official entity name for where Higher Education was received by staff. |
| Topic: Staff | Category: Endorsements | Variable: INSTITUTION_STATE | Description: State's name where Higher Education degree was received by staff. |
| Topic: Staff | Category: Endorsements | Variable: LICENSE_CATEGORY | Description: Name of the Certificate License Category . |
| Topic: Staff | Category: Endorsements | Variable: LICENSE_STATUS | Description: Certificate status description . |
| Topic: Staff | Category: Endorsements | Variable: LICENSE_TYPE | Description: Name of license type for educators application for certification in MOECS |
| Topic: Staff | Category: Endorsements | Variable: PERMIT_STATUS | Description: Permit status description (e.g., Valid, Expired, etc.). |
| Topic: Staff | Category: Endorsements | Variable: PERMIT_TYPE | Description: Name of Permit type (There are four different types of permits) |
| Topic: Staff | Category: Endorsements | Variable: PROGRAM_TYPE_CODE | Description: Populated when educator completes application for certification through MOECS |
| Topic: Staff | Category: Endorsements | Variable: PROGRAM_TYPE_NAME | Description: Whether staff is certified for elementary, secondary or occupational teaching |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: FIELD_NAME | Description: NULL |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: GRADE_LEVEL_CODE | Description: NULL |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: GRADE_LEVEL_DESC | Description: NULL |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: MAJOR_OR_MINOR_CODE | Description: NULL |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: MAJOR_OR_MINOR_DESC | Description: NULL |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: MTTC_INSTITUTION_ATTAENDED | Description: NULL |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: MTTC_INSTITUTION_NAME_1 | Description: NULL |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: MTTC_INSTITUTION_NAME_2 | Description: NULL |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: MTTC_INSTITUTION_NAME_3 | Description: NULL |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: PASS_FAIL | Description: NULL |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: SCALED_SCORE | Description: NULL |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: STATE | Description: NULL |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: TEST_CODE | Description: NULL |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: TESTING_DATE | Description: NULL |
| Topic: Staff | Category: Professional Development | Variable: ENTITY_CODE | Description: NULL |
| Topic: Staff | Category: Professional Development | Variable: ENTITY_NAME | Description: NULL |
| Topic: Staff | Category: Professional Development | Variable: HOURS_ENGAGED | Description: NULL |
| Topic: Staff | Category: Professional Development | Variable: PD_NAME | Description: NULL |
| Topic: Staff | Category: Professional Development | Variable: PD_NUMBER | Description: NULL |
| Topic: Staff | Category: Professional Development | Variable: PROF_DEV_CATEGORY | Description: NULL |
| Topic: Staff | Category: Professional Development | Variable: PROF_DEV_TYPE | Description: NULL |
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.