- Disclaimer Update 9/18/2024: TEA has not yet published the official CTE lookup table for 2024-2025: PEIMS Calculations – Tech Tips. Therefore, we have manually built a table based on the file found on the TEA CTE Programs of Study page: Programs of Study Change Crosswalk (Updated July 2024). Consider the CTE and Program of Study codes for 2024-2025 to be preliminary until the 2024-2025 CTE lookup table is published, at which point we will replace the manually built table.
- 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 https://kb.ondatasuite.com/knowledge-base/cte-transfer-courses/ for more information on loading this information
- 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
CTE Code
- Can have both CTE Code 6 and 7
- Calculated based on the following logic:
- Service ID Credit and Level can be found under the Source Data document found on the following TEA page: TEA PEIMS Calculations – Tech Tips
| 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 |
Program of Study
- Only calculated 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 Source Data Document, POS Service ID Level Credit and Non-POS CTE Service IDs tabs found here: TEA PEIMS Calculations – Tech Tips
- Includes both state and regional level program of study codes
Frequently Asked Questions
Q1: My student has more than 3 courses with at least 4 credits, why are they a CTE Code 6 instead of 7?
A1:
- Ensure all courses you are counting are in the correct course sequence (0, 2, 5, 9, D0, D2, D5, D9). If the same service ID is reported twice, but both course sequence codes indicate the first part of the course, for example, 1 and D1, none of the parts will be used in the calculation.
- Verify that all completion parts of the courses you are counting are passing (01 or 08).
Q2: My student has many CTE courses, and the sum of credits is greater than 4, why are they being counted as a CTE code E instead of 6 or 7?
A2:
- See question 1.
- Verify that at least two courses are in the same program of study. If a program of study only has one service ID tied to it, the student can’t be a CTE code 6 or 7 because the courses aren’t in the same program of study.
Q3: How do I know how many credits and what levels the service IDs have?
A3: Please see the TEA reference document, Source Data, for the appropriate year:
- PEIMS Calculations – Tech Tips
- Using both the POS Service ID Level Credit and Non-POS CTE Service IDs tabs
Q4: I have a student who has more CTE courses than what is showing on the report, therefore, the CTE code is incorrect. Why is that?
A4: Currently, we can only use what has been reported to PEIMS through course completion records. If a student received their courses from another LEA, these courses would not be accounted for in the report.
Please see kb article for information on loading CTE transfer courses to more accurately calculate the codes:
Q5: Why is my student showing as CTE code 4 when they have a CTE course in a prior year?
A5: Currently, only CTE courses that are associated with a program of study are being used for the calculations of CTE and program of study codes. There are some CTE service IDs that are no longer valid but were valid in the past. Please see the Source Data document in A3, the Non-POS CTE Service IDs tab to see these service IDs.
Q6: When a student has both a 6 and 7 CTE code, how can I see which code belongs to which program of study?
A6: Use Column Options to add a grouping on the Program of Study Code. This will separate the rows for students who have both a CTE code 6 and 7 with the matching program of study code(s).
Q7: I have many students in middle school who are not in CTE, why are my CTE Codes 4-Not CTE so low?
A7: We are only calculating the CTE Code for students who have had at least one CTE course, either current or prior years, so students not on this list are automatically considered not in CTE.
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’