TX Interchange Master Schedule

Contents

Introduction

This interchange includes information for any school not excluded from state reporting. It is the education organization’s course offering schedule.

Submission 4 Selection Criteria

The following selection criteria determine which database records are used in the Extended Year collection. Refer to selection criteria for analysis when the report does not return the correct records. For submission 4, Section Association records are output only for Dual Credit Summer School Classes.

Section Selection Based on Manual Entry Stored Grades Records for Dual Credit Summer School Classes

The stored grade must be associated with the prior academic year.
The stored grade must not be excluded from 415 reporting.
The stored grade must be associated with a student was been enrolled in the prior school year, or is enrolled in the current year.
The stored grade must be associated with a student who has a PEIMS General record in effect for at least one day in the prior school year.
The stored grade must not be associated with a course or section which is excluded from 090 reporting.
The stored grade must have a summer school Service ID for Dual Credit.
The Special Explanation code for the stored grade must equal R - Course completed in summer school.
The Dual Credit Indicator for the stored grade record must equal 1.
The Alternate CDC Number (if populated) for the stored grade must match a school in the district.

Report Input

Each of the available run options and data fields for the report are described below.

Field	Description
Select Schools	At the District Level: Select All Schools to run the extract for all schools not excluded from state reporting. Select Multiple Schools allows the user to use the Ctrl or SHIFT key on your keyboard to click each school you want to run the extract. At the School Level: Select All Schools to run the extract for all schools not excluded from state reporting. Select Current School Only to run the extract just for the current school.
Collection Code	Choose the Collection from the pop-up menu for the report generated. This option controls the naming of the file. FALL1 is for Submission 1, FALL2 is for Re-Submission, and FALL3 is for Working Collection.
School Year	Choose the school year. This value is used in the file name as well as determining which year to use for the data extraction.
ECDS: Limit to Grade K and/or PK	Choose the appropriate filter to limit the report to students enrolled in kindergarten or preschool. Defaults to No. Note: Only visible for the Summer collection.
Run Now	Select this option to run the report immediately.
Schedule	Select this option to run this report on a scheduled basis. Once this option is selected the following choices are: Run Once Start Date and Start Time to run the report. Repeat Select Daily, Weekly, Monthly or Yearly for the appropriate re-occurrence for running the report. If Daily is selected, check the Weekdays only box to limit to weekdays. If Weekly is selected, check which weekday to run the report. If Monthly is selected, check the month to run the report. If Yearly is selected, select either the date or the weekday to run the report. Date Range – Select No End Date or a date that the re-occurrence should end.

Back to Top

Report Output: XML for PEIMS

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.

Filename for PEIMS:

The filename must be in the following format:

District Code: Position 1-6
Underscore: Position 7, 11, 21 and 34.
Campus ID: Position 8-10 – If the file is generated by a user from the District Office, this value is 000. If the file is generated by a user from a school, this value is the three-digit campus ID for the user. This allows partial files to be submitted that contain data only for one school.
Collection Code: Position 12-20. This starts with the ending year of the school year followed by the five characters Collection Code (i.e. FALL1).
Timestamp: Position 22-33 – This is YYYYMMDDHHMM where YYYY is year, MM is month, DD is day, HH is hour, and MM is minute.
Interchange: Position 35 starts the name of the Interchange – InterchangeMasterScheduleExtension.xml

Note: If the student has records at a Non-Reportable Campus, the student's records are reported under the student's home school of enrollment.

Data Element	Description	[Table]FieldName	Collection
Course Offering – This complex type is repeated for each school and includes any course that has at least one section in the master schedule for the year the report is processed. Courses are excluded if the Alternate Course Number is blank, the Course or Section is coded to Exclude from the 090 records or the service ID is one that is not reported on the 300 record. The id is CO_xxx_ccc_ttt where xxx is the School Number, ccc is the Course Number, and ttt is the TermID. Note: For mixed grade level classes, the report extracts a corresponding Course Offering for each unique grade level. For example, a class with PK, K, 1 & 2 would have four Course Offering records.
	School Reference
	Educational Org Identity
State Organization ID	The County District Campus Number.	[Schools]School_Number [Schools]Alternate_School_Number	SUMMER, EXTENDED YEAR
	Course Reference
Identification System	Hard coded to State Course Code.	N/A
ID	The service ID.	[S_TX_SEC_MIXGRD_C]Service_ID [S_TX_SCH_MIXGRD_C]Service_ID [CoursesCoreFields]Alt_Course_Number	SUMMER, EXTENDED YEAR
Section – This complex type is repeated for each section in the master schedule and any section that needs to be created from a manually entered store grade. Note: For mixed grade level classes, the report extracts a corresponding Section for each unique grade level. For example, a class with PK, K, 1 & 2 would have four Section records.
Unique Section Code	The class ID number.	[S_TX_SEC_X]E1056_ClassID_Override [Sections]Course_Number [Courses]Course_Number [CoursesCoreFields]Alt_Course_Number	SUMMER, EXTENDED YEAR
	Course Offering Reference
	School Reference
Campus ID	The County District Campus Number where section is offered.	[Schools]School_Number [Schools]Alternate_School_Number	SUMMER, EXTENDED YEAR
	Class Period Reference
	Class Period Identity
Class Period Name	The first two digits of the Expression for the section.	[Sections]Expression	SUMMER
State Organization ID	The County District Campus Number associated to this Class Period.	[Schools]School_Number [Schools]Alternate_School_Number	SUMMER, EXTENDED YEAR
TX-School Year	The school year for the section.	[Terms]YearID	SUMMER, EXTENDED YEAR
TX-Population Served	The population served in this section.	[S_TX_SEC_X]E0747_Population_Served [S_TX_CRS_X]E0747_Population_Served	SUMMER
TX-Course Sequence	The course sequence code of the section.	[S_TX_SEC_X] E0948_Course_Seq_Override [S_TX_CRS_X]Course_Sequence	SUMMER, EXTENDED YEAR
TX-Non-Campus Based Instruction Code	The non-campus based instruction code of the section. Note: If this record is for a remote class that is taught at a Non-Reportable Campus, this field defaults to 06, Non-Campus Teacher Providing Instruction at Another District Facility	[S_TX_SEC_X]E1072_Non_Campus_Based_Instr [S_TX_CRS_X]E1072	SUMMER
TX-PKCurricula	The PK Curricula used for this PK section.	[S_TX_SEC_X]E1579_PK_Curricula [S_TX_CRS_X]E1579_PK_Curricula	SUMMER
TX-HighQuality Prek ProgramIndicator	Indicates that the section is part of the High Quality PK Program	[S_TX_SEC_X] E1580_High_Qual_PK_Prog [S_TX_SCH_SCHOOLS_X] E1580_High_Qual_PK_Prog	~~SUMMER~~
TX-Student Instruction	Indicates whether the section is morning, afternoon, or full day PK.	[S_TX_SEC_X] E1558_Student_Instruction	~~SUMMER~~
TX-PK School Type	The type of PK program for this section.	[S_TX_SEC_X]E1555_PK_School_Type	~~SUMMER~~
TX-Program Evaluation Type	The PK program evaluation type for this section. Note: This element is only reported for PK sections.	[S_TX_SEC_X]E1626_Program_Eval_Type [S_TX_SCH_SCHOOLS_X]E1626_Program_Eval_Type [Prefs]E1626_Program_Eval_Type	~~SUMMER~~

Back to Top