Common Core of Data, Local Education Agency Universe Survey, 2006-07 FILE NAME = ag061c.dat, 2006-07 NVAR = 87 NOBS = 18,250 LRECL = 530 (*) Fields have one explicit decimal place (+) Fields represent sub-fields of the fields immediately preceding them. NOTE: The file contains data for the school year 2006-07 sorted by the NCES assigned local education agency identification code (LEAID). Throughout the remainder of this file, the following codes may appear as representing missing values whenever they are present in the data or the documentation. M: when alphanumeric data are missing; that is, a value is expected but none was measured. -1: when numeric data are missing; that is, a value is expected but none was measured. N: when alphanumeric data are not applicable; that is, a value is neither expected nor measured. -2: when numeric data are not applicable; that is, a value is neither expected nor measured. ============================================================================================================================================ 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 are also the Federal Information Profesing Standards (FIPS) state code. FIPST 0001 0002 2 AN Federal Information Processing Standards (FIPS) state code. STID06 0008 0021 14 AN State’s own ID for the education agency. NAME06 0022 0081 60 AN Name of the education agency. PHONE06 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. MSTREE06 0092 0121 30 AN Mailing address of the agency—may be a street address, a P.O. Box number, or, if there is no address beyond CITY, STATE, and ZIP, the character “N.” MCITY06 0122 0151 30 AN Name of the agency mailing address city. MSTATE06 0152 0153 2 AN Two-letter U.S. Postal Service abbreviation for the state where the mailing address is located. MZIP06 0154 0158 5 AN Five-digit U.S. Postal Service ZIP code for the mailing address. MZIP406 0159 0162 4 AN Four-digit ZIP+4, if assigned; if none, field is blank. LSTREE06 0163 0192 30 AN Location address of agency. LCITY06 0193 0222 30 AN Location city of agency. LSTATE06 0223 0224 2 AN Location state (two-letter postal abbreviation). LZIP06 0225 0229 5 AN Location 5-digit ZIP Code. LZIP406 0230 0233 4 AN Location +4 ZIP Code. TYPE06 0234 0234 1 AN Agency type code: 1 = Regular local school district. Locally governed agency responsible for providing free public elementary or secondary education; includes independent school districts and those that are a dependent segment of a local government such as a city or county. 2 = Local school district that is a component of a supervisory union. Regular local school district that shares its superintendent and administrative services with other school districts participating in the supervisory union. 3 = Supervisory Union. An education agency that performs administrative services for more than one school district, providing a common superintendent for participating districts. 4 = Regional Education Service Agency. Agency providing specialized education services to a variety of local education agencies, or a county superintendent serving the same purposes. 5 = State-Operated Agency. Agency that is charged, at least in part, with providing elementary and/or secondary instruction or support services. Includes the State Education Agency if this agency operates schools. Examples include elementary/secondary schools operated by the state for the deaf or blind; and programs operated by state correctional facilities. 6 = Federally-Operated Agency. A federal agency that is charged, at least in part, with providing elementary or secondary instruction or support services. 7 = Other Education Agency. Agency providing elementary or secondary instruction or support services that does not fall within the definitions of agency types 1–6 (NOTE: This includes charter school agencies). UNION06 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.” CONUM06 0238 0242 5 AN FIPS county number (two digit FIPS state numeric code + three digits FIPS county code) based on the location of the administrative office. NOTE: Position #0238–0239 is the FIPS state number, and position #0240–0242 is the FIPS number for county within state. CONAME06 0243 0272 30 AN County name based on the location of the administrative office. CSA06 0273 0275 3 AN Combined Statistical Area (CSA). The CSA assignment is based on the CSA assignments of schools associated with the agency, weighted by the number of students in each school. 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. If the school(s) used to weight the assignment are not within a CSA, the field will be assigned an "N" (not applicable). NOTE: Starting in 2006–07, this field will contain the CSA code for all areas. Prior to this year, this field contained the New England City and Town Areas (NECTA) codes for agencies in the New England States. CBSA06 0276 0280 5 AN Core Based Statistical Area (CBSA). 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. The integration of adjacent communities is determined by the CBSAs of schools associated with the agency, weighted by the number of students in each school. If the agency is not in any type of metropolitan/micropolitan statistical area the field contains an "N" (not applicable). NOTE: Starting in 2006–07, this field will contain the CBSA code for all areas. Prior to this year, this field contained the NECTA codes for agencies in the New England States. This assignment was made using a file of FIPS county codes matched to CBSA codes. METMIC06 0281 0281 1 AN Indicates whether the CBSA is a metropolitan or micropolitan area. 0 = CBSA is equal to 70,300 or higher and does not have an associated type code. CBSA equal to 70,300 or higher is NECTA and is not denoted as metropolitan or micropolitan. 1 = CBSA is a metropolitan area. 2 = CBSA is a micropolitan area. MSC06 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 a CBSA. ULOCAL06 0283 0284 2 AN NCES urban-centric locale code. NOTE: Starting in 2006–07, CCD data files contain a new locale code system that is based on the urbanity of the agency location. In prior years, the locale was assigned based on an agency's metro status. See appendix C, Glossary for more detail. 11 = City, Large Territory inside an urbanized area and inside a principal city with population of 250,000 or more. 12 = City, Mid-size Territory inside an urbanized area and inside a principal city with a population less than 250,000 and greater than or equal to 100,000. 13 = City, Small Territory inside an urbanized area and inside a principal city with a population less than 100,000. 21 = Suburb, Large Territory outside a principal city and inside an urbanized area with population of 250,000 or more. 22 = Suburb, Mid-size Territory outside a principal city and inside an urbanized area with a population less than 250,000 and greater than or equal to 100,000. 23 = Suburb, Small Territory outside a principal city and inside an urbanized area with a population less than 100,000. 31 = Town, Fringe Territory inside an urban cluster that is less than or equal to 10 miles from an urbanized area. 32 = Town, Distant Territory inside an urban cluster that is more than 10 miles and less than or equal to 35 miles from an urbanized area. 33 = Town, Remote Territory inside an urban cluster that is more than 35 miles from an urbanized area. 41 = Rural, Fringe Census-defined rural territory that is less than or equal to 5 miles from an urbanized area, as well as rural territory that is less than or equal to 2.5 miles from an urban cluster. 42 = Rural, Distant Census-defined rural territory that is more than 5 miles but less than or equal to 25 miles from an urbanized area, as well as rural territory that is more than 2.5 miles but less than or equal to 10 miles from an urban cluster. 43 = Rural, Remote Census-defined rural territory that is more than 25 miles from an urbanized area and is also more than 10 miles from an urban cluster. CDCODE06 0285 0288 4 AN Congressional district code based on location of administrative office. FIPS numeric code for the congressional districts that are legislatively defined subdivision of the state for the purpose of electing representatives to the House of Representative of the United States Congress. The first two digits are the FIPS state numeric code, which makes the congressional district code unique across states (see Appendix C Glossary for detail). If an agency serves more than one congressional district, the code represents the primary one. LATCOD06 0289 0297 9* N Latitude. Based on the location of the administrative office, the value of LATCOD ranges from 17 to 71. It contains an explicit decimal point. The digits to the left of the decimal represent the number of degrees from the equator; the digits to the right of the decimal represent the fraction of the next degree carried out to six decimal places. LONCOD06 0298 0308 11* N Longitude. Based on the location of the administrative office, the value of LONCOD ranges from -65 to -177. The minus sign (-) indicates west of the prime meridian. It contains an explicit decimal point. The digits to the left of the decimal point represent the number of degrees from the prime meridian; the digits to the right of the decimal point represent the fraction of the next degree carried out to six decimal places. BOUND06 0309 0309 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 as follows: 1 = No significant boundary change for this agency since the last report. Currently in operation. 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 in previous year’s CCD agency universe survey, and is now being added 5 = Agency has undergone a significant change in geographic boundaries or instructional responsibility. 6 = Agency is temporarily closed and may reopen within 3 years. 7 = Agency is scheduled to be operational within 2 years. 8 = Agency was closed on previous year’s file but has reopened. GSLO06 0310 0311 2 AN Agency low grade offered. If grade span data were not reported, this field was calculated from the low grade spans of the associated schools in the CCD school universe file. GSHI06 0312 0313 2 AN Agency high grade offered. If grade span data were not reported, this field was calculated from the high grade spans of the associated schools in the CCD school universe file. When combined, GSLO and GSHI are the grade span of the school. AGCHRT06 0314 0314 1 AN Agency charter. Code indicating charter schools served: 1 = All associated schools are charter schools. 2 = All associated schools are charter and noncharter schools. 3 = All associated schools are noncharter schools. SCH06 0315 0319 5 N Aggregate number of schools associated with this agency in the CCD school universe file. TEACH06 0320 0326 7* N Aggregate full-time-equivalent (FTE) classroom teachers reported for schools associated with this agency in the CCD school universe file, reported to the nearest tenth; field includes one explicit decimal point. This is not necessarily the total number of teachers employed by the agency. UG06 0327 0333 7 N Total number of students in classes or programs without standard grade designations. PK1206 0334 0340 7 N Total number of students in classes from prekindergarten through 12th grade that are part of the public school program. MEMBER06 0341 0347 7 N Calculated total student membership of the local education agency: the sum of the fields UG and PK12. MIGRNT06 0348 0354 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 2006–07 school year. SPECED06 0355 0361 7 N Count of all students having a written Individualized Education Program (IEP) under the Individuals With Disabilities Education Act (IDEA), Part B. ELL06 0362 0368 7 N The number of English language learner (ELL) students served in appropriate programs. PKTCH06 0369 0375 7* N Prekindergarten teachers. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. KGTCH06 0376 0382 7* N Kindergarten teachers. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. ELMTCH06 0383 0389 7* N Elementary teachers. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. SECTCH06 0390 0396 7* N Secondary teachers. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. UGTCH06 0397 0403 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. TOTTCH06 0404 0410 7* N Total teachers. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. AIDES06 0411 0417 7* N Instructional aides. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. CORSUP06 0418 0424 7* N Instructional coordinators & supervisors. Full-time equivalency reported to the nearest tenth; includes one explicit decimal. ELMGUI06 0425 0431 7* N Elementary guidance counselors. Full-time equivalency reported to the nearest tenth; includes one explicit decimal. SECGUI06 0432 0438 7* N Secondary guidance counselors. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. TOTGUI06 0439 0445 7* N Total guidance counselors. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. LIBSPE06 0446 0452 7* N Librarians/media specialists. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. LIBSUP06 0453 0459 7* N Library/media support staff. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. LEAADM06 0460 0466 7* N LEA administrators. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. LEASUP06 0467 0473 7* N LEA administrative support staff. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. SCHADM06 0474 0480 7* N School administrators. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. SCHSUP06 0481 0487 7* N School administrative support staff. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. STUSUP06 0488 0494 7* N Student support services staff. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. OTHSUP06 0495 0501 7* N All other support services staff. Full-time equivalency reported to the nearest tenth; field includes one explicit decimal. IGSLO06 0502 0502 1 AN If this field contains anything other than “R,” the GSLO value originally submitted was adjusted. IGSHI06 0503 0503 1 AN If this field contains anything other than “R,” the GSHI value originally submitted was adjusted. ISCH06 0504 0504 1 AN If this field contains anything other than “T,” the aggregate number of schools associated with this agency in the school universe file was adjusted. ITEACH06 0505 0505 1 AN If this field contains anything other than “T,” the aggregate FTE classroom teacher count reported for schools associated with this agency in the school universe file was adjusted. IUG06 0506 0506 1 AN If this field contains anything other than “R,” the ungraded student count originally submitted was adjusted. IPK1206 0507 0507 1 AN If this field contains anything other than “R,” the PK through 12 student count originally submitted was adjusted. IMEMB06 0508 0508 1 AN If this field contains anything other than “T,” the total student count (ungraded plus PK through 12) was adjusted. IMIGRN06 0509 0509 1 AN If this field contains anything other than “R,” the migrant student count originally submitted was adjusted. ISPEC06 0510 0510 1 AN If this field contains anything other than “R,” the special education/IEP count originally submitted was adjusted. IELL06 0511 0511 1 AN If this field contains anything other than “R,” the English language learner student count originally submitted was adjusted. IPKTCH06 0512 0512 1 AN If this field contains anything other than “R,” the prekindergarten teacher count originally submitted was adjusted. IKGTCH06 0513 0513 1 AN If this field contains anything other than “R,” the kindergarten teacher count originally submitted was adjusted. IELTCH06 0514 0514 1 AN If this field contains anything other than “R,” the elementary teacher count originally submitted was adjusted. ISETCH06 0515 0515 1 AN If this field contains anything other than “R,” the secondary teacher count originally submitted was adjusted. IUGTCH06 0516 0516 1 AN If this field contains anything other than “R,” the teachers of ungraded classes count originally submitted was adjusted. ITOTCH06 0517 0517 1 AN If this field contains anything other than “R,” the total FTE teacher count originally submitted was adjusted. IAIDES06 0518 0518 1 AN If this field contains anything other than “R,” the instructional aides count originally submitted was adjusted. ICOSUP06 0519 0519 1 AN If this field contains anything other than “R,” the instructional coordinators and supervisors count originally submitted was adjusted. IELGUI06 0520 0520 1 AN If this field contains anything other than “R,” the elementary guidance counselors count originally submitted was adjusted. ISEGUI06 0521 0521 1 AN If this field contains anything other than “R,” the secondary guidance counselors count originally submitted was adjusted. ITOGUI06 0522 0522 1 AN If this field contains anything other than “R,” the total guidance counselors count originally submitted was adjusted. ILISPE06 0523 0523 1 AN If this field contains anything other than “R,” the librarians/media specialists count originally submitted was adjusted. ILISUP06 0524 0524 1 AN If this field contains anything other than “R,” the library/media support staff count originally submitted was adjusted. ILEADM06 0525 0525 1 AN If this field contains anything other than “R,” the LEA administrators count originally submitted was adjusted. ILESUP06 0526 0526 1 AN If this field contains anything other than “R,” the LEA administrative support staff count originally submitted was adjusted. ISCADM06 0527 0527 1 AN If this field contains anything other than “R,” the school administrative support staff count originally submitted was adjusted. ISCSUP06 0528 0528 1 AN If this field contains anything other than “R,” the school administrative support staff count originally submitted was adjusted. ISTSUP06 0529 0529 1 AN If this field contains anything other than “R,” the student support services staff count originally submitted was adjusted. IOTSUP06 0530 0530 1 AN If this field contains anything other than “R,” the all other support services staff count originally submitted was adjusted.