CTE Student Industry Credential Template

Introduction

This extract generates a comma-delimited file containing industry certifications that students have achieved during the school year.

Selection criteria determine which database records are used in the report.

Student Selection

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

The student must not be excluded from state reporting.
The student must have a school enrollment associated with a school included in the report.
The student’s school enrollment must not be excluded from state reporting.
The student’s school enrollment Exit Date must occur after the report end date.
The student’s school enrollment Entry Date must occur on or before the report end date.
The student is HSDA-flagged.

CTE Student Industry Credential record Selection

The report selects Industry Credential records from the [S_NM_STU_IndustryCred_C] table based on the following criteria:

The Industry Credential record must be associated with a school included in the report.
The Credential Earned Date associated with the Industry Credential record must occur on or after the report start date.
The Credential Earned Date associated with the Industry Credential fact record must occur on or before the report end date.

Report Input

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.
Select Students	Choose one of the following: The Selected [x] 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.
Select Start Date	Enter the start date of the report.
Select End Date	Enter the end date of the report.
Report Mode	Choose one of the following: Extract – Choose this option to run the extract version this report, which includes only the columns/fields required for submission to the state. Audit – Choose this option to run the audit version of this report, which includes only the columns/fields for the purpose of reviewing assessment fact data. Run the audit version of the report to verify data before running the extract version.

Back to Top

Report Output – Audit Version

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	Begin / End Position
1	Student ID	The state assigned student identification number.	[Students]State_StudentNumber [S_NM_STU_IndustryCred_C]foreignKey	N/A
2	Student Last First	The student’s name in Last, First format.	[Students]LastFirst	N/A
3	School ID	The student’s school ID.	[Students]SchoolID	N/A
4	Student Grade Level	The student’s current grade level.	[Students]Grade_Level	N/A
5	Enroll Status	The student’s enrollment status.	[Students]Enroll_Status	N/A
6	Location Code	The PED assigned three-digit school number. The alternate school number field is extracted if populated.	[S_NM_STU_X]LocationCode or, [Students]SchoolID [ReEnrollments]SchoolID Or, [Schools]Alternate_School_Number	N/A
7	Industry Credential Code	The code identifying the industry certification that was earned.	[S_NM_STU_IndustryCred_C]IndustryCredentialCode	N/A
8	Credential Earned Date	The date the industry credential was earned.	[S_NM_STU_IndustryCred_C]CredentialEarnedDate	N/A

Back to Top

Report Output – Extract Version

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	Begin / End Position
1	District Code	PED assigned three-digit district number.	[Prefs]Name=DistrictNumber [Prefs]Value	1/20
2	School Year Date	This value is automatically extracted as June 30^th. The report determines the year by referencing the school year selected for the report input. To change terms, click Terms at the top of the page and choose a term from the list. The value is extracted in the format YYYY-MM-DD.	[Terms]LastDay	21/30
3	Student ID	The state assigned student identification number.	[Students]State_StudentNumber [NM_StuIndustryCred]foreignKey [VirtualTablesData]foreignKey	31/42
4	Location Code	The PED assigned three-digit school number. The alternate school number field is extracted if populated.	[S_NM_STU_X]LocationCode or, [Students]SchoolID [ReEnrollments]SchoolID or, [Schools]Alternate_School_Number	43/54
5	CIP Code	Required for submission to the warehouse. Note: this is always reported as “0”.	N/A	55/61
6	Delivery Method Code	Required for submission to the warehouse.	[S_NM_STU_IndustryCred_C]DeliveryMethodCode	62/73
7	Industry Credential Code	The code identifying the industry certification that was earned.	[S_NM_STU_IndustryCred_C]IndustryCredentialCode	74/85
8	Credential Earned Date	The school year of credential earned. YYYY-06-30	[S_NM_STU_IndustryCred_C]CredentialEarnedDate	86/95
9	Credential Earned Period Level	Provide the period level credential was earned. Note: this is always reported as “DAY”.	N/A	96/105

Back to Top