Skip to main content

CALPADS error brief · SPRG

SPRG0270

Invalid Program Membership Start Date with R Transaction
Severity Fatal
Error type Input Validation
Record type SPRG

Official CALPADS rule

What CALPADS is rejecting

If Transaction type code = R Then submitted Program Membership Start Date must be within the current academic year.

Focus fields

Fields validated

3.02 - Transaction Type Code 3.15 - Education Program Membership Start Date

Recommended correction path

Suggested resolution

First decision: Is this eligibility or participation?

ELIGIBILITY

The student qualifies

  • Requires authoritative eligibility evidence.
  • Must overlap the applicable SENR enrollment.
  • An end date represents the end of eligibility or permitted reporting period.
  • Do not substitute a service date for an eligibility date.
PARTICIPATION

The student actually receives services

  • Requires evidence that participation or service occurred.
  • The entire membership period must remain within the school enrollment.
  • An end date represents the end of actual participation or service.
  • Eligibility alone does not prove participation.

Do not guess from the program name. Use the current CALPADS definition for the Education Program Code and the authoritative local evidence before selecting or changing the Membership Code.

Official CALPADS rule

Submission: SPRG   Status: Active   Severity: Fatal   Type: Input Validation

If Transaction type code = R Then submitted Program Membership Start Date must be within the current academic year.

  • 3.02 - Transaction Type Code
  • 3.15 - Education Program Membership Start Date

How this record moves through CALPADS

1. Program evidenceEstablish qualification or actual service.
2. SENR and SINFEstablish student, school, enrollment, and demographics.
3. SPRG postsReport program, classification, and membership dates.
4. Reports interpretFall 1, EOY, LCFF, accountability, and benefits use the history.

Upload reminder: A file may upload while individual records reject. Correct the program system, SIS, or extract when the next submission would recreate the error.

Choose the diagnostic pathway

  • Eligibility or participation and enrollment alignment
    • What does the current Education Program Code require?
    • Does the record document qualification or actual service?
    • For eligibility, does the record overlap the school enrollment?
    • For participation, are the entire membership dates inside the enrollment?
    • Would changing the membership code misstate what occurred?
  • Student, SSID, and school ownership
    • Is this the intended student and current SSID?
    • Which SENR enrollment establishes the school context?
    • Does the Reporting LEA have authority to submit the record?
    • Did a within-district transfer require a new school-level SPRG record?
  • Program selection and current reporting process
    • Is the Education Program Code correct for the evidence?
    • Is the code active for the membership date?
    • Is the program still submitted through SPRG?
    • Could the status now come through MSIN or another statewide match?
  • Membership dates and program lifecycle
    • What event establishes the start date?
    • Does the end date represent the end of eligibility or actual participation?
    • Does the record overlap another record for the same program?
    • Does the program require annual redetermination?
  • Homeless identification and required details
    • Does current authorized evidence identify the student as experiencing homelessness?
    • What dwelling situation applies at identification?
    • Is the student an unaccompanied youth?
    • Were the record and questionnaire reviewed for the current year?
    • Did a school transfer change school attribution?
  • FRPM, income eligibility, and statewide matches
    • Was current eligibility actually determined?
    • Is the record based on an application, approved form, CEP or Provision process, or another authorized source?
    • Is direct certification being confused with an LEA-created SPRG record?
    • Are dates valid for LCFF and benefit reporting?
  • Program-specific supplemental fields
    • Does the program require an Academy ID, Education Service Code, academic year, Dwelling Type, or Unaccompanied Youth value?
    • Is the supplemental value valid for this program?
    • Did the extract populate a field that must be blank for other programs?
  • SIS, program system, extract, and CALPADS history
    • What does the authoritative program office or benefits system contain?
    • What does the SIS contain?
    • Did the extract transform, omit, or default a value?
    • What program history is already in CALPADS?
    • Will the next extract reproduce the error?

Read the program-record sequence

  1. EvidenceConfirm qualification or delivered service.
  2. ClassificationChoose eligibility or participation.
  3. Enrollment ruleApply the correct overlap requirement.
  4. SPRG datesMaintain accurate membership history.
  5. VerificationReview CALPADS and downstream reports.

Primary participants for this error

  • CALPADS coordinator
  • Registrar or enrollment staff
  • Program coordinator
  • District student-services administrator
  • SIS system owner
  • Extract, integration, or vendor support

Compare four versions of the record

  • Authoritative program evidence.
  • Program office or benefits system.
  • SIS and generated SPRG extract.
  • CALPADS program and enrollment history.

Correct the first point where these versions diverge.

Recommended correction path

  1. Identify the student, school, and program

    Match SSID, Reporting LEA, School of Attendance, Education Program Code, Membership Code, and membership dates.

  2. Classify the record before changing dates

    Determine from the current program definition whether the record reports eligibility or participation.

  3. Apply the correct enrollment rule

    Eligibility must overlap the applicable school enrollment. Participation membership dates must remain within the enrollment period.

  4. Reconstruct the actual program history

    Use authoritative eligibility evidence or service records, along with SENR and existing CALPADS SPRG history.

  5. Correct the first inaccurate system

    Repair the program system, SIS, membership classification, dates, school association, or extract transformation that caused the divergence.

  6. Verify the corrected meaning

    Confirm acceptance and review school attribution, program history, Fall 1, EOY, LCFF, accountability, and benefit effects as applicable.

Official CALPADS guidance

Understanding the Error. Records that are submitted with an R transaction type code must have a program start date that is within the current academic year.

Things to check for: Verify that the Education Program Membership Start Date in the submitted file are in the current academic year.

Suggested Resolution:
If the Education Program Membership Start Date in the submitted file are correct, replace the ODS record by submitting a record with a transaction type of "R" and a record with a transaction type of Add in the same file.

Before closing the issue

  • Confirm SPRG0270 no longer appears for the intended program record.
  • Verify the Membership Code and dates accurately describe eligibility or participation.
  • Confirm school attribution and the qualifying enrollment.
  • Document source evidence, responsible program owner, correction location, and extract behavior.
  • Review Fall 1, EOY, LCFF, accountability, subgroup, and benefit effects as applicable.

Official references

What SPRG maintains—and does not establish

What SPRG maintains

  • Reporting LEA
  • School of Attendance
  • Student and SSID
  • Education Program Code
  • Education Program Membership Code
  • Education Program Membership Start Date
  • Education Program Membership End Date
  • Program-specific supplemental information
  • School-level program ownership
  • Historical eligibility and participation records

Questions SPRG should answer

  • Does this program report eligibility or participation?
  • What authoritative evidence supports the record?
  • Which LEA and school own the record?
  • When did eligibility or participation actually begin?
  • Has eligibility or participation ended?
  • Does the membership period align with a qualifying enrollment?
  • Did a school transfer require a new program record?
  • Is annual redetermination required?
  • Are program-specific supplemental fields required?
  • Is the LEA still responsible for submitting this status, or is it now supplied through a statewide match?

SPRG does not replace these records or processes

  • SENRSSID, enrollment, school, and ownership
  • SINFDemographics and address
  • SELAEnglish Language Acquisition Status
  • SSRVStudent services
  • SWDS, PLAN, MEET, and SERVSpecial education records
  • State matchesFoster, direct-certification, and current migrant status where applicable

Review official CALPADS SPRG guidance

SPRG participant directory

Engage only the roles needed for the program, evidence, membership classification, school, dates, or system issue.

  • CALPADS coordinator
  • Registrar or enrollment staff
  • School-site office staff
  • District student-services administrator
  • Program coordinator
  • Homeless liaison
  • Foster youth liaison
  • Migrant education or MSIN contact
  • English learner program staff
  • Nutrition services or benefits staff
  • LCFF or accountability staff
  • Title I coordinator
  • Gifted and Talented program staff
  • California Partnership Academy staff
  • Counselor or student-support staff
  • SIS system owner
  • Extract, integration, or vendor support