Report 1.1: Enrollment - Primary and Short-term Enrollment Count by Subgroup

(Updated as of 10/6/2021)

Description: Reports the primary and short-term enrollment counts for specific student subgroups at the school level. This report provides the California Department of Finance with enrollment counts used for budget projections and the federal government with counts of student subgroups for purposes of Title I funding. The data included in this report is publicly accessible from Dataquest and Ed-Data

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

Security Roles: Fall 1 Reports Role

Data As Of:

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

Basic selection criteria:

  • Students Included: Students with an open enrollment on the “Data As Of” date, where the Enrollment Status equals 10 (Primary) or 30 (Short-term) and is in Grade Levels KN – 12.

    • 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.
  • Note - Snapshot: Must have a SINF record that wholly or in part overlaps a qualified enrollment. Default Grade Level does not include PS since PS does not have to be certified.

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
  • Gender
  • Enrollment Status
  • Ethnicity/Race
  • Student School Transfer Code
  • Adult Age Students with Disabilities in Transition Status


Report Logic

Report 1.1


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.2 Enrollment – Primary Status Student List
3 Count of all unique SSIDs with SENR Field 1.23 – Enrollment Status of (10) Primary and (30) Short-term and SENR Field 1.25 - Grade Level equal to KN -12 (Snapshot default - see note above regarding PS).
4 SPRG Field 3.13 - Ed Program Code equal to 185 (Transitional KN) and SPRG Field 3.15 - Program Membership Start Date is on or after 7/1/of reporting year and equal to or before Fall 1 Census Day and SPRG Field 3.16 - Program Membership End Date is blank or is on or after Fall 1 Census Day
5 SELA Field 12.13 - English Language Acquisition Status Code equal to EL (English Learner) status effective during the report period (using effective date) regardless of Reporting LEA
6 SENR Field 1.25 - Grade Level Code equal to KN -12, and SINF Field 2.18 - Student Birth Date equal to (determines age to be 3-21) and SINF Field 2.22 – Student Birth Country not equal to US (United States) or PR (Puerto Rico) and SINF Field 2.46 - Enrolled in US School less than 3 Cumulative Years equal to Y
Title III Eligible Immigrants column leads to Report 2.2 Title III Eligible Immigrants by Birth Country
7 SPRG Field 3.13 - Ed Program Code equal to 127 (Gifted and Talented) and SPRG Field 3.15 - Program Membership Start Date is on or before Fall 1 Census Day and SPRG Field 3.16 Program Membership End Date is blank or is on or after Fall 1 Census Day
8 SPRG Field 3.13 - Ed Program Code equal to 135 (Migrant) and SPRG Field 3.15 - Program Membership Start Date is on or before Fall 1 Census Day and SPRG Field 3.16 - Program Membership End Date equal to blank or is after Fall 1 Census Day
9 SPED Field 14.24 - Ed Plan Type equal to 100 (IEP), 150 (IFSP) or 200 (ISP) – overlapping qualifying enrollment
10 SINF Field 2.50 – Parent Guardian Highest Grade Level Code equal to 14 (Not a High School Graduate) - OR
SPRG Field 3.13 - Ed Program Code equal to 181 (Free NSLP) or 182 (Reduced NSLP) and SPRG 3.15 – Ed Program Membership Start Date is on or after 7/1/ of reporting year and is on or before 10/31 of the reporting year and SPRG 3.16 – Ed Program Membership End date blank or equal to or greater than 10/31 of the Reporting Year – OR
SPRG Field 3.13 - Ed Program Code = 135 (Migrant), 191 (Homeless) or 193 (Tribal Foster Youth) and SPRG 3.15 – Ed Program Membership Start Date is on or before Fall 1 Census Day and SPRG 3.16 – Ed Program Membership End date blank or is on or after Fall 1 Census Day – OR
Foster Youth Indicator equal to Y AND Episode Start date is on or before to Fall 1 Census Day and Episode End Date is blank or is on or after Fall 1 Census Day – OR
Direct Certification Indicator equal to Y AND Direct Certification Date less than or equal to November results – OR
Student enrolled at a Juvenile Court School on Fall 1 Census Day

Glossary References:

Accountability Subgroup Data,

English Learner Subgroup,

Gifted and Talented Education Program (GATE) Subgroup,

Socio-economically Disadvantaged Subgroup,

Special Education Subgroup,

Title 1 Part C Migrant Subgroup,

Title III Eligible Immigrant Subgroup