Section - Section Report
Contents
Introduction
Use the Section - Section report to collect the section information 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 the individual student and the sections for which they are contributing ELA or Math.
Selection Criteria – Section - Section
Selection criteria determine which database records are used in the report. Refer to the selection criteria for analysis when the report does not return the correct records.
The report selects records based on the following criteria:
- All Sections with a start date greater than or equal to the Start Date specified in the Report Input, and an end date less than or equal to the End Date specified in the Report Input, will be selected.
- The Course cannot be set to be excluded from state reporting.
- The School cannot be excluded from state reporting.
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 Input – Section - Section
For help with navigation and running the report, see How to Find and Generate a Report.
Data to be Filled | |
Start Date | Enter the beginning date in the range of dates you want to use to determine the records to include on the report. |
| End Date | Enter the last date in the range of dates you want to use to determine the records to include on the 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 nightly. Check the weekdays only box |
Please Select Schedule Settings | Enter the Start Date and Start Time. Click the Repeat and Daily buttons. |
Please select daily repeat cycle options. | Click the Week days only box. |
Please select end date range option | Click the No End date or you may complete the Ends On field with the day after you last day of school. |
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-Section
Each of the fields displayed in the output of the report is 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 State district code for the reporting district. | [Prefs]District_Number | Text | 2 |
B | SCHCODE | This field contains the State assigned school code. | [S_RI_SCH_X]Ride_ID | Text | 5 |
C | LOCALSECTIONID | This field contains the reported local section ID. It is the ‘sectionid – teacher id’. 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 | [Courses]Course_Number + [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]SectionNumber | Text | 20 |
D | LOCALCOURSEID | The identifier for the course assigned by the local education agency (LEA). If the Course Classification ID = 23002 for a preschool course, the local course ID will be the Service Delivery Module + School Code + Preschool Section ID | [Courses]Course_Number OR [S_RI_CRS_X]Service_Delivery_Model + [Schools]School_Number OR [S_RI_CRS_X]Private_SpecialEd_School + [S_RI_CRS_X]PreSchool_Section_ID | Text | 10 |
E | ROOMNUM | This field contains the room number of the section. | Extracted as Null [Sections]Room | Text | 20 |
F | SECTIONNAME | This field contains the name of the term during which the coursework was completed. This field is optional and will be blank in the output file. | Extracted as Null | Text | 20 |
G | SECTIONTYPE | The type of terms that the section is broken into. See Section Type Codes for more information. | [Terms]Portion | Text | 15 |
H | SECTIONSETTINGID | The setting in which the student is receiving instruction. Valid Options (blank values are set to CLASSROOM)
| [S_RI_SEC_X]Setting | Text | 15 |
I | SECTIONBEGINNINGDATE | The month, day, and year in which the section begins. | [Terms]FirstDay | Date | 10 |
J | SECTIONEDNDINGDATE | The month, day, and year in which the section ends. | [Terms]LastDay | Date | 10 |
K | MINUTESPERMEETING | The number of minutes in one meeting day of the cycle. (Only required for high school) | [Bell_Schedule_Items]Minutes_Attended | Number | 3 |
L | MEETINGDAYSINCYCLE | The number of days (of the total number of days in the cycle) that the section meets. (Only required for high school) | [Sections]Expression | Number | 2 |
M | TOTALDAYSINCYCLE | The total number of days in the cycle. (Only required for high school) | [Terms]Days_Per_Cycle | Number | 2 |
| N | INTCSPROGRAMCODE | The integrated CS4RI computer science code if class is not a standalone computer science course but includes integrated computer science programming. See Integrated Computer Science Program Codes for more information. | [S_RI_SEC_X]Integrated_Comp_Sci_PC | Text | 20 |
| O | CS4RIPARTNERCODE | The CS4RI partner code if standalone computer science class. See Integrated Computer Science Program Code for more information. | [S_RI_SEC_X]Comp_Sci_RI_Partner | Text | 20 |