CTE Enrollment Report

The CTE Enrollment Report reports student section enrollments in the school they enrolled in on count date.

The CTE enrollment Report extracts section enrollment information active on the snapshot date where the section is flagged as Vocational at the Course level.

Collection Periods:

1 – Fall Term
2 –Spring/Summer Term

File Format:
Non-Articulated - Section enrollments from the current school are included where the section's Site Location School ID field is blank.
Articulated - Section enrollments for remote schools (student is taking a vocational class at another school) and section enrollments from sections where the Site Location School ID is not blank are included.

Selection Criteria

The report selects records from the [CC] table based on the following criteria:

The student is not excluded from state reporting ([Students]State_ExcludeFromReporting does not equal 1)
The student is enrolled in a Vocational Course ([Courses]Vocatonal = 1) on the 40th or 100th school day (according to the parameter selected)
Non Articulated File:
- The section enrollment's ([CC] table record) has a schoolID equal to the student's home school schoolID (i.e: not enrolled in a class at another school)
- The section enrollment's section has a blank 'Site Location School ID (CTDS)' field.
- Include all enrollments in a Vocational class that are active on the 40th or 100th school day (according to the student's track) where:
  - The 'Site Location SchoolID is blank and the section's schoolID is the student's home school
- Do not report class enrollments where the section's schoolID is not the student's home school.
Articulated File:
- The section enrollment ([CC] table record) has a schoolID NOT equal to the student's home school schoolID (i.e: the student is enrolled in a class at another school).
- The section enrollment's section has a value in the 'Site Location School ID (CTDS)' field.
- Include all enrollments in a Vocational class that are active on the 40th or 100th school day when selected (according to the student's track) where:
- The section's 'Site Location SchoolID is not blank and the section is at the home school (the school being run for)
- The class enrollment is for a remote section (include section enrollments where the section's school ID is not the student's home school.)
The student's course enrollment is not ‘Excluded From AZ Student-Teacher-Course Connection Reports’ ([CC]AZ_ExcludeSTC does not equal 1).
The section is not excluded from state reporting ([Sections]AZ_ExcludeSTC does not equal 1).
The section’s associated course is not excluded from state reporting ([Courses]AZ_ExcludeSTC does not equal 1).
The School that the section is associated with is not excluded from state reporting ([schools]state_excludefromreporting does not equal 1).
The school number associated with the section is not 999999 or 0.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Use	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. The CTE Enrollment Report reports students section enrollments in the school they enrolled in on count date. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office.
Students to Include	Select one of the following: The Selected [number] Students Only – Run the report for students in the current selection. All Students (default) – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Collection Period	Choose one of the following from the pop-up menu: Snapshot date
Snapshot Term	Displayed when the Snapshot reporting option is selected Choose the snapshot term; uneditable by default; required if enabled Fall Term Spring/Summer Term
Snapshot Date	Displayed when the Snapshot reporting option is selected Enter the snapshot date; uneditable by default If the Snapshot Date parameter is selected: The report includes all CTE enrollments active on snapshot date CTE class enrollment dates overlap snapshot date, taking into account that users exit students from class the day after their last in class ie: cc.exitdate = snapshot date means the student was not enrolled on snapshot date The report pulls a Term column value equal to the value selected for Snapshot Term
School CTDS	Enter the County Code-Type Code-District Code-Site Number of the school of residence.
File format	Choose one of the following from the pop-up menu: Articulated – Produces an articulated file. Non-Articulated – Produces a non-articulated file. CTED Central Campus CTED Community College
High School Schedule	Indicate the number of weeks the class is taught by choosing one of the following from the pop-up menu: 5 – Divide the total number of calendar days by 5. 4 – Divide the total number of calendar days by 4.
Store Code	Enter the store code used to record Earned Credits in the class (comma delimited) for the collection period. Example: Enter S1 when running for the 40 Day and S2 when running for the 100 Day. Enter the store code used to store earned credit hours for 40th and 100th-day enrollments.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Non-Articulated File

Use this template to upload non-articulated course enrollment (course is taught at the school of record).

Item #	Data Element	Description	[Table]FieldName	Length
1	CTDS (School of Residence)	The County Code-Type Code-District Code-Site Number for the school of residence.	[S_AZ_STU_X]CTE_Shool_Residence_CTDS [S_AZ_REN_X]CTE_Shool_Residence_CTDS	9
2	Term	The term reported. If the Snapshot Date parameter is selected, the report pulls a Term column value equal to the value selected for Snapshot Term. Valid values: 1 – Fall Term 2 –Spring/Summer Term	[Sections]TermID	1
3	Program Number	The program CIP code for the section.	[Courses]Code	8
4	Course Number	The CIP code for the course.	[S_AZ_CRS_X]CIPProgramNumber	8
5	Local Course Title	CTE Local Course Title	[Courses]Course_Name	100
6	Teacher's Educator's ID (EIN)	The teacher's 7 digit Educator Identification Number (EIN)	[S_AZ_USR_X]Teacher_EIN	7
7	Teacher's Email Address	The teacher's organization email address.	[Teachers]Email_Addr	100
8	Class Period	The class period; Any characters, numbers, or special characters are allowed	[Period]Sec.Expression	60
11	SUID	Student's Unique ID Number	[Students]State_StudentNumber	10
12	Student Birth Date	Student's Date of Birth (mm/dd/yyyy)	[Students]DOB	10
13	Credits Earned	Number of credits earned by student in the course (NN.NN)	[StoredGrades]EarnedCrHrs	5
14	CTE Student Type	The CTE Student Type: 1 CTE participating public school/charter school 2 Homeschool (non-ESA recipient) 3 Non-CTE participating public school/charter school 4 Private school/private charter school Note: CTE Enrollment Report defaults to 1 if blank.	[S_AZ_STU_X]CTE_Student_Type [S_AZ_REN_X]CTE_Student_Type	1

Articulated File

Use this template to upload articulated course enrollment (course is taught at a school other than the school of record). Do not use this template if the course is taught at a Community College (by a community college teacher) or a CTED at Postsecondary site.

Item #	Data Element	Description	[Table]FieldName	Length
1	CTDS (School of Residence)	The County Code-Type Code-District Code-Site Number for the school of residence.	[S_AZ_STU_X]CTE_Shool_Residence_CTDS [S_AZ_REN_X]CTE_Shool_Residence_CTDS	9
2	Term	The term reported. If the Snapshot Date parameter is selected, the report pulls a Term column value equal to the value selected for Snapshot Term. Valid values: 1 – Fall Term 2 –Spring/Summer Term	[Sections]TermID	1
3	Program Number	The program CIP code for the section.	[Courses]Code	8
4	Course Number	The CIP code for the course.	[S_AZ_CRS_X]CIPProgramNumber	8
5	Local Course Title	CTE Local Course Title	[Courses]Course_Name	100
6	Teacher's Educator's ID (EIN)	The teacher's 7 digit Educator Identification Number (EIN)	[S_AZ_USR_X]Teacher_EIN	7
7	Teacher's Email Address	The teacher's organization email address.	[Teachers]Email_Addr	100
8	Class Period	The class period; Any characters, numbers, or special characters are allowed	[Period]Sec.Expression	60
9	Articulated CTDS	Articulated Course Provided By CTDS Articulated outside your district: Reports Sections > Site Location School ID (CTDS) Articulated to another school in-district: Reports District > Schools/School Info > Edit School > School CTDS Number	[Sections]RemoteEntityId [Schools]CTDSOverride	9
11	SUID	Student's Unique ID Number	[Students]State_StudentNumber	10
12	Student Birth Date	Student's Date of Birth (mm/dd/yyyy)	[Students]DOB	10
13	Credits Earned	Number of credits earned by student in the course (NN.NN)	[StoredGrades]EarnedCrHrs	5
14	CTE Student Type	The CTE Student Type: 1 CTE participating public school/charter school 2 Homeschool (non-ESA recipient) 3 Non-CTE participating public school/charter school 4 Private school/private charter school Note: CTE Enrollment Report defaults to 1 if blank.	[S_AZ_STU_X]CTE_Student_Type [S_AZ_REN_X]CTE_Student_Type	1

Postsecondary Articulated File

Use this template to upload articulated course enrollment where the course is taught by a community college teacher or a CTED at a Postsecondary site.

Item #	Data Element	Description	[Table]FieldName	Length
1	CTDS (School of Residence)	The County Code-Type Code-District Code-Site Number for the school of residence.	Report Parameter	9
2	Term	The term reported. If the Snapshot Date parameter is selected, the report pulls a Term column value equal to the value selected for Snapshot Term. Valid values: 1 – Fall Term 2 –Spring/Summer Term	[Sections]TermID	1
3	Program Number	The program CIP code for the section.	[Courses]Code	8
4	Course Number	The CIP code for the course.	[S_AZ_CRS_X]CIPProgramNumber	8
5	Local Course Title	CTE Local Course Title	[Courses]Course_Name	100
6	Teacher First Name	The teacher's first name.	[Teachers]First_name	50
7	Teacher Last Name	The teacher's last name.	[Teachers]Last_name	50
8	Teacher's Email Address	The teacher's organization email address.	[Teachers]Email_Addr	100
9	Class Period	The class period; Any characters, numbers, or special characters are allowed	[Period]Sec.Expression	60
10	Articulated CTDS	Articulated Course Provided By CTDS Articulated outside your district: Reports Sections > Site Location School ID (CTDS) Articulated to another school in-district: Reports District > Schools/School Info > Edit School > School CTDS Number	[Sections]RemoteEntityId [Schools]CTDSOverride	9
11	SUID	Student's Unique ID Number	[Students]State_StudentNumber	10
12	Student Birth Date	Student's Date of Birth (mm/dd/yyyy)	[Students]DOB	10
13	Credits Earned	Number of credits earned by student in the course (NN.NN)	[StoredGrades]EarnedCrHrs	5
14	CTE Student Type	The CTE Student Type: 1 CTE participating public school/charter school 2 Homeschool (non-ESA recipient) 3 Non-CTE participating public school/charter school 4 Private school/private charter school Note: CTE Enrollment Report defaults to 1 if blank.	[S_AZ_STU_X]CTE_Student_Type [S_AZ_REN_X]CTE_Student_Type	1

CTED Central Campus + Community College File

For CTEDs Only: Use this template to upload course enrollment for CTEDs. Districts and charter schools should not use this template to upload any course enrollment into the CTE Data Portal.

Item #	Data Element	Description	[Table]FieldName	Length
1	CTDS (School of Residence)	The County Code-Type Code-District Code-Site Number for the school of residence.	Report Parameter	9
2	Term	The term reported. If the Snapshot Date parameter is selected, the report pulls a Term column value equal to the value selected for Snapshot Term. Valid values: 1 – Fall Term 2 –Spring/Summer Term	[Sections]TermID	1
3	Program Number	The program CIP code for the section.	[Courses]Code	8
4	Course Number	The CIP code for the course.	[S_AZ_CRS_X]CIPProgramNumber	8
5	Local Course Title	CTE Local Course Title	[Courses]Course_Name	100
6	Teacher's Educator's ID (EIN)	The teacher's 7 digit Educator Identification Number (EIN)	[S_AZ_USR_X]Teacher_EIN	7
7	Teacher First Name	The teacher's first name.	[Teachers]First_name	50
8	Teacher Last Name	The teacher's last name.	[Teachers]Last_name	50
9	Teacher's Email Address	The teacher's organization email address.	[Teachers]Email_Addr	100
10	Class Period	The class period; Any characters, numbers, or special characters are allowed	[Period]Sec.Expression	60
11	SUID	Student's Unique ID Number	[Students]State_StudentNumber	10
12	Student Birth Date	Student's Date of Birth (mm/dd/yyyy)	[Students]DOB	10
13	Credits Earned	Number of credits earned by student in the course (NN.NN)	[StoredGrades]EarnedCrHrs	5
14	CTE Student Type	The CTE Student Type: 1 CTE participating public school/charter school 2 Homeschool (non-ESA recipient) 3 Non-CTE participating public school/charter school 4 Private school/private charter school 5 Empowerment Scholarship Account (ESA) recipient 6 Continuation of Services/13th Year students Note: CTE Enrollment Report defaults to 1 if blank.	[S_AZ_STU_X]CTE_Student_Type [S_AZ_REN_X]CTE_Student_Type	100
15	School of Residence CTDS	The student's School of Residence CTDS if student is attending from a CTE participating school Enrollment record should match articulated enrollment from student's school of residence; otherwise, leave blank.	[S_AZ_STU_X]CTE_Shool_Residence_CTDS [S_AZ_REN_X]CTE_Shool_Residence_CTDS	9
17	File Type	The file type; defaults to CTED for all rows	CTED	4