Tool Search: School Discipline and Attendance
The Student Demographics File reports ALL students involved in behavior incidents that are reported in the Discipline by Action File. One record reports for each student with an applicable behavior incident and resolution where at least one day falls within the reporting period (Start Date - End Date, entered on the report editor).
School Discipline and Attendance Student Demographics Extract
Read - Access and generate School Discipline and Attendance - Student Demographics.
Write - N/A
Add - N/A
Delete - N/A
For more information about Tool Rights and how they function, see the Tool Rights article.
Data reports for each unique combination in the following categories:
- Race/Ethnicity
- Gender
- Grade Level
- Special Education Involvement
- 504 Status
- ELL Status
The Summary Type reports the total number of students for the specified behavior/allegation type. The Detail Type reports each student's behavior event/resolutions by event.
The Detail Type is NOT in a state-compliant format.
Report Logic
The Summary Report Type reports a record reports for each individual student involved in Behavior Incidents and Behavior Resolutions that report in the Discipline by Action Extract, where at least one day falls within the reporting period. Only one record reports for each student per incident. When there are no discipline incidents for the student, a record is not reported.
When a student has more than one event with a resolution tied to an incident, the resolution that has a value in the Most Serious Action field reports; when that field is not populated, the resolution with the highest eventID (most recently generated). When more than one student is tied to an incident, each student reports.
- Enrollment Service Type is Primary (P), Partial (S) or Special Ed Services (N).
- Grade level of enrollment is 002, 004, 006, 007, 010, 020, 030, 040, 050, 060, 070, 080, 090, 100, 110, 120.
- Behavior Incidents contain Behavior Events with state-mapped resolutions. All events must have a resolution with a mapped resolution in order to report EXCEPT Event Codes 18-22.
- At least one day of the Behavior Incident and resolution must fall within the reporting period.
- The resolution must have occurred in the selected calendar. When a behavior event occurs on the last day of school for the 2021-22 school year, but the resolution was not assigned until the first day of the 2022-23 school year, the record reports when the 2022-23 calendar is selected.
When the role assigned to a participant is Victim, a resolution is NOT required for the following fields:
- Students Reported as Harassed or Bullied on the Basis of Sex (field 24).
- Students Reported as Harassed or Bullied on the Basis of Race or Color of National Origin (field 25).
- Students Reported as Harassed or Bullied on the Basis of Disability (field 26).
All resolutions mapped to a state code of 06:Referred to Law Enforcement are counted, regardless of the Most Severe field being marked. This may cause more than one resolution to report for an incident.
The Detail Report Type uses the same logic, except that it reports ALL resolutions tied to reportable incidents, regardless of when they are marked as Most Serious or not, one line per student for every resolution that reports on the Summary Report Type. This means the counts on the Detail Report Type DO NOT match the counts on the Summary Report Type when an incident includes more than one student.
Students are not included when:
- The enrollment is marked as State Exclude or no show.
- The grade level of enrollment is marked as State Exclude.
- The calendar of enrollment is marked as State Exclude.
Non-Binary Gender Reporting
Schools can assign students a gender of M: Male, F: Female or N: Non-binary. This is done on the Identities tool and/or the Demographics tool.
Data Pipeline Extracts and other required extracts use the Legal Gender field included in the Protected Identity Information to report student identity information.
To properly record a gender of N: Non-Binary, on the Identities tool:
- Assign the Gender of N: Non-Binary in the standard identify fields.
- Assign the Protected Identity Information Legal Gender field to M: Male, F: Female or N: Non-Binary.
- Save the record when finished.
Gender and Legal Gender Assignment
Report Editor
| Data Element | Description |
|---|---|
| Extract Type | Selection indicates what file generates.
|
| Type | Indicates whether a Summary report generates or a Detail report generates. Note that the Detail Type is NOT in a state-compliant format. |
| Start Date |
Indicates the start date by which to report behavior events. At least one day of the Behavior Incident must fall within or on the start and end date.
Dates are entered in mmddyy format or use the calendar icon to select a date. |
| End Date | Indicates the end date by which to report behavior events. At least one day of the Behavior Incident must fall within or on the start and end date.
Dates are entered in mmddyy format or use the calendar icon to select a date. |
| Ad hoc Filter | When chosen, only those students included in the selected ad hoc filter are reported in the extract, when they meet the requirements of the extract. |
| Format | Determines the layout of the report. Choose either CSV or HTML. |
| Calendar Selection | Select at least one calendar from which to report student discipline information. |
| Report Generation | Use the Generate Extract button to display the results of the extract immediately. When there is a larger data set being reported, use the Submit to Batch option to choose when the extract generates (after or before school hours, etc.). See the Batch Queue article for more information. |
Generate the Report
- Select the Student Demographics Extract Type.
- Select either the Summary Report Type or the Detail Report Type.
- Enter a Start Date and End Date.
- If desired, select an Ad hoc Filter to return only students included in that filter.
- Select the desired Format, either CSV or HTML, from the dropdown list.
- Select at least one Calendar from which to report discipline records. Calendars can be chosen by active year, by school name or by year.
- Click the Generate Extract button or the Submit to Batch button. The report displays in the selected format.
Student Demographics - CSV Format
Student Demographics - HTML Format
Report Layout
| Data Elements | Description | Location |
|---|---|---|
| District Code | Reports the State District Number.
Numeric, 4 digits |
District Information > State District Number
District.number |
| School Code | Reports the number assigned to the school building by the state department of education. This value reports from the student's enrollment that was active on the date of the incident. When the student has more than one enrollment that was active on the date of incident, the value reports from the Primary enrollment. When a student has a Special Education Attendance Code of 31: Administrative Unit OR 32: State-Operated Program, the four-digit code reports from the Serving District field. For all other students:
|
Enrollments > State Reporting Fields > Serving District
Enrollment.serviceDistrict Enrollments > Special Education Fields > Service Agency/Facility Code Enrollment.serviceFacility Enrollments > State Reporting Fields > School of Accountability Enrollment.residentSchool School Information > School Editor > State School Number School.number |
| Ethnicity/Race | Reports the student's race/ethnicity code:
Numeric, 2 digits |
Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity |
| Gender | Reports the gender assigned to the student when the Report Legal Gender checkbox is marked.
Numeric, 2 digits |
Demographics > Person Information > Gender Identity.gender |
| Grade Level | Reports the grade level of the student for the reported action.
Numeric, 3 digits |
Enrollments > General Enrollment Information > Grade Enrollment.grade Grade Level Setup > State Grade Level |
| Disability/IDEA Status | Indicates when the record is for an IDEA/Special Education student. Reports a value of 1 when:
Otherwise, reports a value of zero (0). Numeric, 1 digit |
Enrollments > Special Ed Fields > Special Ed Start Date, Special Ed Exit Date Enrollment.spedStartDate Enrollment.spedExitDate Special Education > Documents > IEP Behavior Management > Date of Incident BehaviorEvent.date Behavior Management > Resolution Start Date BehaviorResolution.startDate |
| Section 504 Status | Indicates when the record is for students identified as handicapped under regulations implementing Section 504 of the Rehabilitation Act of 1973, but may or may not be eligible for special education placement under the Individuals with Disabilities Education Act. Reports a value of 1 when there is a Section 504 record at any point during the reporting period. Otherwise, reports a value of zero (0). Numeric, 1 digit |
Program Participation > Section 504 Section504.section504ID |
| LEP Status | Indicates when the record is for a student who was identified as being Limited English Proficient. Reports based on the student's LEP Status as of the time of the incident.
Numeric, 1 digit |
Program > Program Participation > LEP > LEP Lep.lep |
| Unduplicated Count of Students Disciplined | Reports the unduplicated count of students involved in a behavior incident in which the State Behavior Resolution Code is 00-09, 11. When a student has a behavior event with a State Resolution Code of 00-09 and 11, a count of 1 reports. Otherwise, a value of zero (0) reports. Numeric, 1 digit |
Behavior Management > Incident > Events and Participation > Resolution Calculated value |
| Classroom Removals | Reports the total number of students (not incidents) who were removed by the teacher or suspended from the classroom. When a student was removed or suspended multiple times, each time is included in this count. Reports the count of instances when a student has a behavior event with a State Behavior Resolution Code is 01: Classroom Suspension/Teacher Removal marked as Most Serious Resolution. Otherwise, reports a value of zero (0). Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Resolution Calculated value |
| In-School Suspensions | Reports the total number of students (not incidents) who received an in-school suspension. When a student received multiple in-school suspensions, each time is included in this count. Reports a count of instances when a student has a behavior event with a State Behavior Resolution Code is 02: In School Suspension marked as Most Serious Resolution. Otherwise, reports a value of zero (0). Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Resolution Calculated value |
| Received Only One Out-of-School Suspension | Reports the total number of students (not incidents) who received just one out-of-school suspension in the school year. Reports a value of 1 when the student has a behavior event with a State Behavior Resolution Code is 03: Out of School Suspension marked as Most Serious Resolution AND the resolution was assigned to the student only once in the selected calendar year. Otherwise, reports a value of zero (0). Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Resolution Calculated value |
| Received More than One Out-of-School Suspension | Reports the total number of students (not incidents) who received an out-of-school suspension more than once during the school year. Reports a value of 1 when the student has a behavior event with a State Behavior Resolution Code is 03: Out of School Suspension marked as Most Serious Resolution AND the resolution was assigned to the student two or more times in the selected calendar year. Otherwise, reports a value of zero (0). Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Resolution Calculated value |
| Total Out-of-School Suspensions | Reports the total number of students (not incidents) who received an out-of-school suspension. All instances of the student receiving an out-of-school suspension are counted. Reports a value of 1 when the student has a behavior event with a State Behavior Resolution Code is 03: Out of School Suspension marked as Most Serious Resolution. Otherwise, reports a value of zero (0). Numeric, 1 digit |
Behavior Management > Incident > Events and Participation > Resolution Calculated value |
| Expulsions with Educational Services | Reports the total number of students (not incidents) who were expelled and were provided with educational services during the expulsion. Reports the total number of instances when the student has a behavior event with a State Behavior Resolution Code is 04, 05, 08 or 11 marked as Most Serious Resolution AND Services During Expulsion is marked. All occurrences for the student are counted. Otherwise, reports a value of zero (0). Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Resolution Calculated value |
| Expulsions without Educational Services | Reports the total number of students (not incidents) who were expelled and were not provided with educational services during the expulsion. Reports the total number of instances when the student has a behavior event with a State Behavior Resolution Code is 04, 05, 08 or 11 marked as Most Serious Resolution AND Services During Expulsion is not marked. All occurrences for the student are counted. Otherwise, reports a value of zero (0). Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Resolution Calculated value |
| Law Enforcement Referral | Reports the total number of students (not incidents) referred to law enforcement. Each time a student was referred to law enforcement is counted. Reports the total number of instances when the student has a behavior event with a State Behavior Resolution Code is 06: Referred to Law Enforcement for Most Serious Action OR when the student has a behavior event with a State Behavior Resolution Code is 06: Referred to Law Enforcement. Otherwise, reports a value of zero (0). When the State Behavior Resolution Code is 18-22, that event is not included. Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Resolution Calculated value |
| School Related Arrest | Reports the total number of students (not incidents) who were arrested for any activity conducted on the school grounds, during off-campus school activities, or due to a referral by any school official. Reports the total number of instances when the student has a behavior event with a State Behavior Resolution Code AND the School Related Arrest checkbox is marked. Otherwise, reports a value of zero (0). Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Resolution Calculated value |
| Other Action | Reports the total number of students (not incidents) in which another action was taken that has not been counted in any other category. Each other action is included, even when the student has been counted multiple times. Reports the total number of instances when the student has a behavior event with a State Behavior Resolution Code is 07: Other Action Taken or 09: Removal Other, Death, Incarcerated, etc marked as Most Serious Resolution. Otherwise, reports a value of zero (0). The value reported here matches the value reported for the Other Actions field on the Discipline by Action report. Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Resolution Calculated value |
| Transferred To Alternative School | Reports the number of students for each demographic combination who meet all of the following:
Otherwise, reports a value of zero (0). Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Resolution Calculated value |
| Subjected to Mechanical Restraint | Summary Report Type: Reports the sum of students for each demographic combination where the Behavior Event is assigned a Behavior Response code of M. All occurrences for the student are counted. Detail Report Type: Reports a count of Behavior Events assigned a Behavior Response code of M for the reported student. Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Response Details > Response Type = M: Mechanical Restraint Calculated value |
| Subjected to Physical Restraint | Summary Report Type: Reports the sum of students for each demographic combination where the Behavior Event is assigned a Behavior Response code of P. All occurrences for the student are counted. Detail Report Type: Reports a count of Behavior Events assigned a Behavior Response code of P for the reported student. Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Response Details > Response Type = P: Physical Restraint Calculated value |
| Subjected to Seclusion | Summary Report Type: Reports the sum of students for each demographic combination where the Behavior Event is assigned a Behavior Response Code of S. All occurrences for the student are counted. Detail Report Type: Reports a count of Behavior Events assigned a Behavior Response code of S for the reported student. Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Response Details > Response Type = S: Seclusion Calculated value |
| Students Reported as Harassed or Bullied on the Basis of Sex | Summary Report Type: Reports the sum of students for each demographic combination where the Behavior Event has a State Event Code of 18 and the Student Role is Victim. All occurrences for the student are counted. Detail Report Type: Reports a count of Behavior Events that have a State Event Code of 18 and the Student Role is Victim for the reported student. NOTE: For both Report Types, a Behavior Resolution is NOT required for this field. Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Participant Details > Role = V: Victim Behavior Event Types > State Event Code = 18: Allegations of harassment or bullying on the basis of sex Calculated value |
| Students Reported as Harassed or Bullied on the Basis of Race or Color or National Origin | Summary Report Type: Reports the sum of students for each demographic combination where the Behavior Event has a State Event Code of 19 and the Student Role is Victim. All occurrences for the student are counted. Detail Report Type: Reports a count of Behavior Events that have a State Event Code of 19 and the Student Role is Victim for the reported student. NOTE: For both Report Types, a Behavior Resolution is NOT required for this field. Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Participant Details > Role = V: Victim Behavior Event Types > State Event Code = 19: Allegations of harassment or bullying on the basis of race, color or national origin Calculated value |
| Students Reported as Harassed or Bullied on the Basis of Disability | Summary Report Type: Reports the sum of students for each demographic combination where the Behavior Event has a State Event Code of 20 and the Student Role is Victim. All occurrences for the student are counted. Detail Report Type: Reports a count of Behavior Events that have a State Event Code of 20 and the Student Role is Victim for the reported student. NOTE: For both Report Types, a Behavior Resolution is NOT required for this field. Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Participant Details > Role = V: Victim Behavior Event Types > State Event Code = 20: Allegations of harassment or bullying on the basis of disability Calculated value |
| Students Disciplined for Bullying or Harassment on the Basis of Sex | Summary Report Type: Reports the sum of students for each demographic combination where the Behavior Event has a State Event Code of 18 and the Student Role is Offender. All occurrences for the student are counted. Detail Report Type: Reports a count of Behavior Events that have a State Event Code of 18 and the Student Role is Offender for the reported student. Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Participant Details > Role = O: Offender Behavior Event Types > State Event Code = 18: Allegations of harassment or bullying on the basis of sex Calculated value |
| Students Disciplined for Bullying or Harassment on the Basis of Race or Color or National Origin | Summary Report Type: Reports the sum of students for each demographic combination where the Behavior Event has a State Event Code of 19 and the Student Role is Offender. All occurrences for the student are counted. Detail Report Type: Reports a count of Behavior Events that have a State Event Code of 19 and the Student Role is Offender for the reported student. Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Participant Details > Role = O: Offender Behavior Event Types > State Event Code = 19: Allegations of harassment or bullying on the basis of race, color or national origin Calculated value |
| Students Disciplined for Bullying or Harassment on the Basis of Disability | Summary Report Type: Reports the sum of students for each demographic combination where the Behavior Event has a State Event Code of 20 and the Student Role is Offender. All occurrences for the student are counted. Detail Report Type: Reports a count of Behavior Events that have a State Event Code of 20 and the Student Role is Offender for the reported student. Numeric, 4 digits |
Behavior Management > Incident > Events and Participation > Participant Details > Role = O: Offender Behavior Event Types > State Event Code = 20: Allegations of harassment or bullying on the basis of disability Calculated value |
| LASID | Reports the student's local student number. Numeric, 10 digits |
Demographics > Student Number Person.studentNumber |
| Incident ID | Reports the incident ID. This field only reports on the Detail Type Report. Numeric, 10 digits |
Behavior Management > Incident ID BehaviorIncident.incidentID |
| Most Serious | When the Resolution being reported is marked as Most Serious, this field reports Yes. Otherwise, this field reports No. This field only reports on the Detail Type Report. Alphanumeric, Yes or No |
Behavior Management > Most Serious Action BehaviorIncident.mostSeriousAction |
