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