FSUSD Hub

Organization: Fairfield-Suisun Unified School District Database: FSUSD (Metabase DB ID: 6) Organization ID: 570bb649-b48b-4c63-922a-6c80382984bc

Recent Work

• 2025-01-15 - FSUSD Enrollment Forms Batch Generation - Generated 15 enrollment PDFs for 10 students across 3 expanded learning programs (ATT-2355)
• 2025-01-14 - FSUSD Enrollment Forms - Initial enrollment form generation for student 182918 (ATT-2302)

Programs

Expanded Learning Programs

• 24-25 Expanded Learning - After-school program across multiple school sites
• Summer Expanded Learning Camp - Summer learning program
• 24-25 Expanded Learning - Champions - Specialized after-school program

ELOP Acknowledgement Steps

Standard 3-step acknowledgement used across all FSUSD expanded learning programs:

1. First-come-first-served waitlist policy understanding
2. Access to ELOP policies on FSUSD.org homepage
3. Medical treatment authorization (911 emergency services)

Database Schema Notes

Key Findings:

• Program names stored with trailing spaces (e.g., "24-25 Expanded Learning ")
• School codes in program.metadata->mainSchoolCode not dependent.metadata->schoolCode
• Parent contact info (email/phone) not available in user.metadata
• No enrollment.user_id tracking which parent performed enrollment
• Session counts stored in enrollment.metadata->sessionCount but often NULL

Schema Structure:

• Students: dependent table with metadata JSONB
• Enrollments: enrollment table linking dependents to programs
• Parents: user and user_dependent_relationship tables
• Programs: program table with organization relationships

Tags: fsusd hub expanded-learning