Tool Search: CTE Reports
The CTE Apprenticeship Programs Report lists the student's ID number and course number of enrollment where the student is receiving CTE training, and any apprentice code associated with the program.
CTE Apprenticeship Programs Report
Report Logic
In order to report:
- A Recognized Credential Earned Code must be populated.
- The Apprenticeship Code must be selected from the drop list on the course editor.
- A student must have an Active Career Tech Program (Career Tech Program Detail) anytime during the Prior Reporting Date and Effective Date on the report editor.
- Active and State Reported must be marked on the Course Information and Career Tech Program Detail.
- The program must have an active "Passed" Certification at Career Tech Program Certification, or "Completer" must be the Student Status on Career Tech Program Detail.
Any course that has a CIP code reports.
Course data reports from the Course Section that has matching CIP code and CTE Program Type to the matching Active Career Tech Program Active Career Tech Program CIP Code and CTE Program Type. If the student is enrolled in multiple active Career Tech Programs, multiple records for that student report.
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 Apprenticeship 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 Apprenticeship 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 Apprenticeship Programs Report - CSV Format
CTE Apprenticeship Programs Report - HTML Format
SQL Query
XX = calendarID
EXEC get_RI_CTE_Apprenticeship_Programs @calendarIDs = '<IDs><ID>87</ID></IDs>',@effectiveDate='2/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. 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 |
| 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 | Scheduling > Courses > Course > Course Information > CTE Data > Program Type |
| Apprenticeship Code | Reports the code of the registered apprenticeship for which the student qualified for advancing standing in. | Numeric, 3 digits | Course.cte ApprenticeshipCode | Scheduling > Courses > Course > Course Information > CTE Data > Apprenticeship Code |
