Organization Calendars

This category represents information about sessions, grading periods, and calendars as published within the Organization Calendars category. The Organization Calendars category includes the following data views and resources:

Calendar Dates

This view captures basic information about current year calendar dates as published in the CalendarDate resource within the Education Organization Calendar category. The layout includes the School Name, Date, and Type of day.

calendarDates

This resource represents a day in the school or district calendar.

Primary PowerSchool Source Data

[Calendar_Day]
[S_SCH_CALENDAR_C]

Selection Criteria

Records are published if the following criteria are met:

The school must not be excluded from state reporting (Note: the district is included by default).
The calendar date for the district or the school falls within the year for the Term selected in the PowerSchool UI.

Resource Output

A separate CalendarDate record is published for each day for the district, and for each school within the year for the Term selected in the PowerSchool UI.
CalendarDate records include both instructional and non-instructional days.
As multiple events may occur on the same date, a separate CalendarEvent is published for each unique combination of Duration and Event Descriptor within the CalendarEvent complex type.
The CalendarDate resource is dependent on the prior publishing of Ed-Fi resources: Schools.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Data Element

Description

Data Type

Stored in [Table]Field

Req'd

date

The month, day, and year of the calendar date.

Date

[Calendar_Day]Date_Value

R

calendarReference

/calendarCode

A unique calendar code is required per calendar that is published. Each Kindergarten setup will have a unique calendar. All other calendars will be one per school.

[SCHOOLS]school_number - track letter appended if calendar describes a track.

/schoolId

The school for which the section is defined.

Integer

Derived from:
[Calendar_Day]SchoolId

R

/schoolYear

The school year associated with the calendar recorded as the later calendar year of the school year. For example, the 2019-2020 school year is recorded as 2020.

Based on the selected year.

calendarEvents

O

/calendarEventDescriptor

The type of scheduled or unscheduled event for the day, for example, Instructional day, Teacher only day, Holiday.

Code	Description
H	Holiday
O	Other
R	Regular
S	Staff Development
V	Vacation
W	Staff/Faculty Work Days
N	In-Session
M	Membership Day

Descriptor

[Calendar_Day]Type, [Calendar_Day]insession, [Calendar_Day]MEMBERSHIPVALUE
1. If [Calendar_Day]MEMBERSHIPVALUE morethan 0 then the CalendarEvent descriptor is of M
2. If [Calendar_Day]MEMBERSHIPVALUE=0 then CalendarEvent Descriptor is of Q
3. The [Calendar_Day]Type values must map one-to-one to SC Namespace CalendarEvent descriptors (for example, when [Calendar_Day]Type = H then the descriptor is H).
4. If [Calendar_Day]insession =1 then the the CalendarEvent Descriptor is N
5. If [Calendar_Day]insession = 0 then the the CalendarEvent Descriptor is T

/dayNote

[Calendar_Day]note

/inSession

[Calendar_Day]insession

/membershipValue

[Calendar_Day]membershipvalue

Calendar

calendars

This resource represents calendars for each school for which data is being published.

Primary PowerSchool Source Data

[Schools]
[S_SCH_CALENDARS_C]

Selection Criteria

Records are published if the following criteria are met:

The school cannot be marked as Excluded from State Reporting.
Grade Levels must be set up on the A File Setup page for each school.

Data Element	Description	[Table]Data Type	Stored in [Table]Field	Req’d
calendarCode	A unique calendar code is required per calendar that is published. Each Kindergarten setup will have a unique calendar. All other calendars will be one per school.	String	[SCHOOLS]school_number - track letter appended if calendar describes a track.	R
schoolReference
/schoolId	A reference to the related school.	String	[SCHOOLS]school_number	R
schoolYearTypeReference
/schoolYear	The school year associated with the calendar recorded as the later calendar year of the school year. For example, the 2019-2020 school year is recorded as 2020.	String	Determined by the term selected on the PowerSchool page.	R
calendarTypeDescriptor	Hardcoded value to School'.	String	Hardcoded to 'School'	R
gradeLevelDescriptor	List of grades that this calendar applies to. If a grade is a kindergarten grade level, then there will only be one value selected. Otherwise, all grade levels associated will be selected.	Date-time		O
instructionalDays	The total membership values of In Session days for a given calendar and/or track.	String		O
gradingPeriods				O
/ beginDate	The first day of the grading period.	date	[TERMS]firstday	O
/gradingPeriodDescriptor	The name of period form which grades are reported.	String	[TERMS]abbreviation	O
/endDate	grading period	date	[TERMS]lastday	O
/totalInstructionalDays	The total insession days between the first and the last day of the term.	Numeric	Calculated	O
/periodSequence	The order of the period relative to other periods.	String	If TERMS.abbreviation = 'S3' then '1' -- 'Summer Semester' If TERMS.portion = 1 then '1' If substr(TERMS.abbreviation, length(TERMS.abbreviation), 1) in ('1','2','3','4','5','6') then substr(TERMS.abbreviation, length(TERMS.abbreviation), 1) ELSE '1' -- default	O
/gradingPeriodName	The name of the grading period. A combination of the district code and term abbreviation. Format: districtCode - [TERMS]abbreviation. For example, 9998-S3	String	Composite based on districtCode and TERMS.abbreviation	R