TX Interchange Education Organization

Contents

Introduction

This interchange includes information for the district and any school that is not excluded from state reporting.

Submission 4 Selection Criteria

The following selection criteria determine which database records are used in the Extended Year collection. Refer to the selection criteria for analysis when the report does not return the correct records. For submission 4, records are output for the district and each school. Records are included in the Courses complex type only for Dual Credit Summer School Classes.

Course 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 who was 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.

Residential Facility

The district must have at least one Residential Facility.
The Residental Facility must have at least one student with an RFT Special Program in effect for the current school year.

Report Input

Each of the available run options and data fields for the report is 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 and any school that has been defined as 701, 702, 703, 720, 750, 751, 998 or 999. 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. If the report is run for specific schools only, the courses for those schools are included in the Course complex type. 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, FALL3 is for Working Collection, SUMR1 is for Submission 3, SUMR2 is for Re-Submission, and SUMR3 is for the Working Collection. The MDYR1, MDYR2, and MDYR3 options are for the Mid-Year collections. The TSDS - RFT option includes the Residential Facility Extension.
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.
October Snapshot Date	Enter the October snapshot date. This field is available only for FALL collections.
ECDS: Limit to Grade K and/or PK	Choose whether to limit the report to K or Pre-K only. This field is available only for SUMR collections.
Crisis Data Submission	Select to run the report based on crisis data.
Run Now	Select this option if the user wants to run the report immediately.
Schedule	Select this option if the user wants 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.

Report Output

Each of the fields displayed in the output of the report is described below.

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 that 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 (for example, FALL1). The collection code used for TSDS - RFT is TSDS.

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 – InterchangeEducationOrganizationExtension.xml

XML for PEIMS

Data Element	XML Name	Description	[Table]FieldName	Collection
Local Education Agency Complex The ID reference is LEA_1.
DISTRICT-ID	StateOrganizationId	The ID number of the district.	[Prefs]DistrictNumber	FALL, MID YEAR, SUMMER, EXTENDED YEAR, TSDS - RFT
SHORT-NAME-OF-INSTITUTION	ShortNameOfInstitution	The name of the LEA.	[Prefs]DistrictName	FALL, MID YEAR, SUMMER, EXTENDED YEAR
	Organization Categories
Organization Category	OrganizationCategory	Hardcoded to 'Local Education Agency'.	Hardcoded to 'Local Education Agency'.	FALL, MID YEAR, SUMMER, EXTENDED YEAR
TOTAL-NUM-SCHOOL-BOARD-REQUESTS	TX-TotalNumSchoolBoardRequests	The total number of requests the school board received for information outside of regular board meetings for the school year.	[Prefs]E1556	SUMMER
TOTAL-COST-SCHOOL-BOARD-REQUESTS	TX-TotalCostSchoolBoardRequests	The total cost in whole dollars to the district for gathering information outside of regular board meetings for the school year.	[Prefs]E1557	SUMMER
FAMILY-ENGAGEMENT-PLAN-LINK	TX-FamilyEngagementPlanLink	The LEA website that identifies the information required for the High-Quality PK Program.	[Prefs]E1577_ThirdCase	~~SUMMER~~
ARMED-SERVICES-VOC-APT-BATTERY-INDICATOR-CODE	ArmedServicesVocAptBatteryIndicator	Indicates if the LEA provides students in grades 10 through 12 the opportunity to take the Armed Services Vocational Aptitude Battery (ASVAB) test or a comparable substitute. Valid values: 00 - District does not offer ASVAB or alternative career exploration test 01 - District offers ASVAB 02 - District offers alternative career exploration test	[PS_Common_Code]Code	FALL
	TX-ProgramsOfStudy Complex Type
PROGRAM-OF-STUDY	TX-ProgramOfStudy			FALL
	TX-GiftedTalentedPrograms Complex Type
GIFTED-TALENTED-PROGRAM-CODE	TX-GiftedTalentedProgramCode			FALL
School Complex - This complex type is repeated for each school not excluded from state reporting. The id reference is SCH_xxx where xxx is the School Number.
CAMPUS-ID	StateOrganizationId	The County-District-Campus number for the school.	[Schools]School_Number	FALL, MID YEAR, SUMMER, EXTENDED YEAR, TSDS - RFT
SHORT-NAME-OF-INSTITUTION	ShortNameOfInstitution	The name of the school.	[Schools]Name	FALL, MID YEAR, SUMMER, EXTENDED YEAR, TSDS - RFT
	Organization Categories
Organization Category	OrganizationCategory	Hardcoded as 'School'.	Hardcoded as 'School'.	FALL, MID YEAR, SUMMER, EXTENDED YEAR, TSDS - RFT
	Local Education Agency Reference
	Educational Org Identity
DISTRICT-ID	StateOrganizationId	The ID number of the district.	[Prefs]DistrictNumber	FALL, MID YEAR, SUMMER, EXTENDED YEAR, TSDS - RFT
CAMPUS-ENROLLMENT-TYPE-CODE	TX-CampusEnrollmentType	The method by which the campus draws student enrollment.	[S_TX_SCH_SCHOOLS_X]E1641_Campus_Enroll_Type	FALL
NSLP-TYPE-CODE	TX-NSLPTypeCode	The school's national school lunch participation type. See 2022-09-05_09-25-50_NSLP Type Codes for valid values.	[S_TX_SCH_SCHOOLS_X]E1581_NSLP_Code	SUMMER, TSDS - RFT
PK-FULL-DAY-WAIVER-INDICATOR-CODE	TX-PKFullDayWaiver	Indicates whether the campus has received an exemption from offering a full-day prekindergarten program		SUMMER
ADDITIONAL-DAYS-PROGRAM-INDICATOR-CODE	TX-AdditionalDaysProgramIndicator	Indicates whether the campus offers additional days of instruction to any students in prekindergarten through fifth grades	[S_TX_SCH_SCHOOLS_X] E1671_ADSY_Indicator	EXTENDED YEAR
EXPANDED-LEARNING-OPPORTUNITY-INDICATOR-CODE	TX-ExpandedLearningOpportunityIndicator	The campus offers an expanded learning opportunity (ELO)		SUMMER, EXTENDED YEAR
	TX-SchoolELO
ELO-TYPE-CODE	TX-ELOType	Indicates the type of expanded learning opportunity (ELO) program offered at the campus	[S_TX_SCH_ELO_C] E1614_ELO_Type	SUMMER, EXTENDED YEAR
ELO-MINUTES-SCHEDULED-PER-DAY	TX-ELOMinutesScheduledPerDay	Indicates the number of minutes scheduled for an Expanded Learning Opportunity (ELO) each day	[S_TX_SCH_ELO_C] E1621_ELO_Minutes [S_TX_SCH_ELO_C] E1621_ELO_ACADSUPP_MIN [S_TX_SCH_ELO_C] E1621_ELO_EDENRICH_MIN [S_TX_SCH_ELO_C] E1621_ELO_MENTOR_MIN [S_TX_SCH_ELO_C] E1621_ELO_PHYSACT_MIN [S_TX_SCH_ELO_C] E1621_ELO_RIGCOURSE_MIN [S_TX_SCH_ELO_C] E1621_ELO_TUTOR_MIN	SUMMER, EXTENDED YEAR
ELO-RIGOROUS-COURSEWORK-INDICATOR-CODE	TX-ELORigorousCourseworkIndicator	The campus offers an expanded learning opportunity (ELO) identified as rigorous coursework. Rigorous coursework is defined as a TEKS-aligned and credit-earning course, including dual credit and credit recovery activities	[S_TX_SCH_ELO_C] E1615_ELO_Rig_Coursework	SUMMER, EXTENDED YEAR
ELO-MENTORING-INDICATOR-CODE	TX-ELOMentoringIndicator	The campus offers an expanded learning opportunity (ELO) identified as mentoring. Mentoring is defined as scheduled interaction between a trained adult and a specific student in which the adult provides support and life skills to help the student’s personal and academic development.	[S_TX_SCH_ELO_C] E1616_ELO_Mentoring	SUMMER, EXTENDED YEAR
ELO-TUTORING-INDICATOR-CODE	TX-ELOTutoringIndicator	The campus offers an expanded learning opportunity (ELO) identified as tutoring. “Tutoring” is defined as one-on-one or small group, led by a certified teacher that provides content instruction or homework help. Tutoring does not include academic skill building activities	[S_TX_SCH_ELO_C] E1617_ELO_Tutoring	SUMMER, EXTENDED YEAR
ELO-PHYSICAL-ACTIVITY-INDICATOR-CODE	TX-ELOPhysicalActivityIndicator	The campus offers an expanded learning opportunity (ELO) identified as physical activity. “Physical activity” is defined as activities designed to provide students with supplemental non-UIL opportunities for individual or group exercise, or related knowledge and skills that encourage regular physical activity	[S_TX_SCH_ELO_C] E1618_ELO_Physical_Activity	SUMMER, EXTENDED YEAR
ELO-ACADEMIC-SUPPORT-INDICATOR-CODE	TX-ELOAcademicSupportIndicator	The campus offers an expanded learning opportunity (ELO) identified as academic support. “Academic” support is defined as supplemental support related to student academic skill development and may include compensatory education, test-taking skills, and related academic skill-building. Tutoring and homework help are not considered academic support.	[S_TX_SCH_ELO_C] E1619_ELO_Academic_Support	SUMMER, EXTENDED YEAR
ELO-EDUCATIONAL-ENRICHMENT-INDICATOR-CODE	TX-ELOEducationalEnrichmentIndicator	The campus offers an expanded learning opportunity (ELO) identified as educational enrichment. Educational enrichment includes activities that engage students in actively exploring academic content and activities introduced during the regular school day. It consists of activities that are intentionally designed to align with but not replicate the instruction in a core course to increase the academic success of students in any subject, including fine arts, civic engagement, science, technology, engineering, and mathematics	[S_TX_SCH_ELO_C] E1620_ELO_Ed_Enrichment	SUMMER, EXTENDED YEAR
Residential Facility Extension Complex
RESIDENTIAL-FACILITY-ID	StateOrganizationId	The ID number for the residential facility.	[S_TX_SEN_RFT_X]E1627_SEN_RF_ID	TSDS - RFT
DISTRICT-ID	StateOrganizationId
		Education Organization Reference
		Educational Org Identity
Location Complex - This complex type is repeated for each unique room in the [Room] table for each School Complex type.
CLASSROOM-IDENTIFICATION-CODE	ClassroomIdentificationCode	The rooms	[Rooms]Room_Number	TSDS - RFT
Class Period Complex - This complex type is repeated for each Class Period Reference within each School Complex type.
CLASS-PERIOD	ClassPeriodName	The period number from the Class Period Reference.	[Period]Period_Number	SUMMER, TSDS - RFT
Course Complex - For PEIMS this complex type is repeated for any course in the School_Course table with Year ID the same as the year being processed and a non-blank alternate course number. Records for schools excluded from state reporting are excluded unless the school is in the range from 701 to 999. For Dashboard, all courses in the School_Course table with a non-blank alternate course number and Exclude from Dashboard set to No for schools not excluded from state reporting are included. Notes: For mixed grade-level classes, the report extracts a corresponding Course for each unique grade level. For example, a class with PK, K, 1 & 2 would have four Course records. When the interchange is set to extract students based on Crisis Code, this section is not generated. For courses scheduled at non-reportable campuses (NRC), service IDs are reported for the student's school of enrollment. Courses with blank service IDs are excluded. For Fall Submission, service IDs are not reported if the course or section is marked as Exclude from 090.
LOCAL-COURSE-TITLE	CourseTitle
NUMBER-OF-PARTS	NumberOfParts
Course Code
COURSE-LEVEL-CHARACTERISTICS	CourseLevelCharacteristic
SUBJECT-AREA	SubjectArea
Minimum Available Credit
Maximum Available Credit
	Course Code – This complex type is for State course code.
ID		The Service ID is used for the state course code.	[S_TX_SEC_MIXGRD_C]SERVICE_ID [S_TX_SCH_MIXGRD_C]SERVICE_ID [CoursesCoreFields]Alt_Course_Number	FALL, SUMMER, EXTENDED YEAR, TSDS - RFT
	Education Organization Reference
	Educational Org Identity
State Organization ID		The County-District-Campus number for the school.	[Schools]School_Number	FALL, SUMMER, EXTENDED YEAR, TSDS - RFT
Program Complex
Program ID		The name of the program.		TSDS - RFT

TSDS - RFT

Data Element	Description	[Table]FieldName	Collection
Local Education Agency Complex The ID reference is LEA_1.
State Organization ID	The ID number of the district.	[Prefs]DistrictNumber	TSDS - RFT
School Complex - This complex type is repeated for each school not excluded from state reporting. The id reference is SCH_xxx where xxx is the School Number.
State Organization ID	The County-District-Campus number for the school.	[Schools]School_Number	TSDS - RFT
Name of Institution	The name of the school.	[Schools]Name	TSDS - RFT
	Organization Categories
Organization Category	Hardcoded as 'School'.	N/A	TSDS - RFT
	Local Education Agency Reference
	Educational Org Identity
State Organization ID	The ID number of the district.	[Prefs]DistrictNumber	TSDS - RFT
NSLP Type Code	The school's national school lunch participation type. See 2022-09-05_09-25-50_NSLP Type Codes for valid values.	[S_TX_SCH_SCHOOLS_X]E1581_NSLP_Code	TSDS - RFT
Residential Facility Extension Complex
State Organization ID	The ID number for the residential facility.	[S_TX_SEN_RFT_X]E1627_SEN_RF_ID	TSDS - RFT
	Education Organization Reference
	Educational Org Identity
Location Complex - This complex type is repeated for each unique room in the [Room] table for each School Complex type.
Classroom Identification Code	The rooms	[Rooms]Room_Number	TSDS - RFT
Class Period Complex - This complex type is repeated for each Class Period Reference within each School Complex type.
Class Period Name	The period number from the Class Period Reference.	[Period]Period_Number	TSDS - RFT
Course Complex - Course data is pulled from the school in which
Course Title
Number of Parts
Course Code
Course Level Characteristics
Subject Area
Minimum Available Credit
Maximum Available Credit

	Course Code – This complex type is for State course code.
ID	The Service ID is used for the state course code.	[S_TX_SEC_MIXGRD_C]SERVICE_ID [S_TX_SCH_MIXGRD_C]SERVICE_ID [CoursesCoreFields]Alt_Course_Number	TSDS - RFT
	Education Organization Reference
	Educational Org Identity
State Organization ID	The County-District-Campus number for the school.	[Schools]School_Number	TSDS - RFT
Program Complex
Program ID	The name of the program.