The Master Schedule interchange is used for education organization’s education course offerings schedule.

Screenshot of the TSDS Extract editor with the Master Schedule Interchange option selected. TSDS Extract Editor/Master Schedule Interchange

Report Logic

Click here to expand...

Sections are reported for Grade Levels PK-12. Grade Level EE does not report. All reportable courses offered through the campus of the enrolled students will be reported.

Class Roster Fall - Only reports calendars, courses, sections, teachers and students associated to grades 1-12.

Multiple records will report if the Section has multiple State Codes (Service IDs) within the Roster Batch Edit and the student is actively enrolled in the Section at any point during the current school year.
- All sections completed or attempted by a student in Grade Levels PK-12 as of the last Friday in October AND any new Sections that begin after the last Friday in October will report.
- Sections taught or attempted will report regardless of the method of delivery.
- To report, a Section must have a minimum of one student enrolled for one day on or after the snapshot date or a student who completed the course prior to snapshot.
A Section will not report if all students enrolled have an ADA Eligibility of 0 in all enrollments.
Data will report from the Service Type P enrollment if a student has multiple enrollments, one with a Service Type of P and another with a Service Type of S or N.
- Data will report from a Service Type of S or N as long as all reporting criteria is met and no enrollment exists with a Service Type of 'P'.
- Summer School enrollments will not report.
A Section will not report if any of the following is true for ALL students in the Section:
- Enrollments marked as State Exclude.
- Grade Level marked as State Exclude.
- Calendar marked as State Exclude.
- No State ID.
- Marked as No Show.

Sections will not report if any of the following is true:

State Code (Service ID) of the Course and the State Code Override on the Roster are both blank.
State Report Exclude checkbox is marked on course.
State Code or Course State Code (override) that begin with a SA, SE, SR, SS, 8 or 9 do not report.
There is no Grading Task that has the Display Pass/Fail Credit Code checkbox marked.

Enrollment records will not report if any of the following is true:

ADA Eligibility of 0 or blank on ALL of the student's ADA records.
State Exclude checkbox marked.
In a Grade Level with State Exclude checkbox marked.
Grade Level other than EE.
In a Calendar with State Exclude checkbox marked.
No Show checkbox marked.

Courses with the State Report Exclude option selected on the Courses tab (Scheduling > Courses > Course) do NOT report.

Report Editor

Field

Description

Submission

3 - Summer

4 - Extended

ECDS (Early Childhood Data System)

KG
Pre-K

CR (Classroom Roster)

Classroom Roster Fall (CRF)
Classroom Roster Winter (CRW)

Interchanges

Interchanges are XML Schema Definitions (XSDs) which group related complex types.

Select Master Schedule.

Effective Date

Only data as of this date reports. Default value is today's date.

Status

Regular
Resubmission
Working Collection

Report Type

XML

Filter By

This field allows you to narrow the report results to specific Calendars, Calendar Years (District), or Schools.

Option	Description
Calendar	This option allows you to select the specific calendar(s) to include in the report.
District	This option allows you to select the specific Calendar Year to include in the report.
School	This option allows you to select the specific school(s) to include in the report.

Population

This option allows you to limit report results to Unique IDs. The Unique ID option only considers students with a Unique ID. The All option considers all students.

Ad Hoc Filter

Select an Ad Hoc filter to limit report results to those that meet filter requirements.

Report Generation

The report can be marked to generate immediately using the Generate Extract button or can be marked to generate at a later time using the Submit to Batch button. See the Batch Queue article for additional guidance.

Report Example

Screenshot of an example of the Master Schedule Interchange Submission 3. Master Schedule Interchange Example - Submission 3

XML Elements

Course Offering

Submission 3 only: Complex type will only report for high school courses grades 9-12.

Only students in grades 9-12 will report UNLESS a student in grades 3-8 is taking a course where high school credit is earned.
A course is considered as high school credit if:

The course has a Special Explanation code of J OR the student has a Special Explanation code of J assigned to them in the Roster Batch Edit tool.

XML Element	Description	Location
LocalCourseCode Required	Report CourseID Submission: 3, 4 KG / PK CRF / CRW String, 30 characters	Scheduling > Course/Section > Course Editor
SchoolReference
EducationOrgIdentity > StateOrganizationId Required	Reports the County-District number (6 digits) + State School Number (3 digits) of the campus/school where the employee performs their services. Submission: 3 & 4 KG / PK CRF/CRW Numeric, 9 digits	System Administration > Resources > School > School Detail > State School Number AND State District Number Database: School.number District.number
CourseReference
CourseIdentity > CourseCode / Identification System Required	Reports State Course Code for Submissions 3, 4 and KG. Reports LEA Course Code for Class Roster (CR) and PK. Submission: 3 & 4 KG / PK CRF/CRW	Scheduling > Course/Section > Course
CourseIdentity > CourseCode > ID Required	Indicates the services provided by the staff. If the Title field in the District Assignment record contains a value of 047: Substitute Teacher or 087: Teacher, the State Code reports from the scheduled courses as the Service ID.; however, if there are any students actively enrolled in the Course > Section OR students were actively enrolled with a different Service ID (Roster Batch Edit > Course State code (override)) this field reports the Course State Code (override) as the Service ID. Courses with blank State Codes do not report unless there is a Course State Code (override) in Roster Batch Edit. If both options are blank, the course does not report. A State Code or Course State Code (override) that begins with a SA, SE, SR, SS or 8 does not report. Submission: 3 & 4 Alphanumeric, 8 characters	Scheduling > Course > Section Editor > Roster Batch Editor > Section ID OR Scheduling > Course > Course Editor > State Code Database: Course.stateCode
CourseIdentity > CourseCode > ID Required	Reports CourseID. In instances where a course is reporting multiple times due to a student having a unique Course Code Override value An increasing alpha character will be added at the end of the local course code to create a unique identifier The unique identifier value will match the following local course code instances in the Master Schedule Interchange Course Offering > Local Course Code Section > Local Course Code The unique identifier value will match the following local course code instances in the Education Organization Interchange Course > Identification System > ID Submission: CRW PK / KG String, 30 characters	Scheduling > Course > CourseID

Section

Reporting Logic:

An assigned Primary Teacher (Teacher of Record) with a Role ID of 087 or 047
A section with rostered, reportable students
A grading task with the Pass/Fail Indicator Code checked AND a Code of either CG or F