Report 1.12: Dropouts – Count Disaggregated

(Updated 9/12/2024)

Description: Reports the number of students the LEA submitted as dropouts (Other Dropouts and No Show Same School Dropouts) by Ethnicity/Race within Grade and Gender.

Report Type: Certification (Fall 1)

Security Roles: Fall 1 Reports Role

Data As Of:

  • Fall 1 Census Day (First Wednesday in October)

Basic selection criteria:

  • SENR – - Enrollment Exit Date within the Graduate/Dropout Reporting Cycle: August 16th of the prior academic year to August 15th of the current academic year - Exit Codes = E140, E300, E400 or T380 OR Completer Code = 360 - Grade Level = 7 – 12
    - Enrollment Status = Primary (10)

  • SINF – record that wholly or in part overlaps a qualified enrollment.

  • SPRG – based on dropout date range regardless of whether the record is owned by the school 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 Language Acquisition Status
  • Title III Eligible Immigrant
  • 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
  • Gifted and Talented Education
  • Dropout Type
  • Exit Reason
  • Group By

Report Logic


Report 1.12: Dropouts Count Disaggregated

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. School Name column leads to Report: 8.1 Student Profile List
3 Grade Level Code – this field can be expanded to show by Grade within Ethnicity and Race categories
4 Student Gender Code – this field can be expanded to show by Gender within Ethnicity and Race categories
5 Total Number calculation – Count of Dropouts (No Show Same School and Others)
6, 8, 10, 12, 14 ,16, 18 Number (#) – Count of Dropouts in each race category
7, 9, 11, 13 ,15, 17 Percentage (%) – Percentage of Dropouts in each race category
19 Number (#): Sum of Completers with more than one race category
20 Number (#) – Count of Dropouts with multiple race categories
21 Percentage (%) – Percentage of Dropouts with multiple race categories
22 Number (#) – Count of Dropouts with race code missing indicator selected
23 Percentage (%) – Percentage of Dropouts with race code missing indicator selected

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.

Glossary References

Ethnicity/ Race
Dropouts-Count Dropouts–LEA View Data