Section Section TCS Report (Rhode Island)

Classic View: RI State Reporting > TCS Reports > Section Section 

Search Terms: TCS Reports

The Section Section reports lists all active courses for the selected calendar in the Report Editor. All courses marked as active for the selected calendar are included. A SCED or State Code assigned to the course is required.

See the TCS Reports article for information on report logic, descriptions of the fields on the report editor and instructions on generating TCS Reports.

Section Section Report  

Report Logic

Each term sequence reports one of the following codes, depending on the setup of the school calendar and term schedule.

  • YEAR
  • SEM
  • TRI
  • QUART
  • QUIN
  • OTHER

TCS Report Editor

Field

Description

Extract Type

Determines which extract generates.

Prior Reporting Date

Date report information was generated in the past. Dates are entered in mmddyy format or use the calendar icon to select a date.

Effective Date

Date determines what data is reported on the extract. Dates are entered in mmddyy format or use the calendar icon to select a date.

Student Ad hoc Filter

Selection limits the students included in the extract to those in the ad hoc filter.

Course Ad hoc Filter

Selection limits the courses included in the extract to those in the ad hoc filter.

Staff Ad hoc Filter

Selection limits the staff included in the extract to those in the ad hoc fitler.

Format

Determines how the report will generate - in HTML or CSV.

Calendar Selection

Indicates from which calendar and year the data reports. At least one calendar needs to be selected in order to generate the report.

 Generate the Section Section TCS Report

  1. Select Section Section from the Extract Type field.
  2. Enter the Prior Reporting Date.
  3. Enter the desired Effective Date.
  4. Select an Ad hoc Filter, if desired, to narrow the individuals included in the report to just those included in the ad hoc filter.
  5. Select the desired Format.
  6. Click the Generate Report extract. The report displays in the selected format.

Section Section Report - HTML Format  

Section Section Report - CSV Format  

Report Layout

Data Element

Description

Location

District Code

The number assigned to the local education agency by the state education agency.


Numeric, 2 digits

System Administration > Resources > District Information > State District Number


District.stateNumber

School Code

State-assigned school code.


Numeric, 5 digits

System Administration > Resources > School > School Detail > State School Number


School.stateNumber

Local Section ID

Combination of the Course Number and the Section Number.


When the PK Course Number field is populated, the course number value reports from that field.


If the Course Number-Section Number value or the PK course Number-Section Number value is greater than 20 digits, the first 20 digits reports.


Numeric, 20 digits

Scheduling > Courses > Sections > Section > Section Editor > Section Number


Section.number


Scheduling > Courses > Course > Course Information > Number, PK Course Number


Course.number

Course.altStatecode

Local Course ID

Identifier for the course assigned by the local education agency.


When the PK Course Number field is populated, that value reports.


Alphanumeric, 10 characters

Scheduling > Courses > Course > Course Information > Number, PK Course Number


Course.number

Course.altStateCode

Room Number

Reports where the course section meets.


Alphanumeric, 20 characters

Scheduling > Courses > Sections > Section > Section Editor > Room


Section.roomID

Section Name

The name of the section during the school year in which coursework was completed.


Alphanumeric, 20 characters

Scheduling > Courses > Course > Course Information > Name


Course.name

Section Type

A span of time indicating when an education institution is open, instruction is provided and students are under the direction and guidance of teachers and/or the education institution. 


See the Report Logic section for applicable values.


Alphanumeric, 15 characters

System Administration > Calendar > Calendar > Terms


Calendar.term

Section Setting ID

The setting in which the student is receiving instruction. Available options are:

  • Classroom
  • Hybrid
  • Online

Alphanumeric, 15 characters

Scheduling > Courses > Course > Course Information > Course Setting


Course.setting

Section Beginning Date

The date the section begins.

  • If the Section Type is Q4, this field reports the first day of Term 1.
  • If the Section Type is S1, this field reports the first day of Term 1.
  • If the Section Type is S2, this field reports the first day of Term 3.

Date Field, 8 characters (MM/DD/YYYY)

Course > Section > Roster > Start Date


Section.startDate

Section Ending Date

The date the section ends.

  • If the Section Type is Q4, this field reports the last day of Term 4.
  • If the Section Type is S1, this field reports the last day of Term 2.
  • If the Section Type is S2, this field reports the last day of Term 4.

Date Field, 8 characters (MM/DD/YYYY)

Course > Section > Roster > End Date


Section.endDate

Minutes Per Meeting

The duration in minutes the section lasts. Data is reported only if the selected SCED Subject Area is 01-24; otherwise a null value reports.


To report, the SCED Lowest Grade must equal one of the following:

  • 09: Grade 09
  • 10: Grade 10
  • 11: Grade 11
  • 12: Grade 12

A null value reports if the SCED Lowest Grade is any grade level other than grade levels 09-12.


Numeric, 3 digits

System Administration > Calendar > Periods > Period Schedule > Instructional Minutes


Period.periodMinutes

Meeting Days In Cycle

The number of individual sections marked when a section meets. Calculated based on total number of periods selected in the Selection Schedule Placement.


Data is reported only if the selected SCED Subject Area is 01-24; otherwise a null value reports.


To report, the SCED Lowest Grade must equal one of the following:

  • 09: Grade 09
  • 10: Grade 10
  • 11: Grade 11
  • 12: Grade 12

A null value reports if the SCED Lowest Grade is any grade level other than grade levels 09-12.


Numeric, 5 digits

Data not stored

Total Days in Cycle

The total number of possible meeting days in the cycle for a section.


Data is reported only if the selected SCED Subject Area is 01-24; otherwise a null value reports.


To report, the SCED Lowest Grade must equal one of the following:

  • 09: Grade 09
  • 10: Grade 10
  • 11: Grade 11
  • 12: Grade 12

A null value reports if the SCED Lowest Grade is any grade level other than grade levels 09-12.


Numeric, 5 digits

Data not stored

State Program CodeIndicates if the class is not a stand-alone computer science course, but includes integrated computer science programming. Reports the selected code.

Alphanumeric, 20 characters
Scheduling > Courses > Course > State Program Code

Course.stateProgramCode
State Partner CodeIndicates if the class is a stand-alone computer science course. Reports the selected code.

Alphanumeric, 20 characters
Scheduling > Courses > Course > State Partner Code

Course.statePartnerCode