FileSpecRules:201406JuneCycleSummerCourseAssignment
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 '2014Jun1.0SumCrsAssign' CollectionVersion must be '2014Jun1.0SumCrsAssign' The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2014Jun1.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 '2014' CurrentSchoolYear must be '2014' The CurrentSchoolYear identifies the school year for the data. For this collection the CurrentSchoolYear must be '2014'.
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 C, 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 C 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 SCR01601 W If CRS.CourseNum in (054840,054841) and CRS.CourseDeliverySys = A then Student Assignment file cannot have data matching the key (CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, EDSSN, PosCode, AssignNum) Enrollment is not allowed for CourseNum and CourseDeliverySys Enrollment is not allowed since CourseNum is 054840 or 054841 and CourseDeliverySys is A. Must not have student assignment records for course assignment.
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 SCR01609 W If CRS.CourseNum is 054841 and CRS.CourseProgCode is 03 then CRS.CourseGradeLevel must be (space K),01,02 and CRS.CourseDeliverySys must be C CourseNum is not valid for CourseProgCode, CourseGradeLevel, or CourseDeliverySys CourseNum 054841 is not valid since CourseProgCode is not 03, CourseGradeLevel is not ( K, 01, 02), or CourseDeliverySys is not C
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).
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 SCR02400 W If CRS.CourseNum = 054842 and CRS.CourseDeliverySys = C then CRS.CourseGradeLevel must be 01 CourseGradeLevel is not valid for CourseNum and CourseDeliverySys CourseGradeLevel must be 01 since CourseNum is 054842 and CourseDeliverySys is C.
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 SCR02100 E If CourseNum is 994400, CourseDeliverySys must be C or G. CourseDeliverySys must be C or G for CourseNum 994400 The Course Delivery System must be C or G for State Course Number 994400.
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.