Class Schedule File

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

 #

Column

Field Name

Data Element

 Description    

Data Type

Required

1

A 

ChkDigitInstrctUnitID

Instructional Unit Identifier (IUID)

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

int

Y

2

B

DistInstID

District Institution Identifier

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/>.

int

Y

3

C

SchlInstID

School Institution Identifier

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/>.

int

Y

4

D

CrsCd

Course Code

The National Center for Education Statistics (NCES) School Courses for the Exchange of Data (SCED) code for the course that is being taught in the location identified by the combination of classroom ID and class period.

varchar

Y

5

E

ChkDigitStdntID

Secure Student Identifier (SSID)

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

int

Y

6

F

StdntLglLNm

Student Legal Last Name

Legal last name of the student.

varchar

Y

7

G

ChkDigitStfID

Unique Staff Identifier

ODE Unique Staff Identifier.

int

Y

8

H

StfLNm

Teacher Legal Last Name

Legal Last Name of the teacher.

varchar

Y

9

I

PstnCd

Position Code

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

varchar

Y

10

J

StdntStrtDtTxt

Student Start Date

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.

varchar

Y

11

K

StdntEndDtTxt

Student End Date

The first weekday following the last day of enrollment in the class. This date should not account for temporary absences of the student. This date may, or may not, coincide with the IUID course end date depending on whether or not the student was enrolled through the end of the course.

varchar

Y

12

L

TchrStrtDtTxt

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.

varchar

Y

13

M

TchrEndDtTxt

Teacher End Date

The first weekday following the last day the teacher administered 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 course end date depending on whether or not the teacher taught through the end of the course.

varchar

Y

14

N

ClsRmID

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.  

varchar

Y

15

O

ClsPrd

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.  

varchar

Y

16

P

ClsSchdFill

Class Schedule Fill

Reserved for Future Use

varchar

N