FileSpecRules:202308AugustCycleStudentEnrollandAttend
Item_Number Item_Name Collection_Rule_ID Severity Business_Rule Short_Title General_Message Detailed_Message
005 Collection Version SEA00001 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. NOTE: This rule applies to many fields but is tied to CollectionVersion due to DataSpecs constraints. 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 SEA00201 E Field exceeds its maximum length. NOTE: This rule applies to many fields but is tied to CollectionVersion due to DataSpecs constraints. 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 SEA00401 E CollectionVersion must match '2023Aug1.0StuEnrlAttnd' CollectionVersion must be '2023Aug1.0StuEnrlAttnd' The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2023Aug1.0StuEnrlAttnd'.
005 Collection Version SEA01401 E There must be at least one Student Enrollment and Attendance record. There are no StuEnrlAttnd records There must be at least one Student Enrollment and Attendance record.
010 Current School Year SEA00402 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'.
015 Attending District Code SEA00407 E AttendingDistrictCode must match a valid DESE County District Code. District codes are in DESE District table. Invalid AttendingDistrictCode code AttendingDistrictCode is not a valid district code.
020 Attending School Code SEA00601 E AttendingSchoolCode must be a valid school code in the Attending District (Attending District Code). Use MOSIS District Table and MOSIS Attendance Center tables. AttendingSchoolCode is not valid for AttendingDistrictCode AttendingSchoolCode is not a valid school code for the AttendingDistrictCode.
020 Attending School Code SEA00611 E If AttendingSchoolCode = 1000 then StudentGradeLevel must be 'PK' AttendingSchoolCode is not valid for StudentGradeLevel AttendingSchoolCode of 1000 is not allowed for grades K-12.
020 Attending School Code SEA00887 E ReportingSchoolCode cannot begin with 102 or 103 unless (ReportingDistrictCode is 002017) or (ReportingDistrictCode/ReportingSchoolCode combination is 010093/1020 or 090078/1030). AttendingSchoolCode should not begin with 102 or 103 AttendingSchoolCode 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.
025 Reporting District Code SEA00408 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 SEA00700 E Reporting District Code must match the SRM users district code. The student is not from this district The student's ReportingDistrictCode does not equal that of the trial.
030 Reporting School Code SEA00602 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 SEA00612 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 SEA00888 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.
035 Resident District Code SEA00409 E ResidentDistrictCode must match a valid DESE County District Code. District codes are in DESE District table. Invalid ResidentDistrictCode code ResidentDistrictCode is not a valid district code.
040 Resident School Code SEA00603 E ResidentSchoolCode must be a valid school code in the Resident District Code. Use MOSIS District Table and MOSIS Attendance Center tables. ResidentSchoolCode is not valid for ResidentDistrictCode ResidentSchoolCode is not a valid school code for the ResidentDistrictCode.
040 Resident School Code SEA00613 E If ResidentSchoolCode = 1000 then StudentGradeLevel must be 'PK' ResidentSchoolCode is not valid for StudentGradeLevel ResidentSchoolCode of 1000 is not allowed for grades K-12.
040 Resident School Code SEA00889 E ReportingSchoolCode cannot begin with 102 or 103 unless (ReportingDistrictCode is 002017) or (ReportingDistrictCode/ReportingSchoolCode combination is 010093/1020 or 090078/1030). ResidentSchoolCode should not begin with 102 or 103 ResidentSchoolCode 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 Student ID SEA00120 W If ResidencyStatus is not PT and StateID exists in another district's certified trial for the current school year, unless reportingdistrictcode is 096119 with ExtSchlHours greater than 0 and SummerAttendance equals 0. Student is reported by another district Student is reported by {District Code} - {District Name}. A student can be reported by only one district for the purpose of state aid. If the student attended more than one summer school then subsequent enrollments must be reported with a residency status of 'PT'.
045 MOSIS Student ID SEA01001 E State ID must match a Student ID in the MOSIS ID system SIDMASTER (State_Student_ID) StateID not found in MOSIS ID State ID was not found in the MOSIS ID system.
075 Date of Birth SEA00418 E DateOfBirth must be a valid date Invalid DateOfBirth The date is not valid. A date must be in MM/DD/YYYY format and be a valid date.
075 Date of Birth SEA01020 E Date of Birth should match the date of birth in the MOSIS ID system (in conjunction with State ID) SIDMASTER (Date_of_Birth) and SIDMASTER (State_Student_ID) DateOfBirth does not match MOSIS ID DateOfBirth does not match the date of birth in the MOSIS ID system.
075 Date of Birth SEA01050 W The Student's age must fall within an age range appropriate for their grade level. Reference the Age Grade Range excel document for more information. Unexpected student age for grade level The age of the student falls outside the expected bounds. Birth dates for grade {0} are expected to fall between {2} and {3}.
080 Student Grade Level SEA00403 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.
080 Student Grade Level SEA01064 E The StudentGradeLevel must be taught in the reporting school. Reference MO-2007-21-2007-K8 Indicator Business Rules-V1.2-JY.doc StudentGradeLevel not taught in reporting school The StudentGradeLevel is not taught in the school that is reporting the student.
090 Residency Status SEA00404 E Must be in code set: (Resident_Status_Codes). Invalid ResidencyStatus code ResidencyStatus must be R1, R2, NR, DI, PT, or FL.
090 Residency Status SEA00426 W If residencystatus = R2 then AttendingDistrictCode must exist in DESE_APPROVED_NONPUBLIC_DISTRICT Where AttendingDistrictCode = MOSIS_COUNTY_DISTRICT and CurrentSchoolYear = Year Residentstatus cannot be "R2" Residentstatus cannot be "R2" since the AttendingDistrictCode is not an approved non-public attendance site.
090 Residency Status SEA02860 E If ResidencyStatus = 'NR' or 'DI' or PT' then Reporting District Code and Attending District Code must be the same value. Reporting and Attending Districts must be equal for this ResidencyStatus When the student's residency status is Non-Resident (NR), Desegregated Inbound (DI) or Parent Tuition (PT) the reporting and attending district codes must be the same.
090 Residency Status SEA02865 E If ResidencyStatus = 'NR' or 'DI' or (PT and StudentGradeLevel is not PK) then Resident District Code cannot match Reporting District Code or Attending District Code. Note: This rule is not to be ran if the residencystatus is PT and the studentgradelevel is PK. Resident District cannot be the same as the Reporting or Attending District When the student's residency status is Non-Resident (NR), Desegregated Inbound (DI), or Parent Tuition (PT) the resident district code cannot match the reporting or attending district codes.
090 Residency Status SEA02960 E If ResidencyStatus = 'R2' then Reporting District Code and Resident District Code must be the same value. Reporting and Resident District must be the same when ResidencyStatus is R2 When the Residency Status is Resident II (R2) the Reporting District Code and Resident District Code must be the same.
090 Residency Status SEA02965 E If ResidencyStatus = 'R2' then Attending District Code cannot match the Reporting District Code. Attending district cannot match Reporting district when ResidencyStatus is R2 When Residency Status is Resident II (R2) the Attending District Code cannot be the same as Reporting District Code.
095 Regular Hrs Attended SEA00101 E RegHrsAttended is not allowed in the August Enrollment and Attendance Cycle Submission RegHrsAttended is not allowed RegHrsAttended is not allowed in the August Enrollment and Attendance Cycle Submission.
100 Regular Hrs Absent SEA00102 E RegHrsAbsent is not allowed in the August Enrollment and Attendance Cycle Submission RegHrsAbsent is not allowed RegHrsAbsent is not allowed in the August Enrollment and Attendance Cycle Submission.
105 Remedial Hrs Attended SEA00103 E RemHrsAttended is not allowed in the August Enrollment and Attendance Cycle Submission RemHrsAttended is not allowed RemHrsAttended is not allowed in the August Enrollment and Attendance Cycle Submission.
110 Hours in Session SEA00104 E HrsInSession is not allowed in the August Enrollment and Attendance Cycle Submission HrsInSession is not allowed HrsInSession is not allowed in the August Enrollment and Attendance Cycle Submission.
115 Summer Attendance SEA00414 E SummerAttendance does not have a valid format. It may have 1 to 4 digits followed by an optional decimal point and 1 to 4 digits. SummerAttendance must be a number Summer Attendance must be reported as a number with 1 to 4 digits followed by an optional decimal point and 1 to 4 digits.
115 Summer Attendance SEA00615 W If the sum of SummerAttendance grouped by  StateID and ReportingDistrictCode are between 210 and 420. SummerAttendance is higher than expected SummerAttendance is higher than expected (greater than 210 hours).
115 Summer Attendance SEA00616 E If the sum of SummerAttendance grouped by  StateID and ReportingDistrictCode is greater than or equal too 420. SummerAttendance is higher than allowed SummerAttendance is higher than allowed (greater than 419 hours).
115 Summer Attendance SEA00617 W If ResidencyStatus is RI, then SummerAttendance for StateID cannot be greater than TOTAL_HOURS_IN_SESSION in the DESE_DC_SUMMER_SCHOOL_APP_BUILDING table matching Year minus 1, District, School and a record must exist in DESE_DC_SUMMER_SCHOOL_APP_DISTRICT for currentschoolyear minus 1 and reportingdistrictcode where last_approval_date is after 3/1 of the currentschoolyear minus 1. SummerAttendance is too high or Summer School Application is not approved. Summer Attendance exceeds the Hours in Session on Core Data Screen 24A or Summer School Application has not been approved.
115 Summer Attendance SEA03300 W SummerAttendance should not be greater than SummerMembership SummerAttendance should not be greater than SummerMembership Summer Attendance should not be greater than Summer Membership.
115 Summer Attendance SEA04050 W Total SummerAttendance cannot equal total ExtSchlHours for ReportingDistrictCode and StateID. Summer Attendance cannot equal Extended School Year Hours Summer Attendance hours cannot equal Extended School Year hours.
115 Summer Attendance SEA04501 E If studentgradelevel equals PK, PKA, or PKP then SummerAttendance is not allowed in the August Enrollment and Attendance Cycle Submission. Summer Attendance is not allowed PK, PKA, or PKP student may not be reported for summer attendance in the August Enrollment and Attendance file.
115 Summer Attendance SEA04505 E If SummerAttendance is greater than 0, then STATUS must equal APPROVED in DESE_DC_SUMMER_SCHOOL_APP_DISTRICT table matching Year minus 1 and ESSER must equal N in the DESE_DC_SUMMER_SCHOOL_APP_BUILDING table matching on Year, District, School Code where reportingdistrictcode = FK_DIST_CNTY_DIST, FK_DIST_YEAR = currentschoolyear minus 1, and reportingschoolcode = FK_SCHOOL_CODE unless ExtSchlHours is greater than 0. Summer Attendance cannot be reported since there is no approved summer school application To claim summer school for state aid the LEA must have an approved summer school application. Summer Attendance cannot be reported since there is not an approved summer school application.
115 Summer Attendance SEA04510 E If SummerAttendance is equal to 0, then STATUS must equal APPROVED in DESE_DC_SUMMER_SCHOOL_APP_DISTRICT table matching Year minus 1 and ESSER must equal Y in the DESE_DC_SUMMER_SCHOOL_APP_BUILDING table matching on Year, District, School Code where reportingdistrictcode = FK_DIST_CNTY_DIST, FK_DIST_YEAR = currentschoolyear minus 1, and reportingschoolcode = FK_SCHOOL_CODE unless ExtSchlHours is greater than 0. Summer Attendance cannot be reported as zero since there is no approved summer school application or ESSER funds reported To claim summer school for state aid using ESSER funds, the LEA must have an approved summer school application and report ESSER funding on the summer school application.
120 Summer Membership SEA00415 E SummerMembership does not have a valid format. It may have 1 to 4 digits followed by an optional decimal point and 1 to 4 digits. SummerMembership must be a number Summer Membership must be reported as a number with 1 to 4 digits followed by an optional decimal point and 1 to 4 digits.
120 Summer Membership SEA04502 E If studentgradelevel equals PK, PKA, or PKP then SummerMembership is not allowed in the August Enrollment and Attendance Cycle Submission. SummerMembership is not allowed PK, PKA, or PKP student may not be reported for summer membership in the August Enrollment and Attendance file.
125 Entry Date SEA00105 E EntryDate must be a valid date. EntryDate is not a valid date The date is not valid. A date must be in MM/DD/YYYY format and be a valid date.
125 Entry Date SEA03450 E EntryDate must be on or before the exit date. EntryDate is after ExitDate EntryDate must be prior to ExitDate or the same as the ExitDate.
130 Entry Code SEA00106 E EntryCode is not allowed in the August Enrollment and Attendance Cycle Submission EntryCode is not allowed EntryCode is not allowed in the August Enrollment and Attendance Cycle Submission.
135 Exit Date SEA00107 E ExitDate must be a valid date. ExitDate is not a valid date The date is not valid. A date must be in MM/DD/YYYY format and be a valid date.
140 Exit Code SEA00108 E ExitCode is not allowed in the August Enrollment and Attendance Cycle Submission ExitCode is not allowed ExitCode is not allowed in the August Enrollment and Attendance Cycle Submission.
145 Exit Destination District Code SEA00109 E ExitDestDistrictCode is not allowed in the August Enrollment and Attendance Cycle Submission ExitDestDistrictCode is not allowed ExitDestDistrictCode is not allowed in the August Enrollment and Attendance Cycle Submission.
150 Exit Destination School Code SEA00110 E ExitDestSchoolCode is not allowed in the August Enrollment and Attendance Cycle Submission ExitDestSchoolCode is not allowed ExitDestSchoolCode is not allowed in the August Enrollment and Attendance Cycle Submission.
155 Exit Destination Comment SEA00111 E ExitDestComment is not allowed in the August Enrollment and Attendance Cycle Submission ExitDestComment is not allowed ExitDestComment is not allowed in the August Enrollment and Attendance Cycle Submission.
156 School Choice SEA00114 E SchoolChoice must be null SchoolChoice is not allowed SchoolChoice is not allowed to be reported in August.
156 School Choice SEA00421 E Must be in code set: (School_Choice_Codes) Invalid SchoolChoice code SchoolChoice must be A, E, O or R.
157 Extended School Hours SEA00115 E ExtSchlHours does not have a valid format. It may have 1 to 4 digits followed by an optional decimal point and 1 to 4 digits. ExtSchlHours must be a number ExtSchlHours must be reported as a number with 1 to 4 digits followed by an optional decimal point and 1 to 4 digits.
157 Extended School Hours SEA00116 W SUM of ExtSchlHours for the StateID is greater than 450 (not greater than or equal to). Total ExtSchlHours are higher than allowed Total ExtSchlHours for this state id are greater than 450 which is higher than allowed. Total hours are calculated across all records containing this state id. Total ExtSchlHours for this state id ({0}) are greater than 450 which is higher than allowed. Total hours are calculated across all records containing this state id.