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