Source document

pipeline_miami/verify/components.yaml

Served verbatim from the project repository. Internal working document conventions apply: documents may reference file paths, branch names, and findings-ledger anchors from the repo.

# Miami base-case (ii) reconciliation config. One block per directly-ingested
# served metric × year. Mirrors pipeline_philly/verify/components.yaml.

- metric_key: enrollment_oct
  reader: membership_total
  years: ["2016-17", "2017-18", "2018-19", "2019-20", "2020-21", "2021-22", "2022-23", "2023-24", "2024-25", "2025-26"]
  tolerance_abs: 0.0
- metric_key: enrollment_oct_gKG
  reader: membership_grade
  reader_args: { grade: "KG" }
  years: ["2018-19", "2022-23", "2023-24", "2025-26"]
  tolerance_abs: 0.0
- metric_key: enrollment_oct_g5
  reader: membership_grade
  reader_args: { grade: "5" }
  years: ["2018-19", "2022-23", "2023-24", "2025-26"]
  tolerance_abs: 0.0
- metric_key: enrollment_oct_g3
  reader: membership_grade
  reader_args: { grade: "3" }
  years: ["2016-17", "2017-18", "2022-23"]   # the invariants step flagged the 2016-17 and 2022-23 grade-3 medians; the re-read confirms the file
  tolerance_abs: 0.0
- metric_key: fish_capacity_school
  served_only_allowance: 3   # the 7 FISH name overrides leave 3 schools per year the text re-read cannot match by name (findings F.7)
  reader: fish_los
  reader_args: { field: school_capacity }
  years: ["2022-23", "2023-24", "2024-25"]
  tolerance_abs: 0.0
- metric_key: fish_capacity_permanent
  served_only_allowance: 3   # the 7 FISH name overrides leave 3 schools per year the text re-read cannot match by name (findings F.7)
  reader: fish_los
  reader_args: { field: permanent_capacity }
  years: ["2022-23", "2023-24", "2024-25"]
  tolerance_abs: 0.0
- metric_key: cofte
  served_only_allowance: 3   # the 7 FISH name overrides leave 3 schools per year the text re-read cannot match by name (findings F.7)
  reader: fish_los
  reader_args: { field: cofte }
  years: ["2022-23", "2023-24", "2024-25"]
  tolerance_abs: 0.0
- metric_key: utilization_school_capacity_pct
  served_only_allowance: 3   # the 7 FISH name overrides leave 3 schools per year the text re-read cannot match by name (findings F.7)
  reader: fish_los
  reader_args: { field: utilization_pct }
  years: ["2022-23", "2023-24", "2024-25"]
  tolerance_abs: 0.0
- metric_key: per_pupil_expenditure_school
  reader: essa_ppe
  reader_args: { column: 6 }
  years: ["2021-22", "2022-23", "2023-24", "2024-25"]
  tolerance_abs: 0.0
- metric_key: per_pupil_expenditure_total
  reader: essa_ppe
  reader_args: { column: 10 }
  years: ["2021-22", "2022-23", "2023-24", "2024-25"]
  tolerance_abs: 0.0
- metric_key: enrollment_abc
  reader: abc_book
  reader_args: { source_id: mdcps_abc_book_2026-27, field: enrollment_abc }
  years: ["2025-26"]
  tolerance_abs: 0.0
- metric_key: fish_capacity_permanent_abc
  reader: abc_book
  reader_args: { source_id: mdcps_abc_book_2026-27, field: fish_capacity_permanent_abc }
  years: ["2025-26"]
  tolerance_abs: 0.0
- metric_key: enrollment_oct_ccd
  reader: ccd_total
  years: ["2018-19", "2023-24"]
  tolerance_abs: 0.0

# ── Outcome metrics (P1). track: outcomes — reported separately from the closure-track verdict.
- metric_key: pct_ell
  track: outcomes
  reader: ell_share
  reader_args: { which: exact }
  years: ["2018-19", "2021-22", "2022-23", "2023-24", "2024-25", "2025-26"]
  tolerance_abs: 0.000001
- metric_key: pct_ell_lower_bound
  track: outcomes
  reader: ell_share
  reader_args: { which: lower }
  years: ["2018-19", "2021-22", "2022-23", "2023-24", "2024-25", "2025-26"]
  tolerance_abs: 0.000001
- metric_key: pct_ell_upper_bound
  track: outcomes
  reader: ell_share
  reader_args: { which: upper }
  years: ["2018-19", "2021-22", "2022-23", "2023-24", "2024-25", "2025-26"]
  tolerance_abs: 0.000001
- metric_key: ela_achievement
  track: outcomes
  reader: school_grades
  reader_args: { column_prefix: "english language arts achievement" }
  years: ["2018-19", "2021-22", "2022-23", "2023-24", "2024-25"]
  tolerance_abs: 0.0
- metric_key: math_achievement
  track: outcomes
  reader: school_grades
  reader_args: { column_prefix: "mathematics achievement" }
  years: ["2024-25"]
  tolerance_abs: 0.0
- metric_key: pct_econ_disadv
  track: outcomes
  reader: school_grades
  reader_args: { column_prefix: "percent of economically disadvantaged students" }
  years: ["2024-25"]
  tolerance_abs: 0.0
- metric_key: chronic_absenteeism_rate
  track: outcomes
  reader: absenteeism
  reader_args: { which: pct10 }
  years: ["2017-18", "2019-20", "2022-23", "2024-25"]
  tolerance_abs: 0.000001
- metric_key: absent_21plus_rate
  track: outcomes
  reader: absenteeism
  reader_args: { which: pct21 }
  years: ["2016-17", "2024-25"]
  tolerance_abs: 0.000001
- metric_key: graduation_rate_4yr
  track: outcomes
  reader: graduation
  reader_args: { group: total }
  years: ["2023-24", "2024-25"]
  tolerance_abs: 0.0
- metric_key: fast_ela_g3_proficiency
  track: outcomes
  reader: srs
  reader_args: { source_id: fldoe_srs_fast_ela_g3_spring2024 }
  years: ["2023-24"]
  tolerance_abs: 0.0
- metric_key: fast_math_g8_proficiency
  track: outcomes
  reader: srs
  reader_args: { source_id: fldoe_srs_fast_math_g8_spring2025 }
  years: ["2024-25"]
  tolerance_abs: 0.0
- metric_key: eoc_alg1_proficiency
  track: outcomes
  reader: srs
  reader_args: { source_id: fldoe_best_alg1_srs_spring2025 }
  years: ["2024-25"]
  tolerance_abs: 0.0
- metric_key: science_g5_proficiency
  track: outcomes
  reader: srs
  reader_args: { source_id: fldoe_science_g5_srs_spring2023 }   # 2023 layout: "Grade" in column 0
  years: ["2022-23"]
  tolerance_abs: 0.0
- metric_key: science_g8_proficiency
  track: outcomes
  reader: srs
  reader_args: { source_id: fldoe_srs_science_g8_spring2023 }
  years: ["2022-23"]
  tolerance_abs: 0.0
# Climate survey composites (independent re-read of the workbook's results sheet, or of its pivot cache for 2021-22)
- metric_key: survey_students_safety
  track: outcomes
  reader: climate_survey
  reader_args: { respondent: students, domain: safety }
  years: ["2019-20", "2021-22", "2024-25"]
  tolerance_abs: 0.01
- metric_key: survey_parents_teaching
  track: outcomes
  reader: climate_survey
  reader_args: { respondent: parents, domain: teaching }
  years: ["2018-19", "2021-22", "2023-24"]
  tolerance_abs: 0.01
- metric_key: survey_staff_leadership
  track: outcomes
  reader: climate_survey
  reader_args: { respondent: staff, domain: leadership }
  years: ["2020-21", "2021-22", "2022-23"]
  tolerance_abs: 0.01
- metric_key: survey_staff_safety
  track: outcomes
  reader: climate_survey
  reader_args: { respondent: staff, domain: safety }
  years: ["2024-25"]
  tolerance_abs: 0.01
- metric_key: survey_staff_teaching
  track: outcomes
  reader: climate_survey
  reader_args: { respondent: staff, domain: teaching }
  years: ["2021-22", "2024-25"]
  tolerance_abs: 0.01
# 2022-23 School Grades: four sheets with different column layouts (loader bug found 2026-09-15; every sheet now indexed on its own header)
- metric_key: school_grade_points_pct
  track: outcomes
  reader: school_grades
  reader_args: { column_prefix: "percent of total possible points" }
  years: ["2022-23", "2024-25"]
  tolerance_abs: 0.0
- metric_key: science_achievement
  track: outcomes
  reader: school_grades
  reader_args: { column_prefix: "science achievement" }
  years: ["2022-23"]
  tolerance_abs: 0.0
- metric_key: learning_gains_math_l25
  track: outcomes
  reader: school_grades
  reader_args: { column_prefix: "mathematics learning gains of the lowest 25" }
  years: ["2023-24"]
  tolerance_abs: 0.0