FileSpecRules:201906JuneCycleStudentCourseCompletion
Item_Number Item_Name Collection_Rule_ID Severity Business_Rule Short_Title General_Message Detailed_Message
005 Collection Version SCC00001 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 SCC00201 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 SCC00401 E CollectionVersion must match '2019Jun1.0StuCRSComp' CollectionVersion must be '2019Jun1.0StuCRSComp' The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2019Jun1.0StuCRSComp'.
010 Current School Year SCC00402 E CurrentSchoolYear must match '2019' CurrentSchoolYear must be '2019' The CurrentSchoolYear identifies the school year for the data. For this collection the CurrentSchoolYear must be '2019'.
025 Reporting District Code SCC00441 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 SCC00700 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 SCC00602 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.
032 Receiving Coll/Dist Code SCC00464 E ReceivingCollDistCode must match a valid District Code in v_DESE_DISTRICT_PUB_PRIV_STATE_HIGH matching the CurrentSchoolYear Invalid ReceivingCollDistCode code ReceivingCollDistCode is not valid.
032 Receiving Coll/Dist Code SCC01301 E If ReceivingColDistCode is not null then SendingDistrictCode is required. SendingDistrictCode is required SendingDistrictCode is required with ReceivingCollDistCode
032 Receiving Coll/Dist Code SCC01302 E RecevingColDistCode is required if DualCreditSite is not null RecevingColDistCode is required RecevingColDistCode is required with DualCreditSite.
032 Receiving Coll/Dist Code SCC01303 W ReportingSchoolCode is not (1100-1199 or 0000) then RecevingColDistCode, ReportingDistrictCode, and SendingDistCode cannot be the same. ReportingDistrictCode, SendingDistrictCode, and ReceivingCollDistCode should not match ReportingDistrictCode, SendingDistrictCode, and ReceivingCollDistCode should not match unless the student is being sent to an area career center or another high school in your district.
034 Sending District Code SCC00447 E SendingDistrictCode must match a valid DESE County District Code. District codes are in DESE District table. Invalid SendDistCode code SendDistCode is not a valid district code.
034 Sending District Code SCC01400 E If SendingDistrictCode is not null then ReceivingColDistCode is required. ReceivingCollDistCode is required ReceivingCollDistCode is required with SendingDistrictCode
034 Sending District Code SCC01401 E SendingDistrictCode is required if DualCredSite is not null. SendingDistrictCode is required SendingDistrictCode is required with DualCreditSite.
034 Sending District Code SCC01402 E If ReportingDistrictCode is not 048078, 096119 or 115115 and ReportingSchoolCode = (1100-1199 or 0000) then SendingDistrictCode is required. SendingDistrictCode is required with ReportingSchoolCode SendingDistrictCode is required since ReportingSchoolCode is 0000 or 1100-1199.
036 Sending School Code SCC01403 E SendingSchoolCode is required if SendingDistrictCode is not null. SendingSchoolCode is required with SendingDistrictCode SendingSchoolCode is required with SendingDistrictCode.
036 Sending School Code SCC01404 E SendingSchoolCode must be a valid school code in the Sending District (Sending District Code). Use MOSIS District Table and MOSIS Attendance Center tables. SendingSchoolCode is not valid for SendingDistrictCode SendingSchoolCode is not a valid school code for the SendingDistrictCode.
045 MOSIS ID SCC00467 W SCC.StateID must exist in the Current Year Certified June Student Enrollment and Attendance (SEA) for the ReportingDistrictCode with a sum of RegHrsAttnd > 0. This rule ensures that if a student was reported in the June SCC file they show up in the June Student Enrollment and Attendance. StateID not found in certified June Student Core/Enrollment Attendance StateID was not found in the certified June Enrollment Attendance. Any student reported in the June Student Course Completion should also exist in the certified June Student Core/Enrollment Attendance.
045 MOSIS ID SCC00468 W Using the Current Year Certified June Student Enrollment and Attendance (SEA) for the ReportingDistrictCode. All SEA.StateID which have a sum of SEA.RegHrsAttended >= 1 where SEA.ReportingSchoolCode is not  (1100-1199 or 0000) and and SEA.ResidencyStatus is not R2 and SEA.StudentGradeLevel is  ('07','08','09','10','11','12') must have a record in the June Student Course Completion with the key of CurrentSchoolYear, ReportingDistrictCode, and StateID.  This rule ensures that if a student was reported in the June SEA file in the correct grades and school and had at least 1 hour of attendance they show up in the June Completion. StateID not found in June Student Course Completion StateID was reported in June Student Core/Enrollment Attendance, but was not found in June Student Course Completion. See "Jun. StateID missing Course Completion" report for individual State Identifiers.
045 MOSIS ID SCC00477 W Using the Certified October Student Assignment (STA) for the ReportingDistrictCode. All STA.StateID with a student grade level 7, 8, 9, 10, 11, 12 must have a record in the June Student Course Completion with the key of CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, EDSSN, PosCode, CTEProgType, AssignNum, StateID unless CRS.AssignEndDate is not null. This rule ensures that if a student was reported in the October Assignment that they show up in the June Completion. StateID not found in June Student Course Completion StateID was reported in October Student Assignment, but was not found in June Student Course Completion. See "Oct. StateID missing Course Completion" report for individual State Identifiers.
045 MOSIS ID SCC01001 E State ID verified against ID system SIDMASTER (State_Student_ID) StateID not found in MOSIS ID The State ID was not found in the MOSIS ID system.
080 Student Date of Birth SCC00446 E DateOfBirth must be a valid date DateOfBirth is not a valid date The date is not valid. A date must be in MM/DD/YYYY format and be a valid date.
095 Student Grade Level SCC00404 E Must be in code set: (Student_Grade_Level_Codes). Invalid StudentGradeLevel code Student Grade Level must be a valid code in the Student Grade Level Codes.
111 ED SSN SCC00460 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.
111 ED SSN SCC00461 E EDSSN is required if SCC.ReportingDistrictCode is not 118118 and ((SCC.ReceivingCollDistCode is equal to SCC.ReportingDistrictCode) or SCC.ReceivingCollDistCode is null) and October CRS.courseprogramcode is not 50 matching on CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, EDSSN, PosCode, CTEProgType, AssignNum. EDSSN is required EDSSN is required since ReceivingCollDistCode is equal to ReportingDistrictCode or ReceivingCollDistCode is null and Cousre Program Code is not 50.
111 ED SSN SCC00500 E EDSSN is not allowed if DualCreditSite is COLL and October CRS.CourseDeliverySys is not (V, VH, or begins with S) matching on CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, Edssn, PosCode, CTEProgType, AssignNum. EDSSN is not allowed EDSSN is not allowed since DualCreditSite is COLL.
117 Position Code SCC00442 E Must be in code set: (Position_Codes). Invalid PosCode code Position Code is not valid.
117 Position Code SCC00478 W SCC.PosCode must be 60. Unexpected PosCode PosCode is expected to be 60.
119 CTE Program Type SCC00443 E Must be in code set: (CTE_Program_Type_Codes) Invalid CTEProgType code CTEProgType is not valid.
120 Assignment Number SCC00465 E If AssignNum is not null Then CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, EDSSN, CTEProgType, PosCode, and AssignNum must match a record in the current year certified October Course Assignment where the CRS.AssignEndDate is null. AssignNum was not reported in October AssignNum was not reported in October Course Assignment. Must have a record that matches CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, EDSSN, PosCode, CTEProgType, AssignNum and the AssignEndDate must be null.
120 Assignment Number SCC00466 W Join the current year certified Oct Course Assignment (CRS) and Student Assignment (STA) on trial_id, EDSSN, CTEProgType, PosCode, and AssignNum and STA.StudentGradeLevel in 7, 8, 9, 10, 11, 12. Verify for the Current Year that each unique instance of STA.EDSSN, STA.CTEProgType, STA.PosCode, and STA.AssignNum where CRS.AssignEndDate is null exists in the June Student Course Completion Collection. This rule is to ensure students are reported in the June Student Course Completion for a particular assignment if students were reported in October for that assignment and it was not ended. Course Completion missing Assignments were found in October which do not have students reported. See "Oct. Assignments missing Course Completions" report for information about specific assignments.
130 State Course Number SCC00449 E Must be in code DESE_DC_COURSE for the CurrentSchoolYear Invalid CourseNum code CourseNum is not valid.
130 State Course Number SCC00469 W Using the Certified October Course Assignment for the ReportingDistrictCode the CourseNum must match. Key: CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, EDSSN, PosCode, CTEProgType, AssignNum unless October Course Num for the matching assignment is 994210 or null. CourseNum does not match October CourseNum does not match the CourseNum of the educators assigment reported in October Course Assignment. CourseNum {0} reported in the June Student Course Completion does not match the CourseNum {1} reported in the October Course Assignment.
190 Course Time Unit SCC00481 E Must be in code set: (Course_Time_Unit_Codes) Invalid CourseTimeUnit code CourseTimeUnit code must be one of (Q1, Q2, Q3, Q4, S1, S2, T1, T2, T3, YL).
190 Course Time Unit SCC00482 E Using the Certified October Course Assignment for the ReportingDistrictCode the CourseNum must match. Key: CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, EDSSN, PosCode, CTEProgType, AssignNum. CourseTimeUnit cannot match another SCC.CourseTimeUnit with the same SCC.CurrentSchoolYear, SCC.ReportingDistrictCode, SCC.ReportingSchoolCode, SCC.EDSSN, SCC.CTEProgType, SCC.PosCode, SCC.AssignNum, and SCC.StateId unless CRS.CourseNum is 994210 or null in the matching October Assignment. Student reported more than once for CourseTimeUnit CourseTimeUnit cannot match another CourseTimeUnit with the same CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, EDSSN, CTEProgType, PosCode, CourseNum, and StateId.
191 Dual Credit Site SCC00445 E Must be in code set: (Dual_Credit_Site_Codes). Invalid DualCreditSite code DualCreditSite must be one of ACC, DIST, COLL, or ITV.
191 Dual Credit Site SCC01500 E If DualCreditSite is null then the combination of ReportingDistrictCode and ReportingsSchoolCode must be different than the combination of SendingDistrictCode and SendingSchoolCode. Reporting district and school cannot be the same as sending district and school ReportingDistrictCode and ReportingSchoolCode cannot match SendingDistrictCode and SendingSchoolCode since DualCreditSite is not provided.
191 Dual Credit Site SCC01501 E If RecevingColDistCode does not equal the ReportingDistrictCode and the RecevingColDistCode exists in srm.dbo.v_dese_district_high (is a college) then DualCreditSite is required. DualCreditSite is required DualCreditSite is required since ReportingDistrictCode is a school district and the RecevingColDistCode is a college.
191 Dual Credit Site SCC01502 E If ReportingDistrictCode is not (‘126126’, ‘145145’, ‘166166’, ‘640121’) and DualCreditSite is Null and RecevingColDistCode is in (‘126126’, ‘145145’, ‘166166’, ‘640121’) then record is not allowed to be reported. DualCreditSite is expected This record should be removed. Only area career centers report students attending area career center classes.
191 Dual Credit Site SCC01503 E DualCreditSite cannot be 'DIST', 'COLL', or 'ACC' unless ReceivingColDistCode exists in srm.dbo.v_DESE_DISTRICT_HIGH. Matching ReceivingColDistCode to CNTY_DIST_CODE and currentschoolyear to Year. DualCreditSite is not valid DualCreditSite is not valid since ReceivingCollDistCode is not a college.
191 Dual Credit Site SCC01504 E DualCreditSite cannot be 'ITV' if ReportingDistrictCode = SendDistCode and ReportingSchoolCode = SendSchoolCode unless ReceivingColDistCode begins with 999 or exists in srm.dbo.v_DESE_DISTRICT_HIGH or.  Matching ReceivingColDistCode to CNTY_DIST_CODE and currentschoolyear to Year. DualCreditSite is not valid DualCreditSite cannot be ITV since Reporting District and School information match Sending District and School information and ReceivingCollDistCode is not a college.  You cannot send students to an ITV class that you broadcast.
192 Course Semester SCC00479 E Must be in code set: (Course_Semester_Codes) Invalid CourseSem code CourseSem is not valid.
193 Student Credits Earned SCC00470 E CreditEarned does not have a valid format. It may have 1 digit followed by an optional decimal point and 1 or 2 digits. CreditEarned has an invalid format CreditEarned does not have a valid format. It may have 1 digit followed by an optional decimal point and 1 or 2 digits.
193 Student Credits Earned SCC00471 W If CreditEarned is not null it must be zero or inclusively be between 0.25 and 7.00 CreditEarned is not in valid range CreditEarned should be between 0.25 and 7.00.
193 Student Credits Earned SCC00485 W If StudentGradeLevel is 09, 10, 11, or 12 and GradeEarned is not equal to F, PS, FL, IC, NC, or WD then CreditEarned cannot equal zero. CreditEarned is not valid CreditEarned should be between 0.25 and 7.00.
195 Student Credits Scheduled SCC00472 E CreditScheduled does not have a valid format. It may have 1 digit followed by an optional decimal point and 1 or 2 digits. CreditScheduled has an invalid format CreditScheduled does not have a valid format. It may have 1 digit followed by an optional decimal point and 1 or 2 digits.
195 Student Credits Scheduled SCC00473 W If CreditScheduled is not null it must be zero or inclusively be between 0.25 and 7.00 CreditScheduled is not in valid range CreditScheduled should be between 0.25 and 7.00.
201 Student Grade Earned SCC00474 E Must be in code set: (Grade_Codes). Invalid GradeEarned code GradeEarned must be A, A- ,B+ ,B ,B- ,C+ ,C ,C- ,D+ ,D ,D- ,F ,PS ,FL ,IC ,NC or WD.
205 Advanced Placement SCC00475 E Must be in code set: (Yes_No) Invalid AdvPlacement code AdvPlacement must be in Y or N.
207 Honors SCC00476 E Must be in code set: (Yes_No) Invalid Honors code Honors must be in Y or N.
235 Course Sequence Number SCC00483 E Must be in code set: (Course_Seq_Num_Codes) Invalid CourseSeqNum code CourseSeqNum is not valid.
235 Course Sequence Number SCC00484 W CRS.CourseSeqNum must be 0 or null if CRS.CourseNum is Null. CourseSeqNum must be 0 or Null CourseSeqNum must be 0 or null since CourseNum is null.