Skip to content

Report 1.21 - Cumulative Enrollment - Count

Description: Reports the cumulative enrollment for the academic year. The total primary, secondary, and short-term enrollment counts are grouped and certified census day enrollment count is provided for comparison.

Data As Of:

  • Snapshot version, any time in the reported academic year (7/1 – 6/30)

Security Role(s) Required: EOY Reports

Basic selection criteria:

  • Open or closed enrollment record within the LEA at any time during the Report Period (7/1/ – 6/30)

  • Excludes one-day enrollments where Enrollment Start Date is between 7/1 – 8/15 and Completion Status is populated (aka summer grads)

  • Enrollment Status = 10, 20, or 30

  • Grade level = TK-12

Report Filters: Filters can be selected resulting in only totals for the selected filter being displayed

  • Academic Year
  • LEA
  • Status
  • School Type
  • School
  • Grade
  • Gender
  • Ethnicity/Race
  • Enrollment Status
  • Cumulative Enrollment Type*
  • English Language Acquisition Status
  • Long-Term English Learner
  • Socio-economically Disadvantaged
  • Students with Disabilities
  • Student School Transfer Code
  • District of Geographic Residence
  • Homeless Program Eligible
  • Title I Part C Migrant
  • Foster Youth

*Note: Cumulative Enrollment (default): includes any enrollment with specified enrollment status (10, 20, 30) that overlaps the academic year, even if the enrollment started before 7/1 of the academic year. Adjusted Cumulative Enrollment: only those records that have an Enrollment Start Date on or after July 1s of the Report Academic Year. One Year Completer (available only for 2019-20 Academic Year): only those records that have an Enrollment Exit Date between August 16th of the Report Academic Year and August 15th of the following Academic Year AND School Completion Status = 100, 120, 320 and 330.

Report Logic

Report 1.22 Screenshot


# Field Description
1 School Code Derived from user ID permission and Expected Schools table.
2 School Name Determined by School Code and the Expected Schools Table.
3 SENR Field 1.24 – Grade Level TK–12.
4 SINF Field 2.19 – Student Gender Code Student gender code.
5 Ethnicity/Race Identified using SINF Fields 2.23–2.30 using the following rules:

1. If Student Hispanic Ethnicity Indicator (2.23) = Y, roll up to Hispanic.
2. If 2.23 = N or null, 2.24 = Y or null, and Race 1–5 Codes (2.25–2.29) indicated, roll up per Rule 5.
3. If 2.23 = N and 2.30 = Y, roll up to Missing.
4. If 2.23 = N or null and 2.30 = Y, roll up to Missing.
5. If 2.23 = N or null, 2.30 = N or null, and Race Codes indicated, roll up as follows:
• American Indian or Alaska Native (100) → American Indian or Alaska Native
• Asian subgroup(s) only (201–299) → Asian
• Filipino (400) only → Filipino
• Filipino + Asian subgroup(s) only → Filipino
• Native Hawaiian/Pacific Islander subgroup(s) only (301–399) → Hawaiian/Pacific Islander
• Black or African American (600) only → Black or African American
• White (700) only → White
• More than one major race category → Multiple
6 Certified Census Day Total Primary Enrollments Count of certified Fall 1 primary enrollments on Census Day from Report 1.1. Available only for school and LEA totals, not by Grade, Gender, or Ethnicity.
7 ODS Census Day Total Primary Enrollments Count of students with Primary Enrollments on Census Day currently in the system, excluding N470 (NoShowOther) exit codes.
8 Total Cumulative Enrollment (Unduplicated) Unduplicated count of SSIDs with an open enrollment during the academic year with status 10 (Primary), 20 (Secondary), or 30 (Short-term).

Note 1: Counts are unduplicated at each aggregate level and may not equal the sum of cumulative enrollment counts by status.

Note 2: Total may vary by filter selected:
• Cumulative Enrollment (default): Includes enrollments with start/end dates in academic year and prior-year enrollments with no end date.
• Adjusted Cumulative Enrollment: Includes only enrollments with start dates in the academic year.
9 Primary (10) Enrollment Status Cumulative Enrollment Total Unduplicated count of SSIDs with open enrollment during the academic year with status 10 (Primary).
10 Secondary (20) Enrollment Status Cumulative Enrollment Total Unduplicated count of SSIDs with open enrollment during the academic year with status 20 (Secondary).
11 Short-Term (30) Enrollment Status Cumulative Enrollment Total Unduplicated count of SSIDs with open enrollment during the academic year with status 30 (Short-Term).

Additional Resources

CALPADS File SpecificationsForm

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

CALPADS Data Guide

Chapter 2.1.6 provides additional information on Cumulative Enrollment and Student Absence.

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.