CTE Coding Summary

Report Location: Student>Student Custom Reports>CTE

Summary: This report lists students who have either a current or prior year CTE course(s) in the summer submission and displays current and prior year CTE data.

Usage: Verify CTE students’ endorsement coding along with CTE courses currently enrolled in and/or previously completed. Can also be used to predict the CTE and Program of Study codes given out by TEA after the first Summer submission.

Special Notes:

Please see Auto Calculation of CTE and Program of Study Codes for further information on auto calculating the CTE and Program of Study codes starting with the 2020-2021 school year.
If current year PEIMS course completion records have not been loaded, only the prior year CTE course columns will display.
Current year and prior year CTE course columns include CTE courses reported in the PEIMS Extended Year submission
CTE Course Service IDs displayed include all CTE courses taken at both high school and middle school
New starting 2020-2021, calculation of Program of Study and CTE Codes
- Note: Since this report only includes students with at least one CTE course in either current or prior years, it can only calculate code 4-Not CTE for students in this report. Any student not on this report is automatically considered code 4-Not CTE since they do not have a CTE course at all.
ADA Eligibility 0 students will appear on the report if they have prior year CTE courses and a CTE code was calculated for them based on this information.
Internal staff only: PDPCI.cte_courses_sql, PDPCI.program_of_study, PDPCI.program_of_study_e1643 tables must be set up for current year

Data Sources:

PEIMS Summer records
- Interchange Education Organization
  - 10010 – Local Education Agency Extension
- Interchange Student
  - 40100 – Student Extension
- Interchange Student Enrollment
  - 48011 – Student Graduation Program Extension
- Interchange Student Program
  - 40110 – Student Program Extension
- Interchange Student Transcript
  - 43415 – Course Transcript Extension
PEIMS Extended Year records
- Interchange Student Transcript
  - 43415 – Course Transcript Extension
PEIMS Fall records for demographic and special program codes if PEIMS Summer file does not exist
Class Roster Fall and Winter Collections for Current Year CTE Service IDs

Definitions:

Students Displayed
- If PEIMS summer has been loaded, students are pulled from summer
- If no PEIMS summer has been loaded, students are pulled from PEIMS fall snapshot
- Students must have either a current year or prior year CTE course in order to display
  - Note: students who only have CTE Transfer courses loaded will also display if they are found in the year selected (either fall or summer)
Grade and Campus
- If PEIMS summer file loaded, pulls last grade and all campuses associated with a 43415 record
- If no PEIMS summer file loaded, pulls snapshot grade and campus values reported in PEIMS fall
  - Note: students who only have CTE Transfer courses loaded will have the grade and campus pulled from the most recent 42400 record, or if no summer records, the 40110 record
Last Campus Attended
- Displays last campus attended to more easily locate where students are based on the last summer load
Endorsements (C199)
- STEM – E1544
- Business and Industry – E1545
- Public Services – E1546
- Arts and Humanities – E1547
- Multi-Disciplinary Studies – E1548
  - Note: If PEIMS summer file is not loaded for the year selected, Endorsements are pulled from the most recent PEIMS summer file loaded
Codes
- At Risk – E0919 (C088)
  - Note: Fall only element
- Emergent Bilingual – E0790 (C061)
- SPED – E0794 (C088)
- Eco Dis – E0785 (C054)
- Note: If PEIMS summer file is not loaded for the year selected, Special Program codes are pulled from the PEIMS fall file loaded

Starting with 2020-2021

Auto calculation of Program of Study and CTE Codes

Uses Summer and Extended Year Course Completion records (43415) for all years
Additionally will use CTE Transfer Courses if loaded to the file center (see element definition further down)
Note: If not loading CTE Transfer Courses, the calculation will not be accurate for students who have taken high school credited CTE courses at another LEA
Only considers Course Sequence Codes (E0948) = 0, 2, 5, 9, D0, D2, D5, D9

Program of Study

Only appears for CTE Codes 6 and/or 7 and can have multiple Program of Study codes
Updated 7/29/2024: Calculates all Programs of Study regardless of what is reported in the Fall PEIMS 10010-E1643 Program of Study element
Determined by comparing Summer and Extended year course completion Service IDs E0724 (and CTE Transfer courses if loaded) to the TEA CTE Autocalculation Source Data Excel file (POS Service ID Level Credit tab) which includes the Credit and Level elements used below in the CTE Code Logic
- PEIMS Calculations – Tech Tips
- Updated 7/7/2021: Now including Non-POS CTE Service IDs with credit in calculations

Includes both state and regional level program of study codes
If student has 2 or more Service IDs passing in the same Program of Study, the Program of Study code(s) will display

CTE Code

Can have both CTE Code 6 and 7
Calculated based on the following logic:
- Credit and Level can be found on the Program of Study file linked above

CTE Code	CTE Code Logic
7-Completer	Unique Sum of Service ID E0724 in summer and extended year (and CTE Transfer courses if loaded) >= 3 and Pass/Fail Credit E0949 = 01 or 08	AND	Sum of Credit >= 4	AND	Same Program of Study	AND	Service ID E0724 = Level 3 or Level 4 within same program of study
6-Concentrator	Unique Sum of Service ID E0724 in summer and extended year (and CTE Transfer courses if loaded) >= 2 and Pass/Fail Credit E0949 = 01 or 08	AND	Sum of Credit >= 2	AND	Same Program of Study	AND	Not CTE Code 7
5-Participant	Unique Sum of Service ID E0724 in summer and extended year (and CTE Transfer courses if loaded) = 1 OR Unique Sum of Service ID E0724 in summer and extended year (and CTE Transfer courses if loaded) > 1	AND	Sum of Credit < 2
E-Explorer	Unique Sum of Service ID E0724 in summer and extended year (and CTE Transfer courses if loaded) >=2	AND	Sum of Credit >= 2	AND	Not CTE Code 5,6,7
4-Not CTE	Not CTE Code 5,6,7,E

Resources for qualifications and calculations:

TWEDS C142
P E I M S C a l c u l a t i o n s – T e c h T i p s

CCMR EWS IBC or CCMR EWS IBC 2024 (for 2023-2024 school year)
- Value on the (CCMR) College, Career & Military Ready Early Warning System report
Continuously Enrolled
- Derived from CCMR EWS Reporting
  - Y indicates student has been continuously enrolled for at least the last 4 years
  - N indicates student has not been continuously enrolled and could have CTE courses not reported to PEIMS from your LEA impacting the calculation for the Program of Study and CTE Code

Current Year
- CY Class Roster CTE Courses Enrolled in – Service ID (E0724-C022) Code and Description of CTE courses in Class Roster Fall and/or Winter
  - Note: This can be used prior to the PEIMS summer reporting of course completion records. It is NOT used to pull the original list of CTE students which is based on current or prior year PEIMS CTE courses.
- CTE Courses Enrolled in – Service ID (E0724-C022) Code and Description
- # CTE Courses Enrolled in – Total number CTE courses listed
- # CTE Course Sequences where credit was received – Total number of CTE course parts for each sequence where Pass/Fail code = 01 or 08 (ex: 2 semester courses will display as 2 if student completes and passes both parts)
Prior Year
- CTE Courses Completed – Service ID (E0724-C022) Code and Description
- # CTE Courses Completed – Total number of CTE courses listed
- # CTE Course Sequences where credit was received – Total number of CTE course parts for each sequence where Pass/Fail code = 01 or 08 (ex: 2 semester courses will display as 2 if student completes and passes both parts)
Post Secondary Certs
- E1640 (C214) for any year/submission along with E1733 licensure results starting with 2022-2023
  - Note: Post Secondary Certs earned prior to 2023 will display “Prior to 2023”
CTE Transfer Courses
- Displays all years of CTE Transfer Course Service IDs E0724 and their descriptions based on the CSV file loaded to the File Center>District>CTE Transfer Courses tab
  - See Loading District – CTE Transfer Courses for more information on loading this information
  - These courses will also show under the Current Year and/or Prior Year columns matching to the year(s) found inside the CSV file and be included in the calculations for courses enrolled in/completed/credit received columns
  - Additionally, these courses will be used in the auto calculation of the Program of Study and CTE Code.

Features:

Filter on:
- Single select Year (Default most recent PEIMS summer)
  - Note: If no PEIMS summer file exists, selects students based on PEIMS fall
- Multi select Grade (Default All Grades)
  - Only includes grade levels 06-12
- Multi select Campus (Default All Campuses)
  - Only includes middle school and high school campuses
  - Student will display on all campuses associated with their 43415 course transcript records
- Multi select Program of Study (Default All Codes including No Program of Study)
  - Will only display the program(s) of study selected even if a student has multiple programs of study. For example, student has POS 001 and 023; if Program of Study 001 is the only selection, the POS 023 will not display for the student.
- Multi select CTE Code (Default All CTE Codes)
- TEA Comparison
  - Do Not Compare with TEA – (Default) Does not show TEA CTE and Program of Study columns
  - Compare with TEA – Displays current and prior year TEA CTE and Program of Study codes based on uploads in the File Center
    - See Loading TSDS – PEIMS CTE Student Roster for further information

Service IDs Used:

23-24 School Year

0358XXXX excluding 03580100, 03580120
A358XXXX
I358XXXX
1270XXXX, 130XXXXX, N127XXXX, N130XXXX

22-23 School Year

0358XXXX excluding 03580100, 03580120
A358XXXX
I358XXXX
1270XXXX, 130XXXXX, N126XXXX, N127XXXX, N130XXXX

21-22 School Year

0358XXXX excluding 03580100, 03580120
A358XXXX
I358XXXX
1270XXXX, 130XXXXX, N126XXXX, N127XXXX, N130XXXX

20-21 School Year

0358XXXX excluding 03580100, 03580110, 03580120, 03580130
A358XXXX
I358XXXX
1270XXXX, 130XXXXX, N126XXXX, N127XXXX, N130XXXX

19-20 School Year

0358XXXX excluding 03580100, 03580110, 03580120, 03580130
A358XXXX
I358XXXX
1270XXXX, 130XXXXX, N127XXXX, N130XXXX

18-19 School Year