(FP) Student Transportation Record

Contents

Introduction

The (FP) Student Transportation Record Report describes student-level transportation data including a flag telling whether or not the student was transported each day of the first full week of October, and the distance the student was transported. Only Community/STEM schools which transport students are required to submit this report.

Selection Criteria

In the Student (S) reporting period, a Community/STEM school, which has transportation requirements, will submit a single record for any student who is transported by or on behalf of the Community/STEM school. The data will be based on the first full week of October. Students, not enrolled during the first full week in October or not transported, will not have a record.

School Selection

The report selects which school records to use based on the following criteria:

The school must be associated with a student included in the report.

Student Selection

The report selects which student records to use based on the following criteria:

The student must be enrolled during the enrollment period selected for the report.
The student is not excluded from state reporting (State/Province-OH>Home Tab> State_ExcludeEnrollment).

Selection criteria determine which database records are used in the report. For the (FD) Student Attributes — Effective Date Record, student enrollment records are selected. The data is extracted from from either:

the FD tab, Start Page > Student Selection > Ohio State Information > FD and
for a student with enrollment history, this field value is extracted from the History tab, Start Page > Student Selection > Ohio State Information > History, or
as otherwise noted.

School Selection

The report selects which school records to use based on the following criteria:

The school must be associated with a student included in the report.

Student Selection

The report selects which student records to use based on the following criteria:

The student was enrolled at some point during the reporting period, which is specified by the start and end dates.
The student is not excluded from state reporting (State/Province-OH>Home Tab> State_ExcludeEnrollment).

The student is not identified as a ‘Grad Only’ Student (State/Province-OH>Home Tab)
This student has at least one Student Transportation Record to be reported.

Back to Top

Report Input

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

The report input is done in Incident Management with the codes and subcodes used in IM.

Field	Description
Report Parameters
Schools for which to run?	If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report All Schools – Run the report for the entire district. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Current Selection Students	Indicate which students to include in the report by selecting one of the following options: The Selected [number] Students Only – Run the report for students in the current selection. All Students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Report Start Date	Enter the start date for scanning school enrollments. Format: [M]M/[D]D/[YY]YY
Report End Date	Enter the end date for scanning school enrollments. Format: [M]M/[D]D/[YY]YY
Reporting Period	Select the reporting period for which you are creating the extract – (S) Student
Fiscal Year	Enter the fiscal year for the report.
Scheduling
Run Now	Select this option to execute the report in the order it is received in the report queue.
Schedule (available Version 7.1.1.)	Enter the start date and start time for the report. Select Run Once and Submit to run the report at the specified date and time. Select Repeat to set future dates (Daily, Weekly, Monthly, Yearly) and Submit.

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.

Note: For documentation of XML report output from the state department of education, refer to http://www.ode.state.oh.us.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length	Begin/End Position
N/A	Filler	Filler	N/A	Numeric	8	1–8
FP010	Sort Type	The sort type equals FP for the Student Transportation extract.	N/A	Alpha-numeric	2	9–10
N/A	Filler	Filler	N/A	Alpha-numeric	1	11
FP020	Fiscal Year	The fiscal year defaults to the current school year.	N/A	Alpha-numeric	4	12–15
FP030	Reporting Period	This is the reporting period selected on the (FP) Student Transportation Record Report page, Start Page > Reports > Run Reports > Student Transportation Record (FP) Report.	N/A	Alpha-numeric	1	16
FP050	District IRN	This field contains the district number. This field value is extracted from the Edit District page, Start Page > District Setup > District Information.	[Prefs]DistrictNumber CST_SUBDISTRICTS.Subdistrict_number	Alpha-numeric	6	17–22
FP060	EMIS Student ID	This field contains the EMIS student ID number assigned by the district to this student. This field value is extracted from the Student Number field on the General Demographics page, Start Page > Student Selection > General Demographics and prepended with the EMIS Prefix ID, if entered, else zeroes are added to create a 9-digit number.	[Students]Student_Number [Prefs]OH_EMIS_Prefix	Alpha-numeric	9	23–31
FP070	Distance Transported Code	This field contains the code which describes the distance a student was transported. This field is extracted from Distance Transported field on the Home Tab, Start Page > Student Selection > Ohio State Information - Home	[S_OH_STU_COMMON_X]Distance_Transported	Alpha-numeric	2	32-33
FP080	Monday Transported	This field contains the code, Y or N, which describes if a student was transported. This field is extracted from Student Transportation field on the Home Tab, Start Page > Student Selection > Ohio State Information - Home	[S_OH_STU_COMMON_X]Transportation	Alpha-numeric	1	34
FP080	Tuesday Transported	This field contains the code, Y or N, which describes if a student was transported. This field is extracted from Student Transportation field on the Home Tab, Start Page > Student Selection > Ohio State Information - Home	[S_OH_STU_COMMON_X]Transportation	Alpha-numeric	1	35
FP080	Wednesday Transported	This field contains the code, Y or N, which describes if a student was transported. This field is extracted from Student Transportation field on the Home Tab, Start Page > Student Selection > Ohio State Information - Home	[S_OH_STU_COMMON_X]Transportation	Alpha-numeric	1	36
FP080	Thursday Transported	This field contains the code, Y or N, which describes if a student was transported. This field is extracted from Student Transportation field on the Home Tab, Start Page > Student Selection > Ohio State Information - Home	[S_OH_STU_COMMON_X]Transportation	Alpha-numeric	1	37
FP080	Friday Transported	This field contains the code, Y or N, which describes if a student was transported. This field is extracted from Student Transportation field on the Home Tab, Start Page > Student Selection > Ohio State Information - Home	[S_OH_STU_COMMON_X]Transportation	Alpha-numeric	1	38

Back to Top