PowerSchool Indiana State Reporting: Membership Report

Contents

Indiana State Report (DOE-ME 2019)

Note: the DOE Membership 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-ME (Membership Report) focuses on ADM (Average Daily Membership) which includes the following fields:

School Number
Student Test Number (STN)
ADM Type
Corporation Number of Legal Settlement
Instructional Days
Instructional Minutes
Grade Level
County of Legal Residence
Full Day Kindergarten Student

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

School Number
- Servicing_School
- SchoolNumberPrefix
  - Note: This may not necessarily be available in your PS database
- [39]Alternate_School_Number
  - Note: this field is pulled from Schools (39) table
- SchoolID
Student Test Number (STN)
- State_StudentNumber
ADM Type
- ADM_Type
Corporation Number of Legal Settlement
- DistrictOfResidence
Instructional Days
- Instructional_Days
Instructional Minutes
- Instructional_Minutes
Grade Level
- Grade_Level
County of Legal Residence
- County_Residence
Full Day Kindergarten Student
- Half_Time_KG

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

S_IN_STU_X.Servicing_School
[39]Alternate_School_Number
SchoolID
State_StudentNumber
S_IN_STU_X.ADM_Type
DistrictOfResidence
S_IN_STU_X.Instructional_Days
S_IN_STU_X.Instructional_Minutes
Grade_Level
S_IN_STU_X.County_Residence
S_IN_STU_X.Half_Time_KG

Report Parameters

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

System Reports > State > Indiana ME Extract Report

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

Use
- Select the school from the dropdown
Student to Include
- The # students selected (you can make a student selection on the Start Page before running the report)
  - For more information on how to do so see the Beginner and Intermediate articles on student selection
- All students
Processing Options:
- ASAP (execute immediately)
- In Background Now (execute immediately)
- At Night
  - Execute during the next evening
- On Weekend
  - Execute during the next weekend
- On Specific Time
  - Execute at a given time and date
Specific Date/Time
- Leave this blank unless you want PowerSchool to run the report at a specific time, in which case you must also select “On specific Time” from the Process Options dropdown menu
Report Count Date
- Enter the date of active enrollments that will be included in the extract
Report file format?
- Select the file format you would like the report extract to have:
  - Comma Delimited (csv)
  - Fixed Length (txt)
  - XML (eXtensible Markup Language)
Add Student Name to Comma Delimited File
- Select No if you are submitting this report to the state
- Select Yes if you are not submitting this report to the state and would like to validate student names coming onto the extract
Enter comma-delimited list of grade levels to extract as grade 13
- Enter a list of grade values which represent grade 13 in your PowerSchool site
Run from Extract Viewer?
- Select No if you would not like to view it in the Extract Viewer
- Select Yes if you would like to view it in the Extract Viewer (it will replace any existing report in the viewer)