FileSpec:201806JuneCycleReferrals
Item Item Name Column Name Required Definition Code Set Data Type Length Precision
005 Collection Version CollectionVersion Required Collection version should contain this value '2018Jun1.0Referrals' for the 2018 June Cycle Referrals File Layout.
Text 50
010 Current School Year CurrentSchoolYear Required The ending year of the current school year. For example, use '2007' for the 2006-2007 school year.
Integer 4
015 Attending District Code AttendingDistrictCode Required DESE assigned 6 digit county district code for the district of attendance. DESE_District_Codes Text 6
020 Attending School Code AttendingSchoolCode Required DESE assigned 4 digit school code for the school of attendance. DESE_School_Codes Text 4
025 Reporting District Code ReportingDistrictCode Required DESE assigned 6 digit county district code for the district reporting. DESE_District_Codes Text 6
030 Reporting School Code ReportingSchoolCode Required DESE assigned 4 digit school code where the student is being reported from. DESE_School_Codes Text 4
035 Resident District Code ResidentDistrictCode Required DESE assigned 6 digit county district code for the district of residence. E.g. K-8 Resident II student attending high school in a different district would have Resident District Code populated with xxxxxx and the “Attending District Code” populated with DESE_District_Codes Text 6
040 Resident School Code ResidentSchoolCode Required DESE assigned 4 digit school code for the school of residence. DESE_School_Codes Text 4
050 MOSIS Student ID StateID Required State assigned student identifier. See http://dese.mo.gov/MOSIS for more information.
Text 10
055 Local Student ID LocalStudentID Optional Local student id maintained by the district. Allows for data to be associated to local systems from DESE source systems.
Text 20
060 Legal Last Name LastName Required Legal last name.
Text 60
065 Legal First Name FirstName Required Legal first name.
Text 60
070 Legal Middle Name MiddleName Optional Legal middle name.
Text 60
075 Legal Name Suffix Suffix Optional Legal name suffix. E.g. Jr, Sr
Text 10
080 Date of Birth DateOfBirth Required Date of birth.
Text 10
110 Office Discipline Referrals OfficeDiscReferrals Optional Number of referrals to the administrative office for disciplinary action.
Integer 3
115 Assistance Referrals AssistanceReferrals Optional Number of referrals to general education team(s) within the school for academic, social or behavioral support. These referrals occur before the special education referral process. Teams may include a Student Support Team, Student Assistance Team, Problem
Integer 3
120 Special Education Referrals SpecEdReferrals Optional Number of referrals to special education for initial evaluation
Integer 3
125 Referrals Outside Agencies ReferralsOutsideAgency Optional Number of referrals to agencies or services outside of school for academic, social or behavioral support 
Integer 3