P-EBT Report
Introduction
The new Pandemic Electronic Benefit Transfer (P-EBT) report is now available that pulls enrollment data per the EDD specifications. The P-EBT report provides nutrition benefits to students who have lost access to free or reduced-price school meals. This also includes students who have hybrid schedules that reduce the number of days or hours they are in the school building, or who are fully remote learning (even if their school is open to some students).
This district level report allows the district to upload current year data of students enrolled in the selected school(s) into the State Report Manager (SRM) for transfer to the Division of Public Assistance for federal reporting purposes. It is recommended that enrollment data is uploaded quarterly during the 2021-2022 school year.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Student Selection
The report selects records from the [Students] table based on the following criteria:
Student must not be excluded from state reporting.
Student must be enrolled in the school(s) during the current school year.
Report Input
For help with navigation and running the report, seeHow to Find and Generate a Report.
Field | Description |
Schools to Report | Choose one, all, or a selection of Schools. A school selection will only be offered at District Office. When running at a school, only that school will be available. |
Students to Include | Required. Indicate which students to include in the report by choosing one of the following options:
If running the report for a single student, or group of students, select the students prior to running the report. |
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
File Layout/Definition
Excel Col | Data Element | Element Description/Notes | [Table]Fieldname | Type | Max Length | Required/ Optional/ Conditional |
---|---|---|---|---|---|---|
A2 | AKSID | Student Identification Number. | [Students]State_StudentNumber | Number | 10 | Required |
B2 | LocalID | District Student Identification Number | [Students]Student_Number | Number | 15 | Optional |
C2 | LastName | The student's last name borne in common by members of the student's family. This is the student's legal name. If the legal name field is not populated, the student's preferred name is reported. | [Students]Last_Name | Text | 35 | Required |
D2 | FirstName | The student's first name given at birth, baptism, or during another naming ceremony, or through legal change. This is the student's legal name. If the legal name field is not populated, the student's preferred name is reported. | [Students]First_Name | Text | 35 | Required |
E2 | MiddleName | The student's middle name given to the student at birth, baptism, or during another naming ceremony, or through legal change. Blanks are NOT allowed. Use NMN (no middle name) where appropriate. This is the student's legal name. If the legal name field is not populated, the student's preferred name is reported. | [Students]Middle_Name | Text | 35 | Optional |
F2 | Suffix | The suffix attached to the student's name. This is the student's legal suffix. If the legal suffix field is not populated, the student's preferred suffix is reported. | [S_AK_STU_X]Suffix | Text | 8 | Optional |
G2 | BirthDate | The date of birth of the student in the MM/DD/YYYY format. | [Students]DOB | Date/Time | 10 | Required |
H2 | Gender | The gender of the student. This is the student's legal gender. If the legal gender field is not populated, the student's preferred gender is reported. Valid values:
| [Students]Gender | Text | 1 | Optional |
I2 | Race | Race or Ethnicity of the student. | [Students]Ethnicity | Text | 1 | Optional |
J2 | SchoolID | School Identification Number which is a unique ID assigned to the school. | [Students]SchoolID [Schools]Alternate_School_Number [Schools]School_Number | Number | 6 | Required |
K2 | Grade | The Grade Level of the student. | [Students]Grade_Level | Text | 2 | Optional |
L2 | Address1 | This is the student’s primary mailing address information and typically contains the building number and street name. | [Students]Mailing_Street | Text | 35 | Required |
M2 | Address2 | This includes any additional information about the student’s address and typically includes a rural route number, apartment number, unit number, and so on. | [Students]Mailing_Street | Text | 35 | Optional |
N2 | City | The city of the student’s mailing address. | [Students]Mailing_City | Text | 35 | Required |
O2 | Zip | The zip code of the student’s mailing address. | [Students]Mailing_Zip | Number | 5 | Required |
P2 | Notes | Any notes related to the student. | Text | 100 | Optional | |
Q2 | EconDisadv | Economically Disadvantaged Status Valid values:
| Pulls value from the [S_AK_STU_X]Econ field if it exists. If the value is null, then N will be displayed if Lunch Status = ‘P’, else Y will be displayed. | Text | 1 | Required |
R2 | Enroll7 | Enrolled in July 2020 Valid values:
The report checks if the Enrolled in District for the Full Academic Year override(s_ak_stu_x.fay_district) field is set to Y, then the report displays Y for all school records to indicate that the student is enrolled for the entire year. If the Enrolled in District for the Full Academic Year override(s_ak_stu_x.fay_district) field is set to N or blank, then the report displays Y if the student is enrolled in the school for at least one day in the specified month. | Derived field | Text | 1 | Required |
S2 | Enroll8 | Enrolled in August 2020 Valid values:
Same behavior as described for column R2 | Derived field | Text | 1 | Required |
T2 | Enroll9 | Enrolled in September 2020 Valid values:
Same behavior as described for column R2 | Derived field | Text | 1 | Required |
U2 | Enroll10 | Enrolled in October 2020 Valid values:
Same behavior as described for column R2 | Derived field | Text | 1 | Required |
V2 | Enroll11 | Enrolled in November 2020 Valid values:
Same behavior as described for column R2 | Derived field | Text | 1 | Required |
W2 | Enroll12 | Enrolled in December 2020 Valid values:
Same behavior as described for column R2 | Derived field | Text | 1 | Required |
X2 | Enroll1 | Enrolled in January 2021 Valid values:
Same behavior as described for column R2 | Derived field | Text | 1 | Required |
Y2 | Enroll2 | Enrolled in February 2021 Valid values:
Same behavior as described for column R2 | Derived field | Text | 1 | Required |
Z2 | Enroll3 | Enrolled in March 2021 Valid values:
Same behavior as described for column R2 | Derived field | Text | 1 | Required |
AA2 | Enroll4 | Enrolled in April 2021 Valid values:
Same behavior as described for column R2 | Derived field | Text | 1 | Required |
AB2 | Enroll5 | Enrolled in May 2021 Valid values:
Same behavior as described for column R2 | Derived field | Text | 1 | Required |
AC2 | Enroll6 | Enrolled in June 2021 Valid values:
Same behavior as described for column R2 | Derived field | Text | 1 | Required |