The financial data files contain data commonly reported for MI school districts including expenditure, revenue, and balance data. Data are sourced from the State of Michigan’s Financial Information Database (FID). Data from the 2004-2022 school years are available. Future year's school year data will be added on.

K-12 Finance Balance

Record Level: District by year by fund by account (Major Class) 
Record Count: 34,000-42,000 fund/account records per year 
Years Covered: 2004-2022 
Population Coverage: District balances at the level of individual funds and accounts 

The district finance balance dataset contains information on the balances in specific district allocation accounts. Each allocation observation is unique within district and year on one of Fund, Suffix, or Major Class, although each Fund, Suffix, and Major Class are seen multiple times within a district and year. Working with the file will generally require some collapse of the file. The INDICATOR variable separates allocations into Balances, Liabilities, and Assets. The AMOUNT variable lists the monetary value associated with the given allocation. 

We have data for between 31,000 and 41,000 balances per year for the range of the dataset, rising slowly over time. We have a total of over 678,000 total balance records.

K-12 Finance Expenditures

Record Level: District by year by object code by expenditure function by fund. From 2017 onward also by by building. 
Record Count: 180,000-688,000 fund/account records per year 
Years Covered: 2004-2022 
Population Coverage: K12 District expenditures 

The district finance expenditures dataset has information describing district spending and what specific district allocation account or grant its coming from. The district expenditure dataset includes BUILDING_CODE and BUILDING_NAME information from 2017 onward, allowing researchers to track expenditures from 4125 buildings. However only roughly two thirds of the over 2.8 million expenditures in these years has building information, with the other third being only at the district level. 

The three digit object code (with a fourth digit "0" added on) is split out into three variables for researcher ease in grouping AMOUNT values they are interested in. These three variables are the HEADER_OBJECT_CODE, SUBHEADER_OBJECT_CODE, and OBJECT_CODE. For example, if the object code is 1870, the HEADER_OBJECT_CODE will be "1000" and the associated HEADER_OBJECT_DESC will indicate "Salaries". The SUBHEADER_OBJECT_CODE is 1800 and SUBHEADER_OBJECT_DESC will indicate "Salary, Temporary". The OBJECT_CODE will be 1870 and the OBJECT_CODE_DESC will indicate "Salary, Temporary, Teaching". 

We have data for over 5.5 million different expenditures. From 2004 to 2016 there are between 180,000 and 242,000 expenditures. Starting in 2017 the numbers rise, at over 366,000 in 2017 and as high as 688,000 in 2022.

K-12 Finance Revenue

Record Level: District by year by fund by suffix code by account (Major Class) 
Record Count: 28,000-32,000 fund/account records per year 
Years Covered: 2004-2022 
Population Coverage: District revenues at the level of individual funds, functions, and accounts 

The district finance revenue dataset holds information on sources of income for districts with specific amounts and descriptive categories they fall under. The revenue data is structured similarly to the balance data, with observations split into fund, function, and major class data. We have data for between 28,000 and 32,000 revenue records per year, with a total of 569,502 records total.

Codebook

Showing 901 - 1000 of 1138 results
Category Sort descending Variable Description
Category: Program Participation Variable: IS_SPECIAL_EDUCATION Description: 

Flag indicating the student is eligible for Special Ed services.

Category: Program Participation Variable: IS_21ST_CENT_COMM_LC_PROG Description: 

Indicates this student participated in at least 30 sessions of an after-school or summer program funded through a 21st Century Community Learning Center (CCLC) grant.Program Code retired in 2017/2018

Category: Program Participation Variable: IS_REDUCED_LUNCH_ELIGIBLE Description: 

Flag indicating if the student is eligible for reduced lunch based on Direct Certification through DHHS or Supplemental Nutrition Eligibility (SNE). If the student qualifies for Free Lunch, then the Reduced Lunch Eligible flag will be 'N' regardless of reduced lunch-specific eligibility factors.

Category: Program Participation Variable: IS_IMMIGRANT_PROGRAM Description: 

Flag indicating if the student participated in an Immigrant program.

Category: Program Participation Variable: IS_MIGRANT_ELIGIBLE Description: 

Flag indicating if the student was eligible for Migrant services.

Category: Program Participation Variable: IS_SUPPLEMENTAL_DIRECT_CERT Description: 

Flag indicating if the student has an active record in the Direct Certification database provided by DHHS.

Category: Program Participation Variable: IS_ELIGIBLE_FREE_LUNCH Description: 

Flag indicating if the student is eligible for free lunch based on being Migrant, Homeless, Direct Cert or Supplemental Nutrition Eligibility (SNE).

Category: Program Participation Variable: IS_HOMELESS_PROGRAM Description: 

Flag indicating if the homeless code field has a value greater than 0.

Category: SAT and ACT Variable: ACT_SCIENCE_SCORE Description: 

The ACT score for the science portion of the assessment.

Category: SAT and ACT Variable: WKEY_MTH_VALID Description: 

Flag denoting whether the student's test was valid for the mathematics portion of the assessment. (Y= Yes; N=No)

Category: SAT and ACT Variable: ACT_ENGLISH_WRITING_SCORE Description: 

The ACT score for the English_writing portion of the assessment.

Category: SAT and ACT Variable: IS_COLLEGE_REPORTABLE Description: 

A flag denoting whether the ACT scores for a student are considered viable to report to colleges.

Category: SAT and ACT Variable: SAT_MATH_SGP Description: 

The student growth percentile (SGP) for the mathematics portion of the assessment.

Category: SAT and ACT Variable: SAT_ELA_SGP_LEVEL Description: 

The student growth percentile (SGP) abbreviation for the English language arts portion of the assessment.

Category: SAT and ACT Variable: SAT_ELA_SGP Description: 

The student growth percentile (SGP) for the English language arts portion of the assessment.

Category: SAT and ACT Variable: SAT_MATH_COLLEGE_READY Description: 

Indicates whether college/career ready benchmark was met on the Mathematics test.

Category: SAT and ACT Variable: SAT_ELA_VALID Description: 

Flag denoting whether the student's test was valid for the English language arts portion of the assessment.

Category: SAT and ACT Variable: WKEY_LOC_INFO_LEVEL_SCORE Description: 

The level score for the locating information portion of the assessment. Level Scores are often used in hiring and advancements decisions. They are based on ACT WorkKeys job profiles which are a snapshot of the skills needed for a particular job.

Category: SAT and ACT Variable: SAT_MATH_SCORE Description: 

The official SAT score for the mathematics portion.

Category: SAT and ACT Variable: SAT_ELA_SCORE Description: 

The official SAT score for the English language arts portion.

Category: SAT and ACT Variable: SAT_MATH_VALID Description: 

Flag denoting whether the student's test was valid for the mathematics portion of the assessment.

Category: SAT and ACT Variable: SAT_TOTAL_SCORE Description: 

The official overall SAT score.

Category: SAT and ACT Variable: SAT_MATH_SGP_LEVEL_DESC Description: 

The student growth percentile (SGP) description for the mathematics portion of the assessment.

Category: SAT and ACT Variable: ACT_MATH_SCORE Description: 

The ACT score for the math portion of the assessment.

Category: SAT and ACT Variable: SAT_ELA_SGP_LEVEL_DESC Description: 

The student growth percentile (SGP) description for the English language arts portion of the assessment.

Category: SAT and ACT Variable: WKEY_RDG_VALID Description: 

Flag denoting whether the student's test was valid for the reading portion of the assessment. (Y= Yes; N=No)

Category: SAT and ACT Variable: WKEY_RDG_SCALED_SCORE Description: 

The scaled score for the reading portion of the assessment. Scale Scores are used by educators to track growth in skills over time.

Category: SAT and ACT Variable: WKEY_LOC_INFO_SCALED_SCORE Description: 

The scaled score for the locating information portion of the assessment. Scale Scores are used by educators to track growth in skills over time.

Category: SAT and ACT Variable: WKEY_RDG_LEVEL_SCORE Description: 

The level score for the reading portion of the assessment. Level Scores are often used in hiring and advancements decisions. They are based on ACT WorkKeys job profiles which are a snapshot of the skills needed for a particular job.

Category: SAT and ACT Variable: ACT_READING_SCORE Description: 

The ACT score for the reading portion of the assessment.

Category: SAT and ACT Variable: SAT_MATH_SGP_LEVEL Description: 

The student growth percentile (SGP) abbreviation for the mathematics portion of the assessment.

Category: SAT and ACT Variable: SAT_COMBINED_VALID Description: 

Flag denoting whether the student's test was valid for the English language arts and mathematics portions of the assessment.

Category: SAT and ACT Variable: WKEY_MTH_SCALED_SCORE Description: 

The scaled score for the mathematics portion of the assessment. Scale Scores are used by educators to track growth in skills over time.

Category: SAT and ACT Variable: SAT_ELA_COLLEGE_READY Description: 

Indicates whether college/career ready benchmark was met on ELA test

Category: SAT and ACT Variable: WKEY_LOC_INFO_VALID Description: 

Flag denoting whether the student's test was valid for the locating information portion of the assessment. (Y= Yes; N=No)

Category: SAT and ACT Variable: ACT_COMPOSITE_SCORE Description: 

The composite score ranges from 1 (low) to 36 (high). The Composite score is the average of your four test scores, rounded to the nearest whole number.

Category: SAT and ACT Variable: ACT_ENGLISH_SCORE Description: 

The ACT score for the English portion of the assessment.

Category: SAT and ACT Variable: WKEY_NCRC_DESC Description: 

The ACT WorkKeys National Career Readiness Certificate (ACT WorkKeys NCRC®) is an assessment-based credential issued at four levels; Platinum, Gold, Silver, and Bronze. Other levels show information about the test, not necessarily credential levels. The NCRC measures and certifies the essential work skills needed for success in jobs across industries and occupations.

Category: SAT and ACT Variable: ACT_WRITING_SCORE Description: 

The ACT score for the writing portion of the assessment.

Category: SAT and ACT Variable: WKEY_MTH_LEVEL_SCORE Description: 

The level score for the mathematics portion of the assessment. Level Scores are often used in hiring and advancements decisions. They are based on ACT WorkKeys job profiles which are a snapshot of the skills needed for a particular job.

Category: Special Education Variable: SPECIAL_ED_SERVICE_CODE_8 Description: 

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Category: Special Education Variable: EO_SERVICE_NAME_7 Description: 

The name of the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.)

Category: Special Education Variable: SPECIAL_ED_PROGRAM_CODE_2 Description: 

The code representing the IEP-designated program(s), or IFSP program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment.

Category: Special Education Variable: SPECIAL_ED_PROGRAM_CODE_3 Description: 

The code representing the IEP-designated program(s), or IFSP program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment.

Category: Special Education Variable: SPECIAL_ED_SERVICE_CODE_10 Description: 

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Category: Special Education Variable: SPECIAL_ED_PROGRAM_CODE_1 Description: 

The code representing the IEP-designated program(s), or IFSP program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment.

Category: Special Education Variable: SPECIAL_ED_SERVICE_CODE_7 Description: 

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Category: Special Education Variable: SPECIAL_ED_SERVICE_CODE_4 Description: 

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Category: Special Education Variable: SPECIAL_ED_SERVICE_CODE_9 Description: 

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Category: Special Education Variable: SPECIAL_ED_SERVICE_CODE_3 Description: 

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Category: Special Education Variable: PARENTAL_CONSENT_DATE Description: 

The date on which the entity received the signed Parental Consent to Evaluate form. It is the beginning of the timeline for completion of the initial Individual Education Plan (IEP).

Category: Special Education Variable: SPECIAL_ED_SERVICE_CODE_6 Description: 

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Category: Special Education Variable: SPECIAL_ED_SERVICE_CODE_2 Description: 

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Category: Special Education Variable: SPECIAL_ED_SERVICE_CODE_5 Description: 

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Category: Special Education Variable: INITIAL_IEP_RESULT Description: 

The outcome code of the initial Individual Education Plan (IEP) determining if the student is eligible or ineligible for special education programs and services.

Category: Special Education Variable: INITIAL_IEP_COMPLETION_DATE Description: 

The completion of an Individual Education Program (IEP) is the date on the notice of the offer of a Free Appropriate Public Education (FAPE).

Category: Special Education Variable: SPECIAL_ED_SERVICE_CODE_1 Description: 

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Category: Special Education Variable: IEP_DATE Description: 

The date of the notice/offer of a Free Appropriate Public Education (FAPE) associated with the student's most recent Individual Education Program (IEP).

Category: Special Education Variable: INITIAL_IEP_TIMELIENESS Description: 

The timeliness status code for the evaluation of Individual Education Plan (IEP) eligibility.

Category: Special Education Variable: SECONDARY_DISABILITY_CODE_1 Description: 

Code used to describe additional disability characteristics as identified on the vision or audiological report.

Category: Special Education Variable: SPECIAL_ED_PROGRAM_CODE_4 Description: 

The code representing the IEP-designated program(s), or IFSP program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment.

Category: Special Education Variable: ELIGIBILITY_REASON_NAME_1 Description: 

The name/descriptor of the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined.

Category: Special Education Variable: ELIGIBILITY_REASON_CODE_10 Description: 

The code used to identify the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined.

Category: Special Education Variable: ELIGIBILITY_REASON_NAME_4 Description: 

The name/descriptor of the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined.

Category: Special Education Variable: ELIGIBILITY_REASON_CODE_6 Description: 

The code used to identify the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined.

Category: Special Education Variable: EO_SERVICE_NAME_4 Description: 

The name of the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.)

Category: Special Education Variable: START_OF_SERVICE_TIMELINESS_NAME Description: 

The name of the Part C Indicator 1: Indicate the service start status for the services identified on the child's Individual Family Service Plan (IFSP).

Category: Special Education Variable: SEA_NOTIFICATION Description: 

Part C Indicator 8 B: Notification to the SEA must occur at least 90 days prior to the toddler's third birthday for toddlers potentially eligible for Part B preschool services.

Category: Special Education Variable: START_OF_SERVICE_TIMELINESS_CODE Description: 

The code for the Part C Indicator 1: Indicate the service start status for the services identified on the child's Individual Family Service Plan (IFSP).

Category: Special Education Variable: ELIGIBILITY_REASON_NAME_9 Description: 

The name/descriptor of the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined.

Category: Special Education Variable: EO_SERVICE_CODE_1 Description: 

The code for the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.)

Category: Special Education Variable: ELIGIBILITY_REASON_NAME_7 Description: 

The name/descriptor of the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined.

Category: Special Education Variable: ELIGIBILITY_REASON_NAME_10 Description: 

The name/descriptor of the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined.

Category: Special Education Variable: ELIGIBILITY_REASON_CODE_8 Description: 

The code used to identify the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined.

Category: Special Education Variable: RESULT_OF_INITIAL_IFSP_NAME Description: 

The name that indicates the results of the Individual Family Service Plan (IFSP) eligibility determination.

Category: Special Education Variable: ELIGIBILITY_REASON_CODE_7 Description: 

The code used to identify the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined.

Category: Special Education Variable: LEA_NOTIFICATION Description: 

Part C Indicator 8 B: Notification to the LEA where the toddler resides must occur at least 90 days prior to the toddler's third birthday for toddlers potentially eligible for Part B preschool services.

Category: Special Education Variable: EO_SERVICE_CODE_4 Description: 

The code for the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.)

Category: Special Education Variable: TRANSITION_CONF_TIMELINESS_CODE Description: 

Part C Indicator 8 C code: Indicate if the transition IFSP conference was held within the required timeframe (at least 90 days but not more than nine months prior to the toddler's third birthday).

Category: Special Education Variable: PART_C_EXIT_REASON_NAME Description: 

The reason given for a child discontinuing services through Part C.

Category: Special Education Variable: TRANSITION_IFSP_TIMELINESS_CODE Description: 

Part C Indicator 8 A code: Indicate if the transition plan in the IFSP was completed within the required timeframe (at least 90 days but not more than nine months prior to the toddler's third birthday).

Category: Special Education Variable: SERVICE_COORDINATING_AGENCY Description: 

The name of the type of agency that is providing service coordination for this child through Part C.

Category: Special Education Variable: EO_SERVICE_NAME_3 Description: 

The name of the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.)

Category: Special Education Variable: EO_SERVICE_CODE_2 Description: 

The code for the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.)

Category: Special Education Variable: EO_SERVICE_NAME_5 Description: 

The name of the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.)

Category: Special Education Variable: RESULT_OF_INITIAL_IFSP_CODE Description: 

The code that indicates the results of the Individual Family Service Plan (IFSP) eligibility determination.

Category: Special Education Variable: EO_SERVICE_NAME_8 Description: 

The name of the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.)

Category: Special Education Variable: EO_SERVICE_CODE_6 Description: 

The code for the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.)

Category: Special Education Variable: EO_SERVICE_CODE_8 Description: 

The code for the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.)

Category: Special Education Variable: EO_SERVICE_NAME_6 Description: 

The name of the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.)

Category: Special Education Variable: EO_SERVICE_CODE_7 Description: 

The code for the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.)

Category: Special Education Variable: ELIGIBILITY_REASON_NAME_3 Description: 

The name/descriptor of the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined.

Category: Special Education Variable: SECONDARY_DISABILITY_CODE_2 Description: 

Code used to describe additional disability characteristics as identified on the vision or audiological report.

Category: Special Education Variable: ELIGIBILITY_REASON_NAME_8 Description: 

The name/descriptor of the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined.

Category: Special Education Variable: ELIGIBILITY_REASON_CODE_5 Description: 

The code used to identify the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined.

Category: Special Education Variable: ELIGIBILITY_REASON_CODE_3 Description: 

The code used to identify the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined.

Category: Special Education Variable: INITIAL_IFSP_DATE Description: 

The date of the child's initial Individualized Family Service Plan (IFSP).

Category: Special Education Variable: EO_SERVICE_CODE_3 Description: 

The code for the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.)

Category: Special Education Variable: PRIM_SERVICE_SETTING_NAME Description: 

The name of the environment in which the majority of the services are being provided to the child.

Category: Special Education Variable: ELIGIBILITY_REASON_CODE_4 Description: 

The code used to identify the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined.