Education Organization Interchange (TSDS) (Texas)

Last Modified on 10/22/2022 10:38 am CDT

Classic View: TX State Reporting > TSDS Extract > Education Organization Interchange

Search Terms: Education Organization Interchange, Organization Interchange, Education Interchange

The Education Organization interchange provides information about the state education agency, education service centers, local education agencies (school districts and charter schools), and campuses. This data category supports the definition of the education offerings provided by campuses, specifically the courses taught, the sections in each course offered and the class period and location of those sections, and the alternative/supplemental programs offered.

The shared services arrangement (SSA) participation data is also reported for each organization type when applicable.

 Courses with the State Report Exclude option selected on the Courses tab (Scheduling > Courses > Course) do NOT report.

TSDS Extract Editor/Education Organization Interchange

Report Editor

The following tables define the options available on the editor.

FieldDescription
Submission
  • 1 - Fall (prior/current year)
  • 3 - Summer
  • 4 - Extended
  • ECDS (Early Childhood Data System)
  • SPPI-14
  • Class Roster (CR)
    • Class Roster Fall (CRF)
    • Class Roster Winter (CRW)
  • SELA
  • Class Find (CF)
Interchanges
Interchanges are XML Schema Definitions (XSDs) which group related complex types.

Select Education Organization.

Effective Date

Submission 3 & 4 Only

Only data as of this date reports. Default value is today's date.

Total Number School Board Req

Submission 3 Only

Indicates the total number of requests submitted outside of a school board meeting by a member of the district’s board of trustees (school board) for information, documents, and records.

Total Cost School Board ReqSubmission 3 Only
Indicates the total cost of fulfilling school board requests that occur outside of school board meetings.
Num Bullying IncidentsSubmission 3 Only
Indicates the total number of bullying incidents reported, up to five digits.
Num Cyber-Bullying IncidentsSubmission 3 Only
Indicates the total number of cyber bullying incidents reported, up to five digits.
Fall Snapshot Date

Submission 1 Only

The last Friday in October.

Last Day of School Start Window

Submission 1 Only

Default value is today's date.

Status
  • Regular
  • Resubmission
  • Working Collection
Report TypeXML
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.

PopulationThis option allows you to limit report results to Unique IDs. The Unique ID option only considers students with a Unique ID. The All option considers all students.
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.

Report Population:

All:

Do not report the following:

  • School marked as State Exclude
  • School marked as Type > In Construction
    • EXCEPT for the SchoolExtension complex type
  • Calendar marked as State Exclude

Report one record for each school that has the following:

  • Active enrollments
  • Active courses & sections (does not apply to SELA or SPPI)
  • Active staff & teachers (does not apply to SELA or SPPI)

ECDS Only

Consider all above population logic.

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

All:

  • Student is not state excluded
  • Student has an active enrollment at some time during the reporting period (not marked as No Show)
  • Student has a Unique ID

Pre-K:

  • Student that was in grade Pre-K at any time during the reporting period
  • Student that 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 value that occurred during the reporting period

KG:

  • Student that was in grade KG at any time during the reporting period
  • Student that 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 value that occurred during the reporting period

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

Calendar:

  • Class Roster Fall: ONLY reports calendars associated to grades 1-12 

Student:

  • Class Roster Winter: Students in grades EE, PK, KG, and 1-12
  • Class Roster Fall: ONLY students in grades 1-12
  • Student must be enrolled in a reportable course/section (see below) with a reportable teacher (see below) on the Snapshot Date
  • Course:
    • Course must contain a reportable teacher (see below)
    • Class Roster Fall: ONLY reports courses and sections associated to grades 1-12

Teacher:

  • Class Roster Fall: ONLY reports teachers associated to grades 1-12
  • If Secondary Teacher on the Course > Section has a District Assignment that is equal to Teacher or Substitute Teacher AND a Class Role equal to 01, 02 or 03.
  • Then report a record for both the Primary Teacher and the Secondary Teacher(s) on the Section
  • Teacher must have a Title Code of 047 or 087
  • Teacher must have a Class Role of 01, 02, or 03
  • Teacher must have been assigned to a course on the Snapshot Date
  • If a teacher has multiple course > sections (with a State Code that is not blank) in one period, a record will report for each Course > Section.
  • Report Primary Teacher only EXCEPT:
  • For Manual Teacher Section Records Only: If the Role ID in the 090 Section of the District Assignment tab is 047 or 087, report only if ALL the following fields are populated in the tab: Non-Teaching Service ID, Class ID Number, Monthly Minutes, Class Type Code, Population Served and Number of Students in a Class.

Do not report:

  • Students with an ADA value of 0
  • Courses with a Service ID (Course Code) that starts with SA, SE, SR, SS, or 8
  • School/Calendar/Staff/Student/Course that are marked as State Exclude
  • Teachers or Students with null UID

SELA

Calendars/Schools report if: 

 Student:

  • 8 years of age or younger on September 1st of the current school year
  • has an Active and locked IEP at some point during the reporting period with either active disabilities of:
    • 05 Deaf Blind
    • 03 Auditory Impairment
  • has any ADA value, including 0

Not reported:

  • students marked as State Exclude
  • students with null UID

Child Find (CF)

To report, the following conditions must be met:

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

XML Elements

LocalEducationAgency

XML ElementDescriptionLocation
StateOrganizationId

 Required


Reports the State District Number assigned by the State.

Submission:

1, 3 & 4

KG / PK

SPPI-14

CRF / CRW

SELA

CF
Numeric, 6 digits		System Administration > Resources > District Information > State District Number

Database:
District.number
ProgramReference

Optional


Reports reference and reference ID for every value entered into Program Type. If no Program Type is reported, do not report.

Submission:

PK

SPPI-14

CRF / CRW

SELA

CF

System Administration > Resources > District Information > Program Type
TX-FamilyEngagementPlanLink

Optional


Reports value.

Submission:
PK

String, 200 characters		System Administration > Resources > District Information > District Detail > Family Engagement Plan Link
TX-TotalNumSchoolboardRequests

Optional


The total number of times the school board requested information.

Submission:
3

Numeric, 3 digits		N/A
TX-TotalCostSchoolboardRequests

Optional


The cost of fulfilling the total number of requests submitted outside of a school board meeting by a member of the district’s board of trustees (school board).

Submission:
3

Numeric, 6 digits		N/A
TX-ArmedServicesVocAptBatteryIndicator

Required 


Indicates whether the school participates in Federal ASVAB testing or an alternate.

Submission:
1

Coded, 2 digits		System Administration > District Information > ASVAB

Database:
School.asvab
TX-ProgramsOfStudy
TX-ProgramOfStudy

Required


Report Program of Study value.  If no value, report 000.

Submission:
1

Coded, 3 characters		Administration > Resources > District Information > Program of Study
TX-GiftedTalentedPrograms
TX-GiftedTalentedProgramCode

Required


Report Gifted and Talented Program value.  If no value, report 00.

Submission:
1

Coded, 2 characters		System Administration > District Information > Gifted Talented Program

Database:
Program.code

School

Reporting logic:

  • Report one record for every active Instructional campus. 
  • Submission 1 Only: Report one record for every active In Construction campus.
    • Do not report any other interchanges or complexes for these schools - regardless if they have staff, students, or courses within them.
XML ElementDescriptionLocation
StateOrganizationId

 Required


Reports the State District Number assigned by the State and the State School Number

Submission:

1, 3 & 4

KG / PK

SPPI-14

CRF / CRW

SELA
CF

Numeric, 9 digits

System Administration > Resources > District Information > State District Number

AND

System Administration > Resources > School > State School Number


Database:

District.number

School.number


LocalEducationAgencyReference > EducationalOrgIdentity
StateOrganizationId

 Required


Reports the State District Number assigned by the State.

Submission:
1, 3 & 4
SELA

Numeric, 6 digits		System Administration > Resources > District Information > State District Number

Database:
District.number
ClassPeriodReference

Required for Submissions: ECDS, SPPI14, CR


Optional: Submission 3


Reports the class period.

Submission:

3

KG / PK

SPPI-14

CRF / CRW

Course/Section > Sections > Section Schedule Placement > Period
TX-CampusEnrollmentType

Required


Report the Campus Enrollment Type value. If no value exists in the field, report 00.

Submission:
1

Coded, 2 characters		System Administration > Resources > School> Campus Enrollment Type
TX-NSLPTypeCode

 Required


  • If no values exist in National School Lunch Program(NSLP) AND Provision field is NULL then 00 reports.
  • If National School Lunch Program(NSLP) field is checked AND Provision field is NULL then 01 reports.
  • If Provision value is 2: Provision 2 AND the NSLP field is checked AND the reporting year falls within the Provision Base Year and the Provision End Year, then 02 reports.
  • If Provision value is 5: CEP AND the NSLP field is checked AND the reporting year falls within the Provision Base Year and the Provision End Year, then 03 reports.


Submission:

1

Numeric, 2 digits		System Administration > Resources > School > Original Record > USDA Programs
TX-PKFullDayWaiver

Optional


If PK Full Day Waiver box is checked, report 1. 

If box is not checked, do not report.


Submission:

3

Coded, 1 digit		System Administration > Resources > School

Database:
School.pkFullDayWaiver
TX-ExpandedLearning OpportunityIndicator

Required


If school has a ELO record that is active at any time during the reporting period, report 1.


All others, report 0.


Submission:

3 & 4

Coded, 1 digit		System Administration > Resources > School

Database:
ExpandedLearningOpportunities
TX-SchoolELOS

Optional


If TX-ExpandedLearningOpportunityIndicator = 1, report full complex type.  

If =0, do not report complex type.


Submission:

3 & 4


Numeric, 2 digits		N/A
TX-SchoolELO
TX-ELOType

Required


If ELO Type contains a value, report that value.


All others, report 0.


Submission:

3 & 4


Coded, 2 digits		System Administration > Resources > School

Database:
ExpandedLearningOpportunities. eloType
TX-SchoolELOActivity

Required


For every Expanded Learning Opportunities record that is active during the reporting period:

  • One full complex type for each selected Expanded Learning Opportunity reports. box checked at
  • If no boxes are checked, the complex type does not report. 
System Administration > Resources > School > Expanded Learning Opportunities
TX-ELOActivityCode

Required

Report code as follows when marked:

  • Rigorous Coursework - 01
  • Mentoring - 02
  • Tutoring - 03
  • Physical Activity - 04
  • Academic Support - 05
  • Educational Enrichment - 06
System Administration > Resources > School > Expanded Learning Opportunities
TX-ELODaysScheduledPerYear

Required


If ELO Days per Year contains a value, report that value.

All others, report 0.


Submission:

3 & 4

Numeric, 3 digits
System Administration > Resources > School > Expanded Learning Opportunities


Database:
ExpandedLearningOppotunities. eloDaysPerYear
TX-ELOMinutesScheduledPerDay

Required


If ELO Minutes per Day contains a value, report that value.

All others, report 0.


Submission:

3 & 4

Numeric, 3 digits		System Administration > Resources > School

Database:
ExpandedLearningOppotunities. eloMinutesPerDay
TX-NumberOfBullyingIncidents

Required


Reports entered value. Left zero pad to make 5 digits.  If Null, report 000.

Submission:

3

Numeric, 5 digits
TX State Reporting > TSDS Extract Editor > Num Bullying Incidents
TX-NumberOfCyberBullyingIncidents

Required


Reports entered value. Left zero pad to make 5 digits. If Null, report 000.

Submission:

3

Numeric, 5 digits
TX State Reporting > TSDS Extract Editor > Num Cyber-Bullying Incidents

ClassPeriod

XML Element

Description

Location

ClassPeriod / id

 Required 

An identifier that links the Class Period Reference to the original Class Period. 

Submission:

3

KG / PK

SPPI-14

CRF / CRW


N/A
ClassPeriodName

 Required 

Reports the sequence number of the earliest period the class was offered EVEN if the period is marked as non-instructional.

The value reported for may consist of any combination of letters (A – Z) and/or numbers (0 – 9).


Submission:

3

KG / PK

SPPI-14

CRF / CRW



Alphanumeric, 2 characters

Scheduling > Courses > Sections > Section Schedule Placement

AND

System Administration > Calendar > Calendar > Periods > Period Info


Course

Reporting Logic:

  • An assigned Primary Teacher (Teacher of Record) with a Role ID of 087 or 047
  • A section with rostered, reportable students
  • A grading task with the Pass/Fail Indicator Code checked AND a Code of either CG or F

 

This complex type includes courses taught by Staff members reporting in the Staff Association Interchange due to manual 90 records being in their employment information.

Submission 3 only: 
  • Only students in grades 9-12 will report UNLESS a student in grades 3-8 is taking a course where high school credit is earned. 
  • A course is considered as high school credit if:
    • the course has a Special Explanation code of J OR the student has a Special Explanation code of J assigned to them in the Roster Batch Edit tool.

XML Element

Description

Location

Course Code
CourseCode / IdentificationSystem

 Required 

This field always reports "State course code."

Submission:

1, 3 & 4

KG / PK

CRF / CRW


Alphanumeric, 31 characters		Scheduling > Course Section > Course
ID

 Required




This field reports the State Code from the Course(s) as the Service ID.

  • If there are any students actively enrolled in the Course > Section OR students were actively enrolled with a different Service ID (Roster Batch Edit > Course State code (override)), this field reports the Course State Code (override) as the Service ID.

    Example
    A Course has a State Code of N1234567, but two students in the Course have a Service ID of ABCD0987 entered on the Roster Batch Edit Course State Code override. TWO 300 records would report for this Course > Section, one for each Service ID.

  • If the Service ID entered in the Course State Code (override) in Roster Batch Edit is greater than 8 characters in length, 8 zeros report on the extract.
  • If the Service ID entered in the Course State Code (override) in Roster Batch Edit is less than 8 characters in length, the ID reports as entered on the extract.
  • A Course with a blank State Code (Service ID) will not report unless there is a Course State Code (override) in Roster Batch Edit. If both fields are blank, the Course will not report.
Submission:

1, 3 & 4

KG / PK

CRF


Alphanumeric, 8 characters		Scheduling >
Course >
Course/Section >
Section Editor >
Roster Batch Editor >
Section ID

Database:
Course.courseID
Course CodeIf a complex type CourseCode is being reported above, then this second complex type will accompany it.  This complex will not report unless associated with a previously reported CourseCode for State course code.
CourseCode /IdentificationSystem

Required

Report "LEA course code"

Submission:

KG / PK

CRF / CRW


Scheduling > Course/Section > Course Editor
ID

Required




Report the CourseID from the Course reported above.

In instances where a course is reporting multiple times due to a student having a unique Course Code Override value

  • An increasing alpha character will be added at the end of the local course code to create a unique identifier
  • The unique identifier will match the following local course code instances in the Master Schedule Interchange
    • Course Offering > Local Course Code
    • Course Offering > Identification System > ID
    • Section > Local Course Code

Submission:

PK

CRF / CRW

Course/Section > Course Editor > CourseID

Course.CourseID








Education Organization Reference > EducationOrgIdentity
StateOrganizationId

 Required 


Reports the State District Number assigned by the State and the State school number.

Submission:
1, 3 & 4

Numeric, 9 digits

System Administration > Resources > District Information > State District Number


AND


System Administration > Resources > School > State School Number


Database:

District.number

School.number


Program

Complex ONLY reports if ProgramReference was reported in LocalEducationAgency complex. For every reference, one complex will report. 

ECDS-PK: Program complex only reports if a special education student is reported in ProgramReference in StudentSpecialEdProgramAssociationExtension.





XML ElementDescriptionLocation
ProgramType/ID

Optional for PK only


An identifier that links the Program Type reference to the Program Type.

Submission:

PK

CRF/CRW

SPPI-14

SELA

CF

N/A
ProgramType

Optional for PK only.

Reports the Program name.

For every reference, one program will report.

Submission:

PK

SPPI-14

CRF / CRW

SELA

CF


Coded, 48 characters		System Administration > Resources > District Information > Program Type


Related Articles

Was this helpful?
Thank you for your feedback!
User Icon

Thank you!

Copyright ©️ 2010-2023 Infinite Campus, Inc. All rights reserved. | Terms of Use | Privacy Policy | infinitecampus.com