CTE Courses Submission Report
Contents
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.
The report selects records based on the following criteria:
- The course(s) is not excluded for State reporting.
- All courses in the selected Schools Master Schedule that have a CTE Program Code specified for the Term selected.
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. |
| 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 course 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 | LOCALCOURSEID | This field contains the local course code for the course. | [Courses]Course_Number | Text | 20 |
E | LOCALCTEPROGRAMCODE | This field contains the locally defined code for the CTE Program of this course. Start Page > School Setup > Courses. | [S_RI_CRS_X]CTE_ProgramCode | Text | 100 |
F | COURSEORDERINPROGRSEQ | This field contains the specific sequence number of this course for the related CTE Program. Start Page > School Setup > Courses. | [S_RI_CRS_X]CTE_CoursesSeq | Number | 1 |