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 601 - 700 of 1138 results
Category Sort descending Variable Description
Category: Enrollment and Attendance Variable: ADDITIONAL_ELIGIBILITY_FACTORS Description: 

Added in 2017-2018 Year Data: Additional factors used to determine a child’s eligibility for a Great Start Readiness Program.

Category: Enrollment and Attendance Variable: DELIVERY_METHOD_NAME Description: 

The name of the type of location where the child attends the reported program or receives early childhood services.

Category: Enrollment and Attendance Variable: PROGRAM_END_DATE Description: 

The date (month, day and year) the child last participated in a program or received services through the reported early childhood program. Note where Program Start Date = Program End date typically indicates a correction in submission and these records are normally filtered out.

Category: Enrollment and Attendance Variable: FISCAL_ENTITY_NAME Description: 

The state-assigned entity name identifying the entity receiving funding directly from the state to provide programs and/or services to the student/child reported.

Category: Enrollment and Attendance Variable: FISCAL_ENTITY_TYPE_CODE Description: 

The category code to which the fiscal entity belongs within EEM.

Category: Enrollment and Attendance Variable: PROVIDER_LICENSE_NUMBER Description: 

The license number assigned to the location a child receives early childhood services. License numbers are alphanumeric codes that are unique to each provider, as assigned by Michigan Department of Licensing and Regulatory Affairs (LARA). Tribal programs not licensed by the state may use a 14-digit code assigned by the Early Childhood Investment Corporation (ECIC) instead.

Category: Enrollment and Attendance Variable: FISCAL_ENTITY_CODE2 Description: 

Refer to definition of Fiscal_Entity_Code. Fiscal_Entity_Code2 identifies thesecond entity receiving funding for blended programs.

Category: Enrollment and Attendance Variable: FISCAL_ENTITY_NAME2 Description: 

The state-assigned entity name identifying the second fiscal entity receiving funding directly from the state to provide programs and/or services to the student/child reported.

Category: Enrollment and Attendance Variable: QUALIFYING_FACTORS Description: 

Added in 2017-2018 Year Data: A list of qualifying factors considered at the time child eligibility was determined for a Great Start Readiness Program. Qualifying factors are those which automatically prioritize a child for enrollment in GSRP.

Category: Enrollment and Attendance Variable: DELIVERY_SCHEDULE_NAME Description: 

The name of the primary schedule followed by the child for this program or service.

Category: Enrollment and Attendance Variable: PROGRAM_EXIT_REASON_CODE Description: 

The primary reason code for the child leaving the reported early childhood program or service.

Category: Enrollment and Attendance Variable: EARLY_CHILDHOOD_PROGRAM_NAME Description: 

The name of the early childhood program or service provided to the child.

Category: Enrollment and Attendance Variable: IHE_ENTRY_DATE Description: 

The year, month and day of the first enrollment at the institution.

Category: Enrollment and Attendance Variable: IHE_CONTROL Description: 

Designates whether an IHE is publicly or privately controlled.

Category: Enrollment and Attendance Variable: IS_REMEDIAL_READING_SESSION Description: 

Y/N indicator of whether any remedial reading courses were taken during the session.

Category: Enrollment and Attendance Variable: IHE_RESIDENCY_STATUS Description: 

A student’s residency status for tuition purposes.

Category: Enrollment and Attendance Variable: IS_REMEDIAL_WRITING_SESSION Description: 

Y/N indicator of whether any remedial writing courses were taken during the session.

Category: Enrollment and Attendance Variable: IHE_INSTATE_OUTSTATE Description: 

Designates whether an IHE is in Michigan or not in Michigan.

Category: Enrollment and Attendance Variable: MOD_CREDITS_ATTEMPTED_SESSION Description: 

Sum Total of STARR Credits Attempted and NSC FTE Days converted to Credits Earned, during a session.

Category: Enrollment and Attendance Variable: IS_REMEDIAL_SESSION Description: 

Y/N indicator of whether remedial courses of any type were taken during the session.

Category: Enrollment and Attendance Variable: IHE_GPA_TERM Description: 

The grade point average (GPA) for the respective academic session.

Category: Enrollment and Attendance Variable: IHE_GPA_CUM Description: 

The cumulative grade point average (GPA) for all courses taken at the IHE by the end of the session.

Category: Enrollment and Attendance Variable: STUDENT_LEVEL_CODE Description: 

The level of education the student is working toward during the academic session. (NO LONGER COLLECTED as of 2017-18).

Category: Enrollment and Attendance Variable: MOD_CREDITS_EARNED_INSTATE_CUM Description: 

Cumulative total to date of STARR Credits Earned and NSC FTE Days converted to Credits Earned, at all Michigan institutions the student has attended.

Category: Enrollment and Attendance Variable: MOD_CREDITS_EARNED_4YR_CUM Description: 

Cumulative total to date of STARR Credits Earned and NSC FTE Days converted to Credits Earned, at all 4 year institutions the student has attended.

Category: Enrollment and Attendance Variable: IHE_TOTAL_CREDITS Description: 

Total (cumulative) credits earned at an IHE according to STARR data only.

Category: Enrollment and Attendance Variable: IS_REMEDIAL_SCIENCE_SESSION Description: 

Y/N indicator of whether any remedial science courses were taken during the session.

Category: Enrollment and Attendance Variable: STUDENT_HOME_STATE Description: 

The name of the student's legal home permanent state or province.

Category: Enrollment and Attendance Variable: IS_LEAVE_OF_ABSENCE Description: 

Indicator of whether ALL courses in a specific session had an enrollment status of ‘Leave of Absence’.

Category: Enrollment and Attendance Variable: IS_REMEDIAL_ESL_SESSION Description: 

Y/N indicator of whether any remedial English as a Second Language (ESL) courses were taken during the session.

Category: Enrollment and Attendance Variable: ENROLLMENT_LEVEL Description: 

The student's enrollment level (undergraduate or graduate) at the IHE.

Category: Enrollment and Attendance Variable: MOD_CREDITS_EARNED_PRIVATE_CUM Description: 

Cumulative total to date of STARR Credits Earned and NSC FTE Days converted to Credits Earned, at all private institutions the student has attended.

Category: Enrollment and Attendance Variable: IS_FULL_TIME_30 Description: 

An indicator of whether or not a student is a full time student using 30 attempted credits per academic school year as the metric.

Category: Enrollment and Attendance Variable: IS_CC_SEEKING_TRNSFR_TO_4YR Description: 

Indicator of whether or not a student is enrolled at a community college with the intention of transferring to a 4-year institution only.

Category: Enrollment and Attendance Variable: MOD_CREDITS_EARNED_OUTSTATE_CUM Description: 

Cumulative total to date of STARR Credits Earned and NSC FTE Days converted to Credits Earned, at all out of state institutions the student has attended.

Category: Enrollment and Attendance Variable: IS_FOR_PROFIT_IHE Description: 

Y/N field that designates whether an IHE operates on a for-profit basis.

Category: Enrollment and Attendance Variable: IHE_PELL_STATUS Description: 

A value that indicates whether or not the student was eligible for or received a Pell Grant for the academic session.

Category: Enrollment and Attendance Variable: IHE_HIGH_SCHOOL_STUDENT Description: 

An indication of high school student status; options are: Not High School Student, Dual Enrolled, Concurrent Enrollment, Early Middle College, and Other High School Student

Category: Enrollment and Attendance Variable: IHE_CTE_STATUS Description: 

A value that indicates a student's status of enrollment and completion in occupational programs as identified by CIP Code, occupational specialty courses, or general occupational courses or apprenticeship-related instruction.

Category: Enrollment and Attendance Variable: FALL_TOTAL_FTE Description: 

GeneralEdFTE + Section52FTE + Section53FTE from Fall collection

Category: Enrollment and Attendance Variable: EXIT_STATUS_NAME Description: 

Descriptive name which correlates to student's exit status.

Category: Enrollment and Attendance Variable: COUNT_DAYS_IN_BUILDING Description: 

The number of fall and spring collection in which a student was submitted in the MSDS in the building as continuing, regardless of FTE.

Category: Enrollment and Attendance Variable: IS_NON_RESIDENT Description: 

Indicates the student was attending the school as a non-resident during at least one of the collection periods in the school year.

Category: Enrollment and Attendance Variable: EXIT_STATUS_CODE Description: 

Code which correlates to the student's exit status.

Category: Enrollment and Attendance Variable: IS_FALL_PRIMARY Description: 

Indicates the primary school record for the student for the fall time period. Eligible records are those in which the student was actively enrolled as a public school student (residency code)--a deduplication process is then used to set this flag to Y for only one record, most often the record from the PEPE (see Technical Notes). Missing values indicate the student was not reported in this entity in the Fall.

Category: Enrollment and Attendance Variable: IS_FIRST_PRIMARY Description: 

Indicates the record from the first primary school seen for the student for the school year (IS_FALL_PRIMARY over IS_SPRING_PRIMARY over IS_EOY_PRIMARY).

Category: Enrollment and Attendance Variable: EXIT_STATUS Description: 

The student's current enrollment status description with the operating district or primary reason the student is no longer enrolled in the school district.

Category: Enrollment and Attendance Variable: IS_IEP_PLACED_ANOTHER_DISTRICT Description: 

Indicates when the student, as stipulated in his/her current IEP, participates in a center program, a cooperative-agreement program designed specifically for special education students or a cross-district special education program.

Category: Enrollment and Attendance Variable: DAYS_POSSIBLE Description: 

The total number of days that education services were available to the student. This is a cumulative number, from the first day the student could have attended (i.e. the first day of the school year, the date of new enrollment, or the beginning of a program [e.g., summer school]) through the last day of attendance (last day of school year, enrollment or program). For additional information about enrollment refer to the characteristic Enrollment Date in the Enrollment component.

Category: Enrollment and Attendance Variable: LEP_REENTRY_DATE Description: 

The date (month, day, and year) that the student was became re-engaged in either a Limited English Proficient (LEP) or an English as a Second Language (ESL) program or service.

Category: Enrollment and Attendance Variable: ENROLLMENT_DATE Description: 

The Enrollment Date from the CohortHistory record.

Category: Enrollment and Attendance Variable: SPECIAL_ED_EXIT_DATE Description: 

The month, day and year of the first day after the date a student last participated in special education programs or services because of the reason reported in Special Education Exit Reason.

Category: Enrollment and Attendance Variable: SCHOOL_LOCALE Description: 

A measure of a school's geographic status on an urban continuum that ranges from "large city" to "rural" as determined by NCES.

Category: Enrollment and Attendance Variable: PROGRAM_START_DATE Description: 

The date (month, day and year) the child first participated in a program or received services through the reported early childhood program. Note where Program Start Date = Program End date typically indicates a correction in submission and these records are normally filtered out.

Category: Enrollment and Attendance Variable: SPECIAL_ED_EXIT_REASON Description: 

The reason the student is no longer participating in special education programs or services.

Category: Enrollment and Attendance Variable: IS_SPRING_PRIMARY Description: 

Indicates the primary school record for the student for the spring time period. Eligible records are those in which the student was actively enrolled for that time period as a public school student (residency code)--a deduplication process is then used to set this flag to Y for only one, most often the record from the PEPE (see Technical Notes). Missing values indicate the student was not reported in this entity in the Spring.

Category: Enrollment and Attendance Variable: LEP_EXIT_DATE Description: 

The date (month, day, and year) that the student was no longer engaged in either an LEP or an ESL program or service.

Category: Enrollment and Attendance Variable: ENTITY_TYPE Description: 

Labels the entity by type (e.g., ISD School, LEA Unique Education Provider, Nonpublic School, College/University, etc.)

Category: Enrollment and Attendance Variable: IS_MOST_PRIMARY Description: 

Indicates the primary record according to which school was the student's primary school for the most collection periods (fall, spring, end of year). If no school was the primary school for 2 or more periods, then this flag is assigned to the first primary school of the school year.

Category: Enrollment and Attendance Variable: EXIT_DATE Description: 

The Exit Date from the CohortHistory record.

Category: Enrollment and Attendance Variable: IS_EOY_PRIMARY Description: 

Indicates the primary school record for the student for the end-of-year time period. Eligible records are those in which the student was actively enrolled for that time period as a public school student (residency code) OR was a graduating student--a deduplication process is then used to set this flag to Y for only one, most often the record with the most recent As Of Date.

Category: Enrollment and Attendance Variable: DAYS_ATTENDED Description: 

The total number of days that the student actually attended or received educational services.

Category: Enrollment and Attendance Variable: IS_SCHOOL_OF_CHOICE Description: 

Indicates the student was attending the school as a non-resident and using the Section 105 Schools of Choice option during at least one of the collection periods in the school year.

Category: Enrollment and Attendance Variable: SPRING_TOTAL_FTE Description: 

GeneralEdFTE + Section52FTE + Section53FTE from Spring collection

Category: Enrollment and Attendance Variable: FALL_SPECIAL_EDUCATION_FTE Description: 

Section52FTE + Section53FTE from Fall collection

Category: Enrollment and Attendance Variable: SPRING_SPECIAL_EDUCATION_FTE Description: 

Section52FTE + Section53FTE from Spring collection

Category: Enrollment and Attendance Variable: PROGRAM_EXIT_REASON_NAME Description: 

The primary reason name for the child leaving the reported early childhood program or service.

Category: Enrollment and Attendance Variable: EARLY_CHILDHOOD_PROGRAM_CODE Description: 

The code for the early childhood program or service provided to the child.

Category: Enrollment and Attendance Variable: FISCAL_ENTITY_CODE Description: 

The state-assigned entity code identifying the entity receiving funding directly from the state to provide programs and/or services to the student/child reported.

Category: Enrollment and Attendance Variable: FISCAL_ENTITY_TYPE_NAME Description: 

The category name to which the fiscal entity belongs within EEM.

Category: Enrollment and Attendance Variable: DELIVERY_SCHEDULE_CODE Description: 

The code for the primary schedule followed by the child for this program or service.

Category: Enrollment and Attendance Variable: COUNT_DAYS_IN_DISTRICT Description: 

The number of fall and spring collections in which a student was submitted in the MSDS in the district as continuing, regardless of FTE.

Category: Graduation Records Variable: COURT_ORDERED_FACILITY Description: 

Facilities that solely serve neglected and/or delinquent children and youth as defined by Title I, Part D.

Category: Graduation Records Variable: DROPOUT Description: 

Indicates if the student was a Dropout for graduation cohort purposes.

Category: Graduation Records Variable: EXEMPT Description: 

Indicates if the student is Exempt for graduation rate purposes.

Category: Graduation Records Variable: IS_SCHOOL_NONPUBLIC Description: 

Indicates if the graduating school is non-public.

Category: Graduation Records Variable: FIVE_YEAR Description: 

Indicator for students who earned a regular high school diploma in 5 years.

Category: Graduation Records Variable: SIX_YEAR Description: 

Indicator for students who earned a regular high school diploma in 6 years.

Category: Graduation Records Variable: FOUR_YEAR Description: 

Indicator for students who earned a regular high school diploma in 4 years.

Category: Graduation Records Variable: IS_EMC_PROGRAM Description: 

Indicates that the student is enrolled in a Early Middle College program.

Category: Graduation Records Variable: OFFTRACK Description: 

Indicates if the student's expected graduation date or graduation date is later than their cohort year.

Category: K12 Building Variable: COUNTY_NAME Description: 

The name of the county.

Category: K12 Building Variable: COUNTY_CODE Description: 

The official state-assigned two-digit code denoting the county location of the entity.

Category: K12 Building Variable: CONTRACTOR_STATUS Description: 

The profit status of the management organization associated with the PSA. For-profit management organizations are called EMOs and non-profit management organizations are called CMOs. These organizations provide managerial services to a district.

Category: K12 Building Variable: CONTACT_PHONE Description: 

This aligns with the current school principal information-Principals Phone number

Category: K12 Building Variable: CYBER_SCHOOL Description: 

Flag to specify if this entity is authorized to offer instruction for a cyber school virtual school setting.

Category: K12 Building Variable: CAREER_TECH_ED Description: 

Flag denoting a school that focuses primarily on providing secondary students with an occupationally relevant or career-related curriculum, including formal preparation for vocational, technical or professional occupations.

Category: K12 Building Variable: GR_12_ACTUAL Description: 

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

Category: K12 Building Variable: CONTACT_LAST_NAME Description: 

This aligns with the current school principal information-Principals Last Name

Category: K12 Building Variable: CONTACT_FIRST_NAME Description: 

This aligns with the current school principal information-Principals First Name

Category: K12 Building Variable: CONTACT_EMAIL Description: 

This aligns with the current school principal information-Principals Email

Category: K12 Building Variable: COMM_ELIG_OPTION Description: 

Flag denoting if this entity has the Community Eligibility Provision. The Community Eligibility Provision provides schools in high-poverty areas a means of sharing with USDA the cost of providing free breakfast and lunch to all students without applications.

Category: K12 Building Variable: CHARTERING_ORG_NAME Description: 

Name of the charter authorizer for the PSA district.

Category: K12 Building Variable: CHARTERING_ORG_CODE Description: 

Code of the charter authorizer for the PSA district.

Category: K12 Building Variable: CHARTER_AUTHORIZER_TYPE Description: 

The entity type for the chartering authorizer (i.e. district, ISD, and higher education institution).

Category: K12 Building Variable: CHART_ORG_PHYS_ZIP Description: 

Chartering org physical address ZIP

Category: K12 Building Variable: CHART_ORG_PHYS_CITY Description: 

Chartering org physical address City

Category: K12 Building Variable: CHART_ORG_PHYS_ADD_LINE_TWO Description: 

Chartering org physical address line two

Category: K12 Building Variable: CHART_ORG_PHYS_ADD_LINE_ONE Description: 

Chartering org physical address line one

Category: K12 Building Variable: PART_TIME_VIRTUAL_SCHOOL Description: 

Flag to specify if this entity is authorized to offer instruction for a part time virtual school setting. Retired as of the Fall 2017 EEM collection.