{"main_topic":"education","sub_topic":"gosa","topic":"financial_efficiency_star_rating","key":"education/gosa/financial_efficiency_star_rating","version":"2.1.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 (the rating plus, for the 2019 and 2024 reports only, the school's own three-year PPE average and three-year CCRPI average the rating was computed from — the publisher's inputs, which differ from what the per_pupil_expenditure and ccrpi_scoring_by_component topics would reproduce, see limitations; the 2017/2018 school files publish no rolling averages). 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.","explorer":true,"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 per-pupil expenditure (nominal dollars) over the publication's window — a rating input. FY2024's window is non-contiguous (FY19+FY23+FY24). District rows every year; school rows 2019 and 2024 only (bronze PPE_Avg). The school values are the publisher's own rating inputs, NOT the mean of the per_pupil_expenditure topic's served yearly school values: the 2019 file computed them from restated FY2017/FY2018 figures the sibling's base-publication-wins merge deliberately does not serve, so 751 of 2,209 schools differ from the served three-year mean by more than $0.01 (max $2,613.60); the 2024 values equal the served FY19/FY23/FY24 mean (max difference $0.004). Extreme school values (up to $233,651) are tiny-enrollment schools, preserved as published. 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 in every publication year (except Talbot County 730's masked 2018 cell) and on school rows in 2019 and 2024 only: NULL on every 2017/2018 school row (those files publish no rolling averages) and on the one 2019 school row the publisher listed without an average (Cirrus Charter 7830611/0611, flagged non-compliant).","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 CCRPI Single Score (0-100 scale) over the publication's window — the academic-outcome input of the rating. District rows every year; school rows 2019 and 2024 only (bronze SS_Avg). The school values are the publisher's own inputs: the 2019 values rest on FY2017/FY2018 single scores that differ from ccrpi_scoring_by_component for 42 schools (61 school-year cells; max 25.3 points), and the 2024 values average FY2023/FY2024 school single scores no other served topic carries. Three 2019 school values overshoot 100 (100.2-101.1) because their FY2017 single score carried points-era bonus points (max 108.2, the same overshoot ccrpi_scoring_by_component serves); a quality check bounds the column to 0-100 everywhere else and to 110 on 2019 school rows.","valid_values":null,"example":71.2,"unit":"score","value_min":0,"value_max":null,"null_meaning":"Populated on every district row and on school rows in 2019 and 2024 only, for the schools the publisher rated (2,120 in 2019, 2,169 in 2024): NULL on every 2017/2018 school row (no rolling averages published) and on the 2019/2024 school rows listed with a PPE average but no CCRPI average (100 in 2019, 22 in 2024 — a single-score year was missing, so no rating was issued either).","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 (enforced by a quality check); the only rolling metric never published at the school level.","valid_values":null,"example":76,"unit":"percentile","value_min":null,"value_max":null,"null_meaning":"Populated on DISTRICT rows only (except Talbot County 730's masked 2018 cell); NULL on every school row — the school files publish no percentile.","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; the masked cells are ledgered per sentinel class in _transform_manifest.json masked_values (school: 103 '.' + 1 non-compliant in 2017, 127 '.' + 3 non-compliant in 2018; district: 1 non-compliant in 2018).","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 2017/2018 school-file '.' sentinel) instead of a numeric rating, and on the 2019/2024 school rows the publisher listed with a three-year PPE average but could not rate (100 in 2019, 22 in 2024; missing single-score year).","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 the publication issued no compliance status at all — the numeric-FESR school files (2019/2024) publish a rating with no status column, so EVERY school row from those files carries NULL, rated or not (2,220 rows in 2019, 2,191 in 2024); the sole exception is the one 2019 school flagged by the file's note column, which carries TRUE.","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 are carried on district rows in every publication year; on school rows, per_pupil_expenditure_three_year_avg and ccrpi_three_year_avg are populated for the 2019 and 2024 reports only (the 2017/2018 school files publish no rolling averages) and per_pupil_expenditure_percentile never (district-only). The school averages are the publisher's own rating inputs and differ from what the sibling topics would reproduce — do not rebuild them from per_pupil_expenditure or ccrpi_scoring_by_component: the 2019 workbook computed both from its own restated FY2017/FY2018 school values, which the per_pupil_expenditure topic's base-publication-wins merge deliberately does not serve, so 751 of 2,209 schools' PPE averages differ from the served three-year mean by more than $0.01 (483 by more than $1, 38 by more than $100, 6 by more than $1,000; max $2,613.60), and 42 schools' CCRPI averages use single scores that differ from ccrpi_scoring_by_component (61 school-year cells; max 25.3 points); the 2024 workbook's PPE average does equal the served FY19/FY23/FY24 mean (max difference $0.004), but its CCRPI average rests on FY2023/FY2024 school single scores that no other served topic carries (this topic is their only served form). The state-local/federal split of the school PPE average is not carried (no rating input; it does not reconcile to the average). Report-year school rows with no rating-family fact at all are omitted (32 in 2019, 84 in 2024; their spending facts live in the per_pupil_expenditure topic), while schools listed with a three-year PPE average but no rating are kept (100 in 2019, 22 in 2024; fesr_star_rating and ccrpi_three_year_avg NULL). 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":[],"non_additive":[],"value_implications":[],"values_endpoint":"/api/v1/education/financial_efficiency_star_rating/values"}