![](media/image1.png){width="3.5in" height="3.5in"}

U.S. DEPARTMENT OF EDUCATION

Education Data Exchange Network (EDEN)

**N094 - Firearm Incidents File Specifications**

**Version 2.1**

**(New for 2005-06)**

**September 2006**

This technical guide was produced under U.S. Department of Education
Contract No. GS00F0049M-ED05P01299 with Perot Systems Government
Services, Inc. Brandon Scott served as the contracting officer's
representative. No official endorsement by the U.S. Department of
Education of any product, commodity, service or enterprise mentioned in
this publication is intended or should be inferred.

**U.S. Department of Education**

Margaret Spellings

*Secretary*

**Office of Planning, Evaluation and Policy Development**

Tom Luce

*Assistant Secretary*

![](media/image2.wmf){width="0.6507874015748032in"
height="9.803149606299212e-2in"}

September 2006

This technical guide is in the public domain. Authorization to reproduce
it in whole or in part is granted. While permission to reprint this
publication is not necessary, the citation should be: U.S. Department of
Education, Office of Planning, Evaluation and Policy Development,
Strategic Accountability Service, *N094 -- Firearm Incidents File
Specifications*, Washington, D.C., 2006.

This technical guide is also available on the Department's Web site at:
[http://www.ed.gov/about/inits/ed/pbdmi/index.html
.](http://www.ed.gov/about/inits/ed/pbdmi/index.html)

On request, this publication is available in alternate formats, such as
Braille, large print, or computer diskette. For more information, please
contact the Department's Alternate Format Center at (202) 260-0852 or
(202) 260-0818.

[]{#__RefHeading___Toc146013368 .anchor}DOCUMENT CONTROL

DOCUMENT INFORMATION

  --------------- ---------------------------------------------------------
  **Title:**      N094 -- Firearm Incidents File Specifications

  **Revision:**   Version 2.1

  **Issue Date:** September 2006

  **Security      Unclassified
  Level:**        

  **Filename:**   371831.doc
  --------------- ---------------------------------------------------------

DOCUMENT HISTORY

+--------+-------------+-------+--------------------------------------+
| **V    | **Date**    | **    | **Summary of Change**                |
| ersion |             | Resp\ |                                      |
| Nu     |             | In    |                                      |
| mber** |             | divid |                                      |
|        |             | ual** |                                      |
+--------+-------------+-------+--------------------------------------+
| 2.1    | September   |       | -   Changed data element name        |
|        | 2006        |       |     "Student Count" to "Incident     |
|        |             |       |     Count"                           |
+--------+-------------+-------+--------------------------------------+
|        |             |       |                                      |
+--------+-------------+-------+--------------------------------------+
|        |             |       |                                      |
+--------+-------------+-------+--------------------------------------+

RELEASE AUTHORIZATION

  ----------------------- -----------------------------------------------
  **Name**                **Signature / Date**

  **Author**              

  **QA**                  

  **Release Authority**   
  ----------------------- -----------------------------------------------

[]{#__RefHeading___Toc146013369 .anchor}PREFACE

This document provides technical instructions for building files that
can be submitted through the Education Data Exchange Network (EDEN).
This document is used in coordination with the EDEN Workbook and the
EDEN Submission System User Guide.

EDEN is a centralized, coordinated repository of state reported, K-12,
educational data residing at the U.S. Department of Education. The EDEN
Submission System is an electronic system that facilitates the efficient
and timely transmission of data from SEAs to the U.S. Department of
Education.

Contents

[DOCUMENT CONTROL ii](#__RefHeading___Toc146013368)

[PREFACE iii](#__RefHeading___Toc146013369)

[1.0 Purpose 1](#purpose)

[1.1 Changes from 03-04 and 04-05 File Specifications
1](#changes-from-03-04-and-04-05-file-specifications)

[1.2 Requirements for Submitting this Data Group
1](#requirements-for-submitting-this-data-group)

[2.0 File Naming Convention 1](#file-naming-convention)

[3.0 Guidance for Submitting This File
2](#guidance-for-submitting-this-file)

[4.0 State Education Agency Firearm Incidents File
3](#state-education-agency-firearm-incidents-file)

[4.1 Header Record Definition 3](#header-record-definition)

[4.2 Data Record Definition 4](#data-record-definition)

[4.3 SEA Firearm Incidents File Examples
6](#sea-firearm-incidents-file-examples)

[4.3.1 Partial Record Sample for Fixed Format SEA Firearm Incidents File
6](#partial-record-sample-for-fixed-format-sea-firearm-incidents-file)

[4.3.2 Partial Record Sample for Comma-Delimited File Format SEA Firearm
Incidents File
7](#partial-record-sample-for-comma-delimited-file-format-sea-firearm-incidents-file)

[4.3.3 Partial Record Sample for Tab-Delimited File Format SEA Firearm
Incidents File
8](#partial-record-sample-for-tab-delimited-file-format-sea-firearm-incidents-file)

[5.0 Local Education Agency Firearm Incidents File
9](#local-education-agency-firearm-incidents-file)

[5.1 Header Record Definition 9](#header-record-definition-1)

[5.2 Data Record Definition 10](#data-record-definition-1)

[5.3 LEA Firearm Incidents File Example
13](#lea-firearm-incidents-file-example)

[5.3.1 Partial Record Sample for Fixed Format LEA Firearm Incidents File
13](#partial-record-sample-for-fixed-format-lea-firearm-incidents-file)

[5.3.2 Partial Record Sample for Comma-Delimited File Format LEA Firearm
Incidents File
14](#partial-record-sample-for-comma-delimited-file-format-lea-firearm-incidents-file)

[5.3.3 Partial Record Sample for Tab-Delimited File Format LEA Firearm
Incidents File
15](#partial-record-sample-for-tab-delimited-file-format-lea-firearm-incidents-file)

# Purpose

This document contains instructions for building fixed and delimited
files to submit EDEN Data Group: Firearm Incidents Table, ID #601.

A separate document contains the XML file formats. General guidance for
constructing all EDEN file types may be found in the *Education Data
Exchange Network (EDEN) Workbook.*

This data group is used to fulfill a portion of the Gun-Free Schools Act
Report as required by Part A, Subpart 3, under Title IV of the
Elementary and Secondary Education Act (ESEA) of 1965, as amended (20
U.S.C. 7151).

## Changes from 03-04 and 04-05 File Specifications

There have been significant changes to this file specification.

-   Changed data element name "Student Count" to "Incident Count"

## Requirements for Submitting this Data Group

The data group is submitted at the following levels:

-   SEA

-   LEA -- for all LEAs that have students

The following table indicates the valid combinations of categories and
the sub-totals and/or totals needed for this file. An "X" in the column
indicates that the column must be populated when reporting that
particular category. The total indicator must be either "Y" (Yes) or "N"
(No). If the record is for a detail count, specify an "N" (No). If the
record is for a subtotal or grand total, specify a "Y" (Yes).

Table 1.2-1: Firearm Incidents Table, Required Categories, and
Applicable Totals

  --------------------------- ---------- ------------- ----------------------
  **Table Name**              **Weapon   **Total       **Comments**
                              Type**     Indicator**   

  **FIREARMINCDNT**           X          N             
  --------------------------- ---------- ------------- ----------------------

# File Naming Convention

Being able to readily identify any particular file transmission is an
important consideration for users of the EDEN Data Submission System.
Being able to identify a particular file can greatly facilitate any
technical assistance that may be requested by the State. A maximum of 25
characters (including the file extension) is allowed for the file name.
The following is the naming convention for Firearm Incidents file
submissions:

sslev**FRAMNCDNT**vvvvvvv.ext

Where:

> **ss** = Two-character USPS State Abbreviation for the submitting SEA.
>
> **lev** = Three-character abbreviation for the level submitted. Use:
>
> SEA for a State Education Agency Firearm Incidents submission
>
> LEA for a Local Education Agency Firearm Incidents submission
>
> **Filename** = **FRAMNCDNT** (no more than nine digits)
>
> **vvvvvvv** = Up to seven-character alphanumeric string designated by
> the SEA to uniquely identify the individual submission (e.g., ver0001,
> v010803)
>
> **.ext** = Three-character file extension identifying the file format
> as follows:

.txt = fixed format

.csv = comma-delimited format

.tab = tab-delimited format

**NOTE:** For additional information on file naming conventions, refer
to the *Educational Data Exchange Network (EDEN) Workbook*.

# Guidance for Submitting This File

This file only reports incidents, not students. The number of students
involved with firearms is reported in the related file N086 -- Children
Involved with Firearms.

Any incident in which a student was found to have brought a firearm to
school or possessed a firearm at school should be reported, even if the
expulsion is shortened or no penalty is imposed. Any incidents in which
a student covered by the provisions of IDEA brought a firearm to school
or possessed a firearm at school should also be included, even if it is
determined that the incident is a manifestation of the student's
disability. A firearm, other than a handgun, rifle, or shotgun, is
defined under 18 U.S.C. 921. That definition is provided under the
"Other" value under Weapon Type.

Fields that are defined as "Number" can contain values with leading
zeros or without leading zeros. Additionally, when submitting fixed
format files, "Number" fields can be either right or left justified.
This applies to the following fields:

-   "Total Records in File" in the Header

-   "File Record Number" in the Data Record

-   "Count" fields in the Data Record, i.e., Teacher Count, Incident
    Count

# State Education Agency Firearm Incidents File

This section describes the fixed file and delimited file specifications
used to transmit information pertaining to the SEA Firearm Incidents
File. The file type is specified in the header record.

## Header Record Definition

The header record is required and is the first record in every file
submitted to the EDEN Submission System. The purpose of the header
record is to provide information as to the file type, number of Data
Records in the file, file name, file identifier, and file reporting
period.

Section 4.3 contains examples of the header record.

Table 4.1-1: Firearm Incidents, SEA Header Record

+-------+----+---+----+-------+--------------------------+-----------+
| **D   | ** | * | ** | *     | **Definition /           | **        |
| ata** | St | * | Ty | *(M)a | Comments**               | Permitted |
|       | ar | L | pe | ndato |                          | Values**  |
| *     | t\ | e | ** | ry/** |                          |           |
| *Elem | Po | n |    |       |                          |           |
| ent** | si | g |    | **(O  |                          |           |
|       | ti | t |    | )ptio |                          |           |
| **N   | on | h |    | nal** |                          |           |
| ame** | ** | * |    |       |                          |           |
|       |    | * |    |       |                          |           |
+=======+====+===+====+=======+==========================+===========+
| File  | 1  | 5 | St | M     | Identifies the type of   | **SEA     |
| Type  |    | 0 | ri |       | file being submitted.    | FIREARM   |
|       |    |   | ng |       |                          | IN        |
|       |    |   |    |       |                          | CIDENTS** |
+-------+----+---+----+-------+--------------------------+-----------+
| Total | 51 | 1 | Nu | M     | The total number of Data |           |
| Re    |    | 0 | mb |       | Records contained in the |           |
| cords |    |   | er |       | file. The header record  |           |
| In    |    |   |    |       | is NOT included in this  |           |
| File  |    |   |    |       | count.                   |           |
+-------+----+---+----+-------+--------------------------+-----------+
| File  | 61 | 2 | St | M     | File Name and extension  |           |
| Name  |    | 5 | ri |       | are provided by the SEA. |           |
| (Incl |    |   | ng |       | The file name should be  |           |
| uding |    |   |    |       | the same as the external |           |
| file  |    |   |    |       | file name. (Please see   |           |
| exten |    |   |    |       | *File Naming Convention* |           |
| sion) |    |   |    |       | in Section 2.0 of this   |           |
|       |    |   |    |       | document.)               |           |
+-------+----+---+----+-------+--------------------------+-----------+
| File  | 86 | 3 | St | M     | Any combination of       |           |
| Ident |    | 2 | ri |       | standard characters to   |           |
| ifier |    |   | ng |       | further identify the     |           |
|       |    |   |    |       | file as specified by the |           |
|       |    |   |    |       | SEA, e.g., a date,       |           |
|       |    |   |    |       | person's name, version   |           |
|       |    |   |    |       | number.                  |           |
+-------+----+---+----+-------+--------------------------+-----------+
| File  | 1  | 9 | St | M     | Enter the Academic       |           |
| Repo  | 18 |   | ri |       | School Year for which    |           |
| rting |    |   | ng |       | data is being reported.  |           |
| P     |    |   |    |       | The required format for  |           |
| eriod |    |   |    |       | entering the File        |           |
|       |    |   |    |       | Reporting Period is      |           |
|       |    |   |    |       | \"CCYY-CCYY\" or \"CCYY  |           |
|       |    |   |    |       | CCYY\", where either a   |           |
|       |    |   |    |       | hyphen or a space must   |           |
|       |    |   |    |       | separate the beginning   |           |
|       |    |   |    |       | and ending years, e.g.,  |           |
|       |    |   |    |       | 2005-2006 or 2005 2006.  |           |
+-------+----+---+----+-------+--------------------------+-----------+
| F     | 1  | 2 | St | M     | Leave filler field       |           |
| iller | 27 | 6 | ri |       | blank.                   |           |
|       |    | 4 | ng |       |                          |           |
+-------+----+---+----+-------+--------------------------+-----------+
| Car   | 3  | 1 |    | M     |                          |           |
| riage | 91 |   |    |       |                          |           |
| R     |    |   |    |       |                          |           |
| eturn |    |   |    |       |                          |           |
| /Line |    |   |    |       |                          |           |
| Feed  |    |   |    |       |                          |           |
| (     |    |   |    |       |                          |           |
| CRLF) |    |   |    |       |                          |           |
+-------+----+---+----+-------+--------------------------+-----------+

## Data Record Definition

Data Records are required and immediately follow the header record in
every file submitted to the EDEN Submission System. Data Records provide
counts for the specified categories as well as sub-totals and grand
totals.

Section 4.3 contains examples of Data Records.

Table 4.2-1: Firearm Incidents, SEA Data Record

+-------+----+----+----+-------+------------------+------------------+
| **D   | ** | ** | ** | *     | **Definition /   | **Permitted      |
| ata** | St | Le | Ty | *(M)a | Comments**       | Values**         |
|       | ar | ng | pe | ndato |                  |                  |
| *     | t\ | th | ** | ry/** |                  |                  |
| *Elem | Po | ** |    |       |                  |                  |
| ent** | si |    |    | **(O  |                  |                  |
|       | ti |    |    | )ptio |                  |                  |
| **N   | on |    |    | nal** |                  |                  |
| ame** | ** |    |    |       |                  |                  |
+=======+====+====+====+=======+==================+==================+
| File  | 1  | 6  | Nu | M     | A sequential     |                  |
| R     |    |    | mb |       | number assigned  |                  |
| ecord |    |    | er |       | by the State     |                  |
| N     |    |    |    |       | that is unique   |                  |
| umber |    |    |    |       | to each row      |                  |
|       |    |    |    |       | entry within the |                  |
|       |    |    |    |       | file.            |                  |
+-------+----+----+----+-------+------------------+------------------+
| **ID  | 7  | 2  | St | M     | The two-digit    | For a list of    |
| 559\  |    |    | ri |       | Federal          | valid FIPS State |
| *     |    |    | ng |       | Information      | Codes, refer to  |
| *FIPS |    |    |    |       | Processing       | the *EDEN        |
| State |    |    |    |       | Standards (FIPS) | Workbook*.       |
| Code  |    |    |    |       | for the state,   |                  |
|       |    |    |    |       | District of      |                  |
|       |    |    |    |       | Columbia, and    |                  |
|       |    |    |    |       | the possessions  |                  |
|       |    |    |    |       | and freely       |                  |
|       |    |    |    |       | associated areas |                  |
|       |    |    |    |       | of the United    |                  |
|       |    |    |    |       | States (e.g.,    |                  |
|       |    |    |    |       | Puerto Rico).    |                  |
+-------+----+----+----+-------+------------------+------------------+
| **ID  | 9  | 2  | St | M     | A number used in | **01** = State   |
| 570\  |    |    | ri |       | EDEN to uniquely | Education        |
| **    |    |    | ng |       | identify state   | Agency           |
| State |    |    |    |       | agencies. This   |                  |
| A     |    |    |    |       | ID cannot be     |                  |
| gency |    |    |    |       | updated through  |                  |
| N     |    |    |    |       | this file.       |                  |
| umber |    |    |    |       |                  |                  |
+-------+----+----+----+-------+------------------+------------------+
| F     | 11 | 14 | St | M     | Leave filler     |                  |
| iller |    |    | ri |       | field blank.     |                  |
|       |    |    | ng |       |                  |                  |
+-------+----+----+----+-------+------------------+------------------+
| F     | 25 | 20 | St | M     | Leave filler     |                  |
| iller |    |    | ri |       | field blank.     |                  |
|       |    |    | ng |       |                  |                  |
+-------+----+----+----+-------+------------------+------------------+
| Table | 45 | 20 | St | M     | The number of    | *                |
| Name  |    |    | ri |       | incidents        | *FIREARMINCDNT** |
|       |    |    | ng |       | involving a      |                  |
|       |    |    |    |       | firearm.         |                  |
+-------+----+----+----+-------+------------------+------------------+
| W     | 65 | 50 | St | M     | The type of      | **HANDGUNS** -   |
| eapon |    |    | ri |       | weapon.          | Handguns         |
| Type  |    |    | ng |       |                  |                  |
|       |    |    |    |       |                  | **RIFLESHOTGUN** |
|       |    |    |    |       |                  | -- Rifles /      |
|       |    |    |    |       |                  | Shotguns         |
|       |    |    |    |       |                  |                  |
|       |    |    |    |       |                  | **MULTIPLE** --  |
|       |    |    |    |       |                  | More than one    |
|       |    |    |    |       |                  | type of weapon   |
|       |    |    |    |       |                  | or firearm.      |
|       |    |    |    |       |                  |                  |
|       |    |    |    |       |                  | **OTHER** -- As  |
|       |    |    |    |       |                  | defined in 18    |
|       |    |    |    |       |                  | USC 921,         |
|       |    |    |    |       |                  | including any    |
|       |    |    |    |       |                  | weapon           |
|       |    |    |    |       |                  | (including a     |
|       |    |    |    |       |                  | starter gun)     |
|       |    |    |    |       |                  | which will or is |
|       |    |    |    |       |                  | designed to or   |
|       |    |    |    |       |                  | may readily be   |
|       |    |    |    |       |                  | converted to     |
|       |    |    |    |       |                  | expel a          |
|       |    |    |    |       |                  | projectile by    |
|       |    |    |    |       |                  | the action of    |
|       |    |    |    |       |                  | any explosive;   |
|       |    |    |    |       |                  | the frame or     |
|       |    |    |    |       |                  | receiver of      |
|       |    |    |    |       |                  | handguns and     |
|       |    |    |    |       |                  | rifles/shotguns; |
|       |    |    |    |       |                  | any firearm      |
|       |    |    |    |       |                  | muffler or       |
|       |    |    |    |       |                  | firearm          |
|       |    |    |    |       |                  | silencer; any    |
|       |    |    |    |       |                  | destructive      |
|       |    |    |    |       |                  | device, which    |
|       |    |    |    |       |                  | includes (a) any |
|       |    |    |    |       |                  | explosive,       |
|       |    |    |    |       |                  | incendiary or    |
|       |    |    |    |       |                  | poison gas, (1)  |
|       |    |    |    |       |                  | bomb, (2)        |
|       |    |    |    |       |                  | grenade, (3)     |
|       |    |    |    |       |                  | rocket having a  |
|       |    |    |    |       |                  | propellant       |
|       |    |    |    |       |                  | charge of more   |
|       |    |    |    |       |                  | than four        |
|       |    |    |    |       |                  | ounces, (4)      |
|       |    |    |    |       |                  | missile having   |
|       |    |    |    |       |                  | an explosive or  |
|       |    |    |    |       |                  | incendiary       |
|       |    |    |    |       |                  | charge of more   |
|       |    |    |    |       |                  | than one-quarter |
|       |    |    |    |       |                  | ounce, (5) mine, |
|       |    |    |    |       |                  | or (6) similar   |
|       |    |    |    |       |                  | device; (b) any  |
|       |    |    |    |       |                  | weapon which     |
|       |    |    |    |       |                  | will or which    |
|       |    |    |    |       |                  | may readily      |
|       |    |    |    |       |                  | converted to,    |
|       |    |    |    |       |                  | expel a          |
|       |    |    |    |       |                  | projectile by    |
|       |    |    |    |       |                  | the action of an |
|       |    |    |    |       |                  | explosive or     |
|       |    |    |    |       |                  | other            |
|       |    |    |    |       |                  | propellant, and  |
|       |    |    |    |       |                  | which has any    |
|       |    |    |    |       |                  | barrel with a    |
|       |    |    |    |       |                  | bore of more     |
|       |    |    |    |       |                  | than one-half    |
|       |    |    |    |       |                  | inch in          |
|       |    |    |    |       |                  | diameter; (c)    |
|       |    |    |    |       |                  | any combination  |
|       |    |    |    |       |                  | or parts either  |
|       |    |    |    |       |                  | designed or      |
|       |    |    |    |       |                  | intended for use |
|       |    |    |    |       |                  | in converting    |
|       |    |    |    |       |                  | any device into  |
|       |    |    |    |       |                  | any destructive  |
|       |    |    |    |       |                  | device, and from |
|       |    |    |    |       |                  | which a          |
|       |    |    |    |       |                  | destructive      |
|       |    |    |    |       |                  | device may be    |
|       |    |    |    |       |                  | readily          |
|       |    |    |    |       |                  | assembled.\      |
|       |    |    |    |       |                  | **MISSING**\     |
|       |    |    |    |       |                  | **NOTCOLLECT**   |
|       |    |    |    |       |                  | -- Not Collected |
+-------+----+----+----+-------+------------------+------------------+
| F     | 1  | 50 | St | M     | Leave filler     |                  |
| iller | 15 |    | ri |       | field blank.     |                  |
|       |    |    | ng |       |                  |                  |
+-------+----+----+----+-------+------------------+------------------+
| F     | 1  | 15 | St | M     | Leave filler     |                  |
| iller | 65 |    | ri |       | field blank.     |                  |
|       |    |    | ng |       |                  |                  |
+-------+----+----+----+-------+------------------+------------------+
| Total | 1  | 1  | St | M     | An indicator     | **N** =          |
| Indi  | 80 |    | ri |       | that defines the | specifies detail |
| cator |    |    | ng |       | count level      | level            |
|       |    |    |    |       | (i.e., detail    |                  |
|       |    |    |    |       | level, subtotal  |                  |
|       |    |    |    |       | level or grand   |                  |
|       |    |    |    |       | total level).    |                  |
+-------+----+----+----+-------+------------------+------------------+
| E     | 1  | 2  | St | O     | Submitted files  |                  |
| xplan | 81 | 00 | ri |       | will be          |                  |
| ation |    |    | ng |       | processed        |                  |
|       |    |    |    |       | through various  |                  |
|       |    |    |    |       | edit checks.     |                  |
|       |    |    |    |       | When unusual     |                  |
|       |    |    |    |       | conditions are   |                  |
|       |    |    |    |       | detected,        |                  |
|       |    |    |    |       | warning errors   |                  |
|       |    |    |    |       | may be issued,   |                  |
|       |    |    |    |       | even though the  |                  |
|       |    |    |    |       | data may be      |                  |
|       |    |    |    |       | valid. When this |                  |
|       |    |    |    |       | occurs, an       |                  |
|       |    |    |    |       | explanation      |                  |
|       |    |    |    |       | responding to    |                  |
|       |    |    |    |       | the warning may  |                  |
|       |    |    |    |       | be submitted     |                  |
|       |    |    |    |       | with the data,   |                  |
|       |    |    |    |       | or after files   |                  |
|       |    |    |    |       | have been        |                  |
|       |    |    |    |       | processed. The   |                  |
|       |    |    |    |       | Department of    |                  |
|       |    |    |    |       | Education will   |                  |
|       |    |    |    |       | verify           |                  |
|       |    |    |    |       | explanations,    |                  |
|       |    |    |    |       | and after        |                  |
|       |    |    |    |       | verification,    |                  |
|       |    |    |    |       | accept the data. |                  |
+-------+----+----+----+-------+------------------+------------------+
| Inc   | 3  | 10 | Nu | M     | If the count     |                  |
| ident | 81 |    | mb |       | provided is      |                  |
| Count |    |    | er |       | either a         |                  |
|       |    |    |    |       | subtotal or      |                  |
|       |    |    |    |       | grand total, it  |                  |
|       |    |    |    |       | must be equal to |                  |
|       |    |    |    |       | or greater than  |                  |
|       |    |    |    |       | the sum of its   |                  |
|       |    |    |    |       | parts.           |                  |
+-------+----+----+----+-------+------------------+------------------+
| Car   | 3  | 1  |    | M     |                  |                  |
| riage | 91 |    |    |       |                  |                  |
| R     |    |    |    |       |                  |                  |
| eturn |    |    |    |       |                  |                  |
| /Line |    |    |    |       |                  |                  |
| Feed  |    |    |    |       |                  |                  |
| (     |    |    |    |       |                  |                  |
| CRLF) |    |    |    |       |                  |                  |
+-------+----+----+----+-------+------------------+------------------+

## SEA Firearm Incidents File Examples

### Partial Record Sample for Fixed Format SEA Firearm Incidents File

The following text shows a portion of the header row and data rows.

### Partial Record Sample for Comma-Delimited File Format SEA Firearm Incidents File

The following text shows a portion of the header row and data rows.[^1]

### Partial Record Sample for Tab-Delimited File Format SEA Firearm Incidents File

The following text below shows a portion of the header row and data
rows.[^2]

# Local Education Agency Firearm Incidents File 

This section describes the fixed file and delimited file specifications
used to transmit information pertaining to the LEA Firearm Incidents
File. The file type is specified in the header record.

## Header Record Definition

The header record is required and is the first record in every file
submitted to the EDEN Submission System. The purpose of the header
record is to provide information as to the file type, number of Data
Records in the file, file name, file identifier, and file reporting
period.

See Section 5.3 for examples of the header record.

Table 5.1-1: Firearm Incidents, LEA Header Record

+-------+----+----+----+-------+-------------------------+-----------+
| **D   | ** | ** | ** | *     | **Definition /          | **        |
| ata** | St | Le | Ty | *(M)a | Comments**              | Permitted |
|       | ar | ng | pe | ndato |                         | Values**  |
| *     | t\ | th | ** | ry/** |                         |           |
| *Elem | Po | ** |    |       |                         |           |
| ent** | si |    |    | **(O  |                         |           |
|       | ti |    |    | )ptio |                         |           |
| **N   | on |    |    | nal** |                         |           |
| ame** | ** |    |    |       |                         |           |
+=======+====+====+====+=======+=========================+===========+
| File  | 1  | 50 | St | M     | Identifies the type of  | **LEA     |
| Type  |    |    | ri |       | file being submitted.   | FIREARM   |
|       |    |    | ng |       |                         | IN        |
|       |    |    |    |       |                         | CIDENTS** |
+-------+----+----+----+-------+-------------------------+-----------+
| Total | 51 | 10 | Nu | M     | The total number of     |           |
| Re    |    |    | mb |       | Data Records contained  |           |
| cords |    |    | er |       | in the file. The header |           |
| In    |    |    |    |       | record is NOT included  |           |
| File  |    |    |    |       | in this count.          |           |
+-------+----+----+----+-------+-------------------------+-----------+
| File  | 61 | 25 | St | M     | File Name and extension |           |
| Name  |    |    | ri |       | are provided by the     |           |
| (Incl |    |    | ng |       | SEA. The file name      |           |
| uding |    |    |    |       | should be the same as   |           |
| file  |    |    |    |       | the external file name. |           |
| exten |    |    |    |       | (Please see *File       |           |
| sion) |    |    |    |       | Naming Convention* in   |           |
|       |    |    |    |       | Section 2.0 of this     |           |
|       |    |    |    |       | document.)              |           |
+-------+----+----+----+-------+-------------------------+-----------+
| File  | 86 | 32 | St | M     | Any combination of      |           |
| Ident |    |    | ri |       | standard characters to  |           |
| ifier |    |    | ng |       | further identify the    |           |
|       |    |    |    |       | file as specified by    |           |
|       |    |    |    |       | the SEA, e.g., a date,  |           |
|       |    |    |    |       | person's name, version  |           |
|       |    |    |    |       | number.                 |           |
+-------+----+----+----+-------+-------------------------+-----------+
| File  | 1  | 9  | St | M     | Enter the Academic      |           |
| Repo  | 18 |    | ri |       | School Year for which   |           |
| rting |    |    | ng |       | data is being reported. |           |
| P     |    |    |    |       | The required format for |           |
| eriod |    |    |    |       | entering the File       |           |
|       |    |    |    |       | Reporting Period is     |           |
|       |    |    |    |       | \"CCYY-CCYY\" or \"CCYY |           |
|       |    |    |    |       | CCYY\", where either a  |           |
|       |    |    |    |       | hyphen or a space must  |           |
|       |    |    |    |       | separate the beginning  |           |
|       |    |    |    |       | and ending years, e.g., |           |
|       |    |    |    |       | 2005-2006 or 2005 2006. |           |
+-------+----+----+----+-------+-------------------------+-----------+
| F     | 1  | 2  | St | M     | Leave filler field      |           |
| iller | 27 | 64 | ri |       | blank.                  |           |
|       |    |    | ng |       |                         |           |
+-------+----+----+----+-------+-------------------------+-----------+
| Car   | 3  | 1  |    | M     |                         |           |
| riage | 91 |    |    |       |                         |           |
| R     |    |    |    |       |                         |           |
| eturn |    |    |    |       |                         |           |
| /Line |    |    |    |       |                         |           |
| Feed  |    |    |    |       |                         |           |
| (     |    |    |    |       |                         |           |
| CRLF) |    |    |    |       |                         |           |
+-------+----+----+----+-------+-------------------------+-----------+

## Data Record Definition

Data Records are required and immediately follow the header record in
every file submitted to the EDEN Submission System. Data Records provide
counts for the specified categories as well as sub-totals and grand
totals.

See Section 5.3 for examples of the Data Record.

Table 5.2-1: Firearm Incidents, LEA Data Record

+-------+----+----+----+-------+------------------+------------------+
| **D   | ** | ** | ** | *     | **Definition /   | **Permitted      |
| ata** | St | Le | Ty | *(M)a | Comments**       | Values**         |
|       | ar | ng | pe | ndato |                  |                  |
| *     | t\ | th | ** | ry/** |                  |                  |
| *Elem | Po | ** |    |       |                  |                  |
| ent** | si |    |    | **(O  |                  |                  |
|       | ti |    |    | )ptio |                  |                  |
| **N   | on |    |    | nal** |                  |                  |
| ame** | ** |    |    |       |                  |                  |
+=======+====+====+====+=======+==================+==================+
| File  | 1  | 6  | Nu | M     | A sequential     |                  |
| R     |    |    | mb |       | number assigned  |                  |
| ecord |    |    | er |       | by the State     |                  |
| N     |    |    |    |       | that is unique   |                  |
| umber |    |    |    |       | to each row      |                  |
|       |    |    |    |       | entry within the |                  |
|       |    |    |    |       | file.            |                  |
+-------+----+----+----+-------+------------------+------------------+
| **ID  | 7  | 2  | St | M     | The two-digit    | For a list of    |
| 559\  |    |    | ri |       | Federal          | valid FIPS State |
| *     |    |    | ng |       | Information      | Codes, refer to  |
| *FIPS |    |    |    |       | Processing       | the *EDEN        |
| State |    |    |    |       | Standards (FIPS) | Workbook*.       |
| Code  |    |    |    |       | for the state,   |                  |
|       |    |    |    |       | District of      |                  |
|       |    |    |    |       | Columbia, and    |                  |
|       |    |    |    |       | the possessions  |                  |
|       |    |    |    |       | and freely       |                  |
|       |    |    |    |       | associated areas |                  |
|       |    |    |    |       | of the United    |                  |
|       |    |    |    |       | States (e.g.,    |                  |
|       |    |    |    |       | Puerto Rico).    |                  |
+-------+----+----+----+-------+------------------+------------------+
| **ID  | 9  | 2  | St | M     | A number used in | **01** = State   |
| 570\  |    |    | ri |       | EDEN to uniquely | Education        |
| **    |    |    | ng |       | identify state   | Agency           |
| State |    |    |    |       | agencies. This   |                  |
| A     |    |    |    |       | ID cannot be     |                  |
| gency |    |    |    |       | updated through  |                  |
| N     |    |    |    |       | this file.       |                  |
| umber |    |    |    |       |                  |                  |
+-------+----+----+----+-------+------------------+------------------+
| **ID  | 11 | 14 | St | M     | The identifier   |                  |
| 4\    |    |    | ri |       | assigned to a    |                  |
| **    |    |    | ng |       | local education  |                  |
| State |    |    |    |       | agency (LEA) by  |                  |
| LEA   |    |    |    |       | the State        |                  |
| Ident |    |    |    |       | Education Agency |                  |
| ifier |    |    |    |       | (SEA). Also      |                  |
|       |    |    |    |       | known as State   |                  |
|       |    |    |    |       | LEA ID. This ID  |                  |
|       |    |    |    |       | is a required    |                  |
|       |    |    |    |       | field. This data |                  |
|       |    |    |    |       | element cannot   |                  |
|       |    |    |    |       | be updated       |                  |
|       |    |    |    |       | through this     |                  |
|       |    |    |    |       | file.            |                  |
+-------+----+----+----+-------+------------------+------------------+
| F     | 25 | 20 | St | M     | Leave filler     |                  |
| iller |    |    | ri |       | field blank.     |                  |
|       |    |    | ng |       |                  |                  |
+-------+----+----+----+-------+------------------+------------------+
| Table | 45 | 20 | St | M     | The number of    | *                |
| Name  |    |    | ri |       | incidents        | *FIREARMINCDNT** |
|       |    |    | ng |       | involving a      |                  |
|       |    |    |    |       | firearm.         |                  |
+-------+----+----+----+-------+------------------+------------------+
| W     | 65 | 50 | St | M     | The type of      | **HANDGUNS** -   |
| eapon |    |    | ri |       | weapon.          | Handguns         |
| Type  |    |    | ng |       |                  |                  |
|       |    |    |    |       |                  | **RIFLESHOTGUN** |
|       |    |    |    |       |                  | --               |
|       |    |    |    |       |                  | Rifles/Shotguns  |
|       |    |    |    |       |                  |                  |
|       |    |    |    |       |                  | **MULTIPLE** --  |
|       |    |    |    |       |                  | More than one    |
|       |    |    |    |       |                  | type of weapon   |
|       |    |    |    |       |                  | or firearm.      |
|       |    |    |    |       |                  |                  |
|       |    |    |    |       |                  | **OTHER** -- As  |
|       |    |    |    |       |                  | defined in 18    |
|       |    |    |    |       |                  | USC 921,         |
|       |    |    |    |       |                  | including any    |
|       |    |    |    |       |                  | weapon           |
|       |    |    |    |       |                  | (including a     |
|       |    |    |    |       |                  | starter gun)     |
|       |    |    |    |       |                  | which will or is |
|       |    |    |    |       |                  | designed to or   |
|       |    |    |    |       |                  | may readily be   |
|       |    |    |    |       |                  | converted to     |
|       |    |    |    |       |                  | expel a          |
|       |    |    |    |       |                  | projectile by    |
|       |    |    |    |       |                  | the action of    |
|       |    |    |    |       |                  | any explosive;   |
|       |    |    |    |       |                  | the frame or     |
|       |    |    |    |       |                  | receiver of      |
|       |    |    |    |       |                  | handguns and     |
|       |    |    |    |       |                  | rifles/shotguns; |
|       |    |    |    |       |                  | any firearm      |
|       |    |    |    |       |                  | muffler or       |
|       |    |    |    |       |                  | firearm          |
|       |    |    |    |       |                  | silencer; any    |
|       |    |    |    |       |                  | destructive      |
|       |    |    |    |       |                  | device, which    |
|       |    |    |    |       |                  | includes (a) any |
|       |    |    |    |       |                  | explosive,       |
|       |    |    |    |       |                  | incendiary or    |
|       |    |    |    |       |                  | poison gas, (1)  |
|       |    |    |    |       |                  | bomb, (2)        |
|       |    |    |    |       |                  | grenade, (3)     |
|       |    |    |    |       |                  | rocket having a  |
|       |    |    |    |       |                  | propellant       |
|       |    |    |    |       |                  | charge of more   |
|       |    |    |    |       |                  | than four        |
|       |    |    |    |       |                  | ounces, (4)      |
|       |    |    |    |       |                  | missile having   |
|       |    |    |    |       |                  | an explosive or  |
|       |    |    |    |       |                  | incendiary       |
|       |    |    |    |       |                  | charge of more   |
|       |    |    |    |       |                  | than one-quarter |
|       |    |    |    |       |                  | ounce, (5) mine, |
|       |    |    |    |       |                  | or (6) similar   |
|       |    |    |    |       |                  | device; (b) any  |
|       |    |    |    |       |                  | weapon which     |
|       |    |    |    |       |                  | will or which    |
|       |    |    |    |       |                  | may readily      |
|       |    |    |    |       |                  | converted to,    |
|       |    |    |    |       |                  | expel a          |
|       |    |    |    |       |                  | projectile by    |
|       |    |    |    |       |                  | the action of an |
|       |    |    |    |       |                  | explosive or     |
|       |    |    |    |       |                  | other            |
|       |    |    |    |       |                  | propellant, and  |
|       |    |    |    |       |                  | which has any    |
|       |    |    |    |       |                  | barrel with a    |
|       |    |    |    |       |                  | bore of more     |
|       |    |    |    |       |                  | than one-half    |
|       |    |    |    |       |                  | inch in          |
|       |    |    |    |       |                  | diameter; (c)    |
|       |    |    |    |       |                  | any combination  |
|       |    |    |    |       |                  | or parts either  |
|       |    |    |    |       |                  | designed or      |
|       |    |    |    |       |                  | intended for use |
|       |    |    |    |       |                  | in converting    |
|       |    |    |    |       |                  | any device into  |
|       |    |    |    |       |                  | any destructive  |
|       |    |    |    |       |                  | device, and from |
|       |    |    |    |       |                  | which a          |
|       |    |    |    |       |                  | destructive      |
|       |    |    |    |       |                  | device may be    |
|       |    |    |    |       |                  | readily          |
|       |    |    |    |       |                  | assembled.\      |
|       |    |    |    |       |                  | **MISSING**\     |
|       |    |    |    |       |                  | **NOTCOLLECT**   |
|       |    |    |    |       |                  | -- Not Collected |
+-------+----+----+----+-------+------------------+------------------+
| F     | 1  | 50 | St | M     | Leave filler     |                  |
| iller | 15 |    | ri |       | field blank.     |                  |
|       |    |    | ng |       |                  |                  |
+-------+----+----+----+-------+------------------+------------------+
| F     | 1  | 15 | St | M     | Leave filler     |                  |
| iller | 65 |    | ri |       | field blank.     |                  |
|       |    |    | ng |       |                  |                  |
+-------+----+----+----+-------+------------------+------------------+
| Total | 1  | 1  | St | M     | An indicator     | **N** =          |
| Indi  | 80 |    | ri |       | that defines the | specifies detail |
| cator |    |    | ng |       | count level      | level            |
|       |    |    |    |       | (i.e., detail    |                  |
|       |    |    |    |       | level, subtotal  |                  |
|       |    |    |    |       | level or grand   |                  |
|       |    |    |    |       | total level).    |                  |
+-------+----+----+----+-------+------------------+------------------+
| E     | 1  | 2  | St | O     | Submitted files  |                  |
| xplan | 81 | 00 | ri |       | will be          |                  |
| ation |    |    | ng |       | processed        |                  |
|       |    |    |    |       | through various  |                  |
|       |    |    |    |       | edit checks.     |                  |
|       |    |    |    |       | When unusual     |                  |
|       |    |    |    |       | conditions are   |                  |
|       |    |    |    |       | detected,        |                  |
|       |    |    |    |       | warning errors   |                  |
|       |    |    |    |       | may be issued,   |                  |
|       |    |    |    |       | even though the  |                  |
|       |    |    |    |       | data may be      |                  |
|       |    |    |    |       | valid. When this |                  |
|       |    |    |    |       | occurs, an       |                  |
|       |    |    |    |       | explanation      |                  |
|       |    |    |    |       | responding to    |                  |
|       |    |    |    |       | the warning may  |                  |
|       |    |    |    |       | be submitted     |                  |
|       |    |    |    |       | with the data,   |                  |
|       |    |    |    |       | or after files   |                  |
|       |    |    |    |       | have been        |                  |
|       |    |    |    |       | processed. The   |                  |
|       |    |    |    |       | Department of    |                  |
|       |    |    |    |       | Education will   |                  |
|       |    |    |    |       | verify           |                  |
|       |    |    |    |       | explanations,    |                  |
|       |    |    |    |       | and after        |                  |
|       |    |    |    |       | verification,    |                  |
|       |    |    |    |       | accept the data. |                  |
+-------+----+----+----+-------+------------------+------------------+
| Inc   | 3  | 10 | Nu | M     | If the count     |                  |
| ident | 81 |    | mb |       | provided is      |                  |
| Count |    |    | er |       | either a         |                  |
|       |    |    |    |       | subtotal or      |                  |
|       |    |    |    |       | grand total, it  |                  |
|       |    |    |    |       | must be equal to |                  |
|       |    |    |    |       | or greater than  |                  |
|       |    |    |    |       | the sum of its   |                  |
|       |    |    |    |       | parts.           |                  |
+-------+----+----+----+-------+------------------+------------------+
| Car   | 3  | 1  |    | M     |                  |                  |
| riage | 91 |    |    |       |                  |                  |
| R     |    |    |    |       |                  |                  |
| eturn |    |    |    |       |                  |                  |
| /Line |    |    |    |       |                  |                  |
| Feed  |    |    |    |       |                  |                  |
| (     |    |    |    |       |                  |                  |
| CRLF) |    |    |    |       |                  |                  |
+-------+----+----+----+-------+------------------+------------------+

## LEA Firearm Incidents File Example 

### Partial Record Sample for Fixed Format LEA Firearm Incidents File

The following text shows a portion of the header row and data rows.

### Partial Record Sample for Comma-Delimited File Format LEA Firearm Incidents File

The following text shows a portion of the header row and data rows.[^3]

### Partial Record Sample for Tab-Delimited File Format LEA Firearm Incidents File

The following text shows a portion of the header row and data rows.[^4]

![](media/image1.png){width="1.5in" height="1.5in"}

Our mission is to ensure equal access to education and to promote
educational excellence throughout the nation.

www.ed.gov

[^1]: ^\*^ Using EXCEL will produce extraneous delimiters at the end of
    the header record. They will be disregarded during file processing
    and so will not generate a file format error.

[^2]: ^\*^ Using EXCEL will produce extraneous delimiters at the end of
    the header record. They will be disregarded during file processing
    and so will not generate a file format error.

[^3]: ^\*^ Using EXCEL will produce extraneous delimiters at the end of
    the header record. They will be disregarded during file processing
    and so will not generate a file format error.

[^4]: ^\*^ Using EXCEL will produce extraneous delimiters at the end of
    the header record. They will be disregarded during file processing
    and so will not generate a file format error.