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

005 | Collection Version | EDP00001 | 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 | EDP00201 | 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 | EDP00401 | E | CollectionVersion must match '2017ALL1.0EDPrep' | CollectionVersion must be '2017ALL1.0EDPrep' | The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the Collection Version must be '2017ALL1.0EDPrep'. | |

010 | Current School Year | EDP00402 | E | CurrentSchoolYear must match '2017' | CurrentSchoolYear must be '2017' | The CurrentSchoolYear identifies the school year for the data. For this collection the CurrentSchoolYear must be '2017'. | |

025 | Reporting Ed Prep Program | EDP00441 | E | ReportingEdPrepProgram must match a valid DESE County District Code. District codes are in DESE District table. | Invalid ReportingEdPrepProgram code | ReportingEdPrepProgram code is not a valid county district code. | |

025 | Reporting Ed Prep Program | EDP00700 | E | ReportingEdPrepProgram must match the SRM user's district code. | The student is not from this district | The student's ReportingEdPrepProgram code does not equal that of the trial. | |

080 | Date of Birth | EDP00446 | 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 | EDP00448 | E | DateofBirth is not a valid date. It must be over the age of 16 and under the age of 100 as of September 1 of the current school year. | Unexpected Date of Birth | The date of birth reported is unexpected. Please verify the data. | Based on reported date of birth, teacher candidate appears to be {1} years old. |

085 | Social Security Number | EDP00445 | E | The Social Security Number must 9 digits with no extra characters such as spaces and dashes. | EDSSN has an invalid format | The Social Security Number must be specified as 9 digits. | |

085 | Social Security Number | EDP00450 | W | If there are records in DESE_LIC_COMPLETERS not found in the submission when matching on compyear, ssn, reportingEdPrepProgram, and subjectArea, display records for verification from DESE_LIC_COMPLETERS where reportingEdPrepProgram=CNTY_DIST_CODE and COMP | Found missing completion | Additional completion(s) found. Please confirm. | Completion for Educator is missing for LastName/FirstName/last four digits of SSN/CompYear/SubjectArea: {1}/{2}/{3}/{4}/{5} |

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

105 | Race/Ethnicity | EDP00406 | E | Must be in code set: (PAP_Race_Ethnicity). | RaceEthnicity must be A, B, H, I or W, P, M, or O | RaceEthnicity must be A, B, H, I or W, P, M, or O. | |

110 | Cert. Subject Area | EDP00409 | E | SubjectArea must be in table DESE_LIC_APPROVED_PROGRAM_INFORMATION_MOSIS matching on compyear and ReportingEdPrepProgram (County_District_Code) | Subject Area is not valid. | Subject Area is not valid. | |

110 | Cert. Subject Area | EDP00410 | E | SubjectArea is required if ReportingEdPrepProgram exists in DESE_DISTRICT_ED_PREP and the Preptype is 4. | Subject Area is required | Subject Area is required since the Reporting Ed Prep Program is a 4 year. | |

110 | Cert. Subject Area | EDP00416 | E | Must be in code set: (Ed_Prep_Certification_Subject_Area_Codes | Invalid EdPrepCertificationSubjectArea code | EdPrepCertificationSubjectArea code is not valid. | |

115 | GPA Type | EDP00407 | E | Must be in code set: (Ed_Prep_GPA_Type_Codes | GPAType must be C, P, or N | GPAType must be C, P, or N. | |

115 | GPA Type | EDP00411 | E | GPAType is required if GPA is provided. | GPA Type is required | GPA Type is required since GPA is provided. | |

115 | GPA Type | EDP00412 | E | GPA_TYPE must match GPA_ALLOWED_TYPE in DESE_LIC_APPROVED_PROGRAM_INFORMATION_MOSIS matching on compyear and ReportingEdPrepProgram (County_District_Code) and SubjectArea | GPA Type is not valid for subject area | GPA Type is not valid for subject area. | |

120 | Content Area GPA | EDP00414 | E | GPA is requred IF GPA_TYPE is C or P for the SubjectArea code in DESE_LIC_APPROVED_PROGRAM_INFORMATION_MOSIS matching on compyear and ReportingEdPrepProgram (County_District_Code) and SubjectArea | GPA is required | GPA is required for subject area. | |

120 | Content Area GPA | EDP00444 | E | GPA does not have a valid format. It may have 1 digit followed by an optional decimal point and 1, or 2 digits and cannot exceed 4. | GPA has an invalid format | GPA does not have a valid format. It may have 1 digit followed by an optional decimal point and 1, or 2 digits and cannot exceed 4. | |

125 | Ed Prep Program Type | EDP00408 | E | Must be in code set: (Ed_Prep_Program_Type_Codes) | EdPrepProgramType must be TD, NT, IP | EdPrepProgramType must be TD, NT, IP. | |

125 | Ed Prep Program Type | EDP00413 | E | If PrepProgramType is TD then ReportingEdPrepProgram must exists in DESE_DISTRICT_ED_PREP and the Preptype is 4. | PrepProgramType is not valid for ReportingEdPrepProgram | PrepProgramType is not valid for 4 year ReportingEdPrepProgram. | |

130 | Completion Year | EDP00415 | E | CompletionYear must match current school year. | CompletionYear is not a valid year | CompletionYear must be the same as the current school year. | |

140 | Cooperating Teacher 1.1 | EDP00800 | E | CT1.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | CT1.1 has an invalid format | CT1.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

145 | Cooperating Teacher 1.2 | EDP00705 | E | CT1.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | CT1.2 has an invalid format | CT1.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | |

150 | Cooperating Teacher 2.4 | EDP00710 | E | CT2.4 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | CT2.4 has an invalid format | CT2.4 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | |

155 | Cooperating Teacher 3.1 | EDP00805 | E | CT3.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | CT3.1 has an invalid format | CT3.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

160 | Cooperating Teacher 3.2 | EDP00810 | E | CT3.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | CT3.2 has an invalid format | CT3.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

165 | Cooperating Teacher 4.1 | EDP00815 | E | CT4.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | CT4.1 has an invalid format | CT4.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

170 | Cooperating Teacher 5.1 | EDP00715 | E | CT5.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | CT5.1 has an invalid format | CT5.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | |

175 | Cooperating Teacher 5.2 | EDP00820 | E | CT5.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | CT5.2 has an invalid format | CT5.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

180 | Cooperating Teacher 5.3 | EDP00825 | E | CT5.3 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | CT5.3 has an invalid format | CT5.3 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

185 | Cooperating Teacher 6.1 | EDP00830 | E | CT6.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | CT6.1 has an invalid format | CT6.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

190 | Cooperating Teacher 7.1 | EDP00835 | E | CT7.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | CT7.1 has an invalid format | CT7.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

195 | Cooperating Teacher 7.2 | EDP00720 | E | CT7.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | CT7.2 has an invalid format | CT7.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | |

200 | Cooperating Teacher 7.5 | EDP00840 | E | CT7.5 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | CT7.5 has an invalid format | CT7.5 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

205 | Cooperating Teacher 8.1 | EDP00845 | E | CT8.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | CT8.1 has an invalid format | CT8.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

210 | Cooperating Teacher 9.1 | EDP00850 | E | CT9.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | CT9.1 has an invalid format | CT9.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

215 | Cooperating Teacher 9.3 | EDP00855 | E | CT9.3 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | CT9.3 has an invalid format | CT9.3 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

220 | Program Supervisor 1.1 | EDP00860 | E | PS1.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | PS1.1 has an invalid format | PS1.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

225 | Program Supervisor 1.2 | EDP00725 | E | PS1.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | PS1.2 has an invalid format | PS1.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | |

230 | Program Supervisor 2.4 | EDP00730 | E | PS2.4 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | PS2.4 has an invalid format | PS2.4 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | |

235 | Program Supervisor 3.1 | EDP00865 | E | PS3.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | PS3.1 has an invalid format | PS3.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

240 | Program Supervisor 3.2 | EDP00870 | E | PS3.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | PS3.2 has an invalid format | PS3.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

245 | Program Supervisor 4.1 | EDP00875 | E | PS4.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | PS4.1 has an invalid format | PS4.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

250 | Program Supervisor 5.1 | EDP00735 | E | PS5.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | PS5.1 has an invalid format | PS5.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | |

255 | Program Supervisor 5.2 | EDP00880 | E | PS5.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | PS5.2 has an invalid format | PS5.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

260 | Program Supervisor 5.3 | EDP00885 | E | PS5.3 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | PS5.3 has an invalid format | PS5.3 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

265 | Program Supervisor 6.1 | EDP00890 | E | PS6.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | PS6.1 has an invalid format | PS6.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

270 | Program Supervisor 7.1 | EDP00895 | E | PS7.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | PS7.1 has an invalid format | PS7.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

275 | Program Supervisor 7.2 | EDP00740 | E | PS7.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | PS7.2 has an invalid format | PS7.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | |

280 | Program Supervisor 7.5 | EDP00900 | E | PS7.5 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | PS7.5 has an invalid format | PS7.5 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

285 | Program Supervisor 8.1 | EDP00905 | E | PS8.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | PS8.1 has an invalid format | PS8.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

290 | Program Supervisor 9.1 | EDP00910 | E | PS9.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | PS9.1 has an invalid format | PS9.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

295 | Program Supervisor 9.3 | EDP00915 | E | PS9.3 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | PS9.3 has an invalid format | PS9.3 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

300 | Building Principal 1.1 | EDP00920 | E | BP1.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | BP1.1 has an invalid format | BP1.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

305 | Building Principal 1.2 | EDP00745 | E | BP1.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | BP1.2 has an invalid format | BP1.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | |

310 | Building Principal 2.4 | EDP00750 | E | BP2.4 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | BP2.4 has an invalid format | BP2.4 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | |

315 | Building Principal 3.1 | EDP00925 | E | BP3.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | BP3.1 has an invalid format | BP3.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

320 | Building Principal 3.2 | EDP00930 | E | BP3.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | BP3.2 has an invalid format | BP3.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

325 | Building Principal 4.1 | EDP00935 | E | BP4.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | BP4.1 has an invalid format | BP4.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

330 | Building Principal 5.1 | EDP00755 | E | BP5.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | BP5.1 has an invalid format | BP5.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | |

335 | Building Principal 5.2 | EDP00940 | E | BP5.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | BP5.2 has an invalid format | BP5.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

340 | Building Principal 5.3 | EDP00945 | E | BP5.3 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | BP5.3 has an invalid format | BP5.3 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

345 | Building Principal 6.1 | EDP00950 | E | BP6.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | BP6.1 has an invalid format | BP6.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

350 | Building Principal 7.1 | EDP00955 | E | BP7.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | BP7.1 has an invalid format | BP7.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

355 | Building Principal 7.2 | EDP00760 | E | BP7.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | BP7.2 has an invalid format | BP7.2 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#) or 'NA'. | |

360 | Building Principal 7.5 | EDP00960 | E | BP7.5 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | BP7.5 has an invalid format | BP7.5 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

365 | Building Principal 8.1 | EDP00965 | E | BP8.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | BP8.1 has an invalid format | BP8.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

370 | Building Principal 9.1 | EDP00970 | E | BP9.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | BP9.1 has an invalid format | BP9.1 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | |

375 | Building Principal 9.3 | EDP00975 | E | BP9.3 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). | BP9.3 has an invalid format | BP9.3 does not have a valid format. It must be between 0 and 7 with a single decimal point (#.#). |