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
If you are stuck on any of the steps outlined above, please don’t hesitate to reach out and contact us!