The following extensions are included in InterchangeStudentParentExtension:
Submissions:
(ECDS-PK) = TSDS ECDS Prekindergarten
(ECDS-KG) = TSDS ECDS Kindergarten
(CF) = TSDS Child Find
(CR) = TSDS Class Roster - Fall & Winter
(CSW) = TSDS Charter School Waitlist
(RFT) = TSDS Residential Facility Tracker
(SELA) = TSDS Special Education Language Acquisition
(SPPI-14) = TSDS State Performance Plan Indicator 14
* Aeries Table.Fields that have an asterisk may need to be mapped on Texas State Reporting > Code Translations.
StudentExtension
- (CF) For Child Find, only students who have a Child Find Eligibility Determination Date (CSE.EDD) on or between July 1 and June 30 of the current school year are reported. Students are not required to have an enrollment record.
Submission | Element ID (Code Table) | Data Element | Aeries Table.Field | Aeries Page | Label |
(TSDS-All) | Student id | LOC.CD | School Options | Code | |
STU.ID | Demographics | Student ID | |||
<Student id="SCID_SSS_XXXXXX"> </Student> where
| |||||
(TSDS-All) | E1523 | TX-UNIQUE-STUDENT-ID | STU.CID | Demographics > Student Data 2 | Unique ID |
<Student id="SCID_SSS_XXXXXX"> <StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId> </Student> where UUUUUUUUUU = STU.CID | |||||
Rules (FATAL):
| |||||
(TSDS - All) | E1090 | STUDENT-IDENTIFICATION-SYSTEM | "State" | ||
<Student id="SCID_SSS_XXXXXX"> <StudentIdentificationCode IdentificationSystem="State"> <IdentificationCode>CCCCCCCCC</IdentificationCode> </StudentIdentificationCode> </Student> | |||||
Rules (FATAL):
| |||||
(TSDS-All) | E0001 | STUDENT-ID | ESD.ED | Demographics > Student Data 2 | Soc-Sec-Num/S-Number |
<Student id="SCID_SSS_XXXXXX"> <StudentIdentificationCode IdentificationSystem="State"> <IdentificationCode>CCCCCCCCC</IdentificationCode> </StudentIdentificationCode> </Student> where CCCCCCCCC = ESC.ED | |||||
Rules (FATAL):
| |||||
(CR) (CSW) (ECDS-PK) (ECDS-KG) (RFT) (SELA) (SPPI-14) | E1090 (DC126) | STUDENT-IDENTIFICATION-SYSTEM | "District" | ||
<Student id="SCID_SSS_XXXXXX"> <StudentIdentificationCode IdentificationSystem="District"> <IdentificationCode>XXXXXX</IdentificationCode> </StudentIdentificationCode> </Student> | |||||
| |||||
(CR) (CSW) (ECDS-PK) (ECDS-KG) (RFT) (SELA) (SPPI-14) | E0923 | LOCAL-STUDENT-ID | STU.ID | Demographics | Student ID |
<Student id="SCID_SSS_XXXXXX"> <StudentIdentificationCode IdentificationSystem="District"> <IdentificationCode>XXXXXX</IdentificationCode> </StudentIdentificationCode> </Student> where XXXXXX = STU.ID | |||||
Rule (FATAL):
| |||||
(TSDS-All) | E0703 | FIRST-NAME | LSI.LFN | Demographics > Change > Show/Hide Legal Name | Legal First Name |
STU.FN | Demographics | First Name | |||
<Student id="SCID_SSS_XXXXXX"> <Name> <FirstName>First</FirstName> </Name> </Student> where First = LSI.LFN if present; otherwise STU.FN | |||||
Special Warnings:
| |||||
(CF) (CR) (CSW) (ECDS-PK) (ECDS-KG) (SELA) (SPPI-14) | E0704 | MIDDLE-NAME | LSI.LMN | Demographics > Change > Show/Hide Legal Name | Legal Middle Name |
STU.MN | Demographics | Middle Name | |||
<Student id="SCID_SSS_XXXXXX"> <Name> <MiddleName>Middle</MiddleName> </Name> </Student> where Middle = LSI.LMN if present; otherwise STU.MN | |||||
Special Warnings:
| |||||
(TSDS-All) | E0705 | LAST-NAME | LSI.LLN | Demographics > Change > Show/Hide Legal Name | Legal Last Name |
STU.LN | Demographics | Last Name | |||
<Student id="SCID_SSS_XXXXXX"> <Name> <LastSurname>Last</LastSurname> </Name> </Student> where Last = LSI.LLN if present; otherwise STU.LN | |||||
Special Warnings:
| |||||
(DC148) (CF) (CR) (CSW) (SELA) | E1303 | GENERATION-CODE-SUFFIX | LSI.LSF | Demographics > Change > Show/Hide Legal Name | Legal Suffix |
STU.SF * | Demographics | Suffix | |||
<Student id="SCID_SSS_XXXXXX"> <Name> <GenerationCodeSuffix>X</GenerationCodeSuffix> </Student> where X = LSI.LSF if present; otherwise STU.SF if present; otherwise omitted | |||||
(CF) (CR) (CSW) (ECDS-PK) (ECDS-KG) (SELA) | E1325 (DC119) | SEX | STU.GN | Demographics | Gender |
<Student id="SCID_SSS_XXXXXX"> <Sex>Gender</Sex> </Student> where Gender = STU.GN Full DC119 Code Translation is used rather than code. | |||||
(TSDS-All) | E0006 | DATE-OF-BIRTH | STU.BD | Demographics | Birthdate |
<Student id="SCID_SSS_XXXXXX"> <BirthData> <BirthDate>YYYY-MM-DD</BirthDate> </BirthData> </Student> where YYYY-MM-DD = STU.BD | |||||
Rule (FATAL):
Special Warning:
| |||||
(SPPI-14) | E1113 (DC006) | ADDRESS-TYPE | "Mailing" or "Home" | ||
<Student id="SCID_SSS_XXXXXX"> <Address AddressType="Mailing/Home"> <StreetNumberName>nnnnn Street Name</StreetNumberName> <ApartmentRoomSuiteNumber>XXXXX</ApartmentRoomSuiteNumber> <City>City</City> <StateAbbreviation>XX</StateAbbreviation> <PostalCode>NNNNN-XXXX</PostalCode> <CountryCode>CC</CountryCode> </Address> </Student> | |||||
(SPPI-14) | E1114 | STREET-NUMBER-NAME | STU.AD | Demographics | Mailing - Address |
STU.RAD | Residence - Address | ||||
<Student id="SCID_SSS_XXXXXX"> <Address AddressType="Mailing/Home"> <StreetNumberName>nnnnn Street Name</StreetNumberName> </Address> </Student> where nnnnn Street Name =
| |||||
(SPPI-14) | E1115 | APARTMENT-ROOM-SUITE-NUMBER | STU.AD | Demographics | Mailing - Address |
STU.RAD | Residence - Address | ||||
<Student id="SCID_SSS_XXXXXX"> <Address AddressType="Mailing/Home"> <ApartmentRoomSuiteNumber>XXXXX</ApartmentRoomSuiteNumber> </Address> </Student> where XXXXX =
| |||||
(SPPI-14) | E1117 | CITY | STU.CY | Demographics | Mailing - City |
STU.RCY | Residence - City | ||||
<Student id="SCID_SSS_XXXXXX"> <Address AddressType="Mailing/Home"> <City>City</City> </Address> </Student> where City =
| |||||
(SPPI-14) | E1118 (DC124) | STATE-ABBREVIATION | STU.ST | Demographics | Mailing - State |
STU.RST | Residence - State | ||||
<Student id="SCID_SSS_XXXXXX"> <Address AddressType="Mailing/Home"> <StateAbbreviation>XX</StateAbbreviation> </Address> </Student> where XX =
| |||||
(SPPI-14) | E1119 | POSTAL-CODE | STU.ZC | Demographics | Mailing - Zip |
STU.RZC | Residence - Zip | ||||
STU.ZX | Mailing - Extn | ||||
STU.RZX | Residence - Extn | ||||
<Student id="SCID_SSS_XXXXXX"> <Address AddressType="Mailing/Home"> <PostalCode>NNNNN-XXXX</PostalCode> </Address> </Student> where NNNNN-XXXX =
| |||||
(SPPI-14) | E1122 (DC033) | COUNTRY-CODE | STU.CN | Demographics | Mailing - Country |
STU.RCN | Residence - Country | ||||
<Student id="SCID_SSS_XXXXXX"> <Address AddressType="Mailing/Home"> <CountryCode>CC</CountryCode> </Address> </Student> where CC =
| |||||
(SPPI-14) | E1455 (DC133) | TELEPHONE-NUMBER-TYPE | "Home" | ||
<Student id="SCID_SSS_XXXXXX"> <Telephone TelephoneNumberType="Home"> <TelephoneNumber>AAA-NNN-NNNN</TelephoneNumber> </Telephone> </Student> | |||||
(SPPI-14) | E1269 | TELEPHONE-NUMBER | STU.TL | Demographics | Telephone |
<Student id="SCID_SSS_XXXXXX"> <Telephone TelephoneNumberType="Home"> <TelephoneNumber>NNN-NNN-NNNN</TelephoneNumber> </Telephone> </Student> where NNN-NNN-NNNN = STU.TL | |||||
(SPPI-14) | E1242 (DC057) | EMAIL-ADDRESS-TYPE | "Home/Personal" | ||
<Student id="SCID_SSS_XXXXXX"> <ElectronicMail EmailAddressType="Home/Personal"> <EmailAddress>name@email.com</EmailAddress> </ElectronicMail> </Student> | |||||
(SPPI-14) | E1243 | EMAIL-ADDRESS | STU.SEM | Demographics | Student's Email |
<Student id="SCID_SSS_XXXXXX"> <ElectronicMail EmailAddressType="Home/Personal"> <EmailAddress>name@email.com</EmailAddress> </ElectronicMail> </Student> where name@email.com = STU.SEM | |||||
(CF) (CR) (ECDS-PK) (ECDS-KG) | E1375 | HISPANIC-LATINO-ETHNICITY | STU.ETH | Demographics | Ethnicity |
<Student id="SCID_SSS_XXXXXX"> <HispanicLatinoEthnicity>true/false</HispanicLatinoEthnicity> </Student> where true/false = true if STU.ETH = Y; otherwise false Omitted if blank | |||||
Rule (FATAL):
| |||||
(CF) (CR) (ECDS-PK) (ECDS-KG) (SELA) | E1343 (DC097) | RACIAL-CATEGORY | STU.RC1 * - STU.RC5 | Demographics | Race |
<Student id="SCID_SSS_XXXXXX"> <Race> <RacialCategory>Race</RacialCategory> <RacialCategory>Race</RacialCategory> <RacialCategory>Race</RacialCategory> </Race> </Student> where Race =
One entry for each race associated with the student. Full DC097 Code Translation is used rather than code. | |||||
Rule (FATAL):
| |||||
(ECDS-PK) (ECDS-KG) (SELA) | E1390 (DC079) | EMERGENT-BILINGUAL | PGM.TY | Special Programs | Program Type |
PGM.CD = 148 | Program Code | ||||
PGM.PSD/PGM.PED | Start Date/End Date | ||||
AUT.CD | Authorizations | Code | |||
AUT.TY = 4 | Type | ||||
<Student id="SCID_SSS_XXXXXX"> <LimitedEnglishProficiency>Status</LimitedEnglishProficiency> </Student> where Status = PGM.TY if PGM.CD = 148 Full DC079 Code Translation is used rather than code. Fixed code. | |||||
Rule (FATAL):
| |||||
(SELA) | E1723 | ELIGIBILITY-DATE | |||
<Student id="SCID_SSS_UUUUUUUUUU"> <Disabilities> <TX-EligibilityDateDisabilities>YYYY-MM-DD</TX-EligibilityDateDisabilities> </Disabilities> </Student> where YYYY-MM-DD = | |||||
Rule (FATAL)
| |||||
(SELA) | E1220 (DC142) | DISABILITY | CSE.DI/CSE.D2/CSE.D3 = 03 or 05 * | Special Education > Disabilities History | Primary Disability/Secondary Disability/Tertiary Disability |
<Student id="SCID_SSS_UUUUUUUUUU"> <Disabilities> <Disability>Description</Disability> </Disabilities> </Student> where Description =
| |||||
Rules (FATAL):
| |||||
(CF) (CR) (CSW) (ECDS-PK) (ECDS-KG) (RFT) (SELA) | E0212 | DISTRICT-ID | LOC.CC + LOC.DC | School Options | County + District |
<Student id="SCID_SSS_XXXXXX"> <TX-LEAReference> <EducationalOrgIdentity> <StateOrganizationId>CCCDDD</StateOrganizationId> </EducationalOrgIdentity> </TX-LEAReference> </Student> where:
| |||||
(ECDS-PK) | E0785 (C054) | ECONOMIC-DISADVANTAGE-CODE | FRE.CD * | Free and Reduced | NSLP Lunch Type Code |
FRE.ESD/FRE.EED | NSLP Eligibility - Start Date/End Date | ||||
<Student id="SCID_SSS_UUUUUUUUUU"> <TX-EconomicDisadvantaged>XX</TX-EconomicDisadvantaged> </Student> where X = FRE.CD | |||||
(RFT) | E706 (C012) | GENERATION-CODE | LSI.LSF | Demographics > Change > Show/Hide Legal Name | Legal Suffix |
STU.SF | Demographics | Suffix | |||
<Student id="SCID_SSS_XXXXXX"> <TX-GenerationCode>X</TX-GenerationCode> </Student> where X = LSI.LSF if present; otherwise STU.SF if present; otherwise omitted | |||||
(RFT) | E0004 (C013) | SEX-CODE | STU.GN * | Demographics | Gender |
<Student id="SCID_SSS_XXXXXX"> <TX-Sex>Male/Female</TX-Sex> </Student> where Male/Female = STU.GN | |||||
(RFT) | E1064 (C088) | HISPANIC-LATINO-CODE | STU.ETH | Demographics | Ethnicity |
<Student id="SCID_SSS_XXXXXX"> <TX-HispanicLatinoEthnicity>0/1</TX-HispanicLatinoEthnicity> </Student> where 0/1 = 1 if STU.ETH=Y; otherwise 0 | |||||
(RFT) | E1059 (C088) | AMERICAN-INDIAN-ALASKA-NATIVE-CODE | STU.RC1-STU.RC5 * | Demographics | Race-Race5 |
<Student id="SCID_SSS_XXXXXX"> <TX-Race> <TX-AmericanIndianAlaskaNative>0/1</TX-AmericanIndianAlaskaNative> </TX-Race> </Student> where 0/1 = 1 if STU.RC1/RC2/RC3/RC4/RC5=01; otherwise 0 | |||||
(RFT) | E1060 (C088) | ASIAN-CODE | STU.RC1-STU.RC5 * | Demographics | Race-Race5 |
<Student id="SCID_SSS_XXXXXX"> <TX-Race> <TX-Asian>0/1</TX-Asian> </TX-Race> </Student> where 0/1 = 1 if STU.RC1/RC2/RC3/RC4/RC5=02; otherwise 0 | |||||
(RFT) | E1061 (C088) | BLACK-AFRICAN-AMERICAN-CODE | STU.RC1-STU.RC5 * | Demographics | Race-Race5 |
<Student id="SCID_SSS_XXXXXX"> <TX-Race> <TX-BlackAfricanAmerican>0/1</TX-BlackAfricanAmerican> </TX-Race> </Student> where 0/1 = 1 if STU.RC1/RC2/RC3/RC4/RC5=03; otherwise 0 | |||||
(RFT) | E1062 (C088) | NATIVE-HAWAIIAN-PACIFIC-ISLANDER-CODE | STU.RC1-STU.RC5 * | Demographics | Race-Race5 |
<Student id="SCID_SSS_XXXXXX"> <TX-Race> <TX-NativeHawaiianPacificIslander>0/1</TX-NativeHawaiianPacificIslander> </TX-Race> </Student> where 0/1 = 1 if STU.RC1/RC2/RC3/RC4/RC5=04; otherwise 0 | |||||
(RFT) | E1063 (C088) | WHITE-CODE | STU.RC1-STU.RC5 * | Demographics | Race-Race5 |
<Student id="SCID_SSS_XXXXXX"> <TX-Race> <TX-White>0/1</TX-White> </TX-Race> </Student> where 0/1 = 1 if STU.RC1/RC2/RC3/RC4/RC5=05; otherwise 0 | |||||
(RFT) | E1629 | RESIDENTIAL-FACILITY-INDICATOR | PGM.CD = 407 | Special Programs | Program Code |
PGM.PSD/PGM.PED | Start Date/End Date | ||||
<Student id="SCID_SSS_XXXXXX"> <TX-ResidentialFacilityIndicator>true/false</TX-ResidentialFacilityIndicator> </Student> where true/false = true if
| |||||
(CSW) | E1677 (C088) | CHARTER-WAITLIST-INDICATOR-CODE | SCD.WS = On Waitlist | School of Choice Requests | Waitlist Status |
<Student id="SCID_SSS_XXXXXX"> <TX-CharterWaitListIndicator>0/1</TX-CharterWaitListIndicator> </Student> where 0/1 = 1 if SCD.WS = On Waitlist; otherwise 0 | |||||
Rule (FATAL):
Special Warning:
|
Additional Rules:
- 10020-0014: For each campus registered with TEA as an active instructional campus, there should be student data for each student served by the LEA.
- 40100-000A: For TSDS, the combination of the following fields must be unique for each student: DISTRICT-ID and TX-UNIQUE-STUDENT-ID.
- 40203-000A: The combination of the following fields must be unique for each leaver: DISTRICT-ID and TX-UNIQUE-STUDENT-ID.
- 40100-0187/40110-0211: For each student reported by the LEA, there must be StudentSectionAssociation data with a matching TX-UNIQUE-STUDENT-ID.
- 40100-0197/40110-0001: For each student reported by the LEA, there must be enrollment (StudentSchoolAssociation) data with a matching TX-UNIQUE-STUDENT-ID.
- (CF) GR2: Students age 21 or younger as of September 1st of the current school year, who are reported with a special education eligibility determination date in the current school year, shall be reported as part of the Child Find collection.
- (CR) GR2: Students enrolled in the LEA in grades 1-12 as of the last Friday in September should be reported as part of the Class Roster Fall Submission.
- (CR) 40100-0186: For a student being reported for the Class Roster collection, the following must not be blank: STUDENT-ID, SEX, HISPANIC-LATINO-ETHNICITY, and at least one RACIAL-CATEGORY.
- (ECDS) 40100-0185: For a student being reported for the ECDS collection, the following must not be blank: SEX, HISPANIC-LATINO-ETHNICITY, EMERGENT-BILINGUAL, and at least one RACIAL-CATEGORY.
- (SPPI-14) 40203-0023: If LEAVER-REASON-CODE is 01, 24, 88, 90, or 98, then student address information must be provided (ADDRESS-TYPE, STREET-NUMBER-NAME, CITY, STATE-ABBREVIATION, POSTAL-CODE).
StudentParentAssociation ↑
Submission | Element ID (Code Table) | Data Element | Aeries Table.Field | Aeries Page | Label |
(SPPI-14) | StudentReference ref | ENR.SC | Enrollment History | School | |
STU.ID | Student ID | ||||
<StudentParentAssociation> <StudentReference ref="SCID_SSS_XXXXXX"/> </StudentParentAssociation> where:
| |||||
(SPPI-14) | ParentReference ref | STU.ID | Demographics | Student ID | |
CON.OR = 1 or 2 | Contacts | Contact Order | |||
<StudentParentAssociation> <ParentReference ref="PARENT_XXXXXX_n"/> </StudentParentAssociation> where:
| |||||
(SPPI-14) | E1423 (DC105) | RELATION | CON.RL | Contacts | Relationship |
<StudentParentAssociation> <Relation>Relationship</Relation> </StudentParentAssociation> where Relationship = CON.RL Full DC105 Code Translation is used rather than code. | |||||
(SPPI-14) | E1427 | CONTACT-PRIORITY | CON.OR = 1 or 2 | Contacts | Contact Order |
<StudentParentAssociation> <ContactPriority>N</ContactPriority> </StudentParentAssociation> where N = CON.OR when CON.OR = 1 or 2 | |||||
Rule (FATAL):
|
Additional Rules:
- 49010-000F: The combination of the following fields must be unique for each StudentParentAssociation: StudentReference and ParentReference.