Tool Search: P-EBT
The P-EBT Extract (Pandemic-Electronic Benefit Transfer) extracts state-defined P-EBT data. P-EBT is available to families who qualify to receive Pandemic EBT food aid.
P-EBT Extract Editor
Report Population Logic
Report Editor
| Field | Description |
|---|---|
| Report Legal Name | If checked, the following fields will report from the Legal Name fields in Census when applicable: Student First Name, Student Last Name, Parent First Name, and Parent Last Name |
| Ad Hoc Filter | Select an Ad Hoc filter to limit report results to those that meet filter requirements. An Ad hoc filter must be selected to restrict the report population. |
| Format |
|
| File Number | Enter a user-defined file number. File numbers must be unique to each file. |
| Report Generation | The report can be marked to generate immediately using the Generate Extract button or can be marked to generate at a later time using the Submit to Batch button. See the Batch Queue article for additional guidance. |
Report Description
| Element | Description | Location |
|---|---|---|
School Year Optional | Reports the school year for the calendar selected in the report editor. 9 digits, YYYY-YYYY | Calendar Information > Calendar AND School Years |
Student's First Name | The reporting student's first name. Namefield, 60 characters | Identities > Current Identity > First Name Identity. firstName |
Student's Last Name | The reporting student's last name. Namefield,60 characters | Identities > Current Identity > Last Name Identity. lastName |
Student's Date of Birth | Reports the date on which the student being reported was born. Date field, YYYYMMDD, 8 characters | Identities > Current Identity > Birth Date Identity. birthdate |
SSN_or_S_Num | Reports the student's Social Security number or State ID. This field reports the Previous State ID. If the Previous State ID is null, the Social Security Number reports. Alphanumeric, 9 characters | Demographics > Previous State ID OR Soc Sec Number |
Local ID (LASID) Optional | Reports the student's local Student ID assigned by the school district. Alphanumeric, 9 characters | Demographics > Local Student Number Person.studentNumber |
Unique_ID | Reports the Student Unique State ID Numeric, 10 digits | Demographics > Student Unique State ID Person.stateID |
Student's Gender | Identification of the student as male, female, or unidentified. Reports M for Male, F for Female, and U for X/Unidentified | Identities > Current Identity > Gender Identity. gender |
District_ID | Reports the number assigned by the state to identify a school district. Numeric, 6 digits | District Information > District Detail > State District Number District.number |
Campus_ID | The unique school identification number made up of the district number and school number of the school in which the student is enrolled. Numeric, 9 digits | District Information > State District Number AND School Information > State School Number District.number School.number |
Entry Date Optional | Reports the Start Date on the reporting student's enrollment. Date field, 8 digits MMDDYYYY | Enrollment > Start Date Enrollment.startDate |
Withdrawal Date Optional | Reports the End Date on the reporting student's enrollment. Date field, 8 digits MMDDYYYY | Enrollment > End Date Enrollment.endDate |
Parent_First_Name | Reports the first name of the reporting student's primary guardian. Namefield, 60 characters | Relationships > Primary Household Relationships > Guardian Identities > Current Identity > First Name
|
Parent_Last_Name | Reports the last name of the reporting student's primary guardian. Namefield, 60 characters | Relationships > Primary Household Relationships > Guardian Identities > Current Identity > Last Name
|
Parent_DOB Optional | Reports the date of birth of the reporting student's Primary guardian. Date field, 8 digits MMDDYYYY | Identities > Current Identity > Birth Date Identity. birthdate |
Parent_Email Optional | Reports the Email, if null report Secondary Email reports. Alphanumeric, 125 characters | Demographics > Personal Contact Information > Email OR Secondary Email |
Parent_Ph_Num Optional | Reports the phone number of the student's Primary guardian. Numeric, 10 digits - no dashes | Households > Address > Phone Number Household.phone |
Address_Line_1 | Reports the student's most recent address. If the student does not have an address, the School's address reports. Alphanumeric, 50 characters | Households > Addresses > Address School Information > School Detail > Address Student Address.number Address.POBox Address.street Address.prefix Address.tag Address.direction Address.apt School School.address |
Address_Line_2 Optional | Reports additional address lines such as apartment number. Alphanumeric, 65 characters | Households > Addresses > Address School Information > School > School Detail > Address |
City | Reports the city of the student's most recent address. The School's City reports if the student does not have an address. String, 20 characters | Households > Address Info > City School Information > School Detail > City Address.city School.city |
State | Reports the 2-digit state code of the student's most recent address. If the student does not have an address, the School's State reports. String, 2 digits | Households > Address Info > State School Information > School Detail > State Address.state School.state |
Zip | Reports the five-digit zip code of the student's most recent address. If the student does not have an address, the School's Zip reports. Numeric, 5 digits | Households > Address Info > Zip School Information > School Detail > Zip Address.zip School.zip |
