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 Name	Field 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