Discipline 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 '2019Feb1.0StuGradFllw' for the 2019 Student Graduate Follow-up February Cycle File Layout. | ||
| 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’ If field is blank, Reporting District Code will default or if the Resident School Code is not blank, its district section will be used. |
| 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’ The value’s building section will be used. If field is blank, Reporting District School will default. |
| 45 | MOSIS Student ID | Text | 10 | reg_personal.state_report_id | Registration > Entry & Reports > Student Demographic > Personal > General panel: State Reporting ID | |
| 50 | Local Student ID | Text | 20 | reg_entry_with.student_id | Student ID | |
| 55 | Legal Last Name | Text | 60 | reg.last_name | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Last Name | |
| 60 | Legal First Name | Text | 60 | reg.first_name | Registration > Entry & Reports > Student Demographic > Registration > Student panel: First Name | |
| 65 | Legal Middle Name | Text | 60 | reg.middle_name | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Middle Name | |
| 70 | Legal Name Suffix | Text | 10 | reg.generation | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Generation | |
| 75 | Date of Birth | Text | 10 | reg.birthdate | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Birth Date | |
| 80 | Student Grade Level | Text | 2 | reg_entry_with.grade converted to state code | reg_grade | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > Regular School Year panel: Grade |
| 85 | Gender | Text | 1 | reg.gender | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Gender | |
| 90 | Race/Ethnicity | Text | 1 | if reg_personal.hispanic = "Y" then report "H" else reg_personal.ethnic_code converted to state code | regtb_ethnicity | Registration > Entry & Reports > Student Demographic > Personal > Federal panel: Hispanic/Latino Ethnicity or Race field If a student is marked Y in the Hispanic/Latino Ethnicity field, an H will be sent in this field. If a student is not Hispanic and has one Race, then the state equiv code of the Primary Race will be sent. If a student is not Hispanic and has multiple races, an M is sent. |
| 95 | Offense Date | Date | 10 | disc_incident.incident_date | Interventions > All > Student > Behavior Incidents > Incident List panel > click appropriate Incident link > Incident panel > Definition panel: Date | |
| 100 | Offense Type | Text | 1 | disc_off_code.offense_code | disc_incident_code | Interventions > All > Student > Behavior Incidents > Incident List panel > click appropriate Incident link > Offenders panel > click name of appropriate offender > Offense Information panel: Offense For each reportable incident, only one Offense Code gets reported per student. If a Discipline Incident has multiple offenses for the student, the MOSIS Download checks which Offense Code has the highest priority Severity Order in the Incident Codes table. For an illustration of this concept, please refer to the Missouri Student Data – Discipline section. |
| 105 | Weapon Type | Text | 1 | disc_off_weapon.weapon_code | disctb_weapon | Interventions > All > Student > Behavior Incidents > Incident List panel > click appropriate Incident link > Offenders panel > click name of appropriate offender > Offense Information panel: Weapon For each reportable incident, only one Weapon Code gets reported per student. If a Discipline Incident has multiple weapons for the student, the MOSIS Download checks which Weapon Code has the highest priority Severity Order in the Weapons table. For an illustration of this concept, please refer to the Missouri Student Data – Discipline section. |
| 110 | Discipline Removal | Text | 3 | disc_off_action.action_code | disctb_off_action | Interventions > All > Student > Behavior Incidents > Incident List panel > click appropriate Incident link > Offenders panel > click name of appropriate offender > Offense Actions: Action Code |
| 115 | Length Removed | Text | 3 | disc_off_action.schd_duration | Interventions > All > Student > Behavior Incidents > Incident List panel > click appropriate Incident link > Offenders panel > click View Detail icon > Actions panel > click appropriate action > Dates panel: Actual Duration or Interventions > All > Student > Behavior Incidents > Incident List panel > click appropriate Incident link > Offenders panel > click View Detail icon > Actions panel > click appropriate action > Dates panel: Scheduled Duration Use actual duration first, if this field is blank use schedule duration. | |
| 120 | Modified Length | Boolean | 1 | Calculated value | Compares the Discipline Offender Action – Actual Duration and Discipline Offender Action – Scheduled Duration | |
| 125 | Alternate Placement Indicator | Boolean | 1 | disc_user.field_value where screen_type='O' and screen_number='550' and field_number='1' | Interventions > All > Student > Behavior Incidents > Incident List panel > click appropriate Incident link > Offenders panel > click View Detail icon > Other Offender Information panel > MOSIS Discipline panel: Alternative Placement | |
| 130 | LEP / ELL | Text | 3 | reg_programs.program_value where program_id and field_number maps to reg_program_column.state_code_equiv='LEP/ELL' If student has CTE Flag value as Y and if this field is blank then default this field to NLP. Else convert value from reg_programs to state code using motb_lep_code table. | motb_lep_code | Registration > Entry & Reports > Student District Defined > MOSIS LEP/ELL: LEP/ELL or Program where the state code equiv = ‘LEPELL’ |
| 135 | IEP Disability | Text | 2 | reg_programs.program_value where program_id and field_number maps to reg_program_column.state_code_equiv='IEPDISAB' | motb_disability | Registration > Entry & Reports > Student District Defined > MOSIS Special Ed: IEP Disability (program where the state code equiv = ‘IEPDISAB’) |