Versions Compared

Key

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

...

Excerpt
nameValidation Rules Course Outcomes

Course

Completion

Outcomes

Rule Id

Message Type

Rule Logic

Rule Message

Notes

CourseCompletion - 1

Error

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

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.

CourseCompletion - 3

Error

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

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`.

CourseCompletion - 4

Error

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

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.

CourseCompletion - 5

Error

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

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 IDs will fail.

CourseCompletion - 6

Error

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

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).

CourseCompletion - 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

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.

CourseCompletion - 8

Exclusion

If Unique Section Code is blank or null, then 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, students with an active ed org association for funding and ADM is 2, or service only students given enrollment with primary school `false` 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. Schools will be given a ten day grace period from the time of enrollment to provide student section data.

CourseCompletion - 10

Error

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

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.

CourseCompletion - 11

Error

Medium of Instruction cannot be `null` or blank

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.

CourseCompletion - 12

Error

IF assigned Student GradeLevels from 9 through 12, and grade level match is "false" then throw 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.

CourseCompletion - 13

Warning

IF assigned Student GradeLevels from PK through 6, and grade level match is "false" then throw 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.

CourseCompletion - 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

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.

CourseCompletion - 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

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.

...

Excerpt
nameValidation Rules Graduation
Graduation

Graduate

Rule #

Message 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

Graduation pathway data must not be submitted when issuing a Work Readiness Wavier Diploma.

Schools cannot report Graduation Pathway data 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" or an Alternate Diploma(23), THEN student must have their record tied to StudentSpecialEducationProgramAssociation

Student must be identified as special education to issue a Certificate of Completion or an Alternate Diploma.

Students cannot be reported with a Certificate of Completion or an Alternate Diploma if they are not or were 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. Conflicted with: (SchoolId)

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 may leave Locally Created Pathway blank/null or provide 10000 when a Locally Created Pathway is not identified. Schools cannot report anything other than 10000, blank, or null 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), "Diploma Level" (24), "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, 16, or 24.

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 CTE Program association of 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 CTE Program association of Industry Certification 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 equal to or 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. The current available list can be found here: (https://www.in.gov/doe/files/Locally-Created-Pathways-v2.pdf)

Graduation - 19

Error

IF DiplomaLevelType is either "6" or "7" THEN AchievementCategoryDescriptor must be NA or Did Not Demonstrate or Null/Blank

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", "16", OR "24", 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)

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 diploma, certificate of attendance, certificate of completion, alternate diploma) is provided. Students must have both diploma types and diploma levels provided. Diploma level is the actual 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 2023 or 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.

Graduation - 27

Error

Students in a cohort year greater than the current year should not be eligible for a waiver diploma of any type (4,11,13,14,15,18,19,20,21,22). Students in the 2022 or later should not be eligible for a waiver.

Early graduates (i.e. students in future cohort years) are not eligible for a waiver diploma.

Students graduating prior to their cohort year cannot be reported with any of the waiver diplomas.

Graduation - 28

Exclusion

July collection: If DiplomaAwardDate is not between 10-01-[SchoolYear] – 1 and 06-30-[SchoolYear], then throw an exclusion  October collection: If DiplomaAwardDate is not between 10-01-[SchoolYear] – 2 and 09-30-[SchoolYear] - 1, then throw an exclusion

Diploma award date must be between {submission open date} and {submission close date} during this collection period

Students being certified for October must have a Diploma Award Date of 10/1 (prior school year) to 9/30 (current school year). Students being certified for July must have a Diploma Award Date of 10/1 (current school year) to 6/30 (current school year).

Graduation - 29

Error

If postsecondary-readiness competency is Alternate Assessment for Alternate Diploma then diploma level type must equal Alternate Diploma; else fail.

If Postsecondary-Readiness Competency is “Alternate Assessment for Alternate Diploma” then Alternate Diploma must be issued.

Students being reported with Postsecondary-Readiness Competency of Alternate Assessment for Alternate Diploma must have the diploma level `Alternate Diploma` reported.

Graduation - 30

Error

If Diploma Type is Alternate Diploma then Diploma Level Type must be equal to XX (Alternate Diploma), else error

Diploma level reported is not allowed with the diploma type reported.

Students receiving an Alternate Diploma  (Diploma Level) then the diploma type must be Alternate Diploma.

Graduation - 31

Error

If local pathway == 10007 and school is not Adult School, throw error

Locally Created Pathway code is not valid for the reporting Education Organization.

Students cannot be reported with Locally Created Pathway of 10007 if their diploma is not being awarded from an IDOE identified Adult Charter School.

...