Referral File Layout

Field #	Field Name	Data Type	Field Length	eSchoolPLUS table.column	Validation Table	Where in eSchoolPLUS?
5	Collection Version	Text	50	Collection version should contain this value YYYYJun1.0Referrals where YYYY is the prompted school year.
10	Current School Year	Integer	4	The ending year of the current school year. For example, use '2019' for the 2018-2019 school year.
15	Attending District Code	Text	6	reg.attending district field using state code equiv	reg_district	Registration > Entry & Reports > Student Demographic > Registration > Other Enrollment panel:  Attending District or Program where the state code equiv = 'ATTENDDIST' If field is blank, Reporting District Code will default.
20	Attending School Code	Text	4	reg.alternate accountability building field using state code equiv	reg_buildings	Registration > Entry & Reports > Student Demographic > Registration > Other Enrollment panel:  Alternate Building or Program where the state code equiv = ‘ATTENDBLDG’ If field is blank, Reporting District School will default.
25	Reporting District Code	Text	6	reg_district.district converted to state code		Administration > General Setup > District > District > Preferences panel > Other panel:  State Code Equivalent
30	Reporting School Code	Text	4	reg_entry_with.building converted to state code	reg_buildings	Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > Regular School Year panel:  Building
35	Resident District Code	Text	6	reg.state_res_building left most 6 characters	reg_district	Registration > Entry & Reports > Student Demographic > Registration > Other Enrollment panel:  District of Residence or Program where the state code equiv = ‘RESDIST’
40	Resident School Code	Text	4	reg.state_res_building last 4 characters	regtb_state_bldg	Registration > Entry & Reports > Student Demographic > Registration > Other Enrollment panel:  State Building of Residence or Program where the state code equiv = ‘RESBLDG’
50	MOSIS Student ID	Text	10	reg_personal.state_report_id		Registration > Entry & Reports > Student Demographic > Personal > General panel:  State Reporting ID
55	Local Student ID	Text	20	reg_entry_with.student_id		Student ID
60	Legal Last Name	Text	60	reg.last_name		Registration > Entry & Reports > Student Demographic > Registration > Student panel:  Last Name
65	Legal First Name	Text	60	reg.first_name		Registration > Entry & Reports > Student Demographic > Registration > Student panel:  First Name
70	Legal Middle Name	Text	60	reg.middle_name		Registration > Entry & Reports > Student Demographic > Registration > Student panel:  Middle Name
75	Legal Name Suffix	Text	10	reg.generation		Registration > Entry & Reports > Student Demographic > Registration > Student panel:  Generation
80	Date of Birth	Text	10	reg.birthdate		Registration > Entry & Reports > Student Demographic > Registration > Student panel:  Birth Date
110	Office Discipline Referrals	Integer	3	Calculated		Interventions > All > Student > Behavior Incidents > Incident List panel > click appropriate Incident link > Offenders panel > click name of appropriate offender > Offense Actions:  Action Code For the prompted School Year, total discipline offender Actions assigned to the student that are also defined in the MOSIS Discipline Reportable Actions district-level district-defined page.  The download counts these Action codes as Discipline Referrals.
115	Assistance Referrals	Integer	3	Calculated		Registration > Entry & Reports > Student District Defined > MOSIS Referrals:  Assistance Referral Count number of Assistance Referrals Values with a Start Date that falls within the prompted School Year from MOSIS Download page.  If you run the download for 2014, the year is considered 7/01/2013 through 6/30/2014.
120	Special Education Referrals	Integer	3	Calculated		Registration > Entry & Reports > Student District Defined > MOSIS Special Ed:  Special Ed Referral Count number of Special Ed Referral Values with a Start Date that falls within the prompted School Year from MOSIS Download page. If you run the download for 2014, the year is considered 7/01/2013 through 6/30/2014.
125	Referrals Outside Agencies	Integer	3	Calculated		Registration > Entry & Reports > Student District Defined > MOSIS Referrals:  Referral to Outside Agency Count number of Referral to Outside Agency Values with a Start Date that falls within the prompted School Year from MOSIS Download page. If you run the download for 2014, the year is considered 7/01/2013 through 6/30/2014.

×