Skip to main content
Skip table of contents

Class Roster File

Contents

Introduction

This report includes a record for the student who enrolled in a section for 10 or more days within the reporting period. The report includes school, course, section, student, and teacher identifiers, along with the start and end dates for student course enrollments and teacher instruction.  If a co-teacher is assigned to the section, a row will be returned for the lead teacher, as well as any co-teachers with the role Reference Code set to “OR”.

Selection Criteria

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.

Sections Selection

The report selects records from the [Sections] table based on the following criteria:

  • One record should be reported for each student who enrolled in the section for 10 or more days.
  • The section must be assigned a term with dates within the reporting period.
  • The course must not be excluded from state reporting.

Back to Top

Report Input

To generate the Class Roster File, do the following:

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

Field

Description

Select Schools*

Choose one of the following:

  • Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.
  • All Schools – Includes all student records on the PowerSchool server that meet selection criteria.

Note: The All Schools option is only available when running the report from the District Office.

Students to Include*

Indicate which students to include in the report by selecting one of the following options:

  • The selected [number] number of students only – Run the report for students in the current selection.
  • All Students (Default) – Run the report for all students in the current school or district that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students prior to running report.

Report Start Date*

Enter the first day of the reporting period.

Report End Date*

Enter the last day of the reporting period.

Include Instructional Minutes? (Optional)

If yes, returns the value stored for the course the InstrctMinCnt field. ([S_OR_CRS_X]SchdldInstrctMinCnt)

File Name

OR_ClassRoster_[SchoolID/DistrictNumber]_[Timestamp].csv

Destination

The report defaults to the Reporting Queue.

Scheduling

Choose a time to run the report from following options:

  • Run Now (default)
  • Schedule

Back to Top

Report Output

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

Data Type

Field Length

A

Instructional Unit Identifier (IUID)

ODE assigned Instructional Unit Identifier (IUID) with a trailing check digit.

[S_OR_SEC_X]InstrctUnitID

int

10

B

District Institution Identifier

The district number. ODE Institution Identification number for the ESD or District administering the program or school in which the class being reported is situated. Institution ID numbers can be found at: <http://www.ode.state.or.us/instid/>.

[Prefs]Value where [Prefs]Name=districtnumber

int

10

C

School Institution Identifier

The school number. ODE Institution Identification number for the program or school where the class being reported is conducted. Institution ID numbers can be found at: <http://www.ode.state.or.us/instid/>.

Note: The alternate school number is reported, if populated. Otherwise, the school number is reported.

[Schools]Alternate_School_Number

[Schools]School_Number

int

10

D

School Section Identifier

The section number. Identifier that distinguishes the specific instance of a class being reported.  This identifier can be any convention used by the institution.

[Sections]Section_Number

varchar

15

E

School Course Identifier

The course number. This is the local identifier, assigned by the district, used to uniquely identify the course.

[Sections]Course_Number

varchar

15

F

Course Code

The alternate course number. This is the National Center for Education Statistics (NCES) or Non-NCES code for the course that is taught in the location identified by the combination of Class Room ID and Class Period.

[Courses]Alt_Course_Number

varchar

6

G

Course Begin Date

Date the course started.

[Sections]TermID

[Terms]FirstDay

varchar

8

H

Secure Student Identifier (SSID)

ODE assigned Secure Student Identifier (SSID) with a trailing check digit.

[Students]State_StudentNumber

int

10

I

District/Local Student Identifier

Identifier, assigned by the district, used to uniquely identify the student.

[Students]Student_Number

varchar

10

J

Student Partial Social Security Number

Last four (4) digits of the Social Security Number of the student.

[Students]SSN

varchar

4

K

Student Legal Last Name

Legal last name of the student.

[Students]Last_Name

varchar

50

L

Student Date of Birth

Date the student was born.

[Students]DOB

varchar

8

M

Student Gender Code

Code indicating the gender of the student.

[Students]Gender

char

1

N

Unique Staff Identifier

ODE Unique Staff Identifier.

[S_OR_USR_X]UniqueStaffID

int

10

O

Employer Staff Identifier

The teacher number. Identifier assigned by the employer used to identify the staff member.  This identifier should be unique within the employer system that assigned it.

[Users]TeacherNumber

varchar

10

P

Teacher Partial Social Security Number

Last four (4) digits of the Social Security Number of the teacher.

[Users]SSN

varchar

4

Q

Teacher Legal Last Name

Legal Last Name of the teacher.

[Users]Last_Name

varchar

50

R

Teacher Date of Birth

Date of Birth of the teacher.

[UserCoreFields]DOB

varchar

8

S

Teacher Gender Code

Code indicating the gender of the teacher.

[UserCoreFields]Gender

char

1

T

Position Code

Code describing the position filled by the staff member, or the function most similar to the staff member's duties.

[S_OR_SSF_X]PositionCode

char

2

U

Instructional Minutes Count

Total instructional minutes the teacher provided to the student during the course.

N/A

int

6

V

Student Start Date

The student’s first day in the section. Date the student began receiving instruction for the IUID. This date should not account for temporary absences of the student. This date may, or may not, coincide with the IUID begin date depending on whether or not the student attended the full length of the course.

[CC]DateEnrolled

varchar

8

W

Student End Date

Date the student stopped receiving instruction for the IUID. This date should not account for temporary absences of the student. This date may, or may not, coincide with the IUID begin date depending on whether or not the student attended the full length of the course.

[CC]DateLeft

varchar

8

X

Teacher Start Date

Date the teacher began administering instruction for the IUID. This date should not account for temporary absences of the teacher. This date may, or may not, coincide with the IUID begin date depending on whether or not the teacher taught the full length of the course.

[Sections]TermID

[Terms]FirstDay

varchar

8

Y

Teacher End Date

Date the teacher stopped administering instruction for the IUID. This date should not account for temporary absences of the teacher. This date may, or may not, coincide with the IUID begin date depending on whether or not the teacher taught the full length of the course.

[Sections]TermID

[Terms]LastDay

varchar

8

Z

Classroom Identifier

Identifier that distinguishes the specific location, usually a classroom, where the class being reported is conducted. This identifier can be any convention used by the institution. 

[Sections]Room

varchar

20

AA

Class Period

Identifier that distinguishes the unit of time set aside for the instructional activities of the class being reported. This identifier can be any convention used by the institution. 

[Section]Expression

varchar

20

AB

Low Grade Responsibility Code

Code indicating the lowest grade level the position is responsible for. In the case of teachers, this represents the lowest grade the teacher actually teaches. In the case of administrators, this represents the lowest grade served by the institution.

[S_OR_SEC_X]LoGrdCd

[S_OR_CRS_X]LoGrdCd

[S_OR_SEC_X]HiGrdCd

[S_OR_CRS_X]HiGrdCd

[SECTIONS]grade_level

char

2

AC

High Grade Responsibility Code

Code indicating the highest grade level the position is responsible for. In the case of teachers, this represents the highest grade the teacher actually teaches. In the case of administrators, this represents the highest grade served by the institution.

[S_OR_SEC_X]HiGrdCd

[S_OR_CRS_X]HiGrdCd

[S_OR_SEC_X]LoGrdCd

[S_OR_CRS_X]LoGrdCd

[SECTIONS]grade_level

char

2

AD

Class Roster Filler

Reserved for future use.

N/A

varchar

20

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.