Transportation Register - Charter Schools

Contents

Introduction

The Transportation Register provides a detailed view of the student’s Transportation data grouped by grade level and Out of Home Placement (OHP). The data matches the Transportation section of the Statistical Summary report. The report generates an HTML page.

The header displays the name of the sub-district and the date range of the report. 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.
The student is selected based on the schools defined in the Accredited School ID. If the report is run for all schools in the sub-district, accredited and non-accredited are included.

Report Input

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

Field	Description
Select Sub-District	Select the sub-district. None is selected by default. Only the sub-districts configured in the District Setup displays in this list.
School Selection*	Indicate the school for the report. If a sub-district is selected, the schools associated with that sub-district are listed.
Current Selection Students	Select the students to include in the report: The Selected [number] Students Only. All Students If running the report for a single student, or group of students, select the students prior to running the report.
Grade (Leave blank to include ALL grades)	Choose the grades level to include in the report. To choose multiple grade levels, use Ctrl+click. To include all grade levels, as well as OHP, leave blank. 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 (mm/dd/yyyy).
End Date	Enter end date of the reporting period (mm/dd/yyyy).
Exclude Basis of Admission	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
Include STN and Grade	Select to include the Student Testing Number and Grade in the report.
Scheduling	Select when to run the report: Run Now (Recommended) Schedule – Run the report on the specified date, time and schedule.

Report Output

Each of the fields displayed in the output of the report is 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 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.

Report Details

Each of the fields displayed in the output of the report is 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