School Calendar Template

PIMS School Calendar Template Specifications

(21 Fields • 19 Collected • Delimited)
Target Table:
PIMS_SCHOOL_CALENDAR
Load Sequence / Dependencies:
None

This domain applies to the following organizational types only:

  • School Districts
  • Intermediate Units
  • Career and Technical Centers
  • Charter Schools
  • Private Residential Rehabilitation Institutions (PRRI)
  • Approved Private Schools (APS)

Template Description

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 PDE approved Act 80 days, and the same total instructional time.

The information collected will be used to calculate the total days in session and total instructional time for each calendar as follows:

  • Days in Session = Number of Scheduled School Days minus Total Days in Session Lost Due to Strike minus Total Days in Session Lost Due to Act 80 minus Total Days in Session Lost Due to Other Reasons plus Total Make-Up Days.
  • Total Instructional Time = Days in Session times Instructional Minutes in Standard Day minus Total Instructional Minutes Lost Due to Planned Shortened Days and PDE Emergency Waiver.

See sections 1501 and 1504 of the Pennsylvania School Code (24 P.S. § 15-1501 and 1504) for required instructional days and hours. The required number of instructional days is 180 (or 180 minus full Act 80 days) and the required instructional hours for each grade are as follows: 450 hours for half-time kindergarten; 900 hours for full-time kindergarten and grades 1-6; and 990 hours for grades 7-12. School districts, intermediate units, and CTCs/AVTS may apply for Act 80 exceptions.

The Days in Session is used to calculate average daily membership (ADM) for students associated with each calendar. It is important to verify the ADM by Calendar Program Code on the Accuracy Certification Statement (ACS).

The Days in Session calculated with School Calendar data must agree with the actual number of student days used by your student information system to generate attendance and membership. The Days in Session or actual number of student days may or may not be the same for all buildings or grade levels.

Additional Information

Field 3 - CALENDAR ID & Field 4 - CALENDAR DESCRIPTION

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.

Field 7 - ROTATION PATTERN CODE

This field is populated for half-day or alternate-day pre-kindergarten and kindergarten School Calendars. It also is populated for School Calendars created for students in part-time CTC/AVTS vocational programs (half-day and semester-about).

Field 8 - CALENDAR PROGRAMS CODE – Refer to Appendix R

This field is required in the School Calendar created for students in certain situations (see full field spec below).

Field 11 - INSTRUCTION START DATE & Field 12 - INSTRUCTION END DATE

Provide semester boundaries for part‑time semester-about rotation CTC/AVTS calendars; if a program was added or cancelled mid-year, still use dates representing the full operational year for the majority.


Template Specifications

1 - SUBMITTING AUN

RequiredKeyMax Length: 9

The unique, 9-digit Administrative Unit Number (AUN) assigned by the PDE.

Sample Value

All LEA and School Numbers can be found on the EdNA website

123456789

eScholar Name: DISTRICT CODE OF INSTRUCTION


2 - SCHOOL YEAR DATE

RequiredKeyMax Length: 10

A single date (June 30), the last day of the current school year indicating the whole school year.

Sample Value

2024-06-30


3 - CALENDAR ID

RequiredKeyMax Length: 12

A unique numeric and/or alphabetical unit used to identify this calendar.

Business Rules

To the extent possible, create a CALENDAR ID that is descriptive of the unique calendar.
Valid Values

Examples:

  • ABCElemKHT
  • WPMS6-7-8
  • CTCAM

4 - CALENDAR DESCRIPTION

RequiredUpdateableMax Length: 100

Free-form text description of the calendar; its purpose is to target student population.

Business Rules

A detailed description for the student or group of students for this calendar. IU may include school district name to designate location of IU classroom.
Valid Values

Examples:

  • ABC_Elementary_KHT
  • William-Penn-Middle School
  • CTC_all-AM-Sessions

5-6 🛇

Field(s) not collected. Must be delimited in template file.


7 - ROTATION PATTERN CODE

Conditionally RequiredUpdateableMax Length: 1

For part-time CTC/AVTS programs enter code for half-day, one-week, two-week, three-week, nine-week, semester rotation, or other. For part-time pre-kindergarten or kindergarten enter code for half-day or alternate day.

Notes

Required only for part-time CTC/AVTS programs, and for part-time pre-kindergarten and kindergarten programs. If H, Field 15 must be between 30 and 270. Checked by the DQE.
Valid Values

For CTC/AVTS programs:

  • H – half day
  • 1 – one-week
  • 2 – two-week
  • 3 – three-week
  • 9 – nine-week
  • S – semester
  • O – other

For part-time Pre-K or kindergarten programs:

  • H – half day
  • A – alternate day

8 - CALENDAR PROGRAMS CODE

Conditionally RequiredUpdateable Max Length: 8

Provides additional context for calendars created by LEAs for students in certain special situations.

Notes

Required for CTC, PRRI, APS. Conditionally required for other LEA types. Checked by the DQE.

Valid Values

See Appendix R for complete list of valid values.


9 - CALENDAR START DATE

RequiredUpdateableMax Length: 10

The date of the first day on the original calendar; this date could be a PDE approved full-day Act 80 day prior to the first day of instruction.

Business Rules

Within 2023-06-25 to 2024-01-31.

Sample Value

2023-08-22


10 - CALENDAR END DATE

RequiredUpdateableMax Length: 10

The date of the last day on the original calendar; this date could be a PDE approved full-day Act 80 day after the last day of instruction.

Business Rules

Within 2024-01-01 to 2024-07-31.

Sample Value

2024-06-18


11 - INSTRUCTION START DATE

RequiredUpdateableMax Length: 10

The date of the first day of instruction.

Business Rules

Falls on or after Field 9.

Sample Value

2023-08-28


12 - INSTRUCTION END DATE

RequiredUpdateableMax Length: 10

The date of the last day of instruction.

Business Rules

Falls on or before Field 10.

Sample Value

2024-06-12


13 - GRADUATION CEREMONY DATE

Conditionally RequiredUpdateable Max Length: 10

The date of the seniors' graduation ceremony.

Notes

Required for calendars that include grade 12 students. Falls on or after Field 12. Checked by the DQE.

Sample Value

2024-06-14


14 - NUMBER OF SCHEDULED SCHOOL DAYS

RequiredUpdateableMax Length: 3

Number of instructional days on the original calendar (planned days plus PDE-approved Act 80 full days).

Business Rules

Range 85–260. Whole numbers only.

Sample Value

185


15 - INSTRUCTIONAL MINUTES IN STANDARD DAY

RequiredUpdateableMax Length: 3

Number of instructional minutes in a regular school day.

Business Rules

Greater than 0; range 30–435. Whole numbers only.

Sample Value

320


16 - TOTAL DAYS IN SESSION LOST DUE TO STRIKE

RequiredUpdateableMax Length: 3

Instructional days lost due to a work stoppage.

Business Rules

Whole numbers. See rules 1–3.

Sample Value

0


17 - TOTAL DAYS IN SESSION LOST DUE TO ACT 80

RequiredUpdateableMax Length: 3

Instructional days lost due to PDE approved full-day Act 80 dismissals actually used.

Notes

For SD / CTC / IU only. Required if Field 21 populated else 0. Whole numbers. Checked by DQE. See rules 1–3.

Sample Value

4


18 - TOTAL DAYS IN SESSION LOST DUE TO OTHER REASONS

RequiredUpdateableMax Length: 3

Instructional days lost due to weather or other causes (exclude waived emergency closings).

Business Rules

Whole numbers. See rules 1–3.

Sample Value

1


19 - TOTAL MAKE-UP DAYS

RequiredUpdateableMax Length: 3

Instructional days made up within or beyond the original calendar. Not included in Field 14.

Business Rules

Whole numbers. See rule 1.

Sample Value

0


20 - TOTAL INSTRUCTIONAL MINUTES LOST TO PLANNED SHORTENED DAYS AND PDE EMERGENCY WAIVER

RequiredUpdateableMax Length: 4

Actual instructional minutes lost (planned early dismissals/late starts, or PDE waived emergency day minutes). Exclude inclement weather shortened days.

Business Rules

Range 0–9000. Whole numbers. Create a separate calendar if required hours (900 KFT–6 / 990 7–12) not met. See rule 1.

Sample / Valid Value:

179


21 - ACT 80 GROUP

Conditionally RequiredUpdateableMax Length: 12

Alphanumeric label used in Act 80 application linking calendar to approval.

Notes

For SD / CTC / IU only. Required if Field 17 > 0. Checked by DQE.

Sample / Valid Value:

Elementary

Rules

  1. Fields 16–20 must be >= 0.
  2. Sum of Fields 16 + 17 + 18 <= Field 14 and >= Field 19.
  3. TOT_DAYS_IN_SESSION = Field 14 + Field 19 – (Field 16 + Field 17 + Field 18).

See the Rules Section of the Template Domain for rules consistent throughout all templates.