FileSpecRules:202300LEP-ELLAssessmentPre-Code
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 '2023LEPELL1.0AsmPre' CollectionVersion must be '2023LEPELL1.0AsmPre' The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2023LEPELL1.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.
050 MOSIS Student ID ASM01064 E StateID must be unique for all records with the same Assessment (Duplicated student for the same assessment is not allowed) Duplicated student for the same assessment is not allowed Duplicated student for the same assessment is not allowed.
050 MOSIS Student ID ASM01070 E Reportingschoolcode must be the same across all records with the same StateID (State ID cannot exist in more than one building) State ID cannot exist in more than one building State ID cannot exist in more than one building.
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 ASM00404 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.
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.
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 ASM01068 E Must be in code set: (ASMNT_TYPE_CODES). Invalid Assessment code Assessment must be MAPSPR, EOCFAL, EOCSUM, or EOCSPR.
110 Assessment ASM01069 W If Assessment = 'MAPSPR' then StudentGradeLevel must be '03','04','05','06','07', or '08' Assessment is not valid for StudentGradeLevel Assessment MAPSPR expects StudentGradeLevel of 03, 04, 05, 06, 07, or 08.
110 Assessment ASM01081 E Assessment must match the 6 characters following the year in the collectionversion. substring(collectionversion,5, 6) Assessment does not match Collectionversion The type of Assessment reported does not match the Assessment type indicated in the CollectionVersion. This record will not be used.
110 Assessment ASM01081 E Assessment must match the 6 characters following the year in the collectionversion. substring(collectionversion,5, 6) Assessment does not match Collectionversion The type of Assessment reported does not match the Assessment type indicated in the CollectionVersion. This record will not be used.
115 Testing Method ASM01071 E Must be in code set: (ASMNT_Test_Method_Codes). Invalid TstMethod code TstMethod must be PENPAP or ONLINE.
115 Testing Method ASM01071 E Must be in code set: (ASMNT_Test_Method_Codes). Invalid TstMethod code TstMethod must be PENPAP or ONLINE.
115 Testing Method ASM01072 E Required if Assessment is EOCFAL, EOCSUM, or EOCSPR. TstMethod is required when Asssement is for End of Course TstMethod is required when Assessment is EOCFAL, EOCSUM, or EOCSPR.
115 Testing Method ASM01072 E Required if Assessment is EOCFAL, EOCSUM, or EOCSPR. TstMethod is required when Asssement is for End of Course TstMethod is required when Assessment is EOCFAL, EOCSUM, or EOCSPR.
140 Subject ASM01075 E Required if Assessment is EOCFAL, EOCSUM, or EOCSPR. Subject is required when Asssement is for End of Course Subject is required when Assessment is EOCFAL, EOCSUM, or EOCSPR.
140 Subject ASM01075 E Required if Assessment is EOCFAL, EOCSUM, or EOCSPR. Subject is required when Asssement is for End of Course Subject is required when Assessment is EOCFAL, EOCSUM, or EOCSPR.
140 Subject ASM01076 E Must be unique with StateID, Subject, and Assessment within the file. Each student can only be reported once per Subject per Assessment type. Subject can only be reported once per StateID Subject can only be reported once per StateID.
140 Subject ASM01076 E Must be unique with StateID, Subject, and Assessment within the file. Each student can only be reported once per Subject per Assessment type. Subject can only be reported once per StateID Subject can only be reported once per StateID.
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 ASM01079 E Must be in code set: (ASMNT_Subject_Codes). Invalid Subject code Subject must be a valid Assessment Subject code.
145 Period ASM01077 E Required if Assessment is EOCFAL, EOCSUM, or EOCSPR. Period is required when Asssement is for End of Course Period is required when Assessment is EOCFAL, EOCSUM, or EOCSPR.
145 Period ASM01077 E Required if Assessment is EOCFAL, EOCSUM, or EOCSPR. Period is required when Asssement is for End of Course Period is required when Assessment is EOCFAL, EOCSUM, or EOCSPR.
150 Sort ASM01078 W If Assessment is 'MAPSPR' then SORT value is expected. Sort is allowed for MAP Labels Sort field is allowed for all MAP Labels.
150 Sort ASM01078 W If Assessment is 'MAPSPR' then SORT value is expected. Sort is allowed for MAP Labels Sort field is allowed for all MAP Labels.
155 Examiner Email ASM01090 E Examiner Email must match a valid email format. A valid email address is one or more characters, a ampersand, one or more characters, a period, one or more characters. Examiner Email has an invalid email format Examiner Email has an invalid email format.