Career and Technical Education - Course Enrollment File

Contents

Introduction

This report generates the Career and Technical Education – Course Enrollment (CTE Course) collection with the consolidated student file format. The report scans for students who were enrolled for a minimum of twenty school days during the current school year. One row is exported for each section where the student was enrolled. The report may be run at the district-wide or school level.

This report uses PS_Membership_Defaults, which is a database table. This table provides student membership information for each day that they have an active enrollment on valid in-session school days. It includes potential periods and minutes as well as actual periods and minutes absent.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Students Selection

The report selects records from the [Students] and [ReEnrollments] tables based on the following criteria:

When a selection of students is provided to the report then that selection is used.
When a start date and end date are provided to the report then students with enrollments within the date range are selection for report inclusion.
When a list of entry codes or exit codes is provided to the report, then students with enrollments using these entry or exit codes are selected for report inclusion.
The Start Date must be on or before the last day of the current term.
The End Date must be on or after the last day of the current term.
The Start Date must be before the End Date.

Back to Top

Report Input

To generate the Career and Technical Education - Course Enrollment File, do the following:

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Use	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office.
Students to Include	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. If running the report for a single student, or group of students, select the students prior to running report. All students – Run the report for all students in the current school or district that meet the selection criteria. Note: Students are evaluated against the selection criteria of the report and may not be included in the output if they do not qualify for the report.
Restrict students and their school enrollments to the following Entry Codes (comma-delimited list).	Enter the Entry Code(s) to be used as student selection criteria. Example: E1,E2,R4
Restrict students and their school enrollments to the following Exit Codes (comma-delimited list).	Enter the Exit Code(s) to be used as student selection criteria. Example: G,W1
Conditional Operator	Choose a conditional operator from the pop-up menu: Entry Codes OR Exit Codes Entry Codes AND Exit Codes
Course Grade Inclusion	Select the checkbox to only include grades earning credit hours. Note: If this checkbox is not selected, all grades associated with a course enrollment will be included.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Data Type	Field Length
This report is a student-level Consolidated Collections report using the “core fields query” to gather student details and assure consistent data submissions to ODE. SEE THE SSID REPORT OUTPUT FOR A LISTING OF THE CORE ELEMENTS OF THIS STUDENT-LEVEL CONSOLIDATED COLLECTION REPORT.
57	Career and Technical Education (CTE) CIP Code	Code indicating the career area and program area for the course taken by the student.	[Courses]Code	varchar	3
58	Career and Technical Education (CTE) Class Number	Number assigned to the instructional unit/course enrolled in by the student. Each instructional unit/course has a number assigned to it by the school that identifies the specific curriculum.	[Courses]Course_Number	varchar	17
59	Career and Technical Education (CTE) Section Number	Number of the section or term and period that the student took the course. Used to differentiate multiple offerings of the same course within the school year. Note: When multiple term grades exist for a CTE course having the same section number, a letter designation (A, B, C, etc.) is appended to the Section Number field for additional term grades. (For example, when a year long section has an S1 and S2 grade to be reported, the S1 grade row will have the original section number reported and the S2 grade row will have the letter A added to the end of the section number.)	[Sections]Section_Number	varchar	3
60	Career and Technical Education (CTE) Course Grade Code	Code indicating the grade (mark) received in the instructional unit or course taken during the reporting period by the student.	[StoredGrades]Grade	char	1
61	Career and Technical Education (CTE) Credits	Credits for an instructional unit or course, with two implied decimal places. Format: nnnnn	[S_OR_SGR_X]CTEOvrdCredits [StoredGrades]EarnedCreditHours	char	5
62	Career and Technical Education (CTE) Filler	Reserved for future use.	N/A	varchar	20

Back to Top