Tagged with: FAll 2

CERT004

A student has no Ethnicity/Race data.

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.

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.

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.

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.

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.

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.

CERT104

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

CERT109

The Employment Status Category is Missing for a Teacher.

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

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

CRSE0130

If Multiple Teacher Code is populated and the SEID is not equal to "9999999999" then at least one other Course Section record must be submitted with the same Academic Term, Academic Year, School of Course Delivery and Class ID, where Multiple Teacher code is not null and where the SEID differs from the current record.

Or, in other words - your CRSE file was uploaded with at least one teacher record marked as "multiple teacher" (think co-teachers, team teaching or a job share situation).  Having just one of the two teacher's records in the CRSE file, however, is not cool.  You gotta have BOTH.  That means a record for teacher A and a record for teacher B too, and in the same file.  

ALSO!  Remember that the CRSE is a full replacement file.  Meaning you will want to upload only 100% complete files, since the information in the last file will literally erase any information from the previous uploads.  

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.

CRSE0231 / CRSC0231

Each of the following fields must have identical values in all records with the same CRS-Local Course ID: - CRS-State Course Code - CRS-Course Name - CRS-Course Content Code - CRS-NCLB Core Course Instructional Level Code - CRS-CTE Technical Preparation Course Indicator - CRS-UC CSU Approved Indicator

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

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

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

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

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.

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 Record Type is missing

GERR0002

The value provided for the field is not a valid value from the CALPADS Code Sets

GERR0002

The value provided for the field is not a valid value from the CALPADS Code Sets

GERR0002

The value provided for the field is not a valid value from the CALPADS Code Sets

GERR0005

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

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)

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

SASS0009

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

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.

SCSC0140

SCSC0141

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

SCSE0006 / SCSC0006

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.

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

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.

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