Tool Search: TSDS Extract

The Student Parent Interchange reports metadata about assessments, specifically the definitions of the assessments, the learning objectives, the learning standards, and assessment items.

Screenshot of the TSDS Student Parent Editor. TSDS Student Parent Editor

The Student Parent Interchange is reported in the following Submissions:

Submissions
ECDS Pre-K KG
SPPI-14
Classroom Roster (CR) Classroom Roster Fall (CRF) Classroom Roster Winter (CRW)
Special Education Language Acquisition (SELA)
Child Find (CF)

Report Population Logic

Click here to expand...

Students must comply with the following logic in order to be included in the report:

All:

The student is not state excluded.
The student has an active enrollment record at some point during the reporting period (and not marked as No Show).
The student has a Unique ID.

Pre-K:

The student was in grade Pre-K at any time during the reporting period.
The student had an assessment with a Parent Test or Child Test with a code of BOY or EOY that contains a Percentile Value or Raw Score that occurred during the reporting period.

Kindergarten:

The student was in grade KG at any time during the reporting period.
The student had an assessment with a Parent Test or Child Test with a code of BOY or EOY that contains a Percentile Value or Raw Score that occurred during the reporting period.
For all students that were enrolled on the assessment date but were not assessed, the user will need to enter a -999 score for that student on that assessment in order to be reported correctly to the state.

SPPI-14

Only report calendars/schools/districts that have students who fit the following criteria:

Student:

Student is considered leaver AND SpEd ( student had an active and locked IEP at any point during their previous year enrollment)
- See Submission 1 > Student Enrollment > SchoolLeaverExtension
Student was in grades 9-12 in the previous school year

Parent Population:

Parent must be identified as a 'guardian' in their relationship to the student
Relationship and Household membership must have been active at sometime during the previous year's enrollment

Class Roster

Fall Class Roster ONLY reports calendars, courses, sections, teachers and students associated with grades 1-12.

Student:
- Fall: Only students in grades 1-12
- Winter: students in grades EE, PK, KG, and 1-12
- must be enrolled in a course/section on the Snapshot Date

SELA

Calendar/School reports if:

Student:
- is 8 years of age or younger on September 1st of current school year
- has an active and locked IEP at some point during the reporting period with either of the following active disabilities:
  - 05 Deaf-Blind
  - 03 Auditory Impairment
- has any ADA value including a value of 0
Not reported:
- students marked as State Exlcude
- students with null UID

Child Find (CF)

Student:

Student must have an enrollment and be 21 years of age or younger on September 1st in the current school year.
Student must have an active and locked IEP at some point during the reporting period with a SPED Eligibility Determination Date on or between July 1st and June 30th of the given school year.

Do not report

Students marked as State Exclude
Students who have no Unique State ID

Report Editor

The following tables define the options available on the editor.

Field	Description
Submission	ECDS (Early Childhood Data System) KG Pre-K SPPI-14 Classroom Roster - CR Classroom Roster Fall (CRF) Classroom Roster Winter (CRW) SELA (Special Education Language Acquisition) Child Find (CF)
Interchanges	Interchanges are XML Schema Definitions (XSDs) which group related complex types. Select Student Parent.
Type	XML
Start Date	The first day in the reporting date range. Only records between this date and the End Date are included.
End Date	The last day in the reporting date range. Any records past this date are not included.
Filter By	This field allows you to narrow the report results to specific Calendars, Calendar Years (District), or Schools.
Ad Hoc Filter	Select an Ad Hoc filter to limit report results to those that meet filter requirements.
Report Generation	The report can be marked to generate immediately using the Generate Extract button or can be marked to generate at a later time using the Submit to Batch button. See the Batch Queue article for additional guidance.

XML Elements

Student

XML Element	Description	Location
StudentUniqueStateId	A unique number assigned by the state Department of Education. Submission: KG / PK SPPI-14 CRF/CRW SELA CF Numeric, 10 digits	Census > People > Demographics > Unique State ID Person.stateID
StudentIdentificationCode
IdentificationSystem	Reports a value of 'State'. Submission: KG / PK SPPI-14 CRF/CRW SELA CF Alphanumeric, 16 characters	N/A
IdentificationCode	Reports the student's Previous State ID. If no value, then report SSN. If both fields are null, report blank. Submission: KG / PK SPPI-14 CRF/CRW SELA CF Numeric, 9 digits	Census > People > Demographics > Person Identifiers > Local Student ID OR Previous State ID Person.studentID Person.stateID
IdentificationSystem *Optional for CRF/CRW	Reports a value of "District". Submission: CRF/CRW SELA Alphanumeric, 7 characters	N/A
IdentificationCode	Reports District Student ID. If not available, reports the Person ID. Submission: CRF/CRW SELA Numeric, 9 characters	Census > People > Demographics > Person Identifiers > Local Student ID OR Person ID Person.studentID Person.stateID
Name
FirstName	Reports the student's first name. Submission: KG / PK SPPI-14 CRF/CRW SELA CF Alphanumeric, 60 characters	Census > Demographics > Person Information > First Name Identity.firstName
MiddleName Optional for Pre-K/KG and* SPPI-14	Reports the student's middle name. Otherwise, reports blank. Element does not report if the student does not have a middle name identified. Submission: KG / PK SPPI-14 CRF/CRW SELA CF Alphanumeric, 60 characters	Census > Demographics > Person Information > Middle Name Identity.middleName
LastSurname	Reports the student's last name. Submission: KG / PK SPPI-14 CRF/CRW SELA CF Alphanumeric, 60 characters	Census > Demographics > Person Information > Last Name Identity.lastName
GenerationCodeSuffix	Reports the student's suffix name. Submission: SPPI-14 CRF/CRW SELA CF Alphanumeric, 4 characters	Census > Demographics > Person Information > Suffix Identity.suffix
Sex	Reports the student's gender. Submission: KG / PK SPPI-14 CRF/CRW SELA CF Alphanumeric, 1 digits (M or F)	Census > Demographics > Person Information > Gender Identity.gender
BirthData
BirthDate	Reports the student's date of birth. Submission: KG / PK SPPI-14 CRF/CRW SELA CF Date field, 10 digits (YYYY-MM-DD )	Census > People > Demographics > Person Information > Birth Date Identity.dateOfBirth
Address
AddressType	When Mailing is checked, reports Mailing. When Mailing is not checked AND Physical is checked report Physical. When Mailing and Physical are not checked AND Secondary or Private is checked report Other. When nothing is checked report Home. Submission: SPPI-14 Alphanumeric, 9 characters	Census > Addresses > Address Location Detail Address.mailing
StreetNumberName	Reports street address (all components). Submission: SPPI-14 Alphanumeric, 100 characters	Census > Addresses Address.number Address.street Address.tag Address.dir
City	Reports the City of residence. Submission: SPPI-14 Alphanumeric, 50 characters	Census > Address > City Address.city
StateAbbreviation	Reports the State abbreviation. Submission: SPPI-14 Alphanumeric, 2 characters	Census > Address > State Address.state
PostalCode	Reports the address zip code. Submission: SPPI-14 Numeric, 9 digits (12345-XXXX)	Census > Address > Zip Address.zip
CountryCode	Reports US. Submission: SPPI-14 Alphanumeric, 2 characters	N/A
Telephone
TelephoneNumberType	When Cell Phone contains a value, reports Mobile. When Cell Phone is blank and Work Phone contains a value, reports Work. When Cell Phone and Work Phone are not populated, and Other Phone contains a value, reports Other. Submission: SPPI-14 Alphanumeric, 11 characters	Census > People > Demographics > Personal Contact Information Contact.cellPhone Contact.workPhone
TelephoneNumber	Reports the Phone Number with no dashes (include area code and extension if applicable - max 14 characters). Submission: SPPI-14 Numeric, 14 digits	Census > People > Demographics > Personal Contact Information Contact.phone
ElectronicMail
EmailAddressType	Reports as Home / Personal. Submission: SPPI-14	N/A
EmailAddress	Report the Email address. If not populated, reports the Secondary Email. Submission: SPPI-14 Alphanumeric, 128 characters	Census > People > Demographics > Personal Contact Information Contact.email Contact.secondaryEmail
HispanicLatinoEthnicity	Report 1 if student is Yes for "Is the individual Hispanic / Latino?" Otherwise, report 0. Submission: KG / PK SPPI-14 CRF/CRW SELA CF Numeric, 1 digit	Census > People > Demographics > Person Information > Race /Ethnicity > Hispanic/Latino Identity.raceEthnicity
Race
RacialCategory	Reports the name(s) of the student's Race/Ethnicity. Repeat the element within the race complex and report 1 value for every box checked in Race/Ethnicity. Report "American Indian - Alaskan Native" if Race/Ethnicity contains a check in American Indian or Alaskan Native. Report "Asian" if Race/Ethnicity contains a check in Asian. Report "Black - African American" if Race/Ethnicity contains a check in Black or African American. Report "Native Hawaiian - Pacific Islander" if Race/Ethnicity contains a check in Native Hawaiian or Other Pacific Islander. Report "White" if Race/Ethnicity contains a check in White. Submission: KG / PK SPPI-14 CRF/CRW SELA CF Alphanumeric, 34 characters	Census > People > Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity
EconomicDisadvantaged *Optional	Reports 1 when: The Code 99 box is checked or student has an active FRAM record containing a State Code. All others, report 0 Submission: PK Numeric, 1 digit	Student Information > General > Enrollments > State Reporting Fields > Code 99 Enrollment.code99 System Administration > FRAM > Eligibility > State Code Eligibility.eligibility
LimitedEnglishProficiency	Non-Emergent Bilingual reports if the student does not have an active EL record at the time of reporting OR is not in monitoring status. Records with pending status are considered inactive and should report as non-emergent. Emergent Bilingual reports if the student has an active EL record at the time of reporting. Monitored 1 reports if the student has an end dated EL record and is in monitoring status. 'In monitoring' is defined as an end dated EL record that is within the 4 years of monitoring. Submission: KG / PK SELA Coded	Student Information > Program Participation > English Learners (EL) Lep.programStatus
TX-LEAReference > EducationalOrgIdentity
StateOrganizationID	The reporting district's State District Number. Submission: KG / PK SPPI-14 CRF/CRW CF Numeric, 4 digits	System Administration > Resources > District Information > State District Number District.number
Disabilities The following disability elements report if student has: an active/locked IEP during the reporting period WITH a Primary Disability value on the Settings and Disabilities tab in the IEP AND the disability has an active date that falls within the reporting period.
TX-EffectiveDateDisabilities	Reports start date. Submission: SELA Date field, 10 characters (YYYY-MM-DD )	Student Information > Special Education > General > Documents > Education Plan > Start Date Plan.startDate
Disability	Reports the name of the Disability. If Disability is 05, reports 'Deaf-Blindness (Deaf-Blind)' If Disability is 03, reports 'Deaf and Hard of Hearing' Submission: SELA Alphanumeric, 38 characters	Student Information > Special Education > General > Documents > Settings and Disabilities > Primary Disability PlanState.disability1
TX-LEAReference > EducationalOrgIdentity
StateOrganizationID	The reporting district's State District Number. Submission: SELA Numeric, 6 digits	System Administration > Resources > District Information > State District Number District.stateNumber
TX-HomeLanguage	Report the state code of the student's Home Language from the most current Identity. If blank/null, then do not report. Submission: SPPI-14 Alphanumeric, 2 characters	Census > Person > Demographics > Home Primary Language student.homePrimaryLanguage

Parent

Household membership, address, and guardian relationship must be active during the previous school year in order to be considered.

All active addresses and guardian relationships will be reported.

XML Element	Description	Location
ParentUniqueStateID	Reports the parent unique ID. Numeric, 15 digits	Census > Demographics > Person Information > Parent Unique State ID Person.additionalID
Name
FirstName	Reports the parent's first name. Submission: SPPI-14 Alphanumeric, 75 characters	Census > Demographics > Person Information > First Name Identity.firstName
MiddleName	Reports the parent's middle name. Submission: SPPI-14 Alphanumeric, 30 characters	Census > Demographics > Person Information > Middle Name Identity.middleName
LastSurname	Reports the parent's last name. Submission: SPPI-14 Alphanumeric, 75 characters	Census > Demographics > Person Information > Last Name Identity.lastName
GenerationCodeSuffix	Report suffix name. Alphanumeric, 4 characters	Census > Demographics > Person Information > Suffix Identity.suffix
Address
AddressType	Reports whether the address is the mailing address. If Mailing is checked report Mailing. If Mailing is not checked AND Physical is checked report Physical. If Mailing and Physical are not checked AND Secondary or Private is checked report Other. If nothing is checked report Home. Submission: SPPI-14 Alphanumeric, 9 characters	Census > Addresses > Address Location Detail > Mailing Address.mailing
StreetNumberName	Reports the parent's street address (all components). Alphanumeric, 40 characters	Census > Addresses Address.number Address.street Address.tag Address.dir
ApartmentRoomSuiteNumber *Optional	Reports the apartment number of the address. Submission: SPPI-14 Alphanumeric, 20 characters	Census > Addresses > Apt Address.apt
City	Reports the City in which the parent resides. Submission: SPPI-14 Alphanumeric, 30 characters	Census > Addresses > City Address.city
StateAbbreviation	Report State (2 digit abbreviation) Submission: SPPI-14 Alphanumeric, 2 characters	Census > Addresses > State
PostalCode	Report Zipcode. Submission: SPPI-14 Coded, 17 characters	Census > Addresses > Zip
CountryCode	Report US. Submission: SPPI-14 Alphanumeric, 2 characters	Coded
Telephone
TelephoneNumberType	If Cell Phone contains a value, reports Mobile. If Cell Phone is Null and Work Phone contains a value, reports Work. If Cell Phone and Work Phone are Null, and Other Phone contains a value, reports Other. Submission: SPPI-14 Alphanumeric, 11 characters	Census > People > Demographics > Personal Contact Information > Cell Phone, Work Phone, Other Phone Contact.cellPhone Contact.workPhone Contact.other
TelephoneNumber	Report Phone Number with no dashes (include area code and extension if applicable - max 14 characters) Submission: SPPI-14 Numeric, 14 Characters	Census > People > Demographics > Personal Contact Information > Cell Phone, Work Phone, Other Phone Contact.cellPhone Contact.workPhone Contact.other
ElectronicMail
EmailAddressType	Reports Home / Personal Submission: SPPI-14 Alphanumeric, 13 characters	N/A
EmailAddress	Reports the person's Email, if null report Secondary Email Submission: SPPI-14 Alphanumeric, 128 characters	Census > People > Demographics > Personal Contact Information > Email, Secondary Email Contact.email Contact.secondaryEmail

StudentParentAssociation

XML Element	Description	Location
StudentReference > ParentReference
Relation	Reports the Name of Relationship. Submission: SPPI-14 Alphanumeric, 26 characters	Census > People > Relationships > Relationship RelatedPair.relationship System Administration > Census > Relationship Types RelationshipType.name
ContactPriority	Indicates count of priority level of contact. Primary = 1, all others count up from that value Submission: SPPI-14 Numeric, 2 digits	Census > People > Relationships > Relationship > Emergency Priority RelatedPair.sequence

Appendix A

Code	Name
01	Jr
02	Sr
03	II
04	III
05	IV
06	V
07	VI
08	VII
09	VIII
10	I
11	IX
12	X

Student Parent (TSDS) (Texas)