FileSpecRules:202010OctoberCycleStudentCore
Item_Number Item_Name Collection_Rule_ID Severity Business_Rule Short_Title General_Message Detailed_Message
005 Collection Version STC00001 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 STC00201 E Field exceeds its maximum length Field exceeds its maximum length Field exceeds its maximum length. The {0} field exceeds its maximum allowable length of {1} character(s).
005 Collection Version STC00401 E CollectionVersion must match '2020Oct1.0StuCore' CollectionVersion must be '2020Oct1.0StuCore' The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2020Oct1.0StuCore'.
005 Collection Version STC01600 E There must be at least one Student Core record There are no Student Core records There must be at least one Student Core record.
010 Current School Year STC00402 E CurrentSchoolYear must match '2020' CurrentSchoolYear must be '2020' The CurrentSchoolYear identifies the school year for the data. For this collection the CurrentSchoolYear must be '2020'.
015 Attending District Code STC00440 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 STC00601 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 STC00611 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 STC00887 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 STC00441 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 STC00700 E ReportingDistrictCode must match the SRM user's district code. The student is not from this district The student's ReportingDistrictCode does not equal that of the trial.
030 Reporting School Code STC00602 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 STC00612 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 STC00614 E If ReportingDistrictCode is not 048078, 096119 or 115115 then ReportingSchoolCode, AttendingSchoolCode, ResidentSchoolCode cannot begin with 11. ReportingSchoolCode, AttendingSchoolCode, or ResidentSchoolCode should not be reported ReportingSchoolCode, AttendingSchoolCode, or ResidentSchoolCode should not be reported since Area Career Centers do not report enrollment, attendance, or membership.
030 Reporting School Code STC00888 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 STC00442 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.
035 Resident District Code STC05009 E If ResidencyStatus is DI then ResidentDistrictCode must be in (115901, 115902, 115903, 115906, 115115, 115911, 115912, 115913, 115914, 115915, 115916, 115917, 115918, 115919, 115920, 115921, 115922, 096090, 096091, 096092, 096093, 096094, 096095, 096098, 096099, 096101, 096102, 096103, 096106, 096110, 096113, 096114, 096119) ResidencyStatus of DI cannot be reported for ResidentDistrictCode ResidencyStatus of DI can only be reported for districts participating in Desegregation. (115115, 115911, 096090, 096091, 096092, 096093, 096094, 096095, 096098, 096099, 096101, 096102, 096103, 096106, 096110, 096113, 096114, 096119)
040 Resident School Code STC00603 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 STC00613 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 STC00889 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.
050 MOSIS Student ID STC00455 E Student cannot be reported since was reported as a Graduate in prior years. StateID cannot exist in v_DESE_JUNE_SEA matching on StateID where v_DESE_JUNE_SEA.ExitCode in ('G01','G03') and v_DESE_JUNE_SEA.CurrentSchoolYear <>CurrentSchoolYear. StateID cannot be reported StateID ({0}) cannot be reported since the StateID has been reported as a graduate in the year {1} from the district {2} / school {3}.
050 MOSIS Student ID STC00465 W Student cannot be reported since was reported as a Dropout in last year. StateID cannot exist in v_DESE_JUNE_SEA matching on StateID where v_DESE_JUNE_SEA.ExitCode begins with 'D' and v_DESE_JUNE_SEA.CurrentSchoolYear = CurrentSchoolYear - 1. StateID cannot be reported StateID cannot be reported since the StateID has been reported as a dropout in the prior year. StateID ({0}) cannot be reported since the StateID has been reported as a dropout in the prior year {1} from the district {2} / school {3}.
050 MOSIS Student ID STC01001 E State ID verified against ID system SIDMASTER (State_Student_ID) StateID not found in MOSIS ID The State ID was not found in the MOSIS ID system.
050 MOSIS Student ID STC01010 E StateID must be unique across all records in the submission. (No Duplicates allowed) Multiple records with the same StateID The StateID must be unique across all records in the submission. The same StateID was found on more than one record. No Duplicates allowed.
080 Date of Birth STC00446 E DateOfBirth must be a valid date. DateOfBirth is not a valid date The date is not valid. A date must be in MM/DD/YYYY format and be a valid date.
080 Date of Birth STC01020 E Date of Birth verified against ID system (in conjunction with State ID) SIDMASTER (Date_of_Birth) and SIDMASTER (State_Student_ID) DateOfBirth does not match MOSIS ID The date of birth reported does not match the date of birth in the MOSIS ID system.
080 Date of Birth STC01050 W If Age is outside the range for the grade level then a WARNING is given. 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}.
090 County STC00403 E Must be in code set: (County_Codes). Invalid County code County is not a valid County code.
090 County STC01100 E Must be a valid county for resident county district when ResidencyStatus is R1, R2, NR, or FL. Must be a valid county for reporting county district when ResidencyStatus is DI. Ensure the first 3 characters of the ReportingDistrictCode equal the County for ResidenctyStatus of DI. Ensure the 3 characters of the ResidentDistrictCode equal the County for ResidencyStatus is R1, R2, or FL or a county code in v_DESE_ALTERNATE_COUNTY County is not valid for ResidentDistrictCode The student's resident county must be a county served by the resident district.
095 Student Grade Level STC00404 E Must be in code set: (Student_Grade_Level_Codes). Invalid StudentGradeLevel code Student Grade Level must be a valid code in the Student Grade Level Codes.
095 Student Grade Level STC01060 E 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.
095 Student Grade Level STC01061 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.
095 Student Grade Level STC01062 W If StudentGradeLevel = KA then verify record exists in Calendar_Header table where reportingdistrictcode = fk_dist_cnty_dist and currentschoolyear = fk_dist_year and begin_grade = (space K) and end_grade = (space K) and KINDERGARTEN_INDICATOR = A StudentGradeLevel does not exist in Calendar StudentGradeLevel KA does not exist in Core Data Calendar.
095 Student Grade Level STC01063 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.
100 Gender STC00405 E Must be in code set: (Gender_Codes). Gender must be M or F Gender must be M or F.
105 Race/Ethnicity STC00406 E Must be in code set: (Race_Ethnicity_Codes). Invalid RaceEthnicity code RaceEthnicity must be A, B, H, I, W, P or M.
110 Lunch Status STC00407 E Must be in code set: (Lunch_Status_Codes). LunchStatus must be U, F or R LunchStatus must be U, F or R.
115 Gifted STC00408 E Must be in code set: (Gifted_Codes). Gifted must be GS, GN, or NI Gifted must be GS, GN, or NI.
120 Homeless STC00409 E Must be in code set: (Homeless_Codes) Invalid Homeless code Homeless must be NH, SH, SF, SY, SN, US, UF, UY, UN, DU, DF, DY, DN, HM, HF, HY or HN.
125 Migrant STC00410 E Must be in code set: (Migrant_Codes). Invalid Migrant code Migrant must be NM, PS, PN, NP, NN, CA or CR.
130 In building less than a year STC00411 E Must be in code set: (Yes_No). NotFAYSchool must be Y or N NotFAYSchool must be Y or N.
135 In district less than a year STC00412 E Must be in code set: (Yes_No). NotFAYDistrict must be Y or N NotFAYDistrict must be Y or N.
140 Voluntary Transfer Student STC00413 E Must be in code set: (Yes_No). VoluntaryTransfer must be Y or N VoluntaryTransfer must be Y or N.
145 A+ Student STC00414 E Must be in code set: (Aplus_Codes) Invalid Aplus code Aplus must be Y, N or C.
145 A+ Student STC01614 W If stc.APLUS is “Y” then stc.attendingdistrictcode and stc.attendingschoolcode must exist in srm.dbo.dese_attendance_center for the stc.currentschoolyear and the A_PLUS column must contain "N" or 'D'. High School is not designated A+ High School is not designated A+. Student should not be reported as Y unless the High School is a designated A+ High School.
145 A+ Student STC01615 W If stc.APLUS is “C” then stc.attendingdistrictcode and stc.attendingschoolcode must exist in srm.dbo.dese_attendance_center for the stc.currentschoolyear and the A_PLUS column must contain 'D'. High School is not designated A+ High School is not designated A+. Student should not be reported as C unless the High School is a designated A+ High School.
150 Number of Months in USA STC00447 E MonthsUSA must be an integer MonthsUSA has an invalid format MonthsUSA should be an integer that is 1 to 3 digits long.
155 Immigrant STC00415 E Must be in code set: (Immigrant_Codes). Immigrant must be Y, or N Immigrant must be Yes (Y), or No (N).
160 ELL Primary Language STC00416 E Must be in code set: (Language_Codes). Invalid ELLLanguage code ELLLanguage is not a valid language code.
160 ELL Primary Language STC01850 E Primary Language is required if LEP/ELL is RCV or NRC ELLLanguage is required when LEPELL 'RCV' or 'NRC' ELL Primary Language is required if LEP/ELL is 'RCV' or 'NRC'.
165 LEP / ELL STC00417 E Must be in code set: (LEP_Codes). Invalid LEPELL code LEPELL must be a valid code in the LEP Codes.
165 LEP / ELL STC02050 W The count of LEPELL = 'NRC' records should not exceed 10% of the total records. The number of students with LEPELL of NRC is larger than expected The number of students reported as Not Receiving Services (NRC) is larger than expected. Please verify your data.
170 ELL Exit STC02000 W If LEP/ELL is MY1 then ELL Exit is not allowed. ELLExit is not allowed if LEPELL is 'MY1' ELL Exit cannot be reported when the LEP/ELL student is in Monitoring Year 1.
175 ELL Exit Test STC00419 E Must be in code set: (LEP_ELL_Exit_Test_Codes). Invalid ELLExitTest code ELLExitTest must be a valid code in the LEP ELL Exit Test Codes.
180 ESOL Instructional Model STC00420 E Must be in code set: (ESOL_Model_Codes). Invalid ESOLInstModel code ESOLInstModel must be must be a valid code in the ESOL Model codes.
180 ESOL Instructional Model STC02300 E Not allowed unless LEP/Ell = 'RCV' ESOLInstModel is only allowed when LEPELL is RCV ESOL instructional model can only be reported when the student is receiving LEP/ELL services.
180 ESOL Instructional Model STC06605 E ESOL Instructional Model is required if LEP ELL is RCV. ESOL Instructional Model is required when LEP ELL is RCV. ESOL Instructional Model is required when LEP ELL is RCV.
185 Missouri Option Program STC00421 E Must be in code set: (Yes_No). MOOptionProgram must be Y or N MOOptionProgram must be Y or N.
190 H.S. Career Ed student STC00422 E Must be in code set: (HS_CareerED_Codes). Invalid CareerEd code CareerEd must be NHS, LTO, PHS, CHS, or CNP.
195 Title I STC00423 E Must be in code set: (Yes_No). TitleI must be Y or N TitleI must be Y or N.
195 Title I STC02600 W If TitleI equals Y, and grade level is not PK, then attendance center table must contain a T or S in DESE_ATTENDANCE_CENTER (TITLE_1_SCHOOL) Title I cannot be Y for this school Attending School Code is not listed as a Title I targeted assistance building or Title I school-wide building.
195 Title I STC02650 W If attendance center table is marked with S, then all students in the building must have Title I marked Y. ATTENDANCE_CENTER (TITLE_1_SCHOOL) Title I must be Y for this school Title I must be marked 'Y' since Attending School Code is a Title I school-wide attendance center.
200 Title III STC00424 E Must be in code set: (Yes_No). TitleIII must be Y or N TitleIII must be Y or N.
205 Residency Status STC00425 E Must be in code set: (Resident_Status_Codes). Invalid ResidencyStatus code ResidencyStatus must be R1, R2, NR, DI, PT, or FL.
205 Residency Status STC00457 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.
205 Residency Status STC02750 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 student's residency status is resident I (R1) then the reporting, attending, and resident district codes must be the same.
205 Residency Status STC02751 E If ResidencyStatus is 'R1' or 'FL' then ReportingSchoolCode, ResidentSchoolCode, AttendingSchoolCode must be the same value. Invalid school codes for ResidencyStatus R1 or FL When the student's residency status is resident I (R1) or Federal Lands (FL) then the reporting, attending, and resident school codes must be the same.
205 Residency Status STC02800 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.
205 Residency Status STC02801 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.
205 Residency Status STC02802 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.
205 Residency Status STC02850 E "If Residency Status is 'R1', 'FL', 'NR' ,'DI','PT' except (when Residency Status is ‘NR’ and the ELEMENTARY_DISTRICT_ONLY_IND in the DESE_DISTRICT table for the ReportingDistrictCode for the CurrentSchoolYear is “Y” and the AttendingDistrictCode is in v_DESE_APPROVED_NONPUBLIC_DISTRICT for the CurrentSchoolYear). then ReportingDistrictCode and AttendingDistrictCode must be the same value." ResidencyStatus not valid for ReportingDistrictCode and AttendingDistrictCode ResidencyStatus not valid for ReportingDistrictCode and AttendingDistrictCode combination. Attending and Reporting district codes must be the same if ResidencyStatus is R1, FL, NR, DI, or PT.
205 Residency Status STC02875 E If Residency Status is 'NR', 'DI' or ('PT' and StudentGradeLevel in (' K','KA','KP','01','02','03','04','05','06','07','08','09','10','11','12') ) then Resident District Code cannot match Reporting District Code or Attending District Code. Grade is only checked against residencystatus PT the other residencystatus should be checked against all grades. 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.
205 Residency Status STC02900 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.
205 Residency Status STC02925 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.
205 Residency Status STC02930 E If ReportingDistrictCode begins with '0489' or '1159' then ResidencyStatus must be R1, DI, R2, PT, or NR. ResidencyStatus must be R1, R2, DI, PT, or NR ResidencyStatus must be R1, R2, DI, PT, or NR for all charter school students.
205 Residency Status STC02931 E If ResidencyStatus is DI then ReportingDistrictCode must be in (115901, 115902, 115903, 115906,115115, 115911, 115912, 115913, 115914, 115915, 115916, 115917, 115918, 115919, 115920, 115921, 115922, 096090, 096091, 096092, 096093, 096094, 096095, 096098, 096099, 096101, 096102, 096103, 096106, 096110, 096113, 096114, 096119) ResidencyStatus of DI cannot be reported for ReportingDistrictCode ResidencyStatus of DI can only be reported by districts participating in Desegregation. (115901, 115902, 115903, 115906, 115115, 115911, 115912, 115913, 115914, 115915, 115916, 115917, 115918, 115919, 115920, 115921, 115922, 096090, 096091, 096092, 096093, 096094, 096095, 096098, 096099, 096101, 096102, 096103, 096106, 096110, 096113, 096114, 096119)
205 Residency Status STC02932 E If ResidencyStatus is DI and ReportingDistrictCode begins with 096 then ResidentDistrictCode must be 115115. ResidencyStatus of DI must have ResidentDistrictCode of 115115 ResidencyStatus DI must be residents of St. Louis City and have ResidentDistrictCode of 115115.
205 Residency Status STC02933 E If ResidencyStatus is DI and ReportingDistrictCode is 115115 then ResidentDistrictCode must begin with 096. ResidencyStatus of DI must have ResidentDistrictCode beginning with 096 ResidencyStatus DI must be residents of surrounding St. Louis counties and have resident district code beginning with 096.
205 Residency Status STC02934 E If residencyStatus = 'R1', 'FL', 'NR','DI','PT' except (when Residency Status is ‘NR’ and the ELEMENTARY_DISTRICT_ONLY_IND in the DESE_DISTRICT table for the ResidentDistrictCode for the CurrentSchoolYear is “Y” and the AttendingDistrictCode is in v_DESE_APPROVED_NONPUBLIC_ATTNDCTR for the CurrentSchoolYear). 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.
205 Residency Status STC02935 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.
205 Residency Status STC02940 E If ReportingDistrictCode begins with '0489' or '1159' and ResidencyStatus is NR, ResidentDistrictCode must be in DESE_DISTRICT with a CLASSIFICATION of U matching on YEAR and COUNTY_DISTRICT. Residency Status cannot be NR for Resident District Code Resident District Code must be classified as unaccredited to be reported by the Reporting District.
210 Membership FTE STC00443 E MemberFTE does not have a valid format. It must have 1 digit followed by an optional decimal point and 1 or 2 digits. MemberFTE has an invalid format MemberFTE does not have a valid format. It must have 1 digit followed by an optional decimal point and 1 or 2 digits.
210 Membership FTE STC02950 E MemberFTE must be greater than 0 and less than or equal to 1 MemberFTE must be greater than 0 and less than or equal to 1 Membership FTE must be greater than 0 and less than or equal to 1
210 Membership FTE STC03000 E MemberFTE is required when ResidencyStatus is R1, FL, DI, NR, or R2 MemberFTE is required when ResidencyStatus is R1, FL, DI, NR, or R2 Membership FTE is required when the student's residency status is Resident I (R1), Federal Lands (FL), Desegregated Inbound (DI), Non-Resident (NR), or Resident II (R2).
215 One Prior 10 Day Attendance STC00426 E Must be in code set: (Yes_No). OnePriorTen must be Y or N OnePriorTen must be Y or N.
215 One Prior 10 Day Attendance STC03160 E OnePriorTen is required when ResidencyStatus is in (R1,R2,FL,NR,DI) OnePriorTen is required for ResidencyStatus OnePriorTen is required for ResidencyStatus
220 Enrolled On Count Date STC00427 E Must be in code set: (Yes_No). EnrolledOnCntDate must be Y or N EnrolledOnCntDate must be Y or N.
225 Enrolled All Year STC00428 E Must be in code set: (Yes_No). EnrolledAllYear must be Y or N EnrolledAllYear must be Y or N.
225 Enrolled All Year STC03400 E If EnrolledAllYear = 'Y' then ResidencyStatus cannot equal 'R2 ResidencyStatus cannot be R2 when EnrolledAllYear is Y When Enrolled All Year is Y the Residency Status cannot be Resident II (R2).
230 First Year Freshman STC00429 E Must be in code set: (Yes_No). FirstYearFreshman must be Y or N FirstYearFreshman must be Y or N.
230 First Year Freshman STC03501 E FirstYearFreshman is only allowed for grade 09 FirstYearFreshman is only allowed for grade 09 First Year Freshman can only be reported when Student Grade Level is 09.
235 GPA STC00444 E GPA does not have a valid format. It may have 1 or 2 digits followed by an optional decimal point and 1, 2 or 3 digits. GPA has an invalid format GPA does not have a valid format. It may have 1 or 2 digits followed by an optional decimal point and 1, 2 or 3 digits.
235 GPA STC03550 E GPA cannot be lower than 0 or greater than GPAScale + 2. GPA exceeds the GPAScale by more than two GPA does not fall within the expected bounds. When the GPA scale is 4 the GPA can be between 0.000 and 6.000. When the GPA scale is 11 the GPA can be between 0.000 and 13.000.
235 GPA STC03600 W Usually the GPA should not exceed the GPA Scale. The GPA exceeds the typical GPAScale The GPA is outside the normal range. In rare cases the GPA can exceed the GPA scale. Please verify the data is accurate.
240 GPA Scale STC00430 E Must be in code set: (GPAScale_Codes). GPAScale must be 4 or 11 GPAScale must be 4 or 11.
240 GPA Scale STC03750 W GPA Scale should be the same for all students in the same building and grade level. GPAScale is not consistent with group GPA scale should be the same for all students in the same attending district, attending school, and grade level.
240 GPA Scale STC03800 E GPA Scale is required if GPA is not Null GPAScale is required when GPA is not null GPAScale is required when GPA is reported.
245 8th Grade Tech Literacy STC00431 E Must be in code set: (Tested_Codes). EighthTechLit must be T, P, or N EighthTechLit must be T, P, or N.
245 8th Grade Tech Literacy STC03975 W EighthTechLit is not allowed unless StudentGradeLevel is 08 EighthTechLit is only allowed for grade 08 8th grade tech literacy can only be reported when Student Grade Level is 08.
250 Aerobic Capacity STC00432 E Must be in code set: (Physical_Fit_Assessment_Codes) Invalid AerobicCap code AerobicCap must be 'HFR', 'TESTED' or 'NOT TESTED'.
250 Aerobic Capacity STC04075 E AerobicCap is not allowed unless StudentGradeLevel is 05 or 09 AerobicCap is only allowed for grades 05 and 09 Aerobic capacity cannot be reported unless Student Grade Level is 05 or 09.
255 Abdominal Strength STC00433 E Must be in code set: (Physical_Fit_Assessment_Codes). Invalid AbdominalStr code AbdominalStr must be 'HFR', 'TESTED' or 'NOT TESTED'.
255 Abdominal Strength STC04175 E AbdominalStr is not allowed unless StudentGradeLevel is 05 or 09 AbdominalStr is only allowed for grades 05 and 09 Abdominal strength cannot be reported unless Student Grade Level is 05 or 09.
260 Upper Body Strength STC00434 E Must be in code set: (Physical_Fit_Assessment_Codes). Invalid UpperBodyStr code UpperBodyStr must be 'HFR', 'TESTED' or 'NOT TESTED'.
260 Upper Body Strength STC04275 E UpperBodyStr is not allowed unless StudentGradeLevel is 05 or 09 UpperBodyStr is only allowed for grades 05 and 09 Upper body strength cannot be reported unless Student Grade Level is 05 or 09.
265 Flexibility STC00435 E Must be in code set: (Physical_Fit_Assessment_Codes). Invalid Flexibility code Flexibility must be 'HFR', 'TESTED' or 'NOT TESTED'.
265 Flexibility STC04375 E Flexibility cannot be reported unless Student Grade Level is 05 or 09. Flexibility is only allowed for grades 05 and 09 Flexibility cannot be reported unless Student Grade Level is 05 or 09.
270 IEP Disability STC00436 E Must be in code set: (Disability_Codes). Invalid IEPDisability code IEPDisability must be 00, 01, 02, 04, 06, 08, 09, 10, 11, 12, 13, 14, 16, 17 or 18.
270 IEP Disability STC04550 E IEPDisability cannot be '00' when SPEDExit is specified IEPDisability cannot be 00 when SPEDExit is specified IEP Disability code cannot be 00 when there is a SPED Program Exit Code.
270 IEP Disability STC04551 W If STC.IEPDisability is 16 then calculated age cannot be inclusively between 7 and 22 as of 12/1 of the current school year. IEPDisability is not valid for age IEPDisability is not valid for age. IEPDisability of 16 cannot be reported for students over the age of 6 as of December 1 of the current school year.
275 MAP-Alternate STC00437 E Must be in code set: (Yes_No). MAPA must be Y or N MAPA must be Y or N.
280 Special Education Placement STC00438 E Must be in code set: (SPED_Placement_Codes). Invalid SPEDPlacement code SPEDPlacement must be 00A4, 00A5, 00A6, 00A7 00B1, 00B2, 00B3, 00B4, 00B5, 1100, 1201, 1301, 1401, 1402, 1403, 1601, 1701, 1801 or 2100.
280 Special Education Placement STC00456 E IF STC.SPEDPlacement is 1401, then ReportingDistrictCode must be 014400, 115414 or 201201 SPEDPlacement code 1401 can only be used by state operated programs SPEDPlacement code 1401 can only be used by state operated programs (MSB, MSD or MSSD)
280 Special Education Placement STC04570 W If SPEDPlacement code begins with 1 or is 2100 then age as of 12/1 of the current school year should be 5 or above and less than 23 and student grade level cannot be PK, PKA, or PKP. Invalid student age or grade level for SPEDPlacement code The student’s age cannot be less than 5 on 12/1 of the current school year and grade level cannot be PK, PKA, or PKP when the SPEDPlacement code is 2100 or begins with 1.
280 Special Education Placement STC04572 W If SPEDPlacement code is 0, then student age as of 12/1 of the current school year has to be between 2 and 5 (including) and grade level has to be PK, PKA, or PKP. Invalid student age or grade level for SPEDPlacement code The student’s age has to be between 2 and 5 as of 12/1 of the current school year and the grade level has to be PK, PKA, or PKP when the SPEDPlacement code begins with 0.
285 SPED Program Exit Code STC00439 E Must be in code set: (SPED_Program_Exit_Codes). Invalid SPEDExit code SPEDExit must be in code set: (SPED_Program_Exit_Codes).
285 SPED Program Exit Code STC00800 W The student age, as of 12/1 in the current school year, must fall within a range that is based on the SPEDExit value. Refer to the Dev Guide for the age ranges associated with each SPEDExit code. Age is outside the expected range for the SPEDExit code The student age, as of 12/1 of the current school year, must fall within a range that is based on the SPEDExit value. Birth dates for students with SPEDExit of {0} are expected to fall between {2} and {3}.
286 Truant STC00450 E Must be in code set: (Yes/No) Invalid Truant code Truant must be Y or N.
288 Supplemental Education Service STC00448 E Must be in code set: (Supple_ED_Services_Codes) Invalid SuppEdService code SuppEdService must be A, E, O or R.
290 Career Cluster STC00449 E Must be in code set: (CTE_Cluster_Codes) Invalid CTECluster code CTECluster must be 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14, 15 or 16.
292 Nontraditional Student (Secondary) STC00451 E Must be in code set: (Yes/No) Invalid NonTradStudent code NonTradStudent must be Y or N.
292 Nontraditional Student (Secondary) STC00642 E If NonTradStudent is Y and Gender does not match NONTRADITIONAL_GENDER in the dese_dc_program_type table for the year and CTE_program_type NonTradStudent code is not valid NonTradStudent code is not valid since the Gender reported is the traditional gender expected.
294 Single Parent (Secondary) STC00452 E Must be in code set: (Yes/No) Invalid SingleParent code SingleParent must be Y or N.
296 Displaced Homemaker (Secondary) STC00453 E Must be in code set: (Yes/No) Invalid DisplacedHomemaker code DisplacedHomemaker must be Y or N.
298 CTE Technical Skills Attainment STC05003 E Must be in code set (CTE_TSA_Testing_Codes) Invalid CTETSA code CTETSA must be one of PT (Passed Test), FT (Failed Test), NT (Not Tested), NA (Not Available), NE (Not Eligible), or PR (Pending Results).
300 K-8 Graduate District Code STC05007 E Must be in code set (K-8District Codes) Which is the DESE_DISTRICT table with ELEMENTARY_DISTRICT_ONLY_IND marked as Y for the current school year. Invalid K8GradDistrictCode code K8GradDistrictCode is not a valid district code.
302 ECO Entry Date STC00615 E ECOEntryDate must be a valid date. ECOEntryDate is not a valid date The date is not valid. A date must be in MM/DD/YYYY format and be a valid date.
302 ECO Entry Date STC00617 W Valid date for the current school year. (Date must be on or after July 1) ECOEntryDate must be in current school year The student's entry date must be a valid date within the current school year. ECOEntryDate must be in the current school year. The school year begins on {0} and ends on {1}.
302 ECO Entry Date STC00619 E ECOEntryDate must be on or before the ECOExitDate. ECOEntryDate is after ECOExitDate ECOEntryDate must be prior to ECOExitDate or the same as the ECOExitDate.
304 ECO Entry Indicator 1 STC00620 E Must be in code set: (ECO_Indicator_Codes). Invalid ECO Indicator code ECOEntryInd1 must be 1, 2, 3, 4, or 5.
304 ECO Entry Indicator 1 STC00626 E ECOEntryInd1 is required if ECOEntryDate is not null ECOEntryInd1 is required ECOEntryInd1 is required since ECOEntryDate has been provided.
306 ECO Entry Indicator 2 STC00621 E Must be in code set: (ECO_Indicator_Codes). Invalid ECO Indicator code ECOEntryInd2 must be 1, 2, 3, 4, or 5.
306 ECO Entry Indicator 2 STC00627 E ECOEntryInd2 is required if ECOEntryDate is not null ECOEntryInd2 is required ECOEntryInd2 is required since ECOEntryDate has been provided.
308 ECO Entry Indicator 3 STC00622 E Must be in code set: (ECO_Indicator_Codes). Invalid ECO Indicator code ECOEntryInd3 must be 1, 2, 3, 4, or 5.
308 ECO Entry Indicator 3 STC00628 E ECOEntryInd3 is required if ECOEntryDate is not null ECOEntryInd3 is required ECOEntryInd3 is required since ECOEntryDate has been provided.
310 ECO Exit Date STC00616 E ECOExitDate must be a valid date. ECOExitDate is not a valid date The date is not valid. A date must be in MM/DD/YYYY format and be a valid date.
310 ECO Exit Date STC00618 W Valid date for the current school year. Date must be on or prior to June 30 ECOExitDate must be in current school year ECOExitDate must be in the current school year. The school year begins on {0} and ends on {1}.
312 ECO Exit Indicator 1 STC00623 E Must be in code set: (ECO_Indicator_Codes). Invalid ECO Indicator code ECOExitInd1 must be 1, 2, 3, 4, or 5.
312 ECO Exit Indicator 1 STC00629 E ECOExitInd1 is required if ECOExitDate is not null ECOExitInd1 is required ECOExitInd1 is required since ECOExitDate has been provided.
314 ECO Exit Indicator 2 STC00624 E Must be in code set: (ECO_Indicator_Codes). Invalid ECO Indicator code ECOExitInd2 must be 1, 2, 3, 4, or 5.
314 ECO Exit Indicator 2 STC00630 E ECOExitInd2 is required if ECOExitDate is not null ECOExitInd2 is required ECOExitInd2 is required since ECOExitDate has been provided.
316 ECO Exit Indicator 3 STC00625 E Must be in code set: (ECO_Indicator_Codes). Invalid ECO Indicator code ECOExitInd3 must be 1, 2, 3, 4, or 5.
316 ECO Exit Indicator 3 STC00631 E ECOExitInd3 is required if ECOExitDate is not null ECOExitInd3 is required ECOExitInd3 is required since ECOExitDate has been provided.
318 CTE Program Code STC00632 E Must be in code set: (CTE_Program_Codes) Invalid CTEProgramCode code CTEProgramCode is not a valid code.
318 CTE Program Code STC00641 E If CTEProgramCode is not null then it must be 0104, 0204, 0304, 0404, 0504, 0604, 0704, 0804 or 1004. Invalid CTEProgramCode code for Secondary Education. Invalid CTEProgramCode code for Secondary Education. CTEProgram Code must be 0104, 0204, 0304, 0404, 0504, 0604, 0704, 0804 or 1004.
320 Title III LEP STC00637 E Must be in code set: (Title_3_Fund_Codes) Title3LEP must be TF, NF, or NE. Title3LEP must be Title III Funded (TF), Not Funded (NF), or Not Eligible (NE).
320 Title III LEP STC00639 E Title3LEP is required if LEPELL is RCV Title3LEP is required Title3LEP is required since LEPELL is RCV.
321 Title III Immigrant STC00638 E Must be in code set: (Title_3_Fund_Codes) Title3Immigrant must be TF, NF, or NE. Title3Immigrant must be Title III Funded (TF), Not Funded (NF), or Not Eligible (NE).
321 Title III Immigrant STC00640 E Title3Immigrant is required if Immigrant is Y. Title3Immigrant is required Title3Immigrant is required since Immigrant is Y.
322 First Freshman Year STC00647 E FirstFreshmanYear is required to be less than or equal to the currentschoolyear and greater than or equal to the currentschoolyear-6. First Freshman Year is invalid First Freshman Year is invalid since year reported occurs too far in the past.
322 First Freshman Year STC00648 E FirstFreshmanYear must be a four digit year. First Freshman Year must be a four digit year First Freshman Year must be a four digit year.
323 Zip Code STC04000 E Zip Code must be 5 or 9 digits. Zip Code must be 5 or 9 digits Zip Codes are specified as 5 or 9 digits.
324 Industry Recognized Credential STC00655 E IndustryCred is not allowed in the October Cycle Student Core Submission. IndustryCred is not allowed IndustryCred is not allowed in the October Cycle Student Core Submission.
325 Military STC05900 E Must be in code set: (Military_Codes). Invalid Military code Military must be NM, AD, NGR, or UNK.
326 MPP STC06000 E Must be in code set: (Yes_No). Invalid MPP code Missouri Preschool Program (MPP) must be Y or N.
326 MPP STC06100 E If MPP is Y, reportingdistrictcode must be in DESE_APPROVED_MPP_DISTRICT matching on year and cnty_dist_code. Reporting District Code is not an approved MPP District Reporting District Code must be an approved Missouri Preschool Program (MPP) District.
326 MPP STC06200 E If MPP is Y, studentgradelevel must be PK. Student Grade Level is invalid for MPP Student Grade Level must be PK if Missouri Preschool Program (MPP) is Yes.
326 MPP STC06300 E MPP is required if StudentGradeLevel is PK and reportingdistrictcode is in DESE_APPROVED_MPP_DISTRICT matching on year and cnty_dist_code. MPP is required Missouri Preschool Program (MPP) is required for PK students.
327 Foster Care STC06350 E Must be in code set: (Yes_No). Invalid Foster Care code Foster Care must be Y or N.
328 PK Eligible State Aid STC06400 E If PKEligStateAid is marked Y, studentgradelevel must be PK, PKA, or PKP and calculated age must be at least 3 as of 8/1 of the current school year.  Student Grade Level or age is invalid for PK Eligible State Aid Student Grade Level must be PK, PKA, or PKP and calculated age must be at least 3 as of 8/1 of the current school year when PK Eligible State Aid is Y. 
328 PK Eligible State Aid STC06401 E If PKEligStateAid is Y, LunchStatus must be F or R. Lunch Status is invalid for PK Eligible State Aid Lunch Status must be F or R when PK Eligible State Aid is Y.
328 PK Eligible State Aid STC06402 W In DC_PKMAX_SA_DISTRICT_FREE_REDUCED_LUNCH for currentschoolyear = FK_DIST_YEAR, and reportingdistrictcode = FK_DIST_CNTY_DIST, the value in TOTAL_NUMBER_PK_STUDENTS_ELIG_FOR_STATE_ID must be greater than or equal to the count of PKEligStateAid equal to Y. (This table is calculating the result of the count of records of lunchstatus in ('F','R'), and enrolledoncountdate = Y, and residencystatus in ('R1', 'R2'), and studentgradelevel in (K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) and calculated age is 18 (included) or less as of 10/1 for current school year multiplied by 4%.) PK Eligible State Aid is invalid PK Eligible State Aid is reported for more than 4% of eligible students.
328 PK Eligible State Aid STC06403 W In DESE_SFIN_WEIGHTED_ADA for currentschoolyear = YEAR, and reportingdistrictcode = COUNTY_DISTRICT, and CEP_PRIOR_YEAR_PERCENT  is greater than '0' the count of PKEligStateAid equal to Y cannot be greater than the result of CEP_PRIOR_YEAR_PERCENT in DESE_SFIN_WEIGHTED_ADA multiplied by count of enrolledoncountdate = Y, and residencystatus in ('R1', 'R2'), and studentgradelevel in (K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) and calculated age is 18 (included) or less as of 10/1 for current school year multiplied by 4%. PK Eligible State Aid is invalid PK Eligible State Aid is reported for more than 4% of eligible students.
328 PK Eligible State Aid STC06405 E Must be in code set: (Yes_No). PKEligStateAid must be Y or N PKEligStateAid must be Y or N.
329 Kindergarten Readiness STC06500 E Must be in code set: (Yes_No). KindergartenReadiness must be Y or N KindergartenReadiness must be Y or N.
329 Kindergarten Readiness STC06501 E KindergartenReadiness is required if StudentGradeLevel is K. Kindergarten Readiness is required when Student Grade Level is K Kindergarten Readiness is required when Student Grade Level is K.
330 High Need Student STC06520 E High Need Student is not allowed in the October Cycle Student Core submission. High Need Student is not allowed High Need Student is not allowed in the October Cycle Student Core submission.
331 Dyslexia STC06510 E Must be in code set: (Dyslexia_Codes). The dyslexia code reported is not a valid code Dyslexia must be a valid code from the Dyslexia Code Set.
332 Neglected or Delinquent STC06550 E Must be in code set: (Neglected_or_Delinquent_Codes). The Neglected or Delinquent code reported is not a valid code Neglected or Delinquent must be a valid code from the Neglected or Delinquent Code Set.
333 CTE Certificate STC06610 E Must be in code set: (Yes_No). CTECertificate must be Y or N CTE Certificate must be Y or N.