ESL First Enrollment Date

Introduction

This report includes the date of first ESL enrollment for all students who were enrolled in the current year and have an ESL date. The report indicates, for each student, if the student has been enrolled in ESL for a period of at least 5 years. The student ESL Background is also provided for informational purposes.

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.

The report selects records from the Students and Reenrollments table based on the following criteria:

The student has a Date First Enrolled in ESL Program value set.
The student has an active enrollment or reenrollment in the year the report is being ran for.
The student must be in the selected students the report is being ran for.
The student must be in the grade level the report is being ran for.
The student must be in the selected school the report is being ran for.
The student must not be excluded from state reporting.

Report Input

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

Field	Description
Select Students	Choose one of the following from the pop-up menu: The Selected X Students Only – Includes only students who are in the current student selection. All Students – Includes all student records on the PowerSchool server that meet the selection criteria for either the current school or all schools.
List of Comma-Separated Grade Levels**	List of Comma-Separated Grade Levels**
Select Schools	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet the 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.
Date Prepared	Enter a date to print in the “Date” section of the report.

Back to Top

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.

Item #	Data Element	Description	[Table]FieldName
1	District Name	The district name.	[Prefs]Value [Prefs]Name=districtname
2	District Number	The district number.	[Prefs]Value [Prefs]Name=districtnumber
3	Date	The date entered at report runtime.	N/A
4	School Name	The name of the school. If the report is run for all schools, then this field is blank.	[Schools]Name
5	School Year	The school year chosen at report runtime.	N/A
6	Student Number	Student's student number.	[Students]Student_Number
7	Name	The student's first and last name.	[Students]LastFirst
8	Student SSN	Student's Social Security Number.	[Students]SSN
9	State Student Number	The student's state student number	[Students]State_StudentNumber
10	Grade	Student's grade level.	[Students]Grade_Level
11	ESL Background	Student's district ID.	[S_TN_STU_X]ELB [S_TN_REN_X]ELB
12	ESL Date	Date student was first enrolled in ESL.	[S_TN_STU_X]DateFirstEnrolledInESLProgram
13	At least 5 years	Indicates if the student was enrolled in ESL for at least 5 years based on the current term year being reported.	[SpEnrollments]ProgramID
14	School	Student's school name.	[Students]SchoolID

Back to Top