FileSpecRules:201400EDPrepAnnualParticipation
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 '2014ALL1.0EDPrepParticipation' CollectionVersion must be '2014ALL1.0EDPrepParticipation' The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the Collection Version must be '2014ALL1.0EDPrepParticipation'.
005 Collection Version EDP00455 E Record must be unique using key CurrentSchoolYear, ReportingEdPrepProgram, SSN, SubjectArea, and EdPrepProgramType. Participant reported more than once for program Participant reported more than once for program. Record must be unique for CurrentSchoolYear, ReportingEdPrepProgram, SSN, SubjectArea, and EdPrepProgramType.
010 Current School Year EDP00402 E CurrentSchoolYear must be in '2010', '2011', '2012', '2013', or '2014'. CurrentSchoolYear must be '2010', '2011', '2012', '2013', or '2014' The CurrentSchoolYear identifies the school year for the data. For this collection the CurrentSchoolYear must be '2010', '2011', '2012', '2013', or '2014'.
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.
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 currentschoolyear 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.
125 Ed Prep Program Type EDP00408 E Must be in code set: (Ed_Prep_Program_Type_Codes) EdPrepProgramType must be TD, NT, IP, or AT EdPrepProgramType must be TD, NT, IP, or AT.
125 Ed Prep Program Type EDP00413 E If PrepProgramType is TD, NT, or IP 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 Ed Prep Participation Status EDP00450 E Must in in code set: (Ed_Prep_Participation_Status_Codes) EdPrepPartStatus must be A, P, or O. EdPrepPartStatus must be (A)dmitted, (P)Participating , or (O) Other.
130 Ed Prep Participation Status EDP00460 E For Current School Year 2014 and prior, EdPrepPartStatus cannot be 'A' if SSN, ReportingEdPrepProgram, SubjectArea, and EdPrepProgramType exist in the collection with a prior currentschoolyear. Participant reported as admitted in a prior currentschoolyear. Participant reported as admitted in a prior currentschoolyear. A participant can only be admitted once to a program, use the status of participating if the participant has resumed the program.
130 Ed Prep Participation Status EDP00465 E For Current School Year 2014 and prior, EdPrepPartStatus cannot be 'P' or 'O' if SSN, ReportingEdPrepProgram, SubjectArea, and EdPrepProgramType exist in the collection with a subsequent currentschoolyear and an EdPrepPartStatus of 'A'. Participant cannot be reported as Participating or Other prior to Admittance Participant cannot be reported as Participating or Other prior to Admittance. Participant has been reported as being admitted into the program in a subsequent school year.
130 Ed Prep Participation Status EDP00470 E At least 1 record with 'A' or 'P' is required for ReportingEdPrepProgram, SSN, SubjectArea, and EdPrepProgramType if a match exists DESE_ED_PREP_COMPLETERS and the record must have a currentschoolyear less than equal to the completion year in the DESE_ED_ Missing participation record for a reported Completer Missing participation record for a reported Completer. Participant was reported as a completer in the Ed Prep Completer collection and requires at least 1 participation record.
130 Ed Prep Participation Status EDP00475 E For Current School Year 2014 and prior, If CurrentSchoolYear is not 2014 and EdPrepPartStatus is 'A' or 'P' then a record matching CurrentSchoolYear + 1, ReportingEdPrepProgram, SSN, SubjectArea, and EdPrepProgramType is required. Missing participation record Missing participation record. Participant was reported as Admitted or Participating, but a subsequent year record has not been provided.
130 Ed Prep Participation Status EDP00480 E For Current School Year 2015 and forward, EdPrepPartStatus cannot be 'A' if SSN, ReportingEdPrepProgram, SubjectArea, and EdPrepProgramType exist in . Participant reported as admitted in a prior currentschoolyear. Participant reported as admitted in a prior currentschoolyear. A participant can only be admitted once to a program, use the status of participating if the participant has resumed the program.
130 Ed Prep Participation Status EDP00485 E For Current School Year 2015 and forward, EdPrepPartStatus cannot be 'P' or 'O' unless SSN, SubjectArea, and EdPrepProgramType exist in Participant cannot be reported as Participating or Other prior to Admittance Participant cannot be reported as Participating or Other prior to Admittance. Participant has been reported as being admitted into the program in a subsequent school year.
130 Ed Prep Participation Status EDP00490 E For Current School Year 2015 and forward, If is 'A' or 'P' then a record matching ReportingEdPrepProgram, SSN, SubjectArea, and EdPrepProgramType is required. Missing participation record Missing participation record. Participant was reported as Admitted or Participating, but a subsequent year record has not been provided.