TX Interchange Student
Contents
Introduction
The interchange schema for Student information can be used when only student identification, characteristic, and demographic information is required to be exchanged. The Student information includes identifiers, name sex, ethnicity and race, birth data and contact information. In addition, flags are included for economically disadvantaged, school food service eligibility, and limited English proficiency. Information is included regarding the student’s home situation, language(s), displacement status, and disabilities. This report is only used for PEIMS reporting.
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.
Non-enrolled homeschooled students who do not attend school in the district, but can participate in activities. These students are excluded from state reporting - now the Interchange student selection will include non-enrolled UIL students with UIL participation records in the current year (23-24).
If students participated in multiple UIL activities during the year multiple records will be reported with the numeric code of the activity.
If a student NonEnrolled UIL Participant records at more than one school during the same year. Output the UIL activities in the school record(s) that most recently entered (select school by record internal ID).
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.
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 prior 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:
At the School Level:
|
Include 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. |
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. |
Limit records to RFT Students only* | Choose Yes or No. |
Default Early Reading Indicator to 3 (Not Assessed) for students with no current year record?* | Choose Yes/No to default Early Reading Indicator to 3 (Not Assessed) for students with no current year record |
Exclude Students with Missing Unique ID | Choose Yes to exclude students with Missing Unique ID |
Exclude Students with Missing SSN | Choose Yes to exclude students with Missing SSN |
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:
|
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 – InterchangeStudentExtension.xml
Report Output: XML
Data Element | Description | [Table]Field | Collection |
Student – This complex type is repeated for each student that is included in the particular Submission selected. Note: Summer School enrollments and enrollments flagged as Exclude from State Reporting are not included in this record. | |||
Student Unique State ID | The student's unique State Student Number | [Students]State_StudentNumber | FALL, SUMMER, EXTENDED YEAR |
Student Identification Code | |||
Identification System | Hard coded as 'State'. | N/A | FALL, SUMMER, EXTENDED YEAR |
Identification Code | The student's state ID number. | [Students]State_StudentNumber [Students]SSN | FALL, SUMMER, EXTENDED YEAR |
Student Identification Code | |||
Identification System | Hard coded as 'District'. | N/A | FALL, SUMMER, EXTENDED YEAR |
Identification Code | The student's local student ID number. | [Students]Student_Number | FALL, SUMMER, EXTENDED YEAR |
Name | |||
First Name | The student’s first name. | [Students]First_Name | FALL, SUMMER, EXTENDED YEAR |
Middle Name | The student's middle name. | [Students]Middle_Name | FALL, SUMMER, EXTENDED YEAR |
Last Name | The student's last name. | [Students]Last_Name | FALL, SUMMER, EXTENDED YEAR |
Birth Data | |||
Birth Date | The student’s date of birth. | [Students]DOB | FALL, SUMMER, EXTENDED YEAR |
TX LEA Reference | |||
EducationalOrgIdentity | |||
State Organization ID | The district where the student is enrolled. | [Prefs]Value [Prefs]Name=districtnumber | FALL, SUMMER, EXTENDED YEAR |
Generation Code Suffix | The student’s generation suffix code. | [StudentCoreFields]PSCore_Legal_Suffix | FALL, SUMMER, EXTENDED YEAR |
Sex | The student's gender. | [Students]Gender | FALL, SUMMER, EXTENDED YEAR |
Hispanic Latino Ethnicity | The student's Federal Ethnicity code. | [Students]FedEthnicity | FALL, SUMMER, EXTENDED YEAR |
TX-Race | |||
American Indian Code | Indicates if the student is American Indian. | [StudentRace]RaceCD = I | FALL, SUMMER, EXTENDED YEAR |
Asian Code | Indicates if the student is Asian. | [StudentRace]RaceCD = A | FALL, SUMMER, EXTENDED YEAR |
Black-African American Code | Indicates if the student is Black or African-American. | [StudentRace]RaceCD = B | FALL, SUMMER, EXTENDED YEAR |
Native Hawaiian Pacific Islander Code | Indicates if the student is Native Hawaiian or Pacific Islander. | [StudentRace]RaceCD = P | FALL, SUMMER, EXTENDED YEAR |
White Code | Indicates if the student is White. | [StudentRace]RaceCD = W | FALL, SUMMER, EXTENDED YEAR |
TX-Student Characteristics | |||
ADA Eligibility Code | The student's Average Daily Attendance eligibility. | [S_TX_STU_STATE_GEN_C]E0787_ADA_Code | FALL |
At Risk Indicator Code | Indicates if the student is considered at-risk of not meeting standards or dropping out of school. | [S_TX_SEN_AtRisk_X]E0919_AtRisk_Ind | FALL |
Homeless Status Code | The student's homeless status. | [S_TX_STU_STATE_GEN_C]E1082_Homeless | FALL, SUMMER |
Immigrant Indicator Code | The student's immigrant status. | [S_TX_SEN_Imm_X]E0797_Immigrant_Indicator | FALL |
LEP Indicator Code | The student's status as a Limited English Proficiency student. | [S_TX_SEN_ESL_X]E0790_LEP_Indicator | FALL, SUMMER, EXTENDED YEAR |
Migrant Indicator Code | The student's migrant status. | [S_TX_SEN_Mig_X]E0984_Migrant_Ind | FALL, SUMMER, EXTENDED YEAR |
SSI Promotion Retention Code | Indicates if the student was promoted or retained due to participation in the Student Success Initiative (SSI). | [S_TX_STU]SSI_PROM_RET_C | FALL |
Unaccompanied Youth Status | Indicates if the student is an unaccompanied youth. | [S_TX_STU_STATE_GEN_C] E1084_Unaccompanied_Youth | FALL, SUMMER |
Unschooled Asylee/Refugee Code | Indicates if the student was first enrolled in a U.S. school sometime in grades 7-12 and, prior to enrollment, was an unschooled asylee or refugee. | [S_TX_STU_STATE_GEN_C] E1076_Unschooled_Asylee | FALL, SUMMER |
Early Reading Indicator Code | Indicates if the student is reading at grade level, or if the student is reading below grade level due to reading difficulties or dyslexia. | [S_TX_STU_Early_Reading_C] E1522_Early_Reading_First | FALL, SUMMER |
Foster Care Indicator Code | Indicates if the student is in foster care. | [S_TX_STU_STATE_GEN_C]E1528_Foster_Care | FALL, SUMMER, EXTENDED YEAR |
Military Connected Student Code | Indicates if the student is the dependent of an active duty or reserves member of the United States military (Army, Navy, Air Force, Marine Corps, Coast Guard) or the Texas National Guard. | [S_TX_STU_STATE_GEN_C] E1529_Military_Connected | FALL, SUMMER |
Dyslexia Indicator Code | Indicates if the student has dyslexia. Note: If the student is not active on the Fall Snapshot Date, this element is suppressed. | [S_TX_STU_STATE_GEN_C]E1530_Dyslexia | FALL |
TX-TSTEM Indicator Code | Indicates if the student is enrolled in a Texas Science, Technology, Engineering, and Mathematics (T-STEM) Academy. Note: This element is only reported for students in grades 6-12. | [S_TX_STU_STATE_GEN_C]E1559_TSTEM [S_TX_STU_STATE_GEN_C] E1559_TSTEM_SUB4 [Students]Grade_Level | FALL, SUMMER, EXTENDED YEAR |
ECHS Indicator Code | Indicates if the student is enrolled in an Early College High School (ECHS). | [S_TX_STU_STATE_GEN_C]E1560_ECHS [S_TX_STU_STATE_GEN_C]E1560_ECHS_Sub4 | FALL, SUMMER, EXTENDED YEAR |
P-Tech Indicator Code | Indicates if the student participates in the Pathways in Technology (P-Tech) Early College High School program. Note: This element is only reported for students in grades 9-12. | [S_TX_STU_STATE_GEN_C]E1612_PTECH [S_TX_STU_STATE_GEN_C] E1612_PTECH_Sub4 [Students]Grade_Level | FALL, SUMMER, EXTENDED YEAR |
IEP Continuer Indicator | Indicates if a student 18 years or older is continuing in special education. This element is reported if the student is 18 years or older as of September 1 of the current school year, is a special education student, and is not a graduate.
For students receiving Speech Therapy only with an Instructional Code of '00', a value of '1' is reported if the student has completed all graduation requirements. Otherwise a value of '0' is reported. IEP Continuer Indicator is suppressed if the student is not 18 or older as of September 1 of the current school year, or if the student is a graduate. | [S_TX_STU_STATE_GEN_C] E1002_As_Of_Override [SPEnrollments]StudentID [Students]DOB | FALL |
Home Language Code | The language spoken in the student's home. | [StudentCoreField]PrimaryLanguage | FALL |
Student Language Code | The language the student predominantly speaks. | [StudentCoreField]PrimaryLanguage [StudentCoreField]SecondaryLanguage | FALL |
As of Status Code | The student's current enrollment status in the LEA. | [S_TX_STU_STATE_GEN_C] E1002_As_Of_Override | FALL, SUMMER |
Economic Disadvantage Code | Indicates if the student has economic disadvantage. | [S_TX_SEN_Econ_X] E0785_Econ_Disadvantaged | FALL, SUMMER |
TX-Student Census Block Group | The census block the student resides in This element is suppressed if the student is not enrolled on the Fall Snapshot Date. Otherwise, the element is reported if the student meets these criteria:
| [S_TX_STU_CENSUS_BLOCK_C]Census_Block | FALL |
Crisis Code | Indicates the state health or weather-related crisis that impacts this student. Note: This element is only reported if the student's Crisis Code is populated with a value other than NULL. | [S_TX_STU_STATE_GEN_C]E1054_Crisis_Code | FALL, SUMMER, EXTENDED YEAR |
Parental Permission Code | Indicates if the student's parent/guardian has approved of the student's placement in a bilingual or ESL program. | [S_TX_SEN_ESL_X]E0896_Parental_Permission | FALL |
Associate Degree Indicator Code | Indicates if the student earned an associate degree in any of the following fields prior to graduating high school.
| [S_TX_STU_X]E1596_Associate_Degree_Ind | FALL, SUMMER |
Star of Texas Indicator Code | Indicates if the student is eligible for free public pre-kindergarten education because the student's parent or guardian received the Star of Texas Award. Note: This element is only reported if the student is in PK. | [S_TX_STU_STATE_GEN_C] E1601_Star_Of_Texas | FALL, SUMMER |
TX-Residential Facility Indicator | SUMMER | ||
TX-PK Eligible Previous Year | Indicator of whether the four-year-old student was eligible for enrollment at the age of three in the previous school year | [S_TX_SEN_PREK_X]E1649_PK_Elig_Prev_Year | FALL, SUMMER |
TX-Adult Previous Attendance Indicator | Indicates whether an adult student (age 18-25) who is currently enrolled in a high school equivalency program, dropout recovery school or other adult education program, has or has not attended school in the previous nine months prior to enrolling.
| S_TX_STU_X.E1660_Adult_Prev_Att_Ind | FALL, SUMMER |
TX-Industry Certification | |||
TX-Date Cert Earned | Certification earned date | FALL, SUMMER | |
TX-Post Secondary Certification Licensure | Indicates a nationally or internationally recognized business or industry certification or license earned by a student.
| FALL, SUMMER | |
TX-IBC Exam Fee Amount | Identifies the amount of money that was paid for a student’s industry certification exam by the local education agency
| [S_TX_STU_PERF_ACKN_C]E1654_IBC_Exam_Fee_Amt | FALL, SUMMER |
TX-IBC Vendor Code | Identifies the organization or company that offered the service. This the vendor or organization that administered the certification exam. The vendor code must be reported for each certification exam taken | [S_TX_STU_PERF_ACKN_C]E1655_IBC_Vendor_Code | FALL, SUMMER |
TX-Parent Request Retention Indicator | Reported when an enrolled student was retained at the request of the parent or guardian. For the 2021-2022 school year, this applies to students in grades PK-12; for the 2022-2023 school year and beyond, this applies to students in grades PK-3 only | FALL | |
TX-General Education Homebound Indicator | Indicates that a student was provided services through the General Education Homebound program at any time during the current school year | [S_TX_SEN_GEH_X]E1730_GEH_IND | SUMMER |
TX-Virtual Student Not In Membership | 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]E1735_Virtual_Student_Not_InMembership | 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 |