Firearm (GFSA) Discipline File – School Discipline and Attendance (2023-24)

Introduction

The Firearms (GFSA) Discipline File reports incidents as required by the Gun-Free Schools Act.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Incident Management Record Selection

The report selects records from Incident Management based on the following criteria:

The student (Offender) is not flagged as Exclude from State Reporting.
The school is not flagged as Exclude from State Reporting.
The Incident Date falls between the user-selected start and end dates.
The Incident is associated with a school.
The Incident Behavior and Action Codes are State Reportable^, and are both related to GFSA.
The Incident has at least one Offender.
The Behavior is assigned to the Offender(s).
The Action is associated with the Behavior.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Schools to Include	Select Multiple Schools using Ctrl+Click to select multiple schools or Shift+Click to select a range of schools or All Schools. School selection will only be available when at District Office.
Select Start Date*	Enter the starting date of the date range for the report.
Select End Date*	Enter the ending date of the date range for the report.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Field Length
1	District Code	The district number.	[Prefs]value [Prefs]name=districtnumber	4
2	School Code	The reporting school number.	[Schools]Alternate_School_Number [Schools]School_Number	4
3	Grade Level	The grade level for action(s) reported.	[Students]Grade_Level [S_CO_STU_X]Kindergarten [ReEnrollments]Grade_Level [S_CO_REN_X]Kindergarten	3
4	Firearm Weapons	The weapon associated with the incident. Note: The report has been updated and will now correctly report incidents with the Multiple Firearms (04) behavior code.	A custom State Reporting SQL View obtains data from Students and Incident Management tables. The [Incident_CO_BehaviorAction]Behavior_Code is obtained from the SQL Table below: [Incident_Lu_Sub_Code]Lu_Sub_Code_ID (subcodes: 100050-100052).	2
5	IDEA/Special Education	Indicates if the record is for IDEA/Special Education students.	Aggregate function derived from the custom view: [Incident_CO_BehaviorAction]	1
6	Brought or Possessed at School	Number of students who brought or possessed firearms	Aggregate function derived from the custom view: [Incident_CO_BehaviorAction]	2
7	Students Expelled	Number of students expelled for firearms brought to or possessed at school	Aggregate function derived from the custom view: [Incident_CO_BehaviorAction]	2
8	Students Expelled Less Than One Year	Number of students expelled for less than the mandatory once calendar year term.	Aggregate function derived from the custom view: [Incident_CO_BehaviorAction]	2
9	Students Referred and Expelled Less Than One Year	Number of students expelled for less than the mandatory one calendar year that resulted in a referral to an alternative school or program.	Aggregate function derived from the custom view: [Incident_CO_BehaviorAction]	2
10	Students Expelled At Least One Year	Number of students expelled for less than the mandatory once calendar year term.	Aggregate function derived from the custom view: [Incident_CO_BehaviorAction]	2
11	Students Referred and Expelled At Least One Year	Number of students expelled for the mandatory one calendar year term that resulted in a referral to an alternative school or program	Aggregate function derived from the custom view: [Incident_CO_BehaviorAction]	2
12	Students Not Disciplined	The students not disciplined for firearms brought or possessed at school.	Aggregate function derived from the custom view: [Incident_CO_BehaviorAction]	2
13	Students Disciplined Other	Number of students resulted in a disciplinary action other than expulsion (i.e. suspension, classroom removal, etc.) for firearms brought or possessed at school.	Aggregate function derived from the custom view: [Incident_CO_BehaviorAction]	2
14	Students Removed Other	Number of students resulted in another type of removal from school not listed above (i.e. death, incarcerated, etc.) for firearms brought or possessed at school.	Aggregate function derived from the custom view: [Incident_CO_BehaviorAction]	2

Back to Top