Report 1.17: LCFF Unduplicated Pupil Count

(Updated 10/1/2025)

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 Real Time version of this report will not be available for 2013-2014. Use Certification instead.

Report Type: Real Time and Certification (Fall 1)

Security Roles: Free and Reduced role

Data As Of:

  • If Real Time version, user defined
  • If Certification 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 = TK, KN-12
  • Exclude TK or KN students whose 4th birthday is after September 1st of the selected Academic Year
  • 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 must 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 – (Certification)
  • School Type
  • School
  • Grade
  • Ethnicity/Race
  • Gender
  • Student with Disabilities
  • Age Eligibility Filter
    • For academic year 22-23+: filter will show no dropdown options (N/A) since report now only includes students who are LCFF eligible.
    • For academic year 21-22 and prior:
    • 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


Report1.17 Screenshot

Click image to expand


Column Description
1 School Code – Derived from user ID permission and Expected Schools table
2 School Name – Determined by #1 and the Expected Schools Table. Leads to Report: 1.18 LCFF Unduplicated Pupil Student List
3 LCFF Eligible Total Enrollment – Count of students with a qualifying open enrollment as of report date. Limited by age eligibility; only includes students who turn 4 by September 1st of the current Academic Year
4 FRPM (NSLP Free/Reduced) – SPRG 3.13 = 181 (NSLP Free) or 182 (NSLP Reduced) AND SPRG 3.15 Start Date = 7/1 through 10/31 with no Exit before Census Day in the same LEA. If closed before Census Day but a subsequent 181/182 record exists with Start Date ≤ 10/31, the student is counted. Note: Counted at the school of enrollment on Census Day
5 Foster Youth (CDSS File) – Students with a record in the DSS Foster Youth Match Result file where:
• Foster Placement Indicator = Y
• Case Start Date ≤ Census Day AND Case End Date NULL or ≥ Census Day
• If Case Start Date is NULL, use Episode Start/End Dates (Episode Start ≤ Census Day, Episode End NULL or ≥ Census Day)
• Students matched after final Fall 1 Amendment window are not shown as foster on Census Day
6 Tribal Foster Youth – SPRG 3.13 = 193 with Membership Start Date ≤ Census Day and End Date ≥ Census Day
7 Homeless Students – SPRG 3.13 = 191 with Membership Start Date ≤ Census Day and End Date ≥ Census Day
8 Migrant Students (Title I Part C) – Eligible students where program eligibility overlaps Census Day.
• AY ≤ 2024–25: SPRG 3.13 = 135
• AY ≥ 2025–26: Identified via MSIN weekly data file
9 Direct Certification – Direct Certification Status = Y and Direct Certification Date ≤ November Direct Certification CALPADS Extract Date for the Academic Year
10 Unduplicated Program Count – Unduplicated count of students in columns 4 + 5 + 6 + 7 + 8 + 9
11 English Learners (EL/ADEL) – SELA 12.13 = EL or ADEL AND SELA 12.14 (Start Date) ≤ Census Day of the reporting year
12 Unduplicated FRPM/EL/Foster Youth Eligible – Unduplicated count of students included in columns 10 + 11
13 Prior Academic Year FRPM/EL Eligible (Informational) – Unduplicated student count certified in prior year (from the Unduplicated FRPM/EL/Foster Student Total column)
14 Count Difference vs Prior Year (Informational) – Difference between current year Unduplicated FRPM/EL Eligible Total and prior year certified Unduplicated FRPM/EL Eligible Total.
Calculation: Current Year Total − Prior Year Total.
Note: If fewer students in current year, display as negative number

Additional Resources:

Local Conrol Funding Formula FAQ

Frequently asked questions and answers regarding the Local Control Funding Formula (LCFF).

CALPADS File SpecificationsForm

Look for Student Enrollment (SENR), Student Information (SINF), Student English Language Acquisition (SELA), Student Program (SPRG) tabs for the fields indicated in the report logic.

Glossary References

Funding Eligible
English Learner
Foster Youth Economically Disadvantaged Subgroup
Homeless
Migrant