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:
| 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 | |
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.
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 are published as: uri://ed-fi.org/CalendarEventDescriptor#Instructional day Non-Instructional days (M-F) are published as: uri://ed-fi.org/CalendarEventDescriptor#Non-instructional day | 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 |