Skip to main content
Skip table of contents

Organization Calendars

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

Calendar

calendar

One calendar per reporting school.

Primary PowerSchool Source Data

[S_VT_SCH_X]

Selection Criteria

Records are published if the following criteria are met:

  • A calendar type must be selected.

  • The school must not be excluded from state reporting.

  • The Exclude School from Instructional Calendar checkbox is not selected.

Resource Output

Data Element

Description

Data Type

Stored in [Table]Field

Req’d

schoolReference

A reference to the related school resource.

R

/schoolID

The school for which the calendar date is defined.

Integer

Derived from:
[Calendar_Day]SchoolId

R

schoolYearTypeReference

A reference to the related schoolYearType resource.

R

SchoolYear

Select the school year from the list.

Integer

[S_VT_SCH_X]SchoolNumberPrefix

R

beginTime

The usual start time of a school day in 24-hour HH:MM format. For example, 08:00.

String

[S_VT_SCH_X]BeginTime

O

code

The school ID followed by the current year and separated by a hyphen.

String

Derived from: SCHOOLS.School_Number and year_id

R

typeDescriptor

The calendar types:

  • Student Specific Elementary

  • Student Specific Secondary

  • Student Specific Non-Compulsary

String

[S_VT_SCH_X]CalendarType

R

endTime

The usual end time of a school day in 24-hour HH:MM format. For example, 13:00.

String

[S_VT_SCH_X]EndTime

O

InstructionalTimeInMinutesIndicator

If this checkbox is select then the Instructional Minutes field becomes mandatory. Performance Qualified School.

Boolean

[S_VT_SCH_X]IntructionalTimeInMinutes

R

nonInstructionalMinutes

Enter the non-instructional minutes. For example, lunch, recess, etc.

The non instructional time cannot exceed 480 minutes.

Integer

[S_VT_SCH_X]NonInstructionalMinutes

R

scheduleDescriptor

The schedule types:

  • Trimester

  • Traditional

  • Not Applicable

  • Modified Block

  • Block 8

  • Block 4

String

[S_VT_SCH_X]ScheduleType

R

totalWaiverDays

The total number of waiver days.

Integer

[S_VT_SCH_X]TotalWaiverDays

R


Calendar Dates

This view captures basic information about current year calendar dates as published in the calendarDates resource within the Education Organization Calendar category. The layout includes the School Name, Date, Last Publish Date, Publishing ID, Resource ID.

calendarDates

This resource represents a day in the school calendar.

Primary PowerSchool Source Data

  • [Calendar_Day]

Selection Criteria

Records are published if the following criteria are met:

  • The school's school calendar is defined in S_VT_SCH_X

  • The Event duration is more than one.

  • The school must not be excluded from state reporting.

  • 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 calendarDates record is published for each day for the district, and for each school within the year for the Term selected in the PowerSchool UI.

  • CalendarDates records include both instructional and non-instructional days.

  • As multiple events may occur on the same date, a separate calendar event is published for each unique combination of duration and eventDescriptor within the calendarEvent complex type.

  • The calendarDates 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).


Click Export to export the data collection results to a spreadsheet application.

Data Element

Description

Data Type

Stored in [Table]Field

Req’d

schoolReference

A reference to the related schools resource.

R

/schoolID

The school for which the calendar date is defined.

Integer

Derived from:
[Calendar_Day]SchoolId

R

date

The month, day, and year of the CalendarDate.

Date

[CalendarDay]Date_Value

R

calendarDateCalendarEvent

An unordered collection of calendarDateCalendarEvents.

/calendarEventDescriptor

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

Descriptor

[Calendar_Day]Type

If [Calendar_Day]InSession = 1: 'Instructional Day'

Otherwise: 'Holiday'

R

/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.

Number

If [Calendar_Day]InSession = 1: '1'

Otherwise: '0'

R

Back to top

Grading Periods

This view captures the grading periods defined at each school within the district as published in the gradingPeriods resource within the Education Organization Calendar category. The layout provides the School Name, Name of Term, Descriptor, First Day of Term, Last Day of Term, Total Instruction Days, Period Sequence, Last Publish Date, Publishing ID, and Resource ID.

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

  • The gradingPeriods 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).


Click Export to export the data collection results to a spreadsheet application.

Data Element

Description

Data Type

Stored in [Table]Field

Req’d

schoolReference

A reference to the related school's resource.

/schoolID

The school for which the grading period is defined.

Integer

Derived from:
[Terms]SchoolID

R

descriptor

GradingPeriodDescriptor - The name of the period that grades are reported:

End of Year
Fifth Six Weeks
First Nine Weeks
First Semester
First Six Weeks
First Summer Session
First Trimester
Fourth Nine Weeks
Fourth Six Weeks
Second Nine Weeks
Second Semester
Second Six Weeks
Second Summer Session
Second Trimester
Sixth Six Weeks
Summer Semester
Third Nine Weeks
Third Six Weeks
Third Summer Session
Third Trimester

Descriptor

Derived from:
[Terms]Portion
[Terms]Abbreviation

R

beginDate

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

Date

[Terms]FirstDay

Format:'YYYY-MM-DD'

R

totalInstructionalDays

Total days available for educational instruction during the grading period.

Integer

Derived from:

[Calendar_Day]Date_Value

Count of distinct in-session days that fall between the first day and last day of term record for the school

R

endDate

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

Date

[Terms]LastDay

Format:'YYYY-MM-DD'

R

periodSequence

The sequential order of this period relative to other periods.

Integer

When [GradingPeriods]Portion = 1: '1'

Otherwise derived from:
[Terms]Abbreviation

O

Back to top

Sessions (Terms)

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

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 educational 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 sessions 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 Organization Calendars#gradingPeriods resource for additional information).

  • The sessions resource is dependent on the prior publishing of the following resources: schools.

  • LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).

Click Export to export the data collection results to a spreadsheet application.

Data Element

Description

Data Type

Stored in [Table]Field

Req’d

schoolReference

A reference to the related schools resource.

R

/schoolID

Relates the session to the school.

Integer

Derived from:
[Terms]SchoolID

R

schoolYearTypeReference

A reference to the related schoolYearType resource.

/schoolYear

The identifier for the school year.

Integer

[Terms]YearID

R

termDescriptor

The term for the session during the school year.

Descriptor

Derived from:
[Terms]Portion
[Terms]Abbreviation

R

SessionName

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

Format:'YYYY-MM-DD'

R

endDate

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

Date

[Terms]LastDay

Format:'YYYY-MM-DD'

R

totalInstructionalDays

The total number of instructional days in the school calendar for the session.

Integer

Derived from:

[Calendar_Day]Date_Value

Count of distinct in-session days that fall between the first day and last day of term record for the school

R

sessionGradingPeriods

An unordered collection of sessionGradingPeriods. Grading periods associated with the session calendar.

/gradingPeriodReference

A reference to the related gradingPeriods resource.

//schoolId

The school for which the grading period is defined.

Integer

Derived from:
[Terms]SchoolID

R

//descriptor

The name of the grading period during the school year in which the grade is offered (e.g., 1st cycle, 1st semester)

Descriptor

Derived from:

[Terms]Portion
[Terms]Abbreviation

R

//beginDate

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

Date

[Terms]FirstDay

Format:'YYYY-MM-DD'

R


Back to top

JavaScript errors detected

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

If this problem persists, please contact our support.