Education Organization Calendar Verification Report
The Education Organization Calendar Verification report extracts calendar, minutes, and waivers data for verification. Use this report to verify Education Organization Calendar Interchange data.
Selection Criteria
This report has no specified selection criteria.
Report Input
Each of the available run options and data fields for the report are described below. For help with report navigation and generation, see Generate Reports.
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 code.
|
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 to run the report immediately. |
Schedule | Select this option to run this report on a scheduled basis. Once this option is selected the following choices are:
|
Report Output
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.
Data Element/Column Header | Description | [Table]Field |
State Org ID | The state number for this organization. | [Schools]Alternate_School_Number [Schools]School_Number |
Instructional Track | The instructional track reported. | [S_TX_CLD_C]Track |
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 |
Report Period | The number of the reporting period. | [Terms]ID |
School Number | The school number and school name reported in this section. | [Schools]Alternate_School_Number [Schools]School_Number [Schools]Name |
Report Period Start Date | The begin date for the reporting period for the school and track. | Derived |
Report Period End Date | The end date for the reporting period for the school and track. | Derived |
Date | The date of the reported attendance. | [Calendar_Day]Date |
Event Code | The code identifying the school day event. | [Calendar_Day]Type |
Waiver Event | The code identifying the waiver event. | Default Track [S_TX_CLD_X]Waiver_Event_Type_Code Additional Tracks [S_TX_CLD_C]Waiver_Event_Type_Code |
Oper Min | The total number of operational minutes for the school on this date.
| 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 |
Instr Min | The total number of instructional minutes for the school on this date.
| 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 |
Waiver Min | The total number of waiver minutes for this date. | Default Track [S_TX_CLD_X]Waiver_Minutes Additional Tracks [S_TX_CLD_C]Waiver_Minutes |
Total Minutes | The sum of operational minutes (Oper Min), instructional minutes (Instr Min), and waiver minutes (Waiver Min). | Calculated |
In Session | Indicates if school was in session on this day. Valid values:
| [Calendar_Day]InSession |
Totals for Report Period: [Number] | The report calculates subtotals per report period for the following columns:
| Calculated |
Totals for Each Report Period | The report lists the subtotals for School Min, Waiver Min, and In Session from each report period. | Calculated |
Totals for All Report Periods | The report calculates totals for School Min, Waiver Min, and In Session for all report periods. | Calculated |