Tool Search: CTE Reports
The CTE Student in Programs Report lists the student's ID number and course number of enrollment where the student is receiving CTE training.
CTE Student in Programs Report
Report Logic
In order to report:
- A student must have an Active Career Tech Program (Career Tech Program Detail) at any time during the Prior Reporting Date and Effective Date on the report editor.
- Active and State Reported must be checked on the Career Tech Program Detail.
- Course data reports from the Course Section that has matching CIP code and CTE Program Type to the matching Active Career Tech Program CIP Code and CTE Program Type. If a student has multiple active Career Tech Programs multiple records are reported.
Students do not report when:
- Their enrollment record is marked as State Exclude or No Show.
- They are enrolled in a grade level marked as State Exclude.
- They are enrolled in a Calendar marked as State Exclude.
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 Student in Programs. |
| Prior Reporting Date | Entered date indicates the last time this information was reported. Dates are entered in mmddyy format, or can be chosen using the calendar icon. |
| Effective Date | Entered date is used to return students who were enrolled in a course with a CIP code at any time between the Prior Reporting Date and the Effective Date, which defaults to the current date. Modify the current date by typing a new date in mmddyy format or using the calendar icon to choose a date. |
| 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 Report
- Select the CTE Student in Programs options from the Extract Type dropdown list.
- Enter the Prior Reporting Date.
- Modify or keep the current Effective Date.
- Select the desired Format.
- Select the desired Calendar from which to report CTE Program information.
- Click the Generate Extract button. The report displays in the selected format.
CTE Student in Programs - CSV Format
CTE Student in Programs - HTML Format
SQL Query
XX = calendarID
EXEC get_RI_CTE_Student_In_Programs @calendarIDs = '<IDs><ID>87</ID></IDs>',@effectiveDate='02/11/2019', @priorReportDate = '08/01/2018'
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. | 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 |
| SASID | Reports the student's state assigned identification number. | Numeric, 10 digits | Person.stateID | Census > People > Demographics > Person Identifiers > Student State ID |
| Local CTE Program Code | Reports the locally assigned name for the CTE Program. | Alphanumeric, 40 characters | Course.programType | Program Admin > Programs > Career Tech Programs > Pathway/Program Name |
