Tool Search: Transportation Report
The Transportation Report details the out-of-home placement information for each student, including the miles transported for more than 1.5 miles, less than 1.5 miles, and the bus route number.
Transportation Report
Report Logic
A student reports based on the Admission Code for each of their enrollments that are active for the date range (Start/End Dates) entered on the extract editor.
The report returns attendance data for the selected reporting period (quarter or semester) for the selected calendars. Attendance is calculated as follows:
- Present when the total instructional minutes in the day is greater than 200.
Attendance for the AM (first half of the day) is calculated by finding all periods with a Start Time that is on or before the first three hours of instructional minutes in the day.
When the student was present 120 minutes or more within the first three instructional hours, that student is counted as present.
- Attendance for the PM (second half of the day) is calculated by finding all periods where the End Time is on or after the last three hours of instructional minutes in the day.
- When the student was present 120 minutes or more within the last three instructional hours, that student is counted as present.
Period minutes are counted for all periods where the student is not marked as Absent or Absent/Exempt.
When the student is Absent or Absent/Exempt but a value other than 0 is entered for their Present Minutes on the Attendance record, those minutes are also counted.
- Present when the total instruction minutes in the day is 200 or less.
- The student must be present for at least 120 instructional minutes in the entire day to be considered present for both AM and PM half-day periods.
Period minutes are counted for all periods where the student is not marked as Absent or Absent/Exempt.
When the student is Absent or Absent/Exempt but a value other than 0 is entered for their Present Minutes on the Attendance record, those minutes are also counted.
- Absent when the total instructional minutes in the day is greater than 200.
Attendance for the AM (first half of the day) is calculated by finding all periods with a Start Time that is on or before the first three hours of instructional minutes in the day.
When the Half Day Absence (Minutes) field on the student's Grade Level is populated (or on the Calendar when null), reports as absent when the student was absent for more than that many minutes. Otherwise, if the student was present for less than 120 minutes within the first three instructional hours, that student is counted as absent.
- Attendance for the PM (second half of the day) is calculated by finding all periods where the End Time is on or after the last three hours of instructional minutes in the day.
- When the Half Day Absence (Minutes) field on the student's Grade Level is populated (or on the Calendar when null), reports as absent when the student was absent for more than that many minutes. Otherwise, when the student was present for less than 120 minutes within the last three instructional hours, that student is counted as absent.
Period minutes are counted for all periods where the student is not marked as Absent or Absent/Exempt.
When the student is Absent or Absent/Exempt but a value other than 0 is entered for their Present Minutes on the Attendance record, those minutes are also counted.
- Absent when the total instruction minutes in the day is 200 or less.
- When the Whole Day Absence (Minutes) field on the student's Grade Level is populated (or on the Calendar when null), reports as absent when the student was absent for more than that many minutes. Otherwise, a student present for less than 120 instructional minutes in the entire day is considered absent for both AM and PM half-day periods.
Period minutes are counted for all periods where the student is not marked as Absent or Absent/Exempt.
When the student is Absent or Absent/Exempt but a value other than 0 is entered for their Present Minutes on the Attendance record, those minutes are also counted.
Transportation is only reported for days that the enrolled student had an active transportation record.
Reports only those enrollments with certain Admission Codes, based on the following table:
| OHP | Transferred Transported | Resident > 1.5 Miles | Resident < 1.5 Miles | Legally Transported | Other Transported |
|---|---|---|---|---|---|
| OHP1 | OT | R | R | (Transferred Transported + Resident > 1.5 Miles) + FOY | FOY |
| ET01 | RVON | RVON | TO | ||
| ET02 | RVOFF | RVOFF | RBD | ||
| ET03 | ROP | ROP | RBDTD | ||
| ET04 | FRGN | ||||
| ET05 | |||||
| ET06 | |||||
| ET07 | |||||
| ET08 | |||||
| TRVOFF | |||||
| TRVON |
The report can be run in District Editions.
The report generates in PDF.
The student's enrollment transportation record must be active and on or between the extract Start and End Dates in order to be counted.
When student's Miles Transported field is NULL on the student's transportation record, no transportation days will be included for the transportation record on the report.
Report Editor Options
Field | Description |
|---|---|
Calendar Reporting Period | The term options associated with the desired calendar selected for the report. |
Start Date | The first date of the reporting period from which the data is being extracted. Dates are entered in mmddyy format, or use the calendar icon to select a date. |
End Date | The last date of the reporting period from which the data is being extracted. Dates are entered in mmddyy format, or use the calendar icon to select a date. |
| Grade Level Sort Order | Determines how records are sorted by grade level. Options include the following:
|
| Format | Generate the report in PDF, CSV, or HTML format. |
| Ad hoc Filter | Limits students reported to those in the selected filter. |
| Display Totals Page | Generates an additional page providing totals by calendar. |
Calendar Selection | At least one calendar needs to be selected in order to generate the report. Reports can be selected by Active Year, School or Year. |
Report Generation | The extract can be generated immediately using the Generate Report button. Or, use the Submit to Batch button to select when the report is generated. See the Batch Queue article for more information on this functionality. |
Generate the Transportation Report
- Select the Reporting Period from the dropdown list.
- Enter the Start Date for the report.
- Enter the End Date for the report.
- Select a Grade Level Sort Order.
- The extract generates in PDF format by default. Select a different Format (CSV or HTML) if desired.
- Select an Ad hoc Filter to limit students reported to those in an existing Ad hoc Filter.
- Mark Display Totals Page to generate the report with an additional page at the end that provides totals summarized by calendar.
- Select the Calendar(s) to include in the report.
- Click the Generate Report button to view the report in the selected format.
Transportation Report - HTML Format
Transportation Report Layout
Elements | Description & Format | Campus Location |
|---|---|---|
Grade | The grade level in which the student is enrolled. Alphanumeric, 2 characters | Student Information > General > Enrollments > General Enrollment Information > Grade Enrollment.grade |
Student ID | The district-assigned student number. Numeric, 7 digits | Census > People > Demographics > Student Number Identity.studentNumber |
Student Name | The student's last name and first name. Alphanumeric, 50 characters | Census > People > Demographics > Last Name, First Name Identity.lastName |
OHP | The number of days the student's transportation record was active when the student is considered Out of Home Placement.
The Miles Transported field must not be null or 0 for this field to report. Numeric, 4 digits, XX.X | Calculated, not dynamically stored |
Transferred Transported | The number of days the student's transportation record was active when the student is considered Emergency Transfer or Open Transfer. When (Student Info>General>Transportation>Transportation Detail>In Bus) = NOT Blank, AND (Student Info>General>SIF Fields>Admission) = OT, ET01 - ET08, TRVOFF, or TRVON, report the number of days the student's transportation record was active by taking (End Date - Start Date) - Days Absent. Numeric, 4 digits, XX.X | Calculated, not dynamically stored |
Resident > 1.5 | Indicates the total days Resident students were transported 1.5 miles or more.
This field only reports a value when the Admission Code selected on the student's enrollment is R or RVON. Numeric, 2 digits | Student Information > General > Transportation > In Bus and Miles Transported Transportation.inBus |
Resident < 1.5 | Indicates the total days Resident students were transported less than 1.5 miles.
This field only reports a value when the Admission Code selected on the student's enrollment is R or RVON. Numeric, 2 digits | Student Information > General > Transportation > In Bus and Miles Transported Transportation.inBus |
| Legally Transported | Reports the SUM of the Transferred Transported and Resident > 1.5 fields (Transferred Transported + Resident > 1.5 = Legally Transported). Includes also any transportation from the Other Transported field for those students with an enrollment Admission Code = FOY. This field matches the identical field on the Statistical Summary report. Numeric, 2 digits | Not dynamically stored |
Other Transported | Indicates the total days transported for tuition admitted students.
The Miles Transported field must not be null or 0 for this field to report. Numeric, 3 digits | Not dynamically stored |
Bus Route | The bus name and number recorded on the Bus Detail editor. Numeric, 3 digits | System Administration > Transportation > Buses > Number TransportationBus.number |
Previous Versions
Transportation Report (Oklahoma) [.2211 - .2303]
