Path: ID State Reporting > ISEE Extracts
The Master Course Schedule reports section information.
Image 1: Course Master Schedule (ISEE Extract Editor)
Master Course Schedule Report Logic
A record reports for each section that meets the following requirements:
- Section is active on at least one day during the reporting range.
- Course has a Course State Code entered.
- Section being reported is instructional and scheduled during an instructional period in the calendar.
- Section being reported has at least one student actively rostered during the reporting date range.
- Only one record per section reports, even for sections that span multiple terms.
- To report, a section must have at least one rostered student:
- With a Student State ID,
- Enrolled in a grade level mapped to a State Grade Level of NG, PK, KG, or 01-12.
- Whose roster record is active at some point within the section's schedule placement.
Report Editor Field Descriptions
Field | Description |
|---|---|
Report Type | Select Course Master Schedule. The following ISEE extract types are also available: |
Start Date | The earliest date from which data is pulled for the report. (Required) |
End Date | The latest date from which data is pulled for the report. (Required) |
Ad Hoc Filter | This field allows users to use an Ad hoc filter that was created in the Ad hoc Filter Designer. Only one Ad hoc filter may be selected. |
Format | The format in which the report will generate. Options include CSV (State Format) and HTML. |
Select Calendars | The calendar(s) from which data is pulled for the report. Can be set to display only the active year's calendars, or be sorted by school or by year. |
Batch Queue | Users have the option of submitting this report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article. |
Course Master Schedule Extract Layout
Column | Description & Format | Campus Location |
|---|---|---|
| schoolID | The SDE assigned State District Number for the reporting district. Alphanumeric, 4 characters | System Administration > Resources > School > State School Number School.number |
| courseCode | Reports the Course State Code. Alphanumeric, 6 characters | Scheduling > Courses > Course State Code Course.stateCode |
| coursetype | The structure and environment of the course, indicates how student work is expected to be completed and the student's interaction with a teacher or other certificated staff person. Reports the Course Type of the section. Alphanumeric, 1 character | Scheduling > Courses > Section > Course Type Section.courseType |
| setting | Reports the Instructional Setting from the Course, or from the Section if null. Otherwise reports as blank. Alphanumeric, 2 characters | Scheduling > Courses > Course > Instructional Setting; Section > Instructional Setting Course.instructionSetting Section.instructionalSetting |
| minsWeek | The total number of minutes per week the course met. If the Otherwise, reports the full term total of minutes multiplied by the number of instructional days in the Term/s in which the course is scheduled, divided by the number of instructional weeks in the term. Instructional weeks are calculated by the number of instructional days divided by 5. Only whole numbers are used in this calculation. Periods must not be flagged as non-instructional in order to calculate. Numeric, 3 digits | Scheduling > Courses > Course > Course Editor > minsWeek Override System Administration > Calendar > Schedule Structure & Period > Period Info > Start and End Time Calculated, not dynamically stored |
| gradeLevel | Reports the Intended Grade Level of the section. Otherwise, reports the Grade Level from the Course, if null. Alphanumeric, 2 characters | Scheduling > Courses > Section > Intended Grade Level; Courses > Course > Grade Section.intendedGrade Course.grade |
| period | A unique identifier of that describes the course section. This field reports the concatenated names of all periods in which the course is schedule, each separated by a space. For example, if the class is scheduled during periods 01 and 02, reports as 01 02. If the concatenated value exceeds 15 characters, reports the first 15 characters. Alphanumeric, 15 characters | Reports based on System Administration > Calendar > Periods > Name Calculated, not dynamically stored |
| sectionId | Reports the Campus-generated Section ID.This value is displayed in the upper left hand corner of the Section editor. Alphanumeric, 20 characters | Scheduling > Courses > Section > Section ID Section.sectionID |
| sectionAlias | Reports the concatenated Course Name - Section Number Alphanumeric, 50 characters | Scheduling > Courses > Course > Name, Section > Number Course.name Section.number |
| sectionStartDate | Reports the Term Start Date for the first term in which the section meets, based on the Section Schedule Placement. Date field, 10 characters, MM/DD/YYYY | System Administration > Calendar > Calendar > Terms > Term Start Date Term.startDate |
| sectionEndDate | Reports the Term End Date for the last term in which the section meets, based on the Section Schedule Placement. Date field, 10 characters, MM/DD/YYYY | System Administration > Calendar > Calendar > Terms > Term End Date Term.endDate |
| providerSchool | Reports the Provider School. If entered, reports the Provider School Override on the Section. Otherwise reports the Provider School from the Course. Numeric, 5 digits | Scheduling > Courses > Section > Provider School Override; Course > Provider School Course.providerSchool |
| providerSchoolName | Reports the Provider School Name if the Provider School reported as 9999 or 0999. If entered, reports the Provider School Name Override on the Section, or the Provider School Name from the Course if null. Alphanumeric, 50 characters | Scheduling > Courses > Section > Provider School Name Override; Course > Provider School Name Course.providerSchoolName |
| providerInstructor | Reports the Provider Instructor ID entered on the Course for the section of record. Reports without spaces. Numeric, 9 digits | Scheduling > Courses > Course > Provider ID Course.providerID |
| providerInstructorName | Reports the name of the Provider Instructor entered on the Course for the section of record. Reports without spaces or commas. Alphanumeric, 50 characters | Scheduling > Courses > Course > Provider Name Course.providerDisplay |
