PowerSchool Indiana State Reporting: English Learners and Immigrant Students Report

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:

(Concord: IN_non_us_origin)

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!

Updated on December 26, 2018

Was this article helpful?

Need Support?
Can't find the answer you're looking for? Don't worry we're here to help!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Knowledge For Schools by Measure Education