Skip to main content

CALPADS error brief · SPRG

SPRG0645F1

Invalid NSLP Education Program Membership End Date
Severity Fatal
Error type CDD
Record type SPRG

Official CALPADS rule

What CALPADS is rejecting

Education Program Membership End Date Must be within the same Academic Year as the Education Program Academic Year

Focus fields

Fields validated

SENR Data 1.06 School of Attendance 1.23 Enrollment Status Code 1.24 Grade Level Code 1.22 Enrollment Start Date 1.23 Enrollment Exit Date SPRG Data 3.05 School of Attendance 3.13 - Education Program Code 3.15 - Education Program Membership Start Date

Recommended correction path

Suggested resolution

Certification lens

This rule is evaluated from the Fall 1 snapshot and related ODS histories. A record can pass transactional validation and still fail when CALPADS compares the student, dates, school, program, language status, demographics, or special education relationships effective for certification.

Fields and records evaluated

  • 3.06 Academic Year ID
  • 3.13 Program Code 181 or 182
  • 3.15 Membership Start Date
  • 3.16 Membership End Date

Six questions that resolve this certification finding

QuestionSpecific findingEvidence
What passed?Individual source transactions may have posted successfully.Submission detail and ODS history
What did Fall 1 expect?One NSLP membership segment per applicable academic-year boundary.Census-day snapshot logic
What is inconsistent?A membership spans into another academic year or the year/date fields are wrong.Student-level certification detail
Who owns correction?The program office establishes eligibility or participation; the SIS/program system owns the source record; the CALPADS coordinator verifies SPRG and snapshot inclusion.Authoritative local system and program records
What must change?End the supported segment within its academic year and create the appropriate next-year record when eligibility continues.Add, replace, delete, or sequence supported records
What proves resolution?1.0 Certification Errors; 5.1 Program Participants Count; 5.3 Program Participants Student List; applicable Fall 1 program reportRefreshed aggregate and supporting reports

Concrete checks

  • Confirm code 181 versus 182.
  • Apply July 1–June 30 boundaries.
  • Do not use one multiyear open-ended record.
  • Check the next-year segment for overlap or gaps.

Recommended correction path

  1. 1

    Identify the exact snapshot row

    Match the student, school, LEA, academic year, and census/snapshot revision implicated by SPRG0645F1.

  2. 2

    Compare the authoritative source

    Use the owning SIS, program, language, enrollment, or special education record. The program office establishes eligibility or participation; the SIS/program system owns the source record; the CALPADS coordinator verifies SPRG and snapshot inclusion.

  3. 3

    Test the complete rule

    Confirm code 181 versus 182. Apply July 1–June 30 boundaries. Do not use one multiyear open-ended record. Check the next-year segment for overlap or gaps.

  4. 4

    Choose the supported transaction

    End the supported segment within its academic year and create the appropriate next-year record when eligibility continues.

  5. 5

    Correct the source and resubmit

    Repair the authoritative record or extract mapping so the next submission will not recreate the discrepancy. Allow all dependent transactions to post in chronological order.

  6. 6

    Regenerate and reconcile

    Refresh the Fall 1 snapshot, confirm the error clears, and reconcile 1.0 Certification Errors; 5.1 Program Participants Count; 5.3 Program Participants Student List; applicable Fall 1 program report. Aggregate and student-level results must agree.

Official SPRG0645F1 guidance · Current certification and real-time reports · SDLA CALPADS report directory