Skip to main content
Skip table of contents

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:

Sessions

This view captures basic information about current year terms as published within the Organization Calendar dashboard category.

sessions

This resource represents the terms defined at the school.

Primary PowerSchool Source Data

  • [Terms]

Selection Criteria

Records are published if the following criteria are met:

  • The school must not be excluded from state reporting (Note: the school is included by default).

  • The terms for the school must fall within the current reporting year.

Resource Output

  • A separate term record is published for each term identified within the current reporting year for each applicable school in the district. 

  • LEAs and Schools may upload (publish) data to the 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

sessions

    /schoolRef

The school associated with this period. This is an eight-digit number comprising of: 

35+[LEA Number - 3 digit]+[School Number - 3 digit]

Integer

LEA Number - [Prefs]Value [Prefs]Name where = districtnumber

School Number - [Schools]Alternate_School_Number if the value greater is than zero else the [Schools]School_Number

R

    /schoolYearTypeRef

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

String

Based on the selected year. Format - YYYY

R

 /termDescriptor

The descriptor value that describes the term.

Term Descriptor Set

String

[Terms]Portion

R

 /sessionName

The identifier for the calendar for the academic session

String

This is a combined value of the following:

  • Profile ID

  • Term Abbreviation

  • Term DCID

  • School ID

  • Year ID

R

/beginDate

The start date of the term.

Date

[Terms]FirstDay

R

/endDate

The end date of the term.

Date

[Terms]LastDay

R

/totalinstructionDays

The sum of the calendar days where the membershi[value is greater than 0 and the date is between the term start and end date.

Int

[Terms]FirstDay

[Terms]LastDay

[Calendar_Day]MembershipValue

/gradingPeriodDescriptor

The name of the period for which grades are reported.

Grading Period Descriptor Set

Note: This element requires the Grading Period Descriptor mapping be completed on the Code Set Mappings page.

String

[TermBins]StoreCode

Req'd

/periodSequence

The sequential order of this period relative to other periods.

Int

[Terms]Portion

Req'd

/schoolID

The identifier assigned to a school.

Int

[StoredGrade]SchoolID

Req'd

/SchoolYear

The school year in which the grade was earned.

Derived from the report year.

Calendar

This view captures basic information about current year calendars as published in the Calendar resource within the Organization Calendar dashboard category.

calendar

This resource represents a school calendars.

Primary PowerSchool Source Data

  • [Schools]

  • [Calendar_Day]

Selection Criteria

Records are published if the following criteria are met:

  • The school must not be excluded from state reporting (Note: the school is included by default).

  • The calendar for the school must fall within the current reporting year.

Resource Output

  • A separate Calendar record is published for each school in the district. 

  • LEAs and Schools may upload (publish) data to the 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

calendar

    /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

R

    /schoolRef

The school associated with this period. This is an eight-digit number comprising of: 

35+[LEA Number - 3 digit]+[School Number - 3 digit]

Integer

LEA Number - [Prefs]Value [Prefs]Name where = districtnumber

School Number - [Schools]Alternate_School_Number if the value greater is than zero else the [Schools]School_Number

R

    /schoolYear

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

String

Based on the selected year. Format - YYYY

R

 /calendarTypeDescriptor

The type of calendar being published. 

String

Always published as - uri://ed-fi.org/CalendarTypeDescriptor#Student Specific

R

 /instructionalDays

The number of instructional/in session days.

Integer

Sum of calendar days where membershipValue is greater than zero.

O

Calendar Dates

calendarDates

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

Primary PowerSchool Source Data

  • [Schools]

  • [Calendar_Day]

Selection Criteria

Records are published if the following criteria are met:

  • The school must not be marked as Excluded from State Reporting.

Publishing Logic:

  • calendarDate records will publish in-session days with the Calendar Event Descriptor value of "Instructional day" if the In-Session checkbox is checked in the school calendar (populating the Type field for in-session days is no longer required).

  • calendarDate records will now publish for non in-session days according to the following:

    • Non in-session days with a defined Type value (in the school calendar) will publish with the selected mapping value in the Calendar Event Descriptor Mapping field on the district-level New/Edit Calendar Membership Type page.

    • Non in-session days with a Type that is not mapped, in the Calendar Event Descriptor Mapping field, will publish with a Calendar Event Descriptor value of "Other".

    • Weekends and non in-session days that do not have a Type defined will publish with a Calendar Event Descriptor value of "Other".

Data Element

Description

Data Type

Stored in [Table]Field

Req'd

calendarDates

/calendarEventDescriptor

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

String

Instructional days:

[Calendar_Day]InSession

Non-Instructional days:

[Calendar_Day]Type

[Gen]Cat = dailymembtypes

Weekends:

Always “Other”

R

        /date

The calendar date being published.

String

[Calendar_Day]Date

R

calendarRef

       /calendarCode

The calendarCode this date is being published under.

Refer to calendarCode logic above.

String

[Schools]School_Number

R

       /schoolRef

The school associated with this period. This is an eight-digit number comprising of: 

35+[LEA Number - 3 digit]+[School Number - 3 digit]

Integer

LEA Number - [Prefs]Value [Prefs]Name where = districtnumber

School Number - [Schools]Alternate_School_Number if the value greater is than zero else the [Schools]School_Number

R

       /schoolYear

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

String

Based on the selected year. Format - YYYY

R

GradingPeriods

This view captures basic information about current year grading periods as published in the gradingPeriods resource within the Organization Calendar dashboard category.

calendar

This resource represents a school calendars.

Primary PowerSchool Source Data

  • [TermBins]

  • [Terms]

Selection Criteria

Records are published if the following criteria are met:

  • The school must not be excluded from state reporting (Note: the school is included by default).

  • The Terms and TermBin records for the school must fall within the current reporting year.

Resource Output

  • A separate gradingPeriod record is published for each Final Grade Term in the school. 

  • LEAs and Schools may upload (publish) data to the 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

calendar

    /gradingPeriodDescriptor

The name of the period for which grades are reported.

Grading Period Descriptor Set

Note: This element requires the Grading Period Descriptor mapping be completed on the Code Set Mappings page.

String

[TermBins]StoreCode

R

    /periodSequence

The sequential order of this period relative to other periods.

Integer

[Terms]Portion

R

/schoolReference

/schoolID

The school associated with this period. This is an eight-digit number comprising of: 

35+[LEA Number - 3 digit]+[School Number - 3 digit]

Integer

LEA Number - [Prefs]Value [Prefs]Name where = districtnumber

School Number - [Schools]Alternate_School_Number if the value greater is than zero else the [Schools]School_Number

R

/schoolYearTypeReference

/schoolYear

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

Based on the selected year. Format - YYYY

 /beginDate

Month, day, and year of the first day of the GradingPeriod.

Date

[TermBins]Date1

R

 /endDate

Month, day, and year of the last day of the GradingPeriod.

Date

[TermBins]Date2

R

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.