Common Core of Data, Local Education Agency Universe Survey, 2002-03 FILE NAME = mi021bag.dat NVAR = 145 NOBS = 807 LRECL = 725 (*) Fields have one explicit decimal place (+) Fields represent sub-fields of the fields immediately preceding them. The file contains data for the school year 2002-03 sorted by the NCES assigned local education agency identification code (LEAID). Variable Start End Field Data Name Pos. Pos. Length Type Description LEAID 0001 0007 7 AN NCES Local Education Agency ID. The first two positions of this field is also the FIPS state code. +FIPST 0001 0002 2 AN Federal Information Processing Standards, FIPS state code. STID02 0008 0021 14 AN State's own ID for the education agency. NAME02 0022 0081 60 AN Name of the education agency. PHONE02 0082 0091 10 AN Telephone number of education agency. NOTE: Position # 0082-0084 is the area code, and position # 0085-0091 is the exchange and number. MSTREE02 0092 0121 30 AN Mailing address of the agency -- may be a street address, a Post Office box number, or, if there is no address beyond CITY, STATE, and ZIP, the character "N". MCITY02 0122 0151 30 AN Name of the mailing address city. MSTATE02 0152 0153 2 AN Two-letter U.S. Postal Service abbreviation for the state where the mailing address is located. MZIP02 0154 0158 5 AN Five-digit U.S. Postal Service ZIP code for the mailing address. MZIP402 0159 0162 4 AN Four-digit ZIP+4, if assigned; if none, field is blank. LSTREE02 0163 0192 30 AN Location Address. LCITY02 0193 0222 30 AN Location City. LSTATE02 0223 0224 2 AN Location State (PO abbreviation. LZIP02 0225 0229 5 AN Location 5 digit ZIP Code. LZIP402 0230 0233 4 AN Location +4 ZIP Code. TYPE02 0234 0234 1 AN NCES code for type of agency: 1 = Local school district that is not a component of a supervisory union. 2 = Local school district component of a supervisory union sharing a superintendent and administrative services with other local school districts. 3 = Supervisory union administrative center, or a county superintendent serving the same purpose. 4 = Regional education services agency, or a county superintendent serving the same purpose. 5 = State-operated institution charged, at least in part, with providing elementary and/or secondary instruction or services to a special need population. 6 = Federally-operated institution charged, at least in part, with providing elementary and/or secondary instruction or services to a special need population. 7 = Other education agencies that do not fit into the first six categories. UNION02 0235 0237 3 AN Supervisory Union Number. For supervisory union administrative centers and component agencies, this is a number assigned by the state to the union. Additionally, if the agency is a county superintendent, this is the FIPS county number. If no number was reported, the field will contain "000". CONUM02 0238 0242 5 AN FIPS county number. NOTE: Position #0268-0269 is the FIPS state number, and position #0270-0271 is the FIPS number for county within state. CONAME02 0243 0272 30 AN Name of county. CSA02 0273 0275 3 AN A value in this field indicates the agency's address is associated with a recognized combined statistical area. A CSA may comprise two or more metropolitan statistical areas, a metropolitan statistical area and a micropolitan statistical Area, two or more micropolitan statistical areas, or multiple metropolitan and micropolitan statistical areas. The geographic components of combined New England city and town areas are individual metropolitan and micropolitan NECTAs, in various combinations. The areas that combine retain their own designations as metropolitan or micropolitan statistical areas (or NECTAs) within the larger combined statistical area (or combined NECTA). CBSA02 0276 0280 5 AN A value in this field indicates that the agency's address is associated with a recognized population nucleus and adjacent communities that have a high degree of integration with that nucleus, and designated by the U.S. Government as a metropolitan or micropolitan statistical area. If the agency is not in any type of metropolitan/micropolitan statistical area the field is zero filled. For all states but those in New England, the assignment was made using a file of FIPS county codes matched to Core Based Statistical Area codes. For the New England states, the assignment was made using the New England City and Town Area codes of the schools within the corresponding agency. The metropolitan area definitions used were those issued by the Office of Management and Budget (OMB) as of June 2003. METMIC02 0281 0281 1 AN Indicates whether the CBSA is a metropolitan or micropolitan area. 0 = CBSA is equal to 70300 or higher and does not have an associated type code. CBSA equal to 70300 or higher is the New England City and Town Area code (NECTA) and is not denoted as metropolitan or micropolitan. 1 = CBSA is a metropolitan area. 2 = CBSA is a micropolitan area. MSC02 0282 0282 1 AN NCES classification of the agency's service area relative to a CBSA. 1 = Primarily serves a principal city of a CBSA 2 = Serves a CBSA but not primarily its principal city 3 = Does not serve an CBSA LOCALE02 0283 0283 1 AN NCES code for location of the agency relative to populous areas: 1 = Large City: A principal city of a Metropolitan Core Based Statistical Area (CBSA), with the city having a population greater than or equal to 250,000. 2 = Mid-size City: A principal city of a Metropolitan CBSA, with the city having a population less than 250,000. 3 = Urban Fringe of a Large City: Any incorporated place, Census designated place, or non-place territory within a Metropolitan CBSA of a Large City and defined as urban by the Census Bureau. 4 = Urban Fringe of a Mid-size City: Any incorporated place, Census designated place, or non-place territory within a CBSA of a Mid-size City and defined as urban by the Census Bureau. 5 = Large Town: An incorporated place or Census designated place with a population greater than or equal to 25,000 and located outside a Metropolitan CBSA or inside a Micropolitan CBSA. 6 = Small Town: An incorporated place or Census designated place with population less than 25,000 and greater than or equal to 2,500 and located outside a Metropolitan CBSA or inside a Micropolitan CBSA. 7 = Rural, outside CBSA: Any incorporated place, Census designated place, or non-place territory not within a Metropolitan CBSA or within a Micropolitan CBSA and defined as rural by the Census Bureau. 8 = Rural, inside CBSA: Any incorporated place, Census designated place, or non-place territory within a Metropolitan CBSA and defined as rural by the Census Bureau. BOUND02 0284 0284 1 AN The boundary change indicator is a classification of changes in an education agency's boundaries since the last report to NCES. The options are: 1 = No change since last report. 2 = Education agency has closed with no effect on another agency's boundaries. 3 = This is a new education agency formed with no effect on another agency's boundaries. 4 = Agency was in existence, but not reported on previous year's CCD agency universe, and is now being added. 5 = Agency has undergone a significant change in geographical boundaries or instructional responsibility. 6 = Agency is temporarily closed and may re-open in three years. 7 = Agency is scheduled to be operational within two years. GSLO02 0285 0286 2 AN Agency low grade offered. If grade span data was not reported, this field was calculated from the low grade spans of the associated schools on the CCD School Universe file. GSHI02 0287 0288 2 AN Agency high grade offered. If grade span data was not reported, this field was calculated from the high grade spans of the associated schools on the CCD School Universe file. GSLO02 and GSHI02 add up to the Grade Span of the school. AGCHRT02 0289 0289 1 AN Agency Charter. Code indicating charter schools served: 1 = All associated schools are charter schools. 2 = All associated schools are charter and non-charter schools. 3 = All associated schools are non-charter schools. SCH02 0290 0294 5 N Aggregate number of schools associated with this agency on the CCD Public School file. TEACH02 0295 0301 7* N Aggregate FTE classroom teachers reported for schools associated with this agency on the CCD Public School file, reported to the nearest tenth; field includes one explicit decimal. This is NOT necessarily the total number of teachers employed by this agency. UG02 0302 0308 7 N Total students in classes or programs without standard grade designations. PK1202 0309 0315 7 N Total students in classes from prekindergarten through 12th grade that are part of the public school program. MEMBER02 0316 0322 7 N Calculated total student membership of the Local Education Agency: The Sum of the fields UG02 and PK1202. MIGRNT02 0323 0329 7 N The number of migrant students, as defined under 34 CFR 200.40, enrolled in summer programs during the summer immediately prior to the 2002-2003 school year. SPECED02 0330 0336 7 N Count of all students having a written Individual Education Program (IEP) under IDEA - Part B. ELL02 0337 0343 7 N The number of English Language Learner students served in appropriate programs. PKTCH02 0344 0350 7* N Prekindergarten Teachers. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. KGTCH02 0351 0357 7* N Kindergarten Teachers. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. ELMTCH02 0358 0364 7* N Elementary Teachers. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. SECTCH02 0365 0371 7* N Secondary Teachers. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. UGTCH02 0372 0378 7* N Teachers of classes or programs to which students are assigned without standard grade designation. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. TOTTCH02 0379 0385 7* N Total Teachers. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. AIDES02 0386 0392 7* N Instructional Aides. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. CORSUP02 0393 0399 7* N Instructional Coordinators & Supervisors. Full-time equivalency reported to the nearest tenth; includes one explicit decimal. ELMGUI02 0400 0406 7* N Elementary Guidance Counselors. Full-time equivalency reported to the nearest tenth; includes one explicit decimal. SECGUI02 0407 0413 7* N Secondary Guidance Counselors. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. TOTGUI02 0414 0420 7* N Total Guidance Counselors. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. LIBSPE02 0421 0427 7* N Librarians/Media Specialists. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. LIBSUP02 0428 0434 7* N Library/Media Support Staff. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. LEAADM02 0435 0441 7* N LEA Administrators. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. LEASUP02 0442 0448 7* N LEA Administrative Support Staff. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. SCHADM02 0449 0455 7* N School Administrators. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. SCHSUP02 0456 0462 7* N School Administrative Support Staff. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. STUSUP02 0463 0469 7* N Student Support Services Staff. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. OTHSUP02 0470 0476 7* N All Other Support Services Staff. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. TOTDPL02 0477 0482 6 N Total Diploma Recipients. Includes both regular and other diploma recipients, comparable to adding REGDIP and OTHDIP from previous year's agency file. AMDPLM02 0483 0488 6 N Diploma Recipients - Amer. Indian/Alaskan Native - male. AMDPLF02 0489 0494 6 N Diploma Recipients - Amer. Indian/Alaskan Native - female. AMDPLU02 0495 0500 6 N Diploma Recipients - Amer. Indian/Alaskan Native - gender unknown. ASDPLM02 0501 0506 6 N Diploma Recipients - Asian/Pacific Islander - male. ASDPLF02 0507 0512 6 N Diploma Recipients - Asian/Pacific Islander - female. ASDPLU02 0513 0518 6 N Diploma Recipients - Asian/Pacific Islander - gender unknown. HIDPLM02 0519 0524 6 N Diploma Recipients - Hispanic - male. HIDPLF02 0525 0530 6 N Diploma Recipients - Hispanic - female. HIDPLU02 0531 0536 6 N Diploma Recipients - Hispanic - gender unknown. BLDPLM02 0537 0542 6 N Diploma Recipients - Black, not Hispanic - male. BLDPLF02 0543 0548 6 N Diploma Recipients - Black, not Hispanic - female. BLDPLU02 0549 0554 6 N Diploma Recipients - Black, not Hispanic - gender unknown. WHDPLM02 0555 0560 6 N Diploma Recipients - White, not Hispanic - male. WHDPLF02 0561 0566 6 N Diploma Recipients - White, not Hispanic - female. WHDPLU02 0567 0572 6 N Diploma Recipients - White, not Hispanic - gender unknown. TOTOHC02 0573 0578 6 N Total Other High School Completers. Comparable to OTHCOM from previous year's agency file. AMOHCM02 0579 0584 6 N Other High School Completers - Amer. Indian/Alaskan Native - male. AMOHCF02 0585 0590 6 N Other High School Completers - Amer. Indian/Alaskan Native - female. AMOHCU02 0591 0596 6 N Other High School Completers - Amer. Indian/Alaskan Native - gender unknown. ASOHCM02 0597 0602 6 N Other High School Completers - Asian/Pacific Islander - male. ASOHCF02 0603 0608 6 N Other High School Completers - Asian/Pacific Islander - female. ASOHCU02 0609 0614 6 N Other High School Completers - Asian/Pacific Islander - gender unknown. HIOHCM02 0615 0620 6 N Other High School Completers - Hispanic - male. HIOHCF02 0621 0626 6 N Other High School Completers - Hispanic - female. HIOHCU02 0627 0632 6 N Other High School Completers - Hispanic - gender unknown. BLOHCM02 0633 0638 6 N Other High School Completers - Black, not Hispanic - male. BLOHCF02 0639 0644 6 N Other High School Completers - Black, not Hispanic - female. BLOHCU02 0645 0650 6 N Other High School Completers - Black, not Hispanic - gender unknown. WHOHCM02 0651 0656 6 N Other High School Completers - White, not Hispanic - male. WHOHCF02 0657 0662 6 N Other High School Completers - White, not Hispanic - female. WHOHCU02 0663 0668 6 N Other High School Completers - White, not Hispanic - gender unknown. IGSLO02 0669 0669 1 AN If this field contains anything other than "R", the GSLO value originally submitted was adjusted. IGSHI02 0670 0670 1 AN If this field contains anything other than "R", the GSHI value originally submitted was adjusted. ISCH02 0671 0671 1 AN If this field contains anything other than "T", the aggregate number of schools associated with this agency on the school universe file was adjusted. ITEACH02 0672 0672 1 AN If this field contains anything other than "T", the aggregate FTE classroom teacher count reported for schools associated with this agency on the school universe file was adjusted. IUG02 0673 0673 1 AN If this field contains anything other than "R", the Ungraded Student count originally submitted was adjusted. IPK1202 0674 0674 1 AN If this field contains anything other than "R", the PK through 12 Student count originally submitted was adjusted. IMEMB02 0675 0675 1 AN If this field contains anything other than "T", the Total Student count (Ungraded + PK through 12) was adjusted. IMIGRN02 0676 0676 1 AN If this field contains anything other than "R", the Migrant Student count originally submitted was adjusted. ISPEC02 0677 0677 1 AN If this field contains anything other than "R", the Special Education - IEP count originally submitted was adjusted. IELL02 0678 0678 1 AN If this field contains anything other than "R", the English Language Learner Student count originally submitted was adjusted. IPKTCH02 0679 0679 1 AN If this field contains anything other than "R", the Prekindergarten Teacher count originally submitted was adjusted. IKGTCH02 0680 0680 1 AN If this field contains anything other than "R", the Kindergarten Teacher count originally submitted was adjusted. IELTCH02 0681 0681 1 AN If this field contains anything other than "R", the Elementary Teacher count originally submitted was adjusted. ISETCH02 0682 0682 1 AN If this field contains anything other than "R", the Secondary Teacher count originally submitted was adjusted. IUGTCH02 0683 0683 1 AN If this field contains anything other than "R", the Teachers of Ungraded Classes count originally submitted was adjusted. ITOTCH02 0684 0684 1 AN If this field contains anything other than "R", the Total FTE Teacher count originally submitted was adjusted. IAIDES02 0685 0685 1 AN If this field contains anything other than "R", the Instructional Aides count originally submitted was adjusted. ICOSUP02 0686 0686 1 AN If this field contains anything other than "R", the Instructional Coordinators & Supervisors count originally submitted was adjusted. IELGUI02 0687 0687 1 AN If this field contains anything other than "R", the Elementary Guidance Counselors count originally submitted was adjusted. ISEGUI02 0688 0688 1 AN If this field contains anything other than "R", the Secondary Guidance Counselors count originally submitted was adjusted. ITOGUI02 0689 0689 1 AN If this field contains anything other than "R", the Total Guidance Counselors count originally submitted was adjusted. ILISPE02 0690 0690 1 AN If this field contains anything other than "R", the Librarians/Media Specialists count originally submitted was adjusted. ILISUP02 0691 0691 1 AN If this field contains anything other than "R", the Library/Media Support Staff count originally submitted was adjusted. ILEADM02 0692 0692 1 AN If this field contains anything other than "R", the LEA Administrators count originally submitted was adjusted. ILESUP02 0693 0693 1 AN If this field contains anything other than "R", the LEA Administrative Support Staff count originally submitted was adjusted. ISCADM02 0694 0694 1 AN If this field contains anything other than "R", the School Administrative Support Staff count originally submitted was adjusted. ISCSUP02 0695 0695 1 AN If this field contains anything other than "R", the School Administrative Support Staff count originally submitted was adjusted. ISTSUP02 0696 0696 1 AN If this field contains anything other than "R", the Student Support Services Staff count originally submitted was adjusted. IOTSUP02 0697 0697 1 AN If this field contains anything other than "R", the All Other Support Services Staff count originally submitted was adjusted. ITDPL02 0698 0698 1 AN If this field contains anything other than "R", the Total Diploma Recipients count originally submitted was adjusted. IAMDPM02 0699 0699 1 AN If this field contains anything other than "R", the Diploma Recipients - Amer. Indian/Alaskan Native - male count originally submitted was adjusted. IAMDPF02 0700 0700 1 AN If this field contains anything other than "R", the Diploma Recipients - Amer. Indian/Alaskan Native - female count originally submitted was adjusted. IAMDPU02 0701 0701 1 AN If this field contains anything other than "R", the Diploma Recipients - Amer. Indian/Alaskan Native - gender unknown count originally submitted was adjusted. IASDPM02 0702 0702 1 AN If this field contains anything other than "R", the Diploma Recipients - Asian/Pacific Islander - male count originally submitted was adjusted. IASDPF02 0703 0703 1 AN If this field contains anything other than "R", the Diploma Recipients - Asian/Pacific Islander - female count originally submitted was adjusted. IASDPU02 0704 0704 1 AN If this field contains anything other than "R", the Diploma Recipients - Asian/Pacific Islander - gender unknown count originally submitted was adjusted. IHIDPM02 0705 0705 1 AN If this field contains anything other than "R", the Diploma Recipients - Hispanic - male count originally submitted was adjusted. IHIDPF02 0706 0706 1 AN If this field contains anything other than "R", the Diploma Recipients - Hispanic - female count originally submitted was adjusted. IHIDPU02 0707 0707 1 AN If this field contains anything other than "R", the Diploma Recipients - Hispanic - gender unknown count originally submitted was adjusted. IBLDPM02 0708 0708 1 AN If this field contains anything other than "R", the Diploma Recipients - Black, not Hispanic - male count originally submitted was adjusted. IBLDPF02 0709 0709 1 AN If this field contains anything other than "R", the Diploma Recipients - Black, not Hispanic - female count originally submitted was adjusted. IBLDPU02 0710 0710 1 AN If this field contains anything other than "R", the Diploma Recipients - Black, not Hispanic - gender unknown count originally submitted was adjusted. IWHDPM02 0711 0711 1 AN If this field contains anything other than "R", the Diploma Recipients - White, not Hispanic - male count originally submitted was adjusted. IWHDPF02 0712 0712 1 AN If this field contains anything other than "R", the Diploma Recipients - White, not Hispanic - female count originally submitted was adjusted. IWHDPU02 0713 0713 1 AN If this field contains anything other than "R", the Diploma Recipients - White, not Hispanic - gender unknown count originally submitted was adjusted. ITOHC02 0714 0714 1 AN If this field contains anything other than "R", the Total Other High School Completers count originally submitted was adjusted. IAMOCM02 0715 0715 1 AN If this field contains anything other than "R", the Other High School Completers - Amer. Indian/Alaskan Native - male count originally submitted was adjusted. IAMOCF02 0716 0716 1 AN If this field contains anything other than "R", the Other High School Completers - Amer. Indian/Alaskan Native - female count originally submitted was adjusted. IAMOCU02 0717 0717 1 AN If this field contains anything other than "R", the Other High School Completers - Amer. Indian/Alaskan Native - gender unknown count originally submitted was adjusted. IASOCM02 0718 0718 1 AN If this field contains anything other than "R", the Other High School Completers - Asian/Pacific Islander - male count originally submitted was adjusted. IASOCF02 0719 0719 1 AN If this field contains anything other than "R", the Other High School Completers - Asian/Pacific Islander - female count originally submitted was adjusted. IASOCU02 0720 0720 1 AN If this field contains anything other than "R", the Other High School Completers - Asian/Pacific Islander - gender unknown count originally submitted was adjusted. IHIOCM02 0721 0721 1 AN If this field contains anything other than "R", the Other High School Completers - Hispanic - male count originally submitted was adjusted. IHIOCF02 0722 0722 1 AN If this field contains anything other than "R", the Other High School Completers - Hispanic - female count originally submitted was adjusted. IHIOCU02 0723 0723 1 AN If this field contains anything other than "R", the Other High School Completers - Hispanic - gender unknown count originally submitted was adjusted. IBLOCM02 0724 0724 1 AN If this field contains anything other than "R", the Other High School Completers - Black, not Hispanic - male count originally submitted was adjusted. IBLOCF02 0725 0725 1 AN If this field contains anything other than "R", the Other High School Completers - Black, not Hispanic - female count originally submitted was adjusted. IBLOCU02 0726 0726 1 AN If this field contains anything other than "R", the Other High School Completers - Black, not Hispanic - gender unknown count originally submitted was adjusted. IWHOCM02 0727 0727 1 AN If this field contains anything other than "R", the Other High School Completers - White, not Hispanic - male count originally submitted was adjusted. IWHOCF02 0728 0728 1 AN If this field contains anything other than "R", the Other High School Completers - White, not Hispanic - female count originally submitted was adjusted. IWHOCU02 0729 0729 1 AN If this field contains anything other than "R", the Other High School Completers - White, not Hispanic - gender unknown count originally submitted was adjusted.