Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'fac_build'

Facility - Building (FB)

[fac_build]

ID Element Name Type Size Values Cycle

Key

FB0010

Fiscal Year - The fiscal year that this reporting represents:
For the 2021-2022 reporting year fy must be = 32

fy Num 2 Table 7
FB0020

Cycle - The reporting cycle for which the data is submitted:

7 = June 15th
cycle Num 2 Table 7
FB0030

LEA, District -Local Education Agency, the unique seven-digit number assigned by the ADE to identify individual county, district, and cooperative. The first two digits represent the county, the second two digits represent the district, and the last three digits represent the individual school, for example:

6001000
60 = Pulaski County
01 = Little Rock School District
000 = N/A (zeroes for district)
lea Alpha 7 Appendix B,D 7
FB0040

LEA, School -Local Education Agency, the unique seven-digit number assigned by the ADE to identify individual county, district, schools, cooperatives, and vocational institutions. The first two digits represent the county, the second two digits represent the district, and the last three digits represent the individual school, for example:

6001002
60 = Pulaski County
01 = Little Rock School District
002 = Hall High School
id Alpha 10 7

General Information

FB0100

Primary Use - The primary educational use of the building as best described by one of the following:

01 = K-12 Comprehensive
02 = Kindergarten/Pre-School
03 = Elementary or Primary
04 = Middle School
05 = Junior High School
06 = Senior High School
07 = Science
08 = Vocationa
09 = Special Education
10 = Music/Band
11 = Library/Media Center
12 = Fine Arts
13 = Gymnasium
14 = Cafeteria
15 = Physical Education
16 = Multi-Purpose
17 = Administrative
18 = Transportation Fac
19 = Field House
20 = Adult Education l
21 = Maint/Storage
22 = Community Activity
23 = Abandoned
24 = Techstart
primary_use Num 2 Table 7
FB0150

Grade Level, Low - The number representing the lowest grade taught in the building. One of the following codes must be used:

P = Pre-School
K = Kindergarten
01 = 1st Grade
02 = 2nd Grade
03 = 3rd Grade
04 = 4th Grade
05 = 5th Grade
06 = 6th Grade
07 = 7th Grade
08 = 8th Grade
09 = 9th Grade
10 = 10th Grade
11 = 11th Grade
12 = 12th Grade
grade_low Alpha 2 Table 7
FB0160

Grade Level, High - The number representing the highest grade taught in the building. See the preceding list of values.

grade_high Alpha 2 Table 7
FB0280

Wired for Internet - Enter the number of rooms within this building that is wired for accessibility to the Internet.

internet_conn Num 3 7
FB0285

Type of Internet Service - The type of Internet service available in the building. One of the following codes must be used:

01 = Dial Up
02 = High Speed (Includes Wireless)
03 = None

type_serv Alpha 2 Table 7
FB0290

Computer Stations - The total number of instructional computer stations. The unduplicated number of computer stations available to students for instruction (classrooms, media center, media cart computers moved from one class to another).

comp_stations Num 3 7
FB0300

Multimedia Computer Stations - Enter the number of instructional computer stations located within the building that have multimedia computers i.e. computers that have sound cards, speakers, and CD ROMS.

multimed_stations Num 3 7
FB0305

Other Devices - The total number of equipment such as smart phones, portable media players, and other Internet mobile devices; interactive tablets; netbooks; e-book tools; and all other devices that can connect to the Internet for instructional purposes.

oth_devices Num 4 7
FB0310

Instructional Classrooms - Enter the number of rooms within the building that are used primarily for instructional purposes i.e. more than 50% of the occupied time.

inst_classroom Num 3 7
FB0320

School Year of Initial Receipt of Equipment - The school year in which the high school received the donated equipment. (example: 2017/18)

receipt_of_equipment Alpha 7 7
FB0330

Number of VR Sets Received - The number of VR Kits(Oculus Rift and Computer) received by the School LEA as part of the Arkansas/Facebook/Techstart Donation.

oculus_rift_kits Num 2 7
No change Added Modified Deleted

Back to List