Page Comparison

...

Excerpt

name	Validation Rules Curricular Materials Assistance

Curricular Materials Assistance

Rule #	Rule Logic	Rule Message
TextBook - 1	IF certifying for CMA, THEN STN must be enrolled in SFS, where the SFS program type denotes an EntryDate on or before Census Date AND ExitWithdrawDate on OR after Census Date or NULL	Student is not counted for Curricular Material Assistance, inactive or no enrollment record in School Food Services program.
TextBook - 2	PRECONDITION: Must enrolled in CMA program with an EntryDate before OR on Census Date and ExitWithdrawDate on OR after Census Date OR NULL RULE: If certifying for CMA, then STN must be in grade levels KG through 13.	Student is not counted for Curricular Material Assistance, only grade levels between KG through 13 are allowed.
TextBook - 3	If certifying for CMA, LivesWithParentUSI is required if StudentDoesNotLiveWithParent is false (extension.StudentCurricularMaterialProgramAssociation)	Student lives with parent/guardian is 'true' but no parent/guardian associated to the student.
TextBook - 4	IF certifying for CMA, THEN STN must be enrolled in CMA, where the CMA program type denotes an EntryDate on or before Census Date AND ExitWithdrawDate on OR after Census Date or NULL.	Student is not counted for Curricular Material Assistance, inactive or no enrollment record in Curricular Materials Reimbursement program.

Excerpt

name	Validation Rules Graduation

Graduation

Rule #	Rule Type	Rule Logic	Rule Message	Notes
Graduation - 1	Error	IF DiplomaLevelType is either "11", "19", "20", "21", OR "22" (Evidence-based waivers) AND the cohort year is less than 2023, THEN the AchievementCategoryDescriptor must be NULL	Employability Skills must not be submitted when issuing a Work Readiness Wavier Diploma.	Schools cannot report an Employability Skill for students in a cohort year less than 2023 AND earning one of the Work-Readiness Waiver diplomas.
Graduation - 2	Error	IF cohort year is 2023 OR after, THEN AchievementCategoryDescriptor under Employability Skills(RecognitionType) (edfi.StudentAcademicRecordDiploma) must be populated AND AchievementCategoryDescriptor under Postsecondary-Ready Competencies(RecognitionType) (extension.StudentAcademicRecordExtension) must be populated	Employability Skills and Postsecondary-Readiness Competencies are required.	Students in a cohort year 2023 or greater must also have Employability Skills and Postsecondary-Readiness Competency data reported.
Graduation - 3	Error	IF student passed both GQE test, THEN DiplomaLevelType may NOT include the following: 04, 06, 07, 11, 13, 14, 15, 18, 19, 20, 21, 22	Student passing Graduation Qualifiying Exams cannot be issued a waiver based diploma or certificate.	Students cannot be reported with a waiver based diploma or a certificate when they have passed their qualifying exams.
Graduation - 4	Error	IF student record has a DiplomaLevelType of "06", THEN student must have their record tied to StudentSpecialEducationProgramAssociation	Student must be identified as special education to issue a Certificate of Completion.	Students cannot be reported with a Certificate of Completion if they are not also identified as Special Education via the Special Education Program records.
Graduation - 5	Conflict	IF student record is submitted for 'Graduation' certification, THEN only a single school corporation is permitted to have this data	Student is not counted for Graduation, multiple schools claiming student as a graduate. See Conflicts	Students cannot be reported as a graduate by multiple schools. Only one school may report the graduate information.
Graduation - 6	Warning	IF student record is submitted for 'Graduation' certification AND student age is less than 16, THEN print "WARNING: Student should be at least 16 years old as of October 1st, collection year"	Student is not 16 years of age by October 1 of the graduating year. Verify student's DOB as of October 1 of graduating school year for accuracy.	Students reported as earning a diploma who are not 16 years of age will receive a warning message. This will not keep the student from being certified.
Graduation - 8	Error	IF AchievementCategoryDescriptor under PostSecondaryCompetency is NOT a Locally Created Pathway ("9")(2247), THEN the AchievementCategorySystem on the StudentAcademicRecord must default to "10000" or null	Postsecondary-Readiness Competency other than "Locally Created Pathway" does not utilize a Local Pathway.	Schools cannot report anything other than 10000 when reporting any Postsecondary-Readiness Competency other than Locally Created Pathway.
Graduation - 9	Error	IF AchievementCategoryDescriptor under Employability Skill has a value, THEN AchievementCategoryDescriptor under PostSecondaryCompetency must contain a value	Postsecondary-Readiness Competency other than "N/A or Did not Demonstrate" is required when Employability Skills are provided.	Schools must provide both Postsecondary-Readiness Competency and Employability Skills data together. Schools cannot provide one data without the other.
Graduation - 10	Error	IF AchievementCategoryDescriptor under PostsecondaryCompetency is populated, THEN the AchievementCategoryDescriptor under Employability Skill must be populated	Employability Skills other than "N/A or Did not Demonstrate" is required when a Postsecondary-Readiness Competency is provided.	Schools must provide both Employability Skills and Postsecondary-Readiness Competency data together. Schools cannot provide one data without the other.
Graduation - 11	Error	IF AchievementCategoryDescriptor under PostSecondaryCompetency is Academic Honors, THEN DiplomaLevelType must be "Core 40 with Academic Honors…" (02), "Core 40 with Technical Honors" (09), OR "Core 40 with Academic and Technical Honors" (16)	If Postsecondary-Readiness Competency is "Honors Diploma" then one of the Honors Diplomas must be issued.	Schools reporting a student's Postsecondary-Readiness Competency is Honors Diploma cannot report a diploma type earned other than 02, 09, or 16.
Graduation - 12	Error	IF AchievementCategoryDescriptor under PostSecondaryCompetency is "Waiver from Postsecondary-Ready Competency" ("10"), THEN DiplomaLevelType must be either "General" ("4") OR "Core 40 Only" ("13")	Postsecondary-Readiness Competency must be "Waiver from Postsecondary-Ready Competency" when issuing a "General(Evidence Based)" or "Core 40 Only(Evidence Based)" diploma.	Schools reporting a student's Postsecondary-Readiness Competency is Waiver from Postsecondary Readiness Competency cannot report a diploma type earned other than 04 or 13.
Graduation - 13	Error	If AchievementCategoryDescriptor under PostSecondaryCompetency is "Career-Technical Education Concentrator" ("07"), THEN there should be a "1" in either "Perkins4" OR "Perkins5"	Student with Postsecondary-Readiness Competency of "Career-Technical Education Concentrator" must be identified with either Perkins IV or Perkins V through InTERS reporting.	Students must be identified with either Perkins IV or V by DWD through InTERS reporting when providing a student's Postsecondary-Readiness Competency is Career-Technical Education Concentrator.
Graduation - 14	Error	If AchievementCategoryDescriptor under PostSecondaryCompetency is "State and Industry recognized Credential or Certification" ("05"), then there should be a "1" in the CertResult	Student with Postsecondary-Readiness Competency of "State and Industry recognized Credential or Certification" must have a Certification Result through InTERS reporting.	Students must be identified with a Certification Result by DWD through InTERS reporting when providing a student's Postsecondary-Readiness Competency is State and Industry recognized Credential or Certification.
Graduation - 15	Error	IF DiplomaLevelTypes are "1", "2", "3", "9", OR "16", AND the cohort year is 2023 or greater THEN student must have values both in AchievementCategoryDescriptor under Employability Skills AND AchievementCategoryDescriptor under PostsecondaryCompetency, ELSE error	Student in cohort year 2023 or later must have Graduation Pathway information provided.	Students in a cohort year greater than 2023 cannot be reported as earning any diploma without also providing Graduation Pathway information (Employability Skills and Postsecondary-Readiness Competency)
Graduation - 16	Error	IF student DiplomaLevelType CodeValue is set to "12" (International Baccalaureate Diploma), THEN school must be International Baccalaureate Program accredited	School is not approved to issue an International Baccalaureate diploma.	Schools cannot report students as earning a diploma of International Baccalaureate Diploma if they are not also identified on IDOE table as being an IB recognized school from the IB website.
Graduation - 17	Error	IF AchievementCategoryDescriptor under PostSecondaryCompetency is Locally Created Pathway ("9"), THEN the AchievementCategorySystem (LocalPathway) on the StudentAcademicRecord may only contain values "10001" through "99999" as defined on LocallyCreatedPathway table	Locally Created Pathway code is not valid.	Schools trying to report a locally created pathway number that is not approved and available from IDOE will fail. Currently there are only four available (https://drive.google.com/file/d/1sYEZ-8hiie_YOL_BSN5Y675EhY7U0Dxr/view ) missing from doc is 10004 - RAMP (Evansville School Corp)
Graduation - 19	Error	IF DiplomaLevelType is either "6" or "7" THEN AchievementCategoryDescriptor must be NULL AND AchievementCategoryDescriptor must NULL AND AchievementCategorySystem must also be NULL	Employability Skills, Postsecondary-Readiness Competency, and Local Pathway should not be submitted for students earning certificates.	Students earning a Certificate of Completion or Course Completion do not have Employability Skills or Postsecondary-Readiness Competency reported.
Graduation - 20	Error	IF DiplomaLevelTypes are "1", "2", "3", "9", OR "16", AND cohort year is less than 2023, THEN student must have values both in AchievementCategoryDescriptor under Employability Skills AND AchievementCategoryDescriptor under PostsecondaryCompetency, ELSE IF student cohort year < 2023 AND student passed ISTEP10 THEN OK, ELSE IF student cohort year < 2019 AND student passed ECAs, THEN OK, ELSE throw error	Student in cohort year prior to 2023 not passing Graduation Qualifying Exams cannot be issued the given Diploma Type unless Graduation Pathway information has been provided.	Students in a cohort year less than 2023 AND have not passed their qualifying exams cannot be reported as earning any diploma without also providing Graduation Pathway information (Employability Skills and Postsecondary-Readiness Competency) - report NA or Did Not Demonstrate when pathway was not utilized to obtain the diploma level (waiver)
Graduation - 21	Error	IF school is certifying their student data for 'Graduation', THEN the School must contain any of the following GradeLevelDescriptorIds: "09", "10", "11", "12"	Diplomas cannot be issued, school is not configured for grade levels 9 through 12.	Schools cannot report Graduate data if they are not identified as educating students in grades 9-12.
Graduation - 22	Error	If a student is less than the age of 19 and a graduate record exists, but no cohort year assignment found, then Error.	Student does not have a cohort year assigned. Please contact schoolaccountability@doe.in.gov.	Students under the age of 19 reported with a graduate record AND does not have a cohort year assigned from School Accountability will need to contact schoolaccountability@doe.in.gov (this should be rare)
Graduation - 23	Error	IF DiplomaLevelType (from DOE table) is either NULL/Blank, then Error	Student not counted for Graduation. Diploma Type provided, yet no Diploma Level provided.	Students will not be counted when only a diploma type (regular, certificate of attendance, certificate of completion) is provided. Students must have both diploma types and diploma levels provided. Diploma level is the actualy diploma earned.
Graduation - 24	Error	If the diploma type is evidence-based waiver (Any of the following: (04=General (Work Readiness Waiver 13=Core 40 Only (Evidence-based waiver or Waiver from Postsecondary Readiness Competency Requirements for Graduation Pathways) Then post_secondary ready competency MUST be any one of these: NA or Did Not Demonstrate, Waiver Postsecondary Readiness Competency, or NULL/BLANK. If not, ERROR	Waiver Postsecondary-Readiness Competency must be provided when a waiver diploma type is reported.	Schools reporting a student's diploma is 04-General (Work Readiness Waiver) or 13-Core 40 Only (Evidence-based waiver or Waiver from Postsecondary Readiness Competency Requirements for Graduation Pathways) THEN Waiver Postsecondary-Readiness Competency must be provided if student is in 2023or greater cohort.
Graduation - 25	Error	If Diploma Type is Certificate of Completion then Diploma Level Type must be equal to 06 Certificate of Completion (IEP program Completed), else error	Diploma Level provided is not allowed when reporting a diploma type of Certificate of Completion.	Students receiving a Certification of Completion (Diploma Level) then the diploma type must be Certificate of Completion.
Graduation - 26	Error	If Diploma Type is Certificate of Attendance then Diploma Level Type must be equal to 07 (Course Completion), else error	Diploma Level provided is not allowed when reporting a diploma type of Certification of Attendance.	Students receiving Course Completion (Diploma Level) then the diploma type must be Certificate of Attendance.

Excerpt

name	Validation Rules Homebound

Homebound

Rule #	Rule Type	Rule Logic	Rule Message	Notes
HomeBound - 1	Informational/Error	Beginning May 1st of the current collection year: IF studentProgramAssociation is Homebound AND Program EndDate is NULL or blank, THEN throw error	Student must be exited from Homebound/Hospitalized program when services end or no later than June 30th of the current school year.	Students identified as receiving Homebound or Hospitalized services and reported with a program association must have an exit date when the services are no longer being provided or provide June 30th (last date of the school year) if they receive services until the end of the year. The message will show as Informational until May 1st of each school year and will then show as an error until an end date is provided.
HomeBound - 2	Exclusion	IF the aggregate DayCount for that student/reportingcorp is less than the total of 20 days, THEN EXCLUSION	Homebound student not counted. Days of services received is below the required threshold of 20 days.	Students identified as receiving Homebound or Hospitalized services and reported with a program association record or records that do not add up to 20 days of services will throw the exclusion message. The student data will be received but the student will not be counted for certification or funding purposes.

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

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	Student not counted for Membership. Attendance records could not be found.

Excerpt

name	Validation Rules Pupil Enrollment

Pupil Enrollment

RuleID	Rule Type	RuleMessage	Notes
PupilEnrollment-1	Informational	Student is not counted for Pupil Enrollment, primary school is false.	Student School Association (enrollment) record has the school identified as 'false' and this could be an accurate message if the enrollment record is correct.
PupilEnrollment-2	Informational	Invalid grade value	Grade level might be reported without leading zero. Only PK -13 is allowed.
PupilEnrollment-3	Conflict	Student is not counted for Pupil Enrollment, multiple schools claiming student for enrollment. See Conflicts	Conflict is on the Student School Association (enrollment) date either the same entry/exit date or overlapping. There is no dates on the Ed Org record.
PupilEnrollment-5	Error	Students must have an active SSA before or on Census Date to be counted.	Student School Association must have enrollment date on or before count date and not prior to the first calendar date.

Excerpt

name	Validation Rules Special Education

Special Education

Rule #	Rule Type	Rule Logic	Rule Message	Notes
SpecialEducation - 1	Error	IF Special Education Program Association equals "56" (Parentally placed in private school) OR "38" (Parentally placed in private preschool), THEN public schools CANNOT be given "TRUE" as Primary Schools	Public school cannot be the primary school for students reported as parentally placed in a private school setting.	PUBLIC SCHOOLS: For the reporting LEA the Student School Association (enrollment) record should show the school = False and the school ID must be a school that belongs to/resides in the reporting LEA
SpecialEducation - 2	Exclusion	IF student's age is 23 years on OR after July 1st, THEN do not count towards Special Education Program	Student not counted for Special Education, student is older than 22 years of age by count date.	A student cannot be 23 years of age as of July 1st for the reporting school year. A student can be 22 years + months/days as long as they are not 23 years of age on or by July 1st of the reporting school year.
SpecialEducation - 3	Exclusion	IF student is NOT 3 years old OR older by count date, THEN special ed funds will not be applied to student.	Student not counted for Special Education, student is not 3 years of age by count date.	A student must be at least 3 years old on count date(s) to report and generate funding.
SpecialEducation - 4	Exclusion	IF certifying for Special Education AND ProgramType is Special Education, THEN SpecialEducationProgramAssociation must denote an EntryDate prior to or on count date AND an ExitWithdrawDate after or on count date.	Student not counted for Special Education, inactive enrollment record on count date.	Students will not be counted for SE funding if they do not have an ACTIVE program record with a start date prior to or on a count date with no exit date and exit reason terminating the services.
SpecialEducation - 5	Error	IF student's Primary Exceptionality is code 8 (Developmental Delay), THEN student's age must be younger than 9 years by December 1st.	Primary Exceptionality Code 8 (Developmental Delay) cannot be reported for a student at the age of 9 as of December 1st.	Students cannot be 9 years of age as of December 1st and be reported with an exceptionality (disability) of Developmental Delay; either primary or secondary.
SpecialEducation - 6	Error	IF student's Secondary Exceptionality is code 8 (Developmental Delay), THEN student's age must be younger than 9 years by December 1st.	Secondary Exceptionality Code 8 (Developmental Delay) cannot be reported for a student at the age of 9 as of December 1st.	Students cannot be 9 years of age as of December 1st and be reported with an exceptionality (disability) of Developmental Delay; either primary or secondary.
SpecialEducation - 7	Error	IF student is 5 years of age (OR LESS) by count date AND grade level is PK, THEN Special Education Program Association must be either of the following: 26, 27, 28, 29, 33, 34, 35, 36, 37, 38	Student's Placement Type is not valid with student's grade level.	Students who are in grade level PK and are 5 years old (or less) by count date must be reported with a program associated to legacy/historical Preschool Codes (26-38)
SpecialEducation - 8	Error	IF a student has a Special Education Program Association to 26, 27, 28, OR 29, THEN only the following Special Education Settings (Location Codes) are allowed: 01 (Community-Based Preschool/Head Start), 02 (Medical/Mental Health Placement), 04, 06, 09 (Private Vendor), 10 (Non-Public School) OR may remain BLANK	Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.	Review or Refer to Program Names and Setting Codes resource document
SpecialEducation - 9	Error	IF a student has a Special Education Program Association to 33, 34, OR 35, THEN only the following Special Education Settings (Location Codes) are allowed: 02 (Medical/Mental Health Placement), 04, 09 (Non-Public School) OR may remain BLANK	Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.	Review or Refer to Program Names and Setting Codes resource document
SpecialEducation - 10	Error	IF a student has a Special Education Program Association to 36 (Receiving majority of hours at service provider or some other location), THEN the use of Special Education Settings (Location Codes) are NOT allowed	Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.	Review or Refer to Program Names and Setting Codes resource document
SpecialEducation - 11	Error	IF a student has a Special Education Program Association to 37 (Receiving majority of hours at home), THEN only the following Special Education Settings (Location Codes) are allowed: 01 (Community-Based Preschool/Head Start), 02 (Medical/Mental Health Placement), 04 (Court-ordered Placement), OR may remain BLANK	Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.	Review or Refer to Program Names and Setting Codes resource document
SpecialEducation - 12	Error	IF a student has a Special Education Program Association to 38 (Parentally placed in private preschool), THEN the Special Education Setting (Location Codes) must be 10 (Non-Public School)	Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.	Review or Refer to Program Names and Setting Codes resource document
SpecialEducation - 13	Error	IF a student has a Special Education Program Association to either 50-57, THEN only students from grade levels KG through 13 that is also 22 years of age or younger by July 1st (of reporting year) OR grade level PK that is between the ages of 6 and 22 are to be counted	Student's Placement Type is not valid with student's grade level.	Students who are in grade level KG-13 and are less than 23 years old by July 1st of the reporting year OR have a grade level of PK and are age 6 must be reported with a program associated to legacy/historical School Age Codes (50-57)
SpecialEducation - 14	Error	IF a student has a Special Education Program Association to 50, 51, 52, 53, OR 54, THEN only the following Special Education Settings (Location Codes) are allowed: 02 (Medical/Mental Health Placement), 03, 04, 06, 09 (Private Vendor), 10 (Non-Public School) OR may remain BLANK	Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.	Review or Refer to Program Names and Setting Codes resource document
SpecialEducation - 15	Error	IF a student has a Special Education Program Association to 55 (Correctional facility), THEN the Special Education Setting (Location Codes) must be 04	Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.	Review or Refer to Program Names and Setting Codes resource document
SpecialEducation - 16	Error	IF a student has a Special Education Program Association to 56 (Parentally placed in private school), THEN the Special Education Setting (Location Codes) must either be 10 (Non-Public School) OR 03 (Homeschool)	Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.	Review or Refer to Program Names and Setting Codes resource document
SpecialEducation - 17	Error	IF a student has a Special Education Program Association to 57 (Home services determined by CCC), THEN the Special Education Setting (Location Codes) must be 02 (Medical/Mental Health Placement), 04, OR may remain BLANK	Special Education Settings (Formally known as Location Code) is not allowed for the given Special Education Program (Formally known as Placement Type) reported.	Review or Refer to Program Names and Setting Codes resource document
SpecialEducation - 18	Exclusion	If Student does not have placement data as of the count date, exclude record	Student has no placement data as of the count date.	Students reported with program of UNDEFINED have not been placed in a program yet as of count date will be excluded.
SpecialEducation - 19	Exclusion	IF IDEA Eligibility is false, THEN Exlcude record	Student has not been reported as eligible for IDEA services as of the count date.	Students who have "FALSE" for their eligibility as of count date will be excluded. This could be students who were evaluated and found to not be eligibile for services. These could be students who are currently being evaluated for services and the evaluation has not been completed. Students terminated from services should NOT be flipped to "false" as they were special education and IDOE will not count these students for funding purposes when the exit date with termination reason is provided.

Excerpt

name	Validation Rules Special Education Evaluation

Special Education Evaluation

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

Rule 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 33

New Version 34

Key

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

Membership

RuleID

Rule Type

RuleMessage

Notes

Pupil Enrollment

RuleID

Rule Type

RuleMessage

Notes

Special Education

Rule #

Rule Type

Rule Logic

Rule Message

Notes

Special Education Evaluation

Rule #

Rule Type

Rule Logic

Rule Message

Notes

Special Education Termination

Rule #

Rule Type

Rule Logic

Rule Message

Notes

Staff

Rule #

Rule Type

Rule Message

Notes

Title I

Rule #

Rule Type

Rule Logic

Rule Message

Notes