Skip to main content

Membership is free!

Tagged with: Student Information

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 Immigrant

CERT045

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

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

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

FRMT0001

Field length does not match Calpads File Specifications

FRMT0001

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

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

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

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

IVR0165

If Student's Grade Level Code not = to AD, then English Language Acquisition Status Code must be populated

IVR0213

English Language Acquisition Status Start Date should be less than or equal to SINF Effective Start 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).

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.

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.

SENR0006

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

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.

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

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.

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.

SPRG0001

Reporting LEA must equal CDS code associated with submitter User ID

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.

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.

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

Recent CALPADS Discussions

What happens if you don't certify CALPADS?
1575 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?
1177 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 ...