Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt
nameValidation Rules Course Outcomes

Course Outcomes

Rule Id

Rule Type

Rule Logic

Rule Message

Notes

Course Completion - 1

Error

IF certifying school personnel AND is assigned to an IB AcademicSubjectDescriptor, THEN School must be IB accredited

Error - School has not been identified as providing IB courses for the current school year.

IDOE has a separate table where schools that have identified themselves as providing IB courses is listed. If a school is not on the table the error message will trigger. Schools should submit a help ticket after confirming they are listed on the IB site as an IB school and IDOE staff will work to have the school added to the list.

Course Completion - 3

Error

IF Course Result (courseAttemptResultType) is "No grade awarded", THEN finalNumericGradeEarned must remain blank

Error - When "No Grade is Awarded" a grade earned cannot be reported.

Schools cannot report a grade/GPA (0.0-4.0) earned when the student is reported for the class as 'no grade awarded'.

Course Completion - 4

Error

IF submitted a finalNumericGradeEarned, THEN the values must be between 0 through 4.0

Error - Grades Earned can only have a numeric value between 0.0 to 4.0.

Students completing a high school or credit bearing course MUST have a final numeric grade (GPA) provided (0.0-4.0). Letter or alpha grades will not be accepted. Elementary and Middle school courses do not require a numeric grade (GPA) provided. If a school tries to send a numeric grade outside of 0.0-4.0 range the record will fail.

Course Completion - 5

Error

IF CreditType is "Dual Credit", THEN a PostsecondaryInstitution is required

Error - A Post-Secondary Institution must be provided when Dual Credit is awarded.

Schools providing the credit type of 'Dual Credit' and do not provide one of the post-seconday instrution codes will fail.

Course Completion - 6

Error

IF Course Result (courseAttemptResultType) is "Pass" OR "Fail", AND High School Level Course is "True", THEN finalNumericGradeEarned cannot be Null or Blank

Error - When "Pass" or "Fail" is provided a grade earned must be reported.

Students completing a high school course and receiving a result of 'Pass' or 'Fail' MUST have a final numeric grade (GPA) provided (0.0-4.0).

Course Completion - 7

Error

If High School Level Course is "True" AND Course Result (courseAttemptResultType) is "Pass" then earnedCredits must be greater than 0 AND CreditType cannot be 'null' OR Blank

Error - When "Pass" is reported for a High School course the Credits Earned must be greater than zero and the type of Credit Earned must be provided.

Students completing a high school course and receiving a result of 'Pass' MUST have the credits earned greater than zero (0) and the type of credit earned MUST be provided. Allowable Credit Types are Regular, Dual, or Applied Unit.

Course Completion - 8

Exclusion

If Unique Section Code is blank or null, then exclusion

Exclusion - Student is reported as enrolled. No schedule or course records provided.

Students with a student school association (enrollment) record provided at any point in time during the school year would also be expected to have a schedule (student section data). Exceptions to this expectation are those students with a one day mobility record prior to the school year or service only students given enrollment to have the ability to report a program association. Students may need a one day mobility record to provide course completion (student transcript) occuring over the summer and does not actually attend during the school year.

Course Completion - 9

Exclusion

If Course Result (Course Attempt Result Type) is blank or null, then exclusion

Exclusion - Student is reported with a schedule/course records. No course completion data provided.

Students with a schedule (student section data) and course completion (student transcript) data has not been provided will fail. IDOE is working on a solution to not show this error until course completion is expected during the school year.

Course Completion - 10

Error

IF no matching StaffSectionAssociation.staffUSI is found for provided StudentSectionAssociation record, THEN fail

Error - Student Course Completion record does not have a matching Staff Section Record. Details [Course Code, Section Code, Term]

Student schedules (student section data) must have a Staff record that matches. This is used to tie the student to the teacher. Data viewed for the match is the course code, the section code and the term the course is scheduled. If these do not align the record will fail.

Course Completion - 11

Error

Medium of Instruction cannot be 'null' or blank

Error - Medium of Instruction must be provided.

Medium of instruction must be provided for every course. Schools must identify if the student is being taught 1. Face-to-face (traditional classroom with teacher) 2. Technology-based instruction in classroom (sitting in a school building but taught via computer/online instruction, credit recovery as an example) 3. Virtual/Online Distance Learning (not sitting in a school building and being taught via computer/online instruction). Medium of instruction may be located in the course master and schools should confirm with their SIS vendor where the field is located for data input.

Course Completion - 12

Error

IF assigned Student GradeLevels from 9 through 12, and grade level match is "false" then throw Error

Error - Subject code provided is only valid for grade levels PK-8. Details [Course Code, Section Code, Term]

Students reported with high school grade level MUST be reported with a state assigned high school course code. High school students cannot be reported with an elementary or middle school course code. Schools should check to make sure the local course is not mapped to a state identified elementary or middle school course code.

Course Completion - 13

Warning

IF assigned Student GradeLevels from PK through 6, and grade level match is "false" then throw Warning

Warning - HS subject codes are typically valid for students in grades 7-13. Check subject code for accuracy.

Students reported with grade levels PK - 6th and enrolled in an identified high school course will receive this warning message. Schools should check to make sure the elementary grade level student is enrolled in the accurate course and the local course is mapped to the correct state course code.

Course Completion - 14

Error

If High School Level Course is True AND Course Result (courseAttemptResultType) is "Pass" then Final Numeric Grade Earned must be greater than 0 AND cannot be 'null' OR Blank

Error - When "Pass" is reported for a High School course the Final Grade Earned must be greater than zero.

Students completing a high school course and receiving a result of 'Pass' MUST have a final numeric grade (GPA) provided that is greater than 0.0.

Course Completion - 15

Error

If High School Level Course is True AND Course Result (courseAttemptResultType) is "Fail" then earned credits must be Zero AND CreditType cannot be 'Null' OR Blank

Error - When "Fail" is reported for a High School course the Earned Credit must be zero and Credit Type must be provided.

Students completing a high school course and receiving a result of 'Fail' MUST have the credits earned reported as zero (0) and the type of credit the student was trying to earn MUST be provided. Allowable Credit Types are Regular, Dual, or Applied Unit.

Course Completion - 16

Error

If High School Level Course is "False", then THEN earnedCredits AND CreditType must remain Null or Blank

Error - Earned Credits cannot be provided when a non-High School course is reported.

Schools cannot report earned credits or credit types when the subject is not an identified high school subject/course code.

Note: Deactivated 5/6/22

Excerpt
nameValidation 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
nameValidation 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
nameValidation 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.