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 SCH CHRON ABSENT,15,MDSCHCHRONABSEver0007.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 counts for the specified category sets, subtotals and education unit totals. 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. DG4 15 14 String M The identifier assigned to a local LEA Identifier (State) 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 29 20 String M The identifier assigned to a school School Identifier by the state education agency (State) (SEA). Also known as the State School Identification Number (ID). This ID cannot be updated through this file. Table Name 49 20 String M See section 1.0 CHRONABSENT 69 15 String A The concept describing the M - Male Sex (Membership) biological traits that distinguish the F - Female males and females of a species. MISSING Racial Ethnic 84 15 String A The general racial category that AM7 - American Indian or most clearly reflects individuals' Alaska Native recognition of their community or AS7 - Asian
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 SCH CHRON ABSENT,15,MDSCHCHRONABSEver0007.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 counts for the specified category sets, subtotals and education unit totals. 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 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 State School Identification Number (ID). This ID cannot be updated through this file. Table Name 49 20 String M See section 1.0 CHRONABSENT Sex (Membership) 69 15 String A The concept describing the biological traits that distinguish the males and females of a species. M - Male F - Female MISSING Racial Ethnic 84 15 String A The general racial category that most clearly reflects individuals' recognition of their community or AM7 - American Indian or Alaska Native AS7 - Asian
fs195-14-2.docx