Educlaw K12

EduClaw K-12 Extensions

Sub-vertical of EduClaw SIS. Adds K-12 specific workflows: behavioral incident tracking with IDEA MDR compliance, student health records with FERPA-compliant access logging, the complete IDEA Part B pipeline (referral → IEP → services → progress), Section 504 plans, and end-of-year grade promotion with batch advancement.

Security Model

• Local-only: All data stored in ~/.openclaw/erpclaw/data.sqlite
• Fully offline: No external API calls, no telemetry, no cloud dependencies
• No credentials required: Uses erpclaw_lib shared library (installed by erpclaw)
• SQL injection safe: All queries use parameterized statements
• FERPA compliant: Health records, discipline records, and special education data access is logged
• IDEA compliance: IEP goals and services are immutable; changes require new IEP version
• Immutable records: Office visits, medication logs, immunizations, and promotion decisions cannot be modified after creation

Quick Start

# Create a discipline incident
python3 scripts/db_query.py --action add-discipline-incident \
  --incident-date 2025-10-15 --incident-time 10:30 \
  --location classroom --incident-type bullying \
  --severity moderate --academic-year-id <year-id>

# Add a student health profile
python3 scripts/db_query.py --action add-health-profile \
  --student-id <id> --allergies '[{"allergen":"peanuts","severity":"severe","epipen_location":"nurse office"}]'

# Create a SpEd referral
python3 scripts/db_query.py --action create-sped-referral \
  --student-id <id> --referral-source teacher \
  --referral-reason "Student struggling with reading fluency" \
  --referral-date 2025-09-10

# Start end-of-year promotion review
python3 scripts/db_query.py --action create-promotion-review \
  --student-id <id> --academic-year-id <year-id>

Tier 1: Most Used Actions

Discipline

Health Records

Special Education

Grade Promotion

Tier 2: Supporting Actions

Discipline

Health Records

Special Education

Grade Promotion

Tier 3: Reports and Advanced Workflows

Key Workflows

1. Discipline Incident → MDR (IDEA Students)

add-discipline-incident (header)
→ add-discipline-student (role + is-idea-eligible)
→ add-discipline-action (suspension → auto-calculates cumulative days)
  └─ If IDEA-eligible + ≥10 days: mdr_alert in response
→ add-discipline-notification
→ complete-discipline-incident
→ [If MDR needed] add-manifestation-review → update-manifestation-review

2. Health Records Enrollment

add-health-profile (allergies, conditions, physician)
→ add-immunization (one per dose per vaccine)
→ get-immunization-compliance (returns missing vaccines)
→ add-immunization-waiver (if exemption)
→ add-student-medication (for each school-administered medication)
→ submit-health-profile-verification (nurse sign-off → status: active)

3. IDEA Full Pipeline

create-sped-referral
→ update-sped-referral (consent_request_date → consent_pending)
→ update-sped-referral (consent_received_date → auto-calc 60-day deadline)
→ add-sped-evaluation (psychological, academic, speech, OT, etc.)
→ record-sped-eligibility (is_eligible=1 → auto-calc IEP deadline +30 days)
→ add-iep (draft)
→ add-iep-goal (one per area)
→ add-iep-service (one per mandated service)
→ add-iep-team-member (parent, teachers, admin, specialists)
→ activate-iep (parent consent → prior IEP superseded)
→ [Ongoing] record-iep-service-session (each delivery session)
→ [Each period] record-iep-progress (per goal)
→ [Annual] list-iep-deadlines → add-iep (new version) → activate-iep

4. Grade Promotion End-of-Year

list-at-risk-students (configurable GPA/attendance thresholds)
→ create-promotion-review (auto-populates discipline count from DB)
→ create-intervention-plan (for at-risk students)
→ update-promotion-review (teacher recommendation + rationale)
→ update-promotion-review (counselor recommendation + notes)
→ submit-promotion-decision (final immutable decision)
→ add-promotion-notification (creates guardian notifications)
→ apply-grade-promotion (idempotent; advances grade; graduates 12th)
→ generate-promotion-report (summary for administration)

FERPA / Privacy Notes

• Health records (get-health-profile, list-office-visits, get-office-visit, get-immunization-record, get-emergency-health-info) are logged to educlaw_data_access_log with data_category='health'.
• Discipline reads (get-discipline-incident, get-discipline-history) are logged with data_category='discipline'.
• Special education reads (get-sped-referral, get-active-iep, get-iep, record-sped-eligibility, get-active-504-plan, generate-iep-progress-report) are logged with data_category='special_education'.
• Emergency health access uses is_emergency_access=1 in the FERPA log.

The special_education data category is used for FERPA access logging of IEP and 504 plan records.

Business Invariants

Database

All tables use the shared SQLite database at ~/.openclaw/erpclaw/data.sqlite.

Run python3 init_db.py to create the 23 K-12 tables (requires erpclaw and educlaw parent tables to exist first).

New Tables (23)