Skip to main content

Membership is free!

Tagged with: CALPADS

CERT001

No student enrollment data is included for an open school that is specified for the collection.

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.

CERT025

The sum of all teacher FTE's (Full Time Equivalents) within the school has either increased or decreased significantly from the previous year.

CERT026

The sum of all administrator FTEs within the school has either increased or decreased significantly from the previous year.

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.

CERT035

The district's number of students who are identified as "English Learners" has either significantly increased or significantly decreased from last year to this year. 

CERT036

The school's count of teachers providing English Learner education services has either increased or decreased significantly from last year's EL teacher count.

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 Immigrant

CERT045

Significant Change In The LEA's Number Of Title III Eligible Immigrants

CERT046

The sum of Staff FTE for all Job Classifications for an individual staff member in the LEA is more than 200%.

CERT047

A course section includes a SEID for which there is no valid teaching assignment information.

CERT048

A teacher was reported who was employed on Census day but has no Non-classroom based job assignments or assigned Course Section records.

In other words, you are trying to report a teacher (because you've already uploaded a staff demographic and staff assignment file), but you are getting a cert error because that teacher doesn't have any course records associated with her/him (likely), or they are a teacher on special assignment or something and don't have a non-teaching assignment. 

So the system is asking you "Did you forget to upload this teacher's course records?"

CERT049

A Staff Assignment was reported for a SEID that has no demographics.

CERT050

There are no administrators at the LEA.

CERT051

There are no pupil services staff at the LEA.

CERT052

There is no staff assignment information for Itinerant or Pull-Out/Push-In Teachers

CERT053

There is no staff assignment information for Teachers at the LEA.

CERT054

A Course Section includes a SEID for which there is no demographic information.

CERT054

A course section includes a SEID for which there is no demographic information.

CERT055

This high school did not submit any students as enrolled in Career-Technical Education courses.

CERT056

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

CERT062

The sum of total enrollment for course sections grouped by Class ID should not be greater than 50

CERT065

The Number of  English Learners (ELs) Receiving Education Services has either increased or decreased significantly when compared with the previous year’s count.

CERT068

No course sections have been identified as NCLB compliant for this school.

CERT070

A substantial FTE percentage is indicated for the Job Classification of Teaching. This staff member has only one departmentalized course section assigned at this school.

CERT073

There is no end of year program participation data for this school. See CALPADS Data Guide for a list of programs collected in the End of Year submission.

CERT075

A teacher with a course section assignment was not employed for the Report Period.

CERT076

A staff member with a non-classroom/support assignment was not employed for the Report Period.

CERT077

No student course section data were submitted for an enrolled student with enrollment status of Primary, excluding Students with Disabilities on IEPs enrolled at the District Level that are not in participating Adult Age Students with Disabilities in Transition Status programs

English Translation:  You have a student enrolled in your school on Census Day (first Wednesday of October), but there is no student course section information in the system yet.  You must upload an SCSE file that has at least one course associated to this student.  You will continue to get this CERT error until that is resolved.

CERT079

A course section does not have any associated student course section records.

In other words, you've uploaded a record using the crse file upload but there are no records of any students enrolled in that section.  

CERT080

The sum of all pupil services FTE within the school has either increased or decreased significantly from the previous year.

CERT081

No course section data was submitted for a student with Enrollment Status of Secondary or Short Term.

CERT081

No course section data was submitted for a student with Enrollment Status of Secondary or Short Term.

CERT082

When the "Multiple Teacher Code" is populated "true", you must have two or more Course Section records with the same Class ID and different SEIDS for the same Course Section.  In other words, you have set up a course to be taught by more than one teacher, but you have only created a single course section record where there should be two.

CERT084

Staff Demographics was reported for a SEID that has no Staff Assignments.

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

CERT092

A student has a waiver record (SWAV), but does not have a program record (SPRG) with Education Program Code = 101 or 144.

CERT097

No Student Program records with an Education Program Code of 122 (NCLB Title I Part A Targeted) have been submitted for a school that received Title I Part A Targeted Assistance funding in the Reporting Year.

CERT098

A student course section record was submitted for an SSID that was not enrolled at any time during the Report Period

CERT099

No End of Year student course section data were submitted for an enrolled student with enrollment status of Primary

CERT100

A course section does not have any associated student course section records.

CERT103

The Education Program Membership Start and End Date range for Transitional Kindergarten Program (185) record is outside of normal range of participation for this program.

Note:  This error was re-activated in May of 2017.

CERT104

The Education Service Code field (9.20) is not populated for a course section in which English Learners are enrolled.

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.

CERT109

The Employment Status Category is Missing for a Teacher.

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.

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.

CERT116

No Student Course Section Completion record (SCSC) was submitted for the CTE Course and the student is a CTE Concentrator.

CERT119

Student will not be 5 in kindergarten year and is not enrolled in TK program

CERT122

Either no Student Course Section Completion record (SCSC) was submitted for a CTE course OR the associated State Course Code submitted is not valid for SCTE Pathway Code.

CERT123

No Student Course Section Completion record (SCSC) was submitted for a CTE Capstone course at the same Reporting LEA or associated State Course Code submitted is not valid for SCTE Pathway Code

CERT129

A student's Expected Attendance Days must be less than or equal to their Total Enrollment Days at the same school for the same academic year. 

CERT138

Missing Student Enrollment Exit Reason for Student With Disabilities Dropping from Program

CERT140

SSRV records must have an associated SPED record (i.e., same student, LEA, and Student Special Education Meeting or Amendment Identifier) where Education Plan type = 100, 150, or 200 and Meeting type = 10, 15, 20

CERT141

Missing Student Enrollment Exit Reason for Student with Disabilities leaving program due to Max Age Reached

CERT143

SPED record must have an associated SENR data for the same SSID, LEA, and Academic Year

CERT145

Student enrolled in a Private School must have an associated SPED record in the same reporting LEA

CERT152

Students in Grades TD, IN, PS, KN, 1-3 should not be suspended for disruption or defiance (Student offense code = 511)

CERT160

Students with an Education Plan Type Code = 200 (ISP) must have a Private School enrollment (0000002)

CERT161

All SPED records for a student with the same Education Plan Type Code, Special Education Meeting Date, and Education Plan Amendment Date in the same Reporting LEA and SELPA must have the same Special Education Program Exit Date and Special Education Exit Reason Code

CRSE0001 / CRSC0001

Reporting LEA must equal institution identifier of submitter User ID

CRSE0002 / CRSC0002

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

CRSE0106

The State Educator ID # (SEID) must be a valid 10-digit SEID and exist in the Commission on Teacher Credentialing database as a current and valid number.

CRSE0122 / CRSC0122

Two or more of the same SEIDs (duplicate) must not be submitted as assigned to a single course section.

CRSE0123 / CRSC0123

If CTE Postsecondary Articulated Course Indicator = Y then a CTE State Course Code must be used.

Reference Course Group Master Combos Valid Combination

CRSE0126 / CRSC0126

State Course Code cannot be blank unless the LEA has used the CALPADS mapping function to provide a translation from the Local Course ID

CRSE0131

If Education Service Code = 1 Or Instructional Strategy = 600 Then Language of Instruction Code must be populated

CRSE0132

Language of Instruction Code must not equal 00 (English) or 37 (Sign Language)

CRSE0135 / CRSC0135

SEID must be a valid SEID in the CCTC file or SEID may equal 9999999999.

CRSE0137 / CRSC0137

If CTE Course Section Provider Code is populated Then Education Program Course Content code must equal 154 or a State Course Code must be populated with a CTE Course Code Reference Course Group Master Combos Valid Combination

CRSE0201 / CRSC0201

School should be open during Academic Year reported

CRSE0220 / CRSC0220

Staff Demographic record should exist for a Course Section Record except when the SEID equals 9999999999

CRSE0223

If Education Service Code (920) is not null, then Instructional Strategy (9.22) cannot be null.

CRSE0224

If Instructional Strategy (9.22) = 400, 500, 600 or 650, then Education Service (9.20) cannot be null.

CRSE0274

If two or more Course Section records have the same Record Type Code, Academic Year ID, School of Course Delivery, Academic Term Code, CRS-Local Course ID, Course Section ID and two or more different SEIDs, then all records must have the same value in the Education Service Code field.

CRSE0298 / CRSC0298

If CRS-Course Content Code 154 (High Quality CTE) is populated for a Course and for the corresponding State Course Code that is not in the range of 7000 - 8999.
 
Reference (Course Group Master Combos, Valid Code Combinations)

CRSE0456

If Distance Learning Indicator = N or is null, then Online Course Instruction Type Code must be blank.

CRSE0457

If Distance Learning Indicator = Y, then Online Course Instruction Type Code must be populated.

CRSE0458

If Departmentalized Course Standards Grade Level Range = MID (Middle Grades 5-8), then Middle School Core Course Indicator must equal Y or N.

CRSE0459

If AP/IB Course Code Cross Reference is populated, then CRS - State Course Code must equal a CTE State Course Code 7000-8999.

CRSE0460

If CRS - Departmentalized Course Standards Grade Level Range Code = NOT - Not Applicable, then CRS - Content Standards Alignment Code must = 3 - Not Content Standards-Aligned or Not Applicable.

CRSE0461

If CRS - Departmentalized Course Standards Grade Level Range Code is not = NOT - Not Applicable, then CRS - Content Standards Alignment Code cannot = 3 - Not Content Standards-Aligned or Not Applicable.

CRSE0462

If State Course Code = 9000, 9051, 9080, 9090, 9130-37, 9155, 9156, 9157, 9222, 9223, 9291, 9292, 9293, 9294, 9316, 9381, or 9400 then Course Content Area Subcategory Code is required.

CRSE0463

If State Course Code does not equal 9000, 9051, 9080, 9090, 9130-37, 9155, 9156, 9157, 9222, 9223, 9291, 9292, 9293, 9294, 9316, 9381, or 9400 then Course Content Area Subcategory Code must be blank.

CRSE0464

If CRS - State Course Code is not in the range of 7000-8999, then High Quality CTE Course Indicator on Course Section must be blank.

CRSE0465

 CRS - State Course Code is in the range of 7000-8999, then High Quality CTE Course Indicator must equal Y or N. 
 
Reference (Course Group Master Combos, Valid Code Combinations)

CRSE0467

If Course Content Area Subcategory is populated, then it must be a valid combination per the CrsGrpSt-ContentSubctgy combinations in the CALPADS Valid Code Combinations.

CRSE0468

Course Group State and CRS - Departmentalized Course Standards Grade Level Range must be a valid combination in the CrsGrpSt-StndsGrdLvlRange combinations in the CALPADS Valid Code Combinations.

CRSE0469

If AP/IB Course Code Cross Reference is populated, then it must be equal to an active course identified as an AP or IB course in the AP or IB columns in the Course Group Master Combos in the CALPADS Valid Code Combinations.

FRMT0001

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

FRMT0001

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

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.

Specifically, the staff member's birth date must by an 8 digit number following the CCYYMMDD format.

A staff member born on March 21, 1968, for example, would be correct if it was 19680321.

FRMT0002

Date format does not match Calpads File Specifications

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.

FRMT0003

Format for Student Credits Attempted or Student Credits Earned must match CALPADS File Specifications

FRMT0004

Data for a numeric field must be a number or a decimal point.

FRMT0004

Data for a numeric field must be a number or a decimal point.

FRMT0004

Data for a numeric field must be a number or a decimal point.

FRMT0004

Data for a numeric field must be a number or a decimal point.

FRMT0004

Data must follow rules for the field type specified in the CALPADS File Specifications (CFS)

FRMT0005

Format for Staff Job Classification FTE Percentage must match CALPADS File Specifications

FRMT0006

Format for Incident Disciplinary Action Duration Days must match CALPADS File Specifications

GERR0001

A required field for the submitted Record Type is missing.

GERR0001

A required field for the submitted Record Type is missing

GERR0001

A required field for the submitted Record Type is missing

GERR0001

A required field for the submitted Records Type is missing

GERR0001

A required field for the submitted Record 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

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

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

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

Student must be enrolled in the School of Attendance during the Academic Year specified

GERR0005

Student must be enrolled in the School of Attendance during the Academic Year specified

GERR0005

Student must be enrolled in the School of Attendance during the Academic Year specified

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

GERR0007

Code submitted outside the effective date range.

GERR0007

Code submitted outside the effective date range

GERR0007

Code submitted outside the effective date range.

(e.g. you've entered a school entry date that exists BEFORE the student's birth date)

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

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

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

IVR0036

Student Birth Country Code and Student Birth State Province Code must be a valid combination

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

SASS0001

Reporting LEA must equal institution identifier of submitter User ID

SASS0006

Academic Year ID must be a valid academic school year combination and no more than one year in the future

SASS0009

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.

SASS0033

Record Type Code must equal SASS

SASS0106

The educator's SEID # must be a valid SEID #.

SASS0118

Staff Job Classification FTE Percentage must be greater than or equal to 1

SASS0119

Staff Job Classification FTE Percentage must be Less Than 200%.

SASS0120

If Staff Job Classification Code = 10 or 11 OR 25, then one or more of the Non Classroom Based Job Assignment Codes must be populated

SASS0163

If Staff Job Classification Code = 26 then School of Assignment must be a charter school (CDS)

SASS0197

Staff Gender Code and Staff Date of Birth Year must equal existing ODS Staff Gender Code and Staff Date of Birth Year in the latest SDEM record

SASS0198

School of Assignment must not be an NPS school

SASS0201

School should be open during Academic Year reported

SASS0219

Staff Job Classification Code and Non Classroom Based Job Assignment Code must be a valid combination as defined in the CALPADS Valid Code Combinations document

SASS0256

Only one Staff Assignment (SASS) record may exist in the file with the same Academic Year ID, SEID, School of Assignment, and Job Classification Code

SASS0257

If any Nonclassroom Based or Support Assignment is "Employee on Leave", then all other Nonclassroom Based or Support Assignment fields must be blank.

SCSC0230

Two or more records with the same SSID (duplicate) must not be submitted as completing the same course section within the same Marking Period

SCSE0001 / SCSC0001

8.04 Reporting LEA

SCSE0007 / SCSC0007

SSID must be a valid CALPADS SSID in the ODS.

In other words, you are submitting a file with an SSID # (State Student Identifier Number) that is not recognized yet by CALPADS.  It is either a typo in your SIS system, or the SSID # may have been recently retired, or there is some other error.

SCSE0008 / SCSC0008

1.08 - SSID

1.17 - Student Birth Date

1.18 - Student Gender Code

SCSE0009 / SCSC0009

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.

SCSE0069 / SCSC0069

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

SCSE0072 / SCSC0072

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

SCSE0128 / SCSC0128

CRS-State Course Code and Grade Level must be a valid combination. See table below:

SCSE0139 / SCSC0139

Student Course Section record must have a corresponding Course Section record

SCSE0199 / SCSC0199

School of Course Delivery must not be an NPS school

SCSE0201 / SCSC0201

School should be open during Academic Year reported

SCSE0222 / SCSC0222

Two or more of the same SSIDs (duplicate) must not be submitted in a student course section submission as enrolled in a single course section

SCTE0001

Reporting LEA must equal CDS code associated with submitter User ID

SCTE0002

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

SCTE0006

Academic Year ID must be a valid academic school year combination and no more than one year in the future

SCTE0007

SSID must be a valid CALPADS SSID in the ODS

SCTE0008

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

SCTE0199

School of Course Delivery must not be an NPS school

SCTE0242

The CTE Pathway Completion Academic Year ID must match the Academic Year ID

SCTE0243

Two (or more) records with the same SSID (State Student Identifier Number) must not be submitted with the same CTE Pathway Code.

SDEM0006

Academic Year ID must be a valid academic school year combination and no more than one year in the future

SDEM0009

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.

SDEM0011

If Staff Alias First Name is populated Then Staff Alias Last Name must be populated

SDEM0033

Record Type Code must equal SDEM.

SDEM0064

Effective Start Date must be within Academic Year specified

SDEM0106

SEID must be a valid SEID in the CCTC file

SDEM0107

Staff Age must be greater than or equal to 18 and less than 95.

SDEM0109

If Staff Hispanic Ethnicity Indicator is populated, then staff Ethnicity Missing Indicator must be equal to N or blank; ELSE, Staff Ethnicity Missing Indicator must equal Y AND Staff Hispanic Ethnicity Indicator must be NULL

SDEM0110

If one or more of the Staff Race Codes are populated, then Staff Race Missing Indicator must be equal to N or blank; ELSE, Staff Race Missing Indicator must be equal to Y AND all Staff Race Code values must be NULL.

SDEM0111

Staff Employment Start Date must be greater than Staff Birth Date plus 18 years

SDEM0112

Staff Employment Start Date must be less than or equal to current date plus six months

SDEM0113

Staff Service Years LEA must be less or equal to Staff Service Years Total

SDEM0114

Staff Employment End Date must be greater than or equal to Staff Employment Start Date

SDEM0115

Staff Service Years LEA Total must be less than or equal to Staff Age minus 17

SDEM0116

Two or more records exist in the submission with the same Effective Start Date

SDEM0196

Staff Gender Code and Staff Date of Birth Year must equal existing ODS Staff Gender Code and Staff Date of Birth Year Or Staff Legal First Name and Staff Legal Last Name must equal existing ODS Staff Legal First Name and Staff Legal Last Name in the latest SDEM record

SDEM0200

Reporting LEA must be open during the effective date period.

SDEM0218

All associated Staff Assignment and Course Section records must be deleted before deleting the last remaining Staff Demographic record

SDEM0221

Staff Service Years LEA (7.30) and Staff Service Years Total (7.31) must be equal to one or more

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.

SENR0027

Student primary enrollment cannot overlap an existing primary enrollment for the same student within the 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.

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 Date

SENR0269

A grade level was submitted for a student that is outside the grade level range offered by the school. Students with a valid special education program record are not included in the grade level validation.

SENR0302

If student has a Secondary Enrollment Status Code (20), Student Exit Reason must be null or = E170 (Secondary Enrollment Exit)

SENR0316

If Student Seal of Biliteracy Indicator = Y then Student School Completion Status must = 100 (Graduated, Standard HS Diploma)

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

If School of Attendance NPS is populated then School of Attendance must equal 0000001.

SPED0004

If School of Attendance = 0000001, then the School of Attendance NPS must be populated.

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

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 active SSID for student.

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

If Education Plan Type Code = 100, 150 or 200 then Special Education Initial Entry Start Date must be populated.

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.

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.

SPED0437

Students may not have an Triennial Evaluation without a Part C Initial Evaluation Meeting.

 

SPED0441

Education Plan Amendment Date must be populated if: 
Education Plan Type Code = 100 (IEP), 150 (IFSP), or 200 (ISP)
AND
Special Education Meeting Type Code and Special Education Meeting Date match a SPED record for the same SSID, Reporting LEA, and SELPA Code in the ODS
AND
any of the following fields do not match:
- Primary Residence Code
- Special Education Program Setting Code
- Preschool Program Setting Service Location Code
- Ten or More Weekly Hours in setting Indicator
- General Education Participation Percentage Range Code
- IEP Includes Postsecondary Goals Indicator
- Postsecondary Goals Updated Annually Indicator
- Postsecondary Goals Age Appropriate Transition Assessment Indicator 
-Transition Services in IEP Indicator 
- Supportive Services Indicator
- Transition Services Goals in IEP Indicator
- Student IEP Participation Indicator
- Agency Representative IEP Participation Code
- Special Transportation Indicator 

SPED0450

Special Education Referral Date is required if Special Education Initial Entry Start Date is greater than or equal to 07/01/2006.

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

SSRV0004

If School of Attendance = 0000001 then School of Attendance NPS must be populated

SSRV0005

School of Attendance NPS must be a valid NPS code in CDS

SSRV0006

Academic Year ID must be a valid academic school year combination and no more than one year in the future.

SSRV0007

SSID must be a valid CALPADS SSID in the ODS.

SSRV0181

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

SSRV0193

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

SSRV0327

If the Special Education Service Provider Code equals 400 (NPA), then the Nonpublic Agency Identifier must also be populated.

SSRV0328

If NPA School is populated, then Special Education Service Provider Code must be 400 (NPA).

SSRV0329

If Service Frequency Code is populated Then Service Duration must be populated.

SSRV0330

Service Duration field must greater than or equal to 10 minutes per service session.

SSRV0410

If Special Education Service Provider Code equals 200 or 210, then Student Age must be at least 12 years, but less than 22 years.

SSRV0411

If Special Education Service Provider Code equals 230, then Student Age must be at least 2 years, but less than 22 years.

SSRV0412

If Special Education Service Provider Code equals 240, then Student Age must be less than 13 years.

SSRV0413

If Special Education Service Provider Code equals 250, then Student Age must be less than 6 years.

SSRV0414

If Special Education Service Provider Code equals 300, then Student Age must be at least 3 years, but less than 22 years.

SSRV0415

If Special Education Service Provider Code equals 310, then Student Age must be less than 21 years.

SSRV0416

If Special Education Service Provider Code equals 410, then Student Age must be at least 2 years, 9 months, but less than 22 years.

SSRV0417

If Special Education Service Code equals 210, 220, 230, 240, 250, 260, or 270, then Student Age must be less than 4 years.

SSRV0418

If Special Education Service Code equals 350, then Student Age must be at least 3 years, but less than 7 years.

SSRV0419

If Special Education Service Code equals 750, 820, 830, 840, 850, 855, 860, or 890, then Student Age must be at least 5 years, but less than 23 years.

SSRV0420

Student Age must be less than 22 years.

SSRV0440

A student with an SSRV record must have an associated SPED record where Education Plan Type = 100, 150, or 200 for the same Reporting LEA, Academic Year, and Education Plan Meeting or Amendment ID.

SSRV0444

SELPA Code must equal existing SELPA Code in SPED record when Student Special Education Meeting or Amendment Identifier is populated.

SSRV0445

Student Special Education Meeting or Amendment Identifier must equal Student Special Education Meeting or Amendment Identifier in existing SPED record.

SSRV0446

Two or more records for the same student with the same (duplicate) Special Education Service Code, Service Provider Code, and Special Education Service Location must not be submitted within the same Academic Year

SSRV0447

Nonpublic Agency Identifier (NPA) must be a valid NPA code in Special Education Division's Nonpublic Agency Database

SSRV0448

Service Frequency Code must be populated for students less than 36 months old OR If the Service Duration is populated, then Service Frequency Code must be populated.

SSRV0449

Service Duration must be populated for students less than 36 months old OR If the Service Frequency Code is populated, then Service Duration must be populated.

STAS0303

The following Student Absence Summary information must be populated if the Student Absence Summary Data Collection exemption Indicator is null or N.

  • Hourly Attendance School Type Indicator
  • Expected Attendance Days
  • Days Attended
  • Days Absent out-of-school suspension
  • Days in Attendance In-School Suspension
  • Days Absent Excused Non-Suspension
  • Days Absent Unexcused Non-Suspension
  • Incomplete Independent Study Days

STAS0304

The following Student Absence Summary information must be null if Student Absence Summary Data Collection Exemption Indicator is equal to "Y" (yes) .

- Hourly Attendance School Type Indicator
- Expected Attendance Days
- Days Attended
- Days Absent out-of-school suspension
- Days in Attendance In-School Suspension
- Days Absent Excused Non-Suspension
- Days Absent Unexcused Non-Suspension
- Incomplete Independent Study Days

STAS0305

When populated, Expected Attendance Days must be between 1 and 255 days, inclusive

STAS0306

When populated, Days Attended must be less than or equal to Expected Attendance Days

For example, a typical school in California operates on a 180 day schedule.  A student attending all year would be expected to be in attendance all 180 days.  

If, for some reason, your SIS system is pulling data incorrectly (maybe a problem with the calendar setup), and you are pulling MORE than 180 days for attendance, the CALPADS system will flag this, since you can't have a student attend MORE days than actually existed during the school year.  

STAS0307

When populated, Days Absent Out-of-School Suspension must be less than or equal to Expected Attendance Days Less Days Attended (May be 0)

STAS0308

When populated,Days in Attendance In-School Supsension must be less than or equal to Expected Attendance Days Less Days Attended (May be 0)

STAS0309

When populated,Days Absent Excused Non-Supsension must be less than or equal to Expected Attendance Days Less Days Attended (May be 0)

STAS0314

A student may only have one STAS record at the same school in the same academic year.

STAS0318

When populated, the total days for all absences and days attended must equal the Expected Attendance Days 

Recent CALPADS Discussions

What happens if you don't certify CALPADS?
1576 Hits 0 Votes 0 Replies
Posted on Wednesday, 01 July 2020
What happens if you don't certify CALPADS? Attached is a PDF file that shows ho ...
Should I report Special Ed Preschool teachers?
1178 Hits 0 Votes 0 Replies
Posted on Tuesday, 17 March 2020
I'm hoping I can get some clarification here as to if we really need to report p ...
Postsecondary status codes 910 & 920
1706 Hits 0 Votes 1 Replies
Posted on Tuesday, 25 February 2020
I posted this question on an actual post but not sure if that was the appropriat ...
Data request from CALPADS
1534 Hits 0 Votes 2 Replies
Posted on Tuesday, 25 February 2020
Hi. Has anyone else gotten the Public Records request from DRC (Disability Right ...
CALPADS Job Class/Assignments
1537 Hits 0 Votes 1 Replies
Posted on Wednesday, 26 February 2020
I'm a bit confused with how to report Teachers who teach students but who also s ...
Cron Job Starts