SIS Handbook | Database Table SchemaBUS - Supplemental Transportation

Main Overview Data Submission Cycles Cycle Reports Data Sources Database Table Schema Previous Table Schema Appendices Handbook Changes Handbook Downloads

Database Schema for Handbook 2024-2025

Back to List
View Source Document for Table 'supptransp'

BUS - Supplemental Transportation (TP)

[supptransp]

ID	Element	Name	Type	Size	Values	Cycle
	Key
TP0010	Fiscal Year - The fiscal year that this reporting represents: For the 2024-2025 reporting year fy must be = 35	fy	Num	2	Table	6
TP0020	Cycle - The reporting cycle for which the data is submitted: 6 = April 15^th	cycle	Num	2	Table	6
TP0030	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	6
TP0040	Receiving Center/City – Name/Location of receiving center	rec_center	Alpha	30		6
TP0050	Type Transportation Provided: 01 = School Bus 02 = Car 03 = Other	type_transp	Num	2	Table	6
	General Information – List all special education and handicapped students you are transporting to approved centers. This includes the Arkansas School for the Blind and/or the Arkansas School for the Deaf in Little Rock.
TP0060	Students Transported – The number of special education and handicapped students being transported to approved centers.	stud_transp	Num	2		6
TP0070	Distance One-Way – The mileage one way to the special education and handicapped approved centers.	dist_1_way	Num	3		6

No change

Added

Modified

Deleted