Tool Search: CTE Reports
The CTE Recognized Credentials Earned Report lists the student's ID number and course number of enrollment where the student is receiving CTE training, and the credential earned code assigned to the course.
CTE Recognized Credentials Earned Report
Report Logic
In order to report, Recognized Credential Earned Code must be selected from the drop list.
Any course that has a CIP Code value entered on the Course editor in the selected calendar reports. A course must be marked as active in order to report; inactive courses, even if there is a CIP Code value for that course, do not report.
A student must have an Active Career Tech Program at anytime during the Prior and Effective Dates entered on the Report Editor. The Program must have an active Passed certification at Career Tech Program Certification.
Course data reports from the Course Section that has a matching CIP code and CTE Program Type to the matching Active Career Tech Program and CTE Program Type. If the student has 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 Recognized Credentials Earned. |
| 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 Recognized Credentials Earned 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 Recognized Credentials Earned - CSV Format
CTE Recognized Credentials Earned - HTML Format
SQL Query
XX = calendarID
EXEC get_RI_CTE_Recognized_Credentials_Earned @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 | The reporting district code. | Numeric, 2 digits | District.number Enrollment.service District | System Administration > Resources > District Information > State District Number Student Information > General > Enrollments > State Reporting Fields > Resident District Code |
| 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 |
| Recognized Credential Earned Code | Reports the code of the recognized credential the student earned. | Numeric, 3 digits | Course.cte CredentialCode | Scheduling > Courses > Course > Course Information > CTE Data > Recognized Credentials Earned Code |
