The 045 Student Transportation extract reports student transportation data, including student to bus relationships, to EIS.
See the EIS Batch Transmission article for an overview of the EIS Batch Transmission File, logic that applies to all extracts, and generation instructions.
Report Logic
Student report who currently have an active, primary enrollment, or who had a primary enrollment at some point during the current school year that has an End Date. If a student has multiple enrollments in the same calendar, only one record reports (such as a student who has exited and reenrolled). Records report for each transportation record in the current year for students enrolled in the selected calendar.
Students who do not have a Student State ID entered are not reported. Enrollments with a Service Type of S: Partial and those in Calendars or Grade Levels marked as Exclude are not reported. Additionally, records are not reported for the following students. These students are included in the warning report.
- Students without PINs.
- Students with multiple active Primary enrollments.
- Students with no Start Date on their transportation record.
- Students with multiple enrollments in the same school.
- Students with an enrollment marked as N: Special Ed Services
- Enrollments marked as No Show or Exclude.
- Students with transportation records that have a Miles Transported value that is longer than 4 characters long.
If a record was previously reported and then marked as exclude, a delete record will be sent to EIS for each record.
The Record Key, which helps determine the Type of record sent (New, Edit, or Delete), is comprised of the Record ID, Record Version, District ID, School ID, School Year, Instructional Program Number, AM Bus Number, PM Bus Number, AM Bus Begin Date and State Assigned Student ID.
Recommended Setup
Transportation records should not have a Miles Transported value that is longer than 4 characters. These records are not reported.
045 Student Transportation Extract Layout
Element Name | Description & Format | Campus Location |
|---|---|---|
Record ID | Identifies the extract - reports as "041" Numeric (3) | N/A |
| Record Version | Identifies the extract version - reports as "02" Numeric (2) | N/A |
| Record Type | Identifies the type of extract:
Character (1) | N/A |
| Filler | N/A. Reports as 00. | N/A |
| District ID | Reports the TN Department of Education assigned District Number. Numeric (3) | System Administration > Resources > District Information > State District Number District.number |
| School ID | Reports the TN Department of Education assigned School Number Numeric (4) | System Administration > Resources > School > State School Number School.number |
| School Year | Reports the start year of the school calendar associated with the enrollment. Date (4) CCYY | System Administration > Calendar > School Years > Start Year SchoolYear.startYear |
| Instructional Program Number | Reports the unique Instructional Program Number of the school, or as 99 if blank. Numeric (2) | System Administration > Calendar > Calendar > Instructional Program Number Calendar.instructionalProgramNumber |
| Student Social Security Number | Reports the student's social security number. Currently reports as 000000000. Numeric (9) | Census > People > Identities > Current Identity > Soc Sec Number Identity.ssn |
| Student PIN | Reports the unique student identifier provided by the school. Numeric (9) | Census > People > Demographics > Person Identifiers > Student PIN Person.additionalID |
| Local Student Key | Reports the locally-generated student identifier. Numeric (10) | Census > People > Demographics > Person Identifiers > Local Student Number Person.studentNumber |
| AM Bus Number | Reports the Bus Number of the bus the student rides in the morning (AM). Otherwise reports as blank. Character (10) | Student Information > General > Transportation > In Bus Transportation.inBus |
| PM Bus Number | Reports the Bus Number of the bus the student rides in the afternoon (PM). Otherwise reports as blank. Character (10) | Student Information > General > Transportation > Out Bus Transportation.outBut |
| Est Miles Transported | Reports the estimated number of miles the student is transported by bus. This field reports with an implied decimal before the last two digits; for example, 2.5 miles reports as 0250. Numeric (4) | Student Information > General > Transportation > Miles Transported Transportation.milesTransported |
| Filler | N/A | N/A |
| Filler | N/A | N/A |
| State Assigned Student ID | Reports the unique state-assigned student ID generated in EIS. Numeric (9) | Census > People > Demographics > Person Identifiers > Student State ID Person.stateID |
| AM Bus Begin Date | Reports the Start Date entered on the student's transportation record for the AM Bus if an In Bus is entered. If the transportation Start Date is prior to the earliest enrollment Start Date, reports enrollment Start Date. Numeric (8) | Student Information > General > Transportation > Start Date Transportation.startDate |
| AM Bus End Date | Reports the End Date entered on the student's transportation record for the AM Bus if an In Bus is entered. If an In Bus is entered and the End Date is not entered, reports as the last day in the calendar with a Day Event Type of AE. Numeric (8) | Student Information > General > Transportation > End Date Transportation.endDate |
| PM Bus Begin Date | Reports the Start Date entered on the student's transportation record for the Bus if an Out Bus is entered. If the transportation Start Date is prior to the earliest enrollment Start Date, reports enrollment Start Date. Numeric (8) | Student Information > General > Transportation > Start Date Transportation.startDate |
| PM Bus End Date | Reports the End Date entered on the student's transportation record for the PM Bus if an Out Bus is entered. If an Out Bus is entered and the End Date is not entered, reports as the last day in the calendar with a Day Event Type of AE. Numeric (8) | Student Information > General > Transportation > End Date Transportation.endDate |
| Filler | N/A | N/A |
