Tool Search: CTE Reports
The CTE Courses Report lists any course that has a CIP Code in the selected calendar.
CTE Courses Report
Report Logic
Any course that has a CIP Code value entered on the Course editor in the selected calendar reports. A course must be marked as active in order to report; inactive courses, even if there is a CIP Code value for that course, do not report.
The following CTE Data fields on the Course editor and Course Masters editor (if using a Course Catalog) are included in the report. Any value populated on the Course Master editor displays on the Course editor.
- CIP Code
- Program Type
- Agreement Higher Ed
- Advanced Stand-In Training
- Post-Secondary Credit Code
- Apprenticeship Code
- Recognized Credential Earned Code
- CTE Sequence
- Concentrator in Sequence
Report Editor
| Field | Description |
|---|---|
| Extract Type | Indicates which CTE Report generates. For this instance, choose CTE Courses. |
| Format | The report can be generated in CSV or HTML formats. |
| Calendar Selection | At least one calendar needs to be chosen in order for the report to generate. If a calendar is selected in the Campus toolbar, that calendar is already chosen. Calendars can be selected by the active year, by school or by year. |
Generate the CTE Programs Report
- Select the CTE Courses options from the Extract Type dropdown list.
- Select the desired Format.
- Select the desired Calendar from which to report CTE Course information.
- Click the Generate Extract button. The report displays in the selected format.
CTE Courses Report - CSV Format
CTE Courses Report - HTML Format
SQL Query
XX = calendarID
EXEC get_RI_CTE_Courses @calendarIDs = '<IDs><ID>XX</ID></IDs>'
Report Layout
| Data Element | Description | Type, Format and Length | Campus Database | Campus Interface |
|---|---|---|---|---|
| District Code | Indicates the district where the student attends school. This reports the Resident District Code from the student's enrollment record. If that is not populated, this reports the State District Number. | Numeric, 2 digits | Enrollment.service District District.number | Student Information > General > Enrollments > State Reporting Fields > Resident District Code System Administration > Resources > District Information > State District Number |
| School Code | Identifies the school code. If Enrollment Status is H or S, a value of XX190 reports, where XX is the first two digits of the current state school number. | Numeric, 5 digits | School.number | System Administration > Resources > School > School Detail > State School Number |
| CTE Tech Center | Reports the career and tech center code. This field always reports blank. | Blank, 5 spaces | N/A | N/A |
| Local Course ID | Reports the course number. | Alphanumeric, 13 digits | Course.number | Scheduling > Courses > Course > Course Information > Course Number |
| Local CTE Program Code | Reports the locally assigned name for the CTE Program. This field reports the name of the course. | Alphanumeric, 40 characters | Course.name | Scheduling > Courses > Course > Course Information > Name |
| Course Order in Progress Sequence | Reports the specific order in the sequence where this course falls within the number of required courses to complete the program of study. On the Course editor, the CTE Sequence field has two dropdowns (parts n of m parts). This field reports the first (part n) value. | Numeric, 1 digit | Course.cteSequence Number | Scheduling > Courses > Course > Course Information > CTE Sequence |
