Section - Course Report | PowerSchool SIS Compliance

Introduction

Use the Section - Course report to collect the course portion of the Teacher Course Student Data Collection.

Required Data Setup

You must define the following information before generating this extract.

Courses must be flagged for ELA or Math Provider.
Sections must have the teacher of record information set as well as any contributing educator information completed.
Contributing Educators must be assigned to an individual student and the sections for which they are contributing ELA or Math.
On the Edit Course (RI Information) page, enter course reporting values in the Rhode Island State Report Information section. Course Level and HS Course Required are active fields in this section and are no longer listed under Obsolete for State Reporting. For courses serving high school grades, select the appropriate Course Level and indicate whether the course is required for a high school diploma:

Code	Course Level
AP	Advanced Placement
BR	Basic or Remedial
EA	Enriched or Advanced
EEP	Early Enrollment Program
GR	General or Regular
H	Honors
X	No Specified Level

For HS Course Required, document the available values as Y (Yes) and N (No).

Selection Criteria – Section - Course

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.
The report selects records based on the following criteria:

All Courses that have associated sections in the school year of the Term the user is logged into in PowerSchool will be selected.
The Course cannot be set to be excluded from state reporting.

Report Input – Section - Course

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

Data to be Filled
School Year	Select the school year for which the report is to be run.
Scheduling Options	Description
Scheduling – Run Now	Leave Run Now selected to run the report now.
Submit	Click Submit to run the report now.
Scheduling – Please Select When to run	Click the Schedule button to schedule this report to run.
Please Select Schedule Settings	Enter the Start Date and Start time. Click the Repeat button.
Please select repeat cycle options.	Choose the applicable option.
Please select end date range option	Enter the appropriate information.
Submit	Click Submit to schedule the report

Districts using the Automated Data Transfer (ADT) system may utilize the SQL script for state reporting purposes provided at the bottom of the report page.

Report Output – Section - Course

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.

Column	Data Element	Description	[Table]FieldName	Field Type	Field Length
A	DISTCODE	This field contains the reporting district code	[Schools]District_Number	Text	2
B	SCHCODE	This field contains the reporting school number.	[S_RI_SCH_X]Ride_ID	Text	5
C	LOCALCOURSEID	The identifier for the course assigned by the local education agency (LEA). If the Course RI Course Classification ID = 23002 is reported as a preschool course and so the local course id will be the Service Delivery Module + School Code + Section ID	[Courses]Course_Number OR [S_RI_CRS_X]Service_Delivery_Model + [S_RI_SCH_X]Ride_ID OR [S_RI_CRS_X]Private_SpecialEd_School + [S_RI_SEC_X]PreSchool_Section_ID	Text	20
D	LOCALCOURSETITLE	The descriptive name given to a course of study offered in a school or other institution or organization.	[Courses]Course_Name	Text	100
E	SCEDCOURSE	The five-digit School Codes for the Exchange of Data (SCED) code and name of the course. The first two digits of the code represent the Secondary Course Subject Area.	[S_RI_CRS_X]Classification_ID	Text	5
F	COURSELEVEL	This field contains the course level of rigor. When GRADESPAN range includes grades 09, 10, 11 or 12, then COURSELEVEL is required. Values include AP, BR, EA, EEP, GR, H, and X.	[S_RI_CRS_X]Course_Level	Text	1
G	HSCOURSEREQUIRED	Indicates whether this course credit is required for a high school diploma: Y (Yes) or N (No). When GRADESPAN range includes grades 09, 10, 11 or 12, then HSCOURSEREQUIRED is required.	[S_RI_CRS_X]HS_Required	Text	1
H	CREDITAVAILABLE	The amount of Carnegie credit available to a student who successfully meets the objectives for courses that carry credit. Available Credit is coded as a one-digit number carried out to two decimal places. (Examples: 1.00, 0.50). When GRADESPAN range includes grades 09, 10, 11 or 12, then CREDITAVAILABLE is required. For grade spans that include grades 09, 10, 11, or 12, the report populates this value from course Credit Hours.	[Courses]Credit_Hours	Text	4
I	GRADESPAN	Identifies the intended grade span for which the course is appropriate and is represented as a four-character code with no decimals. Grade levels are represented by a two-digit code, ranging from 01 to 12; kindergarten is KG, and prekindergarten is PK.	[S_RI_CRS_X]GradeSpan	Text	4