TX Interchange Education Organization Calendar
Contents
Introduction
This interchange includes information for the district and any school that is not excluded from state reporting.
Report Input
Each of the available run options and data fields for the report are described below.
Field | Description |
|---|---|
Select Schools | If run at the district level, choose one of the following:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Collection Code | Choose the Collection from the pop-up menu for the report generated. This option controls the naming of the file. SUMR1 is for Submission 3, SUMR2 is for Re-Submission, SUMR3 is for the Working Collection and TSDS is for the Dashboard. |
School Year | Choose the school year. This value is used in the file name as well as determining which year to use for the data extraction. |
Run Now | Select this option if the user wants to run the report immediately. |
Schedule | Select this option if the user wants to run this report on a scheduled basis. Once this option is selected the following choices are:
|
Report Output: XML for PEIMS
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Filename for PEIMS:
The filename must be in the following format:
- District Code: Position 1-6
- Underscore: Position 7, 11, 21 and 34.
- Campus ID: Position 8-10 – If the file is generated by a user from the District Office, this value is 000. If the file is generated by a user from a school, this value is the three-digit campus id for that user. This allows partial files to be submitted that contain data only for one school.
- Collection Code: Position 12-20. This starts with the ending year of the school year followed by the five characters Collection Code (i.e. FALL1).
- Timestamp: Position 22-33 – This is YYYYMMDDHHMM where YYYY is year, MM is month, DD is day, HH is hour, and MM is minute.
- Interchange: Position 35 starts the name of the Interchange – InterchangeEducationOrgCalendar.xml
Data Element | Description | [Table]FieldName | Collection |
|---|---|---|---|
Calendar Date – This complex type is repeated for each Calendar Date Reference defined in each Grading Period complex types. | |||
Date | The calendar date for each in-session date and/or date with Waiver Event Type. | [Calendar_Day]Date | SUMMER |
TX-School Day Code | This is a calculated value depending on the Waiver Event Type. A student instructional day (whole or part) is 01, otherwise it is 02. | [Calendar_Day]Type | SUMMER |
TX-Calendar Waiver Event Type | The type of waiver event. | Default Track [S_TX_CLD_X]Waiver_Event_Type_Code Additional Tracks [S_TX_CLD_C]Waiver_Event_Type_Code | SUMMER |
TX-School Day Operational Minutes | The number of operational minutes for this date for this track.
| The value is extracted from the first non-blank source in the hierarchy: Default Track Calendar Override [S_TX_CLD_X]School_Day_Minutes Bell Schedule [S_TX_BSD_X]Default_Day_Minutes School Default [S_TX_SCH_SCHOOLS_X]Default_Day_Minutes Additional Tracks [S_TX_CLD_C]School_Day_Minutes Bell Schedule [S_TX_BSD_TRACK_C]Default_Day_Minutes School Default [S_TX_SCH_SCHOOLS_C]Default_Day_Minutes | SUMMER |
| TX-School Day Instructional Minutes | The number of instructional minutes for this date for this track.
| The value is extracted from the first non-blank source in the hierarchy: Default Track Calendar Override [S_TX_CLD_X]School_Day_Minutes Bell Schedule [S_TX_BSD_X]Default_Day_Minutes School Default [S_TX_SCH_SCHOOLS_X]Default_Day_Minutes Additional Tracks [S_TX_CLD_C]School_Day_Minutes Bell Schedule [S_TX_BSD_TRACK_C]Default_Day_Minutes School Default [S_TX_SCH_SCHOOLS_C]Default_Day_Minutes | |
TX-School Day Waiver Minutes | The number of waiver minutes if a waiver was received by the state. | Default Track [S_TX_CLD_X]Waiver_Minutes Additional Tracks [S_TX_CLD_C]Waiver_Minutes | SUMMER |
Reporting Period Extension – This complex type is repeated for each school, reporting period, and track. | |||
TX-School Reference | |||
| Educational Org Identity | ||
State Organization ID | The school associated to this reporting period. | [Schools]Alternate_School_Number [Schools]School_Number | SUMMER |
TX-School Year | The school year being reported. | [Terms]YearID | SUMMER |
TX-Reporting Period | The reporting period for this complex type (1-6). | [Terms]ID | SUMMER |
BeginDate | The begin date for that reporting period for that school and track. | Derived | SUMMER |
EndDate | The end date for that reporting period for that school and track. | Derived | SUMMER |
TX-Instructional Track | The track associated with this reporting period (0-9). | [S_TX_CLD_C]Track | SUMMER |
| TX-Instructional Program Type | The type of attendance program associated with this calendar. | Default Track [S_TX_SCH_SCHOOLS_X]Instructional_Program_Type Additional Tracks [S_TX_SCH_SCHOOLS_C]Instructional_Program_Type | |
TX-Number Days Taught | The number of days taught during this reporting period for school and track. | Derived | SUMMER |
| Calendar Date Reference | ||
| ref | This element is repeated for each calendar date within the reporting period. The ref is CLMD_xxx where xxx is the School ID, Date in yyyymmdd format, and Track. | [Schools]Alternate_School_Number [Schools]School_Number [Calendar_Day]Date [S_TX_CLD_C]Track | SUMMER |