Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'bus'

BUS (BU)

[bus]

ID Element Name Type Size Values Cycle

Key

BU0010

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

fy Num 2 Table 3,5,6,7
BU0020

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

3 = November 15th
5 = February 15th
6 = April 15th
7 = June 15th
cycle Num 2 Table 3,5,6,7
BU0030

LEA, District - 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:

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

Bus Inspection Dates

BU0050

Fall Inspection Date - Indicates the date the district inspected buses for the fall semester.

fall_inspect_date Date 8 MMDDYYYY 3
BU0060

Spring Inspection Date - Indicates the date the district inspected buses for the spring semester.

spring_inspect_date Date 8 MMDDYYYY 6
BU0065

Vin Number - The (VIN) vehicle identification number is the 18 numbers on the plate assigned to the bus by the manufacturer.

vin_num Alpha 18 3,5,6,7

Bus Description

BU0090

Body Make - The name of the company that made the school bus body:

01 = AmTran  07 = Thomas
02 = Ward      08 = Couchette
03 = Blue Bir   09 = Collins
04 = Wayne    10 = Other
05 = Carpenter11 = International
06 = Superior

body_make Num 2 Table 3,5,6,7
BU0100

Body Model Year - The year in which the school bus body was manufactured.

body_year Num 4 YYYY 3,5,6,7
BU0110

Primary Usage - Use the following codes to describe the primary usage of the bus:

1 = Route
2 = Spare
3 = Activity

primary_use Num 1 Table 3,5,6,7
BU0120

Capacity Code - The manufacturers’ rated capacity of the bus.

capacity Num 2 3,5,6,7
BU0130

Fuel Type - The type of fuel the bus is currently designed for as:

G = Gasoline P = Propane
D = Diesel C = CNG
fuel_type Alpha 1 Table 3,5,6,7
BU0140

Primarily for Handicapped - Indicates if the bus is used primarily to transport handicapped students.

prim_handicap Alpha 1 Y/N 3,5,6,7
BU0150

Wheelchair Lift - Indicates if the bus is equipped with a wheelchair lift or ramp.

wheelchair_lift Alpha 1 Y/N 3,5,6,7
BU0151

Passenger Restraint System - Indicates if the bus is equipped with a passenger restraint system.

psngr_restraint Alpha 1 Y/N 3,5,6,7
BU0155

Wi-Fi Enabled - Does the bus provide a Wi-Fi enabled connection?

wifi_enabled Alpha 1 Y/N 3,5,6,7

Purchase Details

BU0160

Purchase Method - The method used to acquire the bus for service as one of these codes:

N = Bought New
U = Bought Used
C = Lease Contract
purch_method Alpha 1 Table 3,5,6,7
BU0170

Purchase Amount - The total dollar amount paid for the chassis and body if bought as a unit or the annual contract amount for the bus.

purch_amt Num 6 3,5,6,7
BU0180

Date, Purchase - The date on which the bus was purchased or leased.

purch_date Date 8 MMDD YYYY 3,5,6,7

Fiscal Year InformationThe following information should reflect statistics for the current school year.

BU0190

Daily Route Mileage - The total distance the bus travels each day for the purpose of transporting students to and from school. Include both morning and afternoon trips to compute total mileage traveled in one day.

route_mileage Num 3 3,5,6,7
BU0200

Bus Damage Amount - The dollar amount it took to fix damage caused by accident(s) involving this bus. (accumulated by fiscal year)

bus_damage_amt Num 7 3,5,6,7
BU0210

Destroyed - Indicates that the bus was destroyed in an accident.

destroyed Alpha 1 Y/N 3,5,6,7
BU0220

Property Damage Amount - The dollar amount of damage to personal property caused by accident(s) involving this bus. (accumulated by fiscal year)

prop_damage_amt Num 7 3,5,6,7
BU0230

Total Accidents - The number of bus related accidents for the particular bus. (accumulated by fiscal year)

accidents_fy Num 2 3,5,6,7
BU0240

Student Fatalities - The number of students fatally injured in accident(s) involving this bus. (accumulated by fiscal year)

fatal_student Num 2 3,5,6,7
BU0250

Driver Fatalities - The number of bus drivers fatally injured in accident(s) involving this bus. (accumulated by fiscal year)

fatal_driver Num 2 3,5,6,7
BU0260

Teacher Fatalities - The number of schoolteachers fatally injured in accident(s) involving this bus. (accumulated by fiscal year)

fatal_teacher Num 2 3,5,6,7
BU0270

Other Fatalities - The number of persons other than students, bus drivers, and teachers fatally injured in accident(s) involving this bus. (accumulated by fiscal year)

fatal_other Num 2 3,5,6,7
BU0280

Student Injuries - The number of students injured by accident(s) involving this bus. (accumulated by fiscal year)

injury_student Num 2 3,5,6,7
BU0290

Driver Injuries - The number of bus drivers injured by accident(s) involving this bus. (accumulated by fiscal year)

injury_driver Num 2 3,5,6,7
BU0300

Teacher Injuries - The number of school teachers injured by accident(s) involving this bus. (accumulated by fiscal year)

injury_teacher Num 2 3,5,6,7
BU0310

Other Injuries - The number of persons other than students, bus drivers, and teachers injured by accident(s) involving this bus. (accumulated by fiscal year)

injury_other Num 2 3,5,6,7
BU0320

Out-of-Service Date - The date the bus is no longer used for the transportation of students.

outserv_date Date 8 MMDD YYYY 3,5,6,7
No change Added Modified Deleted

Back to List