Career and Technical Education - Student Data File

Contents

Introduction

This report generates the Career and Technical Education – Student Data (CTE Student) collection with the consolidated student file format. The report scans for students who were enrolled for a minimum of twenty school days during the current school year. One row is exported for each student. The report may be run at the district or school level.

This report uses PS_Membership_Defaults, which is a database table. This table provides student membership information for each day that they have an active enrollment on valid in-session school days. It includes potential periods and minutes as well as actual periods and minutes absent.

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.

Student Selection

The report selects records from the [Students] and [ReEnrollments] tables based on the following criteria:

When a selection of students is provided to the report then that selection is used.
When a start date and end date are provided to the report then students with enrollments within the date range are selected for report inclusion.
When a list of entry codes or exit codes is provided to the report then students with enrollments using these entry or exit codes are selected for report inclusion.
The Start Date must be on or before the last day of the current term.
The End Date must be on or after the last day of the last in-session date of the current term.
The Start Date must be before the End Date.

Back to Top

Report Input

To generate the Career and Technical Education – Student Data File, do the following:

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

Field	Description
Select Schools	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	Indicate which students to include in the report by selecting one of the following options: The selected [number] number of 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.
File Name	OR_CTESD_[SchoolID/DistrictNumber]_[Timestamp].csv
Destination	The report defaults to the Reporting Queue.
Scheduling	Choose a time to run the report from following options: Run Now (default) Schedule
Restrict students and their school enrollments to the following Entry Codes (comma-delimited list).	Enter the Entry Code(s) to be used as student selection criteria. Example: E1,E2,R4
Restrict students and their school enrollments to the following Exit Codes (comma-delimited list).	Enter the Exit Code(s) to be used as student selection criteria. Example: G,W1
Conditional Operator	Choose a conditional operator from the pop-up menu: Entry Codes OR Exit Codes Entry Codes AND Exit Codes

Back to Top

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.

This report is a student-level Consolidated Collections report using the “core fields query” to gather student details and assure consistent data submissions to ODE.

SEE THE SSID REPORT OUTPUT FOR A LISTING OF THE CORE ELEMENTS OF THIS STUDENT-LEVEL CONSOLIDATED COLLECTION REPORT.

Row	Column	Field Name	Data Element Name	Width	Data Type	Required	Data Element Description
50	AX	DemogFill	Demographic Filler	11	varchar	N	Reserved for future use.
51	AY	CTEAcdmDsvntgFg	Academically Disadvantaged Flag	1	char	Y	Indicates a student who is academically disadvantaged and requires special services and assistance in order to succeed. May include students who score at or below the 25th percentile on a standardized achievement or aptitude test, who have a high school grade point average (GPA) of less than 2.0 on a 4.0 grade scale, or who fail to attain minimum academic competencies.
52	AZ	CTEYrEndStsCd	Career and Technical Education (CTE) Year End Status Code	1	char	Y	Code indicating the student's status as of the end of the school year.
53	BA	CTEStdntLdrshpOrgnz1Cd	Student Leadership Organization Code 1	1	char	N	Code indicating the first type of Student Leadership Organization to which the student belongs.
54	BB	CTEStdntLdrshpOrgnz2Cd	Student Leadership Organization Code 2	1	char	N	Code indicating the second type of Student Leadership Organization to which the student belongs.
55	BC	CTEStdntLdrshpOrgnz3Cd	Student Leadership Organization Code 3	1	char	N	Code indicating the third type of Student Leadership Organization to which the student belongs.
56	BD	CTEStdntLdrshpOrgnz4Cd	Student Leadership Organization Code 4	1	char	N	Code indicating the four type of Student Leadership Organization to which the student belongs.
57	BE	WBLTypCd1	Work-Based Learning Type Code 1	1	char	Y	Structured learning in the workplace or simulated environment that provides opportunities for sustained interactions with industry or community professionals that foster in depth firsthand experience of the expectations and application of knowledge and skills required in a given career field.
58	BF	WBLHrsCd1	Work-Based Learning Hours Code 1	7	varchar	N	Range of hours that the student engaged in the selected work-based learning type.
59	BG	WBLTypCd2	Work-Based Learning Type Code 2	1	char	Y	Structured learning in the workplace or simulated environment that provides opportunities for sustained interactions with industry or community professionals that foster in depth firsthand experience of the expectations and application of knowledge and skills required in a given career field.
60	BH	WBLHrsCd2	Work-Based Learning Hours Code 2	7	varchar	N	Range of hours that the student engaged in the selected work-based learning type.
61	BI	WBLTypCd3	Work-Based Learning Type Code 3	1	char	Y	Structured learning in the workplace or simulated environment that provides opportunities for sustained interactions with industry or community professionals that foster in depth firsthand experience of the expectations and application of knowledge and skills required in a given career field.
62	BJ	WBLHrsCd3	Work-Based Learning Hours Code 3	7	varchar	N	Range of hours that the student engaged in the selected work-based learning type.
63	BK	WBLTypCd4	Work-Based Learning Type Code 4	1	char	Y	Structured learning in the workplace or simulated environment that provides opportunities for sustained interactions with industry or community professionals that foster in depth firsthand experience of the expectations and application of knowledge and skills required in a given career field.
64	BL	WBLHrsCd4	Work-Based Learning Hours Code 4	7	varchar	N	Range of hours that the student engaged in the selected work-based learning type.
65	BM	IRCCd1	CTE Industry-Recognized Credential Code 1	10	Varchar	N	Industry-recognized Credential Identification Code
66	BN	IRCAdmnDt1	CTE Industry-Recognized Credential Administration Date 1	8	datetime	N	Date the industry-recognized credential test was administered
67	BO	IRCCIPCd1	CTE Industry-Recognized Credential CIP Code 1	6	varchar	N	Code indicating the CIP code associated with the industry-recognized credential taken by the student
68	BP	IRCPassCd1	CTE Industry-Recognized Credential Pass Indicator 1	1	char	N	Code indicating whether the student passed/did not pass the credential
69	BQ	IRCCd2	CTE Industry-Recognized Credential Code 2	10	Varchar	N	Industry-recognized Credential Identification Code
70	BR	IRCAdmnDt2	CTE Industry-Recognized Credential Administration Date 2	8	datetime	N	Date the industry-recognized credential test was administered
71	BS	IRCCIPCd2	CTE Industry-Recognized Credential CIP Code 2	6	varchar	N	Code indicating the CIP code associated with the industry-recognized credential taken by the student
72	BT	IRCPassCd2	CTE Industry-Recognized Credential Pass Indicator 2	1	char	N	Code indicating whether the student passed/did not pass the credential
73	BU	WBLCIPCd1	CIP Code For WBL Cd 1	6	char	N	Code indicating the CIP code associated with the CTE WBL taken by the student for WBL Cd 1
74	BV	WBLCIPCd2	CIP Code For WBL Cd 2	6	char	N	Code indicating the CIP code associated with the CTE WBL taken by the student for WBL Cd 2
75	BW	WBLCIPCd3	CIP Code For WBL Cd 3	6	char	N	Code indicating the CIP code associated with the CTE WBL taken by the student for WBL Cd 3
76	BX	WBLCIPCd4	CIP Code For WBL Cd 4	6	char	N	Code indicating the CIP code associated with the CTE WBL taken by the student for WBL Cd 4
77	BY	CTEFill	Career and Technical Education (CTE) Filler	20	varchar	N	Reserved for future use.

Back to Top