Skip to main content

CALPADS error brief · SPRG

SPRG0249F1

Duplicate SPRG Record within File
Severity Fatal
Error type CDD
Record type SPRG

Official CALPADS rule

What CALPADS is rejecting

Only one record may exist in the file with the same SSID, School of Attendance, Education Program Code, and Education Program Membership Start Date unless Education Program Code = 122 (Title I Part A Basic Targeted)

Focus fields

Fields validated

3.07 - SSID 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.05 School of Attendance
  • 3.07 SSID
  • 3.13 Program Code
  • 3.15 Membership Start 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 operational program key per student/school/program/start-date relationship.Census-day snapshot logic
What is inconsistent?Duplicate keys exist in the batch/ODS or emerged after an MID merge.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?Remove a true duplicate, or submit the proper change/replacement transaction when modifying an existing membership.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

  • Compare the complete operational key.
  • Inspect ODS as well as the current file.
  • Review recent MID merges.
  • Preserve distinct memberships that genuinely have different supported keys.

Recommended correction path

  1. 1

    Identify the exact snapshot row

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

  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

    Compare the complete operational key. Inspect ODS as well as the current file. Review recent MID merges. Preserve distinct memberships that genuinely have different supported keys.

  4. 4

    Choose the supported transaction

    Remove a true duplicate, or submit the proper change/replacement transaction when modifying an existing membership.

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