Report 1.17: FRPM/English Learner/Foster Youth – Count

(Updated as of 10/6/2021)

Description: Reports the count of students in categories that are eligible for local supplemental funding dollars based upon their demographics as of Fall 1 Census Day. Totals by school and totals by LEA with drill down links to student list for each school.

Eligibility is determined based on students qualifying for Free or Reduced Price Meals, being classified as English Learners, or being identified as Foster Youth. (Students may qualify for consideration under multiple categories.) The report provides Duplicated Counts (for those students qualified by multiple criteria) and Unduplicated Counts by school where a student is counted only 1 time per school.

NOTE: The ODS version of this report will not be available for 2013-2014. Use Snapshot instead.

Report Type: ODS and Snapshot/Certification (Fall 1)

Security Roles: Fall 1 Reports and Free and Reduced Price Meal VIEW

Data As Of:

  • If ODS version, user defined
  • If Snapshot version, Fall 1 Census Day (First Wednesday in October)

Basic Report Display Criteria:

  • This is a nested report, meaning the first section selects all non-charter schools by LEA. The second section selects all charter schools by LEA (including IRCs). If no schools are expected for a section of the report, the Heading and the Total Selected LEAs row is displayed with zeros for all counts.

  • Non-Charter School(s) Selection: Schools with a ’N’ under Charter School Indicator in Educational Service Institutions table that are active for the selected report “As of” date shall be included in this section of the report.

  • Charter School(s) Selection: Schools with a ’Y’ under Charter School Indicator in Educational Service Institutions table that are active for the selected report “As of” date shall be included in this section of the report.

Basic Selection Criteria

  • Student must have an open enrollment (SENR) record within the LEA as of Fall 1 Census Day (first Wednesday in October of the reporting year)
  • Enrollment Status = 10 - Primary or 30 – Short Term Enrollment
  • School type is NOT Adult Education Center
  • If more than one qualifying enrollment exists for a student, count in each school, unless both primary and short term enrollment are within the same LEA. In that case, report and count the student only in the school of primary enrollment.
  • Grade Level = KN-12
  • The EL Funding Eligible Count is based on students EL or ADEL status as of Census Day
  • Must have a SINF record that wholly or in part overlaps a qualified enrollment. For Short-term enrollments, use SINF associated with the Primary Enrollment record.
  • Direct Certification Date muse be on or before November of the academic year.
  • SPRG data used for Free and Reduced-Priced Meals (FRPM) are selected from 181/182 program codes with Membership Start Dates occurring between 7/1 and 10/31 of the reporting year.
    • Note: Students that are enrolled in School A on Census Day, transfer to School B in the same LEA after Census Day, and School B submits qualifying FRPM record (start date 7/1 – 10/31 of the reporting year), should be counted under School A as FRPM.

Report Filters: Filters can be selected resulting in only totals for the selected filter being displayed – legend on bottom of last page of report states which filter/s were selected

  • Academic Year
  • LEA
  • Status – (Snapshot)
  • School Type
  • School
  • Grade
  • Ethnicity/Race
  • Gender

  • Age Eligibility Filter

    • LCFF (DEFAULT) – includes grades KN-12, and excludes students with Grade Level equals KN and whose 5th birthday (Student Birth Date) is after December 2nd of the selected Academic Year based on the As of Date of the report, if this value is selected.
    • All (KN-12) – includes grades KN-12, based on the As of Date of the report, if this value is selected
    • Title 1 (5 - 17 year olds only) – includes ages 5-17 in whole years based on Student Birth Date and the As of Date of the report, if this value is selected.

Report Logic


Report 1.17: FRPM English Learner Foster Youth Count


Column Rules
1 School code is derived from user ID permission and Expected Schools table
2 School Name is determined by #1 and the Expected Schools Table School Name column leads to Report: 1.18 FRPM/EL/Foster Youth – Student List
3 Total Enrollment (With Applied Filters) - SENR 1.23 – Enrollment Start Date is less than or equal to Census Day and SENR 1.24 – Enrollment Status is 10 (Primary) or 30 (Short Term) and SENR 1.26 – Enrollment Exit Date is on or after Census Day or blank. Note: Students included are based on user selected Age Eligibility Filter.
4 Total Enrollment (Not Filtered) - SENR 1.23 – Enrollment Start Date is less than or equal to Census Day and SENR 1.24 – Enrollment Status is 10 (Primary) or 30 (Short Term) and SENR 1.26 – Enrollment Exit Date is on or after Census Day or blank. Note: Students included are based on age eligibility set to All (KN – 12) regardless of the user selected Age Eligibility. All other filters may modify this count.
5 SPRG 3.13 – Education Program Code = 181 (NSLP Free) or 182 (NSLP Reduced) and SPRG 3.15 – Education Program Membership Start Date = 7/1 through 10/31 of the Reporting year in the same Reporting LEA. Note: A student should be counted FRPM at the school where they are enrolled on Census Day.
6 California Department of Social Services (CDSS) provides a weekly data file to CDE that identifies all Foster Youth.
Include foster placement and family maintenance data for students that have a record in the DSS Foster Youth Match Result file where the Foster Placement indicator equals Y and the Case Start Date is less than or equal to Census Day and the Case End Date is NULL or greater than or equal to Census Day for the associated school of qualifying enrollment.
If the Case Start Date is NULL, the Episode Start Date and Episode End Date will be used. If the Episode Start Date is less than or equal to Census Day and the Episode End Date is NULL or greater than or equal to Census Day.
Students matched after final Fall 1 Amendment window do not show as foster on Fall 1 Census day.
7 SPRG 3.13 – Education Program Code equals 193 (Tribal Foster Youth) and SPRG 3.15 – Education Program Membership Start Date is on or before Census day and SPRG 3.16 – Education Program Membership End Date is on or after Census day
8 SPRG 3.13 – Education Program Code equals 191 (Homeless) and SPRG 3.15 – Education Program Membership Start Date is on or before Census day and SPRG 3.16 – Education Program Membership End Date is on or after Census day
9 SPRG 3.13 – Education Program Code equals 135 (Migrant) and SPRG 3.15 – Education Program Membership Start Date is equal to or less than Census day and SPRG 3.16 – Education Program Membership End Date is greater than or equal to Census day
10 Direct Certification Status equal Y and Direct Certification Date is on or before November Direct Certification CALPADS Extract Date for the Academic Year the report is being run
11 Unduplicated count of students, regardless of multiple participation, in columns 5 + 6 + 7 + 8 + 9 + 10.
12 12. SELA 12.13 – English Language Acquisition Status Code equals EL or ADEL and SELA 12.14 – English Language Acquisition Status Start Date is on or before Census Day of the reporting year
13 13. Unduplicated count of students included in columns 11 + 12

Glossary References:

Funding Eligible,

English Learner,

Foster Youth,

Economically Disadvantaged Subgroup,

Homeless,

Migrant