FileSpecRules:202300EOCException
Item_Number Item_Name Collection_Rule_ID Severity Business_Rule Short_Title General_Message Detailed_Message
005 Collection Version ASM00001 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 ASM00201 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 ASM00401 E CollectionVersion must match '2023EOCEXP1.0AsmPre' CollectionVersion must be '2023EOCEXP1.0AsmPre' The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2023EOCEXP1.0AsmPre'
005 Collection Version ASM01600 E There must be at least one Assessment Pre-Code record There are no Assessment Pre-Code records There must be at least one Assessment Pre-Code record.
010 Current School Year ASM00402 E CurrentSchoolYear must match '2023' CurrentSchoolYear must be '2023' The CurrentSchoolYear identifies the school year for the data. For this collection the CurrentSchoolYear must be '2023'.
025 Reporting District Code ASM00441 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 ASM00700 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 ASM00602 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.
030 Reporting School Code ASM00612 E If ReportingSchoolCode = 1000 then StudentGradeLevel must be 'PK' ReportingSchoolCode is not valid for StudentGradeLevel ReportingSchoolCode of 1000 is not allowed for grades K-12.
030 Reporting School Code ASM00888 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.
050 MOSIS Student ID ASM01001 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 Date of Birth ASM00446 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.
080 Date of Birth ASM01020 E Date of Birth verified against ID system (in conjunction with State ID) SIDMASTER (Date_of_Birth) and SIDMASTER (State_Student_ID) DateOfBirth does not match MOSIS ID The date of birth reported does not match the date of birth in the MOSIS ID system.
095 Student Grade Level ASM01062 W If StudentGradeLevel = KA then verify record exists in Calendar_Header table where reportingdistrictcode = fk_dist_cnty_dist and currentschoolyear = fk_dist_year and begin_grade = (space K) and end_grade = (space K) and KINDERGARTEN_INDICATOR = A StudentGradeLevel does not exist in Calendar StudentGradeLevel KA does not exist in Core Data Calendar.
095 Student Grade Level ASM01063 W If StudentGradeLevel = KP then verify record exists in Calendar_Header table where reportingdistrictcode = fk_dist_cnty_dist and currentschoolyear = fk_dist_year and begin_grade = (space K) and end_grade = (space K) and KINDERGARTEN_INDICATOR = P StudentGradeLevel does not exist in Calendar StudentGradeLevel KP does not exist in Core Data Calendar.
095 Student Grade Level ASM01065 W Student Grade Level must be the same for all records with matching StateIDs StudentGradeLevel must be the same for StateID StudentGradeLevel must be the same for StateID
095 Student Grade Level ASM01080 E Reference MO-2007-21-2007-K8 Indicator Business Rules-V1.2-JY.doc (This is simliar to SEA01061 except for against the ReportingDistrictCode and ReportingSchoolCode) StudentGradeLevel not taught in reporting school The StudentGradeLevel is not taught in the reporting school.
095 Student Grade Level ASM01083 E StudentGradeLevel must be 09, 10, 11, 12. Invalid StudentGradeLevel code StudentGradeLevel must 09, 10, 11 or 12.
100 Gender ASM00405 E Must be in code set: (Gender_Codes). Gender must be M or F Gender must be M or F.
100 Gender ASM01066 E Gender must be the same for all records with matching StateIDs Gender must be the same for StateID Gender must be the same for StateID
105 Race/Ethnicity ASM00406 E Must be in code set: (Race_Ethnicity_Codes). Invalid RaceEthnicity code RaceEthnicity must be A, B, H, I or W, P or M.
105 Race/Ethnicity ASM01067 E RaceEthnicity must be the same for all records with matching StateIDs RaceEthnicity must be the same for StateID RaceEthnicity must be the same for StateID
110 Assessment ASM01084 E Assessment must be EOCEX2, or EOCEX3, or EOCEX4. Invalid Assessment code Assessment must be EOCEX2, or EOCEX3, or EOCEX4.
110 Assessment ASM01085 W Assessment cannot be EOCEX4. Maintain documentation locally to report EOCEX4 District should maintain documentation locally to report EOCEX4 (Student took content in another public Missouri  district, but was not assessed).
110 Assessment ASM01090 E If Assessment equals EOCEX3, Subject must be AMGOV1. Invalid Assessment code Assessment EOCEX3 must be reported with subject AMGOV1.
115 Testing Method ASM01071 E Must be in code set: (ASMNT_Test_Method_Codes). Invalid TstMethod code TstMethod must be PENPAP or ONLINE.
140 Subject ASM01079 E Must be in code set: (ASMNT_Subject_Codes). Invalid Subject code Subject must be a valid Assessment Subject code.
140 Subject ASM01082 E Must be unique with StateID, and Subject within the file. Each student can only be reported once per Subject. Subject can only be reported once per StateID Subject can only be reported once per StateID.