Validation Rules

Attendance - 1

Error

IF certifying student Attendance, School Calendar Dates must align with the Entry/ExitDates identified on their StudentSchoolAssociation

Student does not show active enrollment dates for attendance dates submitted.

Students cannot have an entry or exit date provided that is outside of the school`s overall calendar begin/end dates. Students cannot have enrollment dates before the overall school calendar begin date (1st student calendar date) or have an exit date after the overall school calendar end date (last student calendar date).

Attendance - 2

Error

IF primary school and Attendance count is NOT a WHOLE NUMBER or incremented by "0.5", THEN throw error

Attendance may only be 0.5 (Half Day) or 1 (Full Day) or NO attendance has been provided.

Schools must report a student`s attendance with .5 or 1. If NO ATTENDANCE data is found this is considered 0 (zero) and will trigger the error.

Attendance - 3

Warning

IF student`s total Attendance contains 10 days or more of "Unexcused Absence", THEN throw Warning

Student's attendance consists of more than 10 days of unexcused absences. Student is considered habitually truant. Refer to IC 20-20-8-8.

Students with more than 10 days of unexcused absence codes reported will trigger the warning.

Attendance - 4

Conflict

IF student is attending more than one school listed on their StudentSchoolAssociation with overlapping Entry/ExitDates, AND both Primary School = TRUE; THEN throw conflict;

Student not counted. Multiple schools claiming student for attendance. Conflicted with: {SchoolId - Entry Date - Exit date , *}

Students that have the same entry/exit date or overlapping entry/exit dates on the student school association (enrollment) record where both schools are identified as primary=true will cause the conflict message to trigger. Schools must work together to remove the conflict in the data by adjusting, editing, correcting their entry or exit dates.

Attendance - 6

Error

IF primary school and DaysEnrolled (sum of all attendance events) is null or 0 or not increment of 0.5, THEN throw error

Days Enrolled may only be 0.5 (Half Day) or 1 (Full Day) or NO attendance has been provided.

Schools must report a student`s attendance with .5 or 1. If student school association (enrollment) record data shows the student has an entry date during the school calendar is found and no attendance data has been reported this is considered 0 (zero) and will trigger the error. This will also trigger if the ONLY attendance data reported is an absence or non-present attendance code.

Attendance - 7

Conflict

If a student has more than one schoolOfAcountibility, then conflict

Student not counted. Multiple schools claiming student for attendance. Conflicted with: {Accountability school Ids}

Students that have more than one student school association (enrollment) record where one school is identified as primary=true and one school is identified as primary=false AND both schools report a student education organization association record (SEOA) providing different accountable school IDs will cause the conflict message to trigger. Schools must work together to remove the conflict in the data by adjusting, editing, correcting the additional responsibility record=school of accountability.

Attendance - 8

Exclusion

If Primary School = False then throw exclusion

Student not counted for certification. Primary School is reported as 'False'. Attendance data accepted but not included in the overall certification counts.

Students reported with a School Association (enrollment) record where the primary school=false AND reporting attendance data as required will trigger this exclusion. The attendance data is received but will not be used in the school`s overall attendance percentage calculation or used in the school`s accountability formula.

Attendance - 9

Error

If Student Attendance event date equals more than sum 1.0, then throw error.

Attendance may not be reported more than 1 (full day) for the same date.

Students cannot be reported with attendance totaling more than a full day (1) of attendance. Schools providing two .5 attendance records with different attendance codes will be accepted as this does not total more than a full day (1).

Calendar - 1

Error

BeginDate of calendar year must be on OR after July 1st AND EndDate of calendar year must be on OR before June 30th

Calendar dates for current school year must be between July 1st and June 30th.

School calendars must have a begin date on or after July 1st and an end date on or prior to June 30th of the current reporting year. If the begin or end dates are not within these calendar dates this will trigger the error message.

Calendar - 2

Warning

IF CalendarType is Student Specific Elementary, THEN total Instructional Minutes must be >= 54,000 AND GradeLevelDescriptors must be between KG through 06

Student Specific Elementary Calendar must be reported for schools with grade levels less than or equal to grade 06 and total Instructional time should be at least 54,000 minutes for the school year.

Schools with grade levels of PK-6 may utilize Student Specific Elementary calendar type and report at least a total of 54,000 instructional minutes. Schools utilizing the Elementary calendar type for schools with higher grade levels or not reporting a minimum of 54,000 instructional minutes will trigger the WARNING message. This does not keep a school from certifying the data.

Calendar - 3

Warning

IF CalendarType is Student Specific Secondary, THEN Instructional Minutes must be >= 64,800 for any GradeLevelDescriptors 07 and above

Student Specific Secondary Calendar must be reported for schools with any grade level higher than or equal to grade 07 and total Instructional time should be at least 64,800 minutes for the school year.

Schools with grade levels of 7-12 may utilize Student Specific Secondary calendar type and report at least a total of 64,800 instructional minutes. Schools utilizing the Secondary calendar type for schools with lower grade levels or not reporting a minimum of 64,800 instructional minutes will trigger the WARNING message. This does not keep a school from certifying the data.

Calendar - 4

Warning

IF CalendarType is Student Specific Non-Compulsory, THEN Instructional Minutes must be >=100 AND GradeLevelDescriptor must be PK

Student Specific Non-Compulsory Calendar must be reported for schools with grade levels of PK and/or KG only. and Instructional time must be at least 100 minutes.

Schools with grade levels of PK-PK or PK-KG only may utilize Student Specific Non-Compusory calendar type and report at least 100 instructional minutes. Schools utilizing the Non-Compulsory calendar type for schools with grade levels higher grade levels will trigger this WARNING message. This does not keep a school from certifying the data but may cause School Accountability office to send a notice of incorrect data being provided.

Calendar - 9

Error

IF InstructionalTimeInMinutesIndicator is blank, THEN error

Instructional time in minutes indicator is missing or invalid.

Schools must identify if they are considered a Performance-Qualified School District or High School by providing `true` or `false` date in the Instructional Time in Minutes Indicator field. Instructional Time in Minutes Indicator not provided will trigger this error message.

Calendar - 11

Warning

IF certifying Calendar for a Public school, THEN at least 180 CalendarEvent(s) must consist of "Student Calendar", "Delay/Early Dismissal - Weather", "Delay/Early Dismissal - Other", and "Waiver Day"

Calendar dates is less than the minimum requirement of 180 days. In order to avoid financial penalty, school(s) must have approved waiver days(s) on file with School Accountability.

Schools should provide a minimum of 180 days with one of the Calendar Event descriptors identified as a student instructional day (Student Calendar, E-Learning, Delay/Early Dismissal-Weather, etc.). Schools not providing 180 student instructional days will trigger this WARNING message. This will not keep a school from certifying the data.

Calendar - 12

Warning

If a school provides more than 3 aggregate event days (Virtual Planned - Asynchronous, Virtual Unplanned - Asynchronous, Virtual Covid - Asynchronous) then throw warning.

Asynchronous virtual days in excess of 3 do not count towards the 180 day instructional day requirement.

Schools reporting additional Asynchronous virtual days equaling more than three will receive a WARNING message letting them know they have provided more than three calendar event dates of any asynchronous virtual descriptors. This will not keep a school from certifying the data.

Calendar - 13

Error

Event Minutes cannot be greater than 600 (10hours), then error.

Event Minutes cannot be greater than 600 (10hours)

Schools providing more than 600 event minutes on any calendar date will receive the error message. Schools cannot report more than 600 minutes on any given school calendar date.

Calendar - 14

Error

Event Minutes cannot be less than 0 (zero), else error

Event Minutes cannot be less than zero

Schools providing less than 0 event minutes on any calendar date will receive the error message. Schools cannot report less than 0 minutes on any given school calendar date.

Calendar - 15

Error

Event Duration cannot be less than 0 (zero) else fail

Event Duration cannot be less than zero

Schools providing less than 0 on the event duration on any calendar date will receive the error message. Schools cannot report less than 0 event duration on any given school calendar date.

Calendar - 16

Error

Event Duration cannot be more than 1 (one), else error

Event Duration cannot be more than one.

Schools providing more than 1 on the event duration on any calendar date will receive the error message. Schools cannot report more than 1 event duration on any given school calendar date.

Certified Educator - 1

Warning

ContractSalary was above 30000 and percent of time employed `[TotalTimeEmployed]’ less than 50, throw warning

Current year salary is high for Percentage of Time Employed, verify salary and time employed is accurate.

Schools providing a staff employment record with a salary higher than 30,000 and the FTE is less than 50% will receive this WARNING message. This will not keep a school from certifying their data.

Certified Educator - 2

Warning

If contract salary is below 3000 and contract days is greater than 100, THEN throw warning

Current year salary is less than $3,000, verify salary is accurate.

Schools providing a staff employment record with a salary less than 3,000 and the contract days are more than 100 will receive this WARNING message. This will not keep a school from certifying their data.

Certified Educator - 3

Warning

If historical records are <= total years experience being submitted, throw error

Experience normally increases each year with successive employment. Verify years of experience is accurate.

Schools will receive a WARNING message if the years of experience reported on the staff employment record is not increased by one from data provided to IDOE in a previous school year. This will not keep a school from certifying their data.

Certified Educator - 5

Warning

Prior Salary is higher than current salary.

Current year salary is less than prior year, verify salary is accurate.

Schools will receive a WARNING message if the current salary being provided is less than the salary provided to IDOE in a previous school year. This will not keep a school from certifying their data.

Certified Educator - 6

Warning

ContractSalary entered was too high for the amount of ContractDays submitted (salary higher than 200000 and contract days less than 100)

Current year salary is high for Contract Days, verify salary and contract days are accurate.

Schools will receive a WARNING message if the current salary being provided is more than 200,000 and the contract days are less than 100. This will not keep a school from certifying their data.

Certified Educator - 8

Warning

IF certifying for CE AND school staff is employed at a Public School AND their ContractDays submission is 26 days or less, THEN throw warning

Current year contract day(s) is too low, verify contract days accuracy.

Schools will receive a WARNING message if the contract days provided is less than 27. This will not keep a school from certifying their data.

Certified Educator - 9

Error

IF certifying for CE THEN their ContractSalary must be <= $300,000

Staff Contract Salary must be equal to or less than $300,000.

Schools reporting a staff with a salary more than 300,000 will receive this error message. If a school has a staff being paid more than 300,000 they should contact IDOE support for review of the data to allow a higher salary amount to be provided.

Certified Educator - 10

Error

IF certifying for CE, THEN staff must either have "0" through "70" as their YearsOfPriorProfessionalExperience. "0" indicates as their first year

Staff Years of Experience must be a value between 0 and 70.

Schools reporting a staff with years of experience less than 0 will receive this error message. Staff must have at minimum 0 years of experience provided. Schools reporting a staff with years of experience greater than 70 will receive this error message. If a school has a staff member with more than 70 years of experience they should contact IDOE support for review of allowing a higher years of experience data to be provided.

Certified Educator - 11

Error

IF educator is reporting as 0 years of YearsOfPriorProfessionalExperience, THEN historical SPN data from years prior CANNOT exist

Staff has prior year employment.

Schools reporting 0 for a staff that has prior year experience provided to IDOE will receive this error message. Staff that have been reported to IDOE with prior years experience cannot be reported with 0.

Certified Educator - 12

Error

Supp salary is out of the accepted range, it must be between 0 and 40000.

Supplemental Salary cannot be more than $40,000.

Schools reporting a staff with a supplemental salary more than 40,000 will receive this error message. If a school has a staff being paid more than 40,000 in supplemental salary they should contact IDOE support for review of the data to allow a higher supplemental salary amount to be provided.

Certified Educator - 13

Error

Staff must have Contract Days, Contract Salary, Supplemental Salary, and Percentage of Title I Salary provided.

Staff must have Contract Days, Contract Salary, Supplemental Salary, and Percentage of Title I Salary provided.

Public/Charter schools must provide contract days, contract salary, supplemental salary, and percentage of Title I salary provided. If this data is not provided the error message will be received.

CertifiedPosition - 1

Error

If contracting corp is blank or null, throw error

Staff entered does not have an active contract for the given school year.

Staff must have a Staff Employment record provided by an Ed Org within the state of Indiana (ed org that `holds the contract`) to be included in Staff Assignment (CP) certification. If there is no other ed org holding the contract then the reporting ed org will need to provide the staff employment record. Example: staff are employed by a third party. Not all staff classifications are counted for Staff Assignment certification.

CertifiedPosition - 2

Exclusion

IF School ID is null staff is excluded

Staff not counted for Certified Personnel. Staff is missing a school assignment association record.

Staff provided a Staff Classification descriptor (not considered a key contact or decorator role) and attached accurately to the LEA (central office) ID or School ID will be certified. Staff provided a Staff Classification descriptor not allowed for reporting with the LEA (central office) Id will recieve this error.

CourseCompletion - 1

Error

IF certifying school personnel AND is assigned to an IB AcademicSubjectDescriptor, THEN School must be IB accredited

School has not been identified as providing IB courses for the current school year.

IDOE has a separate table where schools that have identified themselves as providing IB courses is listed. If a school is not on the table the error message will trigger. Schools should submit a help ticket after confirming they are listed on the IB site as an IB school and IDOE staff will work to have the school added to the list.

CourseCompletion - 3

Error

IF Course Result (courseAttemptResultType) is "No grade awarded", THEN finalNumericGradeEarned must remain blank

When No Grade is Awarded a grade earned cannot be reported.

Schools cannot report a grade/GPA (0.0-4.0) earned when the student is reported for the class as `no grade awarded`.

CourseCompletion - 4

Error

IF submitted a finalNumericGradeEarned, THEN the values must be between 0 through 4.0

Grades Earned can only have a numeric value between 0.0 to 4.0.

Students completing a high school or credit bearing course MUST have a final numeric grade (GPA) provided (0.0-4.0). Letter or alpha grades will not be accepted. Elementary and Middle school courses do not require a numeric grade (GPA) provided. If a school tries to send a numeric grade outside of 0.0-4.0 range the record will fail.

CourseCompletion - 5

Error

IF CreditType is "Dual Credit", THEN a PostsecondaryInstitution is required

A Post-Secondary Institution must be provided when Dual Credit is awarded.

Schools providing the credit type of `Dual Credit` and do not provide one of the post-seconday instrution IDs will fail.

CourseCompletion - 6

Error

IF Course Result (courseAttemptResultType) is "Pass" OR "Fail", AND High School Level Course is "True", THEN finalNumericGradeEarned cannot be Null or Blank

When Pass or Fail is provided a grade earned must be reported.

Students completing a high school course and receiving a result of `Pass` or `Fail` MUST have a final numeric grade (GPA) provided (0.0-4.0).

CourseCompletion - 7

Error

If High School Level Course is "True" AND Course Result (courseAttemptResultType) is "Pass" then earnedCredits must be greater than 0 AND CreditType cannot be `null` OR Blank

When Pass is reported for a High School course the Credits Earned must be greater than zero and the type of Credit Earned must be provided.

Students completing a high school course and receiving a result of `Pass` MUST have the credits earned greater than zero (0) and the type of credit earned MUST be provided. Allowable Credit Types are Regular, Dual, or Applied Unit.

CourseCompletion - 8

Exclusion

If Unique Section Code is blank or null, then exclusion

Student is reported as enrolled. No schedule or course records provided.

Students with a student school association (enrollment) record provided at any point in time during the school year would also be expected to have a schedule (student section data). Exceptions to this expectation are those students with a one day mobility record prior to the school year, students with an active ed org association for funding and ADM is 2, or service only students given enrollment with primary school `false` to have the ability to report a program association. Students may need a one day mobility record to provide course completion (student transcript) occuring over the summer and does not actually attend during the school year. Schools will be given a ten day grace period from the time of enrollment to provide student section data.

CourseCompletion - 10

Error

IF no matching StaffSectionAssociation.staffUSI is found for provided StudentSectionAssociation record, THEN fail

Student Course Completion record does not have a matching Staff Section Record. Details [Course Code, Section Code, Term]

Student schedules (student section data) must have a Staff record that matches. This is used to tie the student to the teacher. Data viewed for the match is the course code, the section code and the term the course is scheduled. If these do not align the record will fail.

CourseCompletion - 11

Error

Medium of Instruction cannot be `null` or blank

Medium of Instruction must be provided.

Medium of instruction must be provided for every course. Schools must identify if the student is being taught 1. Face-to-face (traditional classroom with teacher) 2. Technology-based instruction in classroom (sitting in a school building but taught via computer/online instruction, credit recovery as an example) 3. Virtual/Online Distance Learning (not sitting in a school building and being taught via computer/online instruction). Medium of instruction may be located in the course master and schools should confirm with their SIS vendor where the field is located for data input.

CourseCompletion - 12

Error

IF assigned Student GradeLevels from 9 through 12, and grade level match is "false" then throw Error

Subject code provided is only valid for grade levels PK-8. Details [Course Code, Section Code, Term]

Students reported with high school grade level MUST be reported with a state assigned high school course code. High school students cannot be reported with an elementary or middle school course code. Schools should check to make sure the local course is not mapped to a state identified elementary or middle school course code.

CourseCompletion - 13

Warning

IF assigned Student GradeLevels from PK through 6, and grade level match is "false" then throw Warning

HS subject codes are typically valid for students in grades 7-13. Check subject code for accuracy.

Students reported with grade levels PK - 6th and enrolled in an identified high school course will receive this warning message. Schools should check to make sure the elementary grade level student is enrolled in the accurate course and the local course is mapped to the correct state course code.

CourseCompletion - 14

Error

If High School Level Course is True AND Course Result (courseAttemptResultType) is "Pass" then Final Numeric Grade Earned must be greater than 0 AND cannot be `null` OR Blank

When "Pass" is reported for a High School course the Final Grade Earned must be greater than zero.

Students completing a high school course and receiving a result of `Pass` MUST have a final numeric grade (GPA) provided that is greater than 0.0.

CourseCompletion - 15

Error

If High School Level Course is True AND Course Result (courseAttemptResultType) is "Fail" then earned credits must be Zero AND CreditType cannot be `Null` OR Blank

When "Fail" is reported for a High School course the Earned Credit must be zero and Credit Type must be provided.

Students completing a high school course and receiving a result of `Fail` MUST have the credits earned reported as zero (0) and the type of credit the student was trying to earn MUST be provided. Allowable Credit Types are Regular, Dual, or Applied Unit.

Graduation - 1

Error

IF DiplomaLevelType is either "11", "19", "20", "21", OR "22" (Evidence-based waivers) AND the cohort year is less than 2023, THEN the AchievementCategoryDescriptor must be NULL

Graduation pathway data must not be submitted when issuing a Work Readiness Wavier Diploma.

Schools cannot report Graduation Pathway data for students in a cohort year less than 2023 AND earning one of the Work-Readiness Waiver diplomas.

Graduation - 2

Error

IF cohort year is 2023 OR after, THEN AchievementCategoryDescriptor under Employability Skills(RecognitionType) (edfi.StudentAcademicRecordDiploma) must be populated AND AchievementCategoryDescriptor under Postsecondary-Ready Competencies(RecognitionType) (extension.StudentAcademicRecordExtension) must be populated

Employability Skills and Postsecondary-Readiness Competencies are required.

Students in a cohort year 2023 or greater must also have Employability Skills and Postsecondary-Readiness Competency data reported.

Graduation - 3

Error

IF student passed both GQE test, THEN DiplomaLevelType may NOT include the following: 04, 06, 07, 11, 13, 14, 15, 18, 19, 20, 21, 22

Student passing Graduation Qualifiying Exams cannot be issued a waiver based diploma or certificate.

Students cannot be reported with a waiver based diploma or a certificate when they have passed their qualifying exams.

Graduation - 4

Error

IF student record has a DiplomaLevelType of "06" or an Alternate Diploma(23), THEN student must have their record tied to StudentSpecialEducationProgramAssociation

Student must be identified as special education to issue a Certificate of Completion or an Alternate Diploma.

Students cannot be reported with a Certificate of Completion or an Alternate Diploma if they are not or were not also identified as Special Education via the Special Education Program records.

Graduation - 5

Conflict

IF student record is submitted for `Graduation` certification, THEN only a single school corporation is permitted to have this data

Student is not counted for Graduation, multiple schools claiming student as a graduate. Conflicted with: (SchoolId)

Students cannot be reported as a graduate by multiple schools. Only one school may report the graduate information.

Graduation - 6

Warning

IF student record is submitted for `Graduation` certification AND student age is less than 16, THEN print "WARNING: Student should be at least 16 years old as of October 1st, collection year"

Student is not 16 years of age by October 1 of the graduating year. Verify student's DOB as of October 1 of graduating school year for accuracy.

Students reported as earning a diploma who are not 16 years of age will receive a warning message. This will not keep the student from being certified.

Graduation - 8

Error

IF AchievementCategoryDescriptor under PostSecondaryCompetency is NOT a Locally Created Pathway ("9")(2247), THEN the AchievementCategorySystem on the StudentAcademicRecord must default to "10000" or null

Postsecondary-Readiness Competency other than "Locally Created Pathway" does not utilize a Local Pathway.

Schools may leave Locally Created Pathway blank/null or provide 10000 when a Locally Created Pathway is not identified. Schools cannot report anything other than 10000, blank, or null when reporting any Postsecondary-Readiness Competency other than Locally Created Pathway.

Graduation - 9

Error

IF AchievementCategoryDescriptor under Employability Skill has a value,THEN AchievementCategoryDescriptor under PostSecondaryCompetency must contain a value

Postsecondary-Readiness Competency other than "N/A or Did not Demonstrate" is required when Employability Skills are provided.

Schools must provide both Postsecondary-Readiness Competency and Employability Skills data together. Schools cannot provide one data without the other.

Graduation - 10

Error

IF AchievementCategoryDescriptor under PostsecondaryCompetency is populated, THEN the AchievementCategoryDescriptor under Employability Skill must be populated

Employability Skills other than "N/A or Did not Demonstrate" is required when a Postsecondary-Readiness Competency is provided.

Schools must provide both Employability Skills and Postsecondary-Readiness Competency data together. Schools cannot provide one data without the other.

Graduation - 11

Error

IF AchievementCategoryDescriptor under PostSecondaryCompetency is Academic Honors, THEN DiplomaLevelType must be "Core 40 with Academic Honors…" (02), "Diploma Level" (24), "Core 40 with Technical Honors" (09), OR "Core 40 with Academic and Technical Honors" (16)

If Postsecondary-Readiness Competency is "Honors Diploma"  then one of the Honors Diplomas must be issued.

Schools reporting a student`s Postsecondary-Readiness Competency is Honors Diploma cannot report a diploma type earned other than 02, 09, 16, or 24.

Graduation - 12

Error

IF AchievementCategoryDescriptor under PostSecondaryCompetency is "Waiver from Postsecondary-Ready Competency" ("10"), THEN DiplomaLevelType must be either "General" ("4") OR "Core 40 Only" ("13")

Postsecondary-Readiness Competency must be "Waiver from Postsecondary-Ready Competency" when issuing a "General(Evidence Based)" or "Core 40 Only(Evidence Based)" diploma.

Schools reporting a student`s Postsecondary-Readiness Competency is Waiver from Postsecondary Readiness Competency cannot report a diploma type earned other than 04 or 13.

Graduation - 13

Error

If AchievementCategoryDescriptor under PostSecondaryCompetency is "Career-Technical Education Concentrator" ("07"), THEN there should be a "1" in either "Perkins4" OR "Perkins5"

Student with Postsecondary-Readiness Competency of "Career-Technical Education Concentrator" must be identified with either Perkins IV or Perkins V through InTERS reporting.

Students must be identified with either CTE Program association of Perkins IV or V by DWD through InTERS reporting when providing a student`s Postsecondary-Readiness Competency is Career-Technical Education Concentrator.

Graduation - 14

Error

If AchievementCategoryDescriptor under PostSecondaryCompetency is "State and Industry recognized Credential or Certification" ("05"), then there should be a "1" in the CertResult

Student with Postsecondary-Readiness Competency of "State and Industry recognized Credential or Certification" must have a Certification Result through InTERS reporting.

Students must be identified with a CTE Program association of Industry Certification by DWD through InTERS reporting when providing a student`s Postsecondary-Readiness Competency is State and Industry recognized Credential or Certification.

Graduation - 15

Error

IF DiplomaLevelTypes are "1", "2", "3", "9", OR "16", AND the cohort year is 2023 or greater THEN student must have values both in AchievementCategoryDescriptor under Employability Skills  AND AchievementCategoryDescriptor under PostsecondaryCompetency, ELSE error

Student in cohort year 2023 or later must have Graduation Pathway information provided.

Students in a cohort year equal to or greater than 2023 cannot be reported as earning any diploma without also providing Graduation Pathway information (Employability Skills and Postsecondary-Readiness Competency)

Graduation - 16

Error

IF student DiplomaLevelType CodeValue is set to "12" (International Baccalaureate Diploma), THEN school must be International Baccalaureate Program accredited

School is not approved to issue an International Baccalaureate diploma.

Schools cannot report students as earning a diploma of International Baccalaureate Diploma if they are not also identified on IDOE table as being an IB recognized school from the IB website.

Graduation - 17

Error

IF AchievementCategoryDescriptor under PostSecondaryCompetency is Locally Created Pathway ("9"), THEN the AchievementCategorySystem (LocalPathway) on the StudentAcademicRecord may only contain values "10001" through "99999" as defined on LocallyCreatedPathway table

Locally Created Pathway code is not valid.

Schools trying to report a locally created pathway number that is not approved and available from IDOE will fail. The current available list can be found here: (https://www.in.gov/doe/files/Locally-Created-Pathways-v2.pdf)

Graduation - 19

Error

IF DiplomaLevelType is either "6" or "7" THEN AchievementCategoryDescriptor must be NA or Did Not Demonstrate or Null/Blank

Employability Skills, Postsecondary-Readiness Competency, and Local Pathway should not be submitted for students earning certificates.

Students earning a Certificate of Completion or Course Completion do not have Employability Skills or Postsecondary-Readiness Competency reported.

Graduation - 20

Error

IF DiplomaLevelTypes are "1", "2", "3", "9", "16", OR "24", AND cohort year is less than 2023, THEN student must have values both in AchievementCategoryDescriptor under Employability Skills AND AchievementCategoryDescriptor under PostsecondaryCompetency, ELSE IF student cohort year < 2023 AND student passed ISTEP10 THEN OK, ELSE IF student cohort year < 2019 AND student passed ECAs, THEN OK, ELSE throw error

Student in cohort year prior to 2023 not passing Graduation Qualifying Exams cannot be issued the given Diploma Type unless Graduation Pathway information has been provided.

Students in a cohort year less than 2023 AND have not passed their qualifying exams cannot be reported as earning any diploma without also providing Graduation Pathway information (Employability Skills and Postsecondary-Readiness Competency)

Graduation - 21

Error

IF school is certifying their student data for `Graduation`, THEN the School must contain any of the following GradeLevelDescriptorIds: "09", "10", "11", "12"

Diplomas cannot be issued, school is not configured for grade levels 9 through 12.

Schools cannot report Graduate data if they are not identified as educating students in grades 9-12.

Graduation - 22

Error

If a student is less than the age of 19 and a graduate record exists, but no cohort year assignment found, then Error.

Student does not have a cohort year assigned.  Please contact schoolaccountability@doe.in.gov.

Students under the age of 19 reported with a graduate record AND does not have a cohort year assigned from School Accountability will need to contact schoolaccountability@doe.in.gov (this should be rare)

Graduation - 23

Error

IF DiplomaLevelType (from DOE table) is either NULL/Blank, then Error

Student not counted for Graduation. Diploma Type provided, yet no Diploma Level provided.

Students will not be counted when only a diploma type (regular diploma, certificate of attendance, certificate of completion, alternate diploma) is provided. Students must have both diploma types and diploma levels provided. Diploma level is the actual diploma earned.

Graduation - 24

Error

If the diploma type is evidence-based waiver (Any of the following: (04=General (Work Readiness Waiver 13=Core 40 Only (Evidence-based waiver or Waiver from Postsecondary Readiness Competency Requirements for Graduation Pathways) Then post_secondary ready competency MUST be any one of these: NA or Did Not Demonstrate, Waiver Postsecondary Readiness Competency, or NULL/BLANK.  If not, ERROR

Waiver Postsecondary-Readiness Competency must be provided when a waiver diploma type is reported.

Schools reporting a student`s diploma is 04-General (Work Readiness Waiver) or 13-Core 40 Only (Evidence-based waiver or Waiver from Postsecondary Readiness Competency Requirements for Graduation Pathways) THEN Waiver Postsecondary-Readiness Competency must be provided if student is in 2023 or greater cohort.

Graduation - 25

Error

If Diploma Type is Certificate of Completion then Diploma Level Type must be equal to 06 Certificate of Completion (IEP program Completed), else error

Diploma Level provided is not allowed when reporting a diploma type of Certificate of Completion.

Students receiving a Certification of Completion (Diploma Level) then the diploma type must be Certificate of Completion.

Graduation - 26

Error

If Diploma Type is Certificate of Attendance then Diploma Level Type must be equal to 07 (Course Completion), else error

Diploma Level provided is not allowed when reporting a diploma type of Certification of Attendance.

Students receiving Course Completion (Diploma Level) then the diploma type must be Certificate of Attendance.

Graduation - 27

Error

Students in a cohort year greater than the current year should not be eligible for a waiver diploma of any type (4,11,13,14,15,18,19,20,21,22). Students in the 2022 or later should not be eligible for a waiver.

Early graduates (i.e. students in future cohort years) are not eligible for a waiver diploma.

Students graduating prior to their cohort year cannot be reported with any of the waiver diplomas.

Graduation - 28

Exclusion

July collection: If DiplomaAwardDate is not between 10-01-[SchoolYear] – 1 and 06-30-[SchoolYear], then throw an exclusion  October collection: If DiplomaAwardDate is not between 10-01-[SchoolYear] – 2 and 09-30-[SchoolYear] - 1, then throw an exclusion

Diploma award date must be between {submission open date} and {submission close date} during this collection period

Students being certified for October must have a Diploma Award Date of 10/1 (prior school year) to 9/30 (current school year). Students being certified for July must have a Diploma Award Date of 10/1 (current school year) to 6/30 (current school year).

Graduation - 29

Error

If postsecondary-readiness competency is Alternate Assessment for Alternate Diploma then diploma level type must equal Alternate Diploma; else fail.

If Postsecondary-Readiness Competency is “Alternate Assessment for Alternate Diploma” then Alternate Diploma must be issued.

Students being reported with Postsecondary-Readiness Competency of Alternate Assessment for Alternate Diploma must have the diploma level `Alternate Diploma` reported.

Graduation - 30

Error

If Diploma Type is Alternate Diploma then Diploma Level Type must be equal to XX (Alternate Diploma), else error

Diploma level reported is not allowed with the diploma type reported.

Students receiving an Alternate Diploma  (Diploma Level) then the diploma type must be Alternate Diploma.

Graduation - 31

Error

If local pathway == 10007 and school is not Adult School, throw error

Locally Created Pathway code is not valid for the reporting Education Organization.

Students cannot be reported with Locally Created Pathway of 10007 if their diploma is not being awarded from an IDOE identified Adult Charter School.

HomeBound - 1

Informational

Beginning May 1st of the current collection year: IF studentProgramAssociation is Homebound AND Program EndDate is NULL or blank, THEN throw error

Student must be exited from Homebound/Hospitalized program when services end or no later than June 30th of the current school year.

Students identified as receiving Homebound or Hospitalized services and reported with a program association must have an exit date when the services are no longer being provided or provide June 30th (last date of the school year) if they receive services until the end of the year. The message will show as Informational until May 1st of each school year and will then show as an error until an end date is provided.

HomeBound - 2

Exclusion

IF the aggregate DayCount for that student/reportingcorp  is less than the total of 20 days, THEN EXCLUSION

Homebound student not counted. Days of services received is below the required threshold of 20 days.

Students identified as receiving Homebound or Hospitalized services and reported with a program association record or records that do not add up to 20 days of services will throw the exclusion message. The student data will be received but the student will not be counted for certification or funding purposes.

Note: There are no validations against Program Associations for High Ability, 504, Foster, Parent in Military, Homeless, and Unaccompanied Youth

Membership Enrollment - 1

Error

RULE: IF ResponsibilityTypeDescriptor is Funding, THEN student record must report an ADM Type

ADM Type is required

Check the student ed org responsibility association record or membership record to see if responsibility of Funding has been provided and if the ADM is blank. IF ADM is blank and the school expects to recieve funding then an ADM code needs to be reported. IF a school does not expect to recieve funding then the responsibility should be corrected from Funding to Attendance.

Membership Enrollment - 2

Exclusion

RULE: IF ResponsibilityTypeDescriptor is NOT Funding AND ADM Type is missing, THEN do NOT count

Student is not counted; no funding record provided. Association to the Educational Organization is Attendance only.

This is a possible accurate exclusion message if the school does not expect to receive funding and a Primary Responsibility of Attendance is reported on the student ed org responsibility association or membership record.

Membership Enrollment - 3

Warning

RULE: IF certifying for Membership, THEN Student county of residence must be populated (student).

Student’s county of residence is missing from the student record.

County is TEXT and not a code. The county name is provided on the student record with a student`s address.

Membership Enrollment - 4

Exclusion

RULE: IF student has ExitTypeWithdraw of "33" with an exit date AND does NOT have a StudentProgramAssociation with Special Ed, THEN do NOT count towards membership

Student is not counted for Membership, General Education students with exit code 33 prior to count date(s) cannot be certified for membership.

General Education Students with exit code 33 on the Student School Association (enrollment) record prior to count date(s) cannot be certified for membership.

Membership Enrollment - 5

Exclusion

RULE: IF student’s GradeLevelDescriptor is “PK”, THEN do NOT count

Student grade level is Pre-Kindergarten and is not counted towards membership.

Accurate exclusion for PK students.

Membership Enrollment - 6

Exclusion

RULE: IF student`s GradeLevelDescriptor is equal to "KG", THEN Student`s age must be 5 years of age from [edfi.Student.BirthDate] by "October 1st"

Student must be at least 5 years of age for grade level KG

Accurate exclusion if the student is not 5 years of age by October 1st.

Membership Enrollment - 7

Exclusion

RULE: IF certifying for Membership, THEN Student CANNOT have GraduationRecordType of anything other than "6" OR "7”

Student not counted. Graduate record exists.

Students who have earned a diploma and reported with graduate data cannot be reported for membership.

Membership Enrollment - 8

Error

RULES: IF ADM Type is "20", THEN `GradeLevelDescriptor` must be between "09" through "13"

ADM 20 Adult Learners must have a grade level of 09 through 13

Schools may only report ADM 20 for adult learners enrolled at an identified Adult Charter school and are in grade levels 9-13.

Membership Enrollment - 10

Error

RULE: IF ADM Type equals "2", THEN Membership Funding Corp ID must be identified as Traditional "Public" Corp ID

Reporting Corporation must be a Traditional Public Corporation ID when a student is assigned ADM 2.

Only public corporations can report ADM type 2.

Membership Enrollment - 12

Error

RULE: IF ADM Type equals "3" OR "5", THEN Funding Corporation CANNOT equal Corporation of Legal Settlement

Reporting Corporation cannot have matching Corporation of Legal Settlements for ADM 3 or 5.

COLS cannot match the corporation reporting a student for ADM 3 or 5.

Membership Enrollment - 16

Error

RULE: IF ADM Type equals "1", THEN School must be in the Funding Corporation

School ID must belong to the funding corporation OR primary responsibility of Attendance has ADM Type provided for ADM 1.

Student School Association must exist under the reporting corporation for funding when ADM 1 is provided. OR school has given ADM 1 when reporting attendance instead of funding (no ADM allowed when reporting attendance)

Membership Enrollment - 17

Error

RULE: IF ADM Type equals "3", "4", OR "5", THEN student can only be enrolled in Traditional Public School Corporation

School ID must be Traditional Public School ID when ADM is 3, 4, or 5.

Only public corporations can report ADM type 3, 4, or 5.

Membership Enrollment - 18

Error

RULE: IF ADM Type equals "1", THEN student can only be enrolled in a Traditional Public School OR Charter

ADM 1 is only for Traditional Public and Charter Schools.

Only traditional public schools or charter schools can report ADM type 1.

Membership Enrollment - 21

Error

RULE: IF ADM Type equals "6", THEN the "Traditional Public School Corporation" must report FTE at less than 50%

Student must be enrolled less than 50% of time for ADM 6.

Schools must provide instructional days and minutes for IDOE to calculate a student`s FTE and determine if the student is enrolled less than 50% and allowed for reporting ADM 6. Formula is ((Funding Instructional Days divided by 180) times Funding Instructional Minutes) divided by (Calendar Instructional Minutes divided by Calendar Instructional Days) times 1.05

Membership Enrollment - 24

Error

RULE: IF ADM Type equals "1" AND Funding Corporation is Traditional Public School Corporation, THEN Corporation of Legal Settlement must reside with its Funding Corporation

Corporation of Legal Settlement must match Reporting Corporation for ADM 1.

COLS must be the same ID as reporting corporation when reporting ADM 1.

Membership Enrollment - 25

Error

RULE: IF ADM Type equals "6" OR "20", THEN "Instructional Days" AND "Instructional Minutes" cannot be blank

Instructional Days and Minutes must be entered for ADM 6 or 20.

Schools must provide Instructional days and Instructional minutes when reporting ADM 6 for FTE calculation and when reporting ADM 20 for adult learners per statute requirements

Membership Enrollment - 26

Error

RULE: IF certifying for Membership, THEN Corporation of Legal Settlement must reside with Traditional Public School Corporation.

Corporation of Legal Settlement is either missing or is not reported as a Traditional Public School Corporation ID.

Corporation of Legal Settlement is missing or is not reported as a public LEA ID.

Membership Enrollment - 27

Error

RULE: IF LocalEducationAgencyCategoryType is "Charter", THEN ONLY ADM Type of "1", "6", OR "20" is allowed

Charter Schools may only use ADM types 1, 6, or 20. ADM 20 is for Adult Learner Charter Schools only.

Charter schools may only provide ADM 1 or 6 on students. Identified Adult Charter schools may only provide ADM 20 on students.

Membership Enrollment - 28

Error

RULE: IF ADM Type equals "1", "2", "3", "4", "5", "6", OR "10", THEN GradeLevelDescriptors must be between "KG" through "13"

ADM 1, 2, 3, 4, 5, 6, or 10 only allows grade levels KG through 13.

Schools can report any ADM except 20 on students in grade levels KG-13 (20 is for students in grade 9-13)

Membership Enrollment - 30

Error

RULE: IF ADM Type equals "10", THEN School `ChoiceIndicator` must equal "Choice"

ADM 10 is used only for Choice Voucher Schools.

NonPublic Schools not identified as participating in the Choice program cannot report ADM 10

Membership Enrollment - 32

Conflict

RULE: If a student has two StudentSchoolAssociation records with overlapping Entry/ExitDates on Census date and both are PrimaryResponsibily= true, then conflict.

Student not counted. Multiple schools claiming student for funding. Conflicted with: (SchoolId) - (Entry Date) - (Exit Date)

Conflict is on the Student School Association (enrollment) dates either the same entry/exit date or overlapping entry/exit dates.

Membership Enrollment - 34

Exclusion

RULE: IF certifying for Membership, THEN students must be enrolled in a school identified within the StudentSchoolAssociation denoting the EntryDate prior to counts AND ExitWithdrawDate after counts

Student not counted for Membership, inactive enrollment record on count date

Students must have a Student School Association (enrollment) record with entry date prior to count date(s) and no exit date provided or an entry date prior to count date(s) with the exit date after the count date(s) to be considered an active enrollment for membership.

Membership Enrollment - 35

Error

RULE: IF ADM Type 1, 3, 4, 5, 10, or 20 AND the ResponsibilityType is Funding, THEN student`s Primary School must be TRUE

Primary School must be true for ADM Types 1, 3, 4, 5, 10, and 20.

Primary school on School Association (enrollment) record must be true for ADM 1, 3, 4, 5, 10, and 20.

Membership Enrollment - 36

Error

RULE: IF ADM Type equals 6 AND only one Funding ResponsibilityType exists, THEN student`s Primary School must be FALSE

Primary School must be false when ADM is 6 when only one enrollment record is reported.

Primary school on School Association (enrollment) record must be false for ADM 6 when there is no other enrollment record. (homeschool dual enrolled student)

Membership Enrollment - 37

Error

RULE: IF Funding ResponsibilityTypes exists for both ADM Type 6 AND 10, THEN Primary School for ADM 6 must be FALSE AND Primary School for ADM 10 must be TRUE

When dual enrollment is reported, Primary School must be false for ADM 6 and true for ADM 10.

Primary school on School Association (enrollment) record for public school with ADM 6 must be false and Primary school on School Association (enrollment) for non-public school with ADM 10 must be true.

Membership Enrollment - 38

Error

RULES: IF ADM Type equals “10”, THEN Choice Scholarship application must be present and approved for the given student

ADM 10 is only for Choice Voucher students.

Student must have approved scholarship in App Center and provided across to Data Exchange (jeff/david garner)

Membership Enrollment - 39

Error

IF ADM type = 20 THEN edfi.schoolcategory.schoolcategorytypeID must be "2" or "28"

ADM 20 is for Adult Learner Schools only.

Adult Charters are the only ones allowed to use ADM 20.

Membership Enrollment - 40

Error

Student with grade level KG cannot be reported as dual enrolled

Student with grade level KG cannot be reported as dual enrolled.

Students with any of the KG grade levels cannot be reported with ADM 6 (dual enrolled)

Membership Enrollment - 41

Error

RULE: IF ADM Type equals "2" THEN student`s Primary School must be FALSE

Primary Educating School must be False when reporting ADM type 2-Transfer Out.

Primary school on School Association (enrollment) must be false for ADM 2.

Membership Enrollment - 42

Error

IF ADM Type equals "6 or 20" AND reporting ed org ID is Choice identified school THEN fail

ADM types 6 and 20 is not allowed for Choice scholarship students.

NonPublic Schools identified as participating in the Choice program cannot report ADM 6 or 20

Membership Enrollment - 43

Error

IF certifying for Membership THEN Accountability must be provided.

Accountability School must be provided.

Schools must provide the additional responsibility of Accountable School

Membership Enrollment - 44

Exclusion

student claimed must be age 22 years or less on each census/count date

Student must be at 22 years of age or younger on the Census Date

Students over the age of 22 cannot be certified for membership (unless in an adult charter school)

Membership Enrollment - 45

Warning

If the program type isn`t virtual, and the total of virtual days is over 50% for that record, then it will throw an exclusion.

Student counted for Membership. Verify data is accurate as virtual days does not meet threshold for virtual program.

Student does not have enough virtual attendance data reported to support the virtual program.

Membership Enrollment - 46

Error

If the program type isn`t virtual, and the total of virtual days is over 50% for that record, then it will throw an exclusion.

Student not counted for Membership. Virtual days exceeds threshold for non-virtual program.

Student does not have the virtual program record reported to support the virtual attendance data.

Membership Enrollment - 47

Error

If no attendance records found for student, then do not count towards membership.

Student not counted for Membership. Attendance records could not be found or Calendar Dates do not exist.

Schools must have a calendar and calendar dates provided. Schools must have attendance data provided prior to the count date(s).

Membership Enrollment - 48

Conflict

Cannot have records of funding for a student at different schools (except for when one school has ADM 6 and the other has 10).

Student not counted. Multiple schools claiming student for Membership with conflicting ADM Types. Conflicted with: (SchoolId) - (Entry Date) - (Exit Date)

Schools claiming a student for funding with different or matching ADM codes will get this conflict message. This is not on the enrollment data but on the funding record where the begin/end dates of the funding record match or overlap. Only ADM 6 and 10 are allowed by two reporting schools. Cannot have ADM 1 and 5, 1 and 3, 1 and 1, etc.

MultilingualLearners - 1

Error

IF StudentProgramAssociation has Foreign Exchange as a ProgramType, THEN Birth Country cannot equal "USA"

Student cannot be identified as Foreign Exchange, birth country is not outside of the US or US territories.

Students with their birth country reported as USA or one of the US territories cannot be reported as Foreign Exchange.

MultilingualLearners - 2

Conflict

IF certifying for MultilingualLearners, THEN only one school can claim LM for the student for the current collection year

Student not counted. Multiple schools claiming student. Conflicted with: (SchoolId) - (Entry Date) - (Exit Date)

Multiple schools cannot claim a student for Multilingual certification. While programs are not ended when a student exits only one school may be identified as claiming the student. Student school association (enrollment) records cannot be in conflict.

MultilingualLearners - 3

Exclusion

IF student is certifying for LM, THEN student`s LanguageDescriptor may NOT be "211" ("English") AND NonUSOrigin may NOT be “NO” with the exception of dual language/immersion program.

Student is not counted for Multilingual Learners when language code is English and program is not Dual Language/Immersion.

Students with a language code of 211 (English) can only be associated to Dual Language/Immersion program. All other multilingual program associations will fail.

MultilingualLearners - 4

Warning

IF student`s LimitedEnglishProficiencyDescriptor from previous year does NOT match the overall proficiency level in the WIDA result table from one prior year, THEN print warning message

Student's Proficiency Level does not match overall proficiency level from prior year WIDA assessment - verify data for accuracy.

Students with a prof. level determined from WIDA in the prior assessment year does not match what is being reported by the school will receive this warning. Schools should make sure the prof. level being provided is accurate. IDOE will accept the prof. level that is being reported.

MultilingualLearners - 5

Warning

IF student`s LimitedEnglishProficiencyDescriptor from previous year is between 5.0 and 6.0 OR FNA AND the LimitedEnglishProficiencyDescriptor reported for the current year is 4.9 and under, THEN print warning message

Student was previously reported as proficient, verify data for accuracy.

Students reported as previously proficient and have been reassessed and receive a lower or non-proficient score will receive this warning. Schools should verify the data being provided on the student for accuracy as IDOE will update the prof. level to what has been reported.

MultilingualLearners - 6

Error

IF student`s LimitedEnglishProficiencyDescriptor Proficiency Level HAS VALUES from previous year and proficiency level is not 8, THEN EllInstrumentUsedDescriptor must be "5" ("WIDA ACCESS for ELLs") OR "10" ("WIDA Alternate ACCESS")

Instrument used must be WIDA Access or WIDA Alternate Access when WIDA prior year proficiency levels exist.

Students who have WIDA assessment results from the prior school year must have instrument used reported as WIDA Access or WIDA Alternate Access.

MultilingualLearners - 7

Exclusion

IF certifying for LM AND student GradeLevelDescriptor is "PK", THEN student`s age must be between the ages 3 and 5 by COUNTDATE

Student not counted for Multilingual Learners, age must be at least 3 years of age and not older than 5 years as of count date for grade level PK.

Students must be at least 3 years of age and not older than 5 years of age on count date to be reported in grade level PK for multilingual learner certification.

MultilingualLearners - 8

Exclusion

IF certifying for LM THEN studentProgramAssociation must denote an EntryDate prior or equal to count date AND an ExitWighdrawDate equal to or after count date or NULL

Student not counted for Multilingual Learners, no valid Multilingual Learners program record provided.

Student not counted for English Learner, inactive enrollment record on count date.

MultilingualLearners - 9

Exclusion

IF certifying for LM, student`s age must be greater than or equal to "3" OR less than or equal to "21" as of COUNTDATE

Student not counted for Multilingual Learners, age must be 3 to 21 as of count date.

Students must be at least 3 years of age and no more than 21 years of age on count date to be counted for multilingual certification.

MultilingualLearners - 10

Warning

IF EllInstrumentUsedDescriptor is WIDA ACCESS for ELLs ("5") AND does NOT have a WIDA result from the data warehouse, THEN throw warning AND print "Please verify locally that student has a WIDA Access score"

Student Proficency Level is not found from prior year Indiana WIDA ACCESS assessment. Verify data for accuracy.

Schools providing WIDA access as the instrument used to obtain the prof. level being reported when IDOE has no record of the WIDA assessment results will receive this warning. Schools need to verify the correct instrument used is being reported. WIDA results could have been provided from assessment taken in another state.

MultilingualLearners - 11

Exclusion

IF student is certifying for LM AND LimitedEnglishProficiencyDescriptor ProficiencyLevel is "8" ("No assessment and student no longer available."), THEN print `Informational` message stating "Federal law requires that 100% of EL students be assessed annually for English language proficiency. The IDOE monitors the assessment of English learners and may reach out for additional information as to why the student was not assessed as required."

Student not counted - Federal law requires that 100% of EL students be assessed annually for English language proficiency. The IDOE monitors the assessment of Multilingual Learners and may reach out for additional information as to why the student was not assessed as required. This applies to students with Proficency Level 8.

Students reported with prof. level 8 will receive this message and will not be counted for multilingual certification. Schools need to verify the data is accurate and remaining compliant with providing annual assessments to non-English speakers.

MultilingualLearners - 12

Error

IF student`s EllInstrumentUsedDescriptor is "7" ("N/A"), THEN LimitedEnglishProficiencyDescriptor must be "FNA", "NES" OR "0"

Student Profiency Level of FNA, NES, or 0 can only utilize Instrument Used - N/A.

Student Profiency Level of FNA, NES, or 0 can only utilize Instrument Used - N/A.

MultilingualLearners - 13

Error

IF student`s GradeLevelDescriptor is "PK", THEN LimitedEnglishProficiencyDescriptor code value must be "0" and must have a valid birth country ("Immigrant Student who is PK or PK student's birth country is missing")

Student's born outside of USA with grade level of PK must have Proficiency level of 0 - Immigrant Student who is PK; or PK student's birth country is missing.

Students with grade level PK and birth country is outside of the US or US territories must have prof. level 0 provided. Students with grade level PK and prof. level of 0 provided with the birth country data missing will also receive this error.

MultilingualLearners - 14

Error

IF student`s GradeLevelDescriptor is anywhere from "KG" through "13", THEN the LimitedEnglishProficiencyDescriptor CANNOT be "0"

Student grade levels of KG to 13 cannot have Proficiency level of 0.

Student reported with grade levels of KG to 13 cannot have their prof. level reported as 0.

MultilingualLearners - 15

Error

IF student`s LimitedEnglishProficiencyDescriptor is NES ("Native English Speaker"), THEN Birth Country cannot be "USA"

Student with Proficiency Level of NES must have birth country outside of the US or US territories.

Students reported with prof. level of NES cannot have their birth country reported as USA or one of the US territories.

MultilingualLearners - 18

Error

If language code is reported other than English (no English is being reported), and no ProgramType of "English Language Learner" exists, then Error

Student not counted for Multilingual Learners. English Language Learner program does not exist or student language not provided.

Students reported with a non-English language code should have a multilingual program association record even when they are fluent. Either the student`s language code is incorrect or a program association needs to be added.

MultilingualLearners - 19

Error

If a student has an English Learner program and the proficiency level that they report is NULL, then exclude.

Student not counted for Multilingual Learners, Proficiency Level not found.

Students reported with a multilingual program must have a prof. level provided. Either the program is in error or prof. level needs to be provided.

Non Certified Educator - 1

Error

edfi.School must be "Public"

Non-certified staff cannot be certified at a non-public school.

Only public/charter schools report Other Personnel data.

Non Certified Educator - 2

Error

IF certifying for Non-Cert Staff,  the following fields: FullTimeEquivalency, LocalEducationAgencyId, OtherPersonnelCategoryDescriptorId, OtherPersonnelCount, AND OtherPersonnelTitleDescriptorId found under the extension.EducationOrganizationOtherPersonnel table are required

Non-Certified (other personnel) categories, titles, counts, and FTE data are required.

Each data field must be provided on the template.

Non Certified Educator - 3

Error

When OtherPersonnelCount is greater than 0 then FullTimeEquivalency must be greater than 0

When OtherPersonnelCount has a value, FTE must have a value.

If the counts in the personnel column is more than 0 (zero) then the FTE column must be more than 0 (zero).

Non Certified Educator - 4

Error

When FullTimeEquivalency is greater than 0 then OtherPersonnelCount must be greater than 0

OtherPersonnelCount must have a value if FTE has a value.

If the FTE column is reported more than 0 (zero) then the personnel column must be more than 0 (zero).

PupilEnrollment - 1

Exclusion

IF certifying for Pupil Enrollment AND Primary School is TRUE, THEN count. ELSE ignore record.

Student is not counted for Pupil Enrollment, primary school is false.

Student School Association (enrollment) record has the school identified as `false` and this could be an accurate message if the enrollment record is correct.

PupilEnrollment - 2

Error

IF student is certifying for Pupil Enrollment, THEN GradeLevelDescriptors from PK to 13 are accounted for

Invalid grade value

Grade level might be reported without leading zero. Only PK -13 is allowed.

PupilEnrollment - 3

Conflict

IF PE student has two Primary School indicators equating to "True" on StudentSchoolAssociation on OR before census date, THEN throw conflict

Student is not counted for Pupil Enrollment, multiple schools claiming student for enrollment. Conflicted with: (SchoolId) - (Entry Date) - (Exit Date)

Conflict is on the Student School Association (enrollment) date either the same entry/exit date or overlapping. There is no dates on the Ed Org record.

PupilEnrollment - 5

Exclusion

Students must have an active SSA before or on Census Date to be certified/counted

Student not counted for Pupil Enrollment, inactive enrollment record on the census date.

Student School Association must have enrollment date on or before count date and not prior to the first calendar date.

SpecialEducation - 1

Error

IF Special Education Program Association equals "56" (Parentally placed in private school) OR "38" (Parentally placed in private preschool), THEN public schools CANNOT be given "TRUE" as Primary Schools

Public school cannot be the primary school for students reported as parentally placed in a private school setting.

Students attending a nonpublic school and only have an enrollment record to create a relationship for special education program reporting must have their primary school identified as `false`.

SpecialEducation - 2

Exclusion

IF student`s age is 23 years on OR after July 1st, THEN do not count towards Special Education Program

Student not counted for Special Education, student is older than 22 years of age by count date.

Students cannot be 23 years of age and still receiving special education services.

SpecialEducation - 3

Exclusion

IF student is NOT 3 years old OR older by count date, THEN special ed funds will not be applied to student.

Student not counted for Special Education, student is not 3 years of age by December 1st.

Students less than 3 years of age cannot be reported for special education funding. The student can be reported but they will not generate funding.

SpecialEducation - 4

Exclusion

IF certifying for Special Education AND ProgramType is Special Education, THEN SpecialEducationProgramAssociation must denote an EntryDate prior to or on count date AND an ExitWithdrawDate after or on count date.

Student not counted for Special Education, inactive enrollment record on count date.

Students without a special ed program record that is not considered `active` (meaning begin date is prior to count date with no exit date or exit date is after the count date) will not be counted for certification.

SpecialEducation - 5

Error

IF student`s Primary Exceptionality is code 8 (Developmental Delay), THEN student`s age must be younger than 9 years by December 1st.

Primary Exceptionality Code 8 (Developmental Delay) cannot be reported for a student at the age of 9 as of December 1st.

Students older than 9 years of age on 12/1 cannot be reported with their primary disability of Developmental Delay.

SpecialEducation - 6

Error

IF student`s Secondary Exceptionality is code 8 (Developmental Delay), THEN student`s age must be younger than 9 years by December 1st.

Secondary Exceptionality Code 8 (Developmental Delay) cannot be reported for a student at the age of 9 as of December 1st.

Students older than 9 years of age on 12/1 cannot be reported with their secondary disability of Developmental Delay.

SpecialEducation - 7

Error

IF student is 5 years of age (OR LESS) by count date AND grade level is PK, THEN Special Education Program Association must be either of the following: 26, 27, 28, 29, 33, 34, 35, 36, 37, 38

Student's Program Association is not valid with student's age and/or grade level.

Students reported with grade level PK and are 5yrs old or less on count day must be associated to special ed program of Regular Early Childhood, at least 10 hours; Regular Early Childhood, at least 10 hours, Other Location; Regular Early Childhood, less than 10 hours; Regular Early Childhood, less than 10 hours, Other Location; Special Education Program, Separate Class; Special Education Program, Separate School; Special Education Program, Residential Facility; Other Servcies at Provider Location; Other Services at Home; or Private Preschool

SpecialEducation - 8

Error

IF a student has a Special Education Program Association to 26, 27, 28, OR 29, THEN only the following Special Education Settings (Location Codes) are allowed: 01 (Community-Based Preschool/Head Start), 02 (Medical/Mental Health Placement), 04, 06, 09 (Private Vendor), 10 (Non-Public School) OR may remain BLANK

Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.

Students reported with special ed program of Regular Early Childhood, at least 10 hours; Regular Early Childhood, at least 10 hours, Other Location; Regular Early Childhood, less than 10 hours; or Regular Early Childhood, less than 10 hours, Other Location can only have location codes of 01, 02, 04, 06, 09, 10, or blank reported.

SpecialEducation - 9

Error

IF a student has a Special Education Program Association to 33, 34, OR 35, THEN only the following Special Education Settings (Location Codes) are allowed: 02 (Medical/Mental Health Placement), 04, 09 (Non-Public School) OR may remain BLANK

Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.

Students reported with special ed program of Special Education Program, Separate Class; Special Education Program, Separate School; Special Education Program, Residential Facility can only have location codes 02, 04, 06, 09, or blank reported.

SpecialEducation - 10

Error

IF a student has a Special Education Program Association to 36 (Receiving majority of hours at service provider or some other location), THEN the use of Special Education Settings (Location Codes) are NOT allowed

Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.

Students reported with special ed program of Other Services at Provider Location cannot have a location code reported. This must be blank/null.

SpecialEducation - 11

Error

IF a student has a Special Education Program Association to 37 (Receiving majority of hours at home), THEN only the following Special Education Settings (Location Codes) are allowed: 01 (Community-Based Preschool/Head Start), 02 (Medical/Mental Health Placement), 04 (Court-ordered Placement), OR may remain BLANK

Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.

Students reported with special ed program of Other Services at Home can only have location codes 01, 02, 04, or blank reported.

SpecialEducation - 12

Error

IF a student has a Special Education Program Association to 38 (Parentally placed in private preschool), THEN the Special Education Setting (Location Codes) must be 10 (Non-Public School)

Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.

Students reported with special ed program of Private Preschool can only have location code 10 reported.

SpecialEducation - 13

Error

IF a student has a Special Education Program Association to either 50-57, THEN only students from grade levels KG through 13 that is also 22 years of age or younger by July 1st (of reporting year) OR grade level PK that is between the ages of 6 and 22 are to be counted

Student's Program Association is not valid with student's age and/or grade level.

Students reported in grade levels KG-13 and are less than 22 years of age by July 1st; students reported in grade level PK and are 6 years of age must be associated to special ed program of Regular Classroom (80% or more); Resource Room (40%-79%); Separate Class (less than 40%); Separate Day School Facility (+50%); Residential Facility (+50%); Correctional Facility; Parentally placed in Private School; or Student`s disability requirees home services

SpecialEducation - 14

Error

IF a student has a Special Education Program Association to 50, 51, 52, 53, OR 54, THEN only the following Special Education Settings (Location Codes) are allowed: 02 (Medical/Mental Health Placement), 04, 06, 09 (Private Vendor), 10 (Non-Public School) OR may remain BLANK

Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.

Students reported with special ed program of Regular Classroom (80% or more); Resource Room (40%-79%); Separate Class (less than 40%); Separate Day School Facility (+50%); Residential Facility (+50%) can only have location codes 02, 04, 06, 09, 10, or blank reported.

SpecialEducation - 15

Error

IF a student has a Special Education Program Association to 55 (Correctional facility), THEN the Special Education Setting (Location Codes) must be 04

Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.

Students reported with special ed program of Correctional Facility can only have location code 04 reported.

SpecialEducation - 16

Error

IF a student has a Special Education Program Association to 56 (Parentally placed in private school), THEN the Special Education Setting (Location Codes) must either be 10 (Non-Public School) OR 03 (Homeschool)

Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.

Students reported with special ed program Parentally placed in Private School can only have location codes 03 or 10 reported.

SpecialEducation - 17

Error

IF a student has a Special Education Program Association to 57 (Home services determined by CCC), THEN the Special Education Setting (Location Codes) must be 02 (Medical/Mental Health Placement), 04, OR may remain BLANK

Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.

Students reported with special ed program Student`s disability requires home services can only have location codes 02 or 04 reported.

SpecialEducation - 18

Exclusion

IF a Student has a program association as "Undefined"  as of the count date, exclude record

Student not counted for Special Education. Student's program association is 'Undefined'.

Students who are in the evaluation process and have the program identified as `Undefined` will not be counted for SE certification.

SpecialEducation - 19

Exclusion

IF IDEA Eligibility is false, THEN Exlcude record

Student has not been reported as eligible for IDEA services as of the count date.

Students with special ed program records where eligibility is reported as "False" will not be counted for SE funding.

SpecialEducation - 20

Exclusion

When SchoolId is Non-pub and Program Type is Special Education and Program Name is Choice Voucher AND SpecialEducationStatus is Null or Public is identified in doe.ChoiceScholarshipStudents, then exclusion

Student not counted for Special Education, student not identified for Special Education Choice Voucher Program.

Students who were not identified at the time of submitting the choice scholarship application has receiving all services from the nonpublic school only cannot be reported for special education funding by the nonpublic school participating in the Choice program.

SpecialEducation - 22

Error

If Primary Exceptionality is null or empty and program name is not undefined, throw error

A primary exceptionality must be provided.

Students reported with an active SE program record as receiving services must have a primary exceptionality provided.

SpecialEducation - 23

Warning

If Student has multiple Special Ed program associations without end dates, throw conflict. (Schools can conflict with self)

Student not counted. Multiple schools reporting Special Education program or claiming student for Special Education funding. Conflicted schools: (SchoolId) - (Entry Date) - (Exit Date)

Multiple schools cannot claim a student for Special Education certification. This includes multiple schools within the same corporation ID. Students may only have one active program record associated to them for certification.

SpecialEdEvaluation - 1

Warning

IF certifying for Special Education Eval and student has two different Referral ParentalConsentDates, THEN throw informational message

STN submitted with two different Parental Consent Dates. Verify this student had two different Initial evaluations.

Students may have more than one parental consent (referral) date provided if the initial evaluations are for different reasons. This is for information purposes only and schools should make sure the different dates are accurate.

SpecialEdEvaluation - 2

Error

IF certifying for Special Education Eval and TimelineCompliance is "00", THEN a response to IDEAEligibility is required

IDEA Eligibility (student eligiblity) status must be provided.

Schools must provide IDEA eligibility of `True` or `False` if a student`s initial evaluation was during the reporting timeframe and the timeline compliance has been reported as `00` = timeline was met.

SpecialEdEvaluation - 3

Error

IF student has a Referral ParentalConsentDate, THEN CaseConferenceDate (IEPReviewDate) has to be on OR later date (allow null/blank for IEP review date=has not happened yet)

Case Conference (IEP Review) date cannot be prior to the Parental Consent Date.

Schools cannot report a Case Conference date prior to the parental consent (referral) date.

SpecialEdEvaluation - 4

Error

IF a ParentalConsentDate is given AND TimelineCompliance is "00", THEN a CaseConferenceDate (IEPReviewDate) is required

Case Conference (IEP Review) must be submitted when Timeline Compliance is met.

Schools must provide a Case Conference date when the timeline compliance code reported is `00` = timeline was met.

SpecialEdEvaluation - 5

Error

IF CaseConferenceDate (IEPReviewDate) is given, THEN response to IDEAEligibility is required (true/false)

IDEA Eligibility is required when Case Conference Date (IEP Review Date) is provided.

Schools must provide IDEA eligibility of `True` or `False` if a student`s case conference date has been provided.

SpecialEdEvaluation - 6

Error

IF Circumstances (RelevantToTimelineDescriptor) is "1", "2", OR "4", THEN FirstStepsTransitionDate must be blank/null

Student cannot have a First Steps Transition date when Circumstances Relevant to Timeline is 20 or 50 days.

Schools cannot provide a First Steps Transition date when the circumstances relevant to the timeline is not a `3` = Preparation for Transfer from First Steps.

SpecialEdEvaluation - 7

Error

IF Circumstances (RelevantToTimelineDescriptor) is "3", AND IDEAEligibility equals "True" THEN FirstStepsTransitionDate must be provided AND TimelineCompliance must be either "00", "01", "07", or "99".

Student transitioning from First Steps must have Date and Timeline Compliance of "00", "01", "07", "09" or "99".

Schools must provide a Timeline Compliance code of 00 = timeline was met, 01 = parents refues services for student transitioning from First Steps, 07 = timeline missed, third birthday occurs during school break and no ESY, 09 = timline missed, First Steps referral late, or 99 = timeline missed, other reason when the IDEA eligibility is reported as `True` and the circumstances relevant to the timeline is `3` = Preparation for Transfer from First Steps.

SpecialEdEvaluation - 8

Error

IF Circumstances (RelevantToTimelineDescriptor) is "1", "2", OR "4", AND IDEAEligilbility equals "True" or "False" THEN TimelineCompliance must be either "00", "03", "05", "08", or "99".

When Circumstances to Timeline is 20 or 50 days and eligibility is determined, the Timeline Compliance must be "00", "03", "05", "08" or "99".

Schools must provide a Timeline Compliance code of 00 = timeline was met, 03 = student withdrew from school during the evaluation process, 05 = parent revoked consent for testing, 08 = timeline missed, parent refused to bring student in for evaluation, or 99 = timeline missed, other reason when the IDEA eligibility is either `True` or `False` and the circumstances to the timeline is 1, 2, or 4 (20 or 50 day timelines).

SpecialEdEvaluation - 9

Exclusion

IF referral (parental consent) to EOY (student instructional) days is less than to 50 AND Case Conference date is NULL/BLANK AND Circumstances (RelevantToTimeline) = 4; THEN exclude

Student not counted for Special Education Evaluation. Initial evaluation pending 50 day timeline.

Students will not be counted for SE evaluation if the parental consent (referral) date does not allow for enough time to complete the evaluation before the school year ends when the circumstances relevant to timeline is 4 = All other, 50 instructional day timeline.

SpecialEdEvaluation - 10

Exclusion

If referral (parental consent) to EOY (student instructional) days is less than to 20 AND Case Conference date is NULL/BLANK AND Circumstances (RelevantToTimeline) = 1 or 2; THEN exclude

Student not counted for Special Education Evaluation. Initial evaluation pending 20 day timeline.

Students will not be counted for SE evaluation if the parental consent (referral) date does not allow for enough time to complete the evaluation before the school year ends when the circumstances relevant to timeline is 1 = 20 instructional days due to implementation of Response to Intervention or 2 = instructional days due to disciplinary action

SpecialEdEvaluation - 11

Exclusion

IF student`s Age is less than 3 years on the census date (June 30) AND Case Conference date is NULL/BLANK AND Circumstances (RelevantToTimeline) = 3; THEN exclude.     (A student cannot transition from first steps until the day of their third birthday)

Student not counted for Special Education Evaluation. Initial evaluation pending Preparation for transfer from First Steps day timeline.

Students who have not turned 3 years of age by June 30th will not be included for SE-Evaluation certification when they are transitioning from first steps.

SpecialEdEvaluation - 13

Error

IF ParentalConsentDate is greater than or equal to July 1st, (Collection Year - 2)  AND Circumstances (RelevantToTimeline) is NULL/Blank, THEN throw error

Student not counted for special education evaluation. Circumstances to timeline must exist when parental consent date is within the last two school years.

Students with a parental consent (referral) date of July 1st older than two school years ago and the circumstances relevant to the timeline is blank will not be counted for SE-Evaluation. Schools should make sure the parental consent date is accurate and/or the circumstances relevant to the timeline is provided accurately.

SpecialEdTermination - 1

Error

IF ReasonExited is "13", THEN student`s age (on the termination date) must be greater than or equal to 22 AND less than 23

Termination Exit Reason of 'Reached Maximum Age of 22' is invalid. Student's DOB shows age is less than 22 on date of termination.

Students who are less than 22 years of age cannot be reported as terminated from special education services with reason exited code 13 - Reached Maximum Age of 22. Schools should check the DOB of the student.

SpecialEdTermination - 2

Error

IF ReasonExited is "11", THEN student must have a DiplomaLevelType NOT equal to "06" OR "07"

Termination Exit Reason of 'Graduated with High School diploma' is invalid. Student does not have a graduate record earning a diploma submitted.

Students must have a graduate record with a diploma type of regular and any diploma level other than certificate of completion or course completion when reporting reason exited code 11- Earned High School Diploma for special education termination.

SpecialEdTermination - 3

Error

IF ReasonExited is "14" (Deceased),  THEN ExitWithdrawTypeDescriptor must be "21"

Termination Exit Reason of 'Deceased' is invalid. Student does not have a matching enrollment record exit date and exit code of 21.

Students must have an exit withdraw code of 21 (Deceased) on the student school association (enrollment) record when reporting reason exited code 14 - Deceased.

SpecialEdTermination - 4

Error

IF ReasonExited is 15 (Dropout), THEN ExitWithdrawTypeDescriptor must be "01, 02, 03, 05, 10, 12, 13, 14, 15, 16, 17, 18, 26, 30 or 35"

Termination Exit Reason of Dropout is invalid. Student does not have a matching enrollment record exit date and exit code of 01, 02, 03, 05, 10, 12, 13, 14, 15, 16, 17, 18, 26, 30 or 35.

Students must have an exit withdraw code of 01, 02, 03, 05, 10, 12, 13, 14, 15, 16, 17, 18, 26, 30, or 35 on the student school association (enrollment) record when reporting reason exited code 15 - Dropout. Each of the exit withdraw codes are considered dropout codes.

SpecialEdTermination - 5

Error

IF ReasonExited is "12" (Received Certificate), THEN student must have a diplomaLevelType equal to "06" OR "07"

Termination Exit Reason of 'Received Certificate' is invalid. Student does not have a graduate record earning a certificate.

Students must have a graduate record with a diploma type of certificate of attendance or certification of completion and a diploma level of 06 or 07 when reporting reason exited code 12- Received Certificate for special education termination.

SpecialEdTermination - 6

Error

IF ReasonExited is 1 (Transferred to Regular Education) AND ExitTYpe is NOT "33" OR "50", THEN ExitDate is prior to the termination date. (BLANK/NULL doesn`t trigger)

Termination Exit Reason of 'Transferred to Regular Education' is invalid. Student does not have a current active enrollment record OR has an enrollment record with an exit date prior to the Termination date.

Students CANNOT have an exit withdraw code prior to the special education termination date when the reason for termination is code 1 - Transferred to Regular Education. Schools cannot state a student is transferred to regular education when they show the student has exited their school prior to the termination date for any other reason. This allows schools to show the student is no longer receiving services but are still enrolled and attending the school.

SpecialEdTermination - 7

Error

IF prior graduate record exists for the student THEN ReasonExitedDescriptor must be a 1, 11 or 12.

Termination Exit Reason must be 'Earned High School Diploma' or 'Received Certificate' when a Graduate record exists.

Schools must provide a termination date and reason exited code of 11 or 12 when they have provided a `Certified` graduate record with a diploma award date prior or equal to the special ed program termination exit date. Students reported with termination reason 1 = returned to regular education will not trigger this message.

SpecialEdTermination - 9

Error

If reason exited descriptor is not 1, 11, 12, 13, 14, 15, 16, 17, or 99 then error.

Reason exited is not allowable for Special Education Termination reporting.

Schools can only provide the termination reason exited codes of 1, 11, 12, 13, 14, 15, 16, 17, 99 (associated to special education) Need to add additional exit reason code for Alternate diploma once created.