CTE Student Apprenticeship Programs Submission Report
Contents
Introduction
This submission is required for all students who participated in a RIDE approved or provisionally approved CTE program of study that has a current written agreement with a registered apprenticeship program.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to the selection criteria for analysis when the report does not return the correct records.
School Selection
The report selects which school records to use based on the following criteria:
- The Exclude from State Reporting indicator must be No for the school.
- The school must be associated with a student included in the report.
Student Selection
The report selects which student records to use based on the following criteria:
- The course must not be excluded from State Reporting.
- The student is not excluded from state reporting.
- The student was enrolled during the Term selected.
- The students must be scheduled into a section for a course that has a CTE Program Code Specified and a CTE Apprentice Ship Code Specified.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Select Schools* | If run at the district level, choose one of the following:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Select Students* | Select the button to run for The Selected Students or All Students |
| Scheduling Options | Description |
Scheduling – Run Now | Leave Run Now selected to run the report now. |
Submit | Click Submit to run the report now |
Scheduling – Please Select When to run | Click the Schedule button to schedule this report to run. |
Please Select Schedule Settings | Enter the Start Date and Start Time. Click the Repeat button. |
Please select repeat cycle options. | Choose the applicable option. |
Please select end date range option | Enter the appropriate information. |
| Submit | Click Submit to schedule the report. |
Districts using the Automated Data Transfer (ADT) system may utilize the SQL script for state reporting purposes provided at the bottom of the report page.
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
Column | Data Element | Description | [Table]FieldName | Field Type | Field Length |
A | DISTCODE | This field contains the state assigned two-digit local education agency code (LEA). Start Page > District Setup > District Information. | [Pref]districtnumber | Text | 2 |
B | SCHCODE | This field contains the state assigned five-digit code that identifies the school building. Start Page > District Setup > Schools/School Info > Edit School. | [S_RI_SCH_X]Ride_ID | Text | 5 |
C | CTECHCTR | This field contains the five-digit code that identifies the Career and Tech Center School where the program is offered. Start Page > Student Selection > State/Province RI > CTE - Credits Earned. See CTE Career and Tech Center School Codes for more information. | [S_RI_STU_CTECRD_C]TechCenter | Text | 5 |
D | SASID | This field contains the student identification number assigned by the Rhode Island State Department of Education. Start Page > Student Selection > Rhode Island State Information. | [Students]State_StudentNumber | Number | 10 |
E | LOCALCTEPROGRAMCODE | This field contains the locally defined code for the CTE Program associated with this course. Start Page > School Setup > Courses. | [S_RI_CRS_X]CTE_ProgramCode | Text | 100 |
F | APPRENTICESHIPCODE | This field contains the code for the registered apprenticeship that the student qualified for advanced standing. Start Page > School Setup > Courses. See Code Set for APPRENTICESHIPCODE on the RI website for more information. | [S_RI_CRS_X]CTE_ApprenticshipCode | Text | 4 |