Organization Schedules

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

Note: Organization Schedules resources are only published for public schools. In addition, Course Offering and Section resources will now publish records only if there are enrolled students.

Course Offerings

This data view represents an entry in the course catalog of available courses offered by the school during a session (term). The published view layout includes the School Name, Course Name, Course Number, State Status, Valid Codes, Roster Code, CWCS Code, SCED5 Code, Term, Last Publish Date, and Publishing ID.

Notes:

The State Status field identifies if the district course is active, or if the district course has been deprecated or replaced by the state.
The Valid Values field displays the following:
- 'None' is displayed for deprecated courses.
- Otherwise, RosterCode + ’/’ + SCED 5 code (or CWCS code if SCED 5 code not defined in State Download) is displayed.
  - For replaced courses, update your course codes on the Courses page to the new state codes.
  - For deprecated courses, update your course codes on the Courses page by locating the new state course that approximately matches the content of the district course.

courseOfferings

Primary PowerSchool Source Data

[Courses]
[Terms]
[Sections]

Selection Criteria

Records are published if the following criteria are met:

The school must not be excluded from state reporting.\
The school must have an Ed-Fi State School number.
The course is offered during the year for the Term selected in the PowerSchool UI.
Prior to the 2018-19 school year, the course must have a valid Roster Code or CWCS Code.
For the 2018-19 school year, the course must have a valid Roster Code, CWCS Code, or SCED 5 Code.
After the 2018-19 school year, the course must have a valid Roster Code or SCED 5 Code.
Note: Some Roster codes are being replaced or deprecated starting in the 2018-19 school year. These codes will still be accepted during the year, but will not be accepted after 2018-19.

Resource Output

A separate courseOfferings record is published for each unique combination of course and term scheduled at each school.
Note: In PowerSchool, courseOfferings records are derived from section, course, and term records. A single courseOfferings record is published for all sections of a course offered during the same term.
The courseOfferings resource is not dependent on the prior publishing of other 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.

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Element	Description	[Table]Data Type	Stored in [Table]Field	Req’d
courseReference A reference to the related Course resource.				R
/educationOrganizationID	The Education Organization that defines the curriculum and courses offered - often the LEA or school.	Integer	[CourseOfferings]CourseOrgID	R
/code	The course being offered by the school. This is the state courseCode in the downloaded Course entity.	String	[CourseOfferings]CourseCode	R
schoolReference A reference to the related School resource.				R
/schoolID	The school that offers the course.	Integer	[StudentSpecialEducationAssociationEvents]SchoolOrgID	R
sessionReference A reference to the related Session resource.				R
/schoolID	The school for the session resource.	String	[StudentSpecialEducationAssociationEvents]SchoolOrgID	R
/schoolYear	The identifier for the school year.	Number	[CourseTranscripts]SchoolYear	R
/sessionName	The name of the session.	String	studentSchoolAttendanceEvents]SessionName	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. Note: The local course codes that start with 00 are linked to the state course of 00 and published.	String	[CourseTranscripts]LocalCourseCode	R
/localCourseTitle	The descriptive name given to a course of study offered in the school, if different from the course title.	String	[staffSectionAssociations]localCourseTitle	O

Sections

This data view 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. The published view layout includes the School Name, Course Name, Course Number, Section Number, Term, Period Number, Last Publish Date, and Publishing ID.

sections

Primary PowerSchool Source Data

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

Selection Criteria

Records are published if the following criteria are met:

The school must not be excluded from state reporting.
The school must have an Ed-Fi State School number.
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 sections record is published for each unique combination of school, course, and section.
Optionally, a sections record may also contain references to one or more programs associated with the course, such as CTE.
The sections resource is dependent on the prior publishing of the following resources: courseOffering, 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	[Table]Data Type	Stored in [Table]Field	Req’d
courseOfferingReference A reference to the related CourseOffering resource.				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; must match localCourseCode in corresponding courseOffering.	String	[CourseTranscripts]LocalCourseCode	R
/schoolID	The school offering the course; must match SchoolID in corresponding courseOffering.	String	[StudentSpecialEducationAssociationEvents]SchoolOrgID	R
/schoolYear	The identifier for the school year, recorded as the later calendar year of the school year. For example, 2017-2018 school year is recorded as 2018.	Number	[CourseTranscripts]SchoolYear	R
/sessionName	The name of the session.	String	[StudentSchoolAttendanceEvents]SessionName	R
/sectionIdentifier	The Id of the section.	String	[staffSectionAssociations]UniqueSectionCode
/availableCredits		Number	[Sections]AvailableCredits
/sectionName	The name of the section.	String	[CourseTranscripts]SectionNumber
/instructionLanguageDescriptor		String	[Sections]InstructLang_DX
characteristics
sectionCharacteristicDescriptor		String	[Sections]OnlineCourse_DX
/schoolID	The school for the class period.	Integer
/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	[SectionClassPeriods]PeriodName
alternateEducationOrganizationID	Indicates the SSN of the teacher at the section level if the Override Teacher SSN field is specified on the section's page. Note: If the Override Teacher SSN field is changed at the course or section level, then the course and section resources will generate the necessary DCF events to automatically publish the resources with the updated value. Similarly, if the Immersion Language or PSO Institution Code fields are changed at the section level, then the course and section resources will generate the necessary DCF events to automatically publish the resources with the updated value.	Number	[Sections]AltSysCode
classPeriodNumber	A single digit code to indicate the period number. This will be two digits and to achieve that a 0 will be padded to the period number.	String	[Sections]PeriodNumber