016 – District Bus Staff Extract
Introduction
This extract is to provide additional data about district bus staff within the school district.
Report Input
For help with navigation and extract generation, see Create Audit Based Extract File (015, 016, 022).
Extract Output
Each of the fields displayed in the output of the report are described below. SeeUnderstanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName | Field Length | Track |
|---|---|---|---|---|---|
1 | Record ID | The identifier of this record. | Always "016" | 3 | N |
2 | Record Version | The version of this record. | Always "01" | 2 | N |
3 | Record Type | One of the following record types is reported in order to indicate how to modify the state data to match data in PowerSchool. The data in this record either needs to be added to, modified in, or deleted from the state data:
| N/A | 1 | N |
4 | Filler | N/A | N/A | 2 | N |
5 | District ID | The district number. | [Prefs]Value | 3 | N |
6 | School Year | The four-digit year that the instructional program will be operated to provide instructional services to students. This is the current full year term, as defined using the special operation. See the District Setup > Years & Terms section for more information. | [S_TN_DistrictBusStaff_S]School_Year | 4 | N |
7 | Number of regular drivers | Number of regular drivers | [S_TN_DistrictBusStaff_S]RegularDriver | 4 | Y |
8 | Number of substitute drivers | Number of substitute drivers | [S_TN_DistrictBusStaff_S]SubtituteDriver | 4 | Y |
9 | Number of employed bus drivers with CDL | Number of employed bus drivers with CDL | [S_TN_DistrictBusStaff_S]EmployedDriverCDL | 4 | Y |
10 | Number of contracted drivers with CDL | Number of contracted drivers with CDL | [S_TN_DistrictBusStaff_S]ContractedDriverCDL | 4 | Y |
11 | Number of bus assistants | Number of bus assistants | [S_TN_DistrictBusStaff_S]BusAssistants | 4 | Y |
12 | Does district own and operate a bus garage and perform bus maintenance | Does district own and operate a bus garage and perform bus maintenance | [S_TN_DistrictBusStaff_S]BusGarageMaint | 1 | Y |
13 | Does the bus garage mechanics perform maintenance on non-school bus vehicles | Does the bus garage mechanics perform maintenance on non-school bus vehicles | [S_TN_DistrictBusStaff_S] MaintenancenOnSchBus | 1 | Y |
14 | Number of full time mechanics employed by the district | Number of full time mechanics employed by the district | [S_TN_DistrictBusStaff_S]FullTimeMechanics | 4 | Y |
15 | Filler | N/A | N/A | 20 | N |