Below is an example of a header record. Table 4.1–2: Header Record Example Format File Type,Total Records in File,File Name,File Identifier,File Reporting Period,Filler,Carriage Return / Line Feed (CRLF) Example SEA CHARTER AUTHORIZER,15,CHARAUTOR.CSV,characters to identify file, 2017 2018,¶ Data Record Definition Data records are required and immediately follow the header record in every file submitted to the ESS. Data records provide the statuses and other data for the education units. Table 4.2–1: Data Records Start Permitted Values Data Element Name Length Type Pop Definition / Comments Position Abbreviations File Record Number 1 10 Number M A sequential number assigned by the State 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 State Code Standards Institute (ANSI) code for Codes, refer to the EDFacts the state, District of Columbia, and Workbook. the outlying areas and freely associated areas of the United States. DG570 13 2 String M A number used to uniquely identify 01 – State Education State Agency state agencies. This ID cannot be Agency Number updated through this file. Filler 15 14 String M Filler field leave blank Filler 29 20 String M Filler field leave blank DG798 49 60 String M See section 1.0 Charter Authorizer Name DG808 109 20 String M See section 1.0 Charter Authorizer Identifier (State) DG806 129 60 String M The mailing street name and Address Mailing 1 Revised! number or Post Office Box DG806 189 60 String O Additional mailing street address Address Mailing 2 All start Revised! information positions revised from this point down! DG806 249 60 String O Additional mailing street address
Below is an example of a header record. Table 4.1–2: Header Record Example Format File Type,Total Records in File,File Name,File Identifier,File Reporting Period,Filler,Carriage Return / Line Feed (CRLF) Example SEA CHARTER AUTHORIZER,15,CHARAUTOR.CSV,characters to identify file, 2017 2018,¶ Data Record Definition Data records are required and immediately follow the header record in every file submitted to the ESS. Data records provide the statuses and other data for the education units. 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 State 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 Filler 15 14 String M Filler field leave blank Filler 29 20 String M Filler field leave blank DG798 Charter Authorizer Name 49 60 String M See section 1.0 DG808 Charter Authorizer Identifier (State) 109 20 String M See section 1.0 DG806 Address Mailing 1 129 60 Revised! String M The mailing street name and number or Post Office Box DG806 Address Mailing 2 189 All start positions revised from this point down! 60 Revised! String O Additional mailing street address information DG806 249 60 String O Additional mailing street address