P-EBT Upload (Wisconsin)

Classic View: WI State Reporting > P-EBT Upload

Search Terms: P-EBT Upload

The P-EBT (Pandemic Electronic Benefits) Extract returns a count of a student's P-EBT eligible days for a month during the reporting range for those students who receive free or reduced meals.

P-EBT Upload

Report Logic

A student must have an active primary enrollment and be receiving free or reduced price meals in the selected school during the reporting range - August 1 through the entered Effective Date. 

Students are counted when they have an active Free or  or Reduced FRAM eligibility or when a school is enrolled in the USDA Community Eligibility Provision (CEP) School.  

  • The School History record must have a Provision of 5: CEP. 
  • The School Year being reported must be within the Provision Base Year and the Provision End Year. 

A P-EBT Eligible day is one in which a student who received free/reduced meals is learning virtually or is absent for a COVID-related reason. 

  • P-EBT eligible days are calculated for whole months with the date range that is in the past. When the entered effective date is March 15, P-EBT eligible days are calculated through February.
  • When a student does not have any P-EBT eligible days, they are not included in the report.

A student must also have an Instruction Mode record where they are learning virtually or were absent from on-site learning due to COVID, OR they are in a Blended Learning Group that is meeting virtually for the day.

Students are not included when:

  • The enrollment record is marked as No Show, WISE Exclude or State Exclude.
  • The grade level of enrollment is marked as State Exclude.
  • The calendar of enrollment is marked as State Exclude or Summer School.

Report Editor

FieldDescription
Effective DateEntered date is used to count a student's P-EBT eligibile days, starting from August 1. The current date is auto-populated; use the calendar icon to select a new date, or enter a new date in mm/dd/yyyy format.
GradeSelection indicates which grade levels of enrollment are included in the report.
Ad hoc FilterSelect 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.
FormatThe P-EBT Extract can be generated in either CSV or HTML formats.
Calendar SelectionAt least one calendar needs to be selected in order to generate the report. Reports can be selected by Active Year, School or Year.
Report GenerationThe P-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 P-EBT Extract

  1. Enter the desired Effective Date.
  2. Select the desired Grade levels to include in the report.
  3. If desired, select students from an existing Ad hoc Filter.
  4. Select the Format of the report.
  5. Select the Calendar(s) from which to report information.
  6. Click the Generate Extract button or use the Submit to Batch button. The report displays in the desired format.

P-EBT Upload - HTML Format

P-EBT Upload - CSV Format

Report Layout

Data ElementDescriptionLocation
School District CodeReports the number assigned to a school district by the state department of education.

Numeric, 4 digits
System Administration > Resources > District Information > District Information > State District Number

District.number
School Code

Reports the state-assigned school number.


Numeric, 4 digits


System Administration > Resources > School > State School Number

School.number
School NameReports the school in which the student is enrolled.

Alphanumeric, 30 characters
System Administration > Resources >School > School Name

School.name
First Name

Reports the student's first name.



Alphanumeric, 30 characters

Census > People > Demographics > Person Information > First Name


Identity.firstName

Middle Initial

Reports the student's middle initial.



Alphanumeric, 1character

Census > People > Demographics > Person Information > Middle Name


Identity.middleName

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

Date of BirthReports the student's date of birth.

Date field, 10 characters  (MM/DD/YYYY)


Census > People > Demographics > Person Information > Birth Date

Identity.birthDate
SuffixReports any assigned generational birth designation (Jr, III, etc.).

Alphanumeric, 5 characters
Census > People > Demographics > Person Information > Suffix

Identity.suffix
GradeReports the student's grade level of enrollment.

Leading zeros are removed from grade levels 1-9. Students in grades K3, K4, or PK report as K3/K4/PK.

Alphanumeric, 3 digits
Student Information > General > Enrollments > General Enrollment Editor > Grade

Enrollment.grade
GenderReports the student's legal gender from the current identity record.

When the Legal Gender field is blank, reports from the Gender field.

Alphanumeric, 1 character (M or F)
Census > People > Identities > Protected Identity Information > Legal Gender

Identity.legalGender
Census > People > Demographics > Person Information > Gender

Identity.gender
AugustReports the count of the student's P-EBT eligible days within the month of August where: 
  • Student's FRAM Eligibility is F or R; AND
  • Student has a P-EBT Instruction Mode of 01: Learning Virtually or 02: COVID Absent for the day; OR
  • Student is in a Blended Learning Group that is remote for the day.

The Effective Date entered on the Report Editor must be greater than or equal to September 1 (09/01).
Calculated value
SeptemberReports the count of the student's P-EBT eligible days within the month of September where: 
  • Student's FRAM Eligibility is F or R; AND
  • Student has a P-EBT Instruction Mode of 01: Learning Virtually or 02: COVID Absent for the day; OR
  • Student is in a Blended Learning Group that is remote for the day.
The Effective Date entered on the Report Editor must be greater than or equal to October 1 (10/01).
Calculated value
OctoberReports the count of the student's P-EBT eligible days within the month of October where: 
  • Student's FRAM Eligibility is F or R; AND
  • Student has a P-EBT Instruction Mode of 01: Learning Virtually or 02: COVID Absent for the day; OR
  • Student is in a Blended Learning Group that is remote for the day.
The Effective Date entered on the Report Editor must be greater than or equal to November 1 (11/01).
Calculated value.
NovemberReports the count of the student's P-EBT eligible days within the month of November where: 
  • Student's FRAM Eligibility is F or R; AND
  • Student has a P-EBT Instruction Mode of 01: Learning Virtually or 02: COVID Absent for the day; OR
  • Student is in a Blended Learning Group that is remote for the day.
The Effective Date entered on the Report Editor must be greater than or equal to December 1 (12/01).
Calculated value.
DecemberReports the count of the student's P-EBT eligible days within the month of December where: 
  • Student's FRAM Eligibility is F or R; AND
  • Student has a P-EBT Instruction Mode of 01: Learning Virtually or 02: COVID Absent for the day; OR
  • Student is in a Blended Learning Group that is remote for the day.
The Effective Date entered on the Report Editor must be greater than or equal to January 1 (01/01).
Calculated value
JanuaryReports the count of the student's P-EBT eligible days within the month of January where: 
  • Student's FRAM Eligibility is F or R; AND
  • Student has a P-EBT Instruction Mode of 01: Learning Virtually or 02: COVID Absent for the day; OR
  • Student is in a Blended Learning Group that is remote for the day.
The Effective Date entered on the Report Editor must be greater than or equal to February 1 (02/01).
Calculated value
FebruaryReports the count of the student's P-EBT eligible days within the month of February where: 
  • Student's FRAM Eligibility is F or R; AND
  • Student has a P-EBT Instruction Mode of 01: Learning Virtually or 02: COVID Absent for the day; OR
  • Student is in a Blended Learning Group that is remote for the day.
The Effective Date entered on the Report Editor must be greater than or equal to March 1 (03/01).
Calculated value
MarchReports the count of the student's P-EBT eligible days within the month of March where: 
  • Student's FRAM Eligibility is F or R; AND
  • Student has a P-EBT Instruction Mode of 01: Learning Virtually or 02: COVID Absent for the day; OR
  • Student is in a Blended Learning Group that is remote for the day.
The Effective Date entered on the Report Editor must be greater than or equal to April 1 (04/01).
Calculated value
AprilReports the count of the student's P-EBT eligible days within the month of April where: 
  • Student's FRAM Eligibility is F or R; AND
  • Student has a P-EBT Instruction Mode of 01: Learning Virtually or 02: COVID Absent for the day; OR
  • Student is in a Blended Learning Group that is remote for the day.
The Effective Date entered on the Report Editor must be greater than or equal to May 1 (03/01).
Calculated value
MayReports the count of the student's P-EBT eligible days within the month of May where: 
  • Student's FRAM Eligibility is F or R; AND
  • Student has a P-EBT Instruction Mode of 01: Learning Virtually or 02: COVID Absent for the day; OR
  • Student is in a Blended Learning Group that is remote for the day.
The Effective Date entered on the Report Editor must be greater than or equal to June 1 (06/01).
Calculated value.
JuneReports the count of the student's P-EBT eligible days within the month of June where: 
  • Student's FRAM Eligibility is F or R; AND
  • Student has a P-EBT Instruction Mode of 01: Learning Virtually or 02: COVID Absent for the day; OR
  • Student is in a Blended Learning Group that is remote for the day.
The Effective Date entered on the Report Editor must be equal to June 30 (06/30).

NOTE: When the Report Effective Date is in June, the entered date must be June 30 in order to report the eligible days from June.  
Calculated value
Parent/Caretaker First NameReports the first name of the person marked as Primary Guardian.

Parent/Guardian information reports as follows:

  • The Primary and current Household is determined first.
  • The current address reports from the primary and current household.
  • The individual marked as Guardian in that primary and current household who has the lowest personID reports as the Guardian on the report.
Alphanumeric, 30 characters

Census > People > Demographics > Person Information > First Name


Identity.firstName

Parent/Caretaker Middle InitialReports the middle initial of the person marked as Primary Guardian.

Parent/Guardian information reports as follows:

  • The Primary and current Household is determined first.
  • The current address reports from the primary and current household.
  • The individual marked as Guardian in that primary and current household who has the lowest personID reports as the Guardian on the report.
Alphanumeric, 1 character

Census > People > Demographics > Person Information > Middle Name


Identity.middleName


Parent/Caretaker Last NameReports the last name of the person marked as Primary Guardian.

Parent/Guardian information reports as follows:

  • The Primary and current Household is determined first.
  • The current address reports from the primary and current household.
  • The individual marked as Guardian in that primary and current household who has the lowest personID reports as the Guardian on the report.
Alphanumeric, 30 characters

Census > People > Demographics > Person Information >Last Name


Identity.lastName

Parent/Caretaker Date of BirthReports the birth date of the person marked as Primary Guardian.

Date field, 10 characters (MM/DD/YYYY)

Census > People > Demographics > Person Information > Birth Date


Identity.birthDate


Parent/Caretaker Phone NumberReports 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 > Demographics > Personal Contact Information > Phone

Contact.householdPhone
Parent/Caretaker EmailReports the email address of the person marked as Primary Guardian.

Alphanumeric, 100 characters
Census > People > Demographics > Personal Contact Information > Email

Contact.email
Parent/Caretaker StreetReports the student's most recent active mailing address (street address when entered, or PO Box when marked).

When there is no address available for the student, this field reports blank.

Alphanumeric, 44 characters

Census > Households > Addresses > Address 


Address.number

Address.POBox

Address.street

Address.prefix

Address.tag

Address.direction


Parent/Caretaker Street 2Reports the Apartment of the address, if available. Otherwise, this field reports blank.

Alphanumeric, 3 characters
Census > Households > Addresses > Address > Apartment

Address.apt
Parent/Caretaker CityReports the student's city as noted on their most recent active mailing address.

When there is no city available for the student, this field reports blank.

Alphanumeric, 50 characters

Census > Households > Addresses > Address


Address.city



Parent/Caretaker StateReports the student's state as noted on their most recent active mailing address.

When there is no state available for the student, this field reports blank.

Alphanumeric, 2 characters

Census > Households > Addresses > Address


Address.state



Parent/Caretaker Zip Code
Reports the zip code (either 5-digit code or 9-digit code) of the student's most recent active mailing 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