PowerSchool Indiana State Reporting: English Learners and Immigrant Students Report

Contents

Indiana State Report (DOE-LM 2019)

Note: the DOE English Learners and Immigrant Students Report data layout can be obtained here. This file contains detailed information on the requirements and contents of the report as well as submission deadlines.

Layout Requirements

The DOE-LM report focuses the count of English Learners, English language proficiency placements and annual assessments. The following fields are included in the DOE-LM report:

School Number
Student Test Number (STN)
Grade Level
English Language Proficiency Level
Instrument Level
Non-U.S. Origin
Country of Origin
Length of U.S. Enrollment To identify Immigrant students only
Foreign Exchange
Instructional Program
High Ability (Gifted & Talented) Participant
ESEA Title I Program

In PowerSchool, the associated student fields for this report are as follows:

School Number
- [39]SchoolID
Student Test Number (STN)
- State_StudentNumber
Grade Level
- Grade_Level
English Language Proficiency Level
- S_IN_STU_X.ENG_Lang_Prof_Level
Instrument Level
- S_IN_STU_X.Instrument_Used
Non-U.S. Origin
- S_IN_STU_X.Non_US_Origin
Country of Origin
- S_IN_STU_X.Country_Of_Origin
Length of U.S. Enrollment To identify Immigrant students only
- S_IN_STU_X.Length_US_Enrollment
Foreign Exchange
- S_IN_STU_X.Foreign_Exchange_TF
Instructional Program
- S_IN_STU_X.Instructional_Program
High Ability (Gifted & Talented) Participant
- S_IN_STU_X.Gifted_Talented_TF
ESEA Title I Program
- S_IN_STU_X.ESEA_Title_I_Program

The field list below can be used for a Quick Export from your PowerSchool site:


[39]SchoolID
State_StudentNumber
Grade_Level
S_IN_STU_X.ENG_Lang_Prof_Level
S_IN_STU_X.Instrument_Used
S_IN_STU_X.Non_US_Origin
(Concord: IN_non_us_origin)
S_IN_STU_X.Country_Of_Origin
S_IN_STU_X.Length_US_Enrollment
S_IN_STU_X.Foreign_Exchange_TF
S_IN_STU_X.Instructional_Program
S_IN_STU_X.Gifted_Talented_TF
S_IN_STU_X.ESEA_Title_I_Program

Report Parameters

The DOE-LM extract link can be found at the following PowerSchool page:

System Reports > State > English Language Learner and Immigration Students (DOE-LM) Report

On this report page, you will have the following options to select from:

Use
- Select which PowerSchool school site to include in this report

Students to Include
- You can make a selection of students from the Start Page

Processing Options

Specific Date/Time If you choose On Specific Time in the Processing Options, make sure to provide that date in the Specific Date/Time field

Report Snapshot Date
- Select a date for which the student enrollments will be included in the report
Report File Format
Add Student Name & Header Row to Comma Delimited File
- Note: the Header Row is optional and should not be submitted to the state