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 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 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).
Note: Click Export to export the data collection results to an Excel spreadsheet.
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: | R |
| date | The month, day, and year of the CalendarDate. | Date | Calendar_Day.Date_Value | R |
calendarDateCalendarEvent An unordered collection of calendarDateCalendarEvents. | R | |||
/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: Published Value = 'Instructional Day' Otherwise: Published Value = '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: Published Value = '1' Otherwise: Published Value = '0' | R |
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, First Day of Term, Last Day of Term, Name of Term, 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).
Note: Click Export to export the data collection results to an Excel spreadsheet.
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 grading period is defined. | Integer | Derived from: | R |
descriptor | GradingPeriodDescriptor - The name of the period for which grades are reported. | Descriptor | Derived from: | 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 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: Published Value = '1' Otherwise derived from: | O |
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, Year, First Day of Term, Last Day of Term, Name 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 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 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 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).
Note: Click Export to export the data collection results to an Excel spreadsheet.
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: | 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 |
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 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 school | R |
sessionGradingPeriods An unordered collection of sessionGradingPeriods. Grading periods associated with the session calendar. | R | |||
/gradingPeriodReference A reference to the related gradingPeriods resource. | R | |||
//schoolId | The school for which the grading period is defined. | Integer | Derived from: | 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 | R |
//beginDate | Month, day, and year of the first day of the GradingPeriod. | Date | Terms.FirstDay Format: 'YYYY-MM-DD' | R |