{"main_topic":"education","sub_topic":"gosa","topic":"financial_efficiency_star_rating","key":"education/gosa/financial_efficiency_star_rating","version":"2.0.0","year_min":2016,"year_max":2024,"year_gaps":[2020,2021,2022,2023],"update_frequency":"annual","detail_levels":["districts","schools"],"default_detail":"schools","path_template":"education/financial_efficiency_star_rating/year={year}/{detail}.parquet","grain":["year","district_code","school_code"],"title":"Financial Efficiency Star Rating (FESR)","summary":"0.5-5 star financial efficiency ratings — spending versus academic outcomes — for Georgia school districts and schools in FESR publication years (2016-2019, 2024).","description":"Georgia Office of Student Achievement (GOSA) Financial Efficiency Star Rating (FESR) — the program's efficiency evaluation of each rolling window, rating how much a district spends per student against its CCRPI academic results on a 0.5-5.0 star scale (0.5 increments; more stars = better academic outcomes per dollar). Rows exist ONLY for the fiscal years an FESR publication evaluated: district rows FY2016-FY2019 and FY2024 (one per traditional Georgia system, with the three-year rolling per-pupil-expenditure average, the three-year CCRPI average, and the PPE percentile the rating is built from), and school rows FY2017-FY2019 and FY2024 (rating only — schools publish no rolling metrics). GOSA paused the program FY2020-FY2023, so those years have no rows. The FY2024 report revived the rating with a non-contiguous FY19+FY23+FY24 window. The underlying annual spending panel (total/federal/state-local expenditures, FTE enrollment, per-pupil expenditure for every fiscal year) now lives in the sibling per_pupil_expenditure topic, from which each rating's rolling window is built.","source":"Governor's Office of Student Achievement (GOSA)","source_url":"https://gosa.georgia.gov/dashboards-data-report-card/downloadable-data","endpoint":"/api/v1/education/financial_efficiency_star_rating","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Fiscal year the FESR publication treats as its newest (rated) year. Only publication years exist in this topic: 2016-2019 and 2024 for districts, 2017-2019 and 2024 for schools (the program paused FY2020-FY2023 — those years have no rows).","valid_values":null,"example":2024,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"district_code","type":"string","role":"fk_district","nullable":false,"label":"District Code","short_description":"","description":"GOSA district/system code (FK to districts dimension), zero-padded to 3 digits (7-digit codes are charter authorizers, school rows only). District-detail rows cover the 180 traditional school systems (codes 601-793); school-detail rows additionally include charter authorizer codes. Populated on every row.","valid_values":null,"example":"657","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"school_code","type":"string","role":"fk_school","nullable":true,"label":"School Code","short_description":"","description":"GOSA school code, zero-padded to 4 characters (composite FK to schools dimension with district_code; not globally unique on its own). Populated on school rows only — district aggregate rows carry NULL.","valid_values":null,"example":"0103","unit":null,"value_min":null,"value_max":null,"null_meaning":"Populated only on school-detail rows; NULL on every district-detail row (the district level has no school code). The geography-key NULL pattern is how detail level is read from the unioned table.","key_metric_grain_contributor":false,"metric_component":null},{"name":"per_pupil_expenditure_three_year_avg","type":"number","role":"metric","nullable":true,"label":"Per Pupil Expenditure Three Year Average","short_description":"","description":"Three-year rolling average of the district's per-pupil expenditure (nominal dollars) over the publication's window — a rating input. FY2024's window is non-contiguous (FY19+FY23+FY24). District-detail rows only. The yearly per-pupil values live in the sibling per_pupil_expenditure topic.","valid_values":null,"example":9024.04,"unit":"currency","value_min":null,"value_max":null,"null_meaning":"Populated on DISTRICT rows only; NULL on every school row (schools do not publish rolling averages — derivable from the per_pupil_expenditure topic's yearly values).","key_metric_grain_contributor":false,"metric_component":null},{"name":"ccrpi_three_year_avg","type":"number","role":"metric","nullable":true,"label":"CCRPI Three Year Average","short_description":"","description":"Three-year rolling average of the district's CCRPI Single Score (0-100 scale) over the publication's window — the academic-outcome input of the rating. District-detail rows only.","valid_values":null,"example":71.2,"unit":"score","value_min":0,"value_max":100,"null_meaning":"Populated on DISTRICT rows only; NULL on every school row.","key_metric_grain_contributor":false,"metric_component":null},{"name":"per_pupil_expenditure_percentile","type":"integer","role":"metric","nullable":true,"label":"Per Pupil Expenditure Percentile","short_description":"","description":"Percentile rank (1-100 integer) of the district's per_pupil_expenditure_three_year_avg among all 180 Georgia districts in the same publication — population-based, not a national percentile. Higher = more spending per pupil. District-detail rows only.","valid_values":null,"example":76,"unit":"percentile","value_min":null,"value_max":null,"null_meaning":"Populated on DISTRICT rows only; NULL on every school row.","key_metric_grain_contributor":false,"metric_component":null},{"name":"fesr_star_rating","type":"number","role":"metric","nullable":true,"label":"FESR Star Rating","short_description":"Financial efficiency star rating, 0.5-5.0 in half-star steps — more stars mean better academic outcomes per dollar spent.","description":"Financial Efficiency Star Rating in 0.5 increments. Districts: observed 1.0-5.0; schools: 0.5-5.0 (the value range spans both levels). Half-steps enforced by a quality check. Bronze stores it as Float64 in early files and as strings in later files; non-numeric publisher statuses (district 'Non-Compliant'; school '.', 'Non-Compliant[ in 20YY]') are NULLed here, with non-compliance preserved via is_non_compliant.","valid_values":null,"example":3.5,"unit":"rating","value_min":0.5,"value_max":5,"null_meaning":"NULL where the publisher issued a 'Non-Compliant' status (is_non_compliant=true) or no rating (the school-file '.' sentinel) instead of a numeric rating.","key_metric_grain_contributor":false,"metric_component":null},{"name":"is_non_compliant","type":"boolean","role":"categorical","nullable":true,"label":"Is Non Compliant","short_description":"True when the district or school was flagged non-compliant with financial reporting (no star rating issued); false otherwise — including rows the publisher listed without issuing a rating, so false does not guarantee a published rating.","description":"FESR publication outcome: true when the source flags the entity non-compliant (no star rating exists, so fesr_star_rating is NULL — enforced by a quality check); false when the publisher processed the entity normally; NULL when no outcome was published. The false/NULL boundary is ERA-DEPENDENT, faithful to bronze (same behavior as the pre-split approved topic): the 2017/2018 school files publish an explicit status column, so rated rows AND the '.' listed-without-rating rows (103 in 2017, 127 in 2018) carry false; the 2019/2024 numeric school files publish no status, so rated rows carry NULL. A school's 2018-file 'Non-Compliant in 2017' sentinel is served on both the 2017 and 2018 rows (Cirrus Charter 7830611/0611), as the publisher restated it. Districts: the 2018 report's 'Non-Compliant' status (Talbot County 730). The FY2021 pause-year PPE-sentinel flag (7830629/0629) falls outside the publication years and is not carried (see limitations).","valid_values":null,"example":false,"unit":null,"value_min":null,"value_max":null,"null_meaning":"NULL where no compliance outcome was published — the numeric-FESR school files (2019/2024) publish ratings without a flag, so unrated schools in those years carry no outcome.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"fesr_star_rating","usage":"Star-schema fact table. Join the districts dimension on district_code; the schools dimension on district_code + school_code. Read directly with DuckDB over Parquet.","limitations":"Rows exist only for FESR publication years — district rows FY2016-FY2019 and FY2024, school rows FY2017-FY2019 and FY2024. GOSA paused the program FY2020-FY2023: those years have NO rows (they are not NULL-padded), and year-over-year comparisons across the pause span a five-year gap and a methodology revision (the FY2024 rating uses a non-contiguous FY19+FY23+FY24 window). Two detail levels (district, school) in one fact table, split by parquet filename; school_code is NULL on district rows. The rolling-window metrics (per_pupil_expenditure_three_year_avg, ccrpi_three_year_avg, per_pupil_expenditure_percentile) are district-only — school rows carry the rating and compliance flag alone. Report-year school rows with no rating outcome at all are omitted (their spending facts live in the per_pupil_expenditure topic). The single FY2021 pause-year non-compliance flag (school 7830629/0629) is not carried — it falls outside the publication-year row structure. The annual spending panel behind the ratings (expenditures, FTE enrollment, per-pupil expenditure, FY2014-FY2024) lives in the sibling per_pupil_expenditure topic; the former merged topic's ccrpi_single_score column was dropped from both derived topics in the v2 split (annual CCRPI scores are served by the ccrpi_* topics). FESR methodology evolved across publications; cross-year comparisons should account for GOSA-documented methodology drift. No cell-level small-cell suppression exists in this source; NULLs are structural, never suppression.","null_semantics":{"suppressed_to_null":false,"zero_is_real":true},"available_years":[2016,2017,2018,2019,2024],"schema_hash":"388fc5498ebc79a423c540b8a32ea8ff4fd6351d222cf2ef695e8f9f99d89fa1","tags":["education","governor's office of student achievement","financial_efficiency_star_rating"],"granularity_description":"One row per year, district_code, school_code (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), schools detail","query":"SELECT * FROM financial_efficiency_star_rating WHERE year = 2024 LIMIT 100"},{"description":"District 657 in 2024","query":"SELECT * FROM financial_efficiency_star_rating WHERE district_code = '657' AND year = 2024 LIMIT 100"},{"description":"Filter by is_non_compliant = False","query":"SELECT * FROM financial_efficiency_star_rating WHERE is_non_compliant = 'False' AND year = 2024 LIMIT 100"}],"foreign_keys":[{"column":"district_code","target_object":"districts","target_columns":["district_code"],"attribute_columns_added":["district_name","district_census_id","district_type"],"scope":"domain"},{"column":"school_code","target_object":"schools","target_columns":["district_code","school_code"],"attribute_columns_added":["school_name"],"scope":"domain"}],"filters":[{"param":"year","kind":"year_exact","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_min","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_max","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"detail","kind":"detail","type":"string","multi_value":false,"enum_enforced":true,"values":["districts","schools"],"default":"schools"},{"param":"district_code","kind":"foreign_key","column":"district_code","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"school_code","kind":"foreign_key","column":"school_code","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"is_non_compliant","kind":"categorical","column":"is_non_compliant","type":"boolean","multi_value":true,"enum_enforced":false,"values":null,"has_total":false,"total_value":null,"requires_single_value":false,"nullable":true,"null_filter_token":null},{"param":"district_type","kind":"dimension_attribute","dimension":"districts","column":"district_type","type":"string","multi_value":true,"enum_enforced":true,"values":["commission_charter","resa","standard","state_agency","state_charter","state_school","state_special"]},{"param":"school_level","kind":"dimension_attribute","dimension":"schools","column":"school_level","type":"string","multi_value":true,"enum_enforced":true,"values":["elementary","middle","high","k12","other"]},{"param":"locale","kind":"dimension_attribute","dimension":"schools","column":"locale","type":"string","multi_value":true,"enum_enforced":true,"values":["city","suburb","town","rural"]}],"filter_hints":[],"values_endpoint":"/api/v1/education/financial_efficiency_star_rating/values"}