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. |