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

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

Search TermsParent 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

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.

FieldDescription
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.

TypeXML
Start DateThe first day in the reporting date range. Only records between this date and the End Date are included.
End DateThe 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.

OptionDescription
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 FilterSelect 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 ElementDescriptionLocation

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 ElementDescriptionLocation

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 ElementDescriptionLocation
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

CodeName
01

Jr

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



Previous Versions

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