| 005 |
Collection Version |
CDY00001 |
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 |
CDY00020 |
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 |
CDY00100 |
E |
CollectionVersion must match '2027JunSchoolCalDays' |
CollectionVersion must be '2027JunSchoolCalDays' |
The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2027JunSchoolCalDays'. |
|
| 010 |
Current School Year |
CDY00110 |
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'. |
|
| 025 |
Reporting District Code |
CDY00120 |
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 |
CDY00121 |
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 |
CDY00130 |
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 |
Begin Grade |
CDY00150 |
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. |
| 035 |
Begin Grade |
CDY00160 |
E |
Reference MO-2007-21-2007-K8 Indicator Business Rules-V1.2-JY.doc |
BeginGrade not taught in school |
BeginGrade not taught in school. |
|
| 035 |
Begin Grade |
CDY00220 |
E |
The combination of District, SchoolId, begin Grade, end Grade from the Days file should exist in Header File. Meaning a calendar day can exist only if the corresponding header record exists. |
Missing matching header record |
A corresponding School Calendar Header record does not exist for this district, school, grade range, and school year. |
|
| 035 |
Begin Grade |
CDY00230 |
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). |
|
| 040 |
End Grade |
CDY00165 |
E |
Reference MO-2007-21-2007-K8 Indicator Business Rules-V1.2-JY.doc |
EndGrade not taught in school |
EndGrade not taught in school. |
|
| 045 |
Date |
CDY00170 |
E |
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. |
| 045 |
Date |
CDY00210 |
E |
Each record must be unique based on the combination of reportingDistrictCode, reportingSchoolCode, beginGrade, endGrade, currentSchoolYear and Date. |
Duplicate record. |
Another record already exists with the same combination of district, school, grade range, school year and date. Each combination must be unique. |
|
| 050 |
Standard Day Length |
CDY00180 |
E |
Must be a positive integer greater than zero and can have 1 to 3 digits followed by an optional decimal point and 1 to 4 digits. |
Invalid number fomat. |
Should be a number with 1 to 3 digits followed by an optional decimal point and 1 to 4 digits. |
The {0} value {1} must be a valid number with 1 to 3 digits followed by an optional decimal point and 1 to 4 digits. |
| 050 |
Standard Day Length |
CDY00310 |
W |
For each calendar identified by CollectionVersion, ReportingDistrictCode, ReportingSchoolCode, BeginGrade, EndGrade, and CurrentSchoolYear, the sum of StandardDayLength must be at least 1044 hours for full-day programs. Full-day programs are those where BeginGrade and EndGrade are not among the half-day grades KA, KP, PKA, or PKP. |
Insufficient instructional hours. |
Total Hours in session must be at least 1044 for full-day programs. |
For this calendar, the Total Hours in session (sum of StandardDayLength) is {0}. Full-day programs must have a minimum of 1044 hours in session. |
| 050 |
Standard Day Length |
CDY00320 |
W |
For each calendar identified by CollectionVersion, ReportingDistrictCode, ReportingSchoolCode, BeginGrade, EndGrade, and CurrentSchoolYear, the sum of StandardDayLength must be at least 522 hours for half-day programs. Half-day programs are those where BeginGrade and EndGrade are one of KA, KP, PKA, or PKP. |
Insufficient instructional hours |
Total Hours in session must be at least 522 for half-day programs. |
For this calendar, the Total Hours in session (sum of StandardDayLength) is {0}. Half-day programs must have a minimum of 522 hours in session. |
| 050 |
Standard Day Length |
CDY00350 |
W |
For each calendar identified by CollectionVersion, reportingDistrictCode, reportingSchoolCode, beginGrade, endGrade, and currentSchoolYear, a Date with StandardDayLength greater than zero must not fall on a weekend (Saturday or Sunday). |
Instructional hours on weekend |
Date with actual hours attended greater than zero cannot fall on a weekend. |
|
| 050 |
Standard Day Length |
CDY00440 |
W |
For Calendar Days records, StandardDayLength greater than 9.0000 hours is unusually high and should be reviewed. |
Standard Day Length is unusually high. |
The reported Standard Day Length exceeds 9.0000 hours. Please review to ensure the value is correct. |
|
| 050 |
Standard Day Length |
CDY00450 |
E |
For Calendar Days records, StandardDayLength must not exceed 12.0000 hours. |
Standard Day Length is unusually high. |
The reported Standard Day Length exceeds the maximum allowed value of 12.0000 hours. |
|
| 055 |
Event Hours |
CDY00190 |
E |
Must be a positive integer greater than zero and can have 1 to 3 digits followed by an optional decimal point and 1 to 4 digits. |
Invalid Event Hours. |
Standard Day Length should be a number with 1 to 3 digits followed by an optional decimal point and 1 to 4 digits. |
|
| 055 |
Event Hours |
CDY00360 |
F |
For each calendar identified by CollectionVersion, ReportingDistrictCode, ReportingSchoolCode, BeginGrade, EndGrade, and CurrentSchoolYear, if EventCode is 04 (Actual Weather Make-up) or 14 (Make-up Other), then EventHours must not be greater than StandardDayLength. |
Invalid event hours for make-up day |
Event Code 04 (Actual Weather Make-up) or 14 (Make-up Other) cannot have EventHours greater than StandardDayLength. |
|
| 055 |
Event Hours |
CDY00370 |
F |
For each calendar identified by CollectionVersion, reportingDistrictCode, reportingSchoolCode, beginGrade, endGrade, and currentSchoolYear, if EventCode is 05 (AMI), then EventHours must equal StandardDayLength. |
Invalid AMI event hours |
If Event Code is 05 (AMI), then Event Hours must equal StandardDayLength. Combination of onsite and AMI is not allowed. |
|
| 055 |
Event Hours |
CDY00380 |
F |
For each calendar identified by CollectionVersion, reportingDistrictCode, reportingSchoolCode, beginGrade, endGrade, and currentSchoolYear, the sum of EventHours for EventCode 05 (Alternative Method of Instruction) must not exceed 36.0000 hours. |
Excess AMI hours |
More than 36 Alternative Method of Instruction hours have been entered. Section 171.033, RSMo, limits Alternative Method of Instruction hours to no more than 36.0000 hours. |
For this calendar, the total Alternative Method of Instruction (AMI) hours (sum of EventHours for EventCode 05) is {0}. State statute limits AMI hours to a maximum of 36.0000 hours. |
| 055 |
Event Hours |
CDY00390 |
W |
For each calendar identified by CollectionVersion, ReportingDistrictCode, ReportingSchoolCode, BeginGrade, EndGrade, and CurrentSchoolYear, the total EventHours for EventCode 04 (Weather Make-up) must not be greater than the combined total EventHours for EventCodes 06, 07, 08, and 09. |
Excess weather make-up hours |
The district has reported too many weather make-up hours. |
|
| 055 |
Event Hours |
CDY00400 |
W |
For each calendar identified by CollectionVersion, ReportingDistrictCode, ReportingSchoolCode, BeginGrade, EndGrade, and CurrentSchoolYear, the total EventHours for EventCode 14 (Make-up Other) must not be greater than the combined total EventHours for EventCodes 10, 11, 12 and 13. |
Excess make-up other hours |
The district has reported too many make-up other hours. |
|
| 055 |
Event Hours |
CDY00410 |
W |
For each calendar identified by CollectionVersion, ReportingDistrictCode, ReportingSchoolCode, BeginGrade, EndGrade, and CurrentSchoolYear, where the program is a full-day program (BeginGrade and EndGrade not equal to KA, KP, PKA, or PKP), calculate Actual Hours in Session (AHS) as the sum of StandardDayLength for all calendar days, including days reported with Event Code 04 (Actual Weather Make-up) and Event Code 14 (Make-up Other). Calculate Weather Forgiveness (WF) based on Weather Hours (WH), defined as the sum of EventHours for Event Codes 06, 07, 08, and 09 where WF equals 0 when WH is less than or equal to 36 hours, equals half of the hours over 36 when WH is greater than 36 and less than 84 hours, and equals WH minus 60 when WH is greater than or equal to 84 hours. The calendar is not in compliance if AHS is less than 1044 minus WF. |
Insufficient weather make-up hours |
The district or charter school has not made up the required number of inclement weather hours. |
For this calendar, Actual Hours in Session is {0}, which is less than the required minimum of {1} hours after applying allowable weather forgiveness. |
| 055 |
Event Hours |
CDY00420 |
W |
For each calendar identified by CollectionVersion, ReportingDistrictCode, ReportingSchoolCode, BeginGrade, EndGrade, and CurrentSchoolYear, where the program is a half-day program (BeginGrade and EndGrade equal to KA, KP, PKA, or PKP), calculate Actual Hours in Session (AHS) as the sum of StandardDayLength for all calendar days, including days reported with Event Code 04 (Actual Weather Make-up) and Event Code 14 (Make-up Other). Calculate Weather Forgiveness (WF) based on Weather Hours (WH), defined as the sum of EventHours for Event Codes 06, 07, 08, and 09 where WF equals 0 when WH is less than or equal to 36 hours, equals half of the hours over 36 when WH is greater than 36 and less than 84 hours, and equals WH minus 60 when WH is greater than or equal to 84 hours. The calendar is not in compliance if AHS is less than 522 minus WF. |
Insufficient weather make-up hours |
The district or charter school has not made up the required number of inclement weather hours. |
For this calendar, Actual Hours in Session is {0}, which is less than the required minimum of {1} hours after applying allowable weather forgiveness. |
| 060 |
Event Code |
CDY00200 |
E |
Must be in code set: (Calendar_Event_Codes). |
Invalid Event Code. |
Event Code must be a valid code. |
The {0} value ({1}) is not a valid Event code. |
| 060 |
Event Code |
CDY00240 |
E |
If EventCode is blank, then EventHours must also be blank. |
Invalid EventHours based on EventCode |
EventHours must be blank when EventCode is blank. |
|
| 060 |
Event Code |
CDY00250 |
E |
When EventCode is '05' (School In Session – AMI), EventHours and StandardDayLength must be equal. |
Invalid AMI hours |
For AMI days, EventHours must equal StandardDayLength. |
|
| 060 |
Event Code |
CDY00265 |
E |
Only EventCode values '01' (School Not in Session) and '04' through '14' are allowed in the June collection. |
Invalid Event Code for June |
Only School Not in Session and approved event codes (Actual Weather Make-up, AMI, inclement weather, emergency circumstances, and make-up other) are allowed in the June collection. |
|
| 060 |
Event Code |
CDY00270 |
E |
If EventCode = '01' (School Not in Session), then EventHours and StandardDayLength must be blank or zero |
Invalid values for non-instructional day |
Invalid values for non-instructional day |
|
| 065 |
Comments |
CDY00430 |
E |
For Calendar Days records, Comments are required when the Event Code is 12 (School Not in Session – Other Exceptional or Emergency Circumstances), 13 (School Not in Session – Inclement Weather Other), or 14 (Make-up – Other). |
Comments required for “Other” event codes |
Event Code requires an explanatory comment. Please provide details in the Comments field describing the reason for the event. |
|