Versions Compared

Key

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

...

Excerpt
nameValidation Rules Calendar

Calendar

Waiver days should be reported as zero (0) unless the school has received an approved waiver day from IDOE Accountability department. This may remain at zero (0) throughout the year or until an approved waiver day is granted from IDOE Accountability department. An error will trigger if no data is provided

Rule #

Message Type

Rule Logic

Rule Message

Notes

Calendar - 1

Error

BeginDate of calendar year must be on OR after July 1st AND EndDate of calendar year must be on OR before June 30th

Calendar dates for current school year must be between July 1st and June 30th.

School calendars must have a begin date on or after July 1st and an end date on or prior to June 30th of the current reporting year. If the begin or end dates are not within these calendar dates this will trigger the error message.

Calendar - 2

Warning

IF CalendarType is Student Specific Elementary, THEN total Instructional Minutes must be >= 54,000 AND GradeLevelDescriptors must be between KG through 06

Student Specific Elementary Calendar must be reported for schools with grade levels less than or equal to grade 06 and total Instructional time should be at least 54,000 minutes for the school year.

Schools with grade levels of PK-6 may utilize Student Specific Elementary calendar type and report at least a total of 54,000 instructional minutes. Schools utilizing the Elementary calendar type for schools with higher grade levels or not reporting a minimum of 54,000 instructional minutes will trigger the WARNING message. This does not keep a school from certifying the data.

Calendar - 3

Warning

IF CalendarType is Student Specific Secondary, THEN Instructional Minutes must be >= 64,800 for any GradeLevelDescriptors 07 and above

Student Specific Secondary Calendar must be reported for schools with any grade level higher than or equal to grade 07 and total Instructional time should be at least 64,800 minutes for the school year.

Schools with grade levels of 7-12 may utilize Student Specific Secondary calendar type and report at least a total of 64,800 instructional minutes. Schools utilizing the Secondary calendar type for schools with lower grade levels or not reporting a minimum of 64,800 instructional minutes will trigger the WARNING message. This does not keep a school from certifying the data.

Calendar - 4

Warning

IF CalendarType is Student Specific Non-Compulsory, THEN Instructional Minutes must be >=100 AND GradeLevelDescriptor must be PK

Student Specific Non-Compulsory Calendar must be reported for schools with grade levels of PK and/or KG only. and Instructional time must be at least 100 minutes.

Schools with grade levels of PK-PK or PK-KG only may utilize Student Specific Non-Compusory calendar type and report at least 100 instructional minutes. Schools utilizing the Non-Compulsory calendar type for schools with grade levels higher grade levels will trigger this WARNING message. This does not keep a school from certifying the data but may cause School Accountability office to send a notice of incorrect data being provided.

Calendar - 5

Error

IF ScheduleDescriptor is blank, THEN error

School schedule is missing.

Schools must provide and identify the type of schedule is associated to the school calendar (traditional, block 4, trimester, etc.) Schedule description not provided will trigger the error message.

Calendar - 6

Error

IF BeginTime is blank, THEN error

Instructional begin time is missing or invalid.

Schools must provide the begin time of their school day. Begin time not provided will trigger the error message.

Calendar - 7

Error

IF EndTime is blank, THEN error

Instructional end time is missing or invalid.

Schools must provide the end time of their school day. End time not provided will trigger the error message.

Calendar - 8

Error

IF Non-Instructional Minutes is blank, THEN error

Non-Instructional Minutes is missing or invalid.

Schools must provide the number of Non-Instructional minutes (lunch, recess) of a typical school day. Non-Instructional minutes not provided will trigger the error message.

Calendar - 9

Error

IF InstructionalTimeInMinutesIndicator is blank, THEN error

Instructional time in minutes indicator is missing or invalid.

Schools must identify if they are considered a Performance-Qualified School District or High School by providing `true` or `false` date in the Instructional Time in Minutes Indicator field. Instructional Time in Minutes Indicator not provided will trigger this error message.

Calendar - 10

Error

IF TotalWaiverDays is blank, THEN error

Total waiver days are missing or invalid.

.

Calendar - 11

Warning

IF certifying Calendar for a Public school, THEN at least 180 CalendarEvent(s) must consist of "Student Calendar", "Delay/Early Dismissal - Weather", "Delay/Early Dismissal - Other", and "Waiver Day"

Calendar dates is less than the minimum requirement of 180 days. In order to avoid financial penalty, school(s) must have approved waiver days(s) on file with School Accountability.

Schools should provide a minimum of 180 days with one of the Calendar Event descriptors identified as a student instructional day (Student Calendar, E-Learning, Delay/Early Dismissal-Weather, etc.). Schools not providing 180 student instructional days will trigger this WARNING message. This will not keep a school from certifying the data.

Calendar - 12

Warning

If a school provides more than 3 aggregate event days (Virtual Planned - Asynchronous, Virtual Unplanned - Asynchronous, Virtual Covid - Asynchronous) then throw warning.

Asynchronous virtual days in excess of 3 do not count towards the 180 day instructional day requirement.

Schools reporting additional Asynchronous virtual days equaling more than three will receive a WARNING message letting them know they have provided more than three calendar event dates of any asynchronous virtual descriptors. This will not keep a school from certifying the data.

Calendar - 13

Error

Event Minutes cannot be greater than 600 (10hours), then error.

Event Minutes cannot be greater than 600 (10hours)

Schools providing more than 600 event minutes on any calendar date will receive the error message. Schools cannot report more than 600 minutes on any given school calendar date.

Calendar - 14

Error

Event Minutes cannot be less than 0 (zero), else error

Event Minutes cannot be less than zero

Schools providing less than 0 event minutes on any calendar date will receive the error message. Schools cannot report less than 0 minutes on any given school calendar date.

Calendar - 15

Error

Event Duration cannot be less than 0 (zero) else fail

Event Duration cannot be less than zero

Schools providing less than 0 on the event duration on any calendar date will receive the error message. Schools cannot report less than 0 event duration on any given school calendar date.

Calendar - 16

Error

Event Duration cannot be more than 1 (one), else error

Event Duration cannot be more than one.

Schools providing more than 1 on the event duration on any calendar date will receive the error message. Schools cannot report more than 1 event duration on any given school calendar date.

Excerpt
nameValidation Rules Certified Educator

Certified Educator

Rule Id

Message Type

Rule Logic

Rule Message

Notes

Certified Educator - 1

Warning

ContractSalary was above 30000 and percent of time employed `[TotalTimeEmployed]’ less than 50, throw warning

Current year salary is high for Percentage of Time Employed, verify salary and time employed is accurate.

Schools providing a staff employment record with a salary higher than 30,000 and the FTE is less than 50% will receive this WARNING message. This will not keep a school from certifying their data.

Certified Educator - 2

Warning

If contract salary is below 3000 and contract days is greater than 100, THEN throw warning

Current year salary is less than $3,000, verify salary is accurate.

Schools providing a staff employment record with a salary less than 3,000 and the contract days are more than 100 will receive this WARNING message. This will not keep a school from certifying their data.

Certified Educator - 3

Warning

If historical records are <= total years experience being submitted, throw error

Experience normally increases each year with successive employment. Verify years of experience is accurate.

Schools will receive a WARNING message if the years of experience reported on the staff employment record is not increased by one from data provided to IDOE in a previous school year. This will not keep a school from certifying their data.

Certified Educator - 5

Warning

Prior Salary is higher than current salary.

Current year salary is less than prior year, verify salary is accurate.

Schools will receive a WARNING message if the current salary being provided is less than the salary provided to IDOE in a previous school year. This will not keep a school from certifying their data.

Certified Educator - 6

Warning

ContractSalary entered was too high for the amount of ContractDays submitted (salary higher than 200000 and contract days less than 100)

Current year salary is high for Contract Days, verify salary and contract days are accurate.

Schools will receive a WARNING message if the current salary being provided is more than 200,000 and the contract days are less than 100. This will not keep a school from certifying their data.

Certified Educator - 8

Warning

IF certifying for CE AND school staff is employed at a Public School AND their ContractDays submission is 26 days or less, THEN throw warning

Current year contract day(s) is too low, verify contract days accuracy.

Schools will receive a WARNING message if the contract days provided is less than 27. This will not keep a school from certifying their data.

Certified Educator - 9

Error

IF certifying for CE THEN their ContractSalary must be <= $300,000

Staff Contract Salary must be equal to or less than $300,000.

Schools reporting a staff with a salary more than 300,000 will receive this error message. If a school has a staff being paid more than 300,000 they should contact IDOE support for review of the data to allow a higher salary amount to be provided.

Certified Educator - 10

Error

IF certifying for CE, THEN staff must either have "0" through "70" as their YearsOfPriorProfessionalExperience. "0" indicates as their first year

Staff Years of Experience must be a value between 0 and 70.

Schools reporting a staff with years of experience less than 0 will receive this error message. Staff must have at minimum 0 years of experience provided. Schools reporting a staff with years of experience greater than 70 will receive this error message. If a school has a staff member with more than 70 years of experience they should contact IDOE support for review of allowing a higher years of experience data to be provided.

Certified Educator - 11

Error

IF educator is reporting as 0 years of YearsOfPriorProfessionalExperience, THEN historical SPN data from years prior CANNOT exist

Staff has prior year employment.

Schools reporting 0 for a staff that has prior year experience provided to IDOE will receive this error message. Staff that have been reported to IDOE with prior years experience cannot be reported with 0.

Certified Educator - 12

Error

Supp salary is out of the accepted range, it must be between 0 and 40000.

Supplemental Salary cannot be more than $40,000.

Schools reporting a staff with a supplemental salary more than 40,000 will receive this error message. If a school has a staff being paid more than 40,000 in supplemental salary they should contact IDOE support for review of the data to allow a higher supplemental salary amount to be provided.

Certified Educator - 13

Error

Staff must have Contract Days, Contract Salary, Supplemental Salary, and Percentage of Title I Salary provided.

Staff must have Contract Days, Contract Salary, Supplemental Salary, and Percentage of Title I Salary provided.

Public/Charter schools must provide contract days, contract salary, supplemental salary, and percentage of Title I salary provided. If this data is not provided the error message will be received.

...