Skip to main content

CALPADS error brief · SPRG

SPRG0250F1

Duplicate SPRG Record within File for Title I Part A Basic Targeted
Severity Fatal
Error type CDD
Record type SPRG

Official CALPADS rule

What CALPADS is rejecting

If Education Program Code = 122 (Title I Part A Basic Targeted, only one record may exist in the file with the same SSID, School of Attendance, Education Program Code, Education Program Membership Start Date, Education Service Academic Year, and Education Service Code

Focus fields

Fields validated

3.07 - SSID 3.05 - School of Attendance 3.13 - Education Program Code 3.15 - Education Program Membership Start Date 3.17 - Education Service Academic Year 3.18 - Education Service Code

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.05 School
  • 3.07 SSID
  • 3.13 Program Code 122
  • 3.15 Membership Start
  • 3.17 Service Academic Year
  • 3.18 Service Code

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?Each distinct Title I targeted service relationship has one supported operational key.Census-day snapshot logic
What is inconsistent?Two records repeat the same student, school, code 122, start date, service year, and service code.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?Delete a true duplicate or use the proper change transaction for an intended update.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 122 and service code.
  • Compare service academic year.
  • Inspect ODS and current file.
  • Review whether an MID merge created the duplicate.

Recommended correction path

  1. 1

    Identify the exact snapshot row

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

  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 122 and service code. Compare service academic year. Inspect ODS and current file. Review whether an MID merge created the duplicate.

  4. 4

    Choose the supported transaction

    Delete a true duplicate or use the proper change transaction for an intended update.

  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 SPRG0250F1 guidance · Current certification and real-time reports · SDLA CALPADS report directory