PowerSchool SIS Vermont
PowerSchool SIS Vermont
Breadcrumbs

13_CourseSection

Report Description

This file is used to submit course section information and characteristics. This report produces the CourseSection 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.

Section Selection 

The report selects active Section records from the [Sections] table based on the following criteria: 

  • The Section must not be excluded from state reporting.

  • The Section 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 staff member's employing org ID.

[S_VT_Schools_X]PosID 

String

6 

 3

LOCALCOURSEID

The locally assigned course ID.

[Sections]Course_Number

String

55 

 4

COURSESECTION

Unique Course section ID.

[Sections]Section_Number

String

30

 5

COURSETERM

Code set to identify course term.

[S_VT_SEC_X]CourseTerm

String

6

 6

COURSELEVEL

Code set for course rigor level.

[S_VT_SEC_X]CourseLevel

String

1

 7

COURSELEVELCHARACTERISTIC 

Code set for course character.

[S_VT_SEC_X]CourseLevelCharacteristic 

String

5

 8 

COURSECREDITAVAIL 

The number of available course credits.

[Courses]Credit_Hours  

Number

2,2 

 9

COURSESETTING 

Code set to identify course setting.

[S_VT_SEC_X]CourseSetting  

String

2 

 10

SY

The school year.

[S_VT_District_S]SY

Number

4 

11

FLEXIBLE_PATHWAYS

Flexible pathways

[S_VT_SEC_X]COURSEFLEXIBLEPATHWAYS

String

100

 

Back to top