CA Report 1.1: Enrollment - Primary Status by Subgroup
(Updated as of 10/27/2023)
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:
- LEA Authorizer: Authorizing LEA
- County Office of Ed: County
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 TK - 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
- Age Eligibility Filter
- For academic year 21-22 and prior: filter will show no dropdown options (N/A).
- For academic year 22-23+:
- 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
Click image to expand
| 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 TK -12 (Snapshot default - see note above regarding PS) |
| 6 | 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 |
| 7 | 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 |
| 8 | 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 |
| 9 | 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 |
| 10 | SPED Field 14.24 - Ed Plan Type equal to 100 (IEP), 150 (IFSP) or 200 (ISP) – overlapping qualifying enrollment |
| 11 | 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 | |
| 12 | FRPM Eligible - Count of unduplicated students that meet the criteria for Economically Disadvantaged |
Glossary References
Gifted and Talented Education Program (GATE) Subgroup,
Socio-economically Disadvantaged Subgroup,