Scheduling Components (Oregon)

Tool Search: Course Information

The Course Information and Course Section tools contain fields specific to the state of Oregon. These fields can be used for district-tracking purposes or may directly affect state reporting. The information below further defines these state-specific fields to provide guidance in entering data.

The same fields display on the Course Master editor and Course editor.

Course Fields

The Course editor contains information about courses attached to this calendar or school. 

Screenshot of the Course Information editor for Oregon, with specific fields highlighted. Course Information Editor

Exclude from State Reporting

When marked, Indicates the course (and course master) is excluded from all state reports that collect course information.

Click here to expand...

Database Location:

Course.stateReportExclude

Ad Hoc Inquiries:

Course > Course Information > stateReportExclude (courseInfo.stateReportExclude)

Reports:

Instructional Unit Identifier (IUID) Extract

CTE Course

Indicates the course is a Career/Technical Education Course. 

Click here to expand...

Database Location:

Course.cteIndicator

Ad Hoc Inquiries:

Course > Course Information > cteIndicator (courseInfo.cteIndicator)

Reports:

CTE Course File

CTE Student File

Alternative Ed

Indicates the class is taught in an alternative education setting.

Click here to expand...

Database Location:

Course.alternativeEd

Ad Hoc Inquiries:

Course > Course Information > alternativeEd (courseInfo.alternativeEd)

Reports:

Instructional Unit Identifier (IUID) Extract

Class Type

Defines special class types used in state reports. 

On the Class Roster file, courses with a Class Type of the following are not included:

  • PKC: Pre-Kindergarten Course
  • CCC: Community College Course
  • COLL: College Course
  • UNIV: University Course

Click here to expand...

CodeDescription
PKCPre-Kindergarten Course
HTCHome-Tutorial Course
CCCCommunity College Course
COLLCollege Course
UNIVUniversity Course
LCTCLong-Term Care and Treatment Programs

Database Location:

Course.specialCode

Ad Hoc Inquiries:

Course > Course Information > specialCode (courseInfo.specialEdCode)

Reports:

Class Roster File

Staff Assignment File

Special Ed

Indicates the section is taught in a special education setting where the instruction is specifically designed to the unique needs of students with disabilities.

Click here to expand...

Database Location:

Course.specialEd

Ad Hoc Inquiries:

Course > Course Information > specialEdCode (courseInfo.specialEdCode)

Reports:

Instructional Unit Identifier (IUID) Extract

Course Section Fields

The Section editor lists all sections for the selected course and basic identifying information about that section - the assigned primary teacher, where the section meets, in what term and for what period, and how many students are in each section.

Scheduling staff, principals, counselors, etc. can use the tools available in this view to manage course section information - entering grades, creating rosters, recording attendance, etc.

Screenshot of the Course Section Editor for Oregon, with specific fields highlighted.Course Section Editor

Instructional Unit ID

Unique identifier of the course section. This value is assigned by the Oregon Department of Education when the IUID Collection is submitted. This value is reported in the Staff Assignment and Class Roster collections, allowing for consistency between collections/state reports. 

Click here to expand...

Database Location:

Section.stateCode

Ad Hoc Inquiries:

Course > Section Information > stateCode (sectionInfo.stateCode)

Reports: 

Instructional Unit Identifier (IUID) Extract

Instructional Unit Identifier (IUID) Import

Alternative Ed (Override)

Indicates the class is taught in an alternative education setting. When the Alternative Ed field on the Course Information editor is populated, a value does not need to be selected on the Section editor. When the Course field is not populated, but a particular section of that course is for alternative education, this field should be set to Yes.

Click here to expand...

Database Location:

Section.alternativeEd

Ad Hoc Inquiries:

Course > Section Information > alternativeEd (sectionInfo.alternativeEd)

Reports: 

Instructional Unit Identifier (IUID) Extract

Special Ed (Override) 

Indicates the section is taught in a special education setting where the instruction is specifically designed to the unique needs of students with disabilities. When the Special Ed field on the Course Information editor is populated, a value does not need to be selected on the Section editor. When the Course field is not populated, but a particular section of that course is for special education, this field should be set to Yes. 

Click here to expand...

Database Location:

Section.specialEdCode

Ad Hoc Inquiries:

Course > Section Information > specialEdCode (sectionInfo.specialEdCode)

Reports: 

Instructional Unit Identifier (IUID) Extract

Multiple Teacher

A coded value representing the Multiple Teacher Code. A Multiple Teacher Instruction Strategy is a category describing the strategy used when there is more than one Teacher teaching a Class.

Click here to expand...

Database Location:

Section.multipleTeacherCode

Ad Hoc Inquiries:

Course > Section Information > multipleTeacherCode (sectionInfo.multipleTeacherCode)

Reports:

Staff Assignment

Section Staff History Fields

Staff History tracks the history of teachers for a particular course section and lists active primary teachers, teachers, and section staff in addition to former primary teachers, teachers, and section staff. All other fields in the Staff History tab do not require unique, state-specific data. However, many of these fields are required and data entry in these fields may be necessary. For more information on these fields, see the Staff History article.

Screenshot of the Section Staff  History tool for Oregon schools.Section Staff History

Certification Level

Indicates the staff person has emergency or provisional credentials to lead the classroom. These values report in the following fields on the Staff Assignment Report:

  • Emergency/Provisional Determination Flag
  • Out of Field Determination Flag
  • Preliminary Determination Flag

Click here to expand...

CodeDefinition
EPAEmergency/Provisional - TSPC License Determination Flag changed by ODE from N to Y
EPDEmergency/Provisional - TSPC License Determination Flag changed by ODE from X to N
EPBEmergency/Provisional - TSPC License Determination Flag changed by ODE from X to Y
EPCEmergency/Provisional - TSPC License Determination Flag changed by ODE from Y to N
EPXEmergency/Provisional - TSPC Record NOT Found for this Staff Member
EPTeacher has an Emergency or Provisional license for this course
OOTeacher is determined to be Out of Field for this course
OOXOut of Field - TSPC Record NOT Found for this Staff Member
OOAOut of Field - TSPC License Determination Flag changed by ODE from N to Y
OOBOut of Field - TSPC License Determination Flag changed by ODE from X to Y
OOCOut of Field - TSPC License Determination Flag changed by ODE from Y to N
OODOut of Field - TSPC License Determination Flag changed by ODE from X to N
PrelimTeacher is holding a Preliminary License for this course
PrelimXPreliminary License - TSPC Record NOT Found for this Staff Member
PrelimAPreliminary License - TSPC License Determination Flag changed by ODE from N to Y
PrelimBPreliminary License - TSPC License Determination Flag changed by ODE from X to Y
PrelimCPreliminary License - TSPC License Determination Flag changed by ODE from Y to N
PrelimDPreliminary License - TSPC License Determination Flag changed by ODE from X to N

Database Location:

SectionStaffHistory.certificationLevel

Ad Hoc Inquiries:

Not Available

Reports: 

Staff Assignment

Role

Defines the type of position the staff member holds in a specific class/section. 

A teacher must have a Role assigned on the Section Staff History editor that is NOT NSR or blank.

Click here to expand...

CodeDefinition
TORTeacher of Record
TMTTeam Teacher
LTSLong-Term Substitute
STSShort Term Substitute
STUStudent Teachers
COLCollege Instructor/Professor
NSRNot State Reported

Database Location:

SectionStaffHistory.role

Ad Hoc Inquiries:

Course/Section Data Type) Course > Section Information > Staff History Role (staffhistory.role)

Reports: 

Staff Assignment