Report 3.20 Career Technical Education Completers – Student List
(Updated 04/15/2024)
Description: Lists Career Technical Education (CTE) Completers and the Pathway they are pursuing. Also provides code 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 at a school any time during the Report Period
- Enrollment Status Code = 10, 20, or 30
- Grade Level = 07-12
- Course Completion record (CRSC Field 9.07) must map to a state course code within the pathway code reported from SCTE file (SCTE Field 11.13)
- SCTE Pathway Code (Field 11.13) and SCTE Pathway Completion Academic Year ID (Field 11.14) are used to determine Industry Sector. Using Valid Code Combos – Pathway-Industry Sector tab
- Only students who have completed a CTE Course and who have an associated SCTE record should be included in this report.
Student Data Rules:
- A student may have more than one CTE Pathway Code for the Reporting Year. All SCTEs are examined to determine the number of unique CTE Pathway Codes for each student. For each unique CTE Pathway Code value where the Enrollment Period overlaps the Reporting Year of the SCTE containing the CTE Pathway Code (Field 11.13), count the student in that Pathway. Specific/Exception rules:
- A student who has different CTE Pathways (SCSC & SCTE) at the same school during the Reporting Period should be counted for each CTE Pathway.
-
A student who has the same CTE Pathway (SCSC & SCTE) at the same school during the Reporting Period should only be counted once for that CTE Pathway.
-
At the school level, a student who has the same or different CTE Pathways for two different schools within the same LEA (both schools hold a SCSC & SCTE) during the Reporting Period should be counted for each CTE Pathway (count in both schools).
-
At the school level, a student who has an SCSC at one school and SCTE at another school during the Reporting Period (within the same Reporting LEA and for the same SCTE Pathway), the student should only count once at the school where the student is primarily enrolled.
- In the case where the student has two primary enrollments during the Reporting Period, and one school holds the SCSC and the other school holds the SCTE, the school where the student took the Capstone course (SCSC/CRSC) should receive the Completer count
-
Only one record per State Course Code per SSID should populate. If the student is counted in multiple pathways (in 3.19 report) as listed in the previous section, each of those records should show up on this report.
- For counting within a Core Indicator, unduplicate at the State Course Code and School level.
- For Nontraditional Course Enrollment only, count students where student gender = gender specified in CTE Non-Traditional Gender for State Group Course Code in each course for which a nontraditional gender has been established.
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
- CTE Industry Sector
- Students with Disabilities (IDEA)
- Socio-economically Disadvantaged
- Nontraditional Course Enrollment
- English Learners
- Foster Youth
- Education Program
NOTE: Default = Y ‘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.29 Race Ethnicity determined per criteria: |
| 2.23 = Y (Hispanic) | |
| OR 2.23 = N and 2.29 = N and 2.25 = 100 (Am Ind/Alaska Nat) | |
| OR 2.23 = N and 2.29 = N and 2.25 = 201 - 208, 299, 400 (Asian) | |
| OR 2.23 = N and 2.29 = N and 2.25 = 600 (Black/African Am) | |
| OR 2.23 = N and 2.29 = N and 2.25 = 301, 303, 304, 399 (Nat Hawaii/Pac Isl) | |
| OR 2.23 = N and 2.29 = N and 2.25 = 700 (White) | |
| OR 2.23 = N and 2.29 = 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 Combinations | |
| 10 | SCTE Field 11.13 – CTE Pathway Code |
| 11 | CRSC Field 9.07 CRS - State Course Code = 7000-8999 |
| 12 | CRSC Field 9.32 AP/IB Course Code Cross Reference. |
| 13 | CRSE Field 9.36 High Quality CTE Course Indicator. |
| 14 | CRSC Field 9.12 Postsecondary Articulated Course Indicator |
| 15 | 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) |
| 16 | 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 | |
| 17 | CRSC Field 9.07 CRS State Course Code = 7000-8999 AND CTE Non-Traditional Gender is not Null in Valid Code Combinations document. |
| 18 | SPRG Field 3.13 Education Program Code = 162. |
| 19 | SELA Field 12.13 English Language Acquisition Status Code = EL. |
| 20 | Student is Foster Youth Eligible indicator |
| 21 | SPRG Field 3.13 Education Program Code = 193 |
| 22 | SPRG Field 3.13 Education Program Code = 191 |
| 23 | SPRG Field 3.13 Education Program Code = 192 |
Additional Resources
CALPADS File Specifications
Look for Course Completion (CRSC), Student Course Completion (SCSC), Student Career Technical Education (SCTE) and Student Information (SINF) tabs for the fields indicated in the report logic.
CALPADS Data Guide
Chapter 3.2.1 provides additional information on CTE 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 course codes with its corresponding pathway designation that can only be used in specific combinations in CALPADS.