Bus Roster Extract

Introduction

This extract generates a csv file of all eligible bus riders on the user defined snapshot date. This extract is not submitted to PED, but is intended to help districts validate and audit which students are eligible to ride the bus.

A record is returned for each bus the student is set to ride.

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

Students are reported based on the following criteria:

They must be enrolled on the snapshot date.
They must be flagged as being eligible for bus services (either regular bus services or special education bus services)

Report Input

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

Field	Description
Select Schools	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office.
Select Students	Choose one of the following: The Selected [x] 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.
Buses	Select the Bus Number(s) you want to run the extract for. If you do not select a bus number, all bus numbers will be extracted.
Include Students’ DCID	Select Yes or No if you wish to extract the student’s DCID (Oracle ID).
Snapshot Date	Enter the snapshot date you wish to run the report for.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Tables for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Begin / End Position
1	Student Name	The student’s name.	[Students]LastFirst	N/A
2	Local Student Number	The student’s locally assigned student number.	[Students]Student_Number	N/A
3	State Student Number	The student’s PED assigned ID number.	[Students]State_StudentNumber	N/A
4	Student DCID Note: This may not extract depending on the parameters selected when the report is run	The student’s DCID number (the internal ID number of the student as assigned by Oracle).	[Students]DCID	N/A
5	School ID	The school the student is enrolled in on the snapshot date.	[Students]SchoolID	N/A
6	School Name	The name of the school that the student is enrolled in.	[Schools]School_Name	N/A
7	Eligibility Type	The bus eligibility types the student has been set for.	[S_NM_STU_X]EligibleBusSvc_YN [S_NM_STU_X]EligibleBusSvcVocEd_YN [S_NM_STU_X]BUSA	N/A
8	Bus Number	The bus number the student is set to ride.	[S_NM_STU_X]Bus_Number [S_NM_STU_X]Bus_Number	N/A
9	Rode Bus on 40D	Indicates whether or not the student is marked as having actually rode the bus on 40D. Note: The report translates a saved value of 1 to a Y, 0 to N, and a blank remains a blank.	[S_NM_STU_X]RodeBus40D	N/A
10	Rode Bus on 80D	Indicates whether or not the student is marked as having actually rode the bus on 80D. Note: The report translates a saved value of 1 to a Y, 0 to N, and a blank remains a blank.	[S_NM_STU_X]rodebus80d	N/A
11	Rode Bus on 120D	Indicates whether or not the student is marked as having actually rode the bus on 120D. Note: The report translates a saved value of 1 to a Y, 0 to N, and a blank remains a blank.	[S_NM_STU_X]rodebus120d	N/A

Back to Top