S_TN_DISTRICTBUSSTAFF_S (ver 15.12.0)
This table is a standalone table for TN District Bus Staff Information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 15.12.0 | Number(11,0) | Unique Record ID. |
| SCHOOLYEAR | 15.12.0 | Number(11,0) | The four-digit school year that the instructional program will be operated to provide instructional services to students. The year of the fall semester. Must be in format, “CCYY”. |
| REGULARDRIVER | 15.12.0 | Number(11,0) | New number of regular drivers. |
SUBSTITUTEDRIVER | 15.12.0 | Number(11,0) | New number of substitute drivers. |
EMPLOYEDDRIVERCDL | 15.12.0 | Number(11,0) | New number of employed bus drivers with CDL. |
CONTRACTEDDRIVERCDL | 15.12.0 | Number(11,0) | New number of contracted drivers with CDL. |
BUSASSISTANTS | 15.12.0 | Number(11,0) | New number of bus assistants. |
| BUSGARAGEMAINT | 15.12.0 | Varchar2(1) | Does district own and operate a bus garage and perform bus maintenance value? |
| MAINTENANCENONSCHBUS | 15.12.0 | Varchar2(1) | Does the bus garage mechanics perform maintenance on non-school bus vehicles value? |
FULLTIMEMECHANICS | 15.12.0 | Number(11,0) | Number of full time mechanics employed by the district value. |