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: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district. 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. SUMR1 SUMR2 SUMR3 EXYR1 EXYR2 EXYR3
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: Run Once Start Date and Start Time to run the report. Repeat Select Daily, Weekly, Monthly or Yearly for the appropriate re-occurrence for running the report. If Daily is selected, check the Weekdays only box to limit to weekdays. If Weekly is selected, check which weekday to run the report. If Monthly is selected, check the month to run the report. If Yearly is selected, select either the date or the weekday to run the report. Date Range – Select No End Date or a date that the re-occurrence should end.

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. If Instructional Program Type = 01 or 02, minutes are reported as School Day Operational Minutes and the School Day Instructional Minutes element is suppressed. If Instructional Program Type = 04 - 12, minutes are reported as School Day Instructional Minutes and the School Day Operational Minutes element is suppressed. If Instructional Program Type = 03 or 13, both the School Day Operational Minutes and School Day Instructional Minutes elements are suppressed.	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. If Instructional Program Type = 01 or 02, minutes are reported as Operational Minutes and the Instructional Minutes element is suppressed. If Instructional Program Type = 04 - 12, minutes are reported as Instructional Minutes and the Operational Minutes element is suppressed. If Instructional Program Type = 03 or 13, both the Operational Minutes and Instructional Minutes elements are suppressed.	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: 1 - Yes 0 - No	[Calendar_Day]InSession
Totals for Report Period: [Number]	The report calculates subtotals per report period for the following columns: Oper Min Instr Min Waiver Min Total Min In Session	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