Classic View: CO State Reporting > Data Pipeline > School Discipline and Attendance > Firearm (GFSA) Discipline
Search Terms: School Discipline and Attendance
The Firearm (GFSA) Discipline file reports students involved in behavior events who have a Behavior Event State Code of 05: Dangerous Weapon. A record reports for each type of firearm - 01: Handgun, 02: Rifle/Shotgun, 03: Other Firearms, 04: Multiple Firearms - and has a resolution (where appropriate) of 00, 04, 05, 07, 08-11.
Report Logic
A record reports for all students enrolled in the selected calendar who meet the following:
- 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
- The student has a Behavior Event with a State Code of 05: Dangerous Weapon.
- A record reports for each type of firearm (01: Handgun, 02: Rifle/Shotgun, 03: Other Firearms).
- The student has a Behavior Resolution to the Behavior Event of 00, 04, 05, 07, 08-11.
A record and appropriate count reports for each individual student who has an applicable behavior incident where at least one day falls within the reporting period. Students may have more than one record (possibility of 6 total records per students).
If more than one student is tied to an incident, each student reports. See the previous information for rules on reporting multiple event per student.
State Exclude logic is enforced. Students are not reported, even if they meet the above requirements when:
- The Enrollment is marked as State Exclude or No Show
- The Grade level of enrollment is marked as State Exclude
- The selected Calendar is marked as State Exclude.
Report Editor
Data Element | Description |
---|---|
Extract Type | Selection indicates what file generates. For this report, select Firearm (GFSA). |
Type | Indicates whether a Summary report generates or a Detail report generates. |
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, if 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. If 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 Firearm (GFSA) Discipline 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.
- 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.
Report Layout
Data Element | Description | Location |
---|---|---|
District Code | Reports the number assigned to a school district by the state department of education. Numeric, 4 digits | System Administration > Resources > District Information > District Information > State District Number District.number |
School Code | Reports the number assigned to the school building by the state department of education. 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 on the student's most recent enrollment record as of the entered effective date, the end date of report generation, or the most recent enrollment closest to the end date of report generation. For all other students, the student's latest enrollment where the Special Education Start Date is populated and at least one active Special Education date falls within the reporting period or the most recent enrollment closest to the end date of report generation.
| Student Information > General > Enrollments > State Reporting Fields > Serving District Enrollment.serviceDistrict Student Information > General > Enrollments > Special Education Fields > Service Agency/Facility Code Enrollment.serviceFacility Student Information > General > Enrollments > State Reporting Fields > School of Accountability Enrollment.residentSchool System Administration > Resources > School > School Editor > State School Number School.number |
Grade Level | Reports the student's grade level for the action report. Numeric, 3 digits | Student Information > General > Enrollments > General Enrollment Information > Grade Enrollment.grade |
Firearm Weapons | Reports the weapon associated with the event.
Numeric, 2 digits | Behavior > Behavior Event > GFSA Weapon BehaviorEvent.weaponCode |
IDEA/Special Education | Reports a value when the student is considered a Special Education student. A value of 1 reports when:
Otherwise, reports a value of 0. Numeric, 1 digit | Student Information > Special Education > Documents > IEP Student Information > General > Enrollments > Special Ed Fields > Special Ed Start Date, Special Ed Exit Date Enrollment.specialEdStartDate Enrollment.specialEdExitDate Behavior > Behavior > Management > Date of Incident BehaviorEvent.date Behavior > Behavior < Management > Resolution Start Date BehaviorResolution.startDate |
Brought or Possessed at School | Reports the number of students who brought or possessed a firearm while at school (Behavior Event has an Incident Type = 05: Dangerous Weapons). Otherwise, a value of 0 reports. Numeric, 2 digits | Behavior > Behavior Management > Resolution |
Students Expelled | Reports the number of students who were expelled for bringing or possessing firearms to school. Report a value of 1 when:
Otherwise, reports a value of 0. Numeric, 2 digits | Behavior > Behavior Management > Event Type > 05: Dangerous Weapons Behavior > Behavior Management > Resolution |
Students Expelled Less Than One Year | Reports the number of students who were expelled for less than the mandatory one calendar year term. Length of time is determined by the timestamp start date on the Behavior Resolution record and the End Date. If the length of expulsion is less than 364 days, the student is counted. Reports a value of 1 when:
Otherwise, reports a value of 0. Numeric, 2 digits | Behavior > Behavior Management > Event Type > 05: Dangerous Weapons Behavior > Behavior Management > Resolution > 04, 05, 08, 11 |
Students Referred and Expelled Less Than One Year | Reports the number of students expelled for less than the mandatory one calendar year that resulted in a referral to an alternative school or program. Length of time is determined by the timestamp start date on the Behavior Resolution record and the End Date. If the length of expulsion is less than 364 days, the student is counted. Reports a value of 1 when:
Otherwise, reports a value of 0. Numeric, 2 digits | Behavior > Behavior Management > Event Type > 05: Dangerous Weapons Behavior > Behavior Management > Resolution |
Students Expelled at Least One Year | Reports the number of students expelled for at least the mandatory one calendar year. ength of time is determined by the timestamp start date on the Behavior Resolution record and the End Date. If the length of expulsion is less than 364 days, the student is counted. Reports a value of 1 when:
Otherwise, reports a value of 0. Numeric, 2 digits | Behavior > Behavior Management > Event Type > 05: Dangerous Weapons Behavior > Behavior Management > Resolution > 05 |
Students Referred and Expelled At Least One Year | Reports the number of students expelled for the mandatory one calendar year that resulted in a referral to an alternative school or program. Length of time is determined by the timestamp start date on the Behavior Resolution record and the End Date. If the length of expulsion is equal to or more than 364 days, the student is counted. Reports a value of 1 when:
Otherwise, reports a value of 0. Numeric, 2 digits | Behavior > Behavior Management > Event Type > 05: Dangerous Weapons Behavior > Behavior Management > Resolution > 05 |
Students Not Disciplined | Reports the number of students who were not disciplined for firearms brought or possessed at school. Reports a value of 1 when:
Otherwise, reports a value of 0. Numeric, 2 digits | Behavior > Behavior Management > Event Type > 05: Dangerous Weapons Behavior > Behavior Management > Resolution > 00, 10 |
Students Disciplined Other | Reports the number of students where the resolution to the behavior incident resulted in a disciplinary action other than expulsion (i.e., suspension, classroom removal, etc.) for firearms brought or possessed at school. Reports a value of 1 when:
Otherwise, reports a value of 0. Numeric, 2 digits | Behavior > Behavior Management > Event Type > 05: Dangerous Weapons Behavior > Behavior Management > Resolution > 07 |
Students Removed Other | Reports the number of students that resulted in another type of removal from school not listed above (i.e., death, incarcerated, etc.) for firearms brought or possessed at school. Reports a value of 1 when:
Otherwise, reports a value of 0. Numeric, 2 digits | Behavior > Behavior Management > Event Type > 05: Dangerous Weapons Behavior > Behavior Management > Resolution |
LASID | Reports the student's local student number. Numeric 10 digits | Census > People > Demographics > Student Number Person.studentNumber |