TX Interchange Student Program

Contents

Introduction

The interchange schema for Student Program information can be used to exchange students’ participation in programs. The interchange includes extensions for Bilingual, English as a Second language (ESL), Extended Year Services (ESY), Special Education, Career and Technical Education (CTE), Supplemental Services, and Title I Part A programs. This exchange is used for both TSDS and PEIMS.

The Transcript Interchange is updated with logic to source the Pass/Fail Indicator Code from the calculated value in the stored grades record ((S_TX_SGR_X.E0949_PF_Calc). If no calculated value exists in stored grades, the calculation is executed on-the-fly.

The PEIMS Extended Year stored grades selection criteria is updated to first check for the Dual Credit Indicator in the stored grades record. If blank, the logic then examines the Dual Credit flag in courses. Records are no longer bypassed due to a missing Dual Credit indicator in stored grades as long as the stored grades record references a district course number where Dual Credit is set to Yes.

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.

Submission 4 reports three types of records: Bilingual/ESL Summer School, Extended Year Services (ESY), and Dual Credit Summer School classes.

Student Selection Criteria

- Students must be enrolled in a regular, reportable campus in the district or enrolled in a non-reportable campus where the Child Find Placeholder Campus field is set to Yes in Schools/School Info.
- Students must have a Child Find Special Program record where the SPED Eligibility Determination Date falls on or between July 1 and June 30 of the current school year. The Entry Date of the Child Find record may be in a prior school year or the current school year.

Bilingual/ESL Summer School Selection

The student must be enrolled in the prior school year, or in the in the current year.
The student must have a PEIMS General record in effect for at least one day in the prior school year.
The student must have a LEP Special Programs record if effect for the prior school year where the Bilingual/ESL Summer School Indicator equals 1.

Extended School Year Services (ESY Selection

The student must be enrolled in the prior school year, or in the in the current year.
The student must have a PEIMS General record in effect for at least one day in the prior school year.
The student must have an Extended Year Services record for the 2017-18 academic year with Contact Hours in Instructional Setting 1; Contact Hours in Instructional Setting 2 is optional.

Dual Credit Summer School Classes and Manual Entry Stored Grade Selection

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 be associated with a student who meets the Dual Credit summer school class criteria OR the Bilingual/ESL Summer School or Extended Year Services.
The stored grade must not be associated with a course or section which is excluded from 090 reporting.
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.
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.
School Start Window	Enter the appropriate date for the School Start Window for the year being processed. Typically, this is the last Friday in September.
October Snapshot Date	Enter the appropriate date for the October Snapshot Date for the year being processed. Typically, this is the last Friday in October.
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. Notes: Only visible for the Summer collection. Only the Student Program Extension complex and the Title I Special Program complex are reported for PK students.
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 the 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 (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 34 starts the name of the Interchange – InterchangeStudentProgramExtension.xml

Data Element	Description	[Table]Fields	Collection
For FALL Collections, students who are enrolled on snapshot date are included. For SUMMER Collections all students that were active at least one day are included.
StudentProgram
	Student Reference
	Student Identity
Student Unique State ID	Unique State Student Number	[Students]State_StudentNumber	FALL, SUMMER, EXTENDED YEAR
TX-Bilingual	The student’s Bilingual Program Type Code for snapshot date.	[S_TX_SEN_ESL_X]E1042_Bilingual_Program	FALL
TX-ESL	The student’s ESL Program Type Code for snapshot date.	[S_TX_SEN_ESL_X]E1043_ESL_Program	FALL
TX-Bilingual ESL Summer	The student’s indicator that they attended the Bilingual ESL Summer School program.	[S_TX_SEN_ESL_X]E1028_Bil_ESL_Sumr	EXTENDED YEAR
TX-Gifted and Talented	The student’s Gifted and Talented Indicator Code for snapshot date.	[S_TX_SEN_GT_X]E0034_GT	FALL, EXTENDED YEAR
TX-Pregnancy Related Services	The student’s Pregnancy Related Services Code.	[S_TX_SEN_PRS_X]E0939_PRS	SUMMER
TX-Special Education	The student’s Special Ed Indicator Code for snapshot date for Fall Collection and the last status for the Summer Collection.	Derived from: [S_TX_SEN_SPD_X]E0173_INSTR_SETTING	FALL, SUMMER, EXTENDED YEAR
TX-Alternative Language Program	The student's alternative language program type code that they participated in	[S_TX_SEN_ESL_X]E1642_Alt_Language_Program	FALL
TX-Intervention Strategy Indicator	Indicates if the student participated in an intervention strategy at any point in the school year. For the Fall Collection, if the student is not active on the snapshot date, this element is not visible. For the Summer Collection, this element is reported for all students. If the student had an Intervention Strategy record in effect at any time during the year, the report outputs 1; otherwise, the report outputs 0.	[S_TX_SEN_INTERV_X]E1602_Indicator	FALL, SUMMER
TX-504 Indicator	Indicates that the student received Section 504 services at some point during the school year. For the Fall Collection, if the student is not active on the snapshot date, this element is not visible. For the Summer Collection, this element is reported for all students.This field reports as 1 on the Summer Collection if the student has a 504 record on the final day of enrollment for the school year. Otherwise, the report outputs 0.	[S_TX_SEN_504_X]E1603_Indicator	FALL, SUMMER
StudentCTEProgramAssociationExtension – Included for students with CTE classes during the year.
	Student Reference
	Student Identity
Student Unique State ID	Unique State Student Number	[Students]State_StudentNumber	SUMMER
	Education Organization Reference
	Educational Org Identity
State Organization ID	District ID	[S_TX_COHORT_S]E0212	SUMMER
TX-Out Of Workforce Individual	The student’s status on Displaced Homemaker Code on snapshot.	[S_TX_SEN_CTE_X] E1039_Displaced_Homemaker	SUMMER
TX-CTE Transportation Services	The student’s status on CTE Transportation Services Code on snapshot.	[S_TX_SEN_CTE_X]E0917_CTE_Trans	SUMMER
TX-Single Parent Single Pregnant Woman Code	The student’s status on Single Parent Pregnancy Teen Code on snapshot.	[S_TX_SEN_CTE_X] E0829_SinglePar_PregTeen	SUMMER
Student ESY Program Association Extension – Included for students who are coded Special Education and participated in the Extended Services Year Program.
	Student Reference
	Student Identity
Student Unique State ID	Unique State Student Number	[Students]State_StudentNumber	EXTENDED YEAR
	Education Organization Reference
	Educational Org Identity
State Organization ID	District ID	[Prefs]DistrictNumber	EXTENDED YEAR
TX-Campus ID of Enrollment	The campus where the student was enrolled.	[S_TX_STU_ESY_C]E0782_Campus_ID	EXTENDED YEAR
TX-Grade Level Type	The student’s grade level in the prior year.	[S_TX_STU_ESY_C]E0017_Grade_Level	EXTENDED YEAR
TX-Instructional Setting	The instructional setting that the student had for the prior year and is receiving services.	[S_TX_STU_ESY_C]E0173_Instr_Setting1	EXTENDED YEAR
TX-Total ESY Contact Hours Instructional Setting	The total number of contact hours the student got for the first instructional setting.	[S_TX_STU_ESY_C]E1013_Contact_Hours1	EXTENDED YEAR
TX-Instructional Setting 2	The second instructional setting that the student may have received services.	[S_TX_STU_ESY_C]E0173_Instr_Setting2	EXTENDED YEAR
TX-Total ESY Contact Hours Instructional Setting 2	The total number of contact hours the student got for the second instructional setting.	[S_TX_STU_ESY_C]E1013_Contact_Hours2	EXTENDED YEAR
Student Title I Part A Program Association Extension – Included for students who are coded Title I Part A at any point in time during the school year for the Summer Collection. A student may have multiple complex types for Title I if they have been Title I at multiple schools within the school year. However, they can only have one record for each school.
	Student Reference
	Student Identity
Student Unique State ID	Unique State Student Number	[Students]State_StudentNumber	FALL, SUMMER
	Education Organization Reference
	Educational Org Identity
State Organization ID	District ID	[Prefs]District ID	FALL, SUMMER
Campus ID of Enrollment	Campus ID	[Students]SchoolID	FALL, SUMMER
TX-Title I Part A Indicator	The student’s Title I Part A Indicator Code for snapshot date for Fall Collection and the last status for the Summer Collection.	[S_TX_SEN_Title1_X]E0894_Title1_IND	FALL, SUMMER

StudentSpecialEd ProgramAssociationExtension – Included for students who are coded Special Education on snapshot date for the Fall Collection and for all students who were Special Ed at one point in time during the school year for the Summer Collection.
	Student Reference
	Student Identity
Student Unique State ID	Unique State Student Number	[Students]State_StudentNumber	FALL, SUMMER
	Education Organization Reference
	Educational Org Identity
State Organization ID	District ID	[S_TX_COHORT_S]E0212	FALL, SUMMER
TX-Effective Date Sp Ed	Indicates the date upon which the associated data values(s) is/are considered to take effect		FALL, SUMMER
	TX-Disabilities
TX-Effective Date Disabilities	Indicates the date upon which the associated data values(s) is/are considered to take effect		FALL, SUMMER
TX-Primary Disability	The student's primary disability.	[S_TX_SEN_SPD_X]E0041_Dis1	FALL, SUMMER
TX-Secondary Disability	The student's secondary disability.	[S_TX_SEN_SPD_X]E0834_Dis2	FALL, SUMMER
TX-Tertiary Disability	The student's tertiary disability.	[S_TX_SEN_SPD_X]E0835_Dis3	FALL, SUMMER
TX-Multiply Disabled	Indicates if the student has been designated as multiply disabled.	[S_TX_SEN_SPD_X]E0882_Multi_Dis	FALL, SUMMER
TX-Medically Fragile	Indicates if the student is considered medically fragile based on PEIMS criteria.	[S_TX_SEN_SPD_X]E0999_Medically_Frag	FALL
TX-Instructional Setting	The instructional setting where the student received services.	[S_TX_SEN_SPD_X]E0173_Instr_Setting	FALL, SUMMER
TX-Child Count Funding	The federal program by which the student receives special education and related services.	[S_TX_SEN_SPD_X] E0832_Child_Count_Fund	FALL
	TX-Special Ed Services Type
TX-Effective Date Services	Indicates the date upon which the associated data values(s) is/are considered to take effect		FALL, SUMMER
TX-Assistive Technology	Indicates if the student receives, or is scheduled to receive, assistive technology device services during the term.	[S_TX_SEN_SPD_X]E0997_Assistive_Tech	FALL, SUMMER
TX-Audiological Services	Indicates if the student receives, or is scheduled to receive, audiological services during the term.	[S_TX_SEN_SPD_X]E0838_Audiological	FALL, SUMMER
TX-Counseling Services	Indicates if the student receives, or is scheduled to receive, counseling services during the term.	[S_TX_SEN_SPD_X]E0840_Counseling	FALL, SUMMER
TX-Early Childhood Intervention	Indicates if the student participates in an early childhood intervention program.	[S_TX_SEN_SPD_X]E0900_Early_Child	FALL, SUMMER
TX-Interpreting Services	Indicates if a deaf student receives, or is scheduled to receive, interpreting services during the term.	[S_TX_SEN_SPD_X]E1040_Interpreting_Serv	FALL, SUMMER
TX-Medical Diagnostic Services	Indicates if the student who participates in special education and related services receives, or is scheduled to receive, medical diagnostic services during the term.	[S_TX_SEN_SPD_X]E0841_Medical_Diag	FALL, SUMMER
TX-Occupational Therapy	Indicates if the student who participates in special education and related services receives, or is scheduled to receive, occupational therapy services during the term.	[S_TX_SEN_SPD_X]E0843_OT	FALL, SUMMER
TX-Orientation Mobility Training	Indicates if the student who participates in special education and related services receives, or is scheduled to receive, orientation and mobility services during the term.	[S_TX_SEN_SPD_X]E0844_Orient_Mobility	FALL, SUMMER
TX-Physical Therapy	Indicates if the student who participates in special education and related services receives, or is scheduled to receive, physical therapy services during the term.	[S_TX_SEN_SPD_X]E0845_PT	FALL, SUMMER
TX-Preschool Program Child Disabilities	Indicates if the preschool student, age three through five years old, receives any special education and related services from the district or charter school.	[S_TX_SEN_SPD_X]E0899_PPCD	FALL, SUMMER
TX-Psychological Services	Indicates if the student who participates in special education services receives, or is scheduled to receive, psychological services during the term.	[S_TX_SEN_SPD_X]E0846_Psychological	FALL, SUMMER
TX-Recreation	Indicates if the student who participates in special education services receives, or is scheduled to receive, recreation services during the term.	[S_TX_SEN_SPD_X]E0847_Recreation	FALL, SUMMER
TX-Reg Day School Program Deaf	Indicates if the student receives instructional services from a regional day school program for the deaf.	[S_TX_SEN_SPD_X]E0833_RDSPD	FALL, SUMMER
TX-School Health Services	Indicates if the student who participates in special education services receives, or is scheduled to receive, school health services during the term.	[S_TX_SEN_SPD_X]E0848_School_Health	FALL, SUMMER
TX-Social Work Services	Indicates if the student who participates in special education services receives, or is scheduled to receive, social work services during the term.	[S_TX_SEN_SPD_X]E0849_Social_Work	FALL, SUMMER
TX-Speech Therapy	Indicates if the student receives, or is scheduled to receive, speech therapy services through a special education program during the term.	[S_TX_SEN_SPD_X]E0857_Speech	FALL, SUMMER
TX-Transportation	Indicates if the student who participates in special education services receives, or is scheduled to receive, special transportation services during the term.	[S_TX_SEN_SPD_X]E0851_Transportation	FALL, SUMMER
TX-PPCD Services Location Indicator	Indicates if the Preschool Program for Children with Disabilities student received services at a school designed for typically developing children ages three through five, rather than an institution specifically designed for children with disabilities.	[S_TX_SEN_SPD_X]E1077_PPDC_Service	FALL
TX-LEA of RDSPD Service	The LEA ID number of the RDSPD Fiscal Agent that provides RDSPD services.	[S_TX_SEN_SPD_X]E1527_Dist_RDSPD	FALL