Download:
pdf |
pdfAttachment F: School District Review Program
Supplementary Text File Data Dictionary/Record Layout
for School District Listings
Attachment F: Supplementary Text File Data Dictionary/Record Layout
2009-2010
Supplementary Text File Data Dictionary/Record Layout
All text 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,
For the Verification Phase, the file names will be followed by “_V”; e.g.,
_County_Coverage_V.txt.
_SD_Inventory_*.txt (=Two-Digit State FIPS Code)
ATTRIBUTE FIELD
LENGTH
TYPE
DESCRIPTION
STATEFP
2
VARCHAR
State FIPS Code
SDLEA
5
VARCHAR
School District Local
Education Agency Code
00001-99998
LOGRADE
2
VARCHAR
Low Grade
PK,KG,01-12
HIGRADE
2
VARCHAR
High Grade
PK, KG, 01-12
SDLEVEL
1
VARCHAR
School District Level
VARCHAR
SDTYP
1
NAME
100
School District Type
VARCHAR
Value/Range
01,02,04-06,08-13,1542,44-51,53-56
E=Elementary
S=Secondary
U=Unified
A=Pseudo
B=Dept. of Defense
C=Interstate
D=Bureau of Indian
Affairs
E=Same Name
School District Name
Not Blank
_SD_Inventory_*.txt
Record Layout
Space
Column Name
1-2
STATEFP
4-8
SDLEA
10-11
LOGRADE
13-14
HIGRADE
16
SDLEVEL
18
SDTYP
20-119
NAME
Attachment F: Supplementary Text File Data Dictionary/Record Layout
2
_County_Coverage_*.txt (=Two-Digit State FIPS Code)
ATTRIBUTE FIELD
LENGTH
TYPE
DESCRIPTION
Value/Range
01,02,04-06,08-13,1542,44-51,53-56
STATEFP
2
VARCHAR
State FIPS Code
COUNTYFP
3
VARCHAR
County FIPS Code
001-840
COUNAME
100
VARCHAR
County Name
Not Blank
SDLEA
5
VARCHAR
School District Local
Education Agency Code
00001-99998
NAME
100
VARCHAR
School District Name
Not Blank
_County_Coverage_*.txt
Record Layout Space
Column Name
1-2
STATEFP
3-5
COUNTYFP
7-106
COUNAME
108-112
SDLEA
114-213
NAME
Attachment F: Supplementary Text File Data Dictionary/Record Layout
3
_Coextensive_Coverage_*.txt (=Two-Digit State FIPS Code) ATTRIBUTE FIELD
LENGTH
TYPE
DESCRIPTION
Value/Range
01,02,13,21,22,28,
37,45,47,49,51
STATEFP
2
VARCHAR
State FIPS Code
COUNTYFP
3
VARCHAR
County FIPS Code
001-840
COUNAME
100
VARCHAR
County Name
Not Blank
SDLEA
5
VARCHAR
School District Local
Education Agency Code
00001-99998
SDLEVEL
1
School District Level
E=Elementary
S=Secondary
U=Unified
SDNAME
100
VARCHAR
School District Name
Not Blank
COEXTWITH
100
VARCHAR
Name of Entity
Coextensive With
Not Blank
FIPS55
5
FIPS 55 Code of Entity
001-840, 00000-98999,
99001-99840
VARCHAR
VARCHAR
_Coextensive_Coverage_*.txt
Record Layout Space
Column Name
1-2
STATEFP
3-5
COUNTYFP
7-106
COUNAME
108-112
SDLEA
114
SDLEVEL
116-215
SDNAME
217-316
COEXTWITH
318-322
FIPS55
Attachment F: Supplementary Text File Data Dictionary/Record Layout
4
_SD_by_SD_*.txt (=Two-Digit State FIPS Code) ATTRIBUTE
FIELD
LENGTH
TYPE
DESCRIPTION
Value/Range
SDLEA
5
VARCHAR
School District Local
Education Agency
Code
00001-99998
SDLEVEL
1
SDNAME
100
COUSUBPFLAG
1
STATEFP
2
COUNTYFP
3
COUSUBFP
5
COUSUBNAME
100
PLACEPFLAG
1
PLACEFP
PLACENAME
5
100
VARCHAR
School District Level
VARCHAR
VARCHAR
VARCHAR
VARCHAR
VARCHAR
VARCHAR
VARCHAR
VARCHAR
VARCHAR
School District Name
School District
Partially Covers
County Subdivision
Part Flag
State FIPS Code
County FIPS Code
County Subdivision
FIPS Code
County Subdivision
Name
School district Partially
covers Incorporated
Place Part Flag
Place FIPS Code
Place Name
E=Elementary
S=Secondary
U=Unified
Not Blank
P
01, 02, 04-06, 08-13,
15-42, 44-51, 53-56
001-840
00000-98999
Not Blank
P
00001-89999
Not Blank
_SD_by_SD_*.txt
Record Layout Space
Column Name
1-5
SDLEA
7
SDLEVEL
9-108
SDNAME
110
COUSUBPFLAG
112-113
STATEFP
115-117
COUNTYFP
119-123
COUSUBFP
125-224
COUSUBNAME
226
PLACEPFLAG
228-232
PLACEFP
234-333
PLACENAME
Attachment F: Supplementary Text File Data Dictionary/Record Layout
5
| File Type | application/pdf |
| File Title | Appendix E |
| Author | Bureau Of The Census |
| File Modified | 2009-07-27 |
| File Created | 2009-07-27 |