Import Process for TEA Calculated CTE Programs of Study

Introduction

Import Process for TEA Calculated CTE Programs of Study: Version 23.12.2

A new import process is now available under the Student Programs category on the State Reports page. The CTE Programs of Study import creates and/or updates student records using the information contained in your district’s PDM3-404-002_CareerandTechnicalEducation.csv file, which is available for download from the TSDS system. The TEA file contains the calculated CTE Programs of Study records based on CTE course completion data submitted in the PEIMS Summer and Extended Year submissions.  Before proceeding, you must first download the TEA report in CSV format.

Import Process

• The CTE Programs of Study import can be run for different files and different school years.

• In the Academic Year parameter, select the year that corresponds to the value in column A of the TEA file you wish to import. The 2023 Academic Year file is the most recent file available from TEA and includes 2022-23 records.

• Click the Browse button to select the TEA file. If the selected year does not match the Academic Year in the file, an error message is displayed.

• If the file is valid, click Import File to initiate the import. The user is directed to the State Reports Queue.

Record Processing

• Students are matched using the Student Number from the Local ID column in the file. If no matching student number is found, the import matches based on Unique ID.

• Records are imported for active and inactive students, including Graduates.

• For students with a single TEA-calculated Program of Study, a single record is imported for the corresponding school year.

• Students with multiple Programs of Study will have multiple records.

• If records for a particular school year already exist, they are overwritten and updated using the records in the TEA file.

• Records for students with no matching PowerSchool Student Number or Unique ID are not imported.  These records appear in the companion Excluded Students file.

CTE Program of Study Records

• Records from the TEA file are imported into the PowerSchool CTE Programs of Study table (S_TX_STU_CTEPS_C), which is a child of the Students table.

• After importing the records, select a student and navigate to Student Programs, Career and Tech. Click the CTE Programs of Study to view the student’s records.

• Students may have multiple Programs of Study for a single year or for multiple years.  The CTE Indicator Codes may differ across records. The most recent records are displayed at the top of the page.

  • School Year

  • Program of Study

  • CTE Indicator

  • State/Regional Program

  • State Cluster

  • Federal Cluster

  • System Comment

• After running the import process, generate the updated Career and Tech Verification Report, which now includes the CTE Programs of Study for each student. See the related release note for this report for additional details.

Import Process for TEA Calculated CTE Programs of Study Report Output: A zip file is produced containing two csv files. Download and unzip the file, then open the files in Excel or other similar application.

• Import Confirmation File:  Includes all students for whom at least one Program of Study record was imported.

  • Year

  • Campus ID

  • Student Name

  • UID

  • Local ID

  • Grade

• Excluded Students File: Includes students that were not processed due to no matching Student Local ID or UID.

Import File