SEA for the list of organizations in the state filename CHARMAORG 9 vvvvvvv Alphanumeric string designated by the SEA to uniquely identify the individual submission (e.g., ver0001, v010803) 7 .ext Extension identifying the file format: .txt – fixed .csv – comma delimited .tab – tab delimited 4 FIXED OR DELIMITED FILES This section describes the fixed file and delimited file specifications. The fixed file and delimited files contain a header record followed by data records. The file type is specified in the header record. The “Pop” column in the header and data records is coded as follows: M - Mandatory, this field must always be populated A - If one field marked with ‘A’ is provided, all other fields marked with ‘A’ must be provided O - Optional, data in this field are optional Header Record Definition The header record is required and is the first record in every file submitted to the ESS. 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. Table 4.1–1: Header Record Data Element Name Start Position Length Type Pop Definition / Comments Permitted Values Abbreviations File Type 1 50 String M Identifies the type of file being submitted. CHARTER MANAGE ORG Total Records in File 51 10 Number M The total number of data records contained in the file. The header record is NOT included in this count. File Name 61 25 String M The file name including extension, the same as the external file name. See section 3.0
File Identifier 86 32 String M Any combination of standard characters to further identify the file as specified by the SEA (e.g., a date, person’s name, and version number). File Reporting Period 118 9 String M The school year for which data are being reported. The required format is "CCYY–CCYY" or "CCYY CCYY", where either a hyphen or a space separates the beginning and ending years. 2017-2018 Or 2017 2018 Filler 127 333 String M Leave filler field blank. Carriage Return / Line Feed (CRLF) 460 1 M 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 CHARTER MANAGE ORG,15,EUSEACHARMAORGver0007.CSV,characters to identify Data Record Definition Data records are required and immediately follow the header record in every file submitted to the ESS. Data records provide information for the management organizations. 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 Leave filler field blank.
Filler 29 20 String M Leave filler field blank. DG825 Management Organization Name 49 60 String M See section 1.0 DG826 Employer Identification Number (EIN) 109 20 String M See section 1.0 DG827 Address Location 1 129 60 Revised! String A The street address that describes the physical location. DG827 Address Location 2 189 All start positions revised from this point down! 60 Revised! String O Additional address information that describes the physical location. DG827 Address Location 3 249 60 Revised! String O Additional address information that describes the physical location. DG827 City Location 309 30 String A The name of the city that describes the physical location. DG827 State Abbreviation Location 339 2 String A The state abbreviation for the location address. Two-character USPS standard state abbreviation (See FS 029 Appendix A for list of state abbreviations) DG827 ZIP Code Location 341 5 String A The five–digit ZIP Code for the location address. All 5 digits (cannot be 00000 or 99999 or less than 00600) DG827 ZIP Code Plus 4 Location 346 4 String O The four–digit extension of the ZIP Code for the location address. All 4 digits (cannot be 0000) DG828 Address Mailing 1 350 60 Revised! String M The mailing street name and number or Post Office Box. DG828 Address Mailing 2 410 60 Revised! String O Additional mailing street address information. DG828 Address Mailing 3 470 60 Revised! String O Additional mailing street address information. DG828 City Mailing 530 30 String M The mailing address city. DG828 State Abbreviation Mailing 560 2 String M The state abbreviation for the mailing address. Two-character USPS standard state abbreviation (See FS 029 Appendix A for list of state abbreviations) DG828 ZIP Code Mailing 562 5 String M The five–digit ZIP Code for the mailing address. All 5 digits (cannot be 00000 or 99999 or less than 00600)