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.
Report Editor
The following tables define the options available on the editor.
| Field | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| 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 |
| ||||||||
| Report Type | XML | ||||||||
| Filter By | This field allows you to narrow the report results to specific Calendars, Calendar Years (District), or Schools.
| ||||||||
| Population | This 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 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. |
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)).
Calendar Date Extension 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.
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
Non-Waiver Days
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
Non-Waiver Days
*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.
Reporting Period Extension Example
| XML Element | Description | Location |
|---|---|---|
TX-SchoolReference > 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 |
