FileSpecRules:202306JuneCycleSummerStudentAssignment
Item_Number Item_Name Collection_Rule_ID Severity Business_Rule Short_Title General_Message Detailed_Message
005 Collection Version SSA00001 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 SSA00201 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 SSA00401 E CollectionVersion must match '2023Jun1.0SumStuAssign' CollectionVersion must match '2023Jun1.0SumStuAssign' CollectionVersion must match '2023Jun1.0SumStuAssign'
010 Current School Year SSA00402 E CurrentSchoolYear must match '2023' CurrentSchoolYear must match '2023' CurrentSchoolYear must match '2023'
025 Reporting District Code SSA00441 E ReportingDistrictCode must match a valid DESE County District Code. District codes are in DESE District table. Invalid ReportingDistrictCode code ReportingDistrictCode is not a valid district code.
025 Reporting District Code SSA00700 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 SSA00602 E ReportingSchoolCode must be a valid school code in the Reporting District (Reporting District Code) Use MOSIS District Table and MOSIS Attendance Center tables. Reporting School Code is not valid The Reporting School Code is not a valid school code in the Reporting District Code.
030 Reporting School Code SSA00888 E ReportingSchoolCode cannot begin with 102 or 103 unless (ReportingDistrictCode is 002017) or (ReportingDistrictCode/ReportingSchoolCode combination is 010093/1020 or 090078/1030). ReportingSchoolCode should not begin with 102 or 103 ReportingSchoolCode should not begin with 102 or 103 since school codes which begin with 102 and 103 are reserved for schools which do not have enrollments.
045 MOSIS ID SSA01001 E State ID verified against ID system SIDMASTER (State_Student_ID) StateID not found in MOSIS ID The student's State ID was not found in the MOSIS ID system.
045 MOSIS ID SSA01002 E State ID cannot exist more than once in this key. (CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, Edssn, PosCode, AssignNum) StateID reported for this Course Assignment more than once The student's State ID was reported more than once for this Course Assignment.
080 Student Date of Birth SSA01200 E StudentDateOfBirth must be specified as mm/dd/yyyy StudentDateOfBirth 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 SSA00442 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.
100 Student Gender SSA00443 E Must be in code set: (Gender_Codes). Invalid StudentGender code StudentGender must be one of M or F.
105 Race/Ethnicity SSA00444 E Must be in code set: (Race_Ethnicity_Codes). Invalid StudentRaceEthn code RaceEthnicity must be one of A, B, H, I, W, P, or M
120 Dual Credit Site SSA00445 E Must be in code set: (Dual_Credit_Site_Codes). Invalid DualCreditSite code DualCreditSite must be one of ACC, DIST, COLL, or ITV.
126 Receiving Coll/Dist Code SSA00446 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.
130 Sending District Code SSA00447 E Must be in code set: (DESE_District_Codes). Invalid SendDistCode code SendDistCode is not a valid district code.
140 Sending School Code SSA01404 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.
150 ED SSN SSA00460 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.
150 ED SSN SSA00462 E Edssn must exist in Summer Course Assignment with the following key. (CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, Edssn, PosCode, AssignNum) EDSSN must exist in Summer Course File EDSSN must exist in Summer Course File with these fields matching. (CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, Edssn, PosCode, AssignNum)
150 ED SSN SSA00500 E EDSSN is not allowed if DualCreditSite is COLL and CRS.CourseDeliverySys is not (V 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.
160 Position Code SSA00448 E Must be in code set: (Position_Codes). Invalid PosCode code PosCode must be one of 10, 20, 30, 40, 50, 60, 70, 80, or 90.
170 CTE Program Type SSA00449 E Must be in code set: (CTE_Program_Type_Codes). Invalid CTEProgType code CTEProgType is not valid.
180 Disadvantaged SSA00450 E Must be in code set: (Yes_No). Disadvantaged must be Y or N Disadvantaged must be Y or N.
270 IEP Disability (Primary) SSA00451 E Must be in code set: (Disability_Codes). Invalid IEPDisability code IEPDisability is not valid.
280 Adult SSA00456 E Must be in code set: (Yes_No). Adult must be Y or N Adult must be Y or N.
288 State Course Number SSA00463 E Must be in code set: (State_Course_Codes) Invalid CourseNum code CourseNum is not valid.