MD - Discipline Report
Data Element | Field Name | Field Length | Start Position | End Position | eSchoolplus Table.Column | Download Table.Column | Where in eSchoolPLUS |
---|---|---|---|---|---|---|---|
1 | LEA Number | 2 | 1 | 2 | reg_district.state_code_equiv | MD_DISC_DOWN.LEA | Administration, General Setup, District, District: State Equivalency Code |
2 | School Number | 4 | 3 | 6 | If the entry withdrawal building (reg_entry_with.building) is blank, gets the school number from reg_building.state_code_equiv | MD_DISC_DOWN.Building |
|
3 | State Assigned Student ID (SASID) | 10 | 7 | 16 | Reg_personal.State_report_id | MD_DISC_DOWN.State_Id | Registration, Entry & Reports, Student Demographic, Personal: State ID |
4 | Local Student ID Number | 10 | 17 | 26 | Reg.student_id | MD_DISC_DOWN.Student_ID |
|
5 | Last Name | 25 | 27 | 51 | Reg.Last_Name | MD_DISC_DOWN.Last_Name | Registration, Entry & Reports, Student Demographic, Registration: Last Name |
6 | First Name | 15 | 52 | 66 | Reg.First_Name | MD_DISC_DOWN.First_Name | Registration, Entry & Reports, Student Demographic, Registration: First Name |
7 | Middle Name | 15 | 67 | 81 | Reg.Middle_Name | MD_DISC_DOWN.Middle_Name | Registration, Entry & Reports, Student Demographic, Registration: Middle Name |
8 | Generation Code or Suffix | 3 | 82 | 84 | Reg.Generation | MD_DISC_DOWN.Generation_Suffix | Registration, Entry & Reports, Student Demographic, Registration: Generation |
9 | Preferred Name (Optional) | 15 | 85 | 99 | |||
10 | Date of Birth | 8 | 100 | 107 | Reg.Birthdate | MD_DISC_DOWN.Date_Birth | Registration, Entry & Reports, Student Demographic, Registration: Birth Date |
11 | Grade | 2 | 108 | 109 | Reg_entry_with.grade (respective state code from reg_grade.state_code_equiv) | MD_DISC_DOWN.Grade | Registration, Entry & Reports, Student Demographic, Entry/withdrawal: Grade |
12 | Gender | 1 | 110 | 110 | reg.gender_identity (regtb_gender_identity.state_code_equiv_02) | MD_DISC_DOWN.Gender | Registration, Entry & Reports, Student Demographic, Registration: Gender Identity |
13 | Hispanic/Latino Ethnicity | 1 | 111 | 111 | reg_personal.Hispanic | MD_DISC_DOWN.Hispanic | Registration, Entry & Reports, Student Demographic, Personal: Hispanic/Latino Ethnicity |
14 | American Indian/Alaskan Native | 1 | 112 | 112 | reg_personal.ethnic_code where ethnic_code = 1 (regtb_ethnicity.state_code_equiv) | MD_DISC_DOWN.New_Race_1 | Registration, Entry & Reports, Student Demographic, Personal: Race |
15 | Asian | 1 | 113 | 113 | reg_personal.ethnic_code where ethnic_code = 2 (regtb_ethnicity.state_code_equiv) | MD_DISC_DOWN.New_Race_2 | Registration, Entry & Reports, Student Demographic, Personal: Race |
16 | Black or African American | 1 | 114 | 114 | reg_personal.ethnic_code where ethnic_code = 3 (regtb_ethnicity.state_code_equiv) | MD_DISC_DOWN.New_Race_3 | Registration, Entry & Reports, Student Demographic, Personal: Race |
17 | Native Hawaiian or Other Pacific Islander | 1 | 115 | 115 | reg_personal.ethnic_code where ethnic_code = 4 (regtb_ethnicity.state_code_equiv) | MD_DISC_DOWN.New_Race_4 | Registration, Entry & Reports, Student Demographic, Personal: Race |
18 | White | 1 | 116 | 116 | reg_personal.ethnic_code where ethnic_code = 5 (regtb_ethnicity.state_code_equiv) | MD_DISC_DOWN.New_Race_5 | Registration, Entry & Reports, Student Demographic, Personal: Race |
19 | FILLER (Homelessness Status) | 1 | 117 | 117 | |||
20 | Title I Indicator | 1 | 118 | 118 | reg_programs.program_value where reg_program_column.state_code_equiv='MDTitle1' | MD_DISC_DOWN.Title_1 | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Title I |
21 | Free/Reduced Price Meal Eligibility | 1 | 119 | 119 | reg_programs.program_value where reg_program_column.state_code_equiv='MDFARMS' | MD_DISC_DOWN.Free_Reduced_Meal | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Meal Status |
22 | Migrant Status | 1 | 120 | 120 | Reg_personal.migrant | MD_DISC_DOWN.Migrant | Registration, Entry & Reports, Student Demographic, Personal: Migrant |
23 | Filler (Foreign Exchange Student Indicator) | 1 | 121 | 121 | |||
24 | Filler (Special Education (SE) Indicator) | 1 | 122 | 122 | |||
25 | Filler (Special Education End Date) | 8 | 123 | 130 | |||
26 | Filler (Special Education Certificate Status) | 1 | 131 | 131 |
| ||
27 | English Learner (EL) Status | 1 | 132 | 132 | reg_programs.program_value where reg_program_column.state_code_equiv='MDLEP' | MD_DISC_DOWN.LEP | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: English Language Learner |
28 | Filler (English Learner Entry into the US Date) | 8 | 133 | 140 | |||
29 | Filler (English Learner Service Begin Date) | 8 | 141 | 148 | |||
30 | Filler (English Learner Service End Date) | 8 | 149 | 156 | |||
31 | Filler (English Learner ELA Assessment Exempt Status) | 1 | 157 | 157 | |||
32 | Filler (Foster Care Status) | 1 | 158 | 158 |
| ||
33 | Filler (Military Connected Indicator) | 1 | 159 | 159 | |||
34 | Filler (Gifted and Talented Student Indicator | 1 | 160 | 160 |
|
|
|
35 | Filler | 32 | 161 | 192 | |||
36 | Submission Date | 8 | 193 | 200 | Date on which the report is run in eSchoolPlus | MD_DISC_DOWN.Submission_Date |
|
37 | 504 Indicator | 1 | 201 | 201 | reg_programs.program_value where reg_program_column.state_code_equiv='MD504' | MD_DISC_DOWN.MD504_Ind | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: 504 |
38 | Disability Code | 2 | 202 | 203 | reg_programs.program_value where reg_program_column.state_code_equiv='MDDISABL' | MD_DISC_DOWN.Disability | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Disability Code |
39 | Offense Code | 3 | 204 | 206 | disc_incident.incident_code ( its respective state code from disc_incident_code.state_code_equiv) | MD_DISC_DOWN.Offense_Code | Interventions, ALL, Office, Incident Detail, Offenders> Offense Information> Offense |
40 | Date of Offense | 8 | 207 | 214 | disc_incident.incident_date | MD_DISC_DOWN.Offense_Date | Interventions, ALL, Office, Incident Detail: Incident Date |
41 | Disposition Code | 3 | 215 | 217 | If REG_USER_DISTRICT where SCREEN_NUMBER=11000 and FIELD_NUMBER=1 has the date, the disc_off_action.disposition_code (respective state code from disctb_disposition.state_code_equiv) else disc_off_action.action_code (respective state code from disctb_off_action.state_code_equiv) | MD_DISC_DOWN.Disposition_Code | Interventions, ALL, Office, Incident Detail, Offender View Details, Actions: Action Code/Disposition Code |
42 | Length of Removal | 5 | 218 | 222 | disc_off_action.actual_duration | MD_DISC_DOWN.Num_Days | Interventions, ALL, Office, Incident Detail, Offender View Details, Actions: Actual Duration |
43 | Physical Injury | 1 | 223 | 223 | If there is no data in disc_user.field_value where screen_number = 100 and screen_type = 'I' and field_number = 2 then N | MD_DISC_DOWN.Physical_Injury | Interventions, ALL, Office, Incident Detail, Other Incident Information, Maryland State Reporting: Resulted in Physical Injury |
44 | Type of Educational Services Provided | 1 | 224 | 224 | disc_act_user.field_value where screen_number = 100 and screen_type = 'A' and field_number = 1 | MD_DISC_DOWN.Educational_Services | Interventions, ALL, Office, Incident Detail, Offender View Details, Actions, Maryland State Reporting Panel: Educational Services |