Schools Data Dictionary Q1 2016
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
FIELD
FIELD NAMEFIELD TYPEEXAMPLESUGGESTED DISPLAY NAMEDESCRIPTION
2
1ONBOARD_IDINTEGER1558415Not Recommended To DisplayOB assigned record identifier
3
2OB_INST_IDVARCHAR2(14)1114147Not Recommended To DisplayOB assigned institution identifier
4
3ONBOARD_DATEVARCHAR2(10)9/7/2006Not Recommended To DisplayLast date of update
5
4FILE_TYPE_TEXTVARCHAR2(20)PUBLICInstitution TypeThe OB assigned classification of educational institutions maintained on the database.
6
5OB_DISTRICT_NUMBERVARCHAR2(14)5301114032Not Recommended To DisplayOB assigned district number
7
6DISTRICT_TYPEVARCHAR2(35)REGULAR DISTRICTNot Recommended To DisplayOB classification of parent institutions, modeled after federal government coding.
8
7DISTRICT_NAMEVARCHAR2(120)BELLINGHAM SCHOOL DISTRICT 501District NameName of the district associated with a particular school.
9
8OB_SUB_DISTRICT_NUMBERVARCHAR2(14)4290568Not Recommended To DisplayOB District Number for Sub-District. Generally these are only found in very large cities that have one citywide school district also broken into sub-districts. For example, all schools in New York City belong to the New York City Public School District. However each is assigned to smaller, local sub-districts for districting purposes.
10
9SUB_DISTRICT_TYPEVARCHAR2(35)REGULAR LOCAL SCHOOL DISTRICTNot Recommended To DisplayDenotes the type of sub-district.
11
10OB_SUB_DISTRICT_NAMEVARCHAR2(120)LA USD LOCAL DISTRICT 4Sub-District NameName of the sub-district associated with a particular school.
12
11OB_BUILDING_NUMBERINTEGER56982148Not Recommended To DisplayOB assigned Building Number
13
12BUILDING_TYPE_TEXTVARCHAR2(35)REGULAR STUDENT INSTRUCTIONSchool TypeThe primary type of instruction taught within the school. The types are as follows:
A. ADULT EDUCATION SCHOOL
B. ALTERNATIVE/CONTINUING EDUCATION
C. REGULAR STUDENT INSTRUCTION
D. SPECIAL EDUCATION SCHOOL
E. VOCATIONAL/TECHNICAL
F. OTHER
14
13FIPS_STATEVARCHAR2(2)53Not Recommended To DisplayThe FIPS State Number represents the two-digit (Federal Information Processing Standard) state code.
15
14COUNTY3VARCHAR2(3)73Not Recommended To DisplayThe FIPS County Number represents a three-digit FIPS (Federal Information Processing Standard) code. County numbers are unique within each state.
16
15COUNTYNAMEVARCHAR2(50)COOKCountyFederal Information Processing Standard (FIPS) coding for name of county.
17
16GEOCODING_LATITUDENUMBER(8,6)35.466821Not Recommended To DisplayLatitude assigned by Geo-coding software based on the 9-digit ZIP code of the institution. Format for the United States is +12.345678
18
17GEOCODING_LONGITUDENUMBER(9,6)-94.377141Not Recommended To DisplayLongitude assigned by Geo-coding software based on the 9-digit ZIP code of the institution. Format for the United States is -123.456789
19
18GEO_MATCH_CODE_TEXTVARCHAR2(50)ADDRESS MATCHNot Recommended To DisplayMatch codes indicate the accuracy of the assigned centroid (latitude and longitude) for each geo-coded record.
A. ExaExt – Closest known street segment
B. ExaInt – Intersection of multiple streets
C. ExaStr – Actual location
D. ExaZip – Zip centroid
E. MulExt – Multiple street segments identified
F. MulStr – Multiple locations identified
G. Non – Address could not be geocoded
20
19INSTITUTION_NAMEVARCHAR2(120)LOWELL ELEMENTARY SCHOOLSchool NameName of institution
21
20LOCATION_ADDRESSVARCHAR2(60)935 14TH STAddressInstitution’s street address
22
21LOCATION_CITYVARCHAR2(50)BELLINGHAMCityInstitution’s city
23
22STATE_ABBREVVARCHAR2(2)WAStateInstitution’s state
24
23ZIP5_4VARCHAR2(10)98225-6305Zip CodeInstitution’s zip code
25
24PHONEVARCHAR2(30)360-676-6430Telephone NumberInstitution’s phone number
26
25START_DATEVARCHAR2(5)9/7/2015District Start DateThe calendar date all district’s schools are scheduled for opening. Rolled down from District to School, does not show School’s starting date.
27
26END_DATEVARCHAR2(5)6/22/2015District End DateThe calendar date all district’s schools are scheduled for closing. Rolled down from District to School, does not show School’s closing date.
28
27EDUCATIONAL_CLIMATE_INDEX_TEXTVARCHAR2(20)ABOVE AVERAGEEducational Climate IndexThis measure of socioeconomic status developed for OB helps identify ZIP codes with the best conditions for quality schools. It is based on the U.S. Census Bureau's Socioeconomic Status (SES) measure with weights adjusted to more strongly reflect the educational aspect of social status. Factors in this measure are income, educational achievement and occupation of persons within the ZIP code. Since this measure is based on the population of an entire ZIP code, it may not reflect the nature of an individual school.
A. UNCLASSIFIED
B. LOW
C. BELOW AVERAGE
D. AVERAGE
E. ABOVE AVERAGE
F. HIGH
29
28ADVANCED_PLACEMENTCHAR(1)NAdvanced PlacementAdvanced Placement classes are college-level classes offered at the high school level.
30
29BEFORE_AND_AFTER_SCHOOL_PRGMSCHAR(1)YBefore and After School ProgramsBefore/After School programs also known as “extended day” programs, where the school day is extended before and after school to accommodate working parents.
31
30BLUE_RIBBON_SCHOOLCHAR(1)NBlue Ribbon SchoolThe U.S. Secretary of Education established the Blue Ribbon Schools Program to honor schools which have achieved high levels of performance or made significant improvements in closing the achievement gap among student subgroups.
32
31COALITION_OF_ESSENTIAL_SCHOOLSCHAR(1)----NO LONGER SUPPORTED
33
32CHARTER_SCHOOLSCHAR(1)YCharter SchoolA charter school is a school that receives public funding but operates independently of the established public school system in which it is located.
34
33GIFTED_AND_TALENTEDCHAR(1)YGifted and TalentedGifted and Talented programs offer an accelerated curriculum and the chance for children who score particularly high on standardized tests to be in a class with other academically successful children.
35
34INTERNATIONAL_BACCALAUREATECHAR(1)NInternational BaccalaureateThe International Baccalaureate (IB) aims to develop inquiring, knowledgeable and caring young people who help to create a better and more peaceful world through intercultural understanding and respect.
36
35MAGNET_SCHOOLCHAR(1)YMagnet SchoolMagnet schools have a focused theme and aligned curricula in Science, Technology, Engineering, and Mathematics, Fine and Performing Arts.
37
36SITE_BASEDCHAR(1)YSite BasedA Site Based school is a school that has budget authority.
38
37COLLEGE_BOUNDINTEGER90College Bound Seniors (%)This value represents the % of seniors who graduate from this school.
39
38TEACHERS_PROFESSIONAL_STAFFINTEGER14Full-Time TeachersNumber of full-time classroom teachers at an institution.
40
39GRADE_SPAN_CODE_BLDG_TEXTVARCHAR2(20)K - 5Grade SpanRepresents the general grade range for a facility of this type. May not accurately reflect grades taught at this location.
41
40GRADE_LEVEL_1_LO_TEXTVARCHAR2(50)1Lowest Grade LevelLowest grade level for which there is instruction.
42
41GRADE_LEVEL_1_HI_TEXTVARCHAR2(50)12Highest Grade LevelHighest grade level for which there is instruction.
43
42VOC_TECHCHAR(1)NVocational/Technical CurriculumCourses that provide students with the vocational education and technical skills they need in order to perform the tasks of a particular job.
44
43ADULT_EDUCATION_CLASSESCHAR(1)YAdult Education ClassesPrograms offering GED or equivalent courses for adults within regular schools, whether classes are held during evening or daytime schedules. An asterisk (*) will be shown if the school’s primary function is to serve adult students.
45
44SPECIAL_EDUCATIONCHAR(1)YSpecial Education ClassesA school or program within a school that provides services and training to students with moderate to severe mental and/or physical disabilities. An asterisk (*) will be shown if the school’s primary function is to serve as a special education campus.
46
45ALTERNATIVE_PROGRAMSCHAR(1)YAlternative ProgramsAlternative education offers a specialized curriculum designed to meet the needs of a particular group of students. Students may be levels or grades behind, have behavioral problems, need small classroom settings and are often at risk of dropping out of school.
47
46YEAR_ROUND_CLASSESCHAR(1)NYear Round ClassesAn Institution operating regular classes throughout the entire calendar year.
48
47NUMBER_OF_CLASSROOMSINTEGER----NO LONGER SUPPORTED
49
48STUDENTS_NUMBER_OFINTEGER275Number of StudentsExact student enrollment, phone-verified. * The number of students may include charter or specialty programs located on the same physical campus as the main school.
50
49ENROLLMENT_BY_GRADE_UNGRADEDINTEGER0Ungraded EnrollmentData is available for public buildings in every state. Data is computer-generated for private and Catholic buildings.
51
50ENROLLMENT_BY_GRADE_PRE_KINTEGER0Pre-kindergarten EnrollmentEnrollment by Grade - Pre-kindergarten IMPORTANT NOTE: Grade level enrollments are
obtained from the NCES and are the federally
reported enrollment numbers. This data tends to lag
2-3 years behind the current school year. If you want to
display the individual grade level enrollments, we suggest
you sum them to achieve the total enrollment. That way
the information will be consistent but somewhat dated.
52
51ENROLLMENT_BY_GRADE_KGTNINTEGER47Kindergarten EnrollmentEnrollment by Grade - Kindergarten
53
52ENROLLMENT_BY_GRADE_ONEINTEGER51Grade One EnrollmentEnrollment by Grade - Grade One
54
53ENROLLMENT_BY_GRADE_TWOINTEGER56Grade Two EnrollmentEnrollment by Grade - Grade Two
55
54ENROLLMENT_BY_GRADE_THREEINTEGER50Grade Three EnrollmentEnrollment by Grade - Grade Three
56
55ENROLLMENT_BY_GRADE_FOURINTEGER42Grade Four EnrollmentEnrollment by Grade - Grade Four
57
56ENROLLMENT_BY_GRADE_FIVEINTEGER63Grade Five EnrollmentEnrollment by Grade - Grade Five
58
57ENROLLMENT_BY_GRADE_SIXINTEGER102Grade Six EnrollmentEnrollment by Grade - Grade Six
59
58ENROLLMENT_BY_GRADE_SEVENINTEGER125Grade Seven EnrollmentEnrollment by Grade - Grade Seven
60
59ENROLLMENT_BY_GRADE_EIGHTINTEGER117Grade Eight EnrollmentEnrollment by Grade - Grade Eight
61
60ENROLLMENT_BY_GRADE_NINEINTEGER243Grade Nine EnrollmentEnrollment by Grade - Grade Nine
62
61ENROLLMENT_BY_GRADE_TENINTEGER296Grade Ten EnrollmentEnrollment by Grade - Grade Ten
63
62ENROLLMENT_BY_GRADE_ELEVENINTEGER338Grade Eleven EnrollmentEnrollment by Grade - Grade Eleven
64
63ENROLLMENT_BY_GRADE_TWELVEINTEGER0.326Grade Twelve EnrollmentEnrollment by Grade - Grade Twelve
65
64INSTRUCTIONAL_EXPENSE_PUPILINTEGER10000Instructional Expense (Dollars Per Pupil)Dollar Expenditures on instructional materials per pupil.
66
65CURRENT_EXPENSE_PUPILINTEGER8400Current Expenses Per PupilAll other expenses per pupil.
67
66TECHNOLOGY_MEASURE_TEXTVARCHAR2(12)MEDIUM-HIGHTechnology MeasureAn indicator developed for OB used to indicate the presence of electronic technology in schools that accounts for their different sizes, the different student populations that they serve and the different types of equipment in their technology mix. Schools with “high technology presence” can be understood to have the equipment that would make it possible for technology to have a substantial impact on students’ education. The indicators were derived by factor analysis of data regarding modems, interactive videodisc, satellite dish, networks, cable television, computers, monitors, presence of an ILS system, presence of a World Wide Web browser or homepage, and the number of on-line services subscribed to.
Also included in the analysis were enrollment, number of schools in the district, grades taught, student percentages, multicultural student percentages, per-pupil expenditures (DDP) and Lifestyle indicator.
A. HIGH
B. MEDIUM-HIGH
C. MEDIUM
D. MEDIUM-LOW
E. LOW
F. NOT REPORTED
68
67COMPUTER_GRAND_TOTALINTEGER85Instructional ComputersThe number of computer units used by students.
69
68NUMBER_OF_PCSVARCHAR2(1)----NO LONGER SUPPORTED
70
69NUMBER_OF_MACSVARCHAR2(1)----NO LONGER SUPPORTED
71
70POVERTY_LEVELVARCHAR2(25)6 - 15.9 PERCENTPercentage of Population in PovertyPercentage of population within the area meeting the federal classification of poverty.
72
71PERSON_NUMBERINTEGER20001Not Recommended To DisplayThe person number represents a sequential number for each person within an institution.
73
72PREFIX_LITERALVARCHAR2(10)MRPrefixPrefix (MR, MS, DR, etc.) for Principal.
74
73FIRST_NAMEVARCHAR2(50)SEYMOURFirst NameThe Principal’s first name.
75
74LAST_NAMEVARCHAR2(60)SKINNERLast NameThe Principal’s last name.
76
75GENDERVARCHAR2(10)MGenderThe Principal’s gender. U = Unknown
77
76ENGLISH_TITLEVARCHAR2(50)PRINCIPALTitleThe Principal’s official job title.
78
77WEBSITE_URLVARCHAR2(300)http://schools.roundrockisd.org/stonypoint/WebsiteSchool or district’s web site URL.
79
78ZIPVARCHAR2(5)98225Not Recommended To Display5 digit zip code – may be useful in matching to other content.
80
79COUNTYVARCHAR2(5)53073Not Recommended To Display5 digit county FIPS code – may be useful in matching to other content.
81
80STUDENT_TEACHERVARCHAR2(12)18Student/Teacher RatioThe ratio of teachers to students within the school. If there is insufficient data from the vendor, “Not Reported” will be displayed.
82
81STUDENTS_GRADENUMBER(6,1)413Students Per GradeThe ratio of students per grade within the school. If there is insufficient data from the vendor, “Not Reported” will be displayed.
83
82PRESCHOOLCHAR(1)YNot Recommended To DisplayAn indicator whether the school is a preschool. The letter “Y” will appear if the school belongs to the specific category, otherwise it will be a blank field.
84
83ELEMENTARYCHAR(1)YNot Recommended To DisplayAn indicator whether the school is an elementary school. The letter “Y” will appear if the school belongs to the specific category, otherwise it will be a blank field.
85
84MIDDLECHAR(1)YNot Recommended To DisplayAn indicator whether the school is a middle/junior high school. The letter “Y” will appear if the school belongs to the specific category, otherwise it will be a blank field.
86
85HIGHCHAR(1)YNot Recommended To DisplayAn indicator whether the school is a high school. The letter “Y” will appear if the school belongs to the specific category, otherwise it will be a blank field.
87
86ADULT_OTHERCHAR(1)YNot Recommended To DisplayAn indicator whether the school is an adult education school. The letter “Y” will appear if the school belongs to the specific category, otherwise it will be a blank field.
88
87GRADE_LEVEL_1_LO_CODEVARCHAR2(2)PKGrades Taught (Low)An indicator of the lowest grade offered at the school.
89
88GRADE_LEVEL_1_HI_CODEVARCHAR2(10)5Grades Taught (High)An indicator of the highest grade offered at the school.
90
89ESLCHAR(1)YESLA school teaching English language classes to students whose first language is not English.
91
90ENROLLMENT_SHIFTVARCHAR2(20)-6% TO -10%Change in EnrollmentThe change in school enrollment from the previous year.
92
91AYP_SCHOOLCHAR(1)YAdequate Yearly ProgressSchools that have failed to make adequate yearly progress over the past year as determined by state defined standards.
93
92NCLB_SCHOOLCHAR(1)YNo Child Left Behind Improvement SchoolNo Child Left Behind Improvement Schools are schools that have failed to make adequate yearly progress for three or more years.
94
93NCLB_SCHOOL_SUBJECTS_FAILEDVARCHAR2(120)----NO LONGER SUPPORTED
95
94NCLB_SCHOOL_YEARSVARCHAR2(20)----NO LONGER SUPPORTED
96
95GS_TEST_RATINGINTEGER5Test Score RatingSchool Test Score Rating. The rating is based purely on the test score performance of each school. It is based on a scale of 0-5, 5 being best.
97
96GS_IDVARCHAR2(14)360013504605Not Recommended To DisplayUnique 12 digit identification number assigned by The National Center for Education Statistic (NCES).
98
97OS_TYPEVARCHAR2(20)MProminence of Operating SystemIndication of which computer operating system is most prevalent:
A. W – Windows
B. M – Mac
C. L – Linux
D. Not Reported
99
100
Loading...
Main menu