Section - Student Report

Contents

Introduction

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

Selection Criteria – Section - Student

Selection criteria determines 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 Student class enrollment records whose date enrolled is greater than or equal to the Start Date specified by user and is less than or equal to the End Date specified by the user will be will be selected.
The student cannot be excluded from state reporting.
The Course cannot be set to be excluded from state reporting.

Back to Top

Report Input – Section - Student

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

Data to be Filled
Select Schools	If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Select Students	The default option is All students. Use The xxx Selected Students to extract by a user-defined filtered student selection.
Start Date	Enter the Start Date for this report
End Date	Enter the End Date for this report
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-Student

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.	[Prefs]District_Number	Text	2
B	SCHCODE	Local School Id.	[S_RI_SCH_X]Ride_ID	Text	5
C	LOCALSECTIONID	This field contains the reported section id. It is the ‘SectionID – Teacher Number’. For example, ‘1000-100’. If the Course Classification ID = 23002 for a preschool course, the local section ID will be the Service Delivery Module + School Code + Preschool Section ID + Section Number	[Sections]ID +[SchoolStaff]ID OR [S_RI_CRS_X]Service_Delivery_Model + [Schools]School_Number OR [S_RI_CRS_X]Private_SpecialEd_School + [S_RI_SEC_X]PreSchool_Section_ID + [Sections]Section_Number	Text	50
D	SASID	A 10-digit unique numeric ID assigned to each student in R.I. by the State.	[Students]State_StudentNumber	Text	10
E	LASID	This field contains the locally assigned student number.	[Students]Student_Number	Text	16
F	LASTNAME	The last name of the student as noted on the General Demographics page, Start Page > Student Selection > General Demographics, or if the legal last name is populated on the Rhode Island State Information page, Start Page > Student Selection > Rhode Island State Information.	[Students]Last_Name OR [StudentCoreFields]PSCore_Legal_Last_Name	Text	20
G	SECTIONENTRYDATE	The month, day, and, year in which a student enrolled into a course.	[CC]DateEnrolled	Date
H	SECTIONEXITDATE	The month, day, and, year in which a student exited into a course.	[CC]DateLeft	Date

Back to Top