| 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. |
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 '2008Jun1.0StuEnrlAttnd' |
CollectionVersion must be '2008Jun1.0StuEnrlAttnd' |
The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2008Jun1.0StuEnrlAttnd'. |
|
| 005 |
Collection Version |
SEA01401 |
E |
2008 June Enrollment and Attendance cannot contain zero records. An error should occur so to prevent user from certifying the trial. |
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 '2008' |
CurrentSchoolYear must be '2008' |
The CurrentSchoolYear identifies the school year for the data. For this collection the CurrentSchoolYear must be '2008'. |
|
| 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. |
|
| 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. |
|
| 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. |
|
| 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. |
|
| 045 |
MOSIS Student ID |
SEA01005 |
E |
Must match a state ID in the district's student core file for June. |
StateID not found in the student core file |
State ID does not match any State ID found in the student core file. There must be a matching State ID in the district's student core file. |
|
| 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 |
StudentGradeLevel must be PK, K, KA, KP, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11 or 12. |
|
| 080 |
Student Grade Level |
SEA01060 |
E |
The StudentGradeLevel must be taught in the attending school. Reference MO-2007-21-2007-K8 Indicator Business Rules-V1.2-JY.doc |
StudentGradeLevel not taught in attending school |
The StudentGradeLevel is not taught in the school the student is attending. |
|
| 080 |
Student Grade Level |
SEA01061 |
E |
The StudentGradeLevel must be taught in the resident school. Reference MO-2007-21-2007-K8 Indicator Business Rules-V1.2-JY.doc |
StudentGradeLevel not taught in resident school |
The StudentGradeLevel is not taught in the student's resident school. |
|
| 080 |
Student Grade Level |
SEA01062 |
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. |
|
| 080 |
Student Grade Level |
SEA01063 |
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. |
|
| 085 |
Social Security Number |
SEA00417 |
E |
The Social Security Number can be specified as ###-##-#### or 9 digits. |
SSN has an invalid format |
The Social Security Number can be specified as ###-##-#### or 9 digits. |
|
| 090 |
Residency Status |
SEA00404 |
E |
Must be in code set: (Resident_Status_Codes). |
Invalid ResidencyStatus code |
ResidencyStatus must be R1, R2, NR, DI, PT, FL or HS. |
|
| 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 |
SEA02750 |
E |
If ResidencyStatus = 'R1' then Reporting District Code, Resident District Code, Attending District Code must be the same value. |
Invalid district codes for ResidencyStatus 'R1' |
When the Residency Status is 'R1' then Reporting District Code, Attending District Code, and Resident District Code must be the same. |
|
| 090 |
Residency Status |
SEA02800 |
E |
If ResidencyStatus = 'FL' then Attending District Code must be one of these 3 values (051155 or 085046 or 019152). |
AttendingDistrictCode must be 051155, 085046 or 019152 |
When the student's residency status is Federal Lands (FL), the attending district code must be 051155, 085046 or 019152. |
|
| 090 |
Residency Status |
SEA02801 |
E |
If ResidencyStatus = 'FL' then Reporting District Code must be one of these 3 values (051155 or 085046 or 019152). |
ReportingDistrictCode must be 051155, 085046 or 019152 |
When the student's residency status is Federal Lands (FL), the reporting district code must be 051155, 085046 or 019152. |
|
| 090 |
Residency Status |
SEA02802 |
E |
If ResidencyStatus = 'FL' then Resident District Code must be one of these 3 values (051155 or 085046 or 019152). |
ResidentDistrictCode must be 051155, 085046 or 019152 |
When the student's residency status is Federal Lands (FL), the resident district code must be 051155, 085046 or 019152. |
|
| 090 |
Residency Status |
SEA02850 |
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 |
SEA02875 |
E |
If ResidencyStatus = 'NR' or 'DI' or PT' then Resident District Code cannot match Reporting District Code or Attending District Code. |
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 |
SEA02900 |
E |
If ResidencyStatus = 'R2' or 'HS' 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 |
SEA02925 |
E |
If ResidencyStatus = 'R2' or 'HS' 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. |
|
| 090 |
Residency Status |
SEA02934 |
E |
If residencyStatus = 'R1', 'FL', 'NR','DI','PT' then AttendingSchoolCode, ReportSchoolCode must be the same value. |
ResidencyStatus not valid for ReportingSchoolCode and AttendingSchoolCode |
ResidencyStatus not valid for ReportingSchoolCode and AttendingSchoolCode combination. Attending and Reporting school codes must be the same if ResidencyStatus is R1, FL, NR, DI, or PT. |
|
| 090 |
Residency Status |
SEA02935 |
E |
If residencyStatus = 'R2' then ReportSchoolCode, ResidentSchoolCode must be the same value. |
ResidencyStatus not valid for ReportingSchoolCode and ResidentSchoolCode |
ResidencyStatus not valid for ReportingSchoolCode and ResidentSchoolCode combination. Resident and Reporting school codes must be the same if ResidencyStatus is R2. |
|
| 095 |
Regular Hrs Attended |
SEA00411 |
E |
RegHrsAttended does not have a valid format. It may have 1 to 4 digits followed by an optional decimal point and 1 to 4 digits. |
RegHrsAttended must be a number |
Regular Hours Attended must be reported as a number with 1 to 4 digits followed by an optional decimal point and 1 to 4 digits. |
|
| 095 |
Regular Hrs Attended |
SEA00422 |
W |
SUM of RegHrsAttended + RegHrsAbsent for the StateID Where SEA.ResidencyStatus in (R1,NR,DI,FL,PT) grouped by Year, District, School, Grade cannot be greater than REG_TERM_TOTAL_CAL_HRS in the DESE_SFIN_ADA table matching Year, District, School, Grade. |
RegHrsAttended plus RegHrsAbsent are too high |
Total Regular Hours Attended plus Absent Hours for this state id exceed the Calendar Hours (Core Data Screen 10). Total hours and absence are calculated across all records containing this state id for the school and grade. |
Total Regular Hours Attended plus Absent Hours for this state id ({0}) exceed the Calendar Hours (Core Data Screen 10). Total hours and absence are calculated across all records containing this state id for the school and grade. |
| 095 |
Regular Hrs Attended |
SEA02950 |
E |
If Student Grade Level <> 'PK' and ResidencyStatus does not equal 'HS' and entry date <> exit date then value must be greater than Zero. |
RegHrsAttended is required |
Regular hours attended must be reported. |
|
| 100 |
Regular Hrs Absent |
SEA00412 |
E |
RegHrsAbsent does not have a valid format. It may have 1 to 4 digits followed by an optional decimal point and 1 to 4 digits. |
RegHrsAbsent must be a number |
Regular Hours Absent must be reported as a number with 1 to 4 digits followed by an optional decimal point and 1 to 4 digits. |
|
| 100 |
Regular Hrs Absent |
SEA03000 |
W |
If Student Grade Level <> 'PK' and ResidencyStatus does not equal 'HS' and entry date <> exit date then value must be greater than Zero. |
Regular Hours Absent is reported as zero |
Regular Hours Absent is reported as zero. |
|
| 105 |
Remedial Hrs Attended |
SEA00413 |
E |
RemHrsAttended does not have a valid format. It may have 1 to 4 digits followed by an optional decimal point and 1 to 4 digits. |
RemHrsAttended must be a number |
Remedial Hours Attended must be reported as a number with 1 to 4 digits followed by an optional decimal point and 1 to 4 digits. |
|
| 105 |
Remedial Hrs Attended |
SEA00424 |
E |
SUM of RemHrsAttended for the StateID is greater than 348 (Not greater than or equal too) |
Total RemHrsAttended are higher than allowed |
Total Remedial Hours Attended for this state id are greater than 348 which is higher than allowed. Total hours are calculated across all records containing this state id. |
Total Remedial Hours Attended for this state id ({0}) are greater than 348 which is higher than allowed. Total hours are calculated across all records containing this state id. |
| 105 |
Remedial Hrs Attended |
SEA00425 |
W |
SUM of RemHrsAttended for the StateID is greater than 174 and less than or equal too 348 |
Total RemHrsAttended are higher than expected |
Total Remedial Hours Attended for this state id are greater than 174 which is higher than expected. Total hours are calculated across all records containing this state id. |
Total Remedial Hours Attended for this state id ({0}) are greater than 174 which is higher than expected. Total hours are calculated across all records containing this state id. |
| 110 |
Hours in Session |
SEA00416 |
E |
HrsInSession does not have a valid format. It may have 1 to 4 digits followed by an optional decimal point and 1 or 2 digits. |
HrsInSession has an invalid format |
HrsInSession does not have a valid format. It may have 1 to 4 digits followed by an optional decimal point and 1 or 2 digits. |
|
| 110 |
Hours in Session |
SEA03100 |
E |
Hours in Session for all records with residency status of 'R2' (See rule R009850) for an attending district code and attending school code and grade level must be the same. |
HrsInSession does not match peers |
All students with a residency status of R2 in the same attending district, attending school, and grade level must have the same hours in session. |
|
| 110 |
Hours in Session |
SEA03150 |
E |
Value is required if ResidencyStatus is 'R2'. |
HrsInSession is required if ResidencyStatus is 'R2' |
Hours in session must be reported if the student's residency status is resident II. |
|
| 110 |
Hours in Session |
SEA03151 |
E |
Value must be null if is not ResidencyStatus is 'R2' |
HrsInSession is not allowed unless ResidencyStatus is R2 |
Hours In Session is not allowed unless Residency Status is 'R2'. |
|
| 110 |
Hours in Session |
SEA03200 |
W |
If HrsInSession is not null then value must be greater than or equal to 1044 and less than 1200 |
HrsInSession is not valid |
HrsInSession should be a numeric value between 1044 and 1200. |
|
| 115 |
Summer Attendance |
SEA00112 |
E |
SummerAttendance is not allowed in the June Core, Enrollment and Attendance Cycle Submission. |
SummerAttendance is not allowed |
SummerAttendance is not allowed in the June Core, 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. |
|
| 120 |
Summer Membership |
SEA00113 |
E |
SummerMembership is not allowed in the June Core, Enrollment and Attendance Cycle Submission. |
SummerMembership is not allowed |
SummerMembership is not allowed in the June Core, Enrollment and Attendance Cycle Submission. |
|
| 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. |
|
| 125 |
Entry Date |
SEA00419 |
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 |
SEA03400 |
E |
Valid date for the current school year. (Date must be after July 1) |
EntryDate must be in current school year |
The student's entry date must be a valid date within the current school year. EntryDate must be in the current school year. |
The school year begins on {0} and ends on {1}. |
| 125 |
Entry Date |
SEA03450 |
E |
Entry Date 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 |
SEA00405 |
E |
Must be in code set: (Entry_Codes). |
Invalid EntryCode code |
EntryCode is not a valid code. |
|
| 130 |
Entry Code |
SEA03525 |
W |
If entry code is E100 then StudentGradeLevel must be ' K', 'KA', 'KP', or 'PK'. |
EntryCode is E100 but StudentGradeLevel is not ' K', 'KA', 'KP' or 'PK' |
Entry Code may not be valid if student is not in pre-school or kindergarten. Students who are initially entering education should enter at a pre-school or kindergarten grade level. |
|
| 135 |
Exit Date |
SEA00420 |
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. |
|
| 135 |
Exit Date |
SEA03550 |
E |
Valid date for the current school year. Date must be prior to June 30 |
ExitDate must be in current school year |
ExitDate must be in the current school year. |
The school year begins on {0} and ends on {1}. |
| 140 |
Exit Code |
SEA00406 |
E |
Must be in code set: (Exit_Codes). |
Invalid ExitCode code |
ExitCode is not a valid code |
|
| 140 |
Exit Code |
SEA03855 |
E |
If a MOSIS ID occurs multiple times in enrollment and attendance and one of the records contains an exit code equal to D01 or D02 or D03 or D04 or D05, D06, G01, or G02 then it must be the record with the latest exit date otherwise it is an error. (This i |
Graduate or Drop out not reported as final exit |
Student is marked as a graduate or drop out prior to student's exit status with the latest date. If the student is a graduate or drop out then that status must be reported on the record with the student's latest exit date. |
|
| 140 |
Exit Code |
SEA03856 |
W |
StateId cannot have overlapping entry/exit date segments. |
Entry/Exit Date segment overlaps another segment. |
Entry/Exit Date segment overlaps another segment. |
|
| 140 |
Exit Code |
SEA03860 |
E |
If exit code is R003 it cannot be the students final exit for the year. |
Student cannot have Remained: Other (R003) as final exit of the school year |
Student cannot have Remained: Other (R003) as final exit of the school year. Use exit code R001 or R002 to mark natural progression of a student who will remain in your district for next year. |
|
| 145 |
Exit Destination District Code |
SEA00410 |
E |
Value must match a valid DESE County District Code. District codes are in DESE District table. |
Invalid ExitDestDistrictCode code |
ExitDestDistrictCode is not a valid district code |
|
| 145 |
Exit Destination District Code |
SEA03650 |
E |
Value is required if ExitCode ='T002' or 'T001' |
ExitDestDistrictCode is required when ExitCode is T001 or T002 |
Exit destination district code is required if the Exit Code is 'T001' or 'T002'. |
|
| 145 |
Exit Destination District Code |
SEA03675 |
E |
Value is required to be null if ExitCode is not 'T002' or 'T001'. |
ExitDestDistrictCode is not allowed unless ExitCode is T001 or T002 |
Exit destination district code is not allowed unless the Exit Code is 'T001' or 'T002'. |
|
| 150 |
Exit Destination School Code |
SEA03750 |
E |
Value is required if ExitCode ='T002' or 'T001' |
ExitDestSchoolCode is required when ExitCode is T001 or T002 |
Exit destination school code must be reported when the student transfers to another school in the state - T001 or T002. |
|
| 150 |
Exit Destination School Code |
SEA03775 |
W |
Exit destination school code is not allowed unless the Exit Code is 'T001' or 'T002'. |
ExitDestSchoolCode is not allowed unless ExitCode is T001 or T002 |
Exit destination school code cannot be reported unless the student transfers to another school in the state - T001 or T002. |
|
| 150 |
Exit Destination School Code |
SEA03800 |
W |
Value must match a valid DESE School Code and value must be a valid school code in the Exit Destination District Code. Use MOSIS District Table and MOSIS Attendance Center tables. |
ExitDestSchoolCode is not valid for ExitDestDistrictCode |
Exit destination school code is not a valid school code associated with the exit destination district. |
|
| 155 |
Exit Destination Comment |
SEA03850 |
E |
Value is required if ExitCode = 'T003' or 'T004' or 'T005' or 'T006' or 'T007' or 'T008' |
ExitDestComment is required for the ExitCode |
Exit destination comment is required if the student did not transfer to another school district in the state - T003, T004, T005, T006, T007 or T008. |
|
| 156 |
School Choice |
SEA00421 |
E |
Must be in code set: (School_Choice_Codes) |
Invalid SchoolChoice code |
SchoolChoice must be A, E, O or R. |
|
| 156 |
School Choice |
SEA04001 |
E |
If SchoolChoice is E, O, or A then the TitleI field in the DESE_ATTENDANCE_CENTER table should be “T” or “S” for the District, School, and Year, and a matching record exists in the AYP table where currentschoolyear matches the the titleI_year and reportin |
SchoolChoice is not valid |
SchoolChoice is not valid since the ReportingSchoolCode is not a Title I school and/or not in School Improvement. |
|
| 156 |
School Choice |
SEA04002 |
E |
If SchoolChoice is R then some school in the district (reportingdistrictcode) must have a record in the DESE_ATTENDANCE_CENTER for the year matching currentschoolyear with “T” or “S” as the Title I value. The school must also have record existing in the |
SchoolChoice is not valid |
SchoolChoice is not valid since there are no valid Title I schools in the district in School Improvement. |
|
| 156 |
School Choice |
SEA04003 |
E |
If SchoolChoice is R then the reportingschoolcode must not have a record in the AYP_SUMMARY table where currentschoolyear matches TitleI_Year and SI_SUMMARY_LEVEL_TITLEI in ('SIL1','SIL1D','SIL2', 'SIL2D', 'SIL3CA', 'SIL3CAD' 'SIL4RP', 'SIL5RC', 'SIL5RI' |
SchoolChoice is not valid |
SchoolChoice is not valid since the ReportingSchoolCode is in School Improvement. |
|