SPRG - Student Programs

SPRG errors involve a student’s participation in programs such as special education, homeless services, foster youth programs, Title I, or other reportable services. Validations may examine program codes, membership dates, eligibility, and school relationships. Review the full participation history and correct overlapping, missing, or inconsistent program records.

FRMT0001 Wrong field length

Field length does not match CALPADS File Specifications (CFS)

FRMT0002 Wrong date format

Date format does not match CALPADS File Specifications (CFS)

FRMT0009 Invalid column count for file type

Format for invalid column (fields) count based on file type

GERR0001 Required Field Missing

A required field for the submitted Records Type is missing

GERR0002 Value Not Found in Reference Set

The value provided for the field is not a valid value from the CALPADS Code Sets

GERR0005 LEA does not have ownership of student enrollment to make the update

As a Participating record , the Education Program Membership Start Date and Education Program Membership End Date must be within the Enrollment Start Date and Enrollment Exit date (inclusive) of a SENR record, at the School of Attendance As an Eligible record, the SPRG record must overlap a SENR record at the at the School of Attendance. And if the Eligible record is being exited, it must be on or prior to the SENR Exit Date.

GERR0007 Code submitted outside the effective date range

Code submitted outside the effective date range

IVR0001 Invalid Submitter

Reporting LEA must equal CDS code associated with submitter User ID

IVR0002 Invalid Reporting School

School must be a valid code in CDS and have an active CALPADS reporting relationship with the Reporting LEA

IVR0007 Invalid SSID

SSID must be a valid CALPADS SSID in the ODS

IVR0116 Duplicates within File based on Primary Key

Two or more records exist with the same primary key fields.

SPRG0070 Overlapping Program Records

SSID has an existing/matching overlapping Education Program record existing in Staging or ODS

SPRG0075 Education Program Membership End Date Less Than Education Program Membership Start Date

Education Program Membership End Date must be greater than or equal to Education Program Membership Start Date

SPRG0078 Education Program Membership Start Date Greater Than Current Date plus six months

If Education Program Membership Code equals 3 (Participating) Then Education Program Membership Start Date must be less than or equal to current date plus six months

SPRG0081 Missing Education Service Code

If Education Program Code = 122 (Title 1 Part A Basic Targeted) Then Education Service Code must be populated.

SPRG0082 Invalid Education Service Code

If Education Program Code = 122 (Title 1 Part A Basic Targeted) Then Education Service Code must = 5, 6, 7, 8, 9, 10, 11, 12, or 13

SPRG0083 Missing California Partnership Academy ID

If Education Program Code = 113 (California Partnership Academy) Then California Partnership Academy ID must be populated

SPRG0149 Invalid California Partnership Academy ID

Invalid California Partnership Academy ID

SPRG0150 Invalid Education Program Code and Education Service Code combination

If Education Program Code not equal to 122 (Title 1 Part A Basic Targeted) Then Education Service Code must be null

SPRG0151 Invalid Education Program Code and California Partnership Academy ID combination

If California Partnership Academy ID is populated Then Education Program Code must equal 113 (California Partnership Academy)

SPRG0168 Missing Education Service Academic Year

If Education Program Code = 122 (Title 1 Part A Basic Targeted) Then Education Service Academic Year must be populated

SPRG0217 User not authorized to submit Free or Reduced Meal program data

User must have Free and Reduced Price Meal EDIT role to post Free or Reduced Price Meal Program records: Education Program Codes 181 (Free Meal Program), and 182 (Reduced-Priced Meal Program

SPRG0254 Invalid NSLP Program Record

Student must only have one open National School Lunch Program record

SPRG0270 Invalid Program Membership Start Date with R Transaction

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

SPRG0276 Missing Dwelling Type Code

If Education Program Code = 191 (Homeless) Then Dwelling Type Code must be populated

SPRG0278 Missing Unaccompanied Youth Indicator

If Education Program Code = 191 (Homeless) then Unaccompanied Youth Indicator is required

SPRG0533 Invalid NSLP Education Program Membership End Date

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

SPRG0746 Invalid Homeless Education Program Membership End Date for historical SPRG update

Historical homeless records submitted for Academic Years 2025-26 and later must have an Education Program Membership End Date within the same academic year as the start date.

SPRG0747 Invalid Homeless Education Program Membership End Date for historical SPRG update

Historical homeless records submitted for Academic Years 2024-25 and earlier must have an Education Program Membership End Date on or before June 30, 2025.