Report 5.1 - Program Participants - Count

(Updated as of 05/10/2021)

Description: Reports the total number of students with a qualifying enrollment who participated in any of the specified programs at any time during the Report Period.

Report Type: Snapshot/Certification (EOY 2) ODS Academic Year

Report Period:

  • Report Period (July 1 thru June 30 of the reporting year)

Basic Selection Criteria:

  • Any open or closed enrollment within the LEA at any time during the Report Period qualifies for selection.

  • Enrollment Status Code = 10, 20, or 30 for all programs except Title 1 Part A Basic School-wide.

  • Enrollment Status Code = 10 for Title 1 Part A Basic School-Wide.

  • Grade Level = KN-12

  • Program record exists at any time during the Report Period

If a student participated in the same program multiple times at a single school during the Report Period, the student is counted once in the most RECENT program at the school.

If a student participated in multiple programs at a single school during the Report Period, the student is counted once in each program at the school.

If a student participated in the same program at different schools during the Report Period, the student is counted once in the program at each school. - Total Selected Schools – Total unduplicated count of SSID’s by program

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

  • School

  • Status (Snapshot)

  • School Type

  • Grade

  • Gender

  • Ethnicity

  • Enroll Status

  • User Comments

Report Logic:


EOY 2 Report5.1


Column Rules
1 LEA code is derived from user ID permission and Expected Schools table
2 School Name is determined by #1 and the Expected Schools Table.
NOTE: The unduplicated counts in Columns 3 -10 are based on the following rules.
- Count of SSID by program, attributed to schools with qualifying enrollment(s) in the report period AND have Education Program Membership Start Dates in the report period.
- SENR 1.05 -School of Attendance equal to SPRG 3.05 – School of Attendance where SENR 1.23 - School Start Date falls within Report Period and SPRG 3.15 Program Membership Start Date is greater than or equal to Academic year start date and 3.16 Program Membership end date equals Blank - OR – after 7/1 of the reporting year
- Column count links lead to Report 5.3 Program Participants Student List
3 SPRG 3.13 – Program Code equal 108 – Opportunity
4 SPRG 3.13 – Program Code equal 113 – California Partnership Academy.
5 SPRG 3.13 – Program Code equal 162 – Pregnant or Parenting Programs
6 SPRG 3.13 – Program Code equal 185 – Transitional Kindergarten
7 SPRG 3.13 – Program Code equal 101 – 504 Accommodation Plan
8 SPRG 3.13 – Program Code equal 122 – NCLB Title I Part A Basic Targeted
9 SPRG 3.13 – Program Code equal 174 – NCLB Title I Part A Neglected AND Reporting LEA does not have any NCLB Title I Part A Basic School-wide or Targeted program records
10 NCLB Title 1 Part A Basic School-wide – count automatically generated from cumulative AY enrollment status. The count is derived from an unduplicated count by school of open and closed enrollments that occurred during the reporting year
11 SPRG 3.13 – Program Code equal 192 – Armed Forces Family Member


User Roles for Access:

EOY 2 Reports


Additional Resources

CALPADS File SpecificationsForm

Look for Student Enrollment (SENR) and Student Program (SPRG) tabs for the fields indicated in the report logic.

CALPADS Data Guide

Chapter 2.1.3 provides additional information on Student Programs .

CALPADS Code Sets

This document contains the current code values referenced in the file specifications for the coded value data elements. The program code definitions are listed in this document.

Additional Resources

Consolidated Application and Reporting System (CARS)

The Consolidated Application and Reporting System (CARS) is a data collection system to apply for Categorical Program Funding and to report on the use of those funds.