Organization Schedules
This category captures organization course and section 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 courseOfferings resource within the Organization Schedules category. The layout includes the School Name, Course Name, Course Number, Term, Last Publish Date, Publishing ID, and Resource ID.
courseOfferings
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.
The course is offered during the year for the Term selected in the PowerSchool UI.
The term and state term should match with course and sections and the sections must have one or more enrollments.
Resource Output
A separate courseOffering record is published for each unique combination of course, section, and term scheduled at each school based on the year for the Term selected in the PowerSchool UI.
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).
The Organization Schedules category that includes the Course Offerings and Sections resources is now enabled for publishing. You should complete the Download Data process for the State Courses category before attempting to publish this data.
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
courseReference A reference to the related courses resource. | R | |||
/educationOrganizationID | The Education Organization that defines the curriculum and courses offered. This organization identifier matches the educationOrganizationID in the courses resource. | Integer | Derived from: If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: | R |
/code | The course being offered by the school. | String | [Courses]Course_Number | R |
schoolReference A reference to the related schools resource. | ||||
/schoolID | The school that offers the course. | Integer | Derived from: [Courses]SchoolID | R |
sessionReference A reference to the related sessions resource. | ||||
/schoolID | The school for the session resource. | Integer | Derived from: [Terms]SchoolID | R |
/schoolYear | The identifier for the school year. | Integer | [Terms]YearID | R |
/termDescriptor | The term type of the session. | Descriptor | Derived from: [Terms]Portion [Terms]Abbreviation | |
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 | 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 |
Sections
This view captures the course sections offered at each school as published in the sections resource of the Organization Schedules category. The layout includes School Name, Course Name, Course Number, Section Number, Term, Period Number, Last Publish Date, Publishing ID, and Resource ID.
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]
[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.
The term and state term should match with course and sections and the sections must have one or more enrollments.
Resource Output
A separate sections 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 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 | Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
classPeriodReference A reference to the related classPeriod resource. | R | |||
/schoolID | The school for the class period. | Integer | Derived from: [Sections]SchoolID | 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 | Derived from: [Period]Abbreviation [Period]Period_Name | R |
courseOfferingReference A reference to the related courseOffering resource. | R | |||
/schoolID | The school offering the course. | Integer | Derived from: [Courses]SchoolID | 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 |
/schoolYear | 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 | R |
locationReference A reference to the related locations resource. | R | |||
/schoolID | The school for the section's classroom. | Integer | Derived from: [Sections]SchoolID | 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 | R |
schoolReference A reference to the related schools resource. | R | |||
/schoolId | The school associated with the session. | Integer | [Schools]Alternate_School_Number, if greater than 0 Otherwise: [Schools]School_Number | R |
uniqueSectionCode | A unique identifier for the section that is defined by the classroom, the subjects taught, and the instructors that are assigned. | String | Derived from: [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 | '1' | R |
availableCredits | Credits or units of value awarded for the completion of a course. | String | [Courses]Credit_Hours | O |