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 '2022Jun1.0StuCore' |
CollectionVersion must be '2022Jun1.0StuCore' |
The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2022Jun1.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. |
|
005 |
Collection Version |
STC03410 |
W |
There must be a certified version of the current SY February Student Core |
No Certified February Student Core was found |
Some rules check the consistency of data submitted against data certified in prior submissions. We were not able to find a certified February Student Core for the current school year. |
|
005 |
Collection Version |
STC03420 |
W |
There must be a certified version of the current SY October Student Core |
No Certified October Student Core was found |
Some rules check the consistency of data submitted against data certified in prior submissions. We were not able to find a certified October Student Core for the current school year. |
|
010 |
Current School Year |
STC00402 |
E |
CurrentSchoolYear must match '2022' |
CurrentSchoolYear must be '2022' |
The CurrentSchoolYear identifies the school year for the data. For this collection the CurrentSchoolYear must be '2022'. |
|
015 |
Attending District Code |
STC00440 |
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 |
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 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 |
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 v_DESE_DISTRICT_PUB_HIGH_STATE matching the current school year. |
Invalid ResidentDistrictCode code |
ResidentDistrictCode is not a valid district code. |
|
035 |
Resident District Code |
STC05009 |
E |
If ResidencyStatus is DI then ResidentDistrictCode must exist in table DESE_ CV2_CODE_VALUE where DESE_ CV2_CODE_VALUE.FK_CV2_CODE_TYPCODE_TYPE = DESEGIN and DESE_ CV2_CODE_VALUE.CODE = ResidentDistrictCode. |
ResidencyStatus of DI cannot be reported for ResidentDistrictCode |
ResidencyStatus of DI can only be reported for districts participating in Desegregation. |
|
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 |
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 matching on county district and year. |
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. |
|
095 |
Student Grade Level |
STC01064 |
W |
Check June Student Enrollment Attendance and locate latest ExitDate for each StateID. If the exit code of the SEA record doesn’t begin with G, find the record matching ReportingDistrictCode and StateID in the June Student Core and make sure StudentGradeLevel matches. |
The Student Core StudentGradeLevel does not match the Student’s StudentGradeLevel in the Enrollment Attendance record with the latest exit. |
Student’s Grade Level in the Student Core does not match the Student Enrollment Attendance Student Grade Level. |
|
095 |
Student Grade Level |
STC01065 |
E |
Check June Student Enrollment and Attendance and locate all exit codes beginning with G. Matching on ReportingDistrictCode a record must exist in the Student Core file with a matching StateID and StudentGradeLevel. This rule is ensuring that a student who exited the year as a graduate has a matching grade level between the Student Core and Student Enrollment Attendance files. |
The Student Core StudentGradeLevel does not match the Student Enrollment Attendance StudentGradeLevel with the exit of Graduated. |
Student was reported as ending the year as Graduated and therefore must be reported with a matching Student Grade Level in the Student Core and Student Enrollment Attendance files. |
|
095 |
Student Grade Level |
STC01066 |
E |
If IndustryCred is not null then StudentGradeLevel must be in (10, 11,12). |
Unexpected StudentGradeLevel for IndustryCred |
StudentGradeLevel must be 10, 11, or 12 when IndustryCred is reported. |
|
095 |
Student Grade Level |
STC01070 |
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. |
|
095 |
Student Grade Level |
STC01071 |
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. |
|
095 |
Student Grade Level |
STC05013 |
E |
If StudentGradeLevel in (' K', '01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12') and ResidencyStatus in ('R1', 'R2', 'PT', 'NR', 'DI') then at least 1 matching record should exist in Student Enrollment and Attendance file. Matching on StateId. |
Student must have Student Enrollment and Attendance Record |
Student's StudentGradeLevel and ResidencyStatus indicate student should have an Student Enrollment and Attendance record. |
|
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. |
|
110 |
Lunch Status |
STC01400 |
W |
Lunch status is 'U' for all students. If all records in the file are 'U' for lunch status this warning should be given. |
Free or Reduced Lunch expected |
Lunch Status is 'U' for all records. Free or Reduced lunch is expected for one or more records. |
|
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. |
|
125 |
Migrant |
STC00459 |
W |
If Migrant is PS, PN, NP, NN, or CR then current school year should match one of the following: CD_CSCHYEAR or CD_CSCHYEAR1 or CD_CSCHYEAR2 or CD_CSCHYEAR3 field in the Migrant_COE table (SQL) and StateID should match MOSIS_ID in the Migrant_COE table. |
Student is not eligible for Migrant Services |
Student is not eligible for Migrant Services. |
|
125 |
Migrant |
STC00460 |
W |
If Migrant is CA then the current school year should be minus one in the CD_CSCHYEAR or CD_CSCHYEAR1 or CD_CSCHYEAR2 or CD_CSCHYEAR3 field in the Migrant_COE table (SQL) and StateID should match MOSIS_ID in the Migrant_COE table. |
Student is not eligible for Migrant Services |
Student is not eligible for Migrant Services, contact the Department at 573-751-3543 to resolve. |
|
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. |
|
140 |
Voluntary Transfer Student |
STC01500 |
W |
If VoluntaryTransfer equals Y then the Reporting County District Code should begin with '096' or '96' or '115'. |
Reporting District Code cannot have Voluntary Transfer Student |
Voluntary Transfer cannot be 'Y' unless the student is in a St. Louis County or the St. Louis City school district (ReportingDistrictCode starts with '096' or '115'). |
|
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 |
STC01610 |
E |
Aplus is required when Student Grade Level is ''09'', ''10'', ''11'' or ''12''. |
Aplus is required for grades 09 - 12 |
Aplus is required when Student Grade Level is 09, 10, 11 or 12. |
|
145 |
A+ Student |
STC01614 |
E |
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 |
E |
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. |
|
145 |
A+ Student |
STC05012 |
E |
If APLUS is 'C' in the Student Core then the exitcode with the latest exit date (the final exit for the year) for the student must be 'G01' or 'G03'. |
APLUS completers must graduate |
APLUS completers must graduate. This student must have a record in the Student Enrollment and Attendance file with an exit code of G01 or G03. |
|
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. |
|
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. |
|
175 |
ELL Exit Test |
STC06600 |
E |
ELL Exit Test is required if LEP ELL is RCV. |
ELL Exit Test is required when LEP ELL is RCV. |
ELL Exit Test is required when LEP ELL is RCV. |
|
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. |
|
185 |
Missouri Option Program |
STC02400 |
E |
Value is required if StudentGradeLevel is 11, or 12. |
MOOptionProgram is required for grades 11, and 12 |
Missouri Option Program must be reported when Student Grade Level is 11, or 12. |
|
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. |
|
190 |
H.S. Career Ed Student |
STC02505 |
E |
Value is required if StudentGradeLevel is 09, 10, 11, 12. |
CareerEd is required for grades 09 - 12 |
H.S. Career Ed student is required if Student Grade Level is between '09' and '12'. |
|
190 |
H.S. Career Ed Student |
STC02506 |
E |
CareerEd cannot be NHS if CareerEd was LTO, PHS, or PTP and StudentGradeLevel was 09, 10, 11, 12 for the student in the district's prior year June Student Core matching on reportingdistrictcode and stateid. |
CareerEd cannot be NHS |
CareerEd cannot be NHS since student was reported last June as a career education student. |
|
190 |
H.S. Career Ed Student |
STC02507 |
E |
CareerEd must begin with C if CareerEd began with C and StudentGradeLevel was 09, 10, 11, 12 for the student in the district's prior year June Student Core matching on reportingdistrictcode and stateid. |
CareerEd must begin with C |
CareerEd must begin with C indication the student is a concentrator since student was reported last June as a career education concentrator. |
|
190 |
H.S. Career Ed Student |
STC02508 |
E |
CareerEd cannot be NHS if CTEProgramCode is not null. |
CareerEd cannot be NHS |
CareerEd cannot be NHS since student was reported with a CTE Program Code. |
|
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 DESE_ CV2_CODE_VALUE where DESE_ CV2_CODE_VALUE.FK_CV2_CODE_TYPCODE_TYPE = DESEGIN and DESE_ CV2_CODE_VALUE.CODE = ReportingDistrictCode. |
ResidencyStatus of DI cannot be reported for ReportingDistrictCode |
ResidencyStatus of DI can only be reported by districts participating in Desegregation. |
|
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 |
STC02936 |
W |
Student's June STC ResidencyStatus should exist in June SEA file in at least 1 segment for the ReportingDistrictCode for the same CurrentSchoolYear. |
Student's June Student Core ResidencyStatus does not match June Student Enrollment and Attendance |
Student's June Student Core ResidencyStatus does not match June Student Enrollment and Attendance. At least 1 enrollment segment should match the ResidencyStatus reported for the student in the June Student Core. |
|
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, or R2 |
MemberFTE is required when ResidencyStatus is R1, FL, DI, or R2 |
Membership FTE is required when the student's residency status is Resident I (R1), Federal Lands (FL), Desegregated Inbound (DI), or Resident II (R2). |
|
215 |
One Prior 10 Day Attendance |
STC00101 |
E |
OnePriorTen is not allowed |
OnePriorTen is not allowed |
OnePriorTen is not allowed in the June Core, Enrollment and Attendance Cycle Submission. |
|
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. |
|
220 |
Enrolled On Count Date |
STC00102 |
E |
EnrolledOnCntDate must be null in June. |
EnrolledOnCntDate is not allowed |
EnrolledOnCntDate is not allowed in the June Core, Enrollment and Attendance Cycle Submission. |
|
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 or 'HS'. |
ResidencyStatus cannot be R2 when EnrolledAllYear is Y |
When Enrolled All Year is Y the Residency Status cannot be Resident II (R2). |
|
225 |
Enrolled All Year |
STC03412 |
E |
In the June Student Core for each record marked with enrolled all year as 'Y' and StudentGradeLevel is not 12, check the February Student Core submissions for that same school year and ensure the state id exists and that enrolled on count data is 'Y'. |
EnrolledAllYear student is not marked as EnrolledOnCntDate in the February Student Core |
EnrolledAllYear student is not marked as EnrolledOnCntDate. If student was enrolled all year verify student was enrolled on the count date in February and update the student in the February Student Core. |
|
225 |
Enrolled All Year |
STC03422 |
E |
In the June Student Core for each record marked with enrolled all year as 'Y', check the October Student Core submissions for that same school year and ensure the state id exists and that enrolled on count data is 'Y'. |
EnrolledAllYear student is not marked as EnrolledOnCntDate in the October Student Core |
EnrolledAllYear student is not marked as EnrolledOnCntDate. If student was enrolled all year verify student was enrolled on the count date in October and update the student in the October Student Core. |
|
225 |
Enrolled All Year |
STC03423 |
W |
In the June Student Core for each record marked with enrolled all year as 'Y' and Student Grade Level is 12, check the February Student Core submissions for that same school year and ensure the state id exists and that enrolled on count date is 'Y'. |
EnrolledAllYear student (grade 12) is not marked as EnrolledOnCntDate in the February Student Core |
EnrolledAllYear student (grade 12) is not marked as EnrolledOnCntDate in the February Student Core. Student should not be marked as enrolled all year unless was an early graduate who graduated before the January count date. |
|
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. |
|
235 |
GPA |
STC03650 |
E |
GPA is required if StudentGradeLevel = '09' or '10' and IEPDisability = 00 or Null and Sum(SEA.RegHrsAttended) across the students enrollment and attendance records is greater than or equal to 500 else null is allowed. |
GPA is required for grades 09 and 10 |
GPA is required when Student Grade Level is 09 or 10. |
|
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 |
STC04050 |
E |
AerobicCap is required if StudentGradeLevel is 05, 07, or 09 |
AerobicCap is required for grades 05, 07, and 09 |
AerobicCap is required when Student Grade Level is 05, 07, or 09. |
|
250 |
Aerobic Capacity |
STC04075 |
E |
AerobicCap is not allowed unless StudentGradeLevel is 05, 07, or 09 |
AerobicCap is only allowed for grades 05, 07, and 09 |
Aerobic capacity cannot be reported unless Student Grade Level is 05, 07, 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 |
STC04150 |
E |
AbdominalStr is required if StudentGradeLevel is 05, 07, or 09 |
AbdominalStr is required for grades 05, 07, and 09 |
AbdominalStr is required when Student Grade Level is 05, 07, or 09. |
|
255 |
Abdominal Strength |
STC04175 |
E |
AbdominalStr is not allowed unless StudentGradeLevel is 05, 07, or 09 |
AbdominalStr is only allowed for grades 05, 07, and 09 |
Abdominal strength cannot be reported unless Student Grade Level is 05, 07, 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 |
STC04250 |
E |
UpperBodyStr is required if StudentGradeLevel is 05, 07, or 09 |
UpperBodyStr is required for grades 05, 07, and 09 |
UpperBodyStr is required when Student Grade Level is 05, 07, or 09. |
|
260 |
Upper Body Strength |
STC04275 |
E |
UpperBodyStr is not allowed unless StudentGradeLevel is 05, 07, or 09 |
UpperBodyStr is only allowed for grades 05, 07, and 09 |
Upper body strength cannot be reported unless Student Grade Level is 05, 07, 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 |
STC04350 |
E |
Flexibility is required if StudentGradeLevel is 05, 07, or 09 |
Flexibility is required for grades 05, 07, and 09 |
Flexibility is required when Student Grade Level is 05, 07, or 09. |
|
265 |
Flexibility |
STC04375 |
E |
Flexibility cannot be reported unless Student Grade Level is 05, 07, or 09. |
Flexibility is only allowed for grades 05, 07, and 09 |
Flexibility cannot be reported unless Student Grade Level is 05, 07, 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 |
E |
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 |
STC00604 |
W |
If STC.SPEDExit = 02 then an SEA.ExitCode for the StateID must exist with G01 or G03. |
SPEDExit does not match ExitCode |
SPEDExit indicates student graduated, but matching ExitCode (G01, G03) was not found. |
|
285 |
SPED Program Exit Code |
STC00605 |
W |
If STC.SPEDExit = 03 then an SEA.ExitCode for the StateID must exist with D03. |
SPEDExit does not match ExitCode |
SPEDExit indicates student dropped out (Received Certification), but matching ExitCode (D03) was not found. |
|
285 |
SPED Program Exit Code |
STC00606 |
W |
If STC.SPEDExit = 04 then an SEA.ExitCode for the StateID must exist with D04. |
SPEDExit does not match ExitCode |
SPEDExit indicates student dropped out (Reached Max Age),but matching ExitCode (D04) was not found. |
|
285 |
SPED Program Exit Code |
STC00607 |
W |
If STC.SPEDExit = 05 then an SEA.ExitCode for the StateID must exist withT009. |
SPEDExit does not match ExitCode |
SPEDExit indicates student died, but matching ExitCode (T009) was not found. |
|
285 |
SPED Program Exit Code |
STC00608 |
W |
If STC.SPEDExit = 06 then an SEA.ExitCode for the StateID must exist with T001, T002, T003, T004, T005, T006, T007, T008, or T000. |
SPEDExit does not match ExitCode |
SPEDExit indicates student moved, but matching ExitCode (T001, T002, T003, T004, T005, T006, T007, T008, or T000) was not found. |
|
285 |
SPED Program Exit Code |
STC00609 |
W |
If STC.SPEDExit = 07 then an SEA.ExitCode for the StateID must exist with D06. |
SPEDExit does not match ExitCode |
SPEDExit indicates student dropped out, but matching ExitCode (D06) was not found. |
|
285 |
SPED Program Exit Code |
STC00610 |
W |
If STC.SPEDExit = 08 then an SEA.ExitCode for the StateID must exist with D01, D02, or D05. |
SPEDExit does not match ExitCode |
SPEDExit indicates student dropped out, but matching ExitCode (D01, D02, D05) was not found. |
|
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. |
|
286 |
Truant |
STC05500 |
W |
Truant is required if StudentGradeLevel is in ( K, KA, KP, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12) |
Truant is required for StudentGradeLevel |
Truant is required since StudentGradeLevel is in (K, KA, KP, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12). Truant is a recent field added to the June Student Core. DESE strongly encourages all districts to report truancy status for all students grades |
|
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. |
|
288 |
Supplemental Education Service |
STC05002 |
E |
If SuppEdService is specified then Title I must be Y or (LunchStatus must be F or R). |
SuppEdService is not allowed |
SuppEdService can only be reported for Title I students or students eligible for free or reduced lunch. |
|
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. |
|
290 |
Career Cluster |
STC05100 |
E |
CTECluster is required if CareerED is in (PHS, CHS, or CNP) |
CTECluster should be reported for CareerED |
CTECluster should be reported since CareerED is in (PHS, CHS, or CNP) |
|
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. |
|
292 |
Nontraditional Student (Secondary) |
STC00643 |
E |
If NonTradStudent is N and Gender matches 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. |
|
292 |
Nontraditional Student (Secondary) |
STC05200 |
E |
NonTradStudent is required if CareerED is in (PHS, CHS, CNP) |
NonTradStudent should be reported for CareerED |
NonTradStudent is required since CareerED is in (PHS, CHS, CNP) |
|
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. |
|
300 |
K-8 Graduate District Code |
STC05008 |
W |
K8GradDistrictCode is required if StudentGradeLevel is 09 or 10 and ResidencyStatus is NR and ResidentDistrictCode is in codeset (K-8District Codes) K-8District Codes is the DESE_DISTRICT table with ELEMENTARY_DISTRICT_ONLY_IND marked as Y for the current school year. |
K8GradDistrictCode is expected |
K8GradDistrictCode is expected since student is in grade 09 or 10 and residency status is non-resident and the resident district code is a K-8 district. |
|
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 |
STC00633 |
E |
CTEProgramCode is required if CareerEd is PHS, PTP, CHS, CNP, CTP, CNT, or LTO. |
CTEProgramCode is required |
CTEProgramCode is required since CareerEd is one of PHS, PTP, CHS, CNP, CTP, CNT, or LTO. |
|
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. |
|
318 |
CTE Program Code |
STC00645 |
E |
CTEProgamCode must match the appropriate CTECluster in the dese_dc_program_type table for the year |
CTEProgramCode is not valid for CTE Cluster reported |
CTEProgramCode is not valid for the CTECluster reported |
|
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 |
W |
Title3Immigrant is required if Immigrant is Y. |
Title3Immigrant is required |
Title3Immigrant is required since Immigrant is Y. |
|
322 |
First Freshman Year |
STC00646 |
E |
If the STC.Studentgradelevel in ('09','10','11','12') and STC.STATEID does not exist in DESE_STUDENT_COHORT then STC.FirstFreshmanYear is required. |
First Freshman Year is required. |
First Freshman Year is required for students in grades 9,10,11,12 who were not previously enrolled in a Missouri public school district |
|
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 |
STC00650 |
E |
IndustryCred must match a valid Industry Recognized Credential Code in DESE_Industry_Cred_Codes where CurrentSchoolYear = YEAR. |
Invalid IndustryCred code |
Industry Recognized Credential is not a valid code. |
|
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 |
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. |
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. |
|
330 |
High Need Student |
STC06525 |
E |
Must be in code set: (Yes_No). |
Invalid High Need Student code |
High Need Student must be reported with Y or N. |
|
330 |
High Need Student |
STC06535 |
E |
If HighNeedStudent is Y, StudentGradeLevel cannot be PK, PKA, or PKP. |
Student Grade Level is not valid for High Need Student code |
High Need Student must be reported with students in grades K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, or 12. |
|
330 |
High Need Student |
STC06540 |
E |
If HighNeedStudent is Y, IEPDisability cannot be 00. |
High Need Student must have an IEP Disability that is not 00 |
High Need Student must be reported with an IEP Disability that is not 00. |
|
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. |
|
331 |
Dyslexia |
STC06515 |
E |
Dyslexia is required if StudentGradeLevel is K, 1, 2, or 3. |
Dyslexia is required when Student Grade Level is K, 1, 2, or 3 |
Dyslexia is required when Student Grade Level is K, 1, 2, or 3. |
|
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. |
|
333 |
CTE Certificate |
STC06615 |
E |
CTECertificate is required when CareerEd equals CHS, or CNP and current year June SEA Exit Code begins with 'G'. |
CTECertificate is required |
CTE Certificate is required when student is a Career Ed Concentrator and a graduate. |
|
333 |
CTE Certificate |
STC06620 |
E |
CTECertificate cannot be reported unless CareerEd equals CHS, or CNP and current year June SEA Exit Code begins with 'G'. |
CTECertificate is not allowed to be reported |
CTE Certificate should only be reported when student is a Career Ed Concentrator and a graduate. |
|
334 |
Instruction Method |
STC06630 |
E |
Must be in code set: (Instruction_Method_Codes). |
Invalid Instruction Method code |
Instruction Method must be a valid code in the Instruction Method Codes. |
|
335 |
Internet Access |
STC06635 |
E |
Must be in code set: (Yes_No_Unknown_Codes). |
Invalid Internet Access code |
Internet Access must be Y, N, or U. |
|
336 |
Device Access |
STC06640 |
E |
Must be in code set: (Yes_No_Unknown_Codes). |
Invalid Device Access code |
Device Access must be Y, N, or U. |
|
337 |
PK Replacement ID |
STC06406 |
E |
PKReplacementID verified against ID system SIDMASTER (State_Student_ID) |
PK Replacement ID not found in MOSIS ID |
The PK Replacement ID was not found in the MOSIS ID system. |
|
337 |
PK Replacement ID |
STC06410 |
E |
If PKReplacementID is not null, StudentGradeLevel must be PK, PKA, or PKP. |
PK Replacement ID is only allowed for student grade level of PK, PKA, or PKP |
PK Replacement ID is only reported for students in grade levels PK, PKA, or PKP. |
|
337 |
PK Replacement ID |
STC06415 |
W |
Student replacing another for “PK Eligible State Aid” should not have an overlapping enrollment with the replacing student based on the June SEA enrollment information. For example: Student A, State ID 999999999 was enrolled August 24 to October 31 and was marked as being claimed for state aid. Student B, State ID 888888888 was enrolled November 15 till May 15 and was marked as being claimed for state aid and in the new field had the ID of 999999999 indicating they were replacing Student A’s spot in the 4%. Edit would flag if Student B’s enrollment dates overlapped Student A’s enrollment dates. Edit should show both students' IDs so it can be determined which students overlapped. |
Student has an overlapping enrollment with his replacement for “PK Eligible State Aid” |
Student has an overlapping enrollment with his replacement for “PK Eligible State Aid”. |
|
337 |
PK Replacement ID |
STC06420 |
W |
The sum of Total hours for attendance and absents for a student and all the related replacements should not exceed the highest allowed for the year. For example: Student A, State ID 999999999 was enrolled August 24 to October 31 and was marked as being claimed for state aid. Student B, State ID 888888888 was enrolled November 15 till February 15 and was marked as being claimed for state aid and in the new field had the ID of 999999999 indicating they were replacing Student A’s spot in the 4%. Student C, State ID 777777777 was enrolled February 20 to May 15 and was marked as being claimed for state aid and in the new field had the ID of 777777777 indicating they were replacing Student B’s spot in the 4%. Edit would flag if the total attendance hours of Student A, B, and C exceeded the highest calendar allowed for Student A, B, or C (meaning Student A’s calendar was 1,044, Student B’s calendar was 1,054, Student C’s Calendar was 1,060, then the total attendance hours and total absents hours exceeds 1,060 because that was the highest calendar that applied to each student). |
The sum of Total hours for attendance and absents for a student and all the related replacements exceeds the highest allowed for the year |
The sum of Total hours for attendance and absents for a student and all the related replacements exceeds the highest allowed for the year. |
|
338 |
Stackable Credential 1 |
STC06651 |
E |
StackCred1 must match a valid Stackable Credential Code in DESE_Stackable_Cred_Codes where YEAR = CurrentSchoolyear. |
Invalid StackCred1 code |
Stackable Credential 1 is not a valid code. |
|
338 |
Stackable Credential 1 |
STC06660 |
E |
If StackCred1 is not null then StudentGradeLevel must be in (09, 10, 11,12). |
Unexpected StudentGradeLevel for StackCred1 |
Student Grade Level must be 09, 10, 11, or 12 when Stackable Credential 1 is reported. |
|
339 |
Stackable Credential 2 |
STC06652 |
E |
StackCred2 must match a valid Stackable Credential Code in DESE_Stackable_Cred_Codes where YEAR = CurrentSchoolyear. |
Invalid StackCred2 code |
Stackable Credential 2 is not a valid code. |
|
339 |
Stackable Credential 2 |
STC06665 |
E |
If StackCred2 is not null then StudentGradeLevel must be in (09, 10, 11,12). |
Unexpected StudentGradeLevel for StackCred2 |
Student Grade Level must be 09, 10, 11, or 12 when Stackable Credential 2 is reported. |
|
339 |
Stackable Credential 2 |
STC06670 |
E |
If StackCred2 is not null then StackCred2 cannot equal StackCred1. |
StackCred2 cannot equal StackCred1 |
Stackable Credentrial 2 cannot have the same value as Stackable Credential 1. |
|
340 |
ICAP |
STC06672 |
E |
Must be in code set: (Yes_No). |
ICAP must be Y or N |
ICAP must be Y or N. |
|
340 |
ICAP |
STC06675 |
E |
If StudentGradeLevel equals 8, ICAP is required |
ICAP is required when StudentGradeLevel equals 8 |
ICAP is required to be reported for students in Grade 8. |
|
341 |
ICAP Review |
STC06680 |
E |
Must be in code set: (Yes_No). |
ICAP Review must be Y or N |
ICAP Review must be Y or N. |
|
341 |
ICAP Review |
STC06685 |
E |
If StudentGradeLevel equals 9, 10, 11, or 12, ICAPReview is required. |
ICAPReview is required to be reported if studentgradelevel equals 9, 10, 11, or 12 |
ICAP Review is required to be reported for students in Grades 9, 10, 11, or 12. |
|
342 |
Seal of Biliteracy |
STC06695 |
E |
Must be in code set: (Yes_No). |
SealofBiliteracy must be Y or N |
Seal of Biliteracy must be Y or N. |
|
342 |
Seal of Biliteracy |
STC06700 |
E |
If StudentGradeLevel is 11, or 12, SealofBiliteracy is required. |
SealofBiliteracy is required |
Seal of Biliteracy must be reported since Student Grade is 11 or 12. |
|
343 |
Seal of Biliteracy Language 1 |
STC06710 |
E |
SealofBiliteracyLanguage1 must match a valid Seal of Biliteracy Language Code in DESE_Seal_of_Biliteracy_Language_Codes matching on currentschoolyear. |
SealofBiliteracyLanguage1 is not a valid code |
Seal of Biliteracy Language 1 must be a valid code. |
|
343 |
Seal of Biliteracy Language 1 |
STC06715 |
E |
If SealofBiliteracy is Y, SealofBiliteracyLanguage1 is required. |
SealofBiliteracyLanguage1 is required |
Seal of Biliteracy Language 1 is required to be reported when Seal of Biliteracy is Y. |
|
344 |
Seal of Biliteracy Language 2 |
STC06725 |
E |
SealofBiliteracyLanguage2 must match a valid Seal of Biliteracy Language Code in DESE_Seal_of_Biliteracy_Language_Codes matching on currentschoolyear. |
SealofBiliteracyLanguage2 is not a valid code |
Seal of Biliteracy Language 2 must be a valid code. |
|
345 |
Seal of Biliteracy Language 3 |
STC06735 |
E |
SealofBiliteracyLanguage3 must match a valid Seal of Biliteracy Language Code in DESE_Seal_of_Biliteracy_Language_Codes matching on currentschoolyear. |
SealofBiliteracyLanguage3 is not a valid code |
Seal of Biliteracy Language 3 must be a valid code. |
|
346 |
Associate Degree |
STC06740 |
E |
Must be in code set: (Yes_No). |
AssociatesDegree must be Y or N |
Associate Degree must be Y or N. |
|
346 |
Associate Degree |
STC06745 |
E |
If StudentGradeLevel is 12, AssociateDegree is required. |
StudentGradeLevel must be 12 |
If Student Grade Level is 12, Associate Degree is required. |
|
347 |
Associate Degree Institution |
STC06750 |
E |
AssociateDegreeInstitution must match a valid County_District_Code in DESE_Approved_Dual_Credit_Codes where YEAR = CurrentSchoolyear. |
Invalid AssociateDegreeInstitutioncode |
Associate Degree Institution is not a valid code. |
|
347 |
Associate Degree Institution |
STC06755 |
E |
If AssociateDegree equals Y, then AssociatesDegreeInstitution is required. |
AssociatesDegreeInstitution is required |
Associate Degree Institution is required to be reported since Associate Degree is reported as Yes. |
|
348 |
KG Physical Well-being and Motor |
STC06760 |
E |
Must be in code set: (Yes_No_Unknown). |
KGPhysicalWell-beingandMotor must be Y, N, or U |
KG Physical Well-being and Motor must be Y, N, or U. |
|
349 |
KG Social and Emotional |
STC06762 |
E |
Must be in code set: (Yes_No_Unknown). |
KGSocialandEmotional must be Y, N, or U |
KG Social and Emotional must be Y, N, or U |
|
350 |
KG Cognition and General Knowledge |
STC06764 |
E |
Must be in code set: (Yes_No_Unknown). |
KGCognitionandGeneralKnowledge must be Y, N, or U |
KG Cognition and General Knowledge must be Y, N, or U |
|
351 |
KG Approaches Toward Learning |
STC06766 |
E |
Must be in code set: (Yes_No_Unknown). |
KGApproachesTowardLearning must be Y, N, or U |
KG Approaches Toward Learning must be Y, N, or U |
|
352 |
KG Language and Literacy |
STC06768 |
E |
Must be in code set: (Yes_No_Unknown). |
KGLanguageandLiteracy must be Y, N, or U |
KG Language and Literacy must be Y, N, or U. |
|