TX Interchange Student Enrollment

Contents

Introduction

The interchange schema for Student Enrollment information can be used to exchange campus enrollments and/or enrollments in specific class sections. 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.
Current Selection Students*	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Includes Graduates	Set to Yes ONLY during Fall Submission when High Schools have been selected.
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 from the pop-up menu for the report generated.
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.
Crisis Data Submission	Choose Yes or No to indicate whether to run the report based on crisis data. Note: SUMR1 collection must be selected when generating files for the Crisis Data Submission. Districts that previously submitted files for the Crisis Data Submission must first delete existing student records in the TSDS SUMR1 collection.
Crisis Codes to Include	Choose the appropriate Crisis Code(s). The report will extract only students with that code(s). Note: The list box includes a crisis code only if a selected student has that code. If the list box is blank, no students exist with the applicable crisis code.
Include crisis-affected students enrolled on or after this date	Enter a date to run the report for crisis-affected students enrolled on or after the specified date. Note: To avoid unintentionally excluding new enrollees, take care when selecting a date.
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 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 35 starts the name of the Interchange – InterchangeStudentEnrollmentExtension.xml

Data Element	Description	[Table]Fields	Collection
Student School Association Complex Type – This complex type is repeated for each student that is to be included in each collection. For Collection 1 it is all students who are As of Status of A – G or X that are not Excluded from PEIMS.
	Student Reference
	Student Identity
Student Unique State ID	Unique State Student Number	[Students]State_StudentNumber	FALL, SUMMER, EXTENDED YEAR
	School Reference
	Education Org Identity
State Organization ID	Campus ID of Enrollment for the student.	[Prefs]Value [Prefs]Name=districtnumber	FALL, SUMMER, EXTENDED YEAR
TX Grade Level	Submission 1 is grade on snapshot date or grade at last enrollment.	[Students]Grade_Level [ReEnrollments]Grade_Level	FALL, SUMMER, EXTENDED YEAR
TX Campus ID of Enrollment	Campus ID of Enrollment for As of Status C, E and G.	[S_TX_STU_ESY_C]E0782_Campus_ID	FALL, SUMMER, EXTENDED YEAR
TX Campus ID of Residence	Campus ID of Residence	[S_TX_STU_STATE_GEN_C]E0903_Campus_Residence	FALL, SUMMER, EXTENDED YEAR
TX Campus ID of Accountability	Campus ID of Accountability	[S_TX_STU_STATE_GEN_C]E1027_Campus_Accountablity	FALL, SUMMER
Last Date of Enrollment	Last Date of Enrollment	[Students]ExitDate	SUMMER
TX Attribution	Student Attribution Code	[S_TX_STU_STATE_GEN_C]E1000_Attribution_Code	FALL, SUMMER, EXTENDED YEAR
TX PK Program Type Indicator	PK Program Type Code	S_TX_SEN_PreK_X]E1078_PK_Program	FALL
TX Primary PK Funding Source	PK Primary Funding Source Code	[S_TX_SEN_PreK_X]E1079_Prim_PK_Fund	FALL
TX Secondary PK Funding Source Code	PK Secondary Funding Source Code	[S_TX_SEN_PreK_X]E1080_Sec_PK_Fund	FALL
Student Section Association Complex Type – Repeats for every section the student is enrolled and every CC record where they are in and out of the section. Note: this section is not generated when the interchange is set to extract students based on Crisis Code.
	Student Reference
	Student Identity
Student Unique State ID	Unique State Student Number	[Students]State_StudentNumber	SUMMER, EXTENDED YEAR
	Section Reference
	Section Identity
State Organization ID	Campus ID where section is taught.	[Prefs]Value [Prefs]Name=districtnumber	SUMMER, EXTENDED YEAR
Unique Section Code	Class ID Number	[S_TX_SGR_X]Class_ID_Number or Calculated	SUMMER, EXTENDED YEAR
Begin Date	Student Begin Date	[Students]EntryDate or [Reenrollments]EntryDate	SUMMER, EXTENDED YEAR
End Date	Student End Date	[Students]Exitdate or [ReEnrollments]ExitDate	SUMMER, EXTENDED YEAR
TX- Course Sequence	Course Sequence Code for this section/grade.	[S_TX_CRS_X]Course_Sequence [S_TX_SGR_X]E0948	SUMMER, EXTENDED YEAR
TX-Course Completion Indicator	The course completion code for the stored grade.	[S_TX_SGR_X]E1068	FALL, SUMMER, EXTENDED YEAR
School Leaver Extension Complex Type This section is not generated when the interchange is set to extract students based on Crisis Code. For the Leaver Extension to be included in the Fall Submission, a student must have one of the following As of Statuses: A - Enrolled Last Year but not at all this year D - Enrolled Last Year, Enrolled on Last Friday in Oct, Not Enrolled on Last Friday in Sept. E - Enrolled Last Year, Enrolled this year but not Enrolled until after the Last Friday in Oct. Important: If the student has a local exit code but it is not mapped to a state reportable exit code, this complex type will not be created for the student. For information on mapping local exit codes to state codes, see 2023-02-24_03-20-19_District Setup.
	TX LEA Reference
	Educational Org Identity
State Organization ID	District Number	[Prefs]Value [Prefs]Name=districtnumber	FALL
	TX Student Reference
	Student Identity
Student Unique State ID	Unique State Student Number	[Students]State_StudentNumber	FALL
	TX School Reference
	Educational Org Identity
State Organization ID	County District Campus Number where student last attended		FALL
TX Leaver Reason Code	The student's state exit code.	[Gen]Value2 [Gen]Cat=exitcodes [Students]Exitcode	FALL
TX Date of Graduation	Date of Graduation for graduates.	[S_TX_STU_X]E0791	FALL
TX Graduation Type Code	Diploma Type Code	[S_TX_STU_X]E0806	FALL
TX Individual Graduation Committee Graduate Indicator	Indicates if the student graduated after review by an IGC reported only for graduate leavers.	[S_TX_STU_X]E1563	FALL
TX Military Enlistment Indicator Code	Indicates if the student has enlisted in the United States Armed Forces after graduation.	[S_TX_STU_X]E1589_Military_Enlistment	FALL
Student Graduation Program Extension Complex Type Notes: This extension is not generated when the interchange is set to extract students based on Crisis Code. This extension reports for all prior year graduates. FHSP graduates are reported with all of the applicable elements. Non-FHSP graduates are reported with a subset of the following elements: State Organization ID (XML Name: DISTRICT-ID) Student Unique State ID (XML Name: TX-UNIQUE-STUDENT-ID) State Organization ID (XML Name: CAMPUS-ID)
	TX LEA Reference
	Educational Org Identity
State Organization ID	District Number	[Prefs]Value [Prefs]Name=districtnumber	SUMMER
	TX Student Reference
	Student Identity
Student Unique State ID	Unique State Student Number	[Students]State_StudentNumber	SUMMER
	TX School Reference
	Educational Org Identity
State Organization ID	County District Campus Number where student last attended	[Prefs]District ID	SUMMER
	TX-Graduation Program Participants
TX FHSP Participant Type	FHSP Participant Code	[S_TX_STU_X]E1541_FHSP_Part	SUMMER
TX FHSP Distinguished Level Achievement Indicator Type	FHSP Distinguished Level Achievement Indicator Code	[S_TX_STU_X]E1542_FHSP_Dist	FALL, SUMMER
	TX-Endorsement Indicators
TX STEM Endorsement Indicator Type	TX STEM Endorsement Indicator Type	[S_TX_STU_X]E1544_STEM_End	FALL, SUMMER
TX Business And Industry Endorsement Indicator Type	TX Business And Industry Endorsement Indicator Type	[S_TX_STU_X] E1545_BI_End	FALL, SUMMER
TX Public Services Endorsement Indicator Type	TX Public Services Endorsement Indicator Type	[S_TX_STU_X] E1546_PS_End	FALL, SUMMER
TX Arts and Humanities Endorsement Indicator Type	TX Arts and Humanities Endorsement Indicator Type	[S_TX_STU_X] E1547_AH_End	FALL, SUMMER
Associate Degree Indicator Code	Indicates if the student earned an associate degree in any of the following fields prior to graduating high school. 2 Associate of Arts (AA) 3 Associate of Applied Arts (AAA) 4 Associate of Applied Science (AAS) 5 Associate of Arts in Teaching (AAT) 6 Associate of Science (AS)	[S_TX_STU_X]E1596_Associate_Degree_Ind	FALL, SUMMER
Individual Graduation Committee Review Code	Individual Graduation Committee Review Code	[S_TX_STU_X]E1563	SUMMER
TX-FinancialAidApplication Indicator Type	TX-FinancialAidApplication Indicator Type	[S_TX_STU_X]E1724	FALL, SUMMER
TX-Non Enrolled Student UIL Activity	Indicates that the student spent at least half of their instructional time enrolled in virtual courses without the benefit of funding under ADA.	[S_TX_SEN_GEH_X]E1739_Non_Enrolled_StudentUILActivity	SUMMER

Back to Top