Organization Schedules

This category captures the organization course, section, and bell schedule information for the school year. The Organization Schedules category includes the following data views and resources:

Course Offerings

This view captures the detailed list of Course Offerings as published in the CourseOffering resource within the Organization Schedules category. The layout includes the School Name, Course Number, Course Name, and Term.

courseOfferings

This resource represents an entry in the course catalog of available courses offered by the school during a session. A separate Course Offering record is published for each unique combination of course and section scheduled at each school.

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.
The course is offered during the year for the Term selected in the PowerSchool UI.

Resource Output

A separate Course Offering record is published for each unique combination of course and term scheduled at each school.

Note: In PowerSchool, CourseOffering records are derived from section, course, and term records. A single CourseOffering record is published for all sections of a course offered during the same term.

The CourseOfferring resource is dependent on the prior publishing of the following resources: Sessions and Courses.
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	Data Type	Stored in [Table]Field	Req'd
courseReference/courseIdentity				R
/educationOrganizationId	The Education Organization that defines the curriculum and courses offered - often the LEA or school. This organization identifier matches the EducationOrganizationId in the Course resource, usually the SEAId.	Integer	[Prefs]Name=districtnumber [Prefs]Value	R
/code	The course being offered by the school.	String	[Courses]Course_Number	R
schoolId	The school that offers the course.	Integer	Derived from: [Courses]SchoolId	R
sessionReference/sessionIdentity				R
/schoolId	The school for the section's classroom.	Integer	Derived from: [Terms]SchoolId	R
/termDescriptor	The term type of the session.	Descriptor	Derived from: [Terms]Portion [Terms]Abbreviation	R
/schoolYearType	The identifier for the school year.	Type	[Terms]YearId	R
localCourseCode	The local code assigned by the LEA that identifies the organization of subject matter and related learning experiences provided for the instruction of students.	String	[Courses]Course_Number Internal spaces in the course number are replaced with an underscore, and leading /trailing spaces are removed.	R
localCourseTitle	The descriptive name given to a course of study offered in the school, if different from the CourseTitle.	String	[Courses]Course_Name	O

Back to top

Sections

This view captures the course sections offered at each school as published in the Section resource of the Organization Schedules category. The layout includes School Name, Course Number, Course Name, Section Number, Term, and Period Number.

sections

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 currently a one-to-one correspondence between each course offering and its corresponding section.

Primary PowerSchool Source Data

[Sections]
[Courses]
[Section_Meeting]
[Terms]
[Period]

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.

Resource Output

A separate 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 Class Period resources as contained in the Education Organization and Master Schedule categorys.
Optionally, a Section record may also contain references to one or more programs associated with the course, such as CTE.

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: CourseOfferring, Session, Location, and ClassPeriods.
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	Data Type	Stored in [Table]Field	Req'd
ClassPeriodReference/ClassPeriodIdentity The class period during which the section meets.				R
/schoolId	SchoolId – The school for the class period.	Integer	Derived from: [Sections]SchoolID Note: [Sections]WhereTaught is not currently implemented in Ed-Fi; [Sections]SchoolID is currently used in all cases	R
/name	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]Name If blank, then [Period]Period_Number	R
CourseOfferingReference/CourseOfferingIdentity The course offering taught in the section.				R
/schoolId	SchoolId – The school offering the course; must match SchoolId in corresponding CourseOffering.	Integer	Derived from: [Sections]SchoolID Note: [Sections]WhereTaught is not currently implemented in Ed-Fi; [Sections]SchoolID is currently used in all cases	R
/termDescriptor	The name of the term in which the section is offered, for example, Fall Semester, Spring Semester; must match Term in corresponding CourseOffering.	Descriptor	Derived from: [Terms]Portion [Terms]Abbreviation	R
/schoolYearType	The identifier for the school year, for example, 2010-2011; must match SchoolYear in corresponding CourseOffering.	Type	[Terms]YearID	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; must match LocalCourseCode in corresponding CourseOffering.	String	[Courses]Course_Number Internal spaces in the course number are replaced with an underscore, and leading /trailing spaces are removed.	R
LocationReference/LocationIdentity The location, typically a classroom, where the section meets.				R
/schoolID	SchoolId – The school for the section's classroom.	Integer	Derived from: [Sections]SchoolID Note: [Sections]WhereTaught is not currently implemented in Ed-Fi; [Sections]SchoolID is currently used in all cases	R
/classroomIdentificationCode	A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity.	String	[Sections]Room If blank, then 'Open'	R
schoolID	SchoolId – The school associated with the session.	Integer	Derived from: [Section]SchoolID	R
uniqueSectionCode	A unique identifier for the section that is defined by the classroom, the subjects taught, and the instructors that are assigned.	String	[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
availableCredits	Credits or units of value awarded for the completion of a course.	Number	[Courses]Credit_Hours	O
mediumOfInstruction	The media through which teachers provide instruction to students, and the media through with students and teachers communicate about instructional matters.	String	if [S_MI_SEC_TSDL_X]VirtualDelivery = 1 : 'Virtual/On-line Distance learning' is published OC: 'Virtual/On-line Distance learning' is published DL: 'Other technology-based instruction' is published BL: 'Technology-based instruction in classroom' is published NV: 'Other' is published	O

Back to top

Bell Schedules

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 Organization Schedules category. The layout includes School Name, Grade Level, Bell Schedule, and Calendar Date.

bellSchedules

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 separate BellSchedule record is published for each unique BellSchedule defined at each school, for each grade level, and for each date that the BellSchedule 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 BellSchedule 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 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	Data Type	Stored in [Table]Field	Req'd
CalendarDateReference/CalendarDateIdentity The calendar dates when the bell schedule is implemented.				R
/schoolId	The school for which the calendar date is defined.	Integer	Derived from: [Calendar_Day]SchoolId	R
/date	The month, day, and year of the calendar date.	Date	[Calendar_Day]Date_Value	R
name	BellScheduleName - Name or title of the bell schedule.	String	[Bell_Schedule]Name	R
gradeLevelDescriptor	The grade levels the particular bell schedule applies to.	Descriptor	Derived from: [Schools]Low_Grade [Schools]High_Grade	R
schoolId	The school for which the bell schedule is defined.	Integer	Derived from: [Bell_Schedule]SchoolId	R
meetingTimes (1-many) The times at which this Bell Schedule is intended to meet.				O
/classPeriodReference/classPeriodIdentity The class period associated with the meeting time for a bell schedule.				R
//schoolId	The school for which the period is defined.	Integer	Derived from: [Period]SchoolId	R
//name	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]Name If blank, then [Period]Period_Number	R
/startTime	An indication of the time of day the class begins.	String	[Bell_Schedule_Items]Start_Time	O
/endTime	An indication of the time of day the class ends.	String	[Bell_Schedule_Items]End_Time	O

Back to top