Versions Compared

Key

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

...

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