Item_Number | Item_Name | Collection_Rule_ID | Severity | Business_Rule | Short_Title | General_Message | Detailed_Message |
---|---|---|---|---|---|---|---|

005 | Collection Version | SCR00001 | 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 | SCR00201 | 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 | SCR00401 | E | CollectionVersion must match '2018Jun1.0SumCrsAssign' | CollectionVersion must be '2018Jun1.0SumCrsAssign' | The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2018Jun1.0SumCrsAssign' | |

005 | Collection Version | SCR01612 | E | There must be at least one June Summer Course record | There are no June Summer Course records | There must be at least one June Summer Course record. | |

010 | Current School Year | SCR00402 | E | CurrentSchoolYear must match '2018' | CurrentSchoolYear must be '2018' | The CurrentSchoolYear identifies the school year for the data. For this collection the CurrentSchoolYear must be '2018'. | |

025 | Reporting District Code | SCR00441 | E | ReportingDistrictCode must match a valid DESE County District Code. District codes are in DESE District table. | Invalid ReportingDistrictCode code | The ReportingDistrictCode is not a valid district code. | |

025 | Reporting District Code | SCR00700 | E | ReportingDistrictCode must match the SRM user's district code. | The student is not from this district | The student's ReportingDistrictCode does not equal that of the trial. | |

030 | Reporting School Code | SCR00602 | E | ReportingSchoolCode must be a valid school code in the Reporting District (Reporting District Code) Use MOSIS Attendance Center tables. | Invalid ReportingSchoolCode | The Reporting School Code is not a valid school code in the Reporting District Code. | |

050 | ED SSN | SCR00460 | E | The Social Security Number must 9 digits with no extra characters such as spaces and dashes. | EDSSN must be 9 digits | The Social Security Number must be specified as 9 digits. | |

050 | ED SSN | SCR00462 | E | (Different than Oct) EDSSN cannot have more than 99 assignments grouped by collectionversion,currentSchoolYear,reportingdistrictcode, reportingschoolcode, edssn, poscode | EDSSN has too many assignments | EDSSN has over 99 assignments. | EDSSN {0} has over 99 assignments. |

070 | Position Code | SCR00442 | E | Must be in code set: (Position_Codes). | Invalid PosCode code | Position Code is not valid. | |

070 | Position Code | SCR02900 | W | If CRS.PosCode = 10 Then CRS.CourseNum must be (990088, 990099, 880000, 880010, 999915, 992000, 992010) or begin with 881 | PosCode 10 should have courses that begin with 881 | PosCode 10 should have courses that begin with 881. | |

070 | Position Code | SCR02901 | W | If CRS.PosCode = 20 Then CRS.CourseNum must be (990088, 990099, 880000, 880010, 999915, 992000, 992010) or begin with 882 | PosCode 20 should have courses that begin with 882 | PosCode 20 should have courses that begin with 882. | |

070 | Position Code | SCR02902 | W | If CRS.PosCode = 30 Then CRSCourseNum must be (990088, 990099, 880000, 880010, 999915, 992000, 992010, 880020) or begin with 883 or end with 97 | PosCode 30 should have courses that begin with 883 | PosCode 30 should have courses that begin with 883. | |

070 | Position Code | SCR02903 | W | If CRS.PosCode = 40 Then CRSCourseNum must be (990088, 990099, 880000, 880010, 999915, 992000, 992010, 992020) or begin with 884 | PosCode 40 should have courses that begin with 884 | PosCode 40 should have courses that begin with 884. | |

070 | Position Code | SCR02904 | W | If CRS.PosCode = 50 Then CRSCourseNum must be (990088, 990099, 880000, 880010, 999915, 992000, 992010) or begin with 885 | PosCode 50 should have courses that begin with 885 | PosCode 50 should have courses that begin with 885. | |

070 | Position Code | SCR02905 | W | If CRS.PosCode = 60 Then CRSCourseNum can be (990088, 990099, 880000, 880010, 999915, 992000, 992010, 992015, 992020) and cannot begin with 881 or 882 or 883 or 884 or 885 or 887 or 888 or 889 | PosCode 60 should not have courses that begin with 881, 882, 883, 884, 885, 887, 888 or 889 | PosCode 60 should have courses that do not begin with 881, 882, 883, 884, 885, 887, 888 or 889 | |

070 | Position Code | SCR02906 | W | If CRS.PosCode = 70 Then CRSCourseNum must be (990088, 990099, 880000, 880010) or begin with 887 | PosCode 70 should have courses that begin with 887 | PosCode 70 should have courses that begin with 887 or (990088, 990099, 880000, 880010) | |

070 | Position Code | SCR02907 | W | If CRS.PosCode = 80 Then CRSCourseNum can be (990088, 990099, 880000, 880010) and cannot begin with 881 or 882 or 883 or 885 or 887 or end with 97 or 98 | PosCode 80 should not have courses that begin with 881, 882, 883, 885 or 887 or end with 97 or 98 | PosCode 80 should not have courses that begin with 881, 882, 883, 885 or 887 or end with 97 or 98 or (990088, 990099, 880000 or 880010) | |

070 | Position Code | SCR02908 | W | If CRS.PosCode = 90 Then CRSCourseNum must be (990088, 990099, 880000, 880010) or must begin with 889 | PosCode 90 should have courses that begin with 889 | PosCode 90 should have courses that begin with 889 or (990088, 990099, 880000, 880010) | |

070 | Position Code | SCR02910 | W | CRS.PosCode cannot be 20, 40 or 50 if CRS.CourseProgCode is in (06,09,16,17,19) | PosCode is not valid for CourseProgCode | PosCode cannot be 20, 40, or 50 when CourseProgCode is in (06, 09, 16, 17, 19). | |

070 | Position Code | SCR02911 | W | (Different than Oct) CRS.PosCode is not 60 and CRS.CourseNum is not in (887800, 999915, 992000, 992010, 992020) then no records matching CurrentSchoolYear, ReportingDistrictCode, EDSSN, ReportingSchoolCode, PosCode, AssignNum should exist in Student Ass | Enrollment is not allowed for PosCode and CourseNum | Enrollment is not allowed since PosCode is not 60. Must not have student assignment records for course assignment. | |

080 | CTE Program Type | SCR00443 | E | Must be in code set: (CTE_Program_Type_Codes) | Invalid CTEProgType code | CTEProgType is not valid. | |

090 | Assignment Number | SCR00452 | E | (Different from Oct) AssignNum cannot match another AssignNum with the same CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, EDSSN, and PosCode. | AssignNum must be unique for EDSSN | AssignNum cannot match another AssignNum with the same CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, EDSSN, and PosCode. | |

130 | State Course Number | SCR00449 | E | Must be in code set: (State_Course_Codes) | Invalid CourseNum code | CourseNum is not valid. | |

130 | State Course Number | SCR01200 | W | CourseNum is required if ReportingSchoolCode is less than or equal to 2999 and CourseGradeLevel is not ' K' or 'PK' | CourseNum should be reported for this ReportingSchoolCode and CourseGradeLevel | A CourseNum should be reported when the ReportingSchoolCode is less than 3000 and the CourseGradeLevel is not K or PK | |

130 | State Course Number | SCR01300 | E | CourseNum must not be blank if CourseGradeLevel is 09, 10, 11, 12, 13, 14, 15, 16, or 17. | CourseNum is required when CourseGradeLevel is between 9 and 17 | The State Course Number is required if the Course Grade Level is 09, 10, 11, 12, 13, 14, 15, 16, or 17. | |

130 | State Course Number | SCR01400 | E | If CourseNum is 054840 and CourseDeliverySys is PU, then CourseGradeLevel must be K, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14, 15, or 16. | Invalid CourseGradeLevel and/or CourseDeliverySys for CourseNum 054840 | State Course Number 054840 requires Course Delivery System of PU and Course Grade Level of K, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14, 15, or 16. | |

130 | State Course Number | SCR01500 | E | If CourseNum is 998899 then ReportingDistrictCode must be 096119. | Invalid CourseNum for ReportingDistrictCode | State Course Number 998899 is only valid for Reporting District Code 096119. | |

130 | State Course Number | SCR01600 | E | If CourseNum is 195000 then CourseGradeLevel must not be PK. | CourseNum 195000 is invalid for PK | Course Grade Level PK is not valid for State Course Number 195000. | |

130 | State Course Number | SCR01602 | W | If CRS.CourseNum = 994400 then CRS.ReportingSchoolCode must be 1015 and CRS.PosCode must be in (60,80) and CRS.CourseProgCode must be 16 | CourseNum is not valid for ReportingSchoolCode, PosCode, and CourseProgCode | CourseNum 994400 is not valid unless ReportingSchoolCode is 1015 and PosCode is 60 or 80 and CourseProgCode is 16. | |

130 | State Course Number | SCR01604 | W | If ((CRS.CourseNum is 990000,990088,998800), or (CRS.CourseNum begins with 88 excluding 887800,887900,880020) or (CRS.CourseNum ends with 98 or 97)) then no records matching CurrentSchoolYear, ReportingDistrictCode, EDSSN, ReportingSchoolCode, PosCode, As | Enrollment is not allowed for CourseNum | Enrollment is not allowed since CourseNum is in 990000, 990088, or 998800; or CourseNum begins with 88 excluding 887800, 887900, or 880020; or CourseNum ends with 98 or 97. Must not have student assignment records for course assignment. | |

130 | State Course Number | SCR01605 | W | If CRS.CourseGradeLevel is IT then CRS.CourseNum must be in (887600,887800,887897,887900) | CourseNum is not valid for CourseGradeLevel | CourseNum must be in (887600, 887800, 887897, 887900) since CourseGradeLevel is IT. | |

130 | State Course Number | SCR01606 | W | If CRS.CourseNum is 994400 then CRS.CourseGradeLevel must be in (04,05,06,07,08,09,10,11,12,13,14,15,16,17) | CourseNum is not valid for CourseGradeLevel | CourseNum 994400 is not valid since CourseGradeLevel is not in (04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14, 15, 16, 17). | |

130 | State Course Number | SCR01607 | W | If CRS.CourseNum is 195400 then CRS.CourseGradeLevel must be in (PK, (space K)) | CourseNum is not valid for CourseGradeLevel | CourseNum 195400 is not valid since CourseGradeLevel is not in ( K, PK). | |

130 | State Course Number | SCR01608 | W | If CRS.CourseNum is in (195610,195620,195630,195640,195700,195800) then CRS.CourseGradeLevel must be in (05,06,07,08,09,10,11,12,13,14,15) | CourseNum is not valid for CourseGradeLevel | CourseNum is not valid since CourseGradeLevel is not in (05, 06, 07, 08, 09, 10, 11, 12, 13, 14, 15) | |

130 | State Course Number | SCR01610 | W | If CRS.CourseNum is in (054840,054891,115891) then (CRS.PosCode must be 60 or 80) and (CRS.CourseProgCode must be 00, 03, 13, 37, or 43). | CourseNum is not valid for PosCod and CourseProgCode | CourseNum is only valid for PosCode 60 or 80 and CourseProgCode must be 00, 03, 13, 37, or 43. | |

130 | State Course Number | SCR01611 | E | One or more student assignment records are required matching the key (CurrentSchoolYear, ReportingDistrictcode, ReportingSchoolCode, EDSSN, CTEProgType, PosCode, AssignNum) unless (1) Position is not 60; (2) Course is 016785, 193000, 193100, 990000, 990 | No Student Assignment records found matching this Course Assignment | This Course Assignment requires enrollments to be reported in the Student Assignment file that match the key (CurrentSchoolYear, ReportingDistrictcode, ReportingSchoolCode, EDSSN, CTEProgType, PosCode, AssignNum). | |

130 | State Course Number | SCR01615 | E | Course Numbers 086035, 086020, 086025, and 999999 are not allowed. | Course Numbers are not allowed to be reported | Course Numbers 086035, 086020, 086025, and 999999 are not allowed to be reported in the June Summer Course Assignment file. | |

140 | Assignment Start Date | SCR01700 | E | AssignStartDate must be specified as mm/dd/yyyy | AssignStartDate is not a valid date | Dates are specified using the format mm/dd/yyyy. | |

150 | Assignment End Date | SCR01800 | E | AssignEndDate must be specified as mm/dd/yyyy | AssignEndDate is not a valid date | Dates are specified using the format mm/dd/yyyy. | |

170 | Course Sequence Number | SCR00444 | E | Must be in code set: (Course_Seq_Num_Codes) | Invalid CourseSeqNum code | CourseSeqNum is not valid. | |

180 | Course Grade Level | SCR00450 | E | Must be in code set: (Assignment_Grade_Level_Codes) | Invalid CourseGradeLevel code | CourseGradeLevel is not valid. | |

180 | Course Grade Level | SCR02403 | W | If CRS.CourseNum = 887897 then CRS.CourseGradeLevel must be in (PK,IT) | CourseGradeLevel is not valid for CourseNum | CourseGradeLevel must be PK or IT since CourseNum is 887897. | |

180 | Course Grade Level | SCR02404 | W | If CRS.CourseProgCode is 07 then CRS.CourseGradeLevel must be in (PK,IT) | CourseGradeLevel is not valid for CourseProgCode | CourseGradeLevel must be PK or IT since CourseProgCode is 07. | |

180 | Course Grade Level | SCR02405 | E | CRS.CourseGradeLevel is required if CRS.CourseNum is NULL or not in (880000,990088,990000, 193000, 193100, 198600) | CourseGradeLevel is required for CourseNum | CourseGradeLevel is required since CourseNum is not 880000,990088,990000, 193000, 193100, or 198600. | |

190 | Course Semester | SCR00446 | E | Must be in code set: (Course_Semester_Codes) | Invalid CourseSem code | CourseSem is not valid. | |

200 | Course Delivery System | SCR00447 | E | Must be in code set: (Course_Delivery_System_Codes) | Invalid CourseDeliverySys code | CourseDeliverySys is not valid. | |

200 | Course Delivery System | SCR02101 | W | CRS.CourseDeliverySys must begin with L, M, or N if CRS.CourseProgCode is 07 | CourseDeliverySys is not valid for CourseProgCode | CourseDeliverySys must begin with L, M, or N if the CourseProgCode is 07. | |

200 | Course Delivery System | SCR02102 | W | CRS.CourseDeliverySys is required if CRS.CourseProgCode is in (02,03,04,06,07) and CRS.CourseNum Not in (193000, 193100,198600) and CRS.CourseNum does not begin with 88 or end with 97 or 98 | CourseDeliverySys is required | CourseDeliverySys is required since CourseProgCode is in (02, 03, 04, 06, 07) and CourseNum Not in (193000, 193100,198600) and the CourseNum does not begin with 88 or end with 97 or 98. | |

200 | Course Delivery System | SCR02103 | W | CRS.CourseDeliverySys must be null if CRS.CourseNum is 990088 | CourseDeliverySys must be null for CourseNum | CourseDeliverySys must be null since CourseNum is 990088. | |

200 | Course Delivery System | SCR02105 | W | CRS.CourseDeliverySys cannot be G if CRS.CourseProgCode is null | CourseDeliverySys is not valid for CourseProgCode | CourseDeliverySys cannot be G since CourseProgCode is not provided. | |

200 | Course Delivery System | SCR02106 | W | (Different than Oct) If CRS.CombinedCourse is 1-99 then at least 1 other record must have the same CurrentSchoolYear, ReportingDistrictCode, EDSSN, Poscode, CombinedCourse | No matching CombinedCourse found | No matching CombinedCourse found for combined course. | |

200 | Course Delivery System | SCR02109 | E | (Different than October) If CRS.CourseDeliverySys is in 1,2,3,4,5,6,7,8,9,IC then no records matching CurrentSchoolYear, ReportingDistrictCode, EDSSN, ReportingSchoolCode, PosCode, AssignNum should exist in Student Assignment file or Caseload should be g | Enrollment is not allowed for CourseDeliverySys | Enrollment is not allowed since CourseDeliverySys is in (1, 2, 3, 4, 5, 6, 7, 8, 9, IC). Must not have student assignment records for course assignment. | |

200 | Course Delivery System | SCR02110 | W | (Different than October) If CRS.CourseDeliverySys is in T1, T2, T3, T4, T5, T6, T7, T8, T9 then one or more records matching CurrentSchoolYear, ReportingDistrictCode, EDSSN, ReportingSchoolCode, PosCode, AssignNum should exist in Student Assignment file o | Enrollment is required for CourseDeliverySys | Enrollment is required since CourseDeliverySys is in (T1, T2, T3, T4, T5, T6, T7, T8, T9). Must have student assignment record for course assignment. | |

200 | Course Delivery System | SCR02112 | W | If CRS.PosCode=80 and CRS.CourseNum begins with 19, then CRS.CourseDeliverySys must be in (CO, IG, SC, LI, PA) | CourseDeliverySys is not valid for PosCode, and CourseNum | CourseDeliverySys must be CO, IG, SC, LI, or PA since PosCode is 80 and CourseNum begins with 19. | |

200 | Course Delivery System | SCR02113 | W | If CRS.PosCode = 60 and CRS.CourseNum begins with 19 then CRS.CourseDeliverySys must be in (CO, IG, SC, LI, H, C1-C9) | CourseDeliverySys is not valid for PosCode, and CourseNum | CourseDeliverySys must be CO, IG, SC, LI, H, or C1-C9 since PosCode is 60 and CourseNum begins with 19. | |

210 | Course Program Code | SCR00448 | E | Must be in code set: (Course_Program_Code) | Invalid CourseProgCode code | CourseProgCode is not valid. | |

220 | Course Minutes | SCR00453 | E | CourseMins must be an integer | CourseMins must be an integer | CourseMins must be an integer containing only digits. | |

230 | Course Credits | SCR02300 | E | CourseCredit does not have a valid format. It may have 1 digit followed by an optional decimal point and 1 or 2 digits. | CourseCredit has an invalid format | CourseCredit does not have a valid format. It may have 1 digit followed by an optional decimal point and 1 or 2 digits. | |

230 | Course Credits | SCR02302 | W | CourseCredit must be null or zero if CRS.CourseNum is in (086020,990000,990088,998800,999999) | CourseCredit must be null or zero for CourseNum | CourseCredit must be null or zero for CourseNum (086020, 990000, 990088, 998800, 999999). | |

230 | Course Credits | SCR02303 | W | Course Credit must be zero if CRS.ReportingSchoolCode is between 3000 and 5999 | CourseCredit must be null or zero for ReportingSchoolCode | CourseCredit must be null or zero for ReportingSchoolCodes between 3000 and 5999. | |

230 | Course Credits | SCR02304 | W | Course Credit must be zero if CRS.CourseGradeLevel not in (09,10,11,12,13) | CourseCredit must be null or zero for CourseGradeLevel | CourseCredit must be null or zero for CourseGradeLevels not in (09, 10, 11, 12, 13). | |

230 | Course Credits | SCR02305 | W | Course Credit must be zero if (CRS.CourseNum ends with 98 or 97) or (CRS.CourseNum begins with 88) | CourseCredit must be null or zero for the specified CourseNum | CourseCredit must be null or zero when CourseNum ends with 98 or 97 or begins with 88. | |

230 | Course Credits | SCR02306 | W | Course Credit must be zero if CRS.PosCode = 80 | CourseCredit must be null or zero for PosCode | CourseCredit must be null or zero for PosCode 80. | |

230 | Course Credits | SCR02307 | W | If Course Credit is not null it must be zero or inclusively be between 0.25 and 7.00 | CourseCredit is not in valid range | CourseCredit should be between 0.25 and 7.00. | |

230 | Course Credits | SCR02312 | E | Course Credit must be null or zero if CRS.CourseDeliverySys is between 1 or 9. | CourseCredit must be null or zero for CourseDeliverySys | CourseCredit must be null or zero since CourseDeliverySys is between 1 and 9. | |

235 | Caseload | SCR02310 | E | (Different than Oct) If CRS.Caseload > 0 then no records matching CurrentSchoolYear, ReportingDistrictCode, EDSSN, ReportingSchoolCode, PosCode, AssignNum should exist in Student Assignment file. | Enrollment is not allowed with Caseload | Enrollments are not allowed in the Student Assignment file since Caseload is greater than 0. | |

235 | Caseload | SCR02311 | E | If Caseload is not null it must be an positive integer zero or greater. | Caseload must be an integer | Caseload must be a positive integer. | |

240 | Course Total Hours | SCR01950 | W | If CourseNum is not 192000 then CourseHours must be at least 30. | CourseHours must be at least 30 | CourseHours must be at least 30 | |

240 | Course Total Hours | SCR01951 | E | If coursecredit is not zero then CourseHours must be greater than or equal to Floor(CourseCredit times 120). SQL Floor function reduces value to the nearest integer less than the decimal value. Basically truncates all decimal values. | CourseHours are too low for CourseCredit | CourseHours are too low for CourseCredit | |

240 | Course Total Hours | SCR01952 | W | If CourseHours is greater than or equal to 300 | CourseHours are higher than expected | CourseHours are higher than expected | |

240 | Course Total Hours | SCR01953 | E | If CourseHours is not null it must be an integer value zero or greater. | CourseHours must be an integer | CourseHours must be a positive integer. | |

242 | Assignment Comment | SCR03000 | E | AssignComment is required if CourseNum is 991010. | AssignComment is required | AssignComment is required since CourseNum is 991010-Exploratory and Enrichment, provide course details in comment. | |

245 | Combined Course | SCR02935 | E | CombinedCourse must be a positive integer between 1 and 99. | CombinedCourse must be between 1 to 99 | CombinedCourse must be a positive integer between 1 and 99. |