Organization Calendar Data
This category represents information about sessions, grading periods, calendars, funding periods, and student standard days as published within the Education Organization Calendar category.
Sessions (Terms)
This view captures the sessions/terms defined at each school within the district as published in the Session resource within the Education Organization Calendar category. Ed-Fi sessions are 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).
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 |
|---|---|---|---|---|
sessionName | The identifier for the calendar for the academic session, for example, 2010/11, 2011 Summer. | Varchar(60) | [Terms]Name | R |
schoolYear | The identifier for the school year. | Enumerated List | [Terms]YearID | M |
term | The term for the session during the school year. | Enumerated List | [Terms]Portion | M |
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 |
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 |
schoolReference/schoolIdentity | 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 | M |
gradingPeriodReference/GradingPeriodIdentity (1-many) 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 |
Grading Periods
This view captures the grading periods defined at each school within the district as published in the GradingPeriod resource within the Education Organization Calendar 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: calendarDate.
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 | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
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 |
gradingPeriod | The name of the period for which grades are reported. | Descriptor | [Terms]Portion [Terms]Abbreviation Mapped to GradingPeriod Descriptor | 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 |
periodSequence | The sequential order of this period relative to other periods. | Integer | Calculated from: [Terms]Portion [Terms]Abbreviation | O |
Calendar Dates
This view captures basic information about current year calendar dates as published in the CalendarDate resource within the Education Organization Calendar category. The layout includes the School Name, Date, Type of day, Last Publish date, and the Publishing ID.
calendarDate
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).
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 |
|---|---|---|---|---|
date | The month, day, and year of the calendar date. | Date | [Calendar_Day]Date_Value | M |
educationOrganizationReference/ | 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 |
/calendarEventDescriptor | The type of scheduled or unscheduled event for the day, for example, Instructional day, Teacher only day, Holiday. Refer to Event Type Codes (200 Day Event Calendar) for information on the values that can be published. | Descriptor | [Calendar_Day]Type | M |
District Calendar
This view captures summary district calendar information as published in the DistrictCalendar resource within the Education Organization Calendar 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.
districtCalendar
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).
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 |
|---|---|---|---|---|
localEducationAgencyReference/ | The LEA for which the calendar is defined. | Integer | LEAId downloaded from State | M |
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 |
scheduledDays | The scheduled days for the calendar, either Monday – Friday or Monday – Saturday. | Descriptor | [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. | Integer | [TNDistrictCalendar]SchoolStockpileIWD | R |
stockpileProfessionalDevDays | The number of days set aside for professional development for this calendar. | Integer | [TNDistrictCalendar]SchoolStockpilePDD | R |
inServiceDays | The number of in-service days for this calendar. | Integer | [TNDistrictCalendar]InServiceDays | R |
optionalInServiceDays | The number of optional in-service days for this calendar. | Integer | [TNDistrictCalendar]OptionalInServiceDays | R |
parentTeacherConferenceDays | The number of parent/teacher conference days for this calendar. | Integer | [TNDistrictCalendar]ParentTeacherDays | R |
teacherVacationDays | The number of teacher vacation days for this calendar. | Integer | [TNDistrictCalendar]TeacherVacationDays | R |
abbreviatedDays | The number of abbreviated days for this calendar. | Integer | [TNDistrictCalendar]AbbreviatedDays | R |
discretionaryTeacherVacationDays | The number of discretionary teacher vacation days for this calendar. | Integer | [TNDistrictCalendar]DiscretTeacherVacDays | R |
discretionaryInServiceDays | The number of discretionary in-service days for this calendar. | Integer | [TNDistrictCalendar]DiscretInServiceDays | R |
discretionaryAdministrativeDays | The number of discretionary administrative days for this calendar. | Integer | [TNDistrictCalendar]DiscretAdminDays | R |
discretionaryInstructionalDays | The number of discretionary instructional days for this calendar. | Integer | [TNDistrictCalendar]DiscretInstructionalDays | R |
discretionaryOtherDays | The number of discretionary other days for this calendar. | Integer | [TNDistrictCalendar]DiscretOtherDays | R |
instructionalDays | The number of instructional days for this calendar. | Integer | [TNDistrictCalendar]InstructionalDays | R |
districtCalendarDate (1-many) | 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. Refer to Event Type Codes (200 Day Event Calendar) for information on the values that can be published. | Descriptor | [DistrictCalendarDay]Type | M |
/instructionalDay | Indication of whether the calendar day is an instructional day. | Boolean | [DistrictCalendarDay]InSession | R |
School Calendars
This view captures the summary school calendar information as published in the SchoolCalendar resource within the Education Organization category. The layout includes the School Name, Instructional Program Number, Calendar Number, Instructional Calendar, Last Publish date, and the Publishing ID.
schoolCalendar
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 schoolCalendar record is published for each unique Instructional Program within each school.
School calendar dates are not published as part of the schoolCalendar resource; instead, they are published in the calendarDate 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).
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 |
|---|---|---|---|---|
educationOrganizationReference/ | 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 |
districtCalendarReference/DistrictCalendarIdentity | M | |||
/localEducationAgencyReference/ | The LEA for which the calendar is defined. | Integer | LEAId downloaded from State | M |
/schoolYear | The identifier for the school year. | Enumerated List | Derived from: [DistrictCalendar]CalendarYear | M |
/districtCalendarNumber | The number year that the district has assigned to uniquely identify the calendar within the district. | 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. | M |
schoolCalendarNumber | The number that uniquely identifies the calendar within the school. | Integer | [S_TN_SCH_InstrProgram_C]InstructionalProgramNbr | R |
instructionalCalendar | The type of calendar, either traditional or year round. | Descriptor | [S_TN_SCH_InstrProgram_C]InstructionalCalendar T: 'Traditional' Y: 'Year Round' | R |
stockpileProfessionalDevDays | The number of days set aside for professional development for this calendar. | Integer | [S_TN_SCH_InstrProgram_C]Stockpile_PDD | R |
instructionalDays | The number of instructional days for this calendar. | Integer | Derived from: [CalendarDay]InSession | R |
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 |
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 |
blockSchedule | Indication if the calendar is associated with a block schedule. | Varchar(1) | [S_TN_SCH_InstrProgram_C]BlockSchedule | R |
springBlockBeginDate | The starting date for the spring block. | Date | [S_TN_SCH_InstrProgram_C]SpringBlockScheduleDate | R |
schoolCalendarDate (1-many) | 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. Refer to Event Type Codes (200 Day Event Calendar) for information on the values that can be published. | 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 |
calendarTypeDescriptor | Indicates the type of calendar. The code is School and the description is also School. | Descriptor | R | |
Funding Periods
This view captures the funding period information for each school as published in the FundingPeriod resource within the Education Organization category. The layout includes the School Name, Reporting Period Number, Instructional Program Number, and Segment Name, along with the Start Date and End Date for each period, Last Publish date, and the Publishing ID.
fundingPeriod
This resource represents the funding periods associated with each instructional program at each school.
Primary PowerSchool Source Data
[S_TN_SCH_InstrProgram_C]
[Gen]
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.
The Funding Period must be assigned a unique number, a begin date and an end date.
The Funding Period dates must fall within the year for the Term selected in the PowerSchool UI.
Resource Output
A fundingPeriod record is published for each unique Instructional Program and each unique Funding Period within each school.
The fundingPeriod resource is dependent on the prior publishing of the following resources: calendarDate, districtCalendar and schoolCalendar.
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 | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
schoolCalendarReference/schoolCalendarIdentity | M | |||
/districtCalendarReference/districtCalendarIdentity | M | |||
//localEducationAgencyReference/ | The LEA for which the calendar is defined. | Integer | LEAId downloaded from State | M |
//schoolYear | The identifier for the school year. | Enumerated List | Derived from: [DistrictCalendar]CalendarYear | M |
//districtCalendarNumber | The number year that the district has assigned to uniquely identify the calendar within the district. | Integer | [TNDistrictCalendar]CalendarNumber | M |
/schoolReference/schoolIdentity | Reference to the school associated with the calendar | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
/schoolCalendarNumber | The number that uniquely identifies the calendar within the district. | Integer | [S_TN_SCH_InstrProgram_C]InstructionalProgramNbr | M |
periodNumber | The number of the report period during the Instructional Program. | Varchar(2) | Derived from: [Gen]Value where [Gen]Cat='segment' | R |
periodBeginDate | The first day of a 20-day report period. | Date | Derived from: [Gen]Value where [Gen]Cat='segment' Must be formatted as CCYYMMDD | R |
periodEndDate | The last day of a 20-day report period. | Date | Derived from: [Gen]Value2 where [Gen]Cat='segment' Must be formatted as CCYYMMDD | R |
Standard Day
This view captures the number of instructional minutes for each grade level within each school as published in the StudentStandardDay resource within the Education Organization category. The layout includes the School Name, Grade Level, Student Standard Day (minutes), Last Publish date, and the Publishing ID.
studentStandardDay
This resource represents the number of instructional minutes for a full-time student in a particular grade level.
Primary PowerSchool Source Data
[Schools]
[S_TN_SCH_InstrProgram_C]
[Students]
Selection Criteria
Records are published if the following criteria are met:
The school must not be excluded from state reporting.
At least one student in the grade level is not excluded from state reporting.
Resource Output
A standardStudentDay record is published for each grade level that contains at least one reportable student.
The studentStandardDay resource is dependent on the prior publishing of the following resources: calendarDate, districtCalendar, and schoolCalendar.
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 | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
schoolCalendarReference/schoolCalendarIdentity | M | |||
/districtCalendarReference/districtCalendarIdentity | M | |||
//localEducationAgencyReference/ | The LEA for which the calendar is defined. | Integer | LEAId downloaded from State | M |
//schoolYear | The identifier for the school year. | Enumerated List | Derived from: [DistrictCalendar]CalendarYear | M |
//districtCalendarNumber | The number year that the district has assigned to uniquely identify the calendar within the district. | Integer | [TNDistrictCalendar]CalendarNumber | M |
/schoolReference/schoolIdentity | Reference to the school associated with the calendar | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
/schoolCalendarNumber | The number that uniquely identifies the calendar within the district. | Integer | [S_TN_SCH_InstrProgram_C]InstructionalProgramNbr | M |
gradeLevel | The grade level associated with the Student Standard Day. | Descriptor | One record per school and grade level of enrolled students Grade Level -2: 'P3' Grade Level -1: 'P4' Grade Level 0: 'K' | R |
totalInstructionalMins | The total instructional minutes for the Student Standard Day. | Integer | Derived from: [S_TN_SCH_X]StndDayDuration Calculated for each grade level based on value of StndDayDuration for students grouped by grade level | R |