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 (Terms)

This view captures the sessions/terms defined at each school within the district as published in the Session resource within the Education Organization Calendar category. Ed-Fi sessions are the equivalent of PowerSchool terms. The layout provides the School Name, Year, Name of Term, First Day of Term, and Last Day of Term.

sessions

This resource represents the prescribed span of time when an education institution is open, instruction is provided, and students are under the direction and guidance of teachers and/or education institution administration. A session may be interrupted by one or more vacations.

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.
  • The term or term portion exists within the year for the Term selected in the PowerSchool UI.

Resource Output

  • A separate Session record is published for each unique term record at each school based on [Terms]Portion and [Terms]Abbreviation.
  • The GradingPeriodReference complex type includes a reference to each unique grading period associated with the session (refer to the GradingPeriod resource for additional information).
  • The Session resource is dependent on the prior publishing of the following resources: GradingPeriod and CalendarDate.
  • 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

schoolID

Relates the session to the school.

Integer

Derived from:
[Terms]SchoolID

R

schoolYearType

SchoolYearType - The identifier for the school year.

Type

[Terms]YearID
Note: This is the four-digit year for the Spring semester

R

termDescriptor

The term for the session during the school year.

Descriptor

Derived from:
[Terms]Portion
[Terms]Abbreviation

R

name

The identifier for the calendar for the academic session, for example, 2010/11, 2011 Summer.

String

[Terms]Name

R

beginDate

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

Date

[Terms]FirstDay

R

endDate

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

Date

[Terms]LastDay

R

totalInstructionalDays

The total number of instructional days in the school calendar.

Integer

[Calendar_Day]Date_Value where InSession = 1 and Date_Value between FirstDay and LastDay of Term record for school.

R

GradingPeriodReference/GradingPeriodIdentity (1-many)
The grading periods associated with the calendar.

O

/educationOrganizationId

The school for which the grading period is defined.

Integer

Derived from:
[Terms]SchoolID

 

/descriptor

GradingPeriodDescriptor - The name of the period for which grades are reported.

Descriptor

[Terms]Portion
[Terms]Abbreviation
Map to GradingPeriodType value in GradingPeriod Descriptor

 

/beginDate

Month, day, and year of the first day of the grading period.

Date

[Terms]FirstDay

 

Back to top

Grading Periods

This view captures the grading periods defined at each school within the district as published in the GradingPeriod resource within the Education Organization Calendar category. The layout provides the School Name, Name of Term, First Day of Term, and Last Day of Term.

gradingPeriods

This resource represents the time span for which grades are reported.

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.
  • The term or term portion associated with the grading period exists within the year for the Term selected in the PowerSchool UI.

Resource Output

  • A separate GradingPeriod record is published for each unique term record at each school based on [Terms]Portion and [Terms]Abbreviation.
    • This allows any term to be used as a grading period.
    • Each Session record incudes GradingPeriod references to all grading periods that could be applied to that session.
    • For example, if a school had both semesters and quarters:
      • Each semester session would include a reference to the corresponding semester grading period and a reference to the two corresponding quarter grading periods (3 grading period references).
      • Each quarter session would have only one reference to its corresponding quarter grading period.
  • The GradingPeriod resource is dependent on the prior publishing of the following resources: CalendarDate.
  • 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

educationOrganizationId

The Education Organization for which the grading period is defined - usually the LEA or school.

Integer

Derived from:
[Terms]SchoolID

R

descriptor

GradingPeriodDescriptor - The name of the period for which grades are reported.

Descriptor

Derived from:
[Terms]Portion
[Terms]Abbreviation

R

beginDate

Month, day, and year of the first day of the grading period.

Date

[Terms]FirstDay

R

endDate

Month, day, and year of the last day of the grading period.

Date

[Terms]LastDay

R

totalInstructionalDays

Total days available for educational instruction during the grading period.

Integer

[Calendar_Day]Date_Value where InSession = 1 and Date_Value between FirstDay and LastDay of Term record for school

R

periodSequence

The sequential order of this period relative to other periods.

Integer

If [Terms]Portion = 1 then '1'
Otherwise derived from
[Terms]Abbreviation

O

Back to top

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]

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

schoolId

The school for which the section is defined.

Integer

Derived from:
[Calendar_Day]SchoolId

R

date

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

Date

[Calendar_Day]Date_Value
[DistrictCalendarDay]Date_Value

R

calendarEvents (1-many)

O

/calendarEventDescriptor

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

Descriptor

[Calendar_Day]Type
If null, [Calendar_Day]InSession
Map to Ed-Fi descriptor

 

/eventDuration

The amount of time for the event as recognized by the school: 1 day = 1, 1/2 day = 0.5, 1/3 day = 0.33. Default to 1.

Number

Default = '1'

 

Back to top

JavaScript errors detected

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

If this problem persists, please contact our support.