CA Report 1.1: Enrollment - Primary Status by Subgroup

(Updated as of 10/20/2021)

Description: Reports the primary and short-term enrollment counts for specific student subgroups at the LEA level for a selected county.

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 who 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.
  • 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

  • Note: The report includes all of these grade levels; however, it defaults to a view that does not show PS initially since PS does not have to be certified.

  • There must be a SINF record that wholly or in part overlaps a qualified enrollment

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

Report Logic


C/A Report 1.1

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 SENR Field 1.23 – Enrollment Status equals (10) Primary and (30) Short-term and SENR Field 1.25 - Grade Level equal to KN -12 (Snapshot default - see note above regarding PS)
6 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
7 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
8 SENR Field 1.23 – Enrollment Status equals (10) Primary and 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
9 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
10 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
11 SPED Field 14.24 - Ed Plan Type equal to 100 (IEP), 150 (IFSP) or 200 (ISP) – overlapping qualifying enrollment
12 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 equal to or greater than 7/1/ of reporting year and equal to or less than 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), or 191 (Homeless) and SPRG 3.15 – Ed Program Membership Start Date equal to or greater than Fall 1 Census Day and SPRG 3.16 – Ed Program Membership End date blank or equal to or greater than Fall 1 Census Day – OR
Foster Youth Indicator equal to Y AND Episode Start date less than or equal to Fall 1 Census Day and Episode End Date is blank or greater than or equal to Fall 1 Census Day – OR
Direct Certification Indicator equal to Y AND Direct Certification Date less than or equal to January 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