Page Comparison

Appanvil karma designer

summary

Download Spreadsheet Change Log

page

{"id":"EJyr1dNQxAJdJguiodbJA","name":"page","children":[{"id":"SRS9yY8wapvscXyrMR4t4","params":{"background":"#151E47","padding":0,"gap":10},"children":[{"id":"f6zXp2BMg4vT0JskyguCU","name":"row","children":[{"id":"LLtETss-snEBZlL4O6REi","name":"column","children":[{"name":"image","params":{"templateId":"full-width rounded","alignment":"start","position":"center center","borderRadius":{"all":20,"bbl":0,"bbr":0,"btl":0,"btr":0,"isIndividualCorners":false},"image":{"value":"att413630598","target":"_blank","type":"attachment"},"width":254,"height":48,"link":{"value":"410255361","target":"_self","type":"page"}},"children":[],"id":"a9zWcdN3fWnhr4Hvkqmiv"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}},{"id":"qAKT5zCUcEhNjzq1SJb4c","name":"column","children":[{"name":"button","params":{"templateId":"large button","label":"Download Spreadsheet","size":"large","shape":"rounded","alignment":"center","states":{"idle":{"colors":{"background":"#ffffff8c"}},"hover":{"colors":{"background":"#FED720"}}},"link":{"value":"https://docs.google.com/spreadsheets/d/19KgAGb7MUrQjvCkRLWwZfS8NWYsNj_sc/edit#gid=109994608318EKrNNSPR-lrc7Ym2vkYsTS8KAbwxd9G/edit?usp=sharing&ouid=114946491007287294795&rtpof=true&sd=true","target":"_blank","type":"link"}},"children":[],"id":"JGzdwG2E8HdqyDxocwnmD"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}},{"id":"xgCMrMo0FAFcCdm054mMo","name":"column","children":[{"name":"button","params":{"templateId":"large button","label":"Change Log","size":"large","shape":"rounded","alignment":"end","states":{"idle":{"colors":{"background":"#ffffff8c"}},"hover":{"colors":{"background":"#FED720"}}},"link":{"value":"413990913","target":"_self","type":"page"}},"children":[],"id":"kTLhRJkez9HeMQZaEO5zb"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}},{"id":"IfCWW5kQJcP6h2rWmKZJ0","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"HnfZjctzwsQ07uy8lDujA","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"uBaTW2wC3ZrPcLJ4nmup7","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1,1,1],"gap":10,"minHeight":0,"padding":10,"borderRadius":0,"size":"full"}}],"name":"section"}]}

...

Excerpt

name	Validation Rules Alt Ed

Alternative Education

Rule #	Rule Message Type	Rule Logic	Rule Message	Rule 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' `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 one 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 of each reporting school year.
AlternativeEducation - 7	ErrorExclusion	Day Count must be less than 10 consecutive student instructional days. Otherwise, errorexclusion	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 . 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.
AlternativeEducation - 10	Error	New Rule: IF reason exited descriptor is not 2, 3, 4, 5, 6, 7, 10, 11, or 14 then error.	Reason Exited is not allowable for Alternative Education reporting.	Schools must report one of the allowable reason exited codes (outcome) when reporting an exit date on the Alt-Ed program association record.

Excerpt

name	Validation Rules Attendance

Attendance

5Schools must report a student's schoolOfAccountibility is for Attendance, multiple schools are claiming accountability for student. See Conflicts. warning warning school's school's accountability formula.

Rule #	Rule Message 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 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 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 student`s total Attendance contains 10% 10 days 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 with overlapping Entry/ExitDates, AND both Primary School = TRUE; THEN throw conflict;	Student not counted. Multiple schools claiming student for attendance. See ConflictsConflicted 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	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).	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).

Excerpt

name	Validation Rules Calendar

Calendar

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

Rule #	Rule Message 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 - 59	Error	IF ScheduleDescriptor InstructionalTimeInMinutesIndicator is blank, THEN error	School schedule Instructional time in minutes indicator is missing or invalid.	Schools must provide and identify the type of schedule is associated to the school calendar (traditional, block 4, trimester, etc.) Schedule description 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 the this error message.
Calendar - 611	ErrorWarning	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.	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.

Course OutcomesStudent not counted for Membership. Attendance records could not be found

Excerpt

name	Validation Rules Course Outcomes

Certified Educator

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

Excerpt

name	Validation Rules Membership

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

Rule Id	Rule Message Type	Rule Logic	Rule Message	Notes
Course Outcomes Certified Educator - 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.
~~Course Completion - 16~~	~~Error~~	~~If High School Level Course is "False", then THEN earnedCredits AND CreditType must remain Null or Blank~~	~~Error - Earned Credits cannot be provided when a non-High School course is reported.~~	~~Schools cannot report earned credits or credit types when the subject is not an identified high school subject/course code.~~ Note: Deactivated 5/6/22

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.

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

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)

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

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.

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.

Rule #	Message Type	Rule Logic	Rule Message	Notes
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
SpecialEdTermination - 7	Error	IF prior graduate record exists for the student THEN ReasonExitedDescriptor must be a 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 graduate record for a special education student.

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.

Page Comparison

Versions Compared

Old Version 35

New Version Current

Key

Alternative Education

Rule #

Message Type

Rule Logic

Rule Message

Rule Notes

Attendance

Rule #

Message Type

Rule Logic

Rule Message

Notes

Calendar

Rule #

Message Type

Rule Logic

Rule Message

Notes

Certified Educator

Membership

RuleID

Rule Type

RuleMessage

Notes

Rule Id

Message Type

Rule Logic

Rule Message

Notes

Curricular Materials Assistance

Rule #

Rule Type

Rule Logic

Rule Message

Notes

Graduation

Rule #

Rule Type

Rule Logic

Rule Message

Notes

Homebound

Rule #

Rule Type

Rule Logic

Rule Message

Notes

Certified Position

Rule Id

Message Type

Rule Logic

Rule Message

Notes

Course Outcomes

Rule Id

Message Type

Rule Logic

Rule Message

Notes

Curricular Materials Assistance

Rule #

Message Type

Rule Logic

Rule Message

Notes

Graduate

Rule #

Message Type

Rule Logic

Rule Message

Notes

Homebound

Rule #

Message Type

Rule Logic