| 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 '2027AugSchoolCalDays' |
CollectionVersion must be '2027AugSchoolCalDays' |
The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2027AugSchoolCalDays'. |
|
| 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 |
CDY00280 |
W |
For each calendar identified by CollectionVersion, ReportingDistrictCode, ReportingSchoolCode, BeginGrade, EndGrade, and CurrentSchoolYear, the earliest Date with StandardDayLength greater than zero must not be earlier than 14 days prior to the first Monday in September of the school year.(171.031, RSMo.) |
First instructional day too early |
The first instructional day for this calendar cannot be earlier than 14 days before the first Monday in September of the school year. |
|
| 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 |
CDY00330 |
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 Planned Net Instruction Hours as the sum of StandardDayLength for all calendar days minus the sum of EventHours for records where EventCode = 03 (Planned Weather Make-up Built-In). The calendar is not in compliance if Planned Net Instruction Hours is less than 1044.0000 |
Insufficient planned net instruction hours |
Total planned hours in session less built-in planned weather make-up hours is less than 1044. |
For this calendar, planned net instruction hours (sum of StandardDayLength minus planned weather make-up hours) is {0}. Full-day programs must have a minimum of 1044.0000 planned net instruction hours in session. |
| 050 |
Standard Day Length |
CDY00340 |
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 Planned Net Instruction Hours as the sum of StandardDayLength for all calendar days minus the sum of EventHours for records where EventCode = 03 (Planned Weather Make-up Built-In). The calendar is not in compliance if Planned Net Instruction Hours is less than 522.0000. |
Insufficient planned net instruction hours |
Total planned hours in session less built-in planned weather make-up hours is less than 522. |
For this calendar, planned net instruction hours (sum of StandardDayLength minus planned weather make-up hours) is {0}. Half-day programs must have a minimum of 522.0000 planned net instruction 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 planned 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 |
CDY00290 |
W |
For each calendar identified by CollectionVersion, ReportingDistrictCode, ReportingSchoolCode, BeginGrade, EndGrade, and CurrentSchoolYear, the total EventHours for EventCode '03' (Planned Weather Make-up - Built-In) must be at least 18 for half-day programs. Half-day programs are defined as calendars where BeginGrade and EndGrade are one of KA, KP, PKA, or PKP. |
Insufficient planned make-up hours |
Half-day programs must report at least 18 hours of planned make-up time. |
For this calendar, the sum of EventHours for EventCode '02' is {0}. Half-day programs (KA, KP, PKA, PKP) must report at least 18 total hours of planned weather make-up time. |
| 055 |
Event Hours |
CDY00300 |
W |
For each calendar identified by CollectionVersion, ReportingDistrictCode, ReportingSchoolCode, BeginGrade, EndGrade, and CurrentSchoolYear, the total EventHours for EventCode '03' (Planned Weather Make-up - Builtin) must be at least 36 for full-day programs. Full-day programs are calendars where BeginGrade and EndGrade are not limited to the half-day grades KA, KP, PKA, or PKP (for example, K and 01–12). |
Insufficient planned make-up hours |
Full-day programs must report at least 36 hours of planned make-up time. |
For this calendar, the sum of EventHours for EventCode '02' is {0}. Full-day programs must report at least 36 total hours of planned weather make-up time. |
| 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 |
CDY00260 |
E |
Only EventCode values '01' - School Not in Session, '02' - Planned Weather Make-up (Conditional) and '03' - Planned Weather Make-up (Built-In) are allowed in the August collection. |
Invalid Event Code for August |
Only planned weather make-up days, holidays, and weekends are allowed in the August cycle. |
|
| 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 |
|