Item_Number | Item_Name | Collection_Rule_ID | Severity | Business_Rule | Short_Title | General_Message | Detailed_Message |
---|---|---|---|---|---|---|---|

005 | Collection Version | EDC00001 | 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 | EDC00201 | 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 | EDC00401 | E | CollectionVersion must match '2020Oct1.0EdCore' | CollectionVersion must match '2020Oct1.0EdCore' | The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2020Oct1.0EdCore'. | |

005 | Collection Version | EDC01600 | E | There must be at least one Educator Core record | There are no Educator Core records | There must be at least one Educator Core record. | |

010 | Current School Year | EDC00402 | 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'. | |

025 | Reporting District Code | EDC00441 | 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 | EDC00700 | E | ReportingDistrictCode must match the SRM user's district code. | ReportingDistrictCode does not match that of the trial | Invalid ReportingDistrictCode. The ReportingDistrictCode is not the same as the trial's district. | |

050 | ED SSN | EDC00445 | E | The Social Security Number must 9 digits with no extra characters such as spaces and dashes. | EDSSN must be 9 digits | The Social Security Number must be specified as 9 digits. | |

050 | ED SSN | EDC00451 | E | EDSSN must be unique in the file. | Duplicate EDSSN | There can be only one entry for each educator. An educator is defined by their social security number. | |

050 | ED SSN | EDC00452 | E | At least 1 record matching EDSSN must exist in the Educator School file. Match on EDSSN, ReportingDistrictCode, CurrentSchoolYear. | EDSSN is missing Educator School record. | No matching record for the EDSSN can be found in the Educator School file. | |

080 | ED Date of Birth | EDC00446 | E | DateOfBirth must be a valid date | EDDateOfBirth is not a valid date | Dates are specified using the format mm/dd/yyyy. | |

080 | ED Date of Birth | EDC01100 | W | The educator's age, based on EDDateOfBirth, cannot be older than 80 or younger than 18 on Oct 15 of the current school year. | EDDateOfBirth is outside the expected range | EDDateOfBirth is outside expected range. The age is expected to be between 18 to 80 on Oct 15. | |

100 | ED Gender | EDC00405 | E | Must be in code set: (Gender_Codes). | Invalid Gender code | Gender must be M or F. | |

105 | ED Race/Ethnicity | EDC00406 | E | Must be in code set: (Race_Ethnicity_Codes). | Invalid RaceEthnicity code | RaceEthnicity must be A, B, H, I, W, P or M. | |

110 | ED Email | EDC00450 | W | EDEmail must match a valid email format. A valid email address is one or more characters, a ampersand, one or more characters, a period, one or more characters. | EDEmail has an invalid email format | EDEmail has an invalid email format. | |

120 | Extended Contract Duration | EDC00421 | E | EDExtConDur must be an Integer | EDExtConDur must be an integer | EDExtConDur must be an integer containing only digits. | |

120 | Extended Contract Duration | EDC05010 | E | EDExtConDur (ED Extended Contract Duration) must be greater than 0 if EDExtConSal (ED Extended Contract Salary) is greater than 0 | EDExtConDur must be greater than zero | Extended Contract Duration must be greater than zero if Extended Contract Salary is greater than zero. | |

120 | Extended Contract Duration | EDC05020 | W | If EDExtConDur (ED Extended Contract Duration) greater than 100 | EDExtConDur is greater than 100 days | Extended Contract Duration is greater than 100 days. This value has surpassed a threshold and should be verified to be correct. | |

130 | Extended Contract Salary | EDC00422 | E | EDExtConSal must be an Integer | EDExtConSal must be an integer | EDExtConSal must be an integer containing only digits. | |

130 | Extended Contract Salary | EDC05100 | W | EDExtConSal (ED Extended Contract Salary) greater than EDRegTermSal (ED Regular Term Salary). | EDExtConSal should not exceed EDRegTermSal | Extended Contract Salary should not exceed Regular Term Salary. | |

130 | Extended Contract Salary | EDC05110 | W | EDExtConSal (ED Extended Contract Salary) should not exceed 50000. | EDExtConSal should not exceed 50000 | Extended Contract Salary should not exceed 50000. This value has surpassed a threshold and should be verified to be correct. | |

140 | Regular Term Salary | EDC00423 | E | EDRegTermSal must be an Integer | EDRegTermSal must be an integer | EDRegTermSal must be an integer containing only digits. | |

140 | Regular Term Salary | EDC05200 | W | If EDRegTermSal (ED Regular Term Salary) exceeds 200000. | EDRegTermSal should not exceed 200000 | Regular Term Salary should not exceed 200000. This value has surpassed a threshold and should be verified to be correct. | |

140 | Regular Term Salary | EDC05201 | W | EDRegTermSal must be null or zero if EDC.EDFiscAgentCoDist <> EDC.ReportingDistrictCode. | EDRegTermSal must be null or zero | EDRegTermSal must be null or zero if EDFiscAgentCoDist is not the same as ReportingDistrictCode. | |

140 | Regular Term Salary | EDC05202 | E | EDRegTermSal is required to be greater than zero if EDC.EDFiscAgentCoDist = EDC.ReportingDistrictCode and Sum of FTE is greater than zero. | EDRegTermSal is required to be greater than zero | EDRegTermSal is required to be greater than zeros since the educators total FTE is greater than zero. | |

150 | Extra Duty Salary | EDC00424 | E | EDExtDutySal must be an Integer | EDExtDutySal must be an integer | EDExtDutySal must be an integer containing only digits. | |

150 | Extra Duty Salary | EDC05300 | W | EDExtDutySal (Extra Duty Salary) should not exceed EDRegTermSal (ED Regular Term Salary). | EDExtDutySal should not exceed EDRegTermSal | Extra Duty Salary should not exceed Regular Term Salary. | |

160 | Min. Salary Supplement | EDC00425 | E | EDMinSalSupplmt must be an Integer | EDMinSalSupplmt must be an integer | EDMinSalSupplmt must be an integer containing only digits. | |

160 | Min. Salary Supplement | EDC05600 | W | EDMinSalSupplmt must be null or zero if sum of EDS.FTE is zero for that EDSSN. | EDMinSalSupplmt must be null or zero | EDMinSalSupplmt must be null or zero if total FTE is zero for educator. | |

160 | Min. Salary Supplement | EDC05601 | W | If EDMinSalSupplmt is greater than zero then the sum of EDS.FTE must be greater than zero for that EDSSN. | Educator total FTE must be greater than zero | Educator total FTE must be greater than zero if EDMinSalSupplmt is greater than zero | |

160 | Min. Salary Supplement | EDC05602 | E | If the Educator’s EDS.Salary for records in which the (EDC.EDHighDegree is in (MAST, SPEC, DOCT) and EDS.PosCode is in (40, 50, 60) and EDC.EDYrExpPublic > 10) is greater than or equal to [the amount in DC_EDUCATOR_MINIMUM_SALARY times EDS.FTE] where currentschoolyear matches the year and Minimum_Salary_Type = ‘10PLUSMASTER’ then EDC.EDMinSalSupplmt for that educator must be null or zero. (Key between EDC and EDS is CurrentSchoolYear, ReportingDistrictCode, EDSSN or Trial_ID and EDSSN) | EDMinSalSupplmt must be null or zero | EDMinSalSupplmt must be null or zero since the educator is already paid at or above the minimum salary established in section 163.172.1, RSMo. | |

160 | Min. Salary Supplement | EDC05603 | E | If Educator’s EDS.Salary (for records that are PosCode 40, 50, or 60) is greater than or equal to [the amount in DC_EDUCATOR_MINIMUM_SALARY times EDS.FTE] where currentschoolyear matches the year and Minimum_Salary_Type = ‘MIN’ and edHighDegree not in ('MAST', 'SPEC', 'DOCT') then EDC.EDMinSalSupplmt for that educator must be null or zero. (Key between EDC and EDS is CurrentSchoolYear, ReportingDistrictCode, EDSSN or Trial_ID and EDSSN) | EDMinSalSupplmt must be null or zero | EDMinSalSupplmt must be null or zero since the educator is already paid at or above the minimum salary established in section 163.172.1, RSMo. | |

170 | Career Ladder Stage | EDC00407 | E | Must be in code set: (Educator_Career_Ladder_Stages) | Invalid EDCareerLadr code | EDCareerLadr must be 1, 2, or 3. | |

170 | Career Ladder Stage | EDC02080 | E | If EDEarlyTermDate (Early Termination Date) is valid and not null then EDCareerLadr (Career Ladder Stage) must be Null. | EDCareerLadr must be null when EDEarlyTermDate is supplied | When an Educator is an early termination the EDCareerLadr must be null. | |

170 | Career Ladder Stage | EDC02090 | E | If EDLateHireDate (Late Hire Date) is valid and not null then EDCareerLadr (Career Ladder Stage) must be null. | EDCareerLadr must be null when EDLateHireDate is supplied | If Educator was a Late Hire then EDCareerLadr must be null. | |

170 | Career Ladder Stage | EDC03000 | W | If EDCareerLadr (Career Ladder Stage) is 1 then EDYrExpMO must be >= 6. | Educator must have 6 or more years of MO experience | Stage 1 - Educator must have 6 or more years of teaching experience in Missouri Public Schools. | |

170 | Career Ladder Stage | EDC03010 | W | If EDCareerLadr (Career Ladder Stage) is 2 then EDYrExpMO must be >= 5 and .EDYrExpPublic >= 8 | Educator must have 8 or more years of Public school experience | Stage 2 - Educator must have 8 or more years of Public school experience (5 of which must be Missouri experience) | |

170 | Career Ladder Stage | EDC03020 | W | If EDCareerLadr (Career Ladder Stage) is 3 then EDYrExpMO must be >= 5 and .EDYrExpPublic >= 11 | Educator must have 11 or more years of Public school experience | Stage 3 - Educator must have 11 or more years of Public school experience (5 of which must be Missouri experience) | |

170 | Career Ladder Stage | EDC03030 | W | If EDCareerLadr is not null then ReportingDistrictCode must be an approved Career Ladder district as indicated in the DESE_District table with a Y in Column Career_Laddar_Indicator where the column Year matches CurrentSchoolYear. | EDCareerLadr must be null | EDCareerLadr must be null since ReportingDistrictCode is not an approved career ladder district. | |

170 | Career Ladder Stage | EDC03040 | W | If EDCareerLadr is not null then the total FTE (across all records for the EDSSN in the Districts EDSchool file) must equal 1.0 | EDCareerLadr not allowed if Total FTE is less than one | EDCareerLadr is not allowed since the sum of educators FTE is less than one. | |

170 | Career Ladder Stage | EDC03050 | W | If EDCareerLadr is not null then the EDSSN must have at least .57 FTE (in the EdSchool File) in at least one of these PosCode (40, 50, 60, 70, 90) | EDCareerLadr must have at least 0.57 FTE | Educator must have at least 0.57 FTE in the EDSchool file in at least one of these positions (40, 50, 60, 70, or 90) | |

180 | Highest Degree | EDC00408 | E | Must be in code set: (Educator_Highest_Degree) | Invalid EDHighDegree code | EDHighDegree is not one of the valid codes. | |

190 | Public School Years - District | EDC00426 | E | EDYrExpDist must be an Integer | EDYrExpDist must be an integer | EDYrExpDist must be an integer containing only digits. | |

190 | Public School Years - District | EDC00430 | E | Check prior year October Educator Core EDC and prior year Educator School EDS certified submissions matching the EDSSN unless the prior year EDC.EDEarlyTermDate contains a valid date or EDS.PosCode is 70 or 80., ensure the value for Public School Years - District increased by 1 in the current year. This rule ensures if an educator was reported in the district the prior year, they have a record in the current year with an additional year added to the years of experience. | EDYrExpDist must be 1 greater than the prior year | The number of years teaching public school in the district (EDYrExpDist) must be 1 greater than the prior year. | |

190 | Public School Years - District | EDC04000 | E | EDYrExpDist (Public School Years - District) must be 1 or greater. | EDYrExpDist must be 1 or greater | The number of years teaching public school in the district (EDYrExpDist) must be 1 or greater. | |

190 | Public School Years - District | EDC04010 | E | EDYrExpDist (Public School Years - District) cannot exceed EDYrExpMO (Public School Years - MO) | EDYrExpDist cannot exceed EDYrExpMO | The number of years teaching public school in the district (EDYrExpDist) cannot exceed the number of years teaching public school in Missouri (EDYrExpMO). | |

195 | Public School Years - Missouri | EDC00427 | E | EDYrExpMO must be an Integer | EDYrExpMO must be an integer | EDYrExpMO must be an integer containing only digits. | |

195 | Public School Years - Missouri | EDC00431 | E | Check prior year October Educator Core EDC and prior year Educator School EDS certified submissions matching the EDSSN unless the prior year EDC.EDEarlyTermDate contains a valid date or EDS.PosCode is 70 or 80, ensure the value for Public School Years - Missouri increased by 1 in the current year. This rule ensures if an educator was reported in the district the prior year, they have a record in the current year with an additional year added to the years of experience. | EDYrExpMO must be 1 greater than the prior year | The number of years teaching public school in Missouri (EDYrExpMO) must be 1 greater than the prior year. | |

195 | Public School Years - Missouri | EDC04100 | E | EDYrExpMO (Public School Years - MO) cannot exceed EDYrExpPublic (Public School Years - Public) | EDYrExpMO cannot exceed EDYrExpPublic | The number of years teaching public school in Missouri (EDYrExpMO) cannot exceed the number of years teaching public school (EDYrExpPublic). | |

200 | Public School Years -Public | EDC00428 | E | EDYrExpPublic must be an Integer | EDYrExpPublic must be an integer | EDYrExpPublic must be an integer containing only digits. | |

200 | Public School Years -Public | EDC00432 | E | Check prior year October Educator Core EDC and prior year Educator School EDS certified submissions matching the EDSSN unless the prior year EDC.EDEarlyTermDate contains a valid date or EDS.PosCode is 70 or 80, ensure the value for Public School Years - Public increased by 1 in the current year. This rule ensures if an educator was reported in the district the prior year, they have a record in the current year with an additional year added to the years of experience. | EDYrExpPublic must be 1 greater than the prior year | The number of years teaching public school (EDYrExpPublic) must be 1 greater than the prior year. | |

200 | Public School Years -Public | EDC04200 | W | EDYrExpPublic (Public School Years - Public) should not exceed 55. | EDYrExpPublic should not exceed 55 | The number of years teaching public school (EDYrExpPublic) should not exceed 55. | |

210 | Late Hire Date | EDC00447 | E | EDLateHireDate must be a valid date | EDLateHireDate is not a valid date | Dates are specified using the format mm/dd/yyyy. | |

210 | Late Hire Date | EDC02050 | E | EDLateHireDate must be a valid date between and including July 1 of the current school year minus 1 and June 30 of the current school year. | EDLateHireDate must be a date within the Current School Year | EDLateHireDate must be a date within the current school year (July 1 to June 30). | |

220 | Early Termination Date | EDC00448 | E | EDEarlyTermDate must be a valid date | EDEarlyTermDate is not a valid date | Dates are specified using the format mm/dd/yyyy. | |

220 | Early Termination Date | EDC02060 | E | EDEarlyTermDate must be a valid date between and including July 1 of the current school year minus 1 and June 30 of the current school year. | EDEarlyTermDate must be a date within the Current School Year | EDEarlyTermDate must be a date within the current school year (July 1 to June 30). | |

220 | Early Termination Date | EDC02070 | E | EDEarlyTermDate cannot occur prior to EDLateHireDate. | EDEarlyTermDate is before EDLateHireDate | EDEarlyTermDate must be on or after the EDLateHireDate. | |

240 | Fiscal Agent County District | EDC00409 | E | Must be in code set: (Fiscal_Agent_District) | Invalid EDFiscAgentCoDist code | EDFiscAgentCoDist is not valid. | |

250 | Min. Salary Days Worked | EDC00429 | E | EDMinSalDaysWrkd must be an Integer | EDMinSalDaysWrkd must be an integer | EDMinSalDaysWrkd must be an integer containing only digits. | |

250 | Min. Salary Days Worked | EDC05500 | E | EDMinSalDaysWrkd (Minimum Salary Days Worked) cannot be null if EDMinSalSupplmt (Minimum Salary Supplement) is not null. | EDMinSalDaysWrkd is required if EDMinSalSupplmt is not null | Minimum Salary Days Worked is required if Minimum Salary Supplement is not null. | |

250 | Min. Salary Days Worked | EDC05510 | E | EDMinSalDaysWrkd (Minimum Salary Days Worked) must be null if EDMinSalSupplmt (Minimum Salary Supplement) is null. | EDMinSalDaysWrkd must be null if EDMinSalSupplmt is null | Minimum Salary Days Worked must be null if Minimum Salary Supplement is null. | |

250 | Min. Salary Days Worked | EDC05521 | W | If EDC.EDMinSalDaysWrkd is greater than zero and not equal to DESE_District.Contract_Days and EDC.EDLateHireDate and EDC.EDEarlyTermDate are both null. | EDMinSalDaysWrkd does not match contract days | EDMinSalDaysWrkd does not match contract days and no late hire or early term date has been entered. | |

250 | Min. Salary Days Worked | EDC05522 | W | If EDC.EDMinSalDaysWrkd is greater than 185 | EDMinSalDaysWrkd is greater than 185 | EDMinSalDaysWrkd is greater than 185 |