Skip to main content
Skip table of contents

Master Course Schedule

Contents


Introduction

This report generates the Master Course Schedule of classes, sections, and teachers for each instructional period of the day in a .csv file. The report can be run at the school or district for one building or all buildings. State reporting requires report output for the entire district, however, the school-level version of the report is available for troubleshooting schedule conflicts.

Beginning in the 2019-2020 school year, the previous year state course codes in the State Course Code field are archived in the Courses By Year extension [(S_ID_CBY_X)]. You can run the Master Schedule report for previous years - beginning with 2018-2019 as the previous year - by selecting the applicable school year from the Term drop-down list before running the report. The report checks the Courses By Year extension for archived state course codes for the year in which the report is run.

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.

The report selects records from the [Sections], [Courses], [Terms], [Schools], and [Users] tables based on the following criteria:

  • The sections must include one or more active enrollment records for the sections in-session terms.
  • The sections must be in session during all or part of the reporting period.
  • The sections must not be excluded from state reporting.
  • The courses must not be excluded from state reporting.
  • The student's Course Enrollment Entry Date must fall between the report Start and End Date.
  • ProviderSchool, ProviderSchoolName, ProviderInstructor, and ProviderInstructorName must be filled in on the Section data entry page.
  • At least one student must be enrolled in the section during the reporting period.
  • At least one student enrolled in the section must not be marked as Exclude from State Reporting.

Back to Top

Report Input

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

If you are running the report for a previous year (2018-2019 or later), choose the school year from the Term drop-down list before running the report.

Field

Description

Use

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. This option is only available when running the report from the District Office.


Start Date

Enter a date using the format mm/dd/yyyy or mm-dd-yyyy for the first day of the report date range.

End Date

Enter a date using the format mm/dd/yyyy or mm-dd-yyyy for the last day of the report date range.

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.

Item #

Data Element

Description

[Table]FieldName

Field NameField Path

Field Type

Field Length

1

School Identification

From the Idaho Education Directory, the state school number associated with the LEA School building where the section is to be instructed or associated with.

[Sections]SchoolID

[Schools]Alternate_School_Number



Numeric


2

Course Code

The Idaho state course code that best outlines the particular course section. This code should be the same code used when matching records between Staff Assignments, Student Course Enrollments, and Master Course Schedule files.

[S_ID_SEC_X]CourseCode

[S_ID_SEC_X]AssignmentCode

[S_ID_CRS_X]CourseCode

[Courses]Alt_Course_Number

[Courses]Course_Number

State Course Code Override

Assignment Code

State Course Code


VarChar

6

3

Course Type

The structure and environment for the course.

[S_ID_SEC_X]CourseType

[S_ID_CRS_X]CourseType

ISEE Course Type


VarChar

1

4

Instructional Setting

For Teachers, the typical instructional setting for this class.

[S_ID_SEC_X]InstructionalSetting

[S_ID_CRS_X]InstructionalSetting

Instructional Setting

VarChar

2

5

Minutes per Week

Minutes per week the class is in session. If course is a block schedule class with different times per week (e.g. meets M W F one week and T Th the next), then average the time across the two weeks.

[S_ID_SEC_X]MinsWeek

[S_ID_CRS_X]MinsWeek

[S_ID_SCH_X]MinsWeek

Minutes per Week

Minutes Per Week Course Override

Minutes Per Week School Override


Numeric

11

6

Grade Level

The grade level for which the class content was designed.

See the Appendix for valid values.

[S_ID_SEC_X]GradeLevel

[Sections]Grade_Level

[S_ID_CRS_X]GradeLevel

Content Grade Level


Numeric

2

7

Section Period

The period of the day for the instructional course/ assignment section.

[Sections]Expression



Numeric

10

8

Section Identification

The unique identifier for the specific section of an instructional course/ assignment.

[Sections]ID



Numeric

15

9

Section Alias Name

The district section name associated with the section ID number for the specific section of an instructional course/assignment.

[Section]Course_Number - [Sections]Section_Number



Numeric

50

10

Section Start Date

The date in which the section is to start; matching Staff Assignments and Student Course Enrollments; should not start before this date.

[Sections]TermID

[Terms]FirstDay



Date

10

11

Section End Date

The date in which the section is to end; matching Staff Assignments and Student Course Enrollments; should not end after this date.

[Sections]TermID

[Terms]LastDay



Date

10

12

Provider School

The institution providing instruction of a non-regular course, i.e. virtual or distance learning.

[S_ID_SEC_X]ProviderSchool

Provider School

VarChar

8

13

Provider School Name

The name of the institution providing instruction of a non-regular course, i.e. virtual or distance learning.

Use this for ProviderSchool code 9999 or 0999 option sets.

[S_ID_SEC_X]ProviderSchoolName

Provider School Name

VarChar

50

14

Provider Instructor

The EDUID of the teacher of the course. This is the employee of the provider school. Only applies to non-regular course, for example virtual or distance learning courses.

[S_ID_SEC_X]ProviderInstructor1

Provider Instructor 1

VarChar

10

15

Provider Instructor Name

The Name of the teacher of the course. This is the employee of the provider school. Only applies to non-regular course, for example virtual or distance learning courses.

[S_ID_SEC_X]ProviderInstructor1Name

Use the eduid to link back to [Users]LastFirst

Provider Instructor 1 Name

VarChar

40

Back to Top

JavaScript errors detected

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

If this problem persists, please contact our support.