Calendars
This category represents information about sessions, grading periods, calendars, funding periods, and student standard days as published within the Calendars category.
To export the data collection results any of the reports output to a spreadsheet, click Export.
localEducationAgencyCalendars
This view captures summary district calendar information as published in the localEducationAgencyCalendars resource within the Calendars category. The layout includes the Calendar Number, Schedule Days, Instructional Calendar, In-service Days, Optional In-service Days, Parent Teacher Days, Last Publish date, and the Publishing ID.
localEducationAgencyCalendars
This resource represents the calendar(s) for the district.
Primary PowerSchool Source Data
- [DistrictCalendar]
- [TNDistrictCalendar]
Selection Criteria
Records are published if the following criteria are met:
- Each DistrictCalendar must be assigned a unique calendar number.
- The calendar is for the year of the Term selected in the PowerSchool UI.
- The calendar number must be between 01 and 99.
Resource Output
- A districtCalendar record is published for each unique calendar within the current school year.
- The calendar dates associated with the district calendar are published as part of the districtCalendar resource.
- The districtCalendar resource is not dependent on the prior publishing of other Ed-Fi resources.
- LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
schoolYear | The identifier for the school year. | Enumerated List | Derived from: | M |
districtCalendarNumber | The number that the district has assigned to uniquely identify the calendar within the district. | Integer | [TNDistrictCalendar]CalendarNumber | M |
scheduledDaysDescriptor | The scheduled days for the calendar, either Monday – Friday or Monday – Saturday. | String | [TNDistrictCalendar]ScheduleDays | R |
instructionalCalendar | InstructionalCalendarDescriptor - The type of calendar, either traditional or year round. | Descriptor | [TNDistrictCalendar]InstructionalCalendar | R |
stockpileInclementWeatherDays | The number of days set aside for inclement weather for this calendar. | Decimal | [TNDistrictCalendar]SchoolStockpileIWD | R (Not updated) |
stockpileProfessionalDevDays | The number of days set aside for professional development for this calendar. | Decimal | [TNDistrictCalendar]SchoolStockpilePDD | R |
inServiceDays | The number of in-service days for this calendar. | Decimal | [TNDistrictCalendar]InServiceDays | R |
optionalInServiceDays | The number of optional in-service days for this calendar. | Decimal | [TNDistrictCalendar]OptionalInServiceDays | R |
parentTeacherConferenceDays | The number of parent/teacher conference days for this calendar. | Decimal | [TNDistrictCalendar]ParentTeacherDays | R |
teacherVacationDays | The number of teacher vacation days for this calendar. | Decimal | [TNDistrictCalendar]TeacherVacationDays | R |
abbreviatedDays | The number of abbreviated days for this calendar. | Decimal | [TNDistrictCalendar]AbbreviatedDays | R |
discretionaryTeacherVacationDays | The number of discretionary teacher vacation days for this calendar. | Decimal | [TNDistrictCalendar]DiscretTeacherVacDays | R |
discretionaryInServiceDays | The number of discretionary in-service days for this calendar. | Decimal | [TNDistrictCalendar]DiscretInServiceDays | R |
discretionaryAdministrativeDays | The number of discretionary administrative days for this calendar. | Decimal | [TNDistrictCalendar]DiscretAdminDays | R |
discretionaryInstructionalDays | The number of discretionary instructional days for this calendar. | Decimal | [TNDistrictCalendar]DiscretInstructionalDays | R |
discretionaryOtherDays | The number of discretionary other days for this calendar. | Decimal | [TNDistrictCalendar]DiscretOtherDays | R |
instructionalDays | The number of instructional days for this calendar. | Decimal | [TNDistrictCalendar]InstructionalDays | R |
| localEducationAgencyReference/ localEducationAgencyId | The LEA for which the calendar is defined. | Int32 | Need to update | R |
| calendarCode | The Calendar Number year that the district has assigned to uniquely identify the calendar within the district. Need to update | String | Need to update | R |
| calendarTypeDescriptor | Need to update | String | Need to update | R |
| _ext.tdoe/submittedForSchoolYearTypeReference/schoolYear | Need to update | Int32 | Need to update | R |
| _ext.tdoe/submittedByEducationOrganizationReference/educationOrganizationId | Need to update | Int32 | Need to update | R |
districtCalendarDate (1-many) - Need to remove or add to another section) | R | |||
/date | The month, day, and year of the calendar date. | Date | [DistrictCalendarDay]Date_Value | M |
/eventDuration | The amount of time for the event as recognized by the school: 1 day = 1.0, 1/2 day = 0.5, 1/3 day = 0.33. | Decimal(3,2) | [DistrictBellSchedule] | R |
/calendarEvent | The type of scheduled or unscheduled event for the day, for example, Instructional day, Teacher only day, Holiday. | Descriptor | [DistrictCalendarDay]Type | M |
/instructionalDay | Indication of whether the calendar day is an instructional day. | Boolean | [DistrictCalendarDay]InSession | R |
localEducationAgencyCalendarDates
This view captures basic information about current year calendar dates as published in the localEducationAgencyCalendarDates resource within the Calendars category. The layout includes the School Name, Date, Type of day, Last Publish date, and the Publishing ID.
localEducationAgencyCalendarDates
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 school falls within the year for the Term selected in the PowerSchool UI.
Resource Output
- Within the year for the Term selected in the PowerSchool UI, a calendarDate record is published for each day within each unique school calendar associated with a Tennessee Instructional Program.
- calendarDate records include both instructional and non-instructional days.
- As multiple events may occur on the same date, a separate calendarEvent is published for each unique combination of Duration and Event Descriptor within the calendarEvent complex type.
- The calendarDate resource is dependent on the prior publishing of the following resources: schoolCalendar.
- LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
| calendarEvents (1-many) (Need to confirm if this 1-many or 1-1) | ||||
| /calendarEventDescriptor | String | |||
| _ext.tdoe.eventDuration | Fraction of school day for this event, allowable values 1.00 (EIS record uses 100), 0.50 (EIS record uses 050), and 0.33 (EIS record uses 033) | Decimal | ||
date | The month, day, and year of the calendar date. | Date | [Calendar_Day]Date_Value | R |
| localEducationAgencyCalendarReference (1-many) | ||||
| /calendarCode | For cross compatibilty must be two character left padded integer between 1 and 99 inclusive | String | ||
| /localEducationAgencyId | Int32 | |||
| /schoolYear | Ed-Fi uses the concluding year, so schoolyear 2018-19 is 2018 in EIS but 2019 in Ed-Fi | Int32 | ||
| _ext.tdoe.submittedForSchoolYearTypeReference/schoolYear | Ed-Fi uses the concluding year, so schoolyear 2018-19 is 2018 in EIS but 2019 in Ed-Fi | Int32 | ||
| _ext.tdoe.submittedByEducationOrganizationReference/EducationOrganizationId | Used for assigning errors - should be the most granular Id - prefer SchoolId to LocalEducationAgencyId where possible. In this case, LocalEducationAgencyId | Int32 | ||
educationOrganizationReference/ Need to remove or move another section | The Education Organization for which the calendar date is defined. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
calendarEvent (1-many) | M | |||
/eventDuration | The amount of time for the event as recognized by the school: 1 day = 1.0, 1/2 day = 0.5, 1/3 day = 0.33. | Decimal(3,2) | Derived from: | M |
/calendarEvent | The type of scheduled or unscheduled event for the day, for example, Instructional day, Teacher only day, Holiday. | Descriptor | [Calendar_Day]Type | M |
calendars
This view captures the summary school calendar information as published in the calendars resource within the Calendars category. The layout includes the School Name, Instructional Program Number, Calendar Number, Instructional Calendar, Last Publish date, and the Publishing ID.
calendars
This resource represents the calendars for each instructional program within each school.
Primary PowerSchool Source Data
- [Calendar_Day]
- [S_TN_SCH_InstrProgram_C]
Selection Criteria
Records are published if the following criteria are met:
- The school must not be excluded from state reporting.
- The Instructional Program must be assigned a unique program number.
Resource Output
- A calendars record is published for each unique Instructional Program within each school.
- School calendar dates are not published as part of the calendars resource; instead, they are published in the calendarDates resource.
- The schoolCalendar resource is dependent on the prior publishing of the following resources: districtCalendar.
- LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
| calendarCode | Instructional Program Number Need to update | String | R | |
| schoolReference/schoolId | District ID and School Id Need to update | System.int32 | R | |
| schoolYearTypeReference/schoolYear | School Year Need to update | Int32 | R | |
| calendarTypeDescriptor | Need to update | String | R | |
| gradeLevels/GradeLevelDescriptor | Need to update | String | O | |
| _ext.tdoe/submittedForSchoolYearTypeReference/SchoolYear | Ed-Fi uses the concluding year, so schoolyear 2018-19 is 2018 in EIS but 2019 in Ed-Fi Need to update | Int32 | R | |
| _ext.tdoe/submittedByEducationOrganizationReference/EducationOrganizationId | Used for assigning errors - should be the most granular Id - prefer SchoolId to LocalEducationOrganizationId where possible. In this case, same as schoolReference.schoolId Need to update | Int32 | R | |
educationOrganizationReference/ Need to remove or move to another section | The Education Organization for which the school calendar is defined. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
_ext.tdoe/localEducationAgencyCalendarReference (1-many) (Need to update 1-1 or 1-many status) | R | |||
/localEducationAgencyId | The LEA for which the calendar is defined. | Int32 | LEAId downloaded from State | M |
/schoolYear | The identifier for the school year. | Int32 | Derived from: [DistrictCalendar]CalendarYear | M |
/localEducationAgencyCalendarCode | The Calendar Number year that the district has assigned to uniquely identify the calendar within the district. Need to update | Integer | [TNDistrictCalendar]CalendarNumber Match on [S_TN_SCH_InstrProgram_C]CalendarNumber, but if only one district calendar, then all school calendars belong to district calendar, regardless of [S_TN_SCH_InstrProgram_C]TCalendarNumber value. Need to update | R |
schoolCalendarNumber Need to remove or move another resource | The number that uniquely identifies the calendar within the school. | Integer | [S_TN_SCH_InstrProgram_C]InstructionalProgramNbr | R |
instructionalCalendar Need to remove or move another resource | The type of calendar, either traditional or year round. | Descriptor | [S_TN_SCH_InstrProgram_C]InstructionalCalendar T: 'Traditional' Y: 'Year Round' | R |
_ext.tdoe/stockpileProfessionalDevDays | The number of days set aside for professional development for this calendar. | Integer | [S_TN_SCH_InstrProgram_C]Stockpile_PDD | R |
_ext.tdoe/instructionalDays | The number of instructional days for this calendar. | Integer | Derived from: [CalendarDay]InSession | R |
_ext.tdoe/studentDay | Length in minutes for a standard full-time day including lunch for students in this program within the school. | Integer | [S_TN_SCH_InstrProgram_C]StudentDayLength | R |
_ext.tdoe/teacherDay | Length in minutes for standard full-time day of instruction including lunch, for teachers in this program within the school. Usually StudentDay plus time teachers are required to be at the school before student arrival and after student departure. | Integer | [S_TN_SCH_InstrProgram_C]TeacherDayLength | R |
_ext.tdoe/usesBlockScheduleIndicator | Indication if the calendar is associated with a block schedule. | Varchar(1) | [S_TN_SCH_InstrProgram_C]BlockSchedule | R |
_ext.tdoe/springBlockBeginDate | The starting date for the spring block. | Date | [S_TN_SCH_InstrProgram_C]SpringBlockScheduleDate | R |
| _ext.tdoe.calendarFundingPeriods (1-many) | ||||
/periodNumber | The number of the report period during the Instructional Program. | Int32 | Derived from: [Gen]Value where [Gen]Cat='segment' | R |
/beginDate | The first day of a 20-day report period. | Date | Derived from: [Gen]Value where [Gen]Cat='segment' Must be formatted as CCYYMMDD | R |
/endDate | The last day of a 20-day report period. | Date | Derived from: [Gen]Value2 where [Gen]Cat='segment' Must be formatted as CCYYMMDD | R |
schoolCalendarDate (1-many) - Need to remove or add to another section - all rows below | R | |||
/date | The month, day, and year of the calendar date. | Date | [Calendar_Day]Date_Value | R |
/eventDuration | The amount of time for the event as recognized by the school: 1 day = 1.0, 1/2 day = 0.5, 1/3 day = 0.33. | Decimal(3,2) | [Bell_Schedule] If contains "full": '1.0 If contains "half": '0.50' If contains "third": '0.33' Default = '1.0' | R |
/calendarEvent | The type of scheduled or unscheduled event for the day, for example, Instructional day, Teacher only day, Holiday. | Descriptor | [Calendar_Day]Type | R |
/InstructionalDay | Indication of whether the calendar day is an instructional day. | Boolean | [Calendar_Day]InSession If InSession = 1: 'True'; else 'False' | O |
calendarDates
This view captures basic information about current year calendar dates as published in the calendarDates resource within the Calendars category. The layout includes the School Name, Date, Type of day, Last Publish date, and the Publishing 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 school falls within the year for the Term selected in the PowerSchool UI.
Resource Output
- Within the year for the Term selected in the PowerSchool UI, a calendarDates record is published for each day within each unique school calendar associated with a Tennessee Instructional Program.
- calendarDates records include both instructional and non-instructional days.
- As multiple events may occur on the same date, a separate calendarEvent is published for each unique combination of Duration and Event Descriptor within the calendarEvent complex type.
- The calendarDates resource is dependent on the prior publishing of the calendars resource.
- LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
| calendarEvents (1-many) | R | |||
| /calendarEventDescriptor | The type of scheduled or unscheduled event for the day, for example, Instructional day, Teacher only day, Holiday. | String | [Calendar_Day]Type If null: [Calendar_Day]InSession If InSession = 1: 'Instructional'; else 'Other' | R |
| /_ext.tdoe/eventDuration | The amount of time for the event as recognized by the school: 1 day = 1.0, 1/2 day = 0.5, 1/3 day = 0.33. | Decimal | Derived from: [BellSchedule]Name If contains "full": '1.0 If contains "half": '0.50' If contains "third": '0.33' Default: '1.0' | R |
date | The month, day, and year of the calendar date. | Date | [Calendar_Day]Date_Value | R |
| calendarReference (1-many) | ||||
| /calendarCode | Instructional Program Number Need to update | String | R | |
| /schoolId | District ID and School Id Need to update | Int32 | R | |
| /schoolYear | District ID and School Id | Int32 | R | |
| _ext.tdoe/submittedForSchoolYearTypeReference/schoolYear | Need to update | Int32 | R | |
| _ext.tdoe/submittedByEducationOrganizationReference/educationOrganizationId | The Education Organization for which the calendar date is defined. | Int32 | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | R |
session
This view captures the sessions/terms defined at each school within the district as published in the session resource within the Calendars category. Ed-Fi session is the equivalent of PowerSchool terms. The layout provides the School Name, Year, Name of Term, First Day of Term, Last Day of Term, Last Publish date, and the Publishing ID.
session
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 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 gradingPeriod resource for additional information).
- The session resource is dependent on the prior publishing of the following resources: gradingPeriod, calendarDate.
- LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Req’d | |
|---|---|---|---|---|---|
sessionName | The identifier for the calendar for the academic session, for example, 2010/11, 2011 Summer. | Varchar(60) | [Terms]Name | R | |
| schoolReference/schoolId | Relates the session to the school. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | R | |
| schoolYearTypeReference/schoolYear | The identifier for the school year. | Int32 | R | ||
| academicWeeks.academicWeekReference (1-many) (Need to update 1-1 or 1-many status) | O | ||||
| /schoolId | O | ||||
| /weekIdentifier | |||||
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]LastDay | R | |
| gradingPeriods.gradingPeriodReference (1-many) | O | ||||
| /gradingPeriodDescriptor | O | ||||
| /periodSequence | O | ||||
| /schoolId | O | ||||
| /schoolYear | O | ||||
| termDescriptor | Need to update | String | Need to update | R | |
totalInstructionalDays | The total number of instructional days in the school calendar. | Integer | [Calendar_Day]Date_Value where InSession = 1 and Date_Value between FirstDay and LastDay of Term record for school. | R | |
| _ext.tdoe/submittedForSchoolYearTypeReference/SchoolYear |
| R | |||
| _ext.tdoe/submittedByEducationOrganizationReference/EducationOrganizationId | Used for assigning errors - should be the most granular Id - prefer SchoolId to LocalEducationAgencyId where possible. In this case match schoolReference.schoolId
| R | |||
gradingPeriodReference/GradingPeriodIdentity (1-many) - NOT UNDER SESSION - MAY NEED TO REMOVE OR ADD TO ANOTHER RESOURCE The grading periods associated with the calendar. | M | ||||
/gradingPeriod | The name of the period for which grades are reported. | Descriptor | [Terms]Portion | M | |
/beginDate | The month, day, and year of the first day of the grading period. | Date | [Terms]FirstDay | M | |
/educationOrganizationReference | The school for which the grading period is defined. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M | |
gradingPeriods
This view captures the grading periods defined at each school within the district as published in the gradingPeriod resource within the Calendars category. The layout provides the School Name, Name of Term, First Day of Term, Last Day of Term, Last Publish date, and the Publishing ID.
gradingPeriod
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
- A separate gradingPeriod record is published for each unique term record at each school based on [Terms]Portion and [Terms]Abbreviation.
- The gradingPeriod resource is dependent on the prior publishing of the following resources: calendarDates.
- LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
| gradingPeriodDescriptor | The name of the period for which grades are reported. | String | [Terms]Portion [Terms]Abbreviation Mapped to GradingPeriod Descriptor Need to update | R |
| periodSequence | The sequential order of this period relative to other periods. | Integer | Calculated from: [Terms]Portion [Terms]Abbreviation | |
educationOrganizationReference/ | The Education Organization for which the grading period is defined - usually the LEA or school. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
beginDate | Month, day, and year of the first day of the grading period. | Date | [Terms]FirstDay | M |
endDate | Month, day, and year of the last day of the grading period. | Date | [Terms]LastDay | R |
totalInstructionalDays | Total days available for educational instruction during the grading period. | Integer | [Calendar_Day]Date_Value where InSession = 1 and Date_Value between FirstDay and LastDay of Term record for school | R |
| _ext.tdoe/submittedForSchoolYearTypeReference/SchoolYear | Ed-Fi uses the concluding year, so schoolyear 2018-19 is 2018 in EIS but 2019 in Ed-Fi Need to update | Int32 | Need to update | R |
| _ext.tdoe/submittedByEducationOrganizationReference/EducationOrganizationId | Used for assigning errors - should be the most granular Id - prefer SchoolId to LocalEducationAgencyId where possible. In this case, match schoolReference.schoolId Need to update | Int32 | Need to update | R |