Page Comparison

...

Excerpt

name	Validation Rules Homebound

Homebound

Rule #	Message 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 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

Excerpt

name	Validation Rules Membership

Membership

ErrorError ADM 1.COLS must be the same ID as reporting corporation when reporting Instructional Days and Minutes must be ID.Missing or is not reported as a public LEA 10 is used only for Choice 31

RuleID	Message Type	RuleMessage	Notes
Membership Enrollment - 1	Error	RULE: IF ResponsibilityTypeDescriptor is Funding, THEN student record must report an 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.ADM Type is required
Membership Enrollment - 2	Exclusion	RULE: IF ResponsibilityTypeDescriptor is NOT Funding AND ADM Type is missing, THEN do NOT count	Student is not counted; no funding record provided. Association to the Educational Organization is Attendance only.	Possible accurate exclusion if attendance responsibility is accurate.
Membership Enrollment - 3Error	Warning	RULE: IF certifying for Membership, THEN Student county of residence must be populated (student).	Student’s county of residence is missing from the student record.	County is text and not a code - 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 dateRULE: IF student has ExitTypeWithdraw of "33" with an exit date AND does NOT have a StudentProgramAssociation with Special Ed, THEN do NOT count towards membership	Student is not counted for Membership, General Education students with exit code 33 prior to count date(s) cannot be certified for membership.
Membership Enrollment - 5	Exclusion	RULE: IF student’s GradeLevelDescriptor is “PK”, THEN do NOT count	Student grade level is Pre-Kindergarten and cannot be is not counted towards membership.	Accurate exclusion for PK students.
Membership Enrollment - 6	Exclusion	RULE: IF student`s GradeLevelDescriptor is equal to "KG", THEN Student`s age must be 5 years of age from [edfi.Student.BirthDate] by "October 1st"	Student must be at least 5 years of age for grade level KG	Accurate exclusion if the student is not 5 years of age by October 1st.
Membership Enrollment-7	Exclusion	Membership Enrollment - 7	Exclusion	RULE: IF certifying for Membership, THEN Student CANNOT have GraduationRecordType of anything other than "6" OR "7”	Student not counted. Graduate record exists.
Membership Enrollment - 8	Error	RULES: IF ADM Type is "20", THEN `GradeLevelDescriptor` must be between "09" through "13"	ADM 20 Adult Learners must have a grade level of 09 through 13
Membership Enrollment - 10	Error	RULE: IF ADM Type equals "2", THEN Membership Funding Corp ID must be identified as Traditional "Public" Corp ID	Reporting Corporation must be a Traditional Public Corporation ID when a student is assigned ADM 2.Only public corporations can report ADM type 2.
Membership Enrollment - 12	Error	RULE: IF ADM Type equals "3" OR "5", THEN Funding Corporation CANNOT equal Corporation of Legal Settlement	Reporting Corporation cannot have matching Corporation of Legal Settlements for ADM 3 or 5.	COLS cannot match the corporation reporting a student for ADM 3 or 5.	Membership Enrollment-16
Membership Enrollment - 16	Error	RULE: IF ADM Type equals "1", THEN School must be in the Funding Corporation	School ID must belong to the funding corporation OR primary responsibility of Attendance has ADM Type provided for ADM 1.Student School Association must exist under the reporting corporation for funding when ADM 1 is provided. OR school has given ADM 1 when reporting attendance instead of funding (no ADM allowed when reporting attendance)
Membership Enrollment - 17	Error	RULE: IF ADM Type equals "3", "4", OR "5", THEN student can only be enrolled in Traditional Public School Corporation	School ID must be Traditional Public School ID when ADM is 3, 4, or 5.	Only public corporations can report ADM type 3, 4, or 5.
Membership Enrollment - 18	Error	RULE: IF ADM 1 is only Type equals "1", THEN student can only be enrolled in a Traditional Public School OR Charter	ADM 1 is only for Traditional Public and Charter Schools.
Membership Enrollment - 21	Error	RULE: IF ADM Type equals "6", THEN the "Traditional Public School Corporation" must report FTE at less than 50%	Student must be enrolled less than 50% of time for ADM 6.
Membership Enrollment - 2324	Error	Reporting Corporation must be a Traditional Public Corporation ID when a student is assigned ADM 2.	duplicate with ME 10 (?)	Membership Enrollment-24	RULE: IF ADM Type equals "1" AND Funding Corporation is Traditional Public School Corporation, THEN Corporation of Legal Settlement must reside with its Funding Corporation	Corporation of Legal Settlement must match Reporting Corporation for	ADM 1.
Membership Enrollment - 25	Error	RULE: IF ADM Type equals "6" OR "20", THEN "Instructional Days" AND "Instructional Minutes" cannot be blank	Instructional Days and Minutes must be entered for ADM 6 or 20.
Membership Enrollment - 26	Error	RULE: IF certifying for Membership, THEN Corporation of Legal Settlement must reside with Traditional Public School Corporation.	Corporation of Legal Settlement is either missing or is not reported as a Traditional Public School Corporation	ID.
Membership Enrollment - 27	Error	RULE: IF LocalEducationAgencyCategoryType is "Charter", THEN ONLY ADM Type of "1", "6", OR "20" is allowed	Charter Schools may only use ADM types 1, 6, or 20. ADM 20 is for Adult Learner Charter Schools only.
Membership Enrollment - 28	Error	RULE: IF ADM Type equals "1", "2", "3", "4", "5", "6", OR "10", THEN GradeLevelDescriptors must be between "KG" through "13"	ADM 1, 2, 3, 4, 5, 6, or 10 only allows grade levels KG through 13.
Membership Enrollment - 30	Error	RULE: IF ADM	Type equals "10", THEN School `ChoiceIndicator` must equal "Choice"	ADM 10 is used only for Choice Voucher Schools.
Membership Enrollment -	32	Error	Grade Level must be KG through 13 for ME and MV Records	Membership Enrollment-32	ConflictConflict	RULE: If a student has two StudentSchoolAssociation records with overlapping Entry/ExitDates on Census date and both are PrimaryResponsibily= true, then conflict.	Student not counted. Multiple schools claiming student for funding. See conflictConflict 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.Conflicted with: (SchoolId) - (Entry Date) - (Exit Date)
Membership Enrollment - 34	Exclusion	Student not counted for Membership, inactive enrollment record on count date	duplicate with ME 4 (?)RULE: IF certifying for Membership, THEN students must be enrolled in a school identified within the StudentSchoolAssociation denoting the EntryDate prior to counts AND ExitWithdrawDate after counts	Student not counted for Membership, inactive enrollment record on count date
Membership Enrollment - 35	Error	Primary School must be true for ADM Types RULE: IF ADM Type 1, 3, 4, 5, 10, and 20.Primary school on School Association (enrollment) record or 20 AND the ResponsibilityType is Funding, THEN student`s Primary School must be TRUE	Primary School must be true for ADM Types 1, 3, 4, 5, 10, and 20.
Membership Enrollment - 36	Error	RULE: IF ADM Type equals 6 AND only one Funding ResponsibilityType exists, THEN student`s Primary School must be FALSE	Primary School must be false when ADM is 6 when only one enrollment record is reported.Primary school on School Association (enrollment) record must be false for ADM 6 when there is no other enrollment record. (homeschool dual enrolled student)
Membership Enrollment - 37	Error	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 RULE: IF Funding ResponsibilityTypes exists for both ADM Type 6 AND 10, THEN Primary School for ADM 6 must be false and FALSE AND Primary school on School Association (enrollment) for non-public school with ADM 10 must be TRUE	When dual enrollment is reported, Primary School must be false for ADM 6 and true for ADM 10.
Membership Enrollment - 38	Error	RULES: IF ADM Type equals “10”, THEN Choice Scholarship application must be present and approved for the given student	ADM 10 is only for Choice Voucher students.Student must have approved scholarship in App Center and provided across to Data Exchange (jeff/david garner)
Membership Enrollment - 39	Error	IF ADM type = 20 THEN edfi.schoolcategory.schoolcategorytypeID must be "2" or "28"	ADM 20 is for Adult Learner Schools only.	Adult Charters are the only ones allowed to use ADM 20.
Membership Enrollment-40	ErrorMembership Enrollment - 40	Error	Student with grade level KG cannot be reported as dual enrolled	Student with grade level KG cannot be reported as dual enrolled.
Membership Enrollment - 41	Error	RULE: IF ADM Type equals "2" THEN student`s Primary School must be FALSE	Primary Educating School must be False when reporting ADM type 2-Transfer Out.	Primary school on School Association (enrollment) must be false for ADM 2.
Membership Enrollment - 42	Error	IF ADM Type equals "6 or 20" AND reporting ed org ID is Choice identified school THEN fail	ADM types 6 and 20 is not allowed for Choice scholarship students.
Membership Enrollment - 43	Error	IF certifying for Membership THEN Accountability must be provided.	Accountability School must be provided.
Membership Enrollment - 44Error	Exclusion	student claimed must be age 22 years or less on each census/count date	Student must be at 22 years of age or younger on the Census Date
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 Warning	If the program type isn`t virtual, and the total of virtual days is over 50% for that record, then it will throw an exclusion.	Student counted for Membership. Verify data is accurate as virtual days does not meet threshold for virtual program.
Membership Enrollment - 46	ExclusionError	If the program type isn`t virtual, and the total of virtual days is over 50% for that record, then it will throw an exclusion.	Student not counted for Membership. Virtual days exceeds threshold for non-virtual program.	Student does not have the virtual program record reported to support the virtual or virtual COVID attendance data.
Membership Enrollment - 47Exclusion	Error	If no attendance records found for student, then do not count towards membership.	Student not counted for Membership. Attendance records could not be found or Calendar Dates do not exist.
Membership Enrollment - 48	Conflict	Cannot have records of funding for a student at different schools (except for when one school has ADM 6 and the other has 10).	Student not counted. Multiple schools claiming student for Membership with conflicting ADM Types. Conflicted with: (SchoolId) - (Entry Date) - (Exit Date)

Excerpt

name	Validation Rules Multilingual Learners

Multilingual Learners

Rule #	Message Type	Rule Logic	Rule Message	Notes
MultilingualLearners - 1	Error	IF StudentProgramAssociation has Foreign Exchange as a ProgramType, THEN Birth Country cannot equal "USA"	Student cannot be identified as Foreign Exchange, birth country is not outside of the US or US territories.	Students with their birth country reported as USA or one of the US territories cannot be reported as Foreign Exchange.
MultilingualLearners - 2	Conflict	IF certifying for MultilingualLearners, THEN only one school can claim LM for the student for the current collection year	Student not counted. Multiple schools claiming student. Conflicted with: (SchoolId) - (Entry Date) - (Exit Date)	Multiple schools cannot claim a student for Multilingual certification. While programs are not ended when a student exits only one school may be identified as claiming the student. Student school association (enrollment) records cannot be in conflict.
MultilingualLearners - 3	Exclusion	IF student is certifying for LM, THEN student`s LanguageDescriptor may NOT be "211" ("English") AND NonUSOrigin may NOT be “NO” with the exception of dual language/immersion program.	Student is not counted for Multilingual Learners when language code is English and program is not Dual Language/Immersion.	Students with a language code of 211 (English) can only be associated to Dual Language/Immersion program. All other multilingual program associations will fail.
MultilingualLearners - 4	Warning	IF student`s LimitedEnglishProficiencyDescriptor from previous year does NOT match the overall proficiency level in the WIDA result table from one prior year, THEN print warning message	Student's Proficiency Level does not match overall proficiency level from prior year WIDA assessment - verify data for accuracy.	Students with a prof. level determined from WIDA in the prior assessment year does not match what is being reported by the school will receive this warning. Schools should make sure the prof. level being provided is accurate. IDOE will accept the prof. level that is being reported.
MultilingualLearners - 5	Warning	IF student`s LimitedEnglishProficiencyDescriptor from previous year is between 5.0 and 6.0 OR FNA AND the LimitedEnglishProficiencyDescriptor reported for the current year is 4.9 and under, THEN print warning message	Student was previously reported as proficient, verify data for accuracy.	Students reported as previously proficient and have been reassessed and receive a lower or non-proficient score will receive this warning. Schools should verify the data being provided on the student for accuracy as IDOE will update the prof. level to what has been reported.
MultilingualLearners - 6	Error	IF student`s LimitedEnglishProficiencyDescriptor Proficiency Level HAS VALUES from previous year and proficiency level is not 8, THEN EllInstrumentUsedDescriptor must be "5" ("WIDA ACCESS for ELLs") OR "10" ("WIDA Alternate ACCESS")	Instrument used must be WIDA Access or WIDA Alternate Access when WIDA prior year proficiency levels exist.	Students who have WIDA assessment results from the prior school year must have instrument used reported as WIDA Access or WIDA Alternate Access.
MultilingualLearners - 7	Exclusion	IF certifying for LM AND student GradeLevelDescriptor is "PK", THEN student`s age must be between the ages 3 and 5 by COUNTDATE	Student not counted for Multilingual Learners, age must be at least 3 years of age and not older than 5 years as of count date for grade level PK.	Students must be at least 3 years of age and not older than 5 years of age on count date to be reported in grade level PK for multilingual learner certification.
MultilingualLearners - 8	Exclusion	IF certifying for LM THEN studentProgramAssociation must denote an EntryDate prior or equal to count date AND an ExitWighdrawDate equal to or after count date or NULL	Student not counted for Multilingual Learners, no valid Multilingual Learners program record provided.	Student not counted for English Learner, inactive enrollment record on count date.
MultilingualLearners - 9	Exclusion	IF certifying for LM, student`s age must be greater than or equal to "3" OR less than or equal to "21" as of COUNTDATE	Student not counted for Multilingual Learners, age must be 3 to 21 as of count date.	Students must be at least 3 years of age and no more than 21 years of age on count date to be counted for multilingual certification.
MultilingualLearners - 10	Warning	IF EllInstrumentUsedDescriptor is WIDA ACCESS for ELLs ("5") AND does NOT have a WIDA result from the data warehouse, THEN throw warning AND print "Please verify locally that student has a WIDA Access score"	Student Proficency Level is not found from prior year Indiana WIDA ACCESS assessment. Verify data for accuracy.	Schools providing WIDA access as the instrument used to obtain the prof. level being reported when IDOE has no record of the WIDA assessment results will receive this warning. Schools need to verify the correct instrument used is being reported. WIDA results could have been provided from assessment taken in another state.
MultilingualLearners - 11	Exclusion	IF student is certifying for LM AND LimitedEnglishProficiencyDescriptor ProficiencyLevel is "8" ("No assessment and student no longer available."), THEN print `Informational` message stating "Federal law requires that 100% of EL students be assessed annually for English language proficiency. The IDOE monitors the assessment of English learners and may reach out for additional information as to why the student was not assessed as required."	Student not counted - Federal law requires that 100% of EL students be assessed annually for English language proficiency. The IDOE monitors the assessment of Multilingual Learners and may reach out for additional information as to why the student was not assessed as required. This applies to students with Proficency Level 8.	Students reported with prof. level 8 will receive this message and will not be counted for multilingual certification. Schools need to verify the data is accurate and remaining compliant with providing annual assessments to non-English speakers.
MultilingualLearners - 12	Error	IF student`s EllInstrumentUsedDescriptor is "7" ("N/A"), THEN LimitedEnglishProficiencyDescriptor must be "FNA", "NES" OR "0"	Student Profiency Level of FNA, NES, or 0 can only utilize Instrument Used - N/A.	Student Profiency Level of FNA, NES, or 0 can only utilize Instrument Used - N/A.
MultilingualLearners - 13	Error	IF student`s GradeLevelDescriptor is "PK", THEN LimitedEnglishProficiencyDescriptor code value must be "0" and must have a valid birth country ("Immigrant Student who is PK or PK student's birth country is missing")	Student's born outside of USA with grade level of PK must have Proficiency level of 0 - Immigrant Student who is PK; or PK student's birth country is missing.	Students with grade level PK and birth country is outside of the US or US territories must have prof. level 0 provided. Students with grade level PK and prof. level of 0 provided with the birth country data missing will also receive this error.
MultilingualLearners - 14	Error	IF student`s GradeLevelDescriptor is anywhere from "KG" through "13", THEN the LimitedEnglishProficiencyDescriptor CANNOT be "0"	Student grade levels of KG to 13 cannot have Proficiency level of 0.	Student reported with grade levels of KG to 13 cannot have their prof. level reported as 0.
MultilingualLearners - 15	Error	IF student`s LimitedEnglishProficiencyDescriptor is NES ("Native English Speaker"), THEN Birth Country cannot be "USA"	Student with Proficiency Level of NES must have birth country outside of the US or US territories.	Students reported with prof. level of NES cannot have their birth country reported as USA or one of the US territories.
MultilingualLearners - 18	Error	If language code is reported other than English (no English is being reported), and no ProgramType of "English Language Learner" exists, then Error	Student not counted for Multilingual Learners. English Language Learner program does not exist or student language not provided.	Students reported with a non-English language code should have a multilingual program association record even when they are fluent. Either the student`s language code is incorrect or a program association needs to be added.
MultilingualLearners - 19	Error	If a student has an English Learner program and the proficiency level that they report is NULL, then exclude.	Student not counted for Multilingual Learners, Proficiency Level not found.	Students reported with a multilingual program must have a prof. level provided. Either the program is in error or prof. level needs to be provided.

Excerpt

name	Validation Rules Pupil Enrollment

Pupil Enrollment

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

Excerpt

name	Validation Rules Special Education

Special Education

Rule #	Message 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.

Excerpt

name	Validation Rules Special Education Evaluation

Special Education Evaluation

Rule #	Message Type	Rule Logic	Rule Message	Notes
SpecialEdEvaluation - 1	Informational	IF certifying for Special Education Eval and student has two different Referral ParentalConsentDates, THEN throw informational message	STN submitted with two different Parental Consent Dates. Verify this student had two different Initial evaluations.	Students may have more than one parental consent (referral) date provided if the initial evaluations are for different reasons. This is for information purposes only and schools should make sure the different dates are accurate.
SpecialEdEvaluation - 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.
SpecialEdEvaluation - 2	Error	IF certifying for Special Education Eval and TimelineCompliance is "00", THEN a response to IDEAEligibility is required	IDEA Eligibility (student eligiblity) status must be provided.	Schools must provide IDEA eligibility of 'True' or 'False' if a student's initial evaluation was during the reporting timeframe and the timeline compliance has been reported as '00' = timeline was met.
SpecialEdEvaluation - 3	Error	IF student has a Referral ParentalConsentDate, THEN CaseConferenceDate (IEPReviewDate) has to be on OR later date (allow null/blank for IEP review date=has not happened yet)	Case Conference (IEP Review) date cannot be prior to the Parental Consent Date.	Schools cannot report a Case Conference date prior to the parental consent (referral) date.
SpecialEdEvaluation - 4	Error	IF a ParentalConsentDate is given AND TimelineCompliance is "00", THEN a CaseConferenceDate (IEPReviewDate) is required	Case Conference (IEP Review) must be submitted when Timeline Compliance is met.	Schools must provide a Case Conference date when the timeline compliance code reported is '00' = timeline was met.
SpecialEdEvaluation - 5	Error	IF CaseConferenceDate (IEPReviewDate) is given, THEN response to IDEAEligibility is required (true/false)	IDEA Eligibility is required when Case Conference Date (IEP Review Date) is provided.	Schools must provide IDEA eligibility of 'True' or 'False' if a student's case conference date has been provided.
SpecialEdEvaluation - 6	Error	IF Circumstances (RelevantToTimelineDescriptor) is "1", "2", OR "4", THEN FirstStepsTransitionDate must be blank/null	Student cannot have a First Steps Transition date when Circumstances Relevant to Timeline is 20 or 50 days.	Schools cannot provide a First Steps Transition date when the circumstances relevant to the timeline is not a '3' = Preparation for Transfer from First Steps.
SpecialEdEvaluation - 7	Error	IF Circumstances (RelevantToTimelineDescriptor) is "3", AND IDEAEligibility equals "True" THEN FirstStepsTransitionDate must be provided AND TimelineCompliance must be either "00", "07", or "99".	Student transitioning from First Steps must have Date and Timeline Compliance of "00", "07" or "99".	Schools must provide a Timeline Compliance code of 00 = timeline was met, 07 = timeline missed, third birthday occurs during school break and no ESY, or 99 = timeline missed, other reason when the IDEA eligibility is reported as 'True' and the circumstances relevant to the timeline is '3' = Preparation for Transfer from First Steps.
SpecialEdEvaluation - 8	Error	IF Circumstances (RelevantToTimelineDescriptor) is "1", "2", OR "4", AND IDEAEligilbility equals "True" or "False" THEN TimelineCompliance must be either "00", "08", or "99".	When Circumstances to Timeline is 20 or 50 days and eligibility is determined, the Timeline Compliance must be "00", "08" or "99".	Schools must provide a Timeline Compliance code of 00 = timeline was met, 08 = timeline missed, parent refused to bring student in for evaluation, or 99 = timeline missed, other reason when the IDEA eligibility is either 'True' or 'False' and the circumstances to the timeline is 1, 2, or 4 (20 or 50 day timelines).
SpecialEdEvaluation - 9	Exclusion	IF referral (parental consent) to EOY (student instructional) days is less than to 50 AND Case Conference date is NULL/BLANK AND Circumstances (RelevantToTimeline) = 4; THEN exclude	Student not counted for Special Education Evaluation. Initial evaluation pending 50 day timeline.	Students will not be counted for SE evaluation if the parental consent (referral) date does not allow for enough time to complete the evaluation before the school year ends when the circumstances relevant to timeline is 4 = All other, 50 instructional day timeline.

Excerpt

name	Validation Rules Special Education Termination

Special Education Termination

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 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, OR 30"	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, or 30.	Students must have an exit withdraw code of 01, 02, 03, 05, 10, 12, 13, 14, 15, 16, 17, 18, 26, or 30 on the student school association (enrollment) record when reporting reason exited code 15 - Dropout. Each of the exit withdraw codes are considered dropout codes. Note: Code 35 missed - submitted to dev team for correction
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 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.

Excerpt

name	Validation Rules Staff

Staff

Rule #	Message Type	Rule Message	Notes
CertifiedPosition - 1	Exclusion	Staff entered does not have an active contract for the given school year.	Staff must have a Staff Employment record provided by the Ed Org that 'holds the contract' to be included in Staff Assignment (CP) certification. Not all staff classifications are counted for Staff Assignment certification.

CP Certification Summary Counts of Staff Classification descriptors allowed for reporting at the LEA (central office) ID are: Superintendent, Assistant Superintendent, LEA Administrator, Chief Technology Officer, Special Education Director, Corporation Test Coordinator, and School Administrator. All other staff classification descriptors for CP certification purposes must be assigned to a School Id.			There are other classification descriptors allowed to be assigned to the LEA Id but are not captured for CP certification.

Excerpt

name	Validation Rules Title I

Title I

Rule #

Message Type

Rule Logic

Rule Message

Notes

~~TitleI - 1~~

~~Error~~

~~If Program Name = "Neglected and Delinquent Program" and the corporation is not listed in the DOE table (that Jeff/Rajini build) as having a program, then error.~~

~~Only corporations with listed Neglected and Delinquent programs can report students as Program type 'Title I Neglected'.~~

A corporation that has not been identified by IDOE as having a Neglected or Delinquent facility located within their geographical area will not be allowed to report the Neglected and Delinquent Program on any student.

Note: Deactivated 5/13/22

TitleI - 2

Exclusion

If Program Type = "Title I Part A" or "Title I Part A and Migrant Title I Part C" and the school is not designated in edfi.school.Title1PartASchoolDesignation is NULL, then error. (Jeff/David will be loading the list of schools from Dwyane here with a "5")

Student not counted. The school is not identified as receiving Title services.

A school ID that has not been identified as a servicing title school will not be allowed to report any Title programs on any student.

~~TitleI - 3~~

~~Exclusion~~

~~When SchoolofAttendance is -1, OR when GeoGraphicCorporationid is NOT NULL, then the GeographicCorporationId must equal the ReportingCorp.~~

Student not counted. Student school association (enrollment) primary record does not equal true or nonpublic school association (enrollment) record provided is not within the geographic boundaries of the corporation.

Corporations cannot report a student for any Title program that is or was not enrolled in one of their schools or a non-public school that is not located within their geographical area. IDOE will look for a school association (enrollment) record of 'true' at the non-public school to confirm the student is or was enrolled at the non-public school to allow reporting of the Title program record.

Note: Deactivated 5/13/22

...

Page Comparison

Versions Compared

Old Version 36

New Version 37

Key

Homebound

Rule #

Message Type

Rule Logic

Rule Message

Notes

Membership

RuleID

Message Type

RuleMessage

Notes

Multilingual Learners

Rule #

Message Type

Rule Logic

Rule Message

Notes

Pupil Enrollment

RuleID

Message Type

RuleMessage

Notes

Special Education

Rule #

Message Type

Rule Logic

Rule Message

Notes

Special Education Evaluation

Rule #

Message Type

Rule Logic

Rule Message

Notes

Special Education Termination

Rule #

Message Type

Rule Logic

Rule Message

Notes

Staff

Rule #

Message Type

Rule Message

Notes

Title I

Rule #

Message Type

Rule Logic

Rule Message

Notes