RuleID | Message Type | Rule Logic | RuleMessage | Notes |
|---|
Membership Enrollment - 1 | Error | RULE: IF ResponsibilityTypeDescriptor is Funding, THEN student record must report an ADM Type | ADM Type is required | Check the student ed org responsibility association record or membership record to see if responsibility of Funding has been provided and if the ADM is blank. IF ADM is blank and the school expects to recieve funding then an ADM code needs to be reported. IF a school does not expect to recieve funding then the responsibility should be corrected from Funding to Attendance. |
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. | This is a possible accurate exclusion message if the school does not expect to receive funding and a Primary Responsibility of Attendance is reported on the student ed org responsibility association or membership record. |
Membership Enrollment - 3 | 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. The county name is provided on the student record with a student`s address. |
Membership Enrollment - 4 | Exclusion | RULE: 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 | General Education Students with exit code 33 on the Student School Association (enrollment) record 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 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 | RULE: IF certifying for Membership, THEN Student CANNOT have GraduationRecordType of anything other than "6" OR "7” | Student not counted. Graduate record exists. | Students who have earned a diploma and reported with graduate data cannot be reported for membership. |
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 | Schools may only report ADM 20 for adult learners enrolled at an identified Adult Charter school and are in grade levels 9-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 | 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. | Membership Enrollment - 17 | Error | RULE: 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 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. | Only traditional public schools or charter schools can report ADM type 1. |
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. | Schools must provide instructional days and minutes for IDOE to calculate a student`s FTE and determine if the student is enrolled less than 50% and allowed for reporting ADM 6. Formula is ((Funding Instructional Days divided by 180) times Funding Instructional Minutes) divided by (Calendar Instructional Minutes divided by Calendar Instructional Days) times 1.05 |
Membership Enrollment - 24 | Error | 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 | COLS must be the same ID as reporting corporation when reporting 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. | Schools must provide Instructional days and Instructional minutes when reporting ADM 6 for FTE calculation and when reporting ADM 20 for adult learners per statute requirements |
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. | Corporation of Legal Settlement is missing or is not reported as a public LEA 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. | Charter schools may only provide ADM 1 or 6 on students. Identified Adult Charter schools may only provide ADM 20 on students. |
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. | Schools can report any ADM except 20 on students in grade levels KG-13 (20 is for students in grade 9-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. | NonPublic Schools not identified as participating in the Choice program cannot report ADM 10 |
Membership Enrollment - 32 | Conflict | 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. Conflicted with: (SchoolId) - (Entry Date) - (Exit Date) | Membership Enrollment - 34 | ExclusionConflict is on the Student School Association (enrollment) dates either the same entry/exit date or overlapping entry/exit dates. |
Membership Enrollment - 34 | Exclusion | 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 | Students must have a Student School Association (enrollment) record with entry date prior to count date(s) and no exit date provided or an entry date prior to count date(s) with the exit date after the count date(s) to be considered an active enrollment for membership. |
Membership Enrollment - 35 | Error | RULE: IF ADM Type 1, 3, 4, 5, 10, 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. | Primary school on School Association (enrollment) record must be true for ADM 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 | RULE: IF Funding ResponsibilityTypes exists for both ADM Type 6 AND 10, THEN Primary School for ADM 6 must be FALSE AND Primary School for ADM 10 must be TRUE | When dual enrollment is reported, Primary School 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 for ADM 6 and true for ADM 10and Primary school on School Association (enrollment) for non-public school with ADM 10 must be true. |
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 | Error | Student with grade level KG cannot be reported as dual enrolled | Student with grade level KG cannot be reported as dual enrolled. | Students with any of the KG grade levels cannot be reported with ADM 6 (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. | NonPublic Schools identified as participating in the Choice program cannot report ADM 6 or 20 |
Membership Enrollment - 43 | Error | IF certifying for Membership THEN Accountability must be provided. | Accountability School must be provided. | Schools must provide the additional responsibility of Accountable School |
Membership Enrollment - 44 | 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 | Students over the age of 22 cannot be certified for membership (unless in an adult charter school) |
Membership Enrollment - 45 | 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. | Student does not have enough virtual or virtual COVID attendance data reported to support the virtual program. |
Membership Enrollment - 46 | Error | 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 vitual or virtual COVID attendance data. |
Membership Enrollment - 47 | 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. | Schools must have a calendar and calendar dates provided. Schools must have attendance data provided prior to the count date(s). |
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) | Schools claiming a student for funding with different or matching ADM codes will get this conflict message. This is not on the enrollment data but on the funding record where the begin/end dates of the funding record match or overlap. Only ADM 6 and 10 are allowed by two reporting schools. Cannot have ADM 1 and 5, 1 and 3, 1 and 1, etc. |