Organization Calendars
This category represents information about sessions, grading periods, and calendars as published within the Organization Calendar category. The Organization Calendars category includes the following data views and resources:
Calendar Dates
This data view represents a detailed list of Calendar Dates associated with the calendar successfully published to the ODS. This represents a day in the school calendar. Calendar Date records include both instructional and non-instructional days. The published view layout provides the School Name, Date, Last Publish Date, Publishing ID, and Resource ID.
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.
- 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 not dependent on the prior publishing of any Ed-Fi resources.
- 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 | [Table]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 | SchoolID downloaded from the state Derived from: [Calendar_Day]SchoolID | R |
date | The month, day, and year of the calendar date. | Date | [CalendarDay]Date_Value | R |
calenderDateCalendarEvent 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 | [CalendarDay]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 |
Grading Periods
This data view represents a detailed list of Grading Periods associated with the calendar successfully published to the ODS. This represents the time span for which grades are reported. A separate grading period record is published for each unique term at each school. The published view 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: calendarDates.
- 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 | [Table]Data Type | Stored in [Table]Field | Req’d |
---|---|---|---|---|
schoolReference A reference to the related School resource. | R | |||
/schoolId | The school for which the grading period is defined. | Integer | SchoolID downloaded from the state 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). | String | Derived from: [Terms]Portion | R |
beginDate | Month, day, and year of the first day of the GradingPeriod. | Date | [Terms]FirstDay | 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 the term record for the school. | R |
endDate | Month, day, and year of the last day of the GradingPeriod. | Date | [Terms]LastDay | R |
periodSequence | The sequential order of this period relative to other periods. | Integer | When [Terms]Portion = 1: '1' Otherwise: Derived from [Terms]Abbreviation | O |
Sessions (Terms)
This data view represents a detailed list of Sessions (Terms) successfully published to the ODS. This 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. The published view 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 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 at each school.
- The sessions resource is not dependent on the prior publishing of any Ed-Fi resources.
- 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 | [Table]Data Type | Stored in [Table]Field | Req’d |
---|---|---|---|---|
schoolReference A reference to the related School resource. | R | |||
/schoolId | Relates the session to the school. | Integer | SchoolID downloaded from the state Derived from: [Terms]SchoolID | R |
schoolYearTypeReference A reference to the related schoolYearType resource. | R | |||
/schoolYear | The identifier for the school year. | Integer | [Terms]YearID | R |
termDescriptor | The term for the session during the school year. | String | Derived from: [Terms]Portion | R |
name | The identifier for the calendar for the academic session (e.g., 2010/11, 2011 Summer). NEDM: Session Type. | 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]EndDate | 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 the term record for the school. | R |
sessionGradingPeriod An unordered collection of sessionGradingPeriods. Grading periods associated with the session calendar. | R | |||
/gradingPeriodReference A reference to the related GradingPeriod resource. | R | |||
//schoolId | The school for which the grading period is defined. | Integer | SchoolID downloaded from the state 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). | String | Derived from: [Terms]Portion | R |
//beginDate | Month, day, and year of the first day of the GradingPeriod. | Date | [Terms]FirstDay | R |