CTE Aggregate Bulk Upload

The CTE aggregate Bulk Upload extracts vocational section information for all sections having students enrolled on the 40th or 100th day of school. This report can be run at the district level but is primarily designed as a school-level report.

This report is used by Career and Technical Education Districts (CTEDs) who are responsible only for aggregate enrollment reporting.

Selection Criteria

The report selects records from the [Sections] 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)
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 meets selection criteria. 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 before running the report.
Collection Period	Choose one of the following from the pop-up menu: 100 Day Period – Include sections with active enrollments on the 100th day. 40 Day Period – Include sections with active enrollments on the 40th day.
CTDS of the school of residence	Enter the County Code-Type Code-District Code-Site Number of the school of residence.

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.

Item #	Data Element	Description	[Table]FieldName	Length
1	Location	The County Code-Type Code-District Code-Site Number for the school of residence.	Report Parameter	9
3	Program Number	The program CIP code for the section.	[S_AZ_CRS_X]CIPProgramNumber	8
4	Course Number	The CIP code for the course.	[Courses]Code	8
5	Funding Eligible Status	Indicates if the school is eligible for JTED funding. Valid values: 0 – Ineligible 1 – Eligible	[Sections]JTED_Indicator	1
6	Grade9EnrollCount	The total number of ninth-grade students enrolled in the section within the report date range.	Calculated	3
7	Grade10EnrollCount	The total number of tenth-grade students enrolled in the section within the report date range.	Calculated	3
8	Grade11EnrollCount	The total number of eleventh-grade students enrolled in the section within the report date range.	Calculated	3
9	Grade12EnrollCount	The total number of twelfth-grade students enrolled in the section within the report date range.	Calculated	3