Join
Tagged with: Fall 1
CERT004
A student has no Ethnicity/Race data.
CERT005
There is a record in the SCSE file that contains information for a student who was not enrolled on Census Day.
CERT006
Significant Change In Total Enrollment
CERT007
Significant Change In Enrollment In A Grade
CERT008
Significant Change In Enrollment In An Ethnicity / Race Category
CERT009
A school's total Special Education program participants has either increased or decreased significantly from the previous year's count.
CERT010
The proportion of a school's enrollment participating in Special Education is greater than 25%.
CERT012
No Total Special Education Program Participants were submitted for this school.
CERT013
Significant Change In The LEA's Number Of Special Education Program Participants
CERT014
The number of 12th grade graduates for the current year is 20% larger than the number of 12th graders in the previous year for a specific gender and ethnicity/race combination.
CERT015
This school had enrollment in Grade 12 in the previous year, but there are no graduates reported this year.
CERT016
The percentage of graduates from this school has either increased or decreased by 25 or more percentage points from the previous year's percentage.
CERT017
Significant Change In Percent Of Graduates Completing UC/CSU Requirements
CERT018
No dropouts reported for a school that reported dropouts in the previous year and that has current year enrollment >= 100 in grades 9-12 and US.
CERT019
Dropouts are reported for grades 9-12 and Ungraded Secondary, but this school had no enrollment in grades 9-12 and Ungraded Secondary in the previous year.
CERT020
The school's number of dropouts either increased or decreased significantly from the previous year.
CERT021
The school's Dropout Rate either increased or decreased significantly from the previous year. Dropout rate includes grades 7-12 and Ungraded Secondary.
CERT023
The number of Limited English Proficient students either increased or decreased significantly between the previous and current year for a school.
CERT024
The difference between the Limited English Proficiency (LEP) count for the current year and the previous year for a school is more than 25 and there is at least a 25% difference between the counts for the two years.
CERT027
No Total Free or Reduced Price Meal Program Eligibility was submitted for a school that submitted eligible students in the previous year.
CERT028
No Free or Reduced Price Meal Program Eligible students were submitted for this school.
CERT029
Significant Change In The School's Number Of Free Or Reduced Price Meal Program Eligible Students
CERT030
Significant Change In The LEA's Number Of Free Or Reduced Price Meal Program Eligible Students
CERT031
Significant Change In LEA's Number Of GATE Students
CERT032
Significant Change In School's Number Of GATE Students
CERT033
No Gifted and Talented Education Program (GATE) eligible students were submitted for a school that submitted eligible students in the previous year.
CERT040
The total number of SSID anomalies in the Snapshot is equal to or greater than 2% of Snapshot enrollment.
CERT041
All intra-LEA CCEs must be resolved before certifying.
CERT042
No Total Title III Eligible Immigrants were submitted for a school that submitted Immigrants in the previous year.
CERT043
No Total Title III Eligible Immigrants were submitted for this school.
CERT044
Significant Change In The School's Number Of Title III Eligible ImmigrantCERT045
Significant Change In The LEA's Number Of Title III Eligible ImmigrantsCERT056
Student was reported as graduating with a Special Education Certificate of Completion and the student is not in Special Education Program.
CERT057
No Special Education Program Participants were submitted for a school that submitted Participants in the previous year.
CERT058
No Total Title I Part C Migrant Education Program Participants were submitted for a school that submitted Participants in the previous year.
CERT059
Significant Change In The School's Number Of Title I Part C Migrant Education Program Participants
CERT060
Significant Change In The LEA's Number Of Title I Part C Migrant Education Program Participants
CERT067
Census Day has no SELA record for a school that has at least one English Learner student.CERT089
Existing prior student enrollment records exited with the Student School Exit Category E490 where there is no subsequent current reporting year student enrollment record within the same LEA
CERT106
If a student with a Primary enrollment has an English Language Acquisition Code = "TBD" and the Student Grade Level Code is not equal to "AD", "IN", "TD", or "PS", then the English Language Acquisition Status Start Date must be less than 90 days before the Census Date of the Report Period.CERT110
The Education Program Membership Start and End Date range for Title I Part C Migrant Program (135) record is outside of the maximum eligibility period of 3 years for this program. Eligibility must be renewed every 3 years.
CERT111
No Homeless Program eligible students were submitted for an LEA.
CERT112
A student that was enrolled any time between July 1 and June 30 of the previous Academic Year and has not been exited prior to August 16 of the Active Academic Year.CERT113
If Student Grade Level Code = KN, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, UE, or US, and English Language Acquisition Status = EL (English Learner), Then Student Initial US School Enrollment Date must be populated.
CERT114
If the most recent enrollment contains Exit Code E150, then a subsequent Enrollment record is required.CERT119
Student will not be 5 in kindergarten year and is not enrolled in TK programFRMT0001
Field length does not match Calpads File Specifications
FRMT0001
Field length does not match Calpads File Specifications
FRMT0001
Field length does not match CALPADS File Specifications (CFS)
FRMT0002
Date format does not match Calpads File Specifications.
One or more of the fields in the file are not in the required date format (MM/DD/YYYY). One or more of the fields in the file are not in the required date format (MM/DD/YYYY).
January 5th, 2006, for example, should be entered as 01/05/2006
FRMT0002
Date format does not match Calpads File Specifications
FRMT0002
Date format does not match CALPADS File Specifications.
FRMT0004
Data must follow rules for the field type specified in the CALPADS File Specifications (CFS)
GERR0001
A required field for the submitted Records Type is missing.
GERR0001
A required field for the submitted Records Type is missing
GERR0001
A required field for the submitted Records Type is missing.
GERR0002
The value provided for the field is not a valid value from the CALPADS Code Sets.
GERR0002
The value provided for the field is not a valid value from the CALPADS Code Sets
GERR0002
The value provided for the field is not a valid value from the CALPADS Code Sets
GERR0005
For a submitted SINF record, the provided Effective Start - End date range does not fall within the submitting LEA's (Local Educational Agency) ownership period of the student.
GERR0007
Code submitted outside the effective date range
GERR0007
Code submitted outside the effective date range
GERR0008
The value provided for the field is not a valid CALPADS Transaction Type Code
GERR0008
The value provided for the field is not a valid CALPADS Transaction Type Code
GERR0008
The value provided for the field is not a valid CALPADS Transaction Type Code
IVR0001
Reporting LEA must equal CDS code associated with submitter User ID
IVR0002
School must be a valid code in CDS and have an active CALPADS reporting relationship with the Reporting LEA
IVR0006
Academic Year ID must be a valid academic school year combination and no more than one year in the future
IVR0007
SSID must be a valid CALPADS SSID in the ODS
IVR0008
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
IVR0009
Field must only contain Alphabetic letters, numbers, periods, hyphens and apostrophes.
These letters and characters are valid:
a b c d e f g h i j k l m n o p q r s t y v w x y z
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
1 2 3 4 5 7 8 9 0 . - '
Any other ascii code characters will be rejected. Check for hidden characters.
IVR0010
If a student's Alias Last Name is populated, then the student's Alias First Name must ALSO be populated.
IVR0011
If Student Alias First Name is populated, then Student Alias Last Name must be populated
IVR0012
If Grade Level Code is equal to Adult (AD), then Student age must be greater than or equal to 16 and less than 80; Else Student Age must be greater than 0 and less than or equal to 22
IVR0013
Student School Start Date must be greater than Student Birth Date.
IVR0033
If Student Information, then Record Type Code must equal SINF, SIGR, SIDM, SIEL, SIST, SIAD
IVR0045
If Student Hispanic Ethnicity Indicator is populated, then Student Ethnicity Missing Indicator must be equal to N or blank; ELSE, Student Ethnicity Missing Indicator must equal Y AND Student Hispanic Ethnicity Indicator must be NULL
IVR0046
If one or more of the Student Race Codes are populated, then Student Race Missing Indicator must be equal to N or blank; ELSE, Student Race Missing Indicator must be equal to Y AND all Student Race Code values must be NULL.
IVR0048
If Interdistrict Transfer Code is populated, then District of Geographic Residence must be populated
IVR0049
If Primary Residence Category Code not equal to 100, 110, 120, 130, OR 310, then Residential Address Line 1 must be populated
IVR0051
If Primary Residence Category Code not equal to 100, 110, 120, 130, OR 310, then Residential Address City Name must be populated.
IVR0052
If Primary Residence Category Code not equal to 100, 110, 120, 130, OR 310, then Residential Address State Province Code must be populated
IVR0053
If Primary Residence Category Code not equal to 100, 110, 120, 130, OR 310, then Residential Address Zip Code must be populated
IVR0054
English Language Acquisition Status Start Date must be greater than Student Birth Date
IVR0055
English Language Acquisition Status Start Date must be less than or equal to current date plus 30 days
IVR0056
If English Language Acquisition Status Code = RFEP (Reclassified Fluent English Proficient), then Student Proficient or Advanced for ELA Code must be populated
IVR0058
If 1) Student Grade Level Code = KN, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, UE, US
AND
2) a) Student Birth Country Code not equal to US or PR OR b) English Language Acquisition Status = EL, then Student Initial US School Enrollment Date must be populated.
IVR0059
Student Initial US School Enrollment Date must be greater than Student Birth Date
IVR0060
Student Initial US School Enrollment Date must be less than or equal to current date plus six months
IVR0061
If Student Birth Country Code Not Equal To US or Puerto Rico, then Enrolled in US School less than Three Cumulative Years Indicator must be populated
IVR0062
If CTE Pathway Completer Indicator is populated, then CTE Pathway Code must be populated
IVR0064
Effective Start Date must be within Academic Year specified
IVR0066
Effective End Date must be greater than or equal to Effective Start Date
IVR0067
Effective End Date must be within Academic Year specified
IVR0068
Student Gender Code and Student Date of Birth Year must equal existing ODS Student Gender Code and Student Date of Birth Year Or Student Legal First Name and Student Legal Last Name must equal existing ODS Student Legal First Name and Student Legal Last Name in the latest SINF record
IVR0072
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 ODS, then do not replace SSID's Student Information
IVR0116
Only one record may exist in the file with the same Effective Start Date
IVR0144
If Student Hispanic Ethnicity Indicator is populated, then Student Ethnicity Missing Indicator must be equal to N or blank
IVR0145
If Student Ethnicity Missing Indicator is equal to Y, then Student Hispanic Ethnicity Indicator must be blank
IVR0146
If Student Race Missing Indicator is equal to Y, then all of the Student Race Codes must be blank
IVR0164
If English Language Acquisition Status Code not equal to EO, then English Language Acquisition Status Start Date must be populated
IVR0165
If Student's Grade Level Code not = to AD, then English Language Acquisition Status Code must be populated
IVR0180
The submitted records attempt to delete the Last Demo Record for a student in CALPADS
IVR0213
English Language Acquisition Status Start Date should be less than or equal to SINF Effective Start Date
IVR0214
English Language Acquisition Status Code of existing record should equal the English Language Acquisition Status Code of input record when the Effective Start Date is the same
IVR0215
English Language Acquisition Status Start Date must be less than or equal to current date
IVR0216
English Language Acquisition Status Code equal to EL, RFEP, or IFEP must have a Primary Language Code other than English (00) or Sign Language (37).
SELA0001
Reporting LEA must equal CDS code associated with submitter User ID.
SELA0002
School must be a valid code in CDS and have an active CALPADS reporting relationship with the Reporting LEA.
SELA0006
Academic Year ID must be a valid academic school year combination and no more than one year in the future
SELA0007
SSID must be a valid CALPADS SSID in the ODS
SELA0008
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
SELA0009
Field must only contain Alphabetic letters, numbers, periods, hyphens and apostrophes.
These letters and characters are valid:
a b c d e f g h i j k l m n o p q r s t y v w x y z
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
1 2 3 4 5 7 8 9 0 . - '
Any other ascii code characters will be rejected. Check for hidden characters.
SELA0033
If Student English Language Acquisition, then Record Type Code must equal SELA
SELA0054
English Language Acquisition Status Start Date must be greater than Student Birth Date
SELA0072
If SSID is retired and Student Gender Code and Student Date of Birth Year in file do not match the Student Gender Code and the Student Date of Birth Year of current SSID in the latest SELA ODS record, then do not replace SSID
SELA0164
If English Language Acquisition Status Code is not NULL, then English Language Acquisition Status Start Date must be populated
SELA0181
The submitted record attempts to delete a record that does not exist in CALPADS
SELA0215
English Language Acquisition Status Start Date must be less than or equal to current date
SELA0255
If a student's English Language Acquisition Status (ELAS) Code is being submitted--- then the most recent ELAS Code currently stored in the CALPADS ODS must be a valid ELAS in combination with the subsequent ELAS being submitted. Reference (Valid Code Combos--- Current ELAS-Submtd ELAS)
SELA0266
If no English Language Acquisition Status (ELAS) Code exists in the ODS for a student--- then the ELAS code being submitted must equal TBD--- EO--- IFEP--- or EL.
SELA0280
Student Primary Language Code cannot equal English (00) or American Sign Language (37) when English Language Acquisition Status Code is not EO
SELA0281
There is already an ELAS status in the CALPADS ODS; therefore the TBD status is not allowed.
SELA0283
If the English Language Acquisition Status (ELAS) code being submitted does not match any ELAS code in CALPADS, then the ELAS Start Date being submitted must be greater than the most recent ELAS Start Date in CALPADS. (In other words, you are trying to create a new ELAS record that PRE-DATES one or more records in CALPADS for the same language designation. Shame on you! :)
SELA0285
If ELAS code being submitted does not equal any ELAS code in ODS--- then ELAS Start Date being submitted must be greater than the most recent ELAS Start Date in the ODS.
SENR0001
Reporting LEA must equal CDS code associated with submitter User ID
SENR0002
School must be a valid code in CDS and have an active CALPADS reporting relationship with the Reporting LEA.
SENR0003
If School of Attendance NPS is populated Then School of Attendance must equal 0000001
SENR0004
If School of Attendance = 0000001 Then School of Attendance NPS must be populated
SENR0005
School of Attendance NPS must be a valid NPS code in CDS
SENR0006
Academic Year ID must be a valid academic school year combination and no more than one year in the future
SENR0007
SSID must be a valid CALPADS SSID in the ODS
SENR0008
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
SENR0009
Field must only contain Alphabetic letters, numbers, periods, hyphens and apostrophes.
These letters and characters are valid:
a b c d e f g h i j k l m n o p q r s t y v w x y z
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
1 2 3 4 5 7 8 9 0 . - '
Any other ascii code characters will be rejected. Check for hidden characters.
SENR0010
If Student Alias Last Name is populated Then Student Alias First Name must be populated
SENR0011
If Student Alias First Name is populated Then Student Alias Last Name must be populated
SENR0012
If the Grade Level Code is equal to Adult (AD) Then Student age must be greater than or equal to 16 and less than 80; otherwise the Student Age must be greater than 0 and less than or equal to 22.
SENR0013
Student School Start Date must be greater than Student Birth Date
SENR0014
Student School Start Date must be less than or equal to current date plus six months
SENR0015
If Student Exit Reason Code is populated then Student School Exit Date must be populated
SENR0018
Student School Exit Date must be greater than or equal to Student School Start Date unless the Student Exit Reason Code = N470 (NoShowOther), in which case the date must be on or one day prior to the Start Date.
SENR0019
Student School Exit Date must be less than or equal to current date plus 30 days
SENR0020
If Student School Exit Date is populated then Student Exit Reason Code must be populated
SENR0021
A student may only have one enrollment record with Student School Completion Status Code equal to 100 within the Reporting LEA
SENR0022
Student Exit Reason Code and Student School Completion Status Code must be a valid combination
SENR0023
Student Exit Reason Code and Grade Level Code combination must be a valid combination
SENR0024
Submitted record has School Start Date which is AFTER the School Exit Date of a graduated record within the LEA for this SSID. A Graduated record is: Student Exit Reason Code = E230 AND School Completion Status = 100, 106 OR 250
SENR0025
Submitted record has School Start Date which is AFTER the School Exit Date of a graduated record within CALPADS for this SSID. A Graduated record is: Student Exit Reason Code = E230 AND School Completion Status = 100, 106 OR 250
SENR0026
If Student Exit Category equals E230 and School Completion Status Code equals 330 (Passed CHSPE) then Student Age must be greater than or equal to 16 at Student School Exit Date, or Grade must be greater than 9.
Btw, the CHSPE stands for California High School Proficiency Examination.
SENR0028
A student's primary enrollment submission overlaps an existing primary enrollment for the same student in another LEA. This submission will create a concurrent enrollment anomaly or CCE.
Primary Enrollments are defined as:
- Enrollment Status = “10” (Primary);
- Enrollment Status = “30” (Short Term), and the enrollment period exceeds 30 days;\
Note: Enrollments with a N470 (NoShowOther) exit and a Enrollment Exit Date equal to or one day prior to the Enrollment Start Date are NOT considered Primary Enrollments."
SENR0029
If Student Exit Reason Code = E230 (CompleterExit) then Student School Completion Status Code must be populated
SENR0030
If Student Exit Reason Code = T165 (TransEnrollDiscip) Or If School Type of element 1.05 (as indicated in the CDE County District School database) is an Alternative School And Student Exit Reason Code = T160 is an Alternative School Then Expected Receiver School of Attendance must be populated
SENR0031
If Student School Completion Status Code = 100, 106 or 108 (Graduated) Then Student Met all UC CSU Requirements Indicator must be populated
SENR0032
If Transaction Type Code = D or Transaction Type Code = R Then SSID must be populated
SENR0033
If SSID Enrollment then Record Type Code must equal SENR
SENR0034
Only one record may exist in the file with the same SSID, School of Attendance, and Student School Start Date
SENR0035
If SSID is populated and Reporting LEAs owns the student (Enrollment Update) then Student Gender Code and Student Date of Birth Year must equal existing ODS Student Gender Code and Student Date of Birth Year
SENR0036
Student Birth Country Code and Student Birth State Province Code must be a valid combination.
This can happen when you mistakingly enter a Canadian Province in the state field when you meant to indicate a US state.
CALPADS gives special attention to the code-sets for three countries.
So if you are using a country code for United States of "US", and the student was born in California, the State Province code would be "US-CA" and NOT just "CA"
SENR0037
A student's primary enrollment submission cannot have the same Enrollment Start Date for the same student in another LEA.
Primary Enrollments are defined as:
- Enrollment Status = “10” (Primary);
- Enrollment Status = “30” (Short Term), and the enrollment period exceeds 30 days; Note: Enrollments with a N470 (NoShowOther) exit and a Enrollment Exit Date equal to or one day prior to the Enrollment Start Date are NOT considered Primary Enrollments.
SENR0045
LEA must be a valid code in CDS and have an active CALPADS reporting relationship with the Reporting LEA
SENR0069
Student Gender Code and Student Date of Birth Year must equal existing ODS Student Gender Code and Student Date of Birth Year in latest Student Information record
SENR0072
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 ODS, then do not replace SSID
SENR0167
Invalid Start Date for Record with R Transaction Type Code
SENR0171
If SSID is blank, then Grade Level Code must be populated
SENR0175
If Student School Completion Status = 100 (Graduated), then Student Exit Reason Code must = E230 (Completer Exit)
SENR0178
The student has an overlapping enrollment (closed or open) for the same LEA and school
SENR0180
The submitted record attempts to delete the Last Enrollment Record for a student in CALPADS
SENR0181
The submitted record attempts to delete a record that does not exist in CALPADS
SENR0182
The Enrollment School Start Date is before the School Open Date
SENR0184
The Enrollment Start Date is after the School Closed Date
SENR0185
Open short term enrollment submitted without an existing open primary enrollment or the short term enrollment School Start Date is before the primary enrollment School Start Date
Primary Enrollments are defined as: - Enrollment Status = “10” (Primary); - Enrollment Status = “30” (Short Term), and the enrollment period exceeds 30 days; Note: Enrollments with a N470 (NoShowOther) exit and a Enrollment Exit Date equal to or one day prior to the Enrollment Start Date are NOT considered Primary Enrollments."
SENR0187
Short term enrollment period must be 30 days or less Primary Enrollments are defined as: - Enrollment Status = “10” (Primary); - Enrollment Status = “30” (Short Term), and the enrollment period exceeds 30 days; Note: Enrollments with a N470 (NoShowOther) exit and a Enrollment Exit Date equal to or one day prior to the Enrollment Start Date are NOT considered Primary Enrollments.
SENR0188
The batch SENR or online submission contains a short-term enrollment record. This submitted enrollment record starts on the SAME date as an existing primary enrollment record in CALPADS ODS for another LEA. Things to check for in submisson: Verify the following fields contained in the submissions against CALPADS Enrollment History of the student:
1.23 - Student School Start Date
1.24 - Enrollment Status Code
1.26 - Student School Exit Date
SENR0189
Only Educational Options schools may submit short term enrollments
Primary Enrollments are defined as:
- Enrollment Status = “10” (Primary);
- Enrollment Status = “30” (Short Term), and the enrollment period exceeds 30 days;
Note: Enrollments with a N470 (NoShowOther) exit and a Student School Exit Date equal to or one day prior to the Student School Start Date are NOT considered Primary Enrollments.
SENR0192
District of Geographic Residence must be populated with a valid 7-digit County District (CD) code representing an active, open district that is not a charter school or county office of education in the academic year specified.
SENR0193
Receiving Specialized Services Only enrollment overlaps an existing Primary Enrollment
SENR0202
School of Attendance must not equal a 7-digit County District (CD) code. Note: This validation does not apply to independently reporting charters.
SENR0203
Invalid Student School Exit Date for Student School Completion Status Code 108 (CAHSEE Exemption): Student School Exit Date must not be in academic year 2007-08 or 2008-09
SENR0204
If Student Exit Reason Code = N420, then Student School Exit Date must be between May 15 and August 15 (inclusive)
SENR0225
If Student Exit Category equals E230 and School Completion Status Code equals 250 or 320; or if Student Exit Category equals T260 or T270; then Student Age must be greater than or equal to 18
SENR0226
Only one record may exist in the file with the same Local ID when the SSID is blank.
SENR0248
If one or more candidates have a score of 100 and user selects New SSID, warn user that a duplicate ID may be created.
SENR0265
If Student Exit Category equals E230 and School Completion Status Code equals 320; then Student Age must be greater than or equal to 16 on the Exit DateSENR0302
If student has a Secondary Enrollment Status Code (20), Student Exit Reason must be null or = E170 (Secondary Enrollment Exit)SENR0317
A student that was enrolled any time between July 1 and June 30 of any previous Academic Year and has not been exited prior to August 16 of the subsequent Academic Year.SENR9999
Record(s) will pass this validation once all other fatal errors are corrected for student
SINF0001
Reporting LEA must equal CDS code associated with submitter User ID
SINF0002
School must be a valid code in CDS and have an active CALPADS reporting relationship with the Reporting LEA
SINF0006
Academic Year ID must be a valid academic school year combination and no more than one year in the future
SINF0007
SSID must be a valid CALPADS SSID in the ODS
SINF0008
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
SINF0009
Field must only contain Alphabetic letters, numbers, periods, hyphens and apostrophes.
These letters and characters are valid:
a b c d e f g h i j k l m n o p q r s t y v w x y z
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
1 2 3 4 5 7 8 9 0 . - '
Any other ascii code characters will be rejected. Check for hidden characters.
SINF0010
If Student Alias Last Name is populated, then Student Alias First Name must be populated
SINF0011
If Student Alias First Name is populated, then Student Alias Last Name must be populated
SINF0012
If Grade Level Code is equal to Adult (AD), then Student age must be greater than or equal to 16 and less than 80; Else Student Age must be greater than 0 and less than or equal to 22
SINF0013
Student School Start Date must be greater than Student Birth Date
SINF0033
If Student Information Then Record Type Code must equal SINF, SIGR, SIDM, SIEL, SIST, SIAD
SINF0036
Student Birth Country Code and Student Birth State Province Code must be a valid combination
SINF0045
If Student Hispanic Ethnicity Indicator is populated, then Student Ethnicity Missing Indicator must be equal to N or blank; ELSE, Student Ethnicity Missing Indicator must equal Y AND Student Hispanic Ethnicity Indicator must be NULL
SINF0046
If one or more of the Student Race Codes are populated, then Student Race Missing Indicator must be equal to N or blank; ELSE, Student Race Missing Indicator must be equal to Y AND all Student Race Code values must be NULL.
SINF0048
If Interdistrict Transfer Code is populated, then District of Geographic Residence must be populated
SINF0049
If Primary Residence Category Code not equal to 100, 110, 120, 130, OR 310 Then Residential Address Line 1 must be populated
SINF0051
If Primary Residence Category Code not equal to 100, 110, 120, 130, OR 310, then Residential Address City Name must be populated
SINF0052
If Primary Residence Category Code not equal to 100, 110, 120, 130, OR 310 Then Residential Address State Province Code must be populated
SINF0053
If Primary Residence Category Code not equal to 100, 110, 120, 130, OR 310 Then Residential Address Zip Code must be populated
SINF0054
English Language Acquisition Status Start Date must be greater than Student Birth Date
SINF0055
English Language Acquisition Status Start Date must be less than or equal to current date plus 30 days
SINF0058
If 1) Student Grade Level Code = KN, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, UE, US AND 2) a) Student Birth Country Code not equal to US or PR or b) English Language Acquisition Status = EL, then Student Initial US School Enrollment Date must be populated
SINF0059
Student Initial US School Enrollment Date must be greater than Student Birth Date
SINF0060
Student Initial US School Enrollment Date K-12 must be less than or equal to student's earliest Enrollment Start Date when enrolled in Grades K-12.
SINF0061
If Student Birth Country Code Not Equal To US or Puerto Rico, then Enrolled in US School less than Three Cumulative Years Indicator must be populated
SINF0062
If CTE Pathway Completer Indicator is populated Then CTE Pathway Code must be populated
SINF0064
Effective Start Date must be within Academic Year specified
SINF0066
Effective End Date must be greater than or equal to Effective Start Date
SINF0067
Effective End Date must be within Academic Year specified
SINF0068
Student Gender Code and Student Date of Birth Year must equal existing ODS Student Gender Code and Student Date of Birth Year or Student Legal First Name and Student Legal Last Name must equal existing ODS Student Legal First Name and Student Legal Last Name in the latest SINF record
SINF0072
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 ODS, then do not replace SSID's Student Information
SINF0116
Only one record for an SSID may exist in the file with the same Effective Start Date
SINF0144
If Student Hispanic Ethnicity Indicator is populated, then Student Ethnicity Missing Indicator must be equal to N or blank
SINF0145
If Student Ethnicity Missing Indicator is equal to Y, then Student Hispanic Ethnicity Indicator must be blank
SINF0146
If Student Race Missing Indicator is equal to Y, then all of the Student Race Codes must be blank.
SINF0164
If English Language Acquisition Status Code not equal to EO, then English Language Acquisition Status Start Date must be populated.
SINF0165
If Student's Grade Level Code not = to AD, then English Language Acquisition Status Code must be populated.
SINF0192
District of Geographic Residence must be a valid 7-digit County District (CD) code
SINF0213
English Language Acquisition Status Start Date should be less than or equal to SINF Effective Start Date.
SINF0214
English Language Acquisition Status Code of existing record should equal the English Language Acquisition Status Code of input record when the Effective Start Date is the same.
SINF0215
English Language Acquisition Status Start Date must be less than or equal to current date
SINF0216
English Language Acquisition Status Code equal to EL, RFEP, or IFEP must have a Primary Language Code other than English (00) or Sign Language (37)
SINF0252
Only a student who has an English Language Acquisition Status Code of RFEP may indicate a "Y" in the Student Proficient or Advanced for ELA Code field.
SINF0255
If a student's English Language Acquisition Status (ELAS) Code is being submitted, then the most recent ELAS Code currently stored in the CALPADS ODS must be a valid ELAS in combination with the subsequent ELAS being submitted.
SPED0001
The Reporting LEA of the submitter must equal the Reporting LEA in the record, or the Reporting SELPA of the submitter must have a relationship with the Reporting LEA in the record.SPED0002
School must be a valid code in CDS and have an active CALPADS reporting relationship with the Reporting LEA.SPED0003
SPED0004
SPED0005
School of Attendance NPS must be a valid NPS code in CDS.
SPED0006
Academic Year ID must be a valid academic school year combination and no more than one year in the future.SPED0007
SSID must be a valid CALPADS SSID in the ODS.
SPED0008
SPED0009
Field must only contain Alphabetic letters, numbers, periods, hyphens and apostrophes.
These letters and characters are valid:
a b c d e f g h i j k l m n o p q r s t y v w x y z
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
1 2 3 4 5 7 8 9 0 . - '
Any other ascii code characters will be rejected. Check for hidden characters.
SPED0034
Only one record may exist in the file with the same SSID, Reporting LEA, and Student Special Education Meeting or Amendment Identifier.SPED0046
The SPED file you are uploading from your Special Education Data system is missing and appropriate student race indicator/race code.SPED0069
Student First Name, Student Last Name, Gender, or Student Birth Date do not match for the same SSID (State Student Identifier #) within the ODS (Operational Data Store aka the current data in CALPADS).
SPED0072
The submitted SSID is retired, but the submitted Student Gender Code and Student Date of Birth Year do not match the student’s current SSID in the ODS.SPED0181
The submitted record attempts to delete a record that does not exist in CALPADS.SPED0193
District of Special Education Accountability must be a valid 7-digit County District (CD) code or 7-digit Charter School code.SPED0331
If the Education Plan Amendment Date is populated (not empty), then the Education Plan Type Code must equal 100,150 or 200.SPED0332
If IEP Includes Postsecondary Goals Indicator is populated then Education Plan Type Code must be 100 (IEP).SPED0332
If IEP Includes Postsecondary Goals Indicator then Education Plan Type Code must be 100 (IEP).SPED0333
If Postsecondary Goals Updated Annually Indicator is populated, then Education Plan Type Code must be 100 (IEP).SPED0334
If Postsecondary Goals Age Appropriate Transition Assessment Indicator is populated, then Education Plan Type Code must be 100 (IEP).SPED0334
If Postsecondary Goals Age Appropriate Transition Assessment Indicator is populated, then Education Plan Type Code must be 100 (IEP).SPED0335
If Transition Services in IEP Indicator is populated, then Education Plan Type Code must be 100 (IEP).SPED0336
If Supportive Services Indicator is populated, then Education Plan Type Code must be 100 (IEP).SPED0337
If Transition Services Goals in IEP Indicator is populated, then Education Plan Type Code must 100 (IEP).SPED0338
If Student IEP Participation Indicator is populated, then Education Plan Type Code must be 100 (IEP).SPED0339
If Agency Representative IEP Participation Code is populated, then Education Plan Type Code must be 100.SPED0340
If Special Transportation Indicator is populated then Education Plan Type Code must =100 (IEP).SPED0341
If Special Education Meeting Type Code = 10 or 15, then Initial Evaluation Parental Consent Date must be populated.SPED0342
If Education Plan Type Code is 100 (IEP), 150 (IFSP) or 200 (ISP), Primary Residence Code must be populated.SPED0343
SPED0344
If Education Plan Type Code = 100 (IEP), 150 (IFSP), or 200 (ISP) then Disability 1 Code must be populated.SPED0345
If Education Plan Type Code = 100 (IEP), 150 (IFSP), or 200 (ISP) then Disability 2 Code must be populated.SPED0346
If Education Plan Type Code = 100, 150 or 200 then Special Education Program Setting Code must be populated.SPED0347
If Education Plan Type Code = 150 (IFSP) then Special Education Program Type Code must be populated.SPED0348
If Education Plan Type Code = 100 (IEP) then Special Transportation Indicator must be populated.SPED0349
If Special Education Meeting Date is populated then Student Special Education Meeting or Amendment Identifier is required.SPED0350
If Special Education Program Exit Date is populated then Special Education Program Exit Reason Code must be populated.SPED0351
Initial Evaluation Parental Consent Date must be greater than or equal to the Special Education Referral Date.SPED0352
Special Education Meeting Date must be greater than or equal to Initial Evaluation Parental Consent Date.SPED0353
Special Education Program Exit Date must be greater than Special Education Initial Entry Start Date in staging.SPED0354
Special Education Program Exit Date must be greater than Special Education Referral Date in staging.SPED0355
Special Education Initial Entry Start Date must be less than or equal to current date.SPED0356
Education Plan Amendment Date must be less than or equal to current date.SPED0359
Disability Code 1 cannot equal 200 (None).SPED0360
If Primary Residence Code is 140 (Parent or Legal Guardian), then Special Education Program Setting Code should not = 301 (Residential Facility) or 402 (Correctional Facility).SPED0361
If Primary Residence Code is 140 (Parent or Legal Guardian), then Special Education Program Setting Code should not = 301 (Residential Facility) or 402 (Correctional Facility).SPED0362
If Special Education Program Setting Code equals 103, then Student Age must be less than 3 years.SPED0363
If Special Education Program Setting Code equals 104 or 200, then Student Age must be less than 7 years.
Note: A "104" setting includes, but is not limited to settings where early intervention services are primarily provided for children with disabilities in a setting that is not home or community based such as a hospital, residential facility, clinic, or English language centers/classes.
SPED0372
Education Plan Type Code and Special Education Program Setting Code combination must be a valid combination per the CALPADS Valid Code Combinations document.SPED0375
Only one SPED record may exist with the same SSID, Reporting LEA, SELPA Code, Special Education Meeting Type Code, Special Education Meeting Date, and Amendment Date.SPED0426
If Special Education Meeting Type Code = 15 or 10 AND Special Education Meeting Date is greater than 60 days from the Initial Evaluation Parental Consent Date THEN the Meeting Delay Code must be populated.SPED0434
Students may not have more than one Part B Initial Evaluation Meeting record during an active plan.SPED0435
Students may not have more than one Initial Type C Meeting record without exiting the Special Education Program.SPED0438
If the student's Education Plan Amendment Date is populated, then the following fields must match an existing record for the same student, SSID, Reporting LEA, and SELPA Code in the ODS:
SPED0441
SPED0443
SELPA must be a valid EntityCode and have an active reporting relationship with the Reporting LEA.SPED0450
Special Education Referral Date is required if Special Education Initial Entry Start Date is greater than or equal to 07/01/2006.SPED0451
Referring Party Code is required if Special Education Referral Date is populated.SPED0471
If Special Education Meeting Type = 30 and Education Plan Type = 300 (Pending), then non-applicable fields must be null.SPRG0001
Reporting LEA must equal CDS code associated with submitter User ID
SPRG0002
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
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
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
Field must only contain Alphabetic letters, numbers, periods, hyphens and apostrophes.
e.g. ABCDEFGHIJKLMNOPQRSTUVWXYZ123457890.-'
SPRG0069
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
Only one record for the same Education Program and school may be in the ODS with a null Membership End Date
SPRG0072
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 must be greater than or equal to Education Program Membership Start Date
SPRG0076
Education Program Membership Start Date must be greater than Student Birth Date
SPRG0077
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
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
If Education Program Code = 122 (NCLB Title 1 Part A Basic Targeted), then Education Service Code must be populated
SPRG0084
If Education Program Code = 135 (Migrant), then Migrant Student ID must be populated
SPRG0085
If Education Program Code = 144 (Special Education), then Primary Disability Code must be populated
SPRG0086
If Primary Disability Code is populated, then Education Program Code must equal 144 (Special Education)
SPRG0087
If Education Program Code = 144 (Special Education), then District of Special Education Accountability must be populated
SPRG0088
If District of Special Education Accountability is populated, then Education Program Code must equal 144 (Special Education)
SPRG0150
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
If California Partnership Academy ID is populated then Education Program Code must equal 113 (California Partnership Academy)
SPRG0152
If Migrant Student ID is populated then Education Program Code must equal 135 (Migrant)
SPRG0168
If Education Program Code = 122 (NCLB Title 1 Part A Basic Targeted) then Education Service Academic Year must be populated
SPRG0181
The submitted record attempts to delete a record that does not exist in CALPADS.
SPRG0193
District of Special Education Accountability must be a valid 7-digit County District (CD) code or a valid 7-digit Charter school code.
SPRG0247
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.
SPRG0250
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
The Migrant Student ID must be 11 characters with the first two characters beginning with "06"
SPRG0254
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
If a student is a participant in the Transitional Kindergarten Program (185), then the student’s grade level must be = KN (Kindergarten)
SPRG0295
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).
SPRG9999
Record(s) Will Pass this Validation Once All Other Fatal Errors Are Corrected For Student
