CTE Student Programs Submission Report

Contents

Introduction

This submission is required for any student enrolled in a RIDE approved or provisionally approved CTE program of study.

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 school is not excluded from State reporting.
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 student is not excluded from state reporting.
Students enrolled in a course with an active Local CTE Program Code assigned for the specified Term are selected.
The course has a Local CTE - Program Code entered.
The course does not have a CTE Apprenticeship Code assigned.

Back to Top

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: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district. 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
Report Checked CTE Students Only	Select Yes or No
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_SCH_CTEPGM_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. Start Page > Student Selection > State/Province RI > CTE - Credits Earned.	[S_RI_CRS_X]CTE_ProgramCode	Text	100
F	WBLCOMPLETED	Completed CTE Program Work-Based Learning Requirement. Start Page > Student Selection > State/Province RI > CTE - Credits Earned.	[S_RI_STU_CTECRD_C]WBL_Completed	Text	1
G	CREDENTIALCOMPLETED	Completed CTE Program Culminating Credentials Requirement. Start Page > Student Selection > State/Province RI > CTE - Credits Earned.	[S_RI_STU_CTECRD_C]Credential_Completed	Text	1
H	COMPLETEDIRCONLY	Completed CTE Program Culminating Credentials Requirement with Industry Recognized Credentials Only. Start Page > Student Selection > State/Province RI > CTE - Credits Earned.	[S_RI_STU_CTECRD_C]Completed_IRC_Only	Text	1
I	COURSEWORKCOMPLETED	Completed CTE Program Coursework Requirement. Start Page > Student Selection > State/Province RI > CTE - Credits Earned.	[S_RI_STU_CTECRD_C]Coursework_Completed	Text	1
J	CTEPROGRAMCOMPLETER	CTE Program Completer. Start Page > Student Selection > State/Province RI > CTE - Credits Earned.	[S_RI_STU_CTECRD_C]CTE_Program_Completer	Text	1

Back to Top