SPRG - Student Programs

FRMT0001 Wrong Field Length

Field length does not match Calpads File Specifications

FRMT0002 Wrong Date Format

Date format does not match Calpads File Specifications

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

GERR0008 Invalid Transaction Type

The value provided for the field is not a valid CALPADS Transaction Type Code

IVR0069 Mismatch of SSID Demographics

Student Gender Code and Student Date of Birth Year must equal existing ODS Student Gender Code and Student Date of Birth Year in the latest SINF record

SPRG0001 Invalid Submitter

Reporting LEA must equal CDS code associated with submitter User ID

SPRG0002 Invalid Reporting School

The school code number must be a valid code in the CDS format and have an active CALPADS reporting relationship with the Reporting LEA.

SPRG0007 Invalid SSID

The student's 10-digit SSID number (State Student Identifier #), must be a valid SSID number in the CALPADS system. The SSID number submitted for one or more students was invalid.

SPRG0008 Retired SSID -- SSID Replaced With Current SSID. Update Local SIS

If SSID is retired and Student Gender Code and Student Date of Birth Year in file match Student Gender Code and Student Date of Birth Year of current SSID in ODS, then replace with current SSID for student

SPRG0009 Invalid Characters In Field

Field must only contain Alphabetic letters, numbers, periods, hyphens and apostrophes.

e.g. ABCDEFGHIJKLMNOPQRSTUVWXYZ123457890.-' 

SPRG0069 Mismatch Of SSID Demographics

Student Gender Code and Student Date of Birth Year must equal existing ODS Student Gender Code and Student Date of Birth Year in the latest SINF record

SPRG0070 Open Education Program Record Exists With Different Membership Start Date

Only one record for the same Education Program and school may be in the ODS with a null Membership End Date

SPRG0072 Retired SSID -- Mismatch Of SSID Demographics

If SSID is retired and Student Gender Code and Student Date of Birth Year in file do not match Student Gender Code and Student Date of Birth Year of current SSID in the latest SINF ODS record, then do not replace SSID.

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

SPRG0076 Education Program Membership Start Date Less Than Birth Date

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

SPRG0077 Education Program Membership Start Date Less Than Student School Start Date

If Education Program Membership Code equals 3 (Participating), then Education Program Membership Start Date must be greater than or equal to first Student School Start Date in CALPADS

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 (NCLB Title 1 Part A Basic Targeted), then Education Service Code must be populated

SPRG0082 Invalid Education Service Code

If Education Program Code = 122 (NCLB 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

SPRG0084 Missing Migrant Student ID

If Education Program Code = 135 (Migrant), then Migrant Student ID must be populated

SPRG0085 Missing Primary Disability Code

If Education Program Code = 144 (Special Education), then Primary Disability Code must be populated

SPRG0086 Invalid Education Program Code And Primary Disability Code Combination

If Primary Disability Code is populated, then Education Program Code must equal 144 (Special Education)

SPRG0087 Missing District of Special Education Accountability

If Education Program Code = 144 (Special Education), then District of Special Education Accountability must be populated

SPRG0088 Invalid Education Program Code And District Of Special Education Accountability Combination

If District of Special Education Accountability is populated, then Education Program Code must equal 144 (Special Education)

SPRG0148 Education Program Membership End Date Less Than Birth Date

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

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 (NCLB Title 1 Part A Basic Targeted), then Education Service Code must be null (empty or blank).

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)

SPRG0152 Invalid Education Program Code And Migrant Student ID Combination

If Migrant Student ID is populated then Education Program Code must equal 135 (Migrant)

SPRG0168 Missing Education Service Academic Year

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

SPRG0181 Delete Submitted For Non-Existing Record

The submitted record attempts to delete a record that does not exist in CALPADS.

SPRG0193 Invalid District of Special Education Accountability

District of Special Education Accountability must be a valid 7-digit County District (CD) code or a valid 7-digit Charter school code.

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

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

SPRG0247 NCLB Title I Targeted Records Submitted for a Title I Schoolwide School

Schools receiving NCLB Title I Schoolwide funding for the Reporting Academic Year should not submit NCLB Title I Targeted Program records for the Reporting Academic Year. Participation in NCLB Title I Schoolwide programs is derived from the school's cumulative primary enrollment count.

SPRG0249 Duplicate SPRG Record within File

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 (NCLB Title I Part A Basic Targeted)

SPRG0250 Duplicate SPRG Record Within File for NCLB Title I Part A Basic Targeted

If Education Program Code = 122 (NCLB Title I Part A Basic Targeted, only one record may exist in the file with the same SSID, School of Attendance, Education Program Code, Education Program Membership Start Date, Education Service Academic Year, and Education Service Code

SPRG0253 Invalid Migrant Student ID

The Migrant Student ID must be 11 characters with the first two characters beginning with "06"

SPRG0254 Invalid NSLP Program Record

The validation trigger for the SPRG0254 was updated to account for all scenarios where National School Lunch Program (NSLP) effective record dates overlap. CERT0254 may be triggered when users upload NSLP program data while a previous NSLP record is either still open or has an effective end date after the current program’s effective start date.

SPRG0264 Invalid Grade Level for Transitional Kindergarten Program Participant

If a student is a participant in the Transitional Kindergarten Program (185), then the student’s grade level must be = KN (Kindergarten)

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

SPRG0277 Missing Runaway Indicator

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

SPRG0278 Missing Unaccompanied Youth Indicator

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

SPRG0279 Invalid Unaccompanied Youth Indicator

If Education Program Code = 191 (Homeless) AND Runaway Indicator = "Yes"
Then Unaccompanied Youth Indicator must equal "Yes"

SPRG0288 Invalid Primary Disability Code and Student Age Combination

If Primary Disability Code is equal to 281 then Student age must be equal to or greater than 3 and less than 6

SPRG0295 Invalid Title I Part A Neglected Program Record

If a student is receiving Title I Part A Neglected Services, then the student must be in a non-Title I Part A school (targeted or schoolwide).

SPRG0533 Invalid NSLP Education Program Membership End Date

SPRG9999 Record(s) Will Pass This Validation Once All Other Fatal Errors Are Corrected For Student

Record(s) Will Pass this Validation Once All Other Fatal Errors Are Corrected For Student