2026-01-16: ASSIST Reporting Partition Parameter
For: Lupita (SAUSD) Impact: Enabled SAUSD to generate legally compliant ASSIST attendance reports split into four distinct funding categories (ASSR, ASBR, BSBR, BSSR) without affecting other districts’ standard reporting functionality. Context: California Education Code Section 8483.1(a)(2)(B) requires attendance reporting to be categorized by funding type. SAUSD receives funding across four distinct categories and needed to filter their ASSIST reports accordingly.
Implementation:
Database Infrastructure:
- Added reportingParameters field to organization metadata with structure: {“reportingParameters”: {“ASSIST”: [“BSSR”, “ASSR”, “ASBR”, “BSBR”]}}
- Tagged SAUSD programs with appropriate reporting categories (BSSR for Before School Supplemental, ASSR for After School Supplemental, ASBR for After School Base, BSBR for Before School Base)
Query Modifications:
- Modified 5 Metabase queries to support optional partition parameter
- Added filter clause: | {{partition}} || ’”’)::jsonb
- Uses JSONB containment operator to check for tag presence
- Preserves existing program filtering logic while adding partition as additional AND condition
User Interface:
- Updated report description HTML to explain optional Report Type parameter with four categories
- Feature only enabled for districts that request it
- When partition not selected, shows all qualifying programs (backward compatible)
Related: ATT-2351
Tags: sausd reporting assist metabase compliance