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