Transportation Register

Contents

Introduction

The Transportation Register provides the number of days a student is flagged for each Transportation Status for each student enrolled during the period selected. Days Present, Absent, and total Membership are also calculated for each student.

The header section of the report lists the district location and the report date range information used to produce the report. The details of the report are summarized in the Report Output section below. The end of the report has a summary of totals grouped by grade levels and a grand total for all grades. The Student Count, Present, Absent, and Membership values in the summary section match the Attendance Register.

All PK4 IDEA students are denoted as (FD) Full Day irrespective of whether they are am or pm.

Underage students in Grades Pre-K, Kindergarten and Grade 1 are moved to the converted grade, denoted with (UA) Underage in the report.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students] and [ReEnrollments] tables based on the following criteria:

The student must not be excluded from state reporting.
The student must be enrolled in a school included in the report.
The student’s school enrollment Exit Date must occur after the report start date.
The student’s school enrollment Entry Date must occur on or before the report end date.
The school enrollment Exit Date must occur after the Entry Date.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Current Selection Students	Select the students to include in the report: The Selected [number] Students Only. All Students Note: If running the report for a single student, or group of students, select the students prior to running report.
Grade	Choose the grade level(s) to be included in the report. To choose multiple grade levels, use Ctrl+click. To include all grade levels, as well as OHP, leave blank. Notes: If no grade levels are selected, all grade levels are reported, including OHP. If grade levels are selected, OHP is excluded. If OHP and grade levels are selected, the report outputs OHP students for all grades and non-OHP students for the grades selected.
Start Date	Enter start date of the reporting period (in mm/dd/yyyy format).
End Date	Enter end date of the reporting period (in mm/dd/yyyy format).
Basis of Admission to Exclude	To exclude a Basis of Admission code, select it from the pop-up menu. To exclude multiple codes, use CTRL+Shift on your keyboard and select the codes to exclude. The following codes can be excluded: ACEPT BORDER CHSP COOP COOPVOFF COOPVON IEPSA IEPSAVOFF IEPSAVON LTSS NR NRISP OTH PK3 Pre-ISP RISP STSS
Scheduling	Select when to run the report: Run Now (Recommended) Schedule – Run the report on the specified date, time and schedule.

Back to Top

Report 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.

Header

Item #	Data Element	Description	[Table]FieldName
1	District	Name of the School District	[Prefs]Value where [Prefs]Name=districtName
2	County	Name of the County of the School	[Schools]CountyName
3	School Number	The number of the school the report is run.	[Schools]School_Number
4	School Name	The name of the school the report is run.	[Schools]Name
5	Reporting Period (Weeks)	The reporting period in weeks.	Calculated from the start date and the end date.
6	Reporting Period (Date Range)	The start and end date of the reporting period	From the start date and the end date report parameters.
7	Days Taught	The number of days taught during the period.	Calculated
8	Not Taught	The number of days not taught during the period.	Calculated
9	Total	The total number of days in the period which is the sum of the Days Taught and Not Taught.	Calculated
10	Date	The date when the report is run.	System Generated
11	Time	The time when the report is completed.	System Generated
12	Grade	The grade level for which the results are displayed.	Derived. Based on the report parameter.

Back to Top

Report Details

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
1	Student Name	The name of the student.	[Students]LastFirst
2	ID Number	The student number.	[Students]Student_Number
3	Transferred Transported	Number of days the student is transported as a transfer.	[S_OK_STU_X]TransportStatus = 3
4	Resident >= 1.5 Miles	Number of days the student is transported from a distance of 1.5 miles or greater.	[S_OK_STU_X]TransportStatus = 1
5	Resident < 1.5 Miles	Number of days the student is transported from a distance less than 1.5 miles.	[S_OK_STU_X]TransportStatus = 2
6	Legally Transported	Number of days the student resides in the district at least 1.5 miles from the school.	[S_OK_STU_X]TransportStatus = 5
7	Other Transported	Number of days the student resides less than 1.5 miles from the school.	[S_OK_STU_X]TransportStatus = 4
8	Transported State Aid Paid	Sum of the values of Transferred Transported and Resident >=1.5 Miles for the student.	Calculated Sum of aggregate counts of Transferred Transported and Resident >=1.5 Miles
9	Present	Number of present days for the student.	Calculated
10	Absent	Number of absent days for the student.	Calculated
11	Membership	Number of membership days for the student.	Calculated

Back to Top