Report 3.15 Career Technical Education Noncompleter Participants – Student List
(Updated 04/15/2024)
Description: Lists Career Technical Education (CTE) Noncompleter Participants and provides core indicators on these students.
Report Type: Snapshot / (EOY 1)
Security Roles: EOY 1 Reports
Data As Of:
- If ODS version, user defined
- If Snapshot version, July 1 – June 30.
Basic selection criteria:
- Enrollment within the LEA at any time during the Report Period qualifies for selection.
- Enrollment Status Code = 10, 20, or 30
- Grade Level = 07-12
- Student Course Section Completion (SCSC) must map to a state course code that is a CTE course (CRSC Field 9.07 = 7000-8999) for the student to be counted as a participant.
- Only students who are CTE Participants but not CTE Completers (i.e. those who do NOT have an associated SCTE record), should be included in this report.
Student Data Rules: - Data presented are the most recent data associated with the most recent qualifying enrollment at the school during the Report Period, with the following exceptions:
- A student who has multiple CTE Course Enrollments at the same school during the Reporting Period should be counted for each CTE Course Enrollment and display one row for each CTE Course completed.
- A student who has multiple CTE Course Enrollments at different schools for the same LEA during the Reporting Period should be counted for each CTE Course Enrollment and display one row for each CTE Course completed.
- Student Program (SPRG) data are selected, for each unique Education Program Code, from the most recent SPRG record for the school and SSID that contains that unique Education Program Code (if exists) and with Education Program Membership Start Date and Education Program Membership End Dates (if exists) that overlap a qualifying enrollment at the school during the Report Period, regardless of Education Program Membership Code.
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
- Enrollment Status
- Perkins/CTEIG Fundable
- English Learner
- Socio-Economically Disadvantaged
- Students with Disabilities (IDEA)
- Foster Youth
- Education Program
- Nontraditional Course Enrollment
- CTE Industry Sector
- CTE Pathway**
NOTE: Default = Y value indicates that the course is CTE related, the teacher has an appropriate CTE credential, AND that the student reported has a valid SCTE record and a related course completion record
REMINDER: CTE completers do not need the High Quality CTE Course Indicator equal to Y in the course record to appear on the CA Dashboard. All CTE courses will be accounted for in the dashboard. Flagging a course with High Quality CTE Course Indicator equal to Y is only needed if the LEA is receiving Perkins funding, which requires CTE courses are taught by CTE credentialed teachers.
**Note: For AY 23-24+, it includes students with an overlapping Eligible and Participating SWD record.
Report Logic:
Click image to expand
| Column | Rules |
|---|---|
| 1 | School code is 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 Field 2.10 Student Local ID |
| 6 | SINF Field 2.19 Gender |
| 7 | SENR Field 1.25 Grade Level Code = 7-12 |
| 8 | 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.25 = 100 (Am Ind/Alaska Nat) | |
| OR 2.23 = N and 2.30 = N and 2.25 = 201 - 208, 299, 400 (Asian) | |
| OR 2.23 = N and 2.30 = N and 2.25 = 600 (Black/African Am) | |
| OR 2.23 = N and 2.30 = N and 2.25 = 301, 303, 304, 399 (Nat Hawaii/Pac Isl) | |
| OR 2.23 = N and 2.30 = N and 2.25 = 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) | |
| 9 | 9. Use CRS‐State Course Code Field 9.07 to look‐up value in Course Group Master Combos document, Valid Code Combo sheet/tab, to derive corresponding CTE Industry Sector code and name. See the Course Group Master Combos tab of the CALPADS Valid Code Combinationsdocument |
| 10 | CRSC Field 9.07 CRS - State Course Code = 7000-8999. |
| 11 | CRSC Field 9.32 AP/IB Course Code Cross Reference. |
| 12 | CRSE Field 9.36 High Quality CTE Course Indicator. |
| 13 | CRSC Field 9.12 Postsecondary Articulated Course Indicator |
| 14 | Overlapping 504 Accommodation Plan (SPRG Field 3.13 Education Program Code = Code 101) or overlapping active SPED record in ODS with Education Plan Type (Field 14.24) = 100 (IEP/IFP), 150 (IFSP), or 200 (ISP) |
| 15 | 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 | |
| Option 8: SPRG Field 3.13 = 193 | |
| 16 | CRSC Field 9.07 CRS State Course Code = 7000-8999 AND CTE Non-Traditional Gender is not Null in CALPADS Valid Code Combinations document. |
| 17 | SPRG Field 3.13 Education Program Code = 162. |
| 18 | SELA Field 12.13 English Language Acquisition Status Code = EL. |
| 19 | Student is Foster Youth Eligible indicator |
| 20 | SPRG Field 3.13 Education Program Code = 193 |
| 21 | SPRG Field 3.13 Education Program Code = 191 |
| 22 | SPRG Field 3.13 Education Program Code = 192 |
Additional Resources
CALPADS File SpecificationsForm
Look for Course Completion (CRSC), Student Course Completion (SCSC), Student Career Technical Education (SCTE), Student Enrollment (SENR) and Student Information (SINF) tabs for the fields indicated in the report logic.
CALPADS Data Guide
Chapter 2.3 provides additional information on Course Completion data.
CALPADS Code Sets
This document contains the current code values referenced in the file specifications for the coded value data elements. The different course-related code definitions are listed in this document.
CALPADS Valid Code Combinations
This document lists codes that can only be used in specific combinations in CALPADS.