Classic View: TX State Reporting > TSDS Extract > Student Parent

Search Terms: Parent TSDS

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

The Student Parent Interchange is reported in the following Submissions:

Submissions
ECDS KG Pre-K
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.

Option	Description
Calendar	This option allows you to select the specific calendar(s) to include in the report.
District	This option allows you to select the specific Calendar Year to include in the report.
School	This option allows you to select the specific school(s) to include in the report.

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 Required	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
StudentIdentificationCode
IdentificationSystem Required	Reports a value of 'State'. Submission: KG / PK SPPI-14 CRF/CRW SELA CF String, 16 characters	N/A
IdentificationCode Required	Report 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 Coded, 9 characters	Census > People > Demographics > Person Identifiers > Local Student ID OR Previous State ID
IdentificationSystem Optional (CRF/CRW) Required (SELA)	Report "District" Submission: CRF/CRW SELA	N/A
IdentificationCode Required	Report District Student ID, if Null, report Person ID. Submission: CRF/CRW SELA Namefield, 9 characters	Census > People > Demographics > Person Identifiers > Local Student ID OR Person ID
Name
FirstName Required	The reporting student's first name. Submission: KG / PK SPPI-14 CRF/CRW SELA CF Namefield, 60 characters	Census > Demographics > Person Information > First Name
MiddleName Required: CR, SELA Optional: SPPI-14, ECDS	The reporting student's middle name. Otherwise, reports blank. KG only: Element does not report if the student does not have a middle name identified. Submission: KG / PK SPPI-14 CRF/CRW SELA CF Namefield, 60 characters	Census > Demographics > Person Information > Middle Name
LastSurname Required	The reporting student's last name. Submission: KG / PK SPPI-14 CRF/CRW SELA CF Namefield, 60 characters	Census > Demographics > Person Information > Last Name
GenerationCodeSuffix Required	The reporting student's suffix name. Submission: SPPI-14 CRF/CRW SELA CF Coded, 4 characters	Census > Demographics > Person Information > Suffix
Sex Required	The reporting student's gender. Submission: KG / PK SPPI-14 CRF/CRW SELA CF	Census > Demographics > Person Information > Gender
BirthData
BirthDate Required	The student's date of birth. Submission: KG / PK SPPI-14 CRF/CRW SELA CF	Census > People > Demographics > Person Information > Birth Date
Address
AddressType Required	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	Census > Addresses > Address Location Detail
StreetNumberName Required	Report street address (all components). Submission: SPPI-14	Census > Addresses
City Required	Report City. Submission: SPPI-14	Census > Address > City
StateAbbreviation Required	Report State (2 digit abbreviation). Submission: SPPI-14	Census > Address > State
PostalCode Required	Report Zip. Submission: SPPI-14	Census > Address > Zip
CountryCode Required	Report US. Submission: SPPI-14	Coded to report US
Telephone
TelephoneNumberType Required	If Cell Phone contains a value report Mobile. If Cell Phone is Null and Work Phone contains a value, report Work. If Cell Phone and Work Phone are Null, and Other Phone contains a value report Other. Submission: SPPI-14	Census > People > Demographics > Personal Contact Information
TelephoneNumber Required	Report Phone Number with no dashes (include area code and extension if applicable - max 14 characters). Submission: SPPI-14	Census > People > Demographics > Personal Contact Information
ElectronicMail
EmailAddressType Required	Report Home/Personal. Submission: SPPI-14
EmailAddress Required	Report Email, if null report Secondary Email. Submission: SPPI-14	Census > People > Demographics > Personal Contact Information
HispanicLatinoEthnicity Required	Report 1 if student is Yes for "is the individual Hipanic/Latino?" Otherwise, report 0. Submission: KG / PK SPPI-14 CRF/CRW SELA CF	Census > People > Demographics > Person Information > Race/Ethnicity > Hispanic/Latino
Race
RacialCategory Required	Reports the name of the student's Race/Ethnicity. Submission: KG / PK SPPI-14 CRF/CRW SELA CF	Census > People > Demographics > Person Information > Race/Ethnicity
EconomicDisadvantaged Optional	Report 99 if Code 99 box is checked. If Code 99 box is not checked, report the student's last status. Submission: PK	CODE 99: System Admin > Student Info > General > Enrollments > State Reporting Fields OR Eligibility Status: System Administration > FRAM > Eligibility > State Code
LimitedEnglishProficiency Required	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 Emergent Bilingual reports if the student has an active EL record at the time of reporting Emergent Bilingual Monitored 1 reports if the student has an end dated EL record and is in monitoring status Emergent Bilingual Monitored 2 reports if the student has an end dated EL record and is in monitoring status KG / PK SELA	Student Information > Program Participation > English Learners (EL)
TX-LEAReference > EducationalOrgIdentity
StateOrganizationID Required	The reporting district's State District Number. Submission: KG / PK SPPI-14 CRF/CRW CF	System Administration > Resources > District Information > State 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 Required	Reports start date. Submission: SELA
Disability Required	If Disability is: 05 "Deaf-Blindness (Deaf-Blind)" report 03 "Hearing/Auditory Impairment (Auditory Impairment)" reports Submission: SELA
TX-LEAReference > EducationalOrgIdentity
StateOrganizationID Required	The reporting district's State District Number. Submission: SELA	System Administration > Resources > District Information > State District Number

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 Required	Report parent unique ID.	Census > Demographics > Person Information > Parent Unique State ID
Name
FirstName Required	Report first name. Submission: SPPI-14	Census > Demographics > Person Information > First Name
MiddleName Required	Report middle name. Submission: SPPI-14	Census > Demographics > Person Information > Middle Name
LastSurName Required	Report last name. Submission: SPPI-14	Census > Demographics > Person Information > Last Name
GenerationCodeSuffix Required	Report suffix name.	Census > Demographics > Person Information > Suffix
Address
AddressType Required	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	Census > Addresses > Address Location Detail
StreetNumberName Required	Report street address (all components).	Census > Addresses
ApartmentRoomSuiteNumber Optional	Report Apt. Submission: SPPI-14 String, 20 characters	Census > Addresses > Apt
City Required	Report City. Submission: SPPI-14 String, 30 characters	Census > Addresses > City
StateAbbreviation Required	Report State (2 digit abbreviation) Submission: SPPI-14 String, 2 characters	Census > Addresses > State
PostalCode Required	Report Zip. Submission: SPPI-14 Coded, 17 characters	Census > Addresses > Zip
CountryCode Required	Report US. Submission: SPPI-14 String, 2 characters	Coded
Telephone
TelephoneNumberType Required	If Cell Phone contains a value report Mobile. If Cell Phone is Null and Work Phone contains a value, report Work. If Cell Phone and Work Phone are Null, and Other Phone contains a value report Other. Submission: SPPI-14 String, 11 characters	Census > People > Demographics > Personal Contact Information
TelephoneNumber Required	Report Phone Number with no dashes (include area code and extension if applicable - max 14 characters) Submission: SPPI-14 Numeric, 14 Characters, XXXXXXXXXXXXXX	Census > People > Demographics > Personal Contact Information
ElectronicMail
EmailAddressType Required	Report Home/Personal Submission: SPPI-14 String, 13 characters
EmailAddress Required	Report Email, if null report Secondary Email Submission: SPPI-14 String, 128 characters	Census > People > Demographics > Personal Contact Information

StudentParentAssociation

XML Element	Description	Location
StudentReference > ParentReference
Relation Required	Report Name of Relationship. Submission: SPPI-14 String, 26 characters	Census > People > Relationships > Relationship AND System Administration > Census > Relationship Types
ContactPriority Required	Indicate 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

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

Previous Versions

Student Parent (TSDS) (Texas) [.2140-.2203]
Student Parent (TSDS) (Texas) [.2048-.2136]

Student Parent (TSDS) (Texas) [.2207 - .2219]