FileSpecRules:201300EDPrep
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 '2013ALL1.0EDPrep' CollectionVersion must be '2013ALL1.0EDPrep' The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the Collection Version must be '2013ALL1.0EDPrep'.
010 Current School Year EDP00402 E CurrentSchoolYear must match '2013' CurrentSchoolYear must be '2013' The CurrentSchoolYear identifies the school year for the data. For this collection the CurrentSchoolYear must be '2013'.
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.
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 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 or 2 digits followed by an optional decimal point and 1, or 2 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, or 2 digits.
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 be 2007, 2008, 2009, 2010, 2011, 2012, or 2013. CompletionYear is not a valid year CompletionYear must be 2007, 2008, 2009, 2010, 2011, 2012, or 2013.
130 Completion Year EDP00417 E At least one record must have a compyear of 2013 unless reportingedprepprogram equals 703619. There are no records found for completion year 2013 There must be at least one record with a completion year of 2013.
130 Completion Year EDP00418 E At least one record must have a compyear of 2012. There are no records found for completion year 2012 There must be at least one record with a completion year of 2012.
130 Completion Year EDP00419 E At least one record must have a compyear of 2011. There are no records found for completion year 2011 There must be at least one record with a completion year of 2011.
130 Completion Year EDP00420 E At least one record must have a compyear of 2010 unless reportingedprepprogram equals 703619. There are no records found for completion year 2010 There must be at least one record with a completion year of 2010.
130 Completion Year EDP00421 E At least one record must have a compyear of 2009 unless reportingedprepprogram equals 703619. There are no records found for completion year 2009 There must be at least one record with a completion year of 2009.
130 Completion Year EDP00423 W At least one record must have a compyear of 2008 unless reportingedprepprogram equals 703619. There are no records found for completion year 2008 There must be at least one record with a completion year of 2008.