Tool Search: MOSIS Extracts
The Summer EBT extract generates a report of students and their Free and Reduced-Priced eligibility for Missouri's summer food program.
See the MOSIS Extracts article for additional information.
Report Logic
One record reports per student enrolled in the calendar(s) selected. This includes all students enrolled at any point during the school year.
Data reports from the most recent primary enrollment when no active enrollment record exists for the student. When a student has multiple primary enrollments, the latest start date is used for reporting. When the start dates are the same, the highest EnrollmentID reports.
When the student has no primary enrollment, then the partial enrollment and SPED enrollment reports.
Students do not report when:
- The student and/or calendar is marked as State Exclude.
- The student is marked as No Show.
The report can be generated for the active year and any prior year.
Only qualified students who are either of the following at any point during the year report:
- FRAM Eligibility of Free or Reduced OR
- Certified Type of Homeless, Migrant, Runaway, Forst Care, SNAL, or TANF.
Students report when their FRAM Eligibility is Paid and the student is either Homeless, Migrant, or Runaway.
The student's primary household reports.
Generate Report
- Navigate to the MOSIS Extracts editor.
- Select the Summer EBT file from the Extract Type dropdown.
- Optional: select an Ad Hoc Filter to narrow results.
- Select a Format, either State Format (CSV) or HTML.
- Select which Calendar(s) to include on the report.
- Click Generate Extract or Submit to Batch.
Report Layout
| Data Element | Description | Location |
|---|---|---|
| Local Education Agency/ School District | The state district number. Part of the header. Numeric, 6 digits | District Information > State District Number |
| School District Representative (Name and Number) | The school district representative and their contact information. Alphanumeric | School & District Settings > District Information > District Contact First Name, District Contact Last Name, Phone |
| School District | The name of the school district. Alphanumeric | District Information > District Name |
| Student Legal Last Name | The student's last name. Alphanumeric | Demographics > Last Name |
| Students Legal First Name | The student's first name. Alphanumeric | Demographics > First Name |
| Student Middle Initial | The student's middle initial. Alphanumeric | Demographics > Middle Name (Initial) |
| Gender | The student's gender. Alphanumeric | First, looks to Legal Gender on the Identities > Protected Identity Information area for reporting When blank, reports from Demographics > Gender |
| DOB | The student's birth date. Date field | Demographics > Person Information > Birth Date |
| LEA Agreement Number | The state district number. Numeric | District Information > State District Number |
| Student MOSIS ID | The student's state student number. Numeric | Demographics > State Student Number |
| School Building Name | The name of the student's school building. Alphanumeric | School Information > School Detail > Name |
| Foster Care | Reports as Y when the student has an active foster care record. Alphanumeric | Program Participation > Foster Care |
| Homeless/Migrant/Runaway | Reports as Y when the student has an active homeless record. Alphanumeric | Program Participation > Homeless Program Participation > Migrant |
| SNAP/TANF Participant | Reports as Y when the student has an active SNAP or TANF FRAM Eligibility Certified Type. Alphanumeric, Y or N | FRAM > Eligibility > Certified Type |
| DCN | Reports as blank. | N/A |
| Head of Household - Last Name | The head of household's last name. Reports the first name of the person marked as Guardian in the primary household. When more than one guardian is available in the primary household, the oldest record (lowest person ID) reports. | Relationships > Primary Household Relationships > Guardian Identities > Current Identity > First Name |
| Head of Household - First Name | The head of household's first name. Reports the last name of the person marked as Guardian in the primary household. When more than one guardian is available in the primary household, the oldest record (lowest person ID) reports. | Relationships > Primary Household Relationships > Guardian Identities > Current Identity > First Name |
| Mailing Address | The Street Number, Street Name, Suite Number portion of the student's address. When the student has more than one active mailing address, the primary reports. Alphanumeric | Households > Addresses > Address School Information > School Detail > Address |
| City | The city portion of the student's address. Alphanumeric | Households > Addresses > City School Information > School Detail > Address |
| State | The state portion of the student's address. Alphanumeric | Households > Addresses > State |
| Zip | The zip portion of the student's address. Alphanumeric | Households > Addresses > Zip |
| Phone Number | The household phone number. When the phone number is a cell phone, then reports Y for the Phone Number Mobile field. Numeric | Households > Address > Phone Number Order: household, cell, other, work |
| Phone Number Mobile | Reports Y when the phone number is a cell phone. Alphanumeric, Y or N | Households > Address > Primary household > Cell phone |
| Head of Household - Email Address | The head of household's email address. Alphanumeric | Households > Primary Member > Personal Info > Email |
