| Topic | Category | Variable | Description |
|---|---|---|---|
| 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 |
| 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: Field name corresponding to the test code |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: GRADE_LEVEL_CODE | Description: A (Elementary), B (Secondary) |
| 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: A (Major), B (Minor) |
| 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: Institution 1 that the examinees had their scores sent to (MI Examinees only) |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: MTTC_INSTITUTION_NAME_2 | Description: Institution 2 that the examinees had their scores sent to (MI Examinees only) |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: MTTC_INSTITUTION_NAME_3 | Description: Institution 3 that the examinees had their scores sent to (MI Examinees only) |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: PASS_FAIL | Description: P (Pass), F (Failed) |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: SCALED_SCORE | Description: Scaled Score |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: STATE | Description: State for out of state examinees only |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: TEST_CODE | Description: MTTC Test Code |
| Topic: Staff | Category: Michigan Test for Teacher Certification | Variable: TESTING_DATE | Description: Date the MTTC test was taken |
| Topic: Staff | Category: Professional Development | Variable: ENTITY_CODE | Description: Code of the facility that the staff received training |
| Topic: Staff | Category: Professional Development | Variable: ENTITY_NAME | Description: Name of college, district, or facility providing or recording training |
| Topic: Staff | Category: Professional Development | Variable: HOURS_ENGAGED | Description: Number of hours of training |
| Topic: Staff | Category: Professional Development | Variable: PD_NAME | Description: Name of the training received by the staff |
| Topic: Staff | Category: Professional Development | Variable: PD_NUMBER | Description: The college credit course number. For other training types, N/A is entered. |
| Topic: Staff | Category: Professional Development | Variable: PROF_DEV_CATEGORY | Description: The District Provided Professional Development training categories |
| Topic: Staff | Category: Professional Development | Variable: PROF_DEV_TYPE | Description: The type of training the staff have received |
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.