2013-2014 School District Review Program

Generic Clearance for Geographic Partnership Programs

Att_D_Data_Dictionary

2013-2014 School District Review Program

OMB: 0607-0795

⚠️ Notice: This form may be outdated. More recent filings and information on OMB 0607-0795 can be found here:
2015-09-25 - Revision of a currently approved collection
Document [pdf]
Download: pdf | pdf
Attachment D: School District Review Program
Data Dictionary/Record Layout for School District Listings

Attachment D: Data Dictionary/Record Layout for School District Listings

2013-2014

Supplementary Text and Excel File Data Dictionary/Record Layout
Text and Excel files are produced for both the Annotation Phase and the Verification
Phase of the SDRP.
For the Annotation Phase, the file names will be followed by “_A”; e.g.,
_SD_Inventory_A.txt, _SD_Inventory_A.xls where  = two-digit State
FIPS code.
For the Verification Phase, the file names will be followed by “_V”; e.g.,
_County_Coverage_V.txt. _SD_Inventory_V.xls where  = two-digit
State FIPS code.
________________________________________________________________________
Data Dictionary for the School District Inventory and Grade Range File
These files follow the naming convention of _SD_Inventory_*.txt and
_SD_Inventory_*.xls
The Data Dictionary Table, Table 1.a, describes the fields in the inventory, their length,
data type, a brief description of the field and the valid value ranges.
Table 1.a Data Dictionary for the School District Inventory and Grade Range File
ATTRIBUTE FIELD LENGTH
TYPE
DESCRIPTION
Value/Range
State FIPS (Federal
01,02,04-06,08-13,15STATE CODE
2
VARCHAR Information Processing
42,44-51,53-56
Standards) Code
VARCHAR
School District Local
SDLEA
5
00001-99998
Education Agency Code
VARCHAR
School District Low
LOGRADE
2
PK,KG,01-12
Grade
VARCHAR
School District High
HIGRADE
2
PK, KG, 01-12
Grade
VARCHAR
E=Elementary
SDLEVEL
1
School District Level
S=Secondary
U=Unified
VARCHAR
A=Pseudo
B=Dept. of Defense
C=Interstate
SDTYPE
1
School District Type
D=Bureau of Indian
Affairs
E=Same Name
VARCHAR
NAME
100
School District Name
Not Blank

Attachment D: Data Dictionary/Record Layout for School District Listings

2

Record Layout for the School District Inventory and Grade Range File
The Record Layout, Table 1.b, defines how each record’s information is displayed giving
the number of spaces in each column and the column name.
Table 1.b Record Layout for the
School District Inventory and Grade Range File
Space
Column Name
1-2

STATE CODE

4-8

SDLEA

10-11

LOGRADE

13-14

HIGRADE

16

SDLEVEL

18

SDTYPE

20-119

NAME

Data Dictionary for the County Coverage File
These files follow the naming convention _County_Coverage_*txt and
_County_Coverage_*.xls
The Data Dictionary Table, Table 2.a, describes the fields in the file, their length, data
type, a brief description of the field and the valid value ranges.

ATTRIBUTE FIELD
STATE CODE

COUNTY CODE
COUNTY NAME

Table 2.a Data Dictionary for the County Coverage File
LENGTH
TYPE
DESCRIPTION
Value/Range
State FIPS (Federal
01,02,04-06,08-13,152
VARCHAR
Information Processing
42,44-51,53-56
Standards) Code
VARCHAR
County FIPS (Federal
3
Information Processing
001-840
Standards) Code
VARCHAR
100
County Name
Not Blank

SDLEA

5

NAME

100

VARCHAR

School District Local
Education Agency Code

00001-99998

VARCHAR

School District Name

Not Blank

Attachment D: Data Dictionary/Record Layout for School District Listings

3

Record Layout for the County Coverage File
The Record Layout, Table 2.b, defines how each record’s information is displayed giving
the number of spaces in each column and the column name.
Table 2.b Record Layout for the
County Coverage File
Space
Column Name
1-2

STATE CODE

3-5

COUNTY CODE

7-106

COUNTY NAME

108-112

SDLEA

114-213

NAME

________________________________________________________________________
Data Dictionary for the Coextensive Coverage File
These files follow the naming convention _Coextensive_Coverage_*txt and
_Coextensive_Coverage_*.xls
The Data Dictionary Table, Table 3.a, describes the fields in the file, their length, data
type, a brief description of the field and the valid value ranges.

ATTRIBUTE FIELD
STATE CODE

COUNTY CODE
COUNTY NAME

Table 3.a Data Dictionary for the Coextensive File
LENGTH
TYPE
DESCRIPTION
State FIPS (Federal
2
VARCHAR
Information Processing
Standards) Code
VARCHAR
County FIPS (Federal
3
Information Processing
Standards) Code
VARCHAR
100
County Name

SDLEA

5

SDLEVEL

1

SDNAME

100

COEXTWITH

100

VARCHAR

001-840
Not Blank
00001-99998

School District Level

E=Elementary
S=Secondary
U=Unified

VARCHAR

School District Name

Not Blank

VARCHAR

Name of Entity School
District Coextensive
With
FIPS(Federal
Information Processing
Standards) 55 Code of
Entity

VARCHAR
5

01,02,13,21,22,28,
37,45,47,49,51

School District Local
Education Agency Code

VARCHAR

ENTITY CODE

Value/Range

Not Blank

001-840, 00000-98999,
99001-99840

Attachment D: Data Dictionary/Record Layout for School District Listings

4

Record Layout for the Coextensive Coverage File
The Record Layout, Table 3.b, defines how each record’s information is displayed giving
the number of spaces in each column and the column name.
Table 3.b Record Layout for the
Coextensive Coverage File
Space
Column Name
1-2

STATE CODE

3-5

COUNTY CODE

7-106

COUNTY NAME

108-112

SDLEA

114

SDLEVEL

116-215

SDNAME

217-316

COEXTWITH

318-322

ENTITY CODE

________________________________________________________________________
Data Dictionary for the School District to Geography Relationship File
These files follow the naming convention _SD_GEO_Relationship_*txt and
_SD_GE)_Relationship_*.xls
The Data Dictionary Table, Table 4.a, describes the fields in the file, their length, data
type, a brief description of the field and the valid value ranges.
Table 4.a Data Dictionary for the School District to Geography Relationship File
ATTRIBUTE FIELD
LENGTH
TYPE
DESCRIPTION
Value/Range
School District Local
SDLEA
5
VARCHAR
Education Agency
00001-99998
Code
VARCHAR
E=Elementary
SDLEVEL
1
School District Level
S=Secondary
U=Unified
SDNAME
100
VARCHAR
School District Name
Not Blank
COUNTY
VARCHAR School District Partially
SUBDIVISION
1
Covers County
P
‘PART’ FLAG
Subdivision Part Flag
VARCHAR
State FIPS (Federal
01, 02, 04-06, 08-13, 15STATE CODE
2
Information Processing
42, 44-51, 53-56
Standards) Code
VARCHAR
County FIPS (Federal
COUNTY CODE
3
Information Processing
001-840
Standards) Code

Attachment D: Data Dictionary/Record Layout for School District Listings

5

VARCHAR
COUNTY
SUBDIVISION CODE

5

COUNTY
SUBDIVISION
NAME

100

PLACE ‘PART’
FLAG

1

PLACE CODE

5

PLACE NAME

100

VARCHAR

VARCHAR

VARCHAR

VARCHAR

County Subdivision
FIPS (Federal
Information Processing
Standards) Code

00000-98999

County Subdivision
Name

Not Blank

School District Partially
covers Incorporated
Place Part Flag
Place FIPS (Federal
Information Processing
Standards) Code

P

00001-89999

Place Name

Not Blank

Record Layout for the School District to Geography Relationship File
The Record Layout, Table 4.b, defines how each record’s information is displayed giving
the number of spaces in each column and the column name.
Table 4.b Record Layout for the
School District to Geography Relationship File
Space
Column Name
1-5

SDLEA

7

SDLEVEL

9-108

SDNAME

110

COUNTY SUBDIVISION
‘PART’ FLAG

112-113

STATE CODE

115-117

COUNTY CODE

119-123
125-224

COUNTY SUBDIVISION
CODE
COUNTY SUBDIVISION
NAME

226

PLACE ‘PART’ FLAG

228-232

PLACE CODE

234-333

PLACE NAME

Attachment D: Data Dictionary/Record Layout for School District Listings

6
File Type	application/pdf
File Title	Appendix E
Author	Bureau Of The Census
File Modified	2013-08-08
File Created	2013-08-08