2011-2012 School District Boundary Review Program (SDRP)

Attachment F: School District Review Program
Data Dictionary/Record Layout for School District Listings

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

2011-2012

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
_SD_Inventory_*.txt and _SD_Inventory_*.xls
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 F: Data Dictionary/Record Layout for School District Listings

2

Record Layout
_SD_Inventory_*.txt
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
_County_Coverage_*.txt and _County_Coverage_*.xls
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
County FIPS (Federal
COUNTY CODE
3
Information Processing
001-840
Standards) Code
VARCHAR
COUNTY NAME
100
County Name
Not Blank
SDLEA

5

NAME

100

VARCHAR

School District Local
Education Agency Code

00001-99998

VARCHAR

School District Name

Not Blank

Record Layout
_County_Coverage_*.txt
Space

Column Name

1-2

STATE CODE

3-5

COUNTY CODE

7-106

COUNTY NAME

108-112

SDLEA

114-213

NAME

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

3

Data Dictionary
_Coextensive_Coverage_*.txt and _Coextensive_Coverage_*.xls
ATTRIBUTE FIELD
LENGTH
TYPE
DESCRIPTION
Value/Range
State FIPS (Federal
01,02,13,21,22,28,
STATE CODE
2
VARCHAR
Information Processing
37,45,47,49,51
Standards) Code
VARCHAR
County FIPS (Federal
COUNTY CODE
3
Information Processing
001-840
Standards) Code
VARCHAR
COUNTY NAME
100
County Name
Not Blank
SDLEA

5

SDLEVEL

1

SDNAME

100

COEXTWITH

100

VARCHAR

School District Local
Education Agency Code

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

VARCHAR
ENTITY CODE

5

Not Blank

001-840, 00000-98999,
99001-99840

Record Layout
_Coextensive_Coverage_*.txt
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

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

4

Data Dictionary
_SD_GEO_Relationship_*.txt and _SD_GEO_Relationship_*.xls
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
VARCHAR
School District
COUNTY
Partially Covers
SUBDIVISION
1
P
County Subdivision
‘PART’ FLAG
Part Flag
VARCHAR
State FIPS (Federal
01, 02, 04-06, 08-13,
STATE CODE
2
Information Processing
15-42, 44-51, 53-56
Standards) Code
VARCHAR County FIPS (Federal
COUNTY CODE
3
Information Processing
001-840
Standards) Code
VARCHAR
County Subdivision
COUNTY
FIPS (Federal
SUBDIVISION
5
00000-98999
Information Processing
CODE
Standards) Code
COUNTY
VARCHAR
County Subdivision
SUBDIVISION
100
Not Blank
Name
NAME
VARCHAR
School District
PLACE ‘PART’
Partially covers
1
P
FLAG
Incorporated Place Part
Flag
VARCHAR
Place FIPS (Federal
PLACE CODE
5
Information Processing
00001-89999
Standards) Code
PLACE NAME
100
VARCHAR
Place Name
Not Blank

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

5

Record Layout
_SD_GEO_Relationship_*.txt
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 F: Data Dictionary/Record Layout for School District Listings

6