1990 Census School District Special Tabulation Technical Documentation Prepared for National Archives Version - March 2000 Table of Contents 1. Overview 3 1.1. Data File Names and Organization by State 4 1.2. File Content Organization: 42 character header segment 5 1.3. File Content Organization: Field Sizes 6 2. Record Subject Matter Field Content: Total Households, Record Type 17 3. Record Subject Matter Field Content: Total Persons (Record Type 2A) 31 4. Record Subject Matter Field Content: Total Persons -- Record Type 2B 85 5. Record Subject Matter Field Content: Households with Children, Record Type 3 158 6. Record Subject Matter Field Content: Parents Living with Children -- Record Type 4 177 7. Record Subject Matter Field Content: Relevant Children's Households -- Record Type CH (5) 250 8. Record Subject Matter Field Content: Relevant Children's Parents -- Record Type CP (6) 269 9. Record Subject Matter Field Content: Relevant Children -- Record Type CO (7) 333 10. Sample State Level Record Segment Listing 383 11. Glossary 391 1. Overview This document summarizes the file structures used for the output of the conversion of the original Census Bureau supplied 1990 Census school district special tabulation files on magnetic tape to a form that meet National Archives and Records Administration (NARA) archival specifications. The objective of the process of converting the original files is to make the contents suitable for archival purposes through record/file restructuring that creates an output record of less than 10,000 characters The restructured files contain fixed-length records of 9,500 characters. To conform to archival requirements, the first four characters of each record have the value of 9500. Each restructured file record contains fixed-length fields. The total length of the record (9,500 characters) consists of a 9,498 character data segment followed by end of record carriage return character and line feed character. In summary, the general record layout follows the following format: Record length (fixed value of 9500) Original 36-character record header prepared by Census Segment sequence number for records with length exceeding 9,500 characters Fixed length fields of data Value of X for all records CR character LF character The original records are segmented in the following manner: Record 1 Segment 01 Fields 1 - 981 Record 2A Segment 01 Fields 1 - 1,042 Segment 02 Fields 1,043 - 2,054 Segment 03 Fields 2,055 - 2,501 Record 2B Segment 01 Fields 1 - 1,021 Segment 02 Fields 1,022 - 1,938 Segment 03 Fields 1,939 - 2,614 Segment 04 Fields 2,615 - 3,187 Record 3 Segment 01 Fields 1 - 808 Record 4 Segment 01 Fields 1 - 1,021 Segment 02 Fields 1,022 - 1,938 Segment 03 Fields 1,939 - 2,614 Segment 04 Fields 2,615 - 3,187 Record 5 Segment 01 Fields 1 - 808 Record 6 Segment 01 Fields 1 - 894 Segment 02 Fields 895 - 1,888 Segment 03 Fields 1,889 - 2,813 Record 7 Segment 01 Fields 1 - 829 Segment 02 Fields 830 - 1,625 Segment 03 Fields 1,626 - 2,271 1.1. Data File Names and Organization by State (this section in progress) Alaska AL.DAT Arizona AZ1.DAT AZ2.DAT 1.2. File Content Organization: 42 character header segment 1 - 4 Record length (9500) 9500 5 - 10 Record length (original) 019089 11 - 11 Record type 7 12 - 12 District type 9 13 - 14 State Code 04 15 - 17 County code 000 18 - 22 School district code 00000 (00000 for state or county) 23 - 24 CCD lowest grade 00 (00 for state or county) 25 - 26 CCD highest grade 00 (00 for state or county) 27 - 28 Augmented lowest grade 00 (00 for state or county) 29 - 30 Augmented highest grade 00 (00 for state or county) 31 - 37 CCD enrollment 0000000 (000000 for state or county) 38 - 38 Age/grade status F 0 Total universe for record types 1 and 2 1 0 - 2 years 2 3 - 4 years 3 5 - 13 years 4 14 - 17 years 5 18 - 19 years 6 3 - 19 years 7 5 - 17 years A Pre-kindergarten B Kindergarten C Grades 1 - 4 D Grade 5 - 8 E Grades 9 - 12 F Total Relevant 39 - 39 Enrollment status 3 0 Total universe for record types 1 and 2 1 Total 2 Total enrolled 3 Enrolled in public school 4 Enrolled in private school (record not in database: derive: enrollment status record 2 - enrollment status record 3) 5 Not enrolle (record not in database: derive: enrollment status record 1 - enrollment status record 2) 40 - 42 NARA Segment 003 43 - 51 Data value s46390 1.3. File Content Organization: Field Sizes Record Type 1 (HT) -- 981 statistical fields. 18 character width fields: 168,169,260,261,262,263,264,265,266,267,268,269,300,301,675,721,722 single segment output record Record Type 2A (PS) -- 2501 statistical fields. 18 character width fields: 1062,1063,1064,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078 Segment 01 Fields 1 - 1,042 Segment 02 Fields 1,043 - 2,054 Segment 03 Fields 2,055 - 2,501 Record Type 2B (PT) -- 3187 statistical fields. 18 character width fields: 2564,2565,3118,3119,3186,3187 Segment 01 Fields 1 - 1,021 Segment 02 Fields 1,022 - 1,938 Segment 03 Fields 1,939 - 2,614 Segment 04 Fields 2,615 - 3,187 Record Type 3 (HC) -- 808 statistical fields. 18 character width fields: 168,169,260,261,262,263,264,265,266,267,268,269,300,301,675,721,722 single segment output record Record Type 4 (PR) -- 3187 statistical fields. 18 character width fields: 2564,2565,3118,3119,3186,3187 Segment 01 Fields 1 - 1,021 Segment 02 Fields 1,022 - 1,938 Segment 03 Fields 1,939 - 2,614 Segment 04 Fields 2,615 - 3,187 Record Type 5 (CH) -- 808 statistical fields. 18 character width fields: 168,169,260,261,262,263,264,265,266,267,268,269,300,301,675,721,722 single segment output record Record Type 6 (CP) -- 2813 statistical fields. 18 character width fields: 2190,2191,2744,2745,2812,2813 Segment 01 Fields 1 - 894 Segment 02 Fields 895 - 1,888 Segment 03 Fields 1,889 - 2,813 Record Type 7 (CO) -- 2271 statistical fields. 18 character width fields: none. Segment 01 Fields 1 - 829 Segment 02 Fields 830 - 1,625 Segment 03 Fields 1,626 - 2,271