School Calendar Template - RE
Contents
Introduction
This template is used to identify each unique calendar associated with a student or group of students. One School Calendar can be submitted for multiple schools with the same days in session, the same number of approved Act 80 days, and the same total instructional time. Written in the Reporting Engine (RE) Platform.
The Calendar ID provides a unique identifier for each different calendar that will be linked to each student on the Student Calendar Fact Template.
Therefore, it is important to create a Calendar ID that is easily identifiable. The Calendar Description field may be used to provide a more detailed
description.
Selection Criteria
- The report selects data District wide and not from an individual school/sub-district level.
- School in the District must not be excluded from state reporting
- Pennsylvania School Calendar Records must be created in District Setup > School Calendar Information
Report Input
For help with report generation and navigation, see How to Find and Generate a Report.
Field | Description |
Use | If run at the district level, choose one of the following from the pop-up menu:
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. |
Processing Options | Choose a time to run the report from the pop-up menu:
|
Specific Date/Time | Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2022 @ 10 AM: 05. |
School Year | Select the school year for which data is to be extracted |
Field Delimiter | Select the field delimiter for the extract file. File is to be provided to the state in delimited format. |
Show Column Field Headings | Choose Yes or No to indicate whether to include column headings in the extract file. Including column headers provides a heading for each type of data extracted in the report. |
| Select Sub District | Note: This field is visible only if your district uses sub district functionality To report on the current district only, leave the selection as "Default District"; otherwise, select a sub district from the pop-up menu. |
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName | Field Type | Field Length |
|---|---|---|---|---|---|
1 | District Code of Instruction | The unique 9-digit Administrative Unit Number assigned by the PDE. | [Prefs]Value where [Prefs]Name=PA_districtAUN | Alpha-numeric | 9 |
2 | School Year Date | A single date indicating the whole school year; June 30 at the end of the standard school year is used to designate a school year. Thus, the 2021-2022 school year would be indicated by 2022-06-30. | [Terms]LastDay | Alpha-numeric | 10 |
3 | Calendar ID | A unique numeric and/or alphabetical unit used to identify this calendar. To the extent possible, create a Calendar ID that is descriptive of the unique calendar. Examples: ABCElemKHT WPMS6_7_8 CTCAM | [S_PA_Calendar_S]Calendar_Id | Alpha-numeric | 12 |
4 | Calendar Description | Free-form text description of the calendar; its purpose and target student population. A detailed description for the student or group of students for this calendar | [S_PA_Calendar_S]Calendar_Description | Alpha-numeric | 30 |
5 | Not Collected | This field is not currently used. | N/A | N/A | N/A |
6 | Not Collected | This field is not currently used. | N/A | N/A | N/A |
7 | Rotation Pattern Code | For part-time CTC/AVTS programs, enter half-day, one-week, two-week, three-week, nine-week, semester rotation, or other. For part-time pre-kindergarten or kindergarten, enter half-day or alternate day. | [S_PA_Calendar_S]Rotation_Pattern_Code | Alpha-numeric | 1 |
8 | Calendar Programs Code | Provides additional context for calendars created by LEAs for students in certain special situations. | [S_PA_Calendar_S]Calendar_Program_Code | Alpha-numeric | 8 |
9 | Calendar Start Date | The date of the first day on the original calendar; this date could be an approved full-day Act 80 day prior to the first day of instruction. | [S_PA_Calendar_S]Calendar_Start_Date | Numeric | 10 |
10 | Calendar End Date | The date of the last day on the original calendar; this date could be an approved full-day Act 80 day after the last day of instruction. | [S_PA_Calendar_S]Calendar_End_Date | Numeric | 10 |
11 | Instruction Start Date | The date of the first day of instruction. | [S_PA_Calendar_S]Instruction_Start_Date | Numeric | 10 |
12 | Instruction End Date | The date of the last day of instruction. Note: If the final day of instruction falls after the Calendar End Date, the template reports the Calendar End Date in this field. | [S_PA_Calendar_S]Instruction_End_Date [S_PA_Calendar_S]Caldendar_End_Date | Numeric | 10 |
13 | Graduation Ceremony Date | The date of the seniors' graduation ceremony. The Graduation Ceremony Date is on or after the Instruction End Date. | [S_PA_Calendar_S]Graduation_Ceremony_Date | Numeric | 10 |
14 | Number of Scheduled School Days | The number of instructional days on the original calendar – planned student instructional days plus PDE-approved Act 80 full days. | [S_PA_Calendar_S] Num_Of_Scheduled_School_Days | Numeric | 3 |
15 | Instructional Minutes in Standard Day | The number of instructional minutes in a regular school day | [S_PA_Calendar_S] Instruct_Min_In_Standard_Day | Numeric | 3 |
16 | Total days in session lost due to strike | The number of instructional days lost due to a work stoppage | [S_PA_Calendar_S]Days_In_Session_Lost_Strike | Numeric | 3 |
17 | Total days in session lost due to Act 80 | The number of instructional days lost due to PDE-approved full-day Act 80 dismissals Do not include any approved Act 80 full-day dismissals that were not used. | [S_PA_Calendar_S]Days_In_Session_Lost_Act80 | Numeric | 3 |
18 | Total days in session lost due to other reasons | The number of instructional days lost due to other reasons such as snow, flood, or adverse weather conditions If the School Services Office granted a waiver for an emergency school closing, do not include this in the number of days lost. | [S_PA_Calendar_S]Days_In_Session_Lost_Other | Numeric | 3 |
19 | Total make-up days | The number of instructional days made up within or beyond the original calendar. These days should not be included in Number of Scheduled School Days (field 14). | [S_PA_Calendar_S]Total_Makeup_Days | Numeric | 3 |
20 | Lost Time Due to Planned Shortened Days and PDE Emergency Waiver | The number of actual instructional minutes lost due to early dismissals or late starts for Act 80 and other planned shortened days Do not include minutes lost due to early dismissals or late starts because of inclement weather | [S_PA_Calendar_S]Total_Instruct_Minutes_Lost | Numeric | 4 |
21 | PIMS Act 80 Group | [S_PA_Calendar_S]act80_group |