CTE Participant Concentrator

The CTE Participant Concentrator extracts CTE participant concentrator information for all students within the selected school year. One record is extracted for each unique CTE Program Number a student participates in for the current school year.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to the selection criteria for analysis when the report does not return the correct records.

Course Selection

The course must be marked as a Vocational Class.
The course must have a CIP Program number assigned.

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. 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 the report.
CTDS of school of residence	Enter the County Code-Type Code-District Code-Site Number of the school of residence.
CTDS of school of attendance	Enter the County Code-Type Code-District Code-Site Number of the school of attendance.
File format	Choose one of the following from the pop-up menu: CTE Districts – formats the file for CTE districts. JTED Districts – format the file for JTED districts.

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.

This report outputs an excel file.

Item #	Data Element	Description	[Table]FieldName	Length
1	FiscalYear	The End Year of the Fiscal Year. Calculated by adding 1991 to the YearID of the Term at the top of the page. Example: 2017-2018 Term YearID = 27. 27 + 1991 = 2018	Calculated [Terms]YearID	4
2	CTDS	The County Code-Type Code-District Code-Site Number for the school of attendance.	Report Parameter Based on the value entered at runtime in the "CTDS of school of residence" parameter.	9
3	Program Number	The CIP program code.	[S_AZ_CRS_X]CIPProgramNumber	8
4	Student SAISID Number	The student's SAIS ID number.	[Students]State_StudentNumber	10
5	Student Birth Date	The student's date of birth.	[Students]DOB	10
6	Student Last Name	The student's last name.	[Students]Last_Name	30
7	Student First Name	The student's first name.	[Students]First_Name	30
8	Federal/State Indicator	Indicates whether the data is for federal or state submission.	[S_AZ_CC_X]CTEIndicator, if populated Otherwise: 'S'	1
9	Carnegie Units Earned in 2018	The number of Carnegie Units the student earned in 2018. The SUM of all Earned Credit Hours for Historical Grades (StoredGrades) associated with Section Enrollments for Courses having the same Program Number.	Calculated	5
10	Single Parent Status	Indicates if the student comes from a single parent household.	[StudentCoreFields]SingleParentHshldFlag	1
11	Student 504 Status	Indicates if the student is served by Section 504.	[S_AZ_STU_X]SpecialEd504Only	1
12	School of Residence CTDS	The County Code-Type Code-District Code-Site Number for the school of residence. Note: School of Residence CTDS is only reported if JTED Districts is selected at runtime in the "File format" parameter.	Report Parameter Based on the value entered at runtime in the "CTDS of school of attendance" parameter.	9