Skip to main content

CALPADS error brief · SPRG

SPRG0148F1

Education Program Membership End Date Less Than Birth Date
Severity Fatal
Error type CDD
Record type SPRG

Official CALPADS rule

What CALPADS is rejecting

Education Program Membership End Date must be greater than Student Birth Date

Focus fields

Fields validated

2.18 - Student Birth Date 3.16 - Education Program Membership End 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

  • 2.18 Student Birth Date
  • 3.16 Program 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?The end date follows birth and is also coherent with the program start date.Census-day snapshot logic
What is inconsistent?Birth date or program end date is wrong, or the wrong date column/value was exported.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?Correct the documented SINF birth date or SPRG end date.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 birth, program start, and program end together.
  • Inspect century/year and column mapping.
  • Do not remove a correct end date merely to avoid the error.
  • Confirm the effective program record belongs to the student.

Recommended correction path

  1. 1

    Identify the exact snapshot row

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

  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 birth, program start, and program end together. Inspect century/year and column mapping. Do not remove a correct end date merely to avoid the error. Confirm the effective program record belongs to the student.

  4. 4

    Choose the supported transaction

    Correct the documented SINF birth date or SPRG end date.

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