12_Course

Contents

Report Description

This file is used to submit information about courses offered by school. This report produces the Course extract for current school year in a comma-delimited format.

Selection Criteria

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

Course Selection

The report selects active Course records from the [Courses] table based on the following criteria:

The course must not be excluded from state reporting.
The course must be active at the school

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.
File Path	Enter the file path. If applicable, select the associated checkbox to save as the default value.
Data Collection Name	Choose the applicable Data Collection from the pop-up menu. 03_NightlyCollection_Unofficial 04_YearEndCollection_Official 07_SpringOfficial
SFTP Connections	Choose a selection from the pop-up menu. The default value is Disable.

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	ADMINID	The district's SU/SD ID.	[S_VT_District_S]AdminID	String	6
2	POSID	The place of service ID.	[S_VT_Schools_X]PosID	String	6
3	LOCALCOURSEID	The locally assigned course ID.	[Courses]Course_Number	String	55
4	COURSECODE	SCED Course code.	[CoursesCoreFields]Alt_Course_Number	String	5
5	COURSENAME	The course name.	[Courses]Course_Name	String	255
6	ADDIT_COURSECAT	Additional course category.	[S_VT_CRS_X]Addit_CourseCat	String	30
7	SY	The school year.	[S_VT_District_S]SY	Number	4

Back to top