Tool Search: S-EBT Extract
The S-EBT (Summer Electronic Benefit Transfer) Extract returns data on students who are eligible for free/reduced-price meals and meet the criteria to receive S-EBT in the calendar selected in the Campus toolbar.
S-EBT Extract Editor
Report Logic
Only those students who qualify for free or reduced-price meals and who attended school due to the following are included:
- The school was primarily operating in a Remote Only or Hybrid learning mode due to COVID-19.
- The student opted into attending remotely full time.
- The student was forced to attend remotely for a short time due to quarantine.
One record per student who has an enrollment in the selected calendar(s) at any time during the reporting period (entered Start and End Dates on the Report Editor) are included. When a student has more than one enrollment, the most recent enrollment reports.
Students who are included in the report must meet the following requirements:
- They have an enrollment in the selected calendar of a school that qualifies for S-EBT benefits;
- They qualify for Free/Reduced meals by the submission of an income application or direct certification during the school year; AND
Students are not included when:
- The enrollment record is marked as No Show or as State Exclude.
- The grade level of enrollment is marked as State Exclude.
- The calendar of enrollment is marked as State Exclude.
When a calendar is NOT marked as Summer School, students do not report UNLESS a student would report as being absent for five or more days. A summer school calendar is determined by the checkbox on the Calendar Information tool.
Report Editor
| Field | Description |
|---|---|
| Start Date | Entered date is used to return student data for those students actively enrolled on or after the entered date. Dates are entered mmddyy format or can be entered by selecting the calendar icon and choosing a date. |
| End Date | Entered date is used to return student data for those students actively enrolled on or before the entered date. Dates are entered mmddyy format or can be entered by selecting the calendar icon and choosing a date. |
| Ad hoc Filter | Select a saved ad hoc filter to only include those students in the filter in the report, assuming those students meet the reporting logic and business rules of this report. |
| Format | The S-EBT Extract can be generated in either CSV or HTML formats. |
| Report Generation | The S-EBT Extract can be generated immediately using the Generate Report button. Or, use the Submit to Batch button to select when the report is generated. See the Batch Queue article for more information on this functionality. |
Generate the S-EBT Extract
- Enter the appropriate Start Date and End Date for the extract.
- When desired, select students from an existing Ad hoc Filter.
- Select the Format of the report.
- Click the Generate Extract button, or click the Submit to Batch button. The report displays in the desired format.
Report Layout
| Data Element | Description | Location |
|---|---|---|
| Parent/Guardian First Name | Reports the first name of the person marked as Primary Guardian. Parent/Guardian information reports as follows:
| Census > People > Relationships > Primary Household Relationships > Guardian Census > People > Demographics > Person Information > First Name Identity.firstName |
| Parent/Guardian Last Name | Reports the last name of the person marked as Primary Guardian. Parent/Guardian information reports as follows:
| Census > People > Relationships > Primary Household Relationships > Guardian Census > People > Demographics > Person Information >Last Name Identity.lastName |
| Primary Language Spoken | Reports the assigned Primary Language code. When the Home Primary Language field is not populated, the default value on the attribute reports. Alphanumeric, 3 characters | Census > People > Identities > Home Primary Language Identity.homePrimaryLanguage |
| Address Line 1 | Reports the student's mailing address (street address when entered, or PO Box when marked). The student's current and primary address reports. When there is no address available for the student, the school's address reports. Alphanumeric, 44 characters | Census > Households > Addresses > Address Address.number Address.POBox Address.street Address.prefix Address.tag Address.direction Address.apt System Administration > Resources > School > School Detail > Address |
| Address Line 2 | N/A | N/A |
| City | Reports the student's city as noted on their primary address. When there is no city available for the student, the school's city reports. Alphanumeric, 50 characters | Census > Households > Addresses > Address Address.city System Administration > Resources > School > School Detail > Address School.city |
| State | Reports the student's state as noted on their primary address. When there is no state available for the student, the school's state reports. Alphanumeric, 2 characters | Census > Households > Addresses > Address Address.state System Administration > Resources > School > School Detail > Address School.state |
| Zip Code | Reports the zip code (either 5 digit code or 9 digit code) of the parent's primary household address. When there is no zip code available for the student, the school's zip code reports. Numeric, 10 digits (12345 or 12345-6789) | Census > Households > Addresses > Address Address.zip System Administration > Resources > School > School Detail > Address School.zip |
| Parent Phone Number | Reports the 10-digit primary phone number assigned at the household, including area code (no dashes). When there is no phone number for the household, this field reports blank. Numeric, 10 digits | Census > People > Households > Address > Phone Number Household.phone |
| Parent Email Address | Reports the email address of the primary parent/guardian. When there is no email address for the household, this field reports blank. Alphanumeric, 50 characters | Census > People > Demographics > Personal Contact Information > Email |
| Student First Name | Reports the student's first name. When the Report Legal Name checkbox is marked, the student's First Name reports from the Legal First Name field. Alphanumeric, 30 characters | Census > People > Demographics > Person Information > First Name Identity.firstName Census > People > Identities > Protected Identity Information > Legal First Name Identity.legalFirstName |
| Student Last Name | Reports the student's last name. When the Report Legal Name checkbox is marked, the student's Last Name reports from the Legal Last Name field. Alphanumeric, 30 characters | Census > People > Demographics > Person Information > Last Name Identity.lastName Census > People > Identities > Protected Identity Information > Legal Last Name Identity.legalLastName |
| NDE Student ID | Reports the unique number assigned to a student by the Department of Education. Numeric, 10 digits | Census > People > Demographics > Person Identifiers > Student State ID Person.stateID |
Previous Versions
P-EBT Extract (Nebraska) [.2327 - .2419]
P-EBT Extract (Nebraska) [.2251 - .2323]
P-EBT Extract (Nebraska) [.2219 - .2247]
