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
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
