FileSpecRules:202706JuneCycleSchoolCalendarHeader
Item_Number Item_Name Collection_Rule_ID Severity Business_Rule Short_Title General_Message Detailed_Message
005 Collection Version CHR00001 E Some fields supply data that is essential for the analysis of student data. The value of that field must be explicit. There are no default values. One or more required fields are missing Some fields supply data that is essential for the analysis of data. A value must be provided. There are no default values. The record is missing the field {0}.
005 Collection Version CHR00020 E Field exceeds its maximum length Field exceeds its maximum length Field exceeds its maximum length. The {0} field exceeds its maximum allowable length of {1} character(s).
005 Collection Version CHR00100 E CollectionVersion must match '2027JunSchoolCalHeader' CollectionVersion must be '2027JunSchoolCalHeader' The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2027JunSchoolCalHeader'.
010 Current School Year CHR00110 E CurrentSchoolYear must match '2027' CurrentSchoolYear must be '2027' The CurrentSchoolYear identifies the school year for the data. For this collection the CurrentSchoolYear must be '2027'.
010 Current School Year CHR00260 E Each record must be unique based on the combination of reportingDistrictCode, reportingSchoolCode, beginGrade, endGrade, and currentSchoolYear. Duplicate record. Another record already exists with the same combination of district, school, grade range, and school year. Each combination must be unique.
025 Reporting District Code CHR00120 E ReportingDistrictCode must match a valid DESE County District Code. District codes are in DESE District table. Invalid Reporting District Code. ReportingDistrictCode is not a valid district code.
025 Reporting District Code CHR00121 E ReportingDistrictCode must match the SRM user's district code. The record is not from this district The ReportingDistrictCode does not equal that of the trial.
030 Reporting School Code CHR00130 E ReportingSchoolCode must be a valid school code in the Reporting District (Reporting District Code) Use MOSIS District Table and MOSIS Attendance Center tables. ReportingSchoolCode is not valid for ReportingDistrictCode ReportingSchoolCode is not a valid school code for the ReportingDistrictCode.
035 Date Calendar Adopted CHR00140 E DateCalendarAdopted, beginDate, endDate, and dateVotersApproved4DayWeek must be a valid calendar date in mm/dd/yyyy format. Invalid date format. Date must be a valid date in mm/dd/yyyy format. The {0} value ({1}) must be a valid date in mm/dd/yyyy format.
040 Begin Grade CHR00150 E BeginGrade and endGrade must be in code set: (Student_Grade_Level_Codes). Invalid grade level. Grade must be a valid grade level code. The {0} value ({1}) is not a valid grade level code.
040 Begin Grade CHR00160 E Reference MO-2007-21-2007-K8 Indicator Business Rules-V1.2-JY.doc BeginGrade not taught in school BeginGrade not taught in school.
040 Begin Grade CHR00270 E BeginGrade must not be greater than endGrade in grade order. Invalid grade range. Grade range is invalid. Begin grade must not be greater than End grade.
040 Begin Grade CHR00330 E BeginGrade and EndGrade must represent the same type of day. Grades PKA and KA are considered AM half-day; PKP and KP are considered PM half-day; all other grades (K, 01, 02 - 12) are considered full-day. The grade range must be either both AM half-day, both PM half-day, or both full-day. Inconsistent grade day type. Grade range must use a consistent day type. Both grades must be AM half-day (PKA or KA), PM half-day (PKP or KP), or full-day grades (K, 01 - 12).
045 End Grade CHR00165 E Reference MO-2007-21-2007-K8 Indicator Business Rules-V1.2-JY.doc EndGrade not taught in school EndGrade not taught in school.
050 4 Day School Week CHR00220 E For districts included in a DESE-identified list, if 4DaySchoolWeek is 'Yes', then dateVotersApproved4DayWeek, 4DayVoterAppStartYear, and 4DayVoterAppEndYear must all be populated. Missing related fields. All related voter approval fields must be populated for a 4-day school week.
055 Date Voters Approved 4 Day Week CHR00280 W For districts included in a DESE-identified list, if the district either has a 4-day school week or the total number of days with a StandardDayLength is less than 169, then DateVotersApp4DayWeek (vote of the people) must be a date prior to July 1 immediately preceding the school year. Flag only when DateVotersApp4DayWeek is on or after that July 1 date. Invalid voter approval date. Voter approval date must be prior to the July 1 date that precedes the school year when the district meets the applicable conditions. The {0} value ({1}) must be prior to the July 1 date that immediately precedes the reported school year when the district is subject to this rule (for example, if the school year is 2028, the approval date must be before 07/01/2027).
055 Date Voters Approved 4 Day Week CHR00285 E For the Calendar Header collection, the fields dateVotersApproved4DayWeek, 4DayVoterAppStartYear, and 4DayVoterAppEndYear may be reported only for districts included in the DESE-identified list. District not eligible for 4-day voter approval 4-day school week voter approval information can be reported only for districts approved by DESE.
055 Date Voters Approved 4 Day Week CHR00310 E When 4DayVoterAppStartYear and DateVotersApp4DayWeek are reported, the voter approval date must fall within the school year immediately preceding the voter approval start year. Specifically, if StartYear = YYYY, then the approval date must fall between 07/01/(YYYY - 2) and 06/30/(YYYY - 1). Invalid voter approval date range. Voter approval date must fall within the required date range relative to the voter approval start year. The values for {0} ({1}) and {2} ({3}) must represent a voter approval date that falls within the school year immediately preceding the voter approval start year (for example, if the voter approval start year is 2028, the approval date must be between 07/01/2026 and 06/30/2027).
060 4 Day Voter App Start Year CHR00290 E When both 4DayVoterAppStartYear and 4DayVoterAppEndYear are reported, the currentSchoolYear must fall within that inclusive range. Invalid school year. School year must fall within the voter-approved range.
060 4 Day Voter App Start Year CHR00300 E When both 4DayVoterAppStartYear and 4DayVoterAppEndYear are reported, the difference between the end year and start year must be exactly 10. Invalid voter-approved year span. Voter-approved year span must be exactly 10 years.
060 4 Day Voter App Start Year CHR00320 E 4DayVoterAppStartYear and 4DayVoterAppEndYear, when reported, must each be a four-digit year in YYYY format. Invalid year format. Year value must be a valid four-digit year. The {0} value ({1}) must be a valid four-digit year in YYYY format.
070 Begin Date CHR00230 E BeginDate and endDate must not fall on a weekend (Saturday or Sunday). Date falls on a weekend. Date must not fall on a Saturday or Sunday.
080 Min Per Week CHR00190 E MinPerWeek must be a positive integer greater than zero and can have upto 6 digits. Invalid minutes per week. Minutes per week must be a positive whole number and can have upto 6 digits.
080 Min Per Week CHR00240 E If the grade range (beginGrade to endGrade) includes any of grades 09 - 12, then minPerWeek and periodsEachDay must be greater than zero. Invalid value based on grade range. Value must be greater than zero when the grade range includes high school grades.
085 Periods Each Day CHR00200 E If periodsEachDay is reported, it must be a positive integer greater than zero and can have 1 to 4 digits followed by an optional decimal point and 1 to 2 digits. Invalid periods each day. Periods Each Day, when reported, should be a number with 1 to 4 digits followed by an optional decimal point and 1 to 2 digits.
085 Periods Each Day CHR00250 E If the grade range (beginGrade to endGrade) includes any of grades 09 - 12, then periodsEachDay must be less than 10. Invalid value based on grade range. Value must be less than 10 when the grade range includes high school grades. The {0} value ({1}) must be less than 10 when the grade range includes any high school grades (09 - 12).
090 Minutes Each Period CHR00210 E If minutesEachPeriod is reported, it must be a positive integer greater than zero and can have 1 to 4 digits followed by an optional decimal point and 1 to 4 digits. Invalid minutes each period. Minutes Each Period, when reported, should be a number with 1 to 4 digits followed by an optional decimal point and 1 to 4 digits.