Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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=1099946083","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"}]}
Table of Contents
minLevel2
maxLevel2
typeflat
separatorpipe

Excerpt
nameValidation Rules Alt Ed

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.

Excerpt
nameValidation Rules Attendance

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
with overlapping Entry/ExitDates,
AND both Primary School = TRUE; THEN throw conflict;

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.