Tool Search: NC CTE Extract
The CTE Extract collects data on CTE CTE Concentrators, Potential Concentrators, OCS/ECS Exclusions, Pathway Course Sequences, and Major Level courses.
NC CTE Extract Editor
Read - Access and generate the NC CTE Exxtract.
Write - N/A
Add - N/A
Delete - N/A
For more information about Tool Rights and how they function, see the Tool Rights article.
Report Logic
Only primary enrollments are included in the report.
Student Enrollments must be active at least one day during the reporting period in order to be included.
- The enrollment end date must be blank or on or before the last day of the school calendar.
- The enrollment end date must be within the Calendar year and have a Local End Status of W4 or W6.
All program records from all years are reported, not just those program records from the selected calendar. One record per program reports, even when it crosses multiple years.
OCS/ECS Students, Pathways Details, and Subgroup Categories are excluded from the report unless the checkbox is marked on the Report editor.
Academic Programs must be marked as State Reported to be included in the CTE Extract.
The report uses the Compound Requirements setup on the Academic Program to report CTE Status.
- When an Academic Program has two required courses, the Pathway Level is set to Prerequisite for one course and Concentrator for the other course.
Compound Requirements Setup for Two Required Courses - When an Academic Program has three required courses, the Pathway Level is set to Foundational Prerequisite for one course, Prerequisite for the second course, and Concentrator for the third course.
Compound Requirements Setup for Three Required Courses
Students are NOT included when:
- The Calendar of enrollment is marked as State Exclude or Summer School.
- The Grade Level of enrollment is marked as State Exclude.
- The Enrollment record is marked as State Exclude or No Show.
Report Editor
| Data Element | Description |
|---|---|
| Setup | |
| Search Calendars | Search field to narrow the list of calendars to select. Use the Expand All/Collapse All. Place a checkbox next to the desired school and calendars. |
| Show Active Year Only |
When set to ON, only those calendars for the current school year are available for selection. When set to OFF, all calendars from all school years are available for selection. |
| Report Options | |
| CTE Status | Indicates the CTE Status to include in the extract. Choose the All option or an individual status - Concentrator, Potential Concentrator, or Participant. Only one status can be selected. |
| Grade Levels |
Lists the state Grade Levels of enrollment that can be selected. Select the All option or individual grade levels. More than one grade level can be selected. |
| Include OCS/ECS Students |
When marked, students who are OCS or ECS are included in the report. |
| Include Pathway Details | When marked, the Pathway Details are included in the report. |
| Include Subgroup Categories | When marked, students who are Homeless, Migrant, Single Parents, Youth with Parents in Active Military, and English Language Learners are included in the report. |
| Effective Date | Entered date reflects the date by which students are considered active in the school. This date defaults to the last day of the selected calendar. Use the Calendar icon to select a different date or enter a new day in MMDDYY format. |
| Ad hoc Filter | Select which students to include in the extract by choosing a filter that was created in the Filter Designer. Only those students included in the filter are included in the report. |
| Output Options | |
| Report Processing | To generate the report immediately,select Generate Now option. To choose when the report generates, use the Submit to Batch option. Submit to Batch is useful when generating the report for several calendars or for larger amounts of data being reported. See the Batch Queue article for more information. |
| Format Type | Determines in which format the report generates - CSV or HTML. |
Generate the Report
- Search for and select the desired Calendars.
- Select the desired CTE Status from the dropdown list. Only one can be selected.
- Select one of more Grade Levels. More than one can be selected.
- Mark the checkboxes to include students in additional reporting categories - Include OCS/ECS Students, Include Pathway Details, and Include Subgroup Categories.
- Enter an Effective Date for the report.
- Select an Ad hoc Filter to only report data for students included in the filter.
- Select the desired Report Processing option of Generate Now or Submit to Batch Queue.
- Select the desired Format Type.
- Click Generate. The report displays in the selected format.
CTE Extract - CSV Format
CTE Extract - HTML FormatReport Layout
| Data Element | Description | Location |
|---|---|---|
| Student Number | Reports the locally assigned Student Number.
Numeric |
Demographics > Local Student Number
Person.studentNumber |
| Last Name | Reports the student's last name.
Alphanumeric, 50 characters |
Demographics > Last Name
Identity.lastName |
| First Name | Reports the student's first name.
Alphanumeric, 50 characters |
Demographics > First Name
Identity.firstName |
| Grade | Reports the grade level of enrollment for the student.
Alphanumeric, 3 characters |
Enrollments > General Enrollment Information > Grade
Enrollment.grade |
| Sex | Reports the student's gender.
Alphanumeric, 1 character (M or F) |
Demographics > Sex
Identity.gender |
| Race/Ethnicity | Indicates the student's Race/Ethnicity.
Alphanumeric, 1 character |
Demographics > Race/Ethnicity
Identity.raceEthnicity |
| Career Pathway | Reports the Academic Plan associated with the Pathway.
Alphanumeric |
Academic Program Detail > Program Name
|
| Career Cluster | Reports the student's Career Cluster.
Alphanumeric |
Academic Program Detail > Cluster |
| CTE Status | Indicates whether the student is a Concentrator, Participant, or Potential Concentrator.
See the Report Logic section for additional details. When the Academic Program Student Status is set to Concentrator or Participant, that value reports. Otherwise, a check is done to see whether the student is a Potential Concentrator based on the Compound Requirements for the Program in which the student is enrolled. When the Program has a Foundational Prerequisite, Prerequisite, and Concentrator:
|
Academic Program Detail > Student Status
Academic Program Setup > Compound Requirements |
| Override | Indicates the student has been granted an override to participate in the program.
Alphanumeric, 1 character (Y or N) |
Academic Program Detail > Override
|
| Course(s) In Progress | Lists the in-progress courses the student is currently taking.
This reports only when the Include Pathway Details is marked on the Extract editor. When the student's End Date in the course/section is on or before the start date of the course/section, OR the student has received credit for the course and is posted on the student's transcript, the course is not included. |
Schedule, Programs > Academic Program |
| Foundational Prerequisite Course | Lists the Course Numbers of the courses that are considered pre-requisites.
This reports only when the Include Pathway Details is marked on the Extract editor. |
Academic Program Setup > Academic Program Detail > Compound Requirements > Pathway Level |
| Prerequisite Course | Lists the Course Numbers of the courses that are considered pre-requisites.
This reports only when the Include Pathway Details is marked on the Extract editor. |
Academic Program Setup > Academic Program Detail > Compound Requirements > Pathway Level |
| Concentrator Course | Lists the courses the student is taking that are considered Concentrator.
This reports only when the Include Pathway Details is marked on the Extract editor. |
Academic Program Setup > Academic Program Detail > Compound Requirements > Pathway Level |
| Pathway Credits Required | Lists the number of credits required for the Pathway.
This is the SUM of credits required for all courses in the Pathway. This reports only when the Include Pathway Details is marked on the Extract editor. Numeric |
Academic Program Setup > Course Requirements > Minimum Credits |
| Individuals with Disabilities | Reports a value of Y when the Primary Disability field is populated. Report a value of N when the Primary Disability field is NOT populated. This reports only when the Include Subgroup Categories is marked on the Extract editor. Alphanumeric, Y or N |
Exceptional Children (EC) > Primary Disability |
| Individuals Preparing for Non-Traditional Fields | When the Non-Traditional Participation checkbox is marked on the student's Academic Plan, reports either Y or N.
This reports only when the Include Subgroup Categories is marked on the Extract editor. Alphanumeric, Y or N |
Academic Program Detail > Non-Traditional Participation |
| Single Parents | Indicates the student is also a single parent. When the Pregnant and Parenting Program Status field is populated AND the End Date on that program is blank or is before the Effective Date entered on the report editor, a value of Y reports. This reports only when the Include Subgroup Categories is marked on the Extract editor. Alphanumeric, Y or N |
Pregnant and Parenting > Program Status |
| English Learners | Indicates the student is also an English Language Learner. When the student's English Learner Program Status is EL AND the End Date on that program is blank or is before the Effective Date entered on the report editor, a value of Y reports. Otherwise, a value of N reports. This reports only when the Include Subgroup Categories is marked on the Extract editor. Alphanumeric, Y or N |
English Learners > English Learners (EL) > Active EL Record > Program Status |
| Homeless Individuals | Indicates the student is also considered unhoused.
When the student has an active Homeless record (no End Date or End Date after the date of the report), a value of Y reports. Otherwise, a value of N reports. This reports only when the Include Subgroup Categories is marked on the Extract editor. Alphanumeric, Y or N |
Homeless > End Date |
| Migrant Students | Indicates the student is also considered a Migrant.
When the student's Migrant record has a Program Status of Active AND the End Date on that program is blank or is before the Effective Date entered on the report editor, reports a value of Y. Otherwise, a value of N reports. This reports only when the Include Subgroup Categories is marked on the Extract editor. Alphanumeric, Y or N |
Migrant > Program Status |
| Youth with Parents In Active Military | Indicates the student's parents are active members of the military.
When the Military Connections Editor has an active record AND the End Date on that program is blank or is before the Effective Date entered on the report editor, reports a value of Y. Otherwise, reports a value of N. This reports only when the Include Subgroup Categories is marked on the Extract editor. Alphanumeric, Y or N |
Military Connections |
| OCS/ECS Flag | Indicates the student participates in OCS/ECS.
When the EC Designated Course of Study is populated, reports either O or E. Otherwise, reports blank. |
Exceptional Children (EC) > EC Designated Course of Study |
| School Year | Reports the calendar year the Concentrator was completed. When there is no end date entered for the Concentrator, the Calendar Year reports. When the program is not set to Concentrator, this field reports blank. Numeric, 9 characters (YYYY - YYYY) |
Calendar > Start Year, End Year
Calendar.startYear Calendar.endYear |
| School Number | Reports the State School Number of the school in which the student is enrolled.
Numeric |
School Information > State School Number
School.number |
| District Number | Reports the State District Number in which the student attends school.
Numeric |
District Information > State District Number
District.number |
