Roster File 2022-23

Introduction

The Roster File 2022 - 23 report extracts roster information about students from selected schools and grades.

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

The student must be enrolled in the school chosen at report runtime. Students who are enrolled in multiple schools during the report period will have separate records for each school if the report is run district wide.
The student must have been enrolled on or before the current date.
The student must not be excluded from state reporting.
Students should be enrolled in the courses with alternate course numbers/course numbers starting with 23.XXXXXXX (ELA), 27.XXXXXXX (Math), or 55.XXXXXXX (ESOL).
Students in Grade 5 enrolled in courses with alternative course numbers/course numbers starting with 41.XXXXXXX (Sci)
Students in Grade 8 enrolled in courses with alternative course numbers/course numbers starting with 41.XXXXXXX (Sci) and 45.XXXXXXX (Social Studies)
Grades 9-12 students will pull groups based on courses marked as EOC, which currently include courses with alternative course numbers/course numbers starting with 45.XXXXXXX (US History) and 26.XXXXXXX (Biology)
Student Groups will allow users at the Teacher level and above, associated with that Student Group, Only they can view the student results for students in the group within the Reporting System.

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

Field	Description
Select Schools	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	Run the report for the current selection of students or all students.
Report Start Date	Enter the start date of the report. Note: Enter the date in a format of MM/DD/YYYY.
Report End Date	Enter the end date of the report. Note: Enter the date in a format of MM/DD/YYYY.
Select Only Students in These Grades	Select the grades from which you want to include students in the report.

Data Element	Description	[Table]FieldName	Required	Length
State Student ID	The State Student ID.	[Students]State_ID	Y	15
Student Last Name	The student's last name.	[Students]Last_Name	N	35
Student First Name	The student's first name.	[Students]First_Name	N	35
Teacher First Name	The teacher's first name.	[Teachers]First_Name	N	35
Teacher Last Name	The teacher's last name.	[Teachers]Last_Name	N	35
Teacher Email	The teacher's email address.	[Teachers]Email	Y	50
Roster Name	The student group name.	[Students]Group_Name	Y	50