P-EBT Extract (Colorado) [.2148 - .2211]

Classic View: CO State Reporting > Data Pipeline > P-EBT Extract

Search Terms: Data Pipeline

The P-EBT (Pandemic Electronic Benefits) Extract returns data on students who are eligible for SNAP or FRPL and meet the criteria to receive P-EBT. 

P-EBT Extract

Report Logic

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. If a student has more than one enrollment, only one record reports. 

Parent/Guardian and Address 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.

The Primary Parent/Guardian First Name, Primary Parent/Guardian Last Name, and Primary Parent/Guardian Telephone Number fields report even when a student's household does NOT have an address. 

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.

Report Editor

FieldDescription
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.

Report Legal NameWhen marked, the student's name and gender report from the Protected Identity Information section on the student's Identities record.
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 appropriate Start Date and End Date for the extract.
  2. Mark the Report Legal Name checkbox, if desired.
  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 Extract - HTML Format

P-EBT Extract - CSV Format

Report Layout

Data ElementDescriptionLocation
School District CodeThe 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 > District Information > District Information > State School Number

School.number
Student State ID (SASID)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
Local ID (LASID)Reports the locally-assigned student number by the school district.

Numeric, 10 digits
Census > People > Demographics > Person Identifiers > Student Number

Person.studentNumber
Student's 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's Middle Name

Reports the student's middle name.


When the Report Legal Name checkbox is marked, the student's Middle Name reports from the Legal Middle Name field.


If the Middle Name field is blank, reports as NMN.


Alphanumeric, 30 characters


Census > People > Demographics > Person Information > Middle Name


Identity.middleName


Census > People > Identities > Protected Identity Information > Legal Middle Name


Identity.legalMiddleName


Student's 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

Student's Gender

Reports the student's gender.

  • 01 - Female
  • 02 - Male

When the Report Legal Name checkbox is marked, the student's Gender reports from the Legal Gender field. 


Numeric, 2 digits

Census > People > Demographics > Person Information > Gender


Identity.gender


Census > People > Identities > Protected Identity Information > Legal Gender


Identity.legalGender

Student's Date of BirthStudent's date of birth.

Date field, 8 characters  (MMDDYYYY)


Census > People > Demographics > Person Information > Birth Date

Census > People > Identities > Identities Editor > Birth Date

Identity.birthDate
Student's Grade LevelStudent's grade level of enrollment.

Numeric, 3 digits
System Administration > Calendar > Calendar > Grade Levels > State Grade Level

Calendar.stateGradeLevel
Student's Language BackgroundReports 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

Primary Parent/Guardian 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 > Relationships > Primary Household Relationships > Guardian


Census > People > Demographics > Person Information > First Name


Identity.firstName

Primary Parent/Guardian 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 > Relationships > Primary Household Relationships > Guardian


Census > People > Demographics > Person Information >Last Name


Identity.lastName

Primary Parent/Guardian Telephone NumberReports the 10-digit primary phone number assigned at the household, including area code (no dashes).

If there is no phone number for the household, this field reports blank.

Numeric, 10 digits
Census > People > Households > Address > Phone Number

Household.phone
Student's Primary Mailing Address 1Reports the student's mailing address (street address when entered, or PO Box when marked).

The student's current and primary address reports.

If 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


School.address
School.city
School.state
School.zip
Student's Primary Mailing Address 2This field reports blank.N/A
Student's Primary Mailing CityReports the student's city as noted on their primary address. If 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

Student's Primary Mailing StateReports the student's state as noted on their primary address. If 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

Student's Primary Mailing Postal CodeReports the zip code (either 5 digit code or 9 digit code) of the parent's primary household address.  If 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

Student's Primary Mailing County CodeReports the number associated with the county in which the student lives. If the student does not have an address, this field reports blank.

Numeric, 2 digits

Census > Households > Addresses > Address


Address.county



Free/Reduced Price Lunch EligibleIndicates whether the student is free or reduced lunch eligible during the reporting period.

A value of 01 reports when the student has a FRAM eligibility record during the reporting period.

A value of 00 reports when the student does not have a FRAM eligibility record during the reporting period.

Numeric, 2 digits
FRAM > Eligibility > School Year AND Start Date AND End Date AND Eligibility

POS.eligibility
Learning Modality: Full Time Remote LearningIndicates whether the student was enrolled in full time distance learning.

Reports 01 when the Remote Learning field is marked on the student's Enrollment Record.

Reports 00 when the Remote Learning field is not marked on the student's Enrollment record.

Numeric, 2 digits
Student Information > General > Enrollments > State Reporting Fields > Remote Learning

Enrollment.remoteLearning