Skip to main content
Skip table of contents

Organization Schedules

This category carries the education course offerings and the related course sections for each school. 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, 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.
  • The course must not be excluded from state reporting ("NE_StateExcludeFromReporting").
  • At least one section of the course must not be excluded from state reporting ("Exclude_State_Rpt_YN").
  • The course must not be excluded from Ed-Fi ([S_NE_CRS_X]ExcludeFromEdFi).
  • The section must not be excluded from Ed-Fi ([S_NE_SEC_X]ExcludeFromEdFi).
  • 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 Organization Schedules 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)

[Sections]Course_Number + '-' + [Sections]DCID

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

schoolReference/schoolIdentity

SchoolId - The school that offers the course.

Integer

SchoolId downloaded from State
Derived from:
[Sections]SchoolID

M

sessionReference/sessionIdentity

M

/schoolReference/schoolIdentity

SchoolId - The school for which the session is defined.

Integer

SchoolId downloaded from State
Derived from:
[Sections]SchoolID

M

/schoolYear

SchoolYearType - The identifier for the school year.

Enumerated List

[Terms]YearID

M

/term

TermType – The term type of the session.

Enumerated List

[Sections]TermID
[Terms]Portion
[Terms]Abbreviation

M

/instructionalTimePlanned

The planned total number of minutes of instructions for this course offering,

Note: The values in the column will be blank for SY less than 22-23.

integerDerived from: [S_NE_CRS_X]Min_Per_Session

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

EducationOrganizationId – The Education Organization that defines the curriculum and courses offered; published as the SEAId.

Integer

SEAId - Data element downloaded from State: '1'

M

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 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]
  • [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 course must not be excluded from state reporting ("NE_StateExcludeFromReporting").
  • The course must not be excluded from Ed-Fi ([S_NE_CRS_X]ExcludeFromEdFi).
  • The section must not be excluded from Ed-Fi ([S_NE_SEC_X]ExcludeFromEdFi).
  • The course must have a valid state course code.
  • The section must not be excluded from state reporting ("Exclude_State_Rpt_YN").
  • The section is taught during the year for the Term selected in the PowerSchool UI.

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 Organization Schedules 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 + '-' + [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

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. This must match localCourseCode in corresponding courseOffering.

Varchar(20)

[Sections]Course_Number + '-' + [Sections]DCID

M

/term

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.

Enumerated List

[Sections]TermID

[Terms]Portion

[Terms]Abbreviation

M

/schoolYear

SchoolYearType - The identifier for the school year, for example, 2010-2011. This must match schoolYear in corresponding courseOffering.

Enumerated List

[Terms]YearID

M

/schoolReference/schoolIdentity

SchoolId – The school offering the course. This must match schoolID in corresponding courseOffering.

Integer

SchoolId downloaded from State

Derived from:

[Sections]SchoolID

Note: [Sections]WhereTaught is not currently implemented in Ed-Fi; [Sections]SchoolID is currently used in all cases

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 entity.

Varchar(20)

[Sections]Room

If blank, default = 'OPEN'

M

/schoolReference/schoolIdentity

SchoolId – The school for the section's classroom.

Integer

SchoolId downloaded from State

Derived from:

[Sections]SchoolID

Note: [Sections]WhereTaught is not currently implemented in Ed-Fi; [Sections]SchoolID is currently used in all cases

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]Abbreviation

If blank:

[Period]Period_Number

M

/schoolReference/schoolIdentity

SchoolId – The school for the class period.

Integer

SchoolId downloaded from State

Derived from:

[Sections]SchoolID

Note: [Sections]WhereTaught is not currently implemented in Ed-Fi; [Sections]SchoolID is currently used in all cases

M

careerAcademy

Indication of whether Career Academy is the section's Course Delivery Model

Boolean

[Sections]NE_CourseDeliveryModel

[S_NE_SEC_X]Course_Delivery_ModelIf value is 3, 4, or 5, 'True' is published; else 'False'

R

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.