045 – Student Transportation
Introduction
This extract includes each transportation (bus) record for students during the current school year.
Report Input
For help with navigation and extract generation, see Create Selected Student Related Extract File.
Extract Output
Each of the fields displayed in the output of the report are described below. See Understanding 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 "045" | 3 | N |
2 | Record Version | The version of this record. | Always "02" | 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 [Prefs]Name=districtnumber | 3 | N |
6 | School ID | The school number. | [Schools]Alternate_School_Number - if populated Otherwise: [Transportation]SchoolID | 4 | N |
7 | 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. | [Terms]FirstDay [Terms]LastDay | 4 | N |
8 | Instructional Program Number | The number used to uniquely identify the program within the school. Valid values: 01, 02, 03, 04, 05, or 06. | [Students]Track | 2 | N |
9 | Student Social Security Number | The student's social security number. | [Students]SSN | 9 | N |
10 | Student PIN | The student's PIN, if the social security number is not provided or reported. | [S_TN_STU_X]StudentPIN | 9 | N |
11 | Local Student Key | The internal ID assigned to the student's record in the PowerSchool database. | [Students]ID | 10 | N |
12 | AM Bus Number | The number of the bus for the student's bus route.
| [S_TN_TRN_X]S_TN_DistrictBus_SID Or, if no value, then, [Transportation]BusNumber | 10 | Y |
13 | PM Bus Number | The number of the bus for the student's bus route. | [S_TN_TRN_X]S_TN_DistrictBus_SID Or, if no value, then, [Transportation]BusNumber | 10 | Y |
14 | Est Miles Transported | The number of whole miles traveled. Enter values 1-99 for distances traveled up to 99 miles. An upcoming change will allow for incremental mileage entry of values such as 1.5 miles. | [S_TN_TRN_X]Distance Travelled Or, if no value, then, [Transportation]Distance | 4 | Y |
15 | Filler | N/A | N/A | 2 | N |
16 | Filler | N/A | N/A | 3 | N |
17 | State Assigned Student ID | The student's state assigned identifier. | [Students]State_StudentNumber | 9 | N |
18 | AM Bus Begin Date | The date the student enrolled for the AM bus. | [Transportation]StartDate | 8 |
|
| 19 | AM Bus End Date | The date the student withdrew from the AM bus. | [Transportation]EndDate | 8 | |
| 20 | PM Bus Begin Date | The date the student enrolled for the PM bus. | [Transportation]StartDate | 8 | |
| 21 | PM Bus End Date | The date the student withdrew from the PM bus. | [Transportation]EndDate | 8 |