Organization Schedule Data

This category carries the education course offerings, the related course sections, including the times and days the sections are offered, along with bell schedule information for each school as published within the Master Schedule category.

Course Offerings

This view captures the detailed list of Course Offerings as published in the CourseOffering resource within the Master Schedule category. The layout includes the School Name, Course Number, Course Name, Section Number, Term, Last Publish date, and the Publishing ID.

courseOffering

This resource represents an entry in the course catalog of available courses offered by the school during a session.

Primary PowerSchool Source Data

[Courses]
[Sections]
[Terms]

Selection Criteria

Records are published if the following criteria are met:

The school where the course is offered must not be excluded from state reporting.
At least one section of the course must not be excluded from state reporting ("State_ExcludeFromReporting").
The course is offered during the year for the Term selected in the PowerSchool UI.
The course must have a valid state course code.

Resource Output

A separate courseOffering record is published for each unique combination of course and section scheduled at each school based on the year for the Term selected in the PowerSchool UI.
Note: In PowerSchool, section records and courseOffering records are essentially the same; the ensuing Ed-Fi Section record within the Master Schedule category adds location and period information.

The CourseOffering resource is dependent on the prior publishing of the following resources: session.
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
localCourseCode	The local code assigned by the School that identifies the course offering provided for the instruction of students.	Varchar(20)	If Report Course.Section setting is set to Yes, then Local Course Number + Section_Number '_' Section DCID Otherwise, [Sections]ID	M
localCourseTitle	The descriptive name given to a course of study offered in the school, if different from the CourseTitle.	Varchar(60)	[Courses]Course_Name	O
instructionalTimePlanned	The planned total number of clock minutes of instruction for this course offering. Generally, this should be at least as many minutes as is required for completion by the related state- or district-defined Course.	Integer	[S_TN_SEC_X]ClassDuration	O
schoolReference/schoolIdentity	The school that offers the course.	Integer	SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	M
sessionReference/sessionIdentity				M
/schoolReference/schoolIdentity	The school for which the session is defined.	Integer	SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	M
/schoolYear	The identifier for the school year.	Enumerated List	[Terms]YearID	M
/term	The term type of the session.	Enumerated List	[Sections]TermID [Terms]Portion [Terms]Abbreviation	M
courseReference/courseIdentity				M
/courseCode	The course being offered by the school. This is typically the CourseCode in the downloaded Course resource, usually the state CourseCode. Typically, if CourseCode does not match a CourseCode in the downloaded Course resource, it will result in an error and/or be prevented from publishing.	Varchar(60)	State CourseCode: [Courses]Alt_Course_Number If blank: [Courses]Course_Number	M
/educationOrganizationReference/ educationOrganizationIdentity	The Education Organization that defines the curriculum and courses offered; published as the SEAId.	Integer	SEAId - Data element downloaded from State: '47'	M

Sections

This view captures the course sections offered at each school as published in the Section resource of the Master Schedule category. The layout includes the School Name, Course Number, Course Name, Section Number, Period Number, Last Publish date, and the Publishing ID.

section

This resource represents a setting in which organized instruction of course content is provided, in-person or otherwise, to one or more students for a given period of time. In Ed-Fi, a course offering may be scheduled for more than one section, but for PowerSchool there is a one-to-one correspondence between each course offering and its corresponding section.

Primary PowerSchool Source Data

[Sections]
[S_TN_SEC_X]
[Section_Meeting]
[Courses]
[Terms]
[Schools]

Selection Criteria

Records are published if the following criteria are met:

The school where the section is taught must not be excluded from state reporting.
The section must not be excluded from state reporting.
The section is taught during the year for the Term selected in the PowerSchool UI.
The course must have a valid state course code.

Resource Output

A section record is published for each unique combination of school, course, and section based on the year for the Term selected in the PowerSchool UI.
The availableCredits complex type reports credit information for sections based on the value in [Courses]Credit_Hours.
Each section record will also contain mandatory references to the courseOffering, location, and classPeriod resources as contained in the Education Organization and Master Schedule categories.
Note: In PowerSchool, section records and courseOffering records are essentially the same; the Ed-Fi Section record adds location and period information.

The section resource is dependent on the prior publishing of the following resources: courseOffering, session, location, and classPeriod.
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
uniqueSectionCode	A unique identifier for the section that is defined by the classroom, the subjects taught, and the instructors that are assigned.	Varchar(255)	[Sections]SchoolID + '' + [Terms]YearID+1991 + '' + [Sections]Course_Number + '' + [Sections]Section_Number + '' + [Sections]DCID	R
sequenceOfCourse	When a section is part of a sequence of parts for a course, the number in the sequence. If the course has only one part, the value should be 1.	Integer	Default: '1'	R
educationalEnvironment	The setting in which a child receives education and related services, for example, Center-based instruction, Home-based instruction, Hospital class, Mainstream, Residential care and treatment facility.	Enumerated List	[S_TN_SEC_X]ClassType T: 'Classroom' P: 'Pull-out class' C: 'Self Contained'	R
mediumOfInstruction	The media through which teachers provide instruction to students and students and teachers communicate about instructional matters, for example, Technology-based instruction in classroom, Correspondence instruction, Face-to-face instruction, Virtual/On-line Distance learning, Center-based instruction.	Enumerated List	[S_TN_SEC_X]TeachingMethod T: 'Face-to-face instruction' D: 'Distance Learning (other than online)' 0: 'Virtual/On-line Distance learning'	R
populationServed	The type of students the section is offered and tailored to, for example, Bilingual students, Remedial education students, Gifted and talented students, Career and Technical Education students, Special education students.	Enumerated List	[S_TN_SEC_X]HonorsClassIndicator Y: 'Honors Students'; else 'Regular Students'	R
availableCredits The amount of credit available to a student who successfully meets the objectives of the course. Available credits are measured in Carnegie units. A course meeting every day for one period of the school day over the span of a school year offers one Carnegie unit.				R
/credit	The value of credits or units of value awarded for the completion of a course.	Decimal (9,2)	[Courses]Credit_Hours	R
courseOfferingReference/courseOfferingIdentity The course offering taught in the section.				M
/localCourseCode	The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students; must match LocalCourseCode in corresponding CourseOffering.	Varchar(20)	If Report Course.Section setting is set to Yes, then Local Course Number + Section_Number '_' Section DCID Otherwise, [Sections]ID	M
/term	The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school. This must match Term in corresponding CourseOffering.	Enumerated List	[Sections]TermID [Terms]Portion [Terms]Abbreviation	M
/schoolYear	The identifier for the school year, for example, 2010-2011. This must match SchoolYear in corresponding CourseOffering.	Enumerated List	[Terms]YearID	M
/schoolReference/schoolIdentity	The school offering the course; must match SchoolID in corresponding CourseOffering.	Integer	SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	M
locationReference/locationIdentity The location, typically a classroom, where the section meets.				M
/classroomIdentificationCode	A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or resource.	Varchar(20)	[Sections]Room Default: 'OPEN'	M
/schoolReference/schoolIdentity	The school for the section's classroom.	Integer	SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	M
classPeriodReference/classPeriodIdentity The class period during which the section meets.				M
/classPeriodName	An indication of the portion of a typical daily session in which students receive instruction in a specified subject, for example, morning, sixth period, block period, or AB schedules.	Varchar(20)	[Period]Period_Number Derived from: [Section_Meeting]Period_Number	M
/schoolReference/schoolIdentity	The school for the class period.	Integer	SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	M

Class Section

This view captures additional scheduling information for Sections. The view layout includes School Name, School Year, School Calendar Number, Course Number, Course Name, Begin Date, Section Number, Period Number, Local Dual Credit, Post-secondary School ID, Term, Last Publish Date, and Publishing ID. Class section also includes an array of the complex element ClassSectionDay, which provides the location where the class was taught and the average minutes taught during the term for each week day, Monday through Saturday. ClassSectionDay is not included in the view.

classSections

This resource represents more detailed information for a section.
Note: The classSections resource is not published for school years prior to the 2016-17 school year.

Primary PowerSchool Source Data

[Sections]
[Courses]
[S_TN_SEC_Honors_X]
[Section_Meeting]
[Terms]
[Cycle_Day]
[Calendar_Day]
[Period]
[Bell_Schedule]
[Bell_Schedule_Items]

Selection Criteria

Records are published if the following criteria are met:

The school must not be excluded from state reporting.
The section must not be excluded from state reporting.
The section is taught during the year for the Term selected in the PowerSchool UI.
The course must have a valid state course code.

Resource Output

A separate classSection record is published for each section that meets the selection criteria.
- classSection includes a sub-resource, classSectionDay.
- A classSectionDay record is included for each day of the week that the section meets.
  Example: a section meeting each day M-F will have five ClassSectionDay records, one for each day the section meets

The classSection resource is dependent on the prior publishing of the following resources: sections, schoolCalendars
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
postSecondary/educationOrganizationId	A reference to the related EducationOrganization resource representing an associated Post-Secondary Institution. *This is required if the class section is local dual credit.	Integer	SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	O*
schoolCalendarReference A reference to the related SchoolCalendar resource.				R
/localEducationAgencyId	LocalEducationAgencyId - The LEA for which the calendar is defined.	Integer	LEAId is downloaded from State.	R
/schoolYear	SchoolYearType - The identifier for the school year.	Integer	[Terms]YearId	R
/districtCalendarNumber	The number year that the district has assigned to uniquely identify the calendar within the district.	Integer	[TNDistrictCalendar]CalendarNumber	R
/schoolID	The school for which the school calendar is defined.	Integer	SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	R
/number	The number that uniquely identifies the calendar within the school.	Integer	[S_TN_SCH_InstrProgram_C]InstructionalProgramNbr	R
sectionReference A reference to the related Section resource.				R
/schoolId	The school for the section.	Integer	SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	R
/classPeriodName	An indication of the portion of a typical daily session in which students receive instruction in a specified subject, for example, morning, sixth period, block period, or AB schedules.	String	[Period]Period_Number Derived from: [Section_Meeting]Period_Number	R
/classroomIdentificationCode	A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or resource.	String	[Sections]Room	R
/localCourseCode	The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.	String	If Report Course.Section setting is set to Yes, then Local Course Number + Section_Number '_' Section DCID Otherwise, [Sections]ID	R
/termType	The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school. This must match Term in corresponding CourseOffering.	String	Derived from: [Terms]Portion [Terms]Abbreviation	R
/schoolYear	The identifier for the school year, for example, 2010-2011. This must match SchoolYear in corresponding CourseOffering.	Integer	[Terms]YearID	R
courseCode	The course being offered by the school. This is typically the CourseCode in the downloaded Course resource, usually the state CourseCode.	String	State CourseCode: [Courses]Alt_Course_Number If blank: [Courses]Course_Number	R
beginDate	The month, day, and year on which the class started.	Date	[Terms]FirstDay	R
endDate	The month, day, and year on which the class ended.	Date	[Terms]LastDay	O
localDualCredit	A high school course that is aligned with a postsecondary challenge examination at a specific postsecondary institution, which allows students exceeding an established cut score to earn postsecondary credits at that institution (typically not transferable). This course is taught by high school faculty at the high school.	String	[S_TN_SEC_Honors_X]LocalDualCredit	O
classSectionDay				R
/educationOrganizationId	Education organization reference representing the actual location the class is taught.	Integer	SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	R
/weekDayDescriptor	Numeric day of the week: 1 = Sunday 2 = Monday 3 = Tuesday 4 = Wednesday 5 = Thursday 6 = Friday 7 = Saturday	String	Derived from: [Section_Meeting], [Terms], [Cycle_Day], [Calendar_Day]	R
/periodDuration	The average duration of the period for that day of the week, over the duration of the course, recorded in minutes. For example, a class meeting 90 minutes every other Monday would report a periodDuration time of 45 minutes for Monday.	Integer	Derived from: [Section_Meeting], [Terms], [Cycle_Day], [Calendar_Day], [Period], [Bell_Sechedule], [Bell_Schedule_Items]	R

Bell Schedule

This view captures the details on the bell schedules for each grade level within each school, and for each date in the school calendar as published in the BellSchedule resource within the Master Schedule category. The layout includes the School Name, Grade Level, Bell Schedule, Calendar Date, Last Publish date, and the Publishing ID.

bellSchedule

This resource represents the schedule of class period meeting times.

Primary PowerSchool Source Data

[Bell_Schedule]
[Bell_Schedule_Items]
[Calendar_Day]
[Period]

Selection Criteria

Records are published if the following criteria are met:

The school must not be excluded from state reporting.
The bell schedule exists within the year for the Term selected in the PowerSchool UI.

Resource Output

A bellSchedule record is published for each unique bell schedule defined at each school, for each grade level, and for each date that the bell schedule is in use during the year for the Term selected in the PowerSchool UI.
The meetingTime complex type includes at least one meetingTime record for each bellSchedule record.
A separate meetingTime element is included for each unique combination of Calendar Date, Class Period, Start Time, and End Time.
There is one calendarDateReference per bellSchedule record; a separate bellSchedule record is published for each date the bell schedule is in effect.
The bellSchedule resource is dependent on the prior publishing of the following resources: calendarDate and classPeriod.
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
bellScheduleName	Name or title of the bell schedule.	Varchar(60)	[Bell_Schedule]Name	M
gradeLevel	The grade levels to which the particular bell schedule applies.	Descriptor	Derived from: [Bell_Schedule]SchoolID [Schools]Low_Grade [Schools]High_Grade	M
schoolReference/schoolIdentity	The school for which the bell schedule is defined.	Integer	SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	M
meetingTime (1-many) The times at which this Bell Schedule is intended to meet.				R
/classPeriodReference/classPeriodIdentity The class period associated with the meeting time for a bell schedule.				R
//classPeriodName	An indication of the portion of a typical daily session in which students receive instruction in a specified subject, for example, morning, sixth period, block period, or AB schedules.	Varchar(20)	[Period]Period_Number Derived from: [Section_Meeting]Period_Number	M
//schoolReference/schoolIdentity	The school for which the period is defined.	Integer	SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	M
/startTime	An indication of the time of day the class begins.	Time	[Bell_Schedule_Items]Start_Time	R
/endTime	An indication of the time of day the class ends.	Time	[Bell_Schedule_Items]End_Time	R
calendarDateReference/calendarDateIdentity The calendar dates when the bell schedule is implemented.				R
/date	The month, day, and year of the calendar date.	Date	[Calendar_Day]Date_Value, [Calendar_Day]Bell_Schedule_ID	M
/educationOrganizationReference/ educationOrganizationIdentity	The school for which the calendar date is defined.	Integer	SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	M