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

Student Enrollments must be active at least one day during the reporting period in order to be included.

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 in order 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.

Screenshot of the CSV Format of the CTE Extract.

CTE Extract - CSV Format

Screenshot of the HTML Format of the CTE EXtract.

CTE Extract - HTML Format

Report 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: When 1 and 2 are complete and the student is scheduled into 3, the CTE Status reports as a Potential Concentrator. When the Program only has a Prerequisite and a Concentration, when 1 is complete, and the student is scheduled into 2, the CTE Status reports as a Potential Concentration. Alphanumeric	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.	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	Indicates whether the student is designated as OCS or ECS. This reports only when the Include Subgroup Categories is marked on the Extract editor. Alphanumeric, Y or N	Exceptional Children (EC) > EC Designated Course of Study
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, 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, 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, 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, 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 participate in OCS/ECS.
School Year	Reports the selected school year. 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

NC CTE Extract

Report Logic

Report Editor

Generate the Report

Report Layout

Related Articles