Carl Perkins Report

Introduction

This report contains career and technical education (CTE) course data for students. The report collects the data required from school districts with Carl Perkins Career & Technical Education grant funds.

The file name is a concatenation of the letter P, the district number, followed by a period (.), then the letter E and the last two digits of the year from the report end date.

Selection Criteria

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

File 1 Record Selection Student must be in grades 9-12.

Student must not be excluded from state reporting.
Student must have one, or more, course enrollments into a course flagged as vocational.
- [Courses]Vocational = 1
Student must have a stored grade for the vocational course with an earned credit value greater than 0.
- [StoredGrades]EarnedCrHrs > 0

File 2 Record Selection

Student must not be excluded from state reporting.
Student must have a Tech Assessment record for the vocation course enrollment that is pulled in File 1.

Report Input

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

Field	Description
Start Date	Enter the start date for the reporting period.
End Date	Enter the end date for the reporting period.

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.

File 1

Item #	Data Element	Description	[Table]FieldName	Length
A	EED Number	The six-digit number assigned to the school by the EED.	[Students]SchoolID	6
B	Alaska Student Identification Number (ASKID)	The student’s unique state assigned identifier.	[Students]State_StudentNumber	10
C	First Name	The student’s first name.	[Students]First_Name	35
D	Middle Name	The student’s middle name or middle initial.	[Students]Middle_Name	35
E	Last Name	The student’s last name.	[Students]Last_Name	35
F	Birth Date	The student’s date of birth, reported in the format MM/DD/YYYY.	[Students]DOB	10
G	Gender	The student’s gender. Valid values: F – Female M – Male	[Students]Gender	1
H	Single Parent	Indicates whether the student is a single parent, including single parent mothers, pregnant women, and single parent fathers. This value is determined by the Single Parent field on the Alaska State Information page. Valid values: 1 – Yes 0 – No	[S_AK_STU_X]Single_Parent	1
I	Out of Workforce Individual	Indicates whether the student meets one of the following criteria: Has worked primarily without remuneration to care for a home and family and for that reason has diminished marketable skills, or Has been dependent on the income of another family member, but is no longer supported by that income, or Is a parent whose youngest dependent child will become ineligible to receive assistance under part A of title IV of the Social Security Act no later than 2 years after the date on which the parent applies for assistance under this title, and Is unemployed and is experiencing difficulty in obtaining or upgrading employment. This value is determined by the Displaced Homemaker field on the Alaska State Information page. Valid values: 1 – Yes 0 – No	[S_AK_STU_X]Displaced_Homemaker	1
J	Course Number	The local course number for the vocational/CTE course.	[Courses]Course_Number	11
K	Course Credit	The number of high school credits earned by the student for the CTE course during the current school year.	[StoredGrades]EarnedCrHrs	4
L	Earned Postsecondary Credit	Indicates whether the student actually received Postsecondary Credit from an articulated postsecondary institution during the reporting year. If so, this credit should appear on their postsecondary transcript during the reporting year. For example, if 25 students meet the district requirements to pass an “L” CTE course, then report each student in the L column. If 5 of the proficient students actually registered for UA credit and paid their fees, report 1 for each of those students in this column. Valid values: 1 – Yes 0 – N Note: The value at the section level takes precedence. If no value is specified at the section level, then the value at the course level is reported.	[S_SEC_X]Earned_Postsecondary_Credit [S_CRS_X]Earned_Postsecondary_Credit	1
M	Work-Based Learning	Indicates that the student participated in one of the three levels of work-based learning during the reporting year. Valid values: Blank (default value) Level 1 (Career Preparation) Level 2 (Career Training) Level 3 (Both) Note: The value at the section level takes precedence. If no value is specified at the section level, then the value at the course level is reported.	[S_SEC_X]Work_Based_Learning [S_CRS_X]Work_Based_Learning	1
O	School Year	The school year to which the reported data pertains. Format: YYYY-YYYY	Derived from the term at the top of the page	9

File 2

Item #	Data Element	Description	[Table]FieldName	Length
A	Alaska Student Identification Number (ASKID)	The student’s unique state assigned identifier.	[Students]State_StudentNumber	10
B	Course Number	The local course number for the vocational/CTE course.	[Courses]Course_Number	11
C	TSA Code	The technical skill assessment code.	[S_AK_STU_TechAssessment_C] techAssessmentCode	4
D	TSA Attempt	Indicates whether or not the technical skill assessment was attempted. 1 – The assessment was attempted	Always reported as “1”.	1
E	TSA Passed	Indicates whether or not the student passed the technical skill assessment. 1 – Passed 0 – Not passed	[S_AK_STU_TechAssessment_C] techAssessmentPassed	1
F	School Year	The school year to which the reported data pertains. Format: YYYY-YYYY	[S_AK_STU_TechAssessment_C] schoolYear	9