Report 1.8: Dropouts by Subgroup – Student List
(Updated as of 11/1/2023)
Description: Reports the list of students submitted by the LEA for the Dropout Count in report 1.24 by subgroup. The dropout student list is based on students who exited during the prior academic year.
Note: The count of student program records are based on the dropout date range (8/16 – 8/15) regardless of whether the record is owned by the school being reported.
Report Type: Certification (Fall 1)
Security Roles: LEA - Level Fall 1 Reports Role
Data As Of:
- Fall 1 Census Day (First Wednesday in October)
Basic selection criteria:
-
SENR –
- Enrollment Status = Primary (10)
- Grade Level = 7 – 12
- Enrollment Exit Date falls within Dropout Reporting Cycle (8/16 – 8/15)
- Exit Reason Codes = E140, E300, E400, T380 or E230 with Completion Status = 360
- AND No subsequent enrollment, in the same LEA, with Start Date on or before Census Day of the current academic year.
-
SPRG & SPED – data reported or used for selecting student subgroups (e.g. Socio-economically Disadvantaged) and Students with Disabilities are selected from qualifying records overlapping the Dropout Reporting Cycle, regardless of whether the record is owned by the LEA being reported.
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
- School Type
- School
- Grade
- Gender
- Ethnicity/Race
- English Learner
- Title I Part C Migrant
- Socio-economically Disadvantaged
- NOTE: Free Meal program and Reduced Price Meal program criteria for SED includes Program Membership Start Dates from 7/1 – 10/31 of current academic year - Students with Disabilities
- Homeless Program Eligible
Report Logic
| Column | Rules |
|---|---|
| 1 | School code is derived from user ID permission and Expected Schools table. This field can be expanded to show by Enrollment Status and Grade categories. |
| 2 | School Name is determined by #1 and the Expected Schools Table |
| 3 | SENR 1.08 SSID |
| 4 | SENR 1.12 Student Legal Last Name, SENR 1.10 Student Legal First Name, SENR 1.11 Student Legal Middle Name |
| 5 | SENR 1.09 Local Student ID |
| 6 | SINF 2.19 Student Gender Code |
| 7 | Ethnicity/Race - identified using SINF fields 2.24 (Student Hispanic Ethnicity Indicator), SINF 2.25 (Student Ethnicity Missing Indicator), SINF 2.26-2.30 (Student Race 1-5 Code), and SINF 2.31 (Student Race Missing Indicator) and the following rules: |
| 1) If the Student Hispanic Ethnicity Indicator (Field 2.24) = Y, always roll up to Hispanic, even if one or more races are selected or the Student Race Missing Indicator (Field 2.31) = Y | |
| 2) If Student Hispanic Ethnicity Missing Indicator (Field 2.24) = N or null and the Student Ethnicity Missing Indicator (Field 2.25) = Y or null and Student Race 1 - 5 Codes (Fields 2.26 - 2.30) is indicated, then roll up per rules outlined in 5 below. | |
| 3) If the Student Hispanic Ethnicity Indicator (Field 2.24) = N and the Student Race Missing Indicator (Field 2.31) = Y, then roll up to "Missing". | |
| 4) If the Student Hispanic Ethnicity Indicator (Field 2.24) = N or null, and the Student Race Missing Indicator (Field 2.31) = Y, then roll up to "Missing." | |
| 5) If the Student Hispanic Ethnicity Indicator (Field 2.24) = N or null, and the Student Race Missing Indicator (Field 2.31) = N or null, and Student Race 1-5 Codes (Field 2.26 - 2.30) is indicated, then roll up as follows: | |
| • If a single race = American Indian or Alaska Native (100), roll up to American Indian or Alaska Native | |
| • If there is one or more of any of the Asian subgroups: ((201) Chinese, (202) Japanese, (203) Korean, (204) Vietnamese, (205) Asian Indian, (206) Laotian, (207) Cambodian, (208) Hmong, (299) Other Asian, and no other race category (100, 301, 302, 303, 304, 399, 400, 600, 700, 302, 303, 304, 399, 400, 600, 700) then roll up to Asian | |
| • If a single race = Filipino (400) roll up to Filipino(400) | |
| • If race includes Filipino (400) AND one or more of any of the Asian subgroups, [(201) Chinese, (202) Japanese, (203) Korean, (204) Vietnamese, (205) Asian Indian, (206) Laotian, (207) Cambodian, (208) Hmong, (299) Other Asian) and no other race category roll up to Filipino(400) | |
| • If there is one or more of any of the Native Hawaiian/Pacific Islander subgroups ((301) Hawaiian, (302) Guamanian, (303) Samoan, (304) Tahitian, (399) Other Pacific Islander) and no other race category (100, 201, 202, 203, 204, 205, 206, 207, 208, 299, 400, 600, 700) then roll up to Hawaiian/Pacific Islander. | |
| • If a single race = (600) Black or African American, roll up to Black or African American | |
| • If a single race = (700) White, roll up to White | |
| • If more than one of the following races: American Indian or Alaska Native, Asian, Black or African American, Native Hawaiian/Pacific Islander, White, roll up to "Multiple" | |
| 8 | SPRG Field 3.13 - Ed Program Code equal to 191 (Homeless) |
| 9 | SPRG Field 3.13 - Ed Program Code equal to 135 (Migrant) |
| 10 | SPED Field 14.24 - Ed Plan Type equal to 100 (IEP), 150 (IFSP) or 200 (ISP) – overlapping qualifying enrollment |
| 11 | 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 |
| 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 is on or after 7/1 of reporting year and on or before 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 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 is on or before to November results – OR | |
| Student enrolled at a Juvenile Court School on Fall 1 Census Day | |
| 13 | SENR 1.26 Student Exit Reason Code |
| 14 | SENR 1.27 Student School Completion Status |
Additional Resources:
CALPADS File SpecificationsForm
Look for Student Enrollment (SENR), Student Information (SINF), Student English Language Acquisition (SELA), Student Program (SPRG) tabs for the fields indicated in the report logic.