| 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 '2019Jun1.0StuEnrlAttnd' |
CollectionVersion must be '2019Jun1.0StuEnrlAttnd' |
The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2019Jun1.0StuEnrlAttnd'. |
|
| 005 |
Collection Version |
SEA01401 |
E |
2019 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 '2019' |
CurrentSchoolYear must be '2019' |
The CurrentSchoolYear identifies the school year for the data. For this collection the CurrentSchoolYear must be '2019'. |
|
| 015 |
Attending District Code |
SEA00407 |
E |
AttendingDistrictCode must match a valid DESE County District Code. District codes are in v_DESE_DISTRICT_PUB_HIGH_STATE matching the current school year. |
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 v_DESE_DISTRICT_PUB_HIGH_STATE matching the current school year. |
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 v_DESE_DISTRICT_PUB_HIGH_STATE matching the current school year. |
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 |
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 |
Student Grade Level must be a valid code in the Student Grade Level Codes. |
|
| 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. |
|
| 080 |
Student Grade Level |
SEA01070 |
W |
If StudentGradeLevel = PKA then verify record exists in Calendar_Header table where reportingdistrictcode = fk_dist_cnty_dist and currentschoolyear = fk_dist_year and begin_grade = PK and end_grade = PK and KINDERGARTEN_INDICATOR = A |
StudentGradeLevel does not exist in Calendar |
StudentGradeLevel PKA does not exist in Core Data Calendar. |
|
| 080 |
Student Grade Level |
SEA01071 |
W |
If StudentGradeLevel = PKP then verify record exists in Calendar_Header table where reportingdistrictcode = fk_dist_cnty_dist and currentschoolyear = fk_dist_year and begin_grade = PK and end_grade = PK and KINDERGARTEN_INDICATOR = P |
StudentGradeLevel does not exist in Calendar |
StudentGradeLevel PKP does not exist in Core Data Calendar. |
|
| 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 |
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 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 |
SEA02900 |
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 |
SEA02901 |
E |
If ResidencyStatus = 'R2' then Exit Code cannot begin with G or D. |
If Residency Status is R2, then Exit Code cannot begin with G or D. |
When the Residency Status is Resident II (R2) the Exit Code cannot begin with G or D. |
|
| 090 |
Residency Status |
SEA02925 |
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. |
|
| 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. |
|
| 090 |
Residency Status |
SEA03867 |
W |
If October STC EnrolledonCntDate is Y and StudentGradeLevel is not PK and ResidencyStatus is not R2 Then ResidencyStatus should exist in June SEA file in at least 1 segment for the student in the same ReportingDistrictCode for the same CurrentSchoolYear. |
Student's ResidencyStatus from your district's certified October Student Core does not match or does not exist in the June Student Enrollment and Attendance |
Student's ResidencyStatus from your district's certified October Student Core does not match or does not exist in the June Student Enrollment and Attendance. If a student was marked as enrolled on the count date in October then at least 1 June enrollment |
The Residency Status for StateID {0} in the certified October Student Core does not match or does not exist in the June Student Enrollment and Attendance. If a student was marked as enrolled on the count date in October then at least 1 June enrollment s |
| 090 |
Residency Status |
SEA03868 |
W |
If February STC EnrolledonCntDate is Y and StudentGradeLevel is not PK and ResidencyStatus is not R2 Then ResidencyStatus should exist in June SEA file in at least 1 segment for the student in the same ReportingDistrictCode for the same CurrentSchoolYear. |
Student's ResidencyStatus from your district's certified February Student Core does not match or does not exist in the June Student Enrollment and Attendance |
Student's ResidencyStatus from your district's certified February Student Core does not match or does not exist in the June Student Enrollment and Attendance. If a student was marked as enrolled on the count date in February then at least 1 June enrollmen |
The Residency Status for StateID {0} in the certified February Student Core does not match or does not exist in the June Student Enrollment and Attendance. If a student was marked as enrolled on the count date in February then at least 1 June enrollment |
| 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 +1 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 entry date <> exit date then value cannot be null and must be greater than Zero unless a June Course Completion record matching ReportingDistrictCode and StateID is found where the October Course Assignment CRS.DeliverySystem equals 'V' matching on ReportingDistrictCode, ReportingSchoolCode, EDSSN, PosCode, CTEProgType, and AssignNum. |
RegHrsAttended is required |
Regular hours attended must be reported. |
|
| 095 |
Regular Hrs Attended |
SEA03870 |
W |
RegHrsAttended + RegHrsAbsent must be less than or equal too number of days in attendance times 7. Calculate number of days in attendance by adding the date difference of thel segements for the student where RegHrsAttended or RegHrsAbsent are greater than zero. |
RegHrsAttended plus RegHrsAbsent appear too high for number of days attended |
RegHrsAttended plus RegHrsAbsent appear too high for number of days attended |
|
| 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 |
E |
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. |
|
| 130 |
Entry Code |
SEA03862 |
E |
If exit code begins with T then subsequent entry code (if exists) must begin with T. The subsequent entry code is the record with the first entry date on or after the exit date. |
ExitCode does not match the subsequent EntryCode |
Exitcode is marked as a transfer-out and another record for this student has been located with an EntryDate subsequent to this record's ExitDate which is not marked as a transfer-in. |
|
| 130 |
Entry Code |
SEA03863 |
W |
If exit code begins with S then subsequent entry code (if exists) must begin with S. The subsequent entry code is the record with the first entry date after the exit date. |
ExitCode does not match the subsequent EntryCode |
Exitcode is marked as a Stopout:Exit and another record for this student has been located with an EntryDate subsequent to this record's ExitDate which is not marked as a Stopout:Entry. |
|
| 130 |
Entry Code |
SEA03864 |
W |
If exit code begins with R then subsequent entry code (if exists) must begin with R and the last 2 characters must match the prior exit code. For example if a studen'ts record had Entry Date of 1/1/2008 with Entry Code of T102 and an Exit date of 1/30/2008 with Exit Code of R004. If that student had additional records the record with an entry date closest but after 1/30/2008 must have an Entry Code of RX04. (X being variable) |
Unexpected EntryCode |
EntryCode is expected to be a matching Remained code since the previous segment had an ExitCode of Remained for this student. |
|
| 130 |
Entry Code |
SEA03866 |
E |
The initial entry code of a student cannot be S100 after the last Wednsday in September for the CurrentSchoolYear - 1. For instance in the 2009 School year 10/24/2008 would be the as of date. This rule needs to be dynamic so that it does not need udpated each year. |
EntryCode of StopOut: Entry is not valid |
EntryCode of StopOut: Entry is not valid since the entry date is after the September Count date (Last Weds. In September) |
|
| 130 |
Entry Code |
SEA03869 |
W |
If the entrycode is S100 or S101 then the datediff of the prior exitcode of S000 or S001 must be at least 21 or more days. |
StopOut is invalid |
StopOut is invalid since student was not dropped out for more than 20 days. |
|
| 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 S001, T009, R001, R002, D01, D02, D03, D04, D05, D06, G01, or G03 then it must be the record with the latest exit date otherwise it is an error. (This is saying that if a kid is a drop out then his final exit code of the year must be the drop out code.) |
ExitCode is only valid for final exit |
Student cannot be reported as a stopout suspension, transfer deceased, remained advanced or retained, graduate or dropped out prior to exit status with the latest date. |
|
| 140 |
Exit Code |
SEA03856 |
E |
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 |
SEA03857 |
E |
Check prior year June Student Enrollment and Attendance certified submission matching the ReportingDistrictCode and locate all exit codes with the value of S000. If the record is the record with the latest exit date for that student (the last exit of the year) then a record must exist in the current year Student Enrollment and Attendance file with an entry date of S100 and it must be have the earliest entry date (the students first segement of the year). This rule is ensuring that a student who exited the year as a stop out exit enters the following year as a stop out entry. |
Missing StopOut Entry for student |
Student was reported as ending the prior year as a StopOut Exit and therefore must be reported as StopOut Entry for current year. |
{FirstName} {LastName} StateID {0} first entry date must have an entry code of S100 or S101. |
| 140 |
Exit Code |
SEA03858 |
E |
If exit code begins with G then studentgradelevel must be 12. |
Graduates must be reported as twelfth graders. |
Students reported with graduation exit codes must have StudentGradeLevel of 12. |
|
| 140 |
Exit Code |
SEA03859 |
E |
If exit code is R004 it cannot be the students final exit for the year. |
Student cannot have Remained: Changed Grade (R004) as final exit of the school year |
Student cannot have Remained: Changed Grade (R004) 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. |
|
| 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. |
|
| 140 |
Exit Code |
SEA03861 |
E |
If exit code is T002 it cannot be the students final exit for the year. |
Student cannot have Transferred Out: Tfer to pub schl within district (T002) as final exit of the school year |
Student cannot have Transferred Out: Tfer to pub schl within district (T002) 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. |
|
| 140 |
Exit Code |
SEA03865 |
E |
If exitcode is D04 then student must be age 20 or older as of December 1 of the CurrentSchoolYear. |
Maximum Age not reached |
ExitCode of D04 should not be reported unless student is Age 20 or older as of December 1 of the current school year. |
|
| 140 |
Exit Code |
SEA03871 |
E |
If StudentGradeLevel = 12 then ExitCode cannot be R001 |
ExitCode cannot be R001 |
ExitCode cannot be R001 since StudentGradeLevel is 12. |
|
| 140 |
Exit Code |
SEA03872 |
E |
Check prior year June Student Enrollment and Attendance certified submission matching the ReportingDistrictCode and locate all exit codes with the value of R001, R002, respectively, for grades 8, 9, 10, 11, 12 unless studentgradelevel is 8 and elementary only indicator in dese_district table is Y. If the record is the record with the latest exit date for that student (the last exit of the year) then a record must exist in the current year Student Enrollment and Attendance file with an entry date of R101 , R102 and it must be the earliest entry date (the students first segment of the year). This rule is ensuring that a student who exited the year as remained enters the following year as a remained entry. |
Missing Remained Entry for Grade 8-12 student |
Grade 8-12 student was reported as ending the prior year as Remained and therefore must be reported with the matching Remained entry for current year. |
{FirstName} {LastName} StateID {0} first entry date must have an entry code of {entryCode}. |
| 140 |
Exit Code |
SEA03873 |
W |
Check prior year June Student Enrollment and Attendance certified submission matching the ReportingDistrictCode and locate all exit codes with the value of R001, R002, respectively, for grades PK, K, 1, 2, 3, 4, 5, 6, 7. If the record is the record with the latest exit date for that student (the last exit of the year) then a record must exist in the current year Student Enrollment and Attendance file with an entry date of R101, R102 and it must be the earliest entry date (the students first segement of the year). This rule is ensuring that a student who exited the year as remained enters the following year as a remained entry. |
Missing Remained Entry for Grade PK-7 student |
Grade PK-7 student was reported as ending the prior year as Remainedand therefore must be reported with the matching Remained entry for current year. |
{FirstName} {LastName} StateID {0} first entry date must have an entry code of {entryCode}. |
| 140 |
Exit Code |
SEA03880 |
E |
If SEA.ExitCode equals G03, then STC.IEPDisability cannot be 00 matching on CurrentSchoolYear,ReportingDistrictCode, StateID. |
Graduates with alternate standards (G03) must have an IEP code other than 00 |
Students reported with exit code G03 must have an IEP Disability code other than 00 reported in the Student Core. |
|
| 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. |
|
| 157 |
Extended School Hours |
SEA00117 |
E |
ExtSchlHours is not allowed in the June Enrollment and Attendance Cycle Submission |
ExtSchlHours is not allowed |
ExtSchlHours is not allowed in the June Enrollment and Attendance Cycle Submission. |
|
| 158 |
Chronic Absenteeism |
SEA04000 |
E |
If ChronicAbsent * (DESE_SFIN_ADA.Standard_Day_Length / 2) > regHrsAbsent |
ChronicAbsent exceeds the number of hours reported in regHrsAbsent |
ChronicAbsent multiplied by half the standard day length exceeds the regHrsAbsent. |
|
| 158 |
Chronic Absenteeism |
SEA04002 |
E |
If ChronicAbsent > 0 then If regHrsAbsent / (DESE_SFIN_ADA.Standard_Day_Length / 2) <= ChronicAbsent |
RegHrsAbsent is too low |
RegHrsAbsent is too low. RegHrsAbsent must be greater than the ChronicAbsent multiplied by half the standard day length. |
|
| 158 |
Chronic Absenteeism |
SEA04003 |
E |
ChronicAbsent must be an integer |
ChronicAbsent has an invalid format |
ChronicAbsent should be an integer that is 1 to 3 digits long. |
|