Class Roster (Rhode Island)

Classic View: RI State Reporting > Enrollment Census > Class Roster 

Search TermsEnrollment Census

The Enrollment Census Class Roster extract reports data regarding student class enrollment and teacher information. The Enrollment Census Extracts collect various types of student information, including demographics, address and contact information, behavior events and program participation.

Enrollment Census - Class Roster Extract

Report Logic

A record reports for each section a student is scheduled in on or after the calendar Start Date through the Effective Date. If there is more than one teacher assigned to a section, a separate record for each teacher reports. Students who have an Enrollment Status of W (Summer Withdrawal) do not report.

Reporting future dates for Section Exit Date is acceptable.

Generate an Enrollment Census Extract

  1. Select Class Roster from the Extract Type dropdown list. 
  2. Enter an Effective Date in mmddyyyy format or by clicking the calendar icon and selecting a date. 
  3. Select the Format in which the report should generate. Options are CSV and HTML.
  4. If the student's legal name and gender information should report from the Protected Identity Information area, mark the Report Legal Identities checkbox.
  5. Click Generate Extract to generate the report.

Class Roster - CSV Format


Class Roster - HTML Format

Class Roster Report Layout

Data Element

Description

Location

SASID

The Student's unique state assigned student ID.


Numeric, 10 digits

Census > People > Demographics > Person Identifiers > Student State ID


Person.stateID

LASID

The student's unique locally assigned student ID.


Numeric, 16 digits

Census > People > Demographics > Person Identifiers > Local Student Number


Person.student Number

DIST CODE

Identifies the reporting district's code.


Numeric, 2 digits

Student Information > General > Enrollments > State Reporting Fields > Resident District


Enrollment.resident District

SCHCODE

Identifies the school code.


Numeric, 5 digits

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


School.number

LAST NAME

The student's last name.


When the Report Legal Identities checkbox is marked, the student's Legal Last Name reports if a Legal Last Name is entered for that student.


Alphanumeric, 50 characters

Census > People > Demographics > Last Name


Identity.lastName


Census > People > Identities > Protect Identity Information > Legal Last Name


Identity.legalLastName

USID

Identifies the teacher's ID. 


Alphanumeric, 8 characters

Census > District Employment > Employment Information > License Number


Employment.license Number

TEACHER_LAST_NAME

The teacher's last name.


Alphanumeric, 50 characters

Census > People > Demographics > Person Information > Last Name


Identity.lastName

TEACHER_FIRST_NAME

The teacher's first name.


Alphanumeric, 50 characters

Census > People > Demographics > Person Information > First Name


Identity.firstName

TEACHER_MIDDLE_NAME

The teacher's middle name.


Alphanumeric, 50 characters

Census > People > Demographics > Person Information > Middle Name


Identity.middleName

LOCAL SECTION ID

Identifies the section number.


Alphanumeric, 5 characters

Scheduling > Courses > Section > Section ID


Section.sectionID

LOCAL COURSE ID

Identifies the course number. 

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


Alphanumeric, 50 characters

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


Course.number

Course.altStateCode

LOCAL COURSE NAME

Identifies the course name.


Alphanumeric, 50 characters

Scheduling > Courses > Course > Course Editor > Name


Course.name

RI_COURSE_ CLASSIFICATION_ID

Identifies the course's state code.


Alphanumeric, 5 characters

Scheduling > Courses > Course > Course Editor > State Code


Course.stateCode

SECTION_ENTRY_DATE

Identifies the date the student entered the section. The Roster Start Date reports; otherwise, if no Roster Start Date is available, the Start Date of the first term the section is scheduled reports.


Date Field, 10 characters

MM/DD/YYYY

Scheduling > Courses > Section > Roster


Section.startDate

SECTION_EXIT_DATE

Identifies the date the student exited the section. Roster End Date reports; otherwise, if Roster End Date is not available, the End Date of the Last term the section is scheduled reports.


Date Field, 10 characters

MM/DD/YYYY

Scheduling > Courses > Section > End Date


Section.endDate