Report 3.19 Career Technical Education Completers – Count by Pathway

(Updated as of 05/10/2021)

Description: Reports the total number of CTE Completers by Pathway at the school level, by gender. School level data is also aggregated at the LEA level. In addition, the number of Completers within each Core Indicator group are counted.

Report Type: ODS and Snapshot / (EOY 1)

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

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.
  • A student who has different CTE Course Enrollments at the same school during the Reporting Period should be counted for each CTE Course Enrollment.

  • At the school level, a student who has different CTE Course Enrollments for two different schools within the same LEA (no overlapping enrollment) during the Reporting Period should be counted for each CTE Course Enrollment (count in both schools).

  • At the school level, a student who has the same CTE Pathway for two different schools within the same LEA (no overlapping enrollment) during the Reporting Period should be counted only once in the most recently enrolled school.

  • The total for selected schools (LEA level) should represent an unduplicated count of students across the LEA identified as CTE Completers.
  • For counting within a Core Indicator, unduplicate at the School level, EXCEPT for Nontraditional Course Enrollment.

  • 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. Do not unduplicate at the school or LEA.

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.

Report Logic:


EOY 1 Report 3.19 Column 13-22


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 CTE Industry Sector Code based on Pathway from SCTE Field 11.13 CTE Pathway Code. See CALPADS Valid Code Combinations
4 SCTE Field 11.13 – CTE Pathway Code
5 CRSC Field 9.07 – State Course Code
6 SINF Field 2.19 – Gender
7 CRSC Field 9.32 – AP/IB Course Code Cross Reference
8 CRSE Field 9.36 – High Quality CTE Course Indicator = Y
9 CRSC Field 9.12 – Postsecondary Articulated Course Indicator = Y
10 CRSC Field 9.19 Course Instructional Level = 23-College Credit Only
11 CRSC Field 9.19 Course Instructional Level = 24-Dual Credit
12 Unduplicated count of CTE Completers by CTE Pathway

EOY 1 Report 3.19 Column 13-22


Column Rules
13 Unduplicated count of 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)
14 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
15 CRSC Filed 9.07 CRS State Course Code = 7000-8999 AND SINF 2.19 Student Gender Code = count of CTE Non-Traditional Gender for State Group Course Code in Valid Code Combinations document.
CTE Non-Traditional Gender is not NULL in CALPADS Valid Code Combinations document
16 Nontraditional Course Enrollment # / Total CTE Participants * 100 where Nontraditional Course Enrollment # is not “N/A
17 Unduplicated count of students with SPRG Field 3.13 Education Program Code = 162
18 Unduplicated count of students with SELA Field 12.13 English Language Acquisition Status Code = EL.
19 Unduplicated count of students in Foster Youth
20 Unduplicated count of students with SPRG Field 3.13 Education Program Code = 193
21 Unduplicated count of students with SPRG Field 3.13 Education Program Code = 191
22 Unduplicated count of students with SPRG Field 3.13 Education Program Code = 192

User Roles for Access

EOY 1 Reports

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.