Alternative Education
Rule # | Rule Type | Rule Logic | Rule Message | Notes |
AlternativeEducation - 1 | Error | If ReasonExited = 11 (Earned a High School Diploma), then a doe.graduation record must exist and DiplomaType must equal Regular Diploma | Student must have a graduate record earning a high school diploma when reporting ReasonExited (formerly Outcomes) as 11 (Earned a High School Diploma). | Schools must provide a graduate record when providing a reason exited code 11-Earned High School Diploma as the 'outcome' from Alternative Education and the diploma must be any of the Regular Diploma types. |
AlternativeEducation - 2 | Conflict | IF student has multiple active Alt Ed Program associations within the Reporting Corporation with overlapping Begin/End dates, THEN Conflict | Student cannot have multiple enrollments in different program IDs with overlapping dates within the same corporation. | Students will create a conflict if they are reported with more than one program record where the program begin/end dates overlap. Students will not be counted for certification. |
AlternativeEducation - 3 | Error | If GradeLevels of PK through 5, then error | Student must be in grades 6 - 13 for enrollment in Alternative Education. | Students in grades PK - 5 cannot be reported with an alternative education program association record. |
AlternativeEducation - 4 | Error | If the alternativeEducationEligibilityReasonDescriptor is blank/null, then error. | Student's eligibility must be provided when an entry date in Alternative Education program is provided. | Schools must provide on of the eligibility reasons when reporting a student with an alternative education program association record. |
AlternativeEducation - 5 | Error | When an EndDate for the Alt Ed Program exists, THEN only the following ReasonExitedDescriptor are allowed: 02, 03, 04, 05, 06, 07, 10, 11, 14. Otherwise Error | Student's outcome must be provided when an exit date in Alternative Education Program is provided. | Schools must provide one of the reason exited codes (outcomes) when an end date is provided to the alternative education program association record. |
AlternativeEducation - 6 | Error | IF certifying student for Alt Ed, THEN Program BeginDate/EndDate must be within current school calendar year (7/1 through 6/30). | Student must have entry/exit dates of 7/1 to 6/30 in the reporting school year. | Alternative Education program records cannot be provided outside of 7/1 to 6/30 or each reporting school year. |
AlternativeEducation - 7 | Error | Day Count must be less than 10 consecutive student instructional days. Otherwise, error | Alternative Education student not counted. Days enrolled in the program are less than 10 consecutive instructional calendar dates. | Students with an alternative education program record showing they have been enrolled in the program less than 10 consecutive student calendar days will not be certified for Alt-Ed reporting. |
AlternativeEducation - 8 | Error | If ALL three meeting times (Morning, Afternoon, and Evening Meeting Times) are blank/null, then error. | Student's meeting time must be provided when an Alternative Education program is provided. | Schools must provide the meeting times a student is scheduled to attend in the alternative education class. More than one meeting time (Morning, Afternoon, Evening) can be provided for the program record. ONLY one record is expected and should show all the meeting times as needed. |
AlternativeEducation - 9 | Error | If the Reporting corporation does not match the ProgramEducationOrganizationId field, then Error | An approved alternative education program does not exist. Program Number is a required field. | Schools having an approved alternative education program is identified in an IDOE table a list of the approved programs to the reporting Education Organization have been provided to all SIS vendors. If the Program Name does not match to the Education Organization the program record will not be accepted. |
Attendance
Rule # | Rule Type | Rule Logic | Rule Message | Notes |
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). | 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% or more of "Unexcused Absence", "Excused Absence", and/or "Suspensions" of the required amount of attendance appropriated for a student's Instructional Time, 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 | Student not counted. Multiple schools claiming student for attendance. See Conflicts | 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 - 5 | 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% of unexcused, excused, and suspension absences. Student is considered a chronic absentee. Refer to IC 20-20-8-8. | Students with more than 10 days of excused, unexcused, and suspension absence codes will trigger the warning. |
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). | 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 schoolOfAccountibility, then conflict | Student is not counted for Attendance, multiple schools are claiming accountability for student. See Conflicts. | 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 warning | 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 warning. 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. |
Calendar
Rule # | Rule Type | Rule Logic | Rule Message | Notes |
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 - 5 | Error | IF ScheduleDescriptor is blank, THEN error | School schedule is missing. | Schools must provide and identify the type of schedule is associated to the school calendar (traditional, block 4, trimester, etc.) Schedule description not provided will trigger the error message. |
Calendar - 6 | Error | IF BeginTime is blank, THEN error | Instructional begin time is missing or invalid. | Schools must provide the begin time of their school day. Begin time not provided will trigger the error message. |
Calendar - 7 | Error | IF EndTime is blank, THEN error | Instructional end time is missing or invalid. | Schools must provide the end time of their school day. End time not provided will trigger the error message. |
Calendar - 8 | Error | IF Non-Instructional Minutes is blank, THEN error | Non-Instructional Minutes is missing or invalid. | Schools must provide the number of Non-Instructional minutes (lunch, recess) of a typical school day. Non-Instructional minutes not provided will trigger the error message. |
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 - 10 | Error | IF TotalWaiverDays is blank, THEN error | Total waiver days are missing or invalid. | Waiver days should be reported as zero (0) unless the school has received an approved waiver day from IDOE Accountability department. This may remain at zero (0) throughout the year or until an approved waiver day is granted from IDOE Accountability department. An error will trigger if no data is provided. |
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. |
Course Outcomes
Rule Id | Rule Type | Rule Logic | Rule Message | Notes |
Course Outcomes - 1 | Error | IF certifying school personnel AND is assigned to an IB AcademicSubjectDescriptor, THEN School must be IB accredited | Error - 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. |
Course Outcomes - 3 | Error | IF Course Result (courseAttemptResultType) is "No grade awarded", THEN finalNumericGradeEarned must remain blank | Error - 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'. |
Course Outcomes - 4 | Error | IF submitted a finalNumericGradeEarned, THEN the values must be between 0 through 4.0 | Error - 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. |
Course Outcomes - 5 | Error | IF CreditType is "Dual Credit", THEN a PostsecondaryInstitution is required | Error - 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 codes will fail. |
Course Outcomes - 6 | Error | IF Course Result (courseAttemptResultType) is "Pass" OR "Fail", AND High School Level Course is "True", THEN finalNumericGradeEarned cannot be Null or Blank | Error - 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). |
Course Outcomes - 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 | Error - 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. |
Course Outcomes- 8 | Exclusion | If Unique Section Code is blank or null, then exclusion | 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 or service only students given enrollment 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. |
Course Completion - 9 | Exclusion | If Course Result (Course Attempt Result Type) is blank or null, then exclusion | Exclusion - Student is reported with a schedule/course records. No course completion data provided. | Students with a schedule (student section data) and course completion (student transcript) data has not been provided will fail. IDOE is working on a solution to not show this error until course completion is expected during the school year. |
Course Completion - 10 | Error | IF no matching StaffSectionAssociation.staffUSI is found for provided StudentSectionAssociation record, THEN fail | Error - 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. |
Course Completion - 11 | Error | Medium of Instruction cannot be 'null' or blank | Error - 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. |
Course Completion - 12 | Error | IF assigned Student GradeLevels from 9 through 12, and grade level match is "false" then throw Error | 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. |
Course Completion - 13 | Warning | IF assigned Student GradeLevels from PK through 6, and grade level match is "false" then throw Warning | 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. |
Course Completion - 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 | Error - 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. |
Course Completion - 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 | Error - 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. |
|
|
|
|
Note: Deactivated 5/6/22 |
Graduation
Rule # | Rule Type | Rule Logic | Rule Message | Notes |
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 | Employability Skills must not be submitted when issuing a Work Readiness Wavier Diploma. | Schools cannot report an Employability Skill 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", THEN student must have their record tied to StudentSpecialEducationProgramAssociation | Student must be identified as special education to issue a Certificate of Completion. | Students cannot be reported with a Certificate of Completion if they are 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. See Conflicts | 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), | Postsecondary-Readiness Competency other than "Locally Created Pathway" does not utilize a Local Pathway. | Schools cannot report anything other than 10000 when reporting any Postsecondary-Readiness Competency other than Locally Created Pathway. |
Graduation - 9 | Error | IF AchievementCategoryDescriptor under Employability Skill has 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), "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, or 16. |
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 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 Certification Result 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", | Student in cohort year 2023 or later must have Graduation Pathway information provided. | Students in a cohort year 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. Currently there are only four available (https://drive.google.com/file/d/1sYEZ-8hiie_YOL_BSN5Y675EhY7U0Dxr/view ) missing from doc is 10004 - RAMP (Evansville School Corp) |
Graduation - 19 | Error | IF DiplomaLevelType is either "6" or "7" THEN AchievementCategoryDescriptor must be NULL AND AchievementCategoryDescriptor must NULL AND AchievementCategorySystem must also be NULL | 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", OR "16", 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) - report NA or Did Not Demonstrate when pathway was not utilized to obtain the diploma level (waiver) |
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, certificate of attendance, certificate of completion) is provided. Students must have both diploma types and diploma levels provided. Diploma level is the actualy diploma earned. |
Graduation - 24 | Error | If the diploma type is evidence-based waiver (Any of the following: (04=General (Work Readiness Waiver | 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 2023or greater cohort. |
Graduation - 25 | Error | If Diploma Type is Certificate of Completion then Diploma Level Type must be equal to 06 | 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. |
Homebound
Rule # | Rule Type | Rule Logic | Rule Message | Notes |
HomeBound - 1 | Informational/Error | 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
RuleID | Rule Type | RuleMessage | Notes |
Membership Enrollment-1 | Error | ADM Type is required | Check to see if Funding has been provided and if ADM is blank then need to populate. If ADM should not be provided then funding would need to be changed to attendance. |
Membership Enrollment-2 | Exclusion | Student is not counted; no funding record provided. Association to the Educational Organization is Attendance only. | Possible accurate exclusion if attendance responsibility is accurate. |
Membership Enrollment-3 | Error | Student’s county of residence is missing from the student record. | County is text and not a code - supplied on the student file with student's address. |
Membership Enrollment-4 | Exclusion | Student is NOT counted for Membership, inactive enrollment record on count date | Student School Association must have enrollment date on or before count date and not prior to the first calendar date. |
Membership Enrollment-5 | Exclusion | Student grade level is Pre-Kindergarten and cannot be counted towards membership. | Accurate exclusion for PK students. |
Membership Enrollment-6 | Exclusion | 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 | Student not counted. Graduate record exists. | |
Membership Enrollment-8 | Error | ADM 20 Adult Learners must have a grade level of 09 through 13 | |
Membership Enrollment-10 | Error | 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 | 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 | 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 | 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 | ADM 1 is only for Traditional Public and Charter Schools. | |
Membership Enrollment-21 | Error | Student must be enrolled less than 50% of time for ADM 6. | |
Membership Enrollment-23 | Error | Reporting Corporation must be a Traditional Public Corporation ID when a student is assigned ADM 2. | duplicate with ME 10 (?) |
Membership Enrollment-24 | Error | 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 | Instructional Days and Minutes must be entered for ADM 6 or 20. | |
Membership Enrollment-26 | Error | Corporation of Legal Settlement is either missing or is not reported as a Traditional Public School Corporation ID. | Missing or is not reported as a public LEA ID. |
Membership Enrollment-27 | Error | Charter Schools may only use ADM types 1, 6, or 20. ADM 20 is for Adult Learner Charter Schools only. | |
Membership Enrollment-28 | Error | ADM 1, 2, 3, 4, 5, 6, or 10 only allows grade levels KG through 13. | |
Membership Enrollment-30 | Error | ADM 10 is used only for Choice Voucher Schools. | |
Membership Enrollment-31 | Error | Grade Level must be KG through 13 for ME and MV Records | |
Membership Enrollment-32 | Conflict | Student not counted. Multiple schools claiming student for funding. See conflict | 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. |
Membership Enrollment-34 | Exclusion | Student not counted for Membership, inactive enrollment record on count date | duplicate with ME 4 (?) |
Membership Enrollment-35 | Error | 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 | 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 | 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 | 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 | 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. | |
Membership Enrollment-41 | Error | 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 | ADM types 6 and 20 is not allowed for Choice scholarship students. | |
Membership Enrollment-43 | Error | Accountability School must be provided. | |
Membership Enrollment-44 | Error | Student must be at 22 years of age or younger on the Census Date | |
Membership Enrollment-45 | Exclusion | Student not counted for Membership. Virtual days does not meet threshold for virtual program. | Student does not have enough virtual or virtual COVID attendance data reported to support the virtual program. |
Membership Enrollment-46 | 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 or virtual COVID attendance data. |
Membership Enrollment-47 | Exclusion | Student not counted for Membership. Attendance records could not be found. |
Pupil Enrollment
RuleID | Rule Type | RuleMessage | Notes |
PupilEnrollment-1 | Informational | 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 | Informational | Invalid grade value | Grade level might be reported without leading zero. Only PK -13 is allowed. |
PupilEnrollment-3 | Conflict | Student is not counted for Pupil Enrollment, multiple schools claiming student for enrollment. See Conflicts | 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 | Error | Students must have an active SSA before or on Census Date to be counted. | Student School Association must have enrollment date on or before count date and not prior to the first calendar date. |
Special Education
Rule # | Rule Type | Rule Logic | Rule Message | Notes |
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. | PUBLIC SCHOOLS: For the reporting LEA the Student School Association (enrollment) record should show the school = False and the school ID must be a school that belongs to/resides in the reporting LEA |
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. | A student cannot be 23 years of age as of July 1st for the reporting school year. A student can be 22 years + months/days as long as they are not 23 years of age on or by July 1st of the reporting school year. |
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 count date. | A student must be at least 3 years old on count date(s) to report and 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 will not be counted for SE funding if they do not have an ACTIVE program record with a start date prior to or on a count date with no exit date and exit reason terminating the services. |
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 cannot be 9 years of age as of December 1st and be reported with an exceptionality (disability) of Developmental Delay; either primary or secondary. |
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 cannot be 9 years of age as of December 1st and be reported with an exceptionality (disability) of Developmental Delay; either primary or secondary. |
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 Placement Type is not valid with student's grade level. | Students who are in grade level PK and are 5 years old (or less) by count date must be reported with a program associated to legacy/historical Preschool Codes (26-38) |
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. | Review or Refer to Program Names and Setting Codes resource document |
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. | Review or Refer to Program Names and Setting Codes resource document |
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. | Review or Refer to Program Names and Setting Codes resource document |
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. | Review or Refer to Program Names and Setting Codes resource document |
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. | Review or Refer to Program Names and Setting Codes resource document |
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 Placement Type is not valid with student's grade level. | Students who are in grade level KG-13 and are less than 23 years old by July 1st of the reporting year OR have a grade level of PK and are age 6 must be reported with a program associated to legacy/historical School Age Codes (50-57) |
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), 03, 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. | Review or Refer to Program Names and Setting Codes resource document |
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. | Review or Refer to Program Names and Setting Codes resource document |
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. | Review or Refer to Program Names and Setting Codes resource document |
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. | Review or Refer to Program Names and Setting Codes resource document |
SpecialEducation - 18 | Exclusion | If Student does not have placement data as of the count date, exclude record | Student has no placement data as of the count date. | Students reported with program of UNDEFINED have not been placed in a program yet as of count date will be excluded. |
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 who have "FALSE" for their eligibility as of count date will be excluded. This could be students who were evaluated and found to not be eligibile for services. These could be students who are currently being evaluated for services and the evaluation has not been completed. Students terminated from services should NOT be flipped to "false" as they were special education and IDOE will not count these students for funding purposes when the exit date with termination reason is provided. |