Education Org Calendar (TSDS) (Texas)

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

Classic View: TX State Reporting > TSDS Extract > Education Org Calendar

Search Terms: Education Org, Education Calendar, Education Org Calendar

This interchange identifies every weekday during the school year and identifies whether it was an instructional day. It also reports the attendance periods for each school selected. This interchange is for Submission 3 only.

TSDS Education Org Calendar Editor

Logic

To report, the following logic is used. 

Submission 3

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
  • Active staff & teachers

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

Report Editor

The following tables define the options available on the editor.

FieldDescription
Submission

3 - Summer

Child Find (CF)

Interchanges
Interchanges are XML Schema Definitions (XSDs) which group related complex types.

Select Education Org Calendar.

Effective Date

Only data as of this date reports. 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.

CalendarDateExtension

This extension represents a day in the school calendar.

One complex is reported for every day marked as Instructional (System Administration > Calendar > Calendar > Days > Day Detail > Instruction) during the school year AND every day marked as a Waiver Day (System Administration > Calendar > Calendar > Days > Event Type (01, 02, 03, 04, or 99)).

CalendarDateExtension Example

XML Element
Description
Location
Date

Required


The day marked as "Instructional."

Submission:
3
CF

Date Field, 10 characters
YYYY-MM-DD
System Administration > Calendar > Calendar > Days > Day Detail > Date

Database:
Calendar.date

TX-SchoolDayCode

Required


Indicates whether there is a Day Event on the Instructional day.

  • If the date is marked as Instructional and has a Day Event with a code in Value (other than 03), then 02 reports. If the Day Event Code is 03, 01 reports.
  • If the date is marked as Instructional and does NOT have a Day Event with a code in the Value, then 01 reports.
  • If the date is NOT marked as Instructional and has a Day Event with a code in Value, then 02 reports.
  • If the date is NOT marked as Instructional and DOES NOT have a Day Event with a code in Value, then the entire day does not report.
Submission:
3
CF

Numeric, 2 digits
System Administration > Calendar > Calendar > Days > Day Detail > Day Events AND Instructional

Database:
Day.eventType

TX-CalendarWaiverEventType

Optional


If there IS a Day Event, the value reports.

Districts MUST set up the Day Event Types with the Code in the Value field or they will not report correctly.


Submission:
3
CF

Numeric, 2 digits
System Administration > Calendar > Calendar > Days > Day Detail > Day Events

Database:
Day.eventType

TX-SchoolDayOperationalMinutes

Required for Submission 3 only


The number of instructional minutes in the school day. This field will only report for calendars with an Instructional Program Type = 01 or 02

Waiver Days

  • Report from Day Event > Duration (if value is 0, reports 0)
  • If value in Event > Duration is NULL or 0 then reports from School Day

Non-Waiver Days

  • Reports from School Day

When reporting from School Day - a value reports from the Period Schedule attached to that day.

*A Waiver Day is any day containing a Day Event code that contains data in the Value field.


Submission:
3
CF

Numeric, 3 digits

System Administration > Calendar > Calendar > Days > Day Detail > Duration

OR

System Administration > Calendar > Periods > Period Schedule/Periods Editor > Period Schedule Info > School Day




TX-SchoolDayInstructionalMinutes

Optional


The number of instructional minutes in the school day. This field will only report for calendars with an Instructional Program Type = 04, 05, 06, 07, 08, 09, 10, 11, 12

Waiver Days

  • Report from Day Event > Duration (if value is 0, reports 0)
  • If value in Event > Duration is NULL then report from Instructional Minutes

Non-Waiver Days

  • Report value from Instructional Minutes

*A Waiver Day is any day containing a Day Event code that contains data in the Value field.


Submission:

3


Numeric, 3 digits

System Administration > Calendar > Calendar > Days > Day Events > Ins. Minutes

OR

System Administration > Calendar > Periods > Period Schedule/Periods Editor > Period Schedule Info > Instructional Minutes (calculated field)


TX-SchoolDayWaiverMinutes

Required


The value entered in the Instructional Minutes field.

If the date contains a state reportable waiver code, then the value from the Inst. Minutes field reports. Otherwise, 0 reports.


Submission:
3
CF

Numeric, 3 digits
System Administration > Calendar > Calendar > Days > Day Events > Inst. Minutes

Database:
DayEvent.instructionalMinutes

ReportingPeriodExtension

This extension represents a time period for which student attendance data is reported. One complex is reported for each of the six reporting periods for each instructional track. For example, if a school has 4 instructional tracks and 6 attendance periods, then 24 complexes report.

This complex type will only reference CalendarDateReference > ref fields that tie to the school AND calendar being reported.

ReportingPeriodExtension Example

XML Element
Description
Location

TX-SchoolReference >
EducationalOrgIdentity > StateOrganizationID

Required


The unique identification number registered with the Texas Education Agency.

Submission:
3
CF

Numeric, 9 digits
System Administration > Resources > School > School Detail > State School Number AND State District Number-Core

Database:

District.number

AND

School.number

TX-SchoolYear

Required


The school year for which the attendance data is being reported.

Submission:
3
CF

Date Field, 9 characters

YYYY-YYYY

System Administration > Calendar > Calendar > Start Date; End Date

Database:

Calendar.startDate

Calendar.endDate

TX-ReportingPeriod

Required


The period for which the attendance data is being reported.

Submission:
3
CF

Numeric, 1 digit
System Administration > Calendar > Calendar > Attendance Periods > Seq

Database:
SchoolMonth.seq

BeginDate

Required


The Start Date of the Attendance Period.

Submission:
3
CF

Date Field, 10 characters

YYYY-MM-DD

System Administration > Calendar > Calendar > Attendance Periods > Start Date

Database:
SchoolMonth.startDate

EndDate

Required


The End Date of the Attendance Period.

Submission:
3
CF

Date Field, 10 characters

YYYY-MM-DD

System Administration > Calendar > Calendar > Attendance Periods > End Date

Database:
SchoolMonth.endDate

TX-InstructionalTrack

Required


An identifying number for the number of Calendars in a particular school. If there is only one Calendar for a school, 0 reports. If there is more than one Calendar for a school, 0 reports for the first school listed and 1 reports for the second school listed in the Calendar.

Submission:
3
CF

Numeric, 2 digits

zero pad from the left if necessary

System Administration > Calendar > Calendar
TX-InstructionalProgramType

Required


Reports the Instructional Program Type for the reporting calendar.

Submission:
3
CF

Numeric, 2 digits
Student Administration > Calendar > Calendar > Instructional Program Type

TX-NumberDaysTaught

Required


The number of instructional days in the Attendance Period.

Submission:
3
CF

Numeric, 3 digits

System Administration > Calendar > Calendar > Attendance Periods > Begin Date AND End Date

AND

System Administration > Calendar > Calendar > Days > Instructional


CalendarDateReference

Required


An identifier that links the Calendar Date Reference to the original Calendar Date.

Submission:
3
CF

Database:
Day.date

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