Student Award Fact Template for Non-CTE and Work Based Learning

Contents

Introduction

This template extracts data on student engagement in Work-Based Learning Experiences and Industry-Recognized Credentials Certificates awarded to students.

Selection Criteria

Selection criteria determine which database records are used in the report. For the Student Award Fact Template for Non-CTE and Work Based Learning report, student records are selected and reported for the entire District.

Student Selection

The report selects which student records to use based on the following criteria:

The student must have participated in a Work-Based Learning Experiences or have an Industry-Recognized Credential Certificate.
The student must not be excluded from state reporting.

Report Input

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

Field	Description
Students to Include	Select one of the following: The Selected [number] Students Only – Run the report for students in the current selection. All Students – 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.
Select School Year	From the pop-up menu, choose the year for which the report should be run.
Field Delimiter	Choose the field delimiter for the extract file.
Include Header Labels in output file?	Choose Yes or No to indicate whether to include column headings in the extract file. Including column headers provides a heading for each type of data extracted in the report.

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.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	District Code	The unique, nine-digit Administrative Unit Number assigned by the PDE. This field is extracted from Start Page > District Setup > District Info.	[Prefs]Value where [Prefs]Name=PA_DistrictAUN is populated Otherwise: [Prefs]Value where [Prefs]Name=District_Number	Alpha-numeric	9
2	School Year Date	A single date indicating the whole school year; the June 30 at the end of the standard school year is used to designate a school year. Thus, the 2017-2018 school year would be indicated by 2018-06-30.	Dervied based on the year for which the report is run.	Alpha-numeric	10
3	Student ID	The PAsecureID assigned to the student. This field is extracted from Start Page > Student > State/Province - PA > PA SecureID. Note: If a student has multiple records extracted, it will first sort by Student ID, and then by the award date.	[Students]State_StudentNumber [ReEnrollments]State_StudentNumber	Alpha-numeric	10
4	Award Code	The subgroup that pertains to the credential. See the Appendix for valid values.	[S_PA_STU_NonCTE_WBLE_Award_S]Award_Code	Alpha-numeric	30
5	Award Type	A static value of the Award Type. Always ICN	[S_PA_STU_NonCTE_WBLE_Award_S]Award_Type	Alpha	20
6	Award Date	The date the student earned the award.	[S_PA_STU_NONCTE_WBLE_AWARD_C]Award_Date	Date	10
7	Not Collected	A blank placeholder is extracted.	N/A	N/A	N/A
8	Not Collected	A blank placeholder is extracted.	N/A	N/A	N/A
9	Not Collected	A blank placeholder is extracted.	N/A	N/A	N/A
9	Not Collected	A blank placeholder is extracted.	N/A	N/A	N/A
11	Not Collected	A blank placeholder is extracted.	N/A	N/A	N/A
12	Not Collected	A blank placeholder is extracted.	N/A	N/A	N/A

Back to Top