| 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. |