FileSpecRules:202106JuneCycleReferrals
Item_Number Item_Name Collection_Rule_ID Severity Business_Rule Short_Title General_Message Detailed_Message
005 Collection Version REF00001 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 REF00005 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 REF00010 E CollectionVersion must match '2021Jun1.0Referrals' CollectionVersion must be '2021Jun1.0Referrals' The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2021Jun1.0Referrals'.
010 Current School Year REF00015 E CurrentSchoolYear must match '2021' CurrentSchoolYear must be '2021' The CurrentSchoolYear identifies the school year for the data. For this collection the CurrentSchoolYear must be '2021'.
015 Attending District Code REF00020 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 REF00025 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.
025 Reporting District Code REF00030 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.
025 Reporting District Code REF00035 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.
030 Reporting School Code REF00040 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.
035 Resident District Code REF00045 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.
040 Resident School Code REF00050 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.
050 MOSIS Student ID REF00055 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.
050 MOSIS Student ID REF00060 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.
080 Date of Birth REF00065 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 REF00070 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.
110 Office Discipline Referrals REF00075 E OfficeDiscReferrals must be an integer OfficeDiscReferrals has an invalid format OfficeDiscReferrals should be an integer that is 1 to 3 digits long.
115 Assistance Referrals REF00080 E AssistanceReferrals must be an integer AssistanceReferrals has an invalid format AssitanceReferrals should be an integer that is 1 to 3 digits long.
120 Special Education Referrals REF00085 E SpecEdReferrals must be an integer SpecEdReferrals has an invalid format SpecEdReferrals should be an integer that is 1 to 3 digits long.
125 Referrals Outside Agencies REF00090 E ReferralsOutsideAgency must be an integer ReferralsOutsideAgency has an invalid format ReferralsOutsideAgency should be an integer that is 1 to 3 digits long.