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
- 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:
- Specific Date/Time
- Report Count Date
- Report file format?
- Add Student Name to Comma Delimited File
- Enter comma-delimited list of grade levels to extract as grade 13
- Run from Extract Viewer?
If you are stuck on any of the steps outlined above, please don’t hesitate to reach out and contact us!