Report 1.23 Graduates and Completers Student List
(Updated 04/15/2024)
Description: Reports the list of students submitted by the LEA as Regular High School Diploma Graduates, CHSPE Completers, Adult Education High School Diplomas, Special Education Certificate of Completion, General Education Completers for the selected Academic Year.
Data As Of:
- Snapshot version, any time in the reported academic year (7/1 – 6/30)
Security Roles: EOY 3 Reports Role
Basic selection criteria:
- Enrollment Status = 10 (Primary) or 30 (Short-Term Enrollment)
- Grade Levels = 07 – 12
-
Enrollment Exit Date (SENR 1.26) falls within the Completer Enrollment Reporting Cycle for the Reporting Year
- Completer Enrollment Reporting Cycle: August 16 of the Academic Year selected (i.e. Reporting Year) to August 15 of the following selected Academic Year (i.e. year following Reporting Year). Example for 2023-24 Academic Year: 8/16/2023 – 8/15/2024
-
Student Exit Reason Code (SENR 1.27) = E230-CompleterExit AND Completion Status Code (SENR 1.28) is any of the following:
- 100-HS Diploma
- 330-Passed CHSPE
- 250-Adult Ed. High School Diploma
- 320-Completed GED and No Standard HS Diploma
- 120-Special Ed. Certification of Completion and No Standard HS Diploma.
-
Note: Students are considered Graduate and Completer even with a subsequent enrollment.
-
Student Program (SPRG) data (e.g., Socio-economically Disadvantaged) are selected from an Education Program Record with Education Program Membership Start Date and End Date (if exists) effective on any date during the Completer Enrollment Reporting Cycle, regardless of whether the record is owned by the school being reported and regardless of Education Program Membership Code
-
Special Education (SPED) data reported or used for selecting Students with Disabilities subgroup are selected from qualifying Active Plan SPED Records overlapping the Completer Enrollment Reporting Cycle on any date, regardless of whether the record is owned by the LEA being reported
-
Student Information (SINF) and Student English Language Acquisition (SELA data used for selecting student subgroups (e.g. Race/Ethnicity, EL, etc.) are selected from the most recent record that overlaps the qualifying enrollment.
Report Filters: Filters can be selected resulting in only totals for the selected filter being displayed
- Academic Year
- LEA
- Status
- School Type
- School
- Grade
- Gender
- Enrollment Status
- Ethnicity/Race
- Students with Disabilities
- Socio-economically Disadvantaged
- English Language Acquisition Status
- Foster Youth
- Education Program
- Seal of Biliteracy
- Golden State Seal of Merit Diploma
- UC/CSU Requirements Met
- Adult Age Students with Disabilities Transition Status
This is a nested report, meaning the first section selects all non-charter schools by LEA. The second section selects all charter schools by LEA (including IRCs). If no schools are expected for a section of the report, the Heading and the Total Selected LEAs row is displayed with zeros for all counts.
Report Logic:
Click image to expand
| Column | Rules |
|---|---|
| 1 | School code - derived from user ID permission and Expected Schools table |
| 2 | School Name is determined by #1 and the Expected Schools Table. |
| 3 | SENR Field 1.08 – SSID |
| 4 | SINF Fields 2.11 - 2.13 for Student Legal Name |
| 5 | SINF Fields 2.10 – Local Student ID |
| 6 | SINF Field 2.19 – Student Gender Code |
| 7 | SINF Fields 2.23-2.30 Race Ethnicity determined per criteria: |
| 2.23 = Y (Hispanic) | |
| OR 2.23 = N and 2.30 = N and 2.26 = 100 (Am Ind/Alaska Nat) | |
| OR 2.23 = N and 2.30 = N and 2.26 = 201 - 208, 299, 400 (Asian) | |
| OR 2.23 = N and 2.30 = N and 2.26 = 600 (Black/African Am) | |
| OR 2.23 = N and 2.30 = N and 2.26 = 301, 303, 304, 399 (Nat Hawaii/Pac Isl) | |
| OR 2.23 = N and 2.30 = N and 2.26 = 700 (White) | |
| OR 2.23 = N and 2.30 = N and multi race categories in the most recent SINF (Multi) | |
| OR 2.24 = Y – OR - 2.23 = N and 2.30 = Y (Missing) | |
| 8 | SINF Field 2.18 – Student Birth Date |
| 9 | SPRG Field 3.13 – Education Program Code = 135 (Title I Part C Migrant) |
| 10 | Students with Disabilities (SWD) – Beginning in 2023-2024 AY: |
| Source: SWDS Record effective on or during the report period has Special Education Status = 1 (Eligible and Participating) (See Record Effective On) | |
| Beginning in 2019-20: | |
| Identify SSID using: SPED | |
| (Education Plan Type (Field 14.24) = 100 (IEP/IFP), 150 (IFSP), or 200 (ISP), | |
| AND | |
| (Plan Set Start Date <= Reporting Period Through (End) Date and either ((Plan Set has no End date) or (Plan Set Exit Date >= Reporting Period From (Start) Date))) | |
| Note- For reports, see also Records Selection Business for further restrictions. | |
| Note - Beginning 2020-2021 reports, Triennial Records Meeting Type = 40 (Triennial) are no longer brought into the reporting Database and no longer used to determine active SPED students. | |
| Prior to 2019-20 through 2022-2023: | |
| Identify SSID using: Student Program | |
| Education Program Code (Field 3.13) = 144 (Special Education) | |
| AND | |
| Education Program Membership Code (Field 3.14) = 1 or 3 (Eligibleor Participating) | |
| When used as an NCLB Subgroup, Enrollment Status Code (Field 1.24) must = 10 (Primary) | |
| 11 | Option 1: Parent/Guardian Highest Education Level Code (SINF Field 2.50 = 14-Not HS Graduate) from most recent SINF record |
| Option 2: SPRG Field 3.13 = 181 or 182 | |
| Option 3: SPRG Field 3.13 = 135 | |
| Option 4: SPRG Field 3.13 = 191 | |
| Option 5: Foster Program Eligible | |
| Option 6: Direct Certification = Y | |
| Option 7: Students enrolled in a Juvenile Court School | |
| 12 | SELA Field 12.13 English Language Acquisition Status Code |
| 13 | Student is Foster Youth Eligible indicator |
| 14 | SPRG Field 3.13 Education Program Code = 193 |
| 15 | SPRG Field 3.13 Education Program Code = 191 |
| 16 | SENR Field 1.32 Student Golden State Seal Merit Diploma Indicator |
| 17 | SENR Field 1.33 Student Seal of Biliteracy Indicator |
| 18 | SENR Field 1.29 Student Met all UC CSU Requirements Indicator |
| 19 | SENR Field 1.35 Graduate with Local Exemptions Indicator |
| 20 | SENR Field 1.34 Adult Age Students with Disabilities in Transition Status |
| 21 | SENR Field 1.23 Enrollment Status Code |
| 22 | SENR Field 1.22 Enrollment Start Date |
| 23 | SENR Field 1.25 Enrollment Exit Date |
| 24 | SENR Field 1.26 Student Exit Reason Code |
| 25 | SENR Field 1.27 Student School Completion Status |
Additional Resources
CALPADS File SpecificationsForm
Look for Student Enrollment (SENR) tab for the fields indicated in the report logic.
CALPADS Data Guide
Chapter 5.1 Appendix C provides additional information on Student Exit Reason code and Student School Completion status descriptions.
CALPADS Code Sets
This document contains the current code values referenced in the file specifications for the coded value data elements. The exit and completion code definitions are listed in this document.