The K-12 staffing data, also known as the Registry for Educational Personnel, contain individual-level records on all education personnel for the academic years 2004-05 through 2019-20. While these data include information on employees from any educational entity in Michigan, the level of information recorded is not uniform for all employees. Private schools, for example, are able but not required to participate in the data collection. Additionally, for some positions (i.e. non-instructional) only a limited number of fields are required to be reported, regardless of the type of entity. These data are contained in nine datasets, which we categorize into the following three broad topical areas: Assignment, Employment, and Demographics; Education and Certifications; and Mobility. Note that some of these datasets could be used by researchers as a standalone product, but others should not due to differences in how and when districts record terminations and leaves of absence.

The Staff Demographics, Assignment, and Employment datasets comprise a significant portion of K-12 staffing data available through the Michigan Education Data Center. They contain information on who is employed, where they are employed, and for what function each semester. Researchers should exercise caution in using any of these datasets separately as there is some variability in how information is reported, and note that information on non-instructional employees is more limited. For example, districts may adopt different policies for recording staff members who are employed for partial semesters or for vacant positions. As a result, there may be some staffers included in the data that do not actually work in a given semester (e.g. substitute teachers).

Demographics

Highlights

Record Level: Employee-level 
Record Count: 1,021,070 observations 
Years Covered: 2004-Present 
Population Coverage: Part-time and full-time employees of educational entities in Michigan

The demographics file is a time-invariant file for all staff members included in REP, uniquely identified by the researcher personal identification code (RPIC). Note that while there should in theory be one observation per staff member, there are 2,341 RPICS with at least one duplicate observations. These duplicates are due to the fact that date of birth and gender are stored in the State’s personnel master file, while race/ethnicity is stored at the district level. Thus, if a staff member is employed by multiple districts and the districts have conflicting values for race/ethnicity, the staff member and their associated RPIC will have multiple observations in the base file. The variables included are RPIC, the old ID number, race/ethnicity, gender, and date of birth.

Researchers should be aware that in 2022, changes were made to how a staff member's race/ethnicity is aggregated when differing values reported in separate systems. Educators self-report their own race/ethnicity in MOECS, and districts report their employees’ race/ethnicity in the REP. MOECS and REP are two separate database systems. The race/ethnicity variable in the staff base file is created by first taking the self-reported race from MOECS and then, for educators who did not have race data in MOECS, they use the most recent race reported for that person in the REP. This has always been the case. What changed is how CEPI handles individuals whose race is reported as “unknown” in MOECS. Previously, CEPI would only extract race data from the REP if there was a missing value for their race in MOECS. This means that if the race was listed “unknown” (which is a non-missing value), they would not extract race data from the REP. They changed this in calendar year 2022. Now they extract race data from the REP for anyone with either a missing value or “unknown” race/ethnicity in MOECS. These changes apply to all staff members listed in the staff demographic file.

Employment

Highlights

Record Level: Employee by collection by school district 
Record Count: approx. 330,000 observations per collection 
Years Covered: 2004-Present 
Population Coverage: Part-time and full-time employees of educational entities in Michigan

The employment dataset contains information on the tenure of each staff member’s employment with a given district. Note that a staff member may work across multiple districts, and there may be conflicts in information reported across districts for the same staff member (e.g. highest education level). Researchers should be cautious in using the annual salary variable as not all districts are required to report this. The Employment data are theoretically unique at the RPIC x Collection X District level, but there are 97 RPICs with at least on duplicate record which may be due to having multiple hiring or termination dates in a given semester or multiple highest education levels.

Variables included are hire date, termination date, whether the position is funded, whether the position is filled by a permanent employee, employment status with the district, the highest educational degree earned, and annual salary (only required for Title 1).

Assignments

Highlights

Record Level: Employee by year by school district by assignment 
Record Count: 6,622,529 observations 
Years Covered: 2004-Present 
Population Coverage: Part-time and full-time employees of educational entities in Michigan

The assignment dataset contains detailed information about the job function(s) a staff member performs each semester in a given location. Data are reported per semester, but employees may have multiple rows per semester for reasons including performing multiple jobs in the same school, the same job for multiple grade levels, or the same job and grade for multiple schools and/or districts. Researchers should note that some assignment codes have changed over time, but we retain a variable with a description of the position which should be used to check for this issue. Researchers should also exercise caution when trying to use FTE or generate a total FTE as some staff members may perform the same position across multiple grades or settings.

The variables in the Assignment dataset can be categorized into variables about the staff member and about the assigned school. Note that staff members employed at the district level, and thus not associated with a particular school (e.g. district superintendent), will have missing values for the school variables. The school variables included are entity type, school code and name, district code and name, ISD code and name, and school open and close dates. The inclusion of the school, district, and ISD identifiers allow researchers to merge on additional information from their respective datasets. The staff variables include information on the staff member’s highly qualified status, effectiveness rating, FTE, assignment code and description, whether funded by a federal grant, flags to identify as a teacher or principal, type of position, funding code and description, grade(s) working with, and special settings.

Codebook

Showing 801 - 900 of 1138 results
Category Sort descending Variable Description
Category: K12 Building Variable: EMC_FOCUS_NT Description: 

Flag to specify if this EMC has a NT focus

Category: K12 Building Variable: EMC_FOCUS_IT Description: 

Flag to specify if this EMC has an IT focus

Category: K12 Building Variable: EMC_FOCUS_HEALTH Description: 

Flag to specify if this EMC has a Health focus

Category: K12 Building Variable: EMC_FOCUS_CTE Description: 

Flag to specify if this EMC has a CTE focus

Category: K12 Building Variable: FACE_VIRTUAL_SCHOOL Description: 

Virtual with face to face options; the school focuses on a systematic program of virtual instruction but includes some physical meetings among students or with teachers.

Category: K12 Building Variable: GR_08_AUTH Description: 

Flag to specify if this entity is authorized to offer instruction of Eighth grade students.

Category: K12 Building Variable: GR_08_ACTUAL Description: 

Flag to specify if this entity is offering instruction of Eighth grade students.

Category: K12 Building Variable: DELINQUENT_INSTITUTION Description: 

Flag to specify if this entity is authorized to offer instruction in a Delinquent Institution setting. A public or private residential facility that is operated primarily for the care of children who have been adjudicated as delinquent or in need of supervision.

Category: K12 Building Variable: GR_07_AUTH Description: 

Flag to specify if this entity is authorized to offer instruction of Seventh grade students.

Category: K12 Building Variable: GR_07_ACTUAL Description: 

Flag to specify if this entity is offering instruction of Seventh grade students.

Category: K12 Building Variable: GR_06_AUTH Description: 

Flag to specify if this entity is authorized to offer instruction of Sixth grade students.

Category: K12 Building Variable: GR_06_ACTUAL Description: 

Flag to specify if this entity is offering instruction of Sixth grade students.

Category: K12 Building Variable: GR_05_AUTH Description: 

Flag to specify if this entity is authorized to offer instruction of Fifth grade students.

Category: K12 Building Variable: GR_05_ACTUAL Description: 

Flag to specify if this entity is offering instruction of Fifth grade students.

Category: K12 Building Variable: GR_04_AUTH Description: 

Flag to specify if this entity is authorized to offer instruction of Fourth grade students.

Category: K12 Building Variable: GR_04_ACTUAL Description: 

Flag to specify if this entity is offering instruction of Fourth grade students.

Category: K12 Building Variable: GR_03_AUTH Description: 

Flag to specify if this entity is authorized to offer instruction of Third grade students.

Category: K12 Building Variable: GR_02_AUTH Description: 

Flag to specify if this entity is authorized to offer instruction of Second grade students.

Category: K12 Building Variable: ENTITY_TYPE_GROUP Description: 

Identifies whether the entity is a school, district, unique education provider, or non-instructional ancillary facility.

Category: K12 Building Variable: FAITH_BASED_INSTITUTION Description: 

Flag denoting a faith based institution. A faith based institution has a religious aspect or focus.

Category: K12 Building Variable: FAMILY_RESOURCE_CENTER Description: 

Flag denoting a family resource center. Department of Human Services workers deliver services on-site at school.

Category: K12 Building Variable: FULL_TIME_VIRTUAL_SCHOOL Description: 

Full Virtual; the school has no physical building where students meet with each other or with teachers, all instruction is virtual.

Category: K12 Building Variable: GENERAL_EDUCATION Description: 

Flag denoting this school provides general education in grades K-12. A public elementary/secondary school that does NOT focus primarily on vocational, special or alternative education, although it may provide these programs in addition to a regular curriculum.

Category: K12 Building Variable: GEO_DISTRICT_CODE Description: 

The Local Education Agency (LEA) District Code in which the entity is located.

Category: K12 Building Variable: GEO_DISTRICT_NAME Description: 

The Local Education Agency (LEA) District Name in which the entity is located.

Category: K12 Building Variable: GR_01_ACTUAL Description: 

Flag to specify if this entity is offering instruction of First grade students.

Category: K12 Building Variable: GR_01_AUTH Description: 

Flag to specify if this entity is authorized to offer instruction of First grade students.

Category: K12 Building Variable: GR_02_ACTUAL Description: 

Flag to specify if this entity is offering instruction of Second grade students.

Category: K12 Building Variable: GR_03_ACTUAL Description: 

Flag to specify if this entity is offering instruction of Third grade students.

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)

Category: Michigan Test for Teacher Certification Variable: SCALED_SCORE Description: 

Scaled Score

Category: Michigan Test for Teacher Certification Variable: FIELD_NAME Description: 

Field name corresponding to the test code

Category: Michigan Test for Teacher Certification Variable: TESTING_DATE Description: 

Date the MTTC test was taken

Category: Michigan Test for Teacher Certification Variable: PASS_FAIL Description: 

P (Pass), F (Failed)

Category: Michigan Test for Teacher Certification Variable: GRADE_LEVEL_DESC Description: 
Category: Michigan Test for Teacher Certification Variable: TEST_CODE Description: 

MTTC Test Code

Category: Michigan Test for Teacher Certification Variable: GRADE_LEVEL_CODE Description: 

A (Elementary), B (Secondary)

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)

Category: Michigan Test for Teacher Certification Variable: STATE Description: 

State for out of state examinees only

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)

Category: Michigan Test for Teacher Certification Variable: MAJOR_OR_MINOR_DESC Description: 
Category: Michigan Test for Teacher Certification Variable: MAJOR_OR_MINOR_CODE Description: 

A (Major), B (Minor)

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_7 Description: 

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_4 Description: 

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_TYPE_2 Description: 

The code to identify the reason a modification was made to the student’s curriculum.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_6 Description: 

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_TYPE_1 Description: 

The code to identify the reason a modification was made to the student’s curriculum.

Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_2 Description: 

The code to identify the type of additional instruction time related activities delivered to the student.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_TYPE_3 Description: 

The code to identify the reason a modification was made to the student’s curriculum.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_2 Description: 

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_1 Description: 

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_1 Description: 

The code to identify the type of additional instruction time related activities delivered to the student.

Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_5 Description: 

The code to identify the type of additional instruction time related activities delivered to the student.

Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_3 Description: 

The code to identify the type of additional instruction time related activities delivered to the student.

Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_6 Description: 

The code to identify the type of additional instruction time related activities delivered to the student.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_5 Description: 

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_4 Description: 

The code to identify the type of additional instruction time related activities delivered to the student.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_3 Description: 

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Category: Postsecondary Building Variable: IHE_PHYS_ADD_LINE_TWO Description: 

The second line of the physical address for the entity.

Category: Postsecondary Building Variable: IHE_PHYS_STATE Description: 

The state of the physical address for the entity.

Category: Postsecondary Building Variable: IHE_PHYS_CITY Description: 

The city of the physical address for the entity.

Category: Postsecondary Building Variable: SNAPSHOT_DAY Description: 

The date in which the snapshot was created. These static 'Snapshots' of data are what is loaded to the MSLDS

Category: Postsecondary Building Variable: HIGHER_ED_CODE Description: 

The unique identifier of the IHE entity in the Educational Entity Master (EEM).

Category: Postsecondary Building Variable: IHE_CONTROL Description: 

Designates whether an IHE is publicly or privately controlled.

Category: Postsecondary Building Variable: IS_OPEN Description: 

A Y or N flag stating the Open Status of most Michigan Institutions.

Category: Postsecondary Building Variable: IPEDS_CODE Description: 

IPEDS (Integrated Postsecondary Education Data Systems) IHE identification code.

Category: Postsecondary Building Variable: IHE_NAME Description: 

The official or legal name of the institution.

Category: Postsecondary Building Variable: IHE_LEVEL Description: 

Designates whether an IHE is a 2-year or 4-year institution.

Category: Postsecondary Building Variable: IHE_PHYS_ZIP_LINE_ONE Description: 

The zip code of the physical address for the entity.

Category: Postsecondary Building Variable: IHE_PHYS_ADD_LINE_ONE Description: 

The first line of the physical address for the entity.

Category: Professional Development Variable: HOURS_ENGAGED Description: 

Number of hours of training. Semester credit hours are converted to hours here using this formula: one semester credit hour = 25 education-related professional learning hours. Similarly, # of days of PD from REP is converted to hours by multiplying #of days by 6.

Category: Professional Development Variable: PROF_DEV_CATEGORY Description: 

The District Provided Professional Development (DPPD & those for the new teachers) training categories. For other types of training N/A is entered.

Category: Professional Development Variable: PROF_DEV_TYPE Description: 

The type of training the staff have received. There are three types of training: State Continuing Education Clock Hours (SCECHs) are organized professional development activities that teachers use for progression. District Provided Professional Development (DPPD) could also be used by educators to renew their certificate or progression.College Credits are also used for professional development and certificate renewal/progression. Please note that in order to distinguish DPPD information entered by the educators from the DPPD offered to new teachers by the districts, a fourth PD type is created here, called DPPD-New Teacher Training.

Category: Professional Development Variable: ENTITY_CODE Description: 

Code of the facility that the staff received training. The IPEDS are extracted from EEM and NCES IPEDS datasets by joining the MOECS data with those two datasets on the entity name. So, if the college name was abbreviated or misspelled, N/A is entered.

Category: Professional Development Variable: PD_TRAINING_COURSE_NUMBER Description: 

The college credit course number. For other training types, "N/A" is entered.

Category: Professional Development Variable: PD_TRAINING_NAME Description: 

Name of the training received by the staff

Category: Professional Development Variable: ENTITY_NAME Description: 

Name of the college, district, or other facilities that the staff received training (as entered by the educator) or offered the training (as entered in REP by the districts).

Category: Program Participation Variable: PROGRAM_CIP_DESCRIPTION Description: 

The description of the discipline or field of study of the student's program, as defined in the Classification of Instructional Programs (CIP) by the US Department of Education's National Center for Education Statistics (NCES).

Category: Program Participation Variable: PROGRAM_CIP_CATEGORY Description: 

The high-level category description of the discipline or field of study of the student's program, as defined in the 2-digit Classification of Instructional Programs (CIP) by the US Department of Education's National Center for Education Statistics (NCES).

Category: Program Participation Variable: PROGRAM_TYPE Description: 

The type of academic program the student is working toward at the IHE during the session. Examples: Major, Minor, SecondMajor, Concentration.

Category: Program Participation Variable: PROGRAM_NAME Description: 

The institution's internal name of the program, major, minor or field of study the student is working toward at the IHE during the session.

Category: Program Participation Variable: PROGRAM_CIP_CODE Description: 

The code indicating a discipline or field of study for the academic program the student is working toward. As submitted by the IHE, sourced from the Classification of Instructional Programs (CIP), by the US Department of Education's National Center for Education Statistics (NCES).

Category: Program Participation Variable: IS_STARR_PROGRAM Description: 

Designates if the session record came from the STARR collection.

Category: Program Participation Variable: IS_INTERNATIONAL_STUDENT_PROG Description: 

Indicates student is an international student participating in a foreign exchange program.

Category: Program Participation Variable: HOMELESS Description: 

Indicates if the student is homeless.

Category: Program Participation Variable: MIGRANT Description: 

Indicates if the student is a migrant student.

Category: Program Participation Variable: ALTERNATIVE_EDUCATION Description: 

Indicates this student is currently participating in an alternative education program (including seat-time waiver programs).

Category: Program Participation Variable: IS_IMMIGRANT_PROGRAM Description: 

Indicates the student has immigrated to the United States from another country and is aged 3 through 21 years, was not born in any state in America and has not attended one or more schools in any one or more states for more than three full academic years. NOTE: The United States Department of Education (USED) includes foreign exchange students as eligible for Title III immigrant programs.

Category: Program Participation Variable: IS_AT_RISK_PROGRAM Description: 

Flag indicating a student is eligible for at-risk (section 31a) funding.

Category: Program Participation Variable: IS_SEAT_TIME_WAIVER Description: 

Indicates this student is receiving his/her instruction for three or more courses through a virtual education program.

Category: Program Participation Variable: IS_MIGRANT_ELIGIBLE Description: 

Flag indicating if the student was eligible for Migrant services.

Category: Program Participation Variable: IS_ENGLISH_LEARNER Description: 

Flag that indicates if the student was eligible to receive Limited English Proficient (LEP) services.

Category: Program Participation Variable: IS_TITLE_I_TAS_PROGRAM Description: 

Student participated in a targeted assistance school (TAS) program.

Category: Program Participation Variable: SPECIAL_ED Description: 

Indicates that the student is in a special education program.

Category: Program Participation Variable: IS_HOMELESS_PROG Description: 

Flag indicating that the homeless code field has a value greater than 0 for the student.

Category: Program Participation Variable: IS_SECTION_504_PROGRAM Description: 

Indicates this student is considered disabled under Section 504 of the Rehabilitation Act of 1973.

Category: Program Participation Variable: IS_DEVELOPMENTAL_KINDERGARTEN Description: 

Indicates this student participated in a Developmental Kindergarten program (a defined two-year Kindergarten program that precedes entry into first grade).

Category: Program Participation Variable: IS_OUT_OF_STATE_RES_PROGRAM Description: 

Indicates the student attends the district from a state or a province other than Michigan.

Category: Program Participation Variable: IS_ALTERNATIVE_EDUCATION Description: 

Indicates this student is currently participating in an alternative education program (including seat-time waiver programs).

Category: Program Participation Variable: IS_EARLY_MID_COLLEGE_PART_PROG Description: 

Indicates the student is enrolled in an early/middle college program. This program could reside at a public high school, community college or a state public university. Students may attend as early as ninth grade.