Table 4.2–1: Data Records Data Element Start Permitted Values Length Type Pop Definition / Comments Name Position Abbreviations File Record 1 10 Number M A sequential number assigned by the Number SEA that is unique to each row entry within the file. DG559 11 2 String M The two-digit American National For a list of valid State Codes, State Code Standards Institute (ANSI) code for the refer to the EDFacts Workbook. state, District of Columbia, and the outlying areas and freely associated areas of the United States. DG570 13 2 String M A number used to uniquely identify state 01 – State Education Agency State Agency agencies. This ID cannot be updated Number through this file. DG4 15 14 String M The identifier assigned to a local LEA Identifier education agency (LEA) by the state (State) education agency (SEA). Also known as State LEA Identification Number (ID). This data element cannot be updated through this file DG5 29 20 String M The identifier assigned to a school by LEA level - Blank School the state education agency (SEA). Also Identifier known as the States School (State) Identification Number (ID). This ID cannot be updated through this file. Filler 49 6 Number M Leave filler field blank. DG603 55 15 String M An indication of whether the school or YESWITHREP – Yes, with GFSA local education agency (LEA) submitted reporting of one or more Reporting a Gun-Free Schools Act (GFSA) of 1994 students for an offense Status report to the state, as defined by Title YESWOREP – Yes, with no 18, Section 921. reported offenses NO - No NA – Not applicable Explanation 70 200 String O Text field for state use. Carriage 270 1 M Return / Line Feed (CRLF) Below is an example of a data record, this is the set of data that should be submitted for each education unit. Table 4.2–2: Data Record Example School level – Format File Record Number,State Code,State Agency Number,LEA Identifier (State),School Identifier (State),Filler,GFSA Reporting Status,Explanation,Carriage Return / Line Feed (CRLF) Example 1,80,01,00606EUPHORIA,EU000001,,YESWOREP,text for state use¶
Table 4.2–1: Data Records Data Element Name Start Position Length Type Pop Definition / Comments Permitted Values Abbreviations File Record Number 1 10 Number M A sequential number assigned by the SEA that is unique to each row entry within the file. DG559 State Code 11 2 String M The two-digit American National Standards Institute (ANSI) code for the state, District of Columbia, and the outlying areas and freely associated areas of the United States. For a list of valid State Codes, refer to the EDFacts Workbook. DG570 State Agency Number 13 2 String M A number used to uniquely identify state agencies. This ID cannot be updated through this file. 01 – State Education Agency DG4 LEA Identifier (State) 15 14 String M The identifier assigned to a local education agency (LEA) by the state education agency (SEA). Also known as State LEA Identification Number (ID). This data element cannot be updated through this file DG5 School Identifier (State) 29 20 String M The identifier assigned to a school by the state education agency (SEA). Also known as the States School Identification Number (ID). This ID cannot be updated through this file. LEA level - Blank Filler 49 6 Number M Leave filler field blank. DG603 GFSA Reporting Status 55 15 String M An indication of whether the school or local education agency (LEA) submitted a Gun-Free Schools Act (GFSA) of 1994 report to the state, as defined by Title 18, Section 921. YESWITHREP – Yes, with reporting of one or more students for an offense YESWOREP – Yes, with no reported offenses NO - No NA – Not applicable Explanation 70 200 String O Text field for state use. Carriage Return / Line Feed (CRLF) 270 1 M Below is an example of a data record, this is the set of data that should be submitted for each education unit. Table 4.2–2: Data Record Example – School level Format File Record Number,State Code,State Agency Number,LEA Identifier (State),School Identifier (State),Filler,GFSA Reporting Status,Explanation,Carriage Return / Line Feed (CRLF) Example 1,80,01,00606EUPHORIA,EU000001,,YESWOREP,text for state use¶
fs163-15-0.docx