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.
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
- Interchange Education Organization
- PEIMS Extended Year records
- Interchange Student Transcript
- 43415 – Course Transcript Extension
- Interchange Student Transcript
- 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
- At Risk – E0919 (C088)
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:
- CCMR EWS Met from 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
- Derived from CCMR EWS Reporting
- 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
- New columns added 3/10/2025 to look at the completed part of the course (Course Sequence E0948 = 0,2,5,9,D0,D2,D5,D9):
- Current Year CTE Courses Passed – Service IDs with pass/fail (E0949) = 01 or 08
- Current Year # CTE Courses Passed – Count of Current Year CTE Courses Passed
- Current Year CTE Courses Failed or Incomplete – Service IDs with pass/fail (E0949) not equal 01 or 08
- Current Year # CTE Courses Failed or Incomplete – Count of Current Year CTE Courses Failed or Incomplete
- CY Class Roster CTE Courses Enrolled in – Service ID (E0724-C022) Code and Description of CTE courses in Class Roster Fall and/or Winter
- Prior Years – New columns added 3/10/2025 to look at the completed part of the course (Course Sequence E0948 = 0,2,5,9,D0,D2,D5,D9) for all prior years:
- Prior Year CTE Courses Passed – Service IDs with pass/fail (E0949) = 01 or 08
- Prior Year # CTE Courses Passed – Count of Prior Year CTE Courses Passed
- Prior Year CTE Courses Failed or Incomplete – Service IDs with pass/fail (E0949) not equal 01 or 08
- Prior Year # CTE Courses Failed or Incomplete – Count of Prior Year CTE Courses Failed or Incomplete
- CTE Transfer Courses – Updated 3/10/2025
- Displays all years completed part (Course Sequence E0948 = 0,2,5,9,D0,D2,D5,D9) 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 be used in the auto calculation of the Program of Study and CTE Code.
- CTE Transfer Courses Passed – Service IDs with pass/fail (E0949) = 01 or 08
- CTE Transfer Courses Failed or Incomplete – Service IDs with pass/fail (E0949) not equal 01 or 08
- Displays all years completed part (Course Sequence E0948 = 0,2,5,9,D0,D2,D5,D9) 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
- 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”
- E1640 (C214) for any year/submission along with E1733 licensure results starting with 2022-2023
- Added 3/10/2025CCMR EWS – IBC Years and Met IBC Only columns from the CCMR EWS report
- CCMR EWS IBC 2024 – displays if running year filter 2023-2024
- CCMR EWS IBC 2025 – displays if running year filter 2024-2025
- CCMR EWS IBC 2026 – displays for any year filter > 2023-2024
- CCMR EWS Met IBC Only – students evaluated for CCMR Met based solely on the applicable year’s IBC indicator
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
- Single select Year (Default most recent PEIMS summer)
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
1270XXXX, 130XXXXX, N127XXXX, N130XXXX
17-18 School Year
1270XXXX, 130XXXXX, N127XXXX, N130XXXX
16-17 School Year
1270XXXX, 130XXXXX, N127XXXX, N130XXXX
15-16 School Year
1270XXXX, 130XXXXX, N127XXXX, N130XXXX
14-15 School Year
1270XXXX, 130XXXXX, N127XXXX, N130XXXX, LOTES012, LOTES013
13-14 School Year
1270XXXX, 130XXXXX, N127XXXX, N130XXXX
12-13 School Year
1270XXXX, 130XXXXX, N130XXXX
11-12 School Year
1270XXXX, 130XXXXX, N130XXXX, N9999997, N9999998, N9999999
10-11 School Year
1270XXXX, 130XXXXX, N130XXXX, N9999997, N9999998, N9999999
09-10 School Year
119XXXXX, 120XXXXX, 1211XXXX, 122XXXXX, 123XXXXX, 124XXXXX, 125XXXXX, 127XXXXX,M1211XXX, M123XXXX, M9999993, M9999994, M9999995,N119XXXX, N120XXXX, N122XXXX, N123XXXX, N125XXXX, N127XXXX, N1295XXX, N9999997, N9999998, N9999999
08-09 School Year
119XXXXX, 120XXXXX, 121XXXXX, 122XXXXX, 123XXXXX, 124XXXXX, 125XXXXX, 127XXXXX, M121XXXX, M122XXXX, M123XXXX, M9999993, M9999994, M9999995, N119XXXX, N120XXXX, N121XXXX, N122XXXX, N123XXXX, N124XXXX, N125XXXX, N127XXXX
Internal staff only – All applicable CTE related tables
- PDPCI.cte_courses_sql
- PDPCI.ibcsToProgramsOfStudy
- PDPCI.program_of_study
- PDPCI.program_of_study_e1643
- PDPCI.code_tables where code_table_id = ‘C022’, ‘C214’, ‘C226’, ‘pos_career_cluster’