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

(Updated as of 10/20/2021)

Description: Reports the count of students in Free/Reduced Price Meal, English Learner, and Foster Youth categories that are eligible for local supplemental funding dollars based upon their demographics as of Fall 1 Census Day. Totals are reported for each LEA and overall for the county selected.

Report Type: Snapshot (Fall 1)

Security Roles:

Data As Of:

  • Fall 1 Census Day (First Wednesday in October)

Basic Report Display Criteria:

LEA Selection

  • Only LEAs that have certified their data are displayed on the C/A reports
  • Reports display data only for expected school types flagged as “Y- Yes” or “P- Permitted”
  • Schools that are expected with a type “Y” will report zeros if the data is certified with no counts
  • Schools that are expected with a “P” and have not submitted data for the report data type, the school will not display on the report if zeros are certified.
  • Permitted type schools will only display if they submit and certify data within the report type.

This is a nested report meaning the first section selects all non-charter schools by LEA for the County. The second section selects all charter schools by LEA (including IRCs) for the County. If no schools are expected and certified 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
  • Students with multiple qualifying records within a single LEA as of Fall 1 Census Day are counted only once. A student with qualifying enrollments in more than one LEA on Census Day is counted in each LEA.
  • 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
  • County
  • LEA
  • School Type
  • School
  • Grade
  • Ethnicity/Race
  • Gender
  • Age Eligibility - 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, UE, US) – includes grades KN-12, UE, US 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


Column Rules
1 LEA code is derived from user ID permission and Expected Schools table
2 LEA Name is determined by #1 and the Expected Schools Table.
3 School Code is derived from user ID permission and Expected Schools table
4 School Name is derived from by #3 and the Expected Schools Table.
5 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.
6 Total Enrollment (All Age Eligibility) - 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.
7 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
8 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.
9 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
10 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
11 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
12 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
13 Total equals 7 + 8 + 9 + 10 + 11 + 12 AND Students counted only once regardless of multiple participation in 7, 8, 9, 10, 11 or 12 (Unduplicated)
14 SELA 12.13 – English Language Acquisition Status Code equals EL or ADEL and SELA 12.14 – English Language Acquisition Status Start Date on or before Census Day of the reporting year
15 Total equals 13 + 14 AND Students counted only once regardless of multiple participation in 13 or 14 (Unduplicated)

Glossary References:

English Learner Subgroup

Title 1 Part C Migrant Subgroup

Title III Eligible Immigrant Subgroup