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.

Note: The course and section data will not be published in Ed-Fi if the course or section is set to be Excluded from State Reporting.

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]
[COURSESCOREFIELDS]

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 full-year term selected at the top of the page (current reporting year).
The course/section is not excluded from state reporting.
- S_NM_CRS_X.State_ExcludeFromReporting
- S_NM_SEC_X.StateReportingExclusion_YN

Resource Output

A separate Course Offering record is published for each unique combination of course, section, 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 resource: Sessions
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Data Element	Description	Data Type	Stored in [Table]Field	Req'd
courseReference
/courseCode	The 4-digit (PED) course code being offered by the school.	String	[COURSESCOREFIELDS]alt_course_number [COURSES]course_number Note: The field the logic pulls from depends on how the State Course Code Field is set on the District Info page. If the saved value (in either field) is greater than 4 digits in length, the first 4 are published.	R
/educationOrganizationId	Always 35000000	Integer		R
sessionReference
/schoolId	The school associated with this session. This is an eight-digit number comprising of: 35+[LEA Number - 3 digit]+[School Number - 3 digit]	Integer	LEA Number - [Prefs]Value [Prefs]Name where = districtnumber School Number - [Schools]Alternate_School_Number if the value greater is than zero else the [Schools]School_Number	R
/schoolYear	The school year associated with the calendar recorded as the trailing calendar year of the school year. For example, the 2019-2020 school year is published as 2020.	Number	[Terms]YearId	R
/sessionName	The name of the session, comprised of the elements below: Format: [Schools]School_Number - [TERMS]abbreviation - [TERMS]dcid	String	[Schools]School_Number [TERMS]abbreviation [TERMS]dcid	R
schoolReference
/schoolID	The associated school. This is an eight-digit number comprising of: 35+[LEA Number - 3 digit]+[School Number - 3 digit]	Integer	LEA Number - [Prefs]Value [Prefs]Name where = districtnumber School Number - [Schools]Alternate_School_Number if the value greater is than zero else the [Schools]School_Number	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 CoursesCoreFields.Alt_Course_Number Note: The field the logic pulls from depends on how the State Course Code Field is set on the District Info page. The localCourseCode updated logic ensures that the localCourseNumber will now publish correctly for districts that are tracking the State Course Code in the Course Number field. The localCourseCode will come from the field that is not selected in the State Course Code field.
localCourseTitle	The descriptive name given to a course of study offered in the school.	String	[Courses]Course_Name	R

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.

Note: The Sections resource can be published successfully without publishing a Locations reference.

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 full-year term selected at the top of the page (current reporting year).

Resource Output

A separate sections record is published for each unique combination of school, course, and section.
The sections resource is dependent on the prior publishing of the following resources: courseOffering.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand (“Run Now” button).

Data Element	Description	Data Type	Stored in [Table]Field	Req’d
schoolID	The school for the class period.	Integer	Derived from: [Sections]SchoolID	R
sectionIdentifier	Unique identifier of a section. FORMAT: [sec]schoolid - [crs]course_number - [sec]section_number - [sec].dcid	String	Composed of the following: [SECTIONS]schoolid, course_number, section_number, dcid	R
courseOfferingReference A reference to the related courseOffering resource.
/localCourseCode	The code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students. Note: The localCourseCode logic (in the courseOfferings resource) has been updated and the localCourseNumber will now publish correctly for districts that are tracking the StateCourseCode in the Course Number field.	String	[Courses]Course_Number [CoursesCoreFields]Alt_Course_Number	R
/schoolID	The school associated with this location. This is an eight-digit number comprising of: 35+[LEA Number - 3 digit]+[School Number - 3 digit]	String	LEA Number - [Prefs]Value [Prefs]Name where = districtnumber School Number - [Schools]Alternate_School_Number if the value greater is than zero else the [Schools]School_Number	R
/schoolYear	The identifier for the school year.	Number	[Terms]YearID + 1991	R
/sessionname	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. Format: [Terms]schoolid - [Terms]abbreviation - [Terms]dcid	String	Composed of the following: [TERMS]schoolid, [TERMS]abbreviation, [TERMS]dcid	R
/sectionIdentifier	Unique identifier of a section. FORMAT: [sec]schoolid - [crs]course_number - [sec]section_number - [sec].dcid	String	[SECTIONS]schoolid, course_number, section_number, dcid	R
/mediumOfInstructionDescriptor	The PED mandated medium of instruction value. Medium Of Instruction Type Descriptor set Note: The MediumOfInstruction (Course Delivery Model Code) logic has been updated and will consider the value set at the school level if the section and course level values are empty.	String	[S_NM_SCH_X]CourseDeliveryModelCode [S_NM_CRS_X]CourseDeliveryModelCode [S_NM_SEC_X]CourseDeliveryModelCode	O
/CourseLevelCharacteristics
/courseLevelCharacteristicDescriptor	Honors	String	[S_NM_CRS_X]Honors_TF [S_NM_SEC_X]Honors_YN	O
/courseLevelCharacteristicDescriptor	Advanced Placement	String	[S_NM_CRS_X]AP_TF [S_NM_SEC_X]AP_YN	O
/courseLevelCharacteristicDescriptor	Career and Technical Education	String	[S_NM_CRS_X]CarandTech_TF [S_NM_SEC_X]CarandTech_YN	O
/courseLevelCharacteristicDescriptor	Gifted and Talented	String	[S_NM_CRS_X]Gifted_TF [S_NM_SEC_X]Gifted_YN	O
/courseLevelCharacteristicDescriptor	Remedial	String	[S_NM_CRS_X]Remedial_TF [S_NM_SEC_X]Remedial_YN	O
/courseLevelCharacteristicDescriptor	Basic/General	String	[S_NM_CRS_X]Basic_TF [S_NM_SEC_X]Basic_YN	O
/courseLevelCharacteristicDescriptor	Special Education	String	[S_NM_CRS_X]Sped_TF [S_NM_SEC_X]Sped_YN	O
/courseLevelCharacteristicDescriptor	International Baccalaureate	String	[S_NM_CRS_X]IB_TF [S_NM_SEC_X]IB_YN	O
/courseLevelCharacteristicDescriptor	Elective	String	[S_NM_CRS_X]Elect_TF [S_NM_SEC_X]Elect_YN	O
/courseLevelCharacteristicDescriptor	Lab Component	String	[S_NM_CRS_X]LabComp_TF [S_NM_SEC_X]LabComp_YN	O
/courseLevelCharacteristicDescriptor	Advanced	String	[S_NM_CRS_X]Advanced_TF [S_NM_SEC_X]Advanced_YN	O
/programReference A reference to the BEP program if applicable
/educationOrganizationID	The district associated with this program. This is an eight-digit number comprising of: 35+[LEA Number - 3 digit]+000	Integer	LEA Number - [Prefs]Value [Prefs]Name where = districtnumber	C
/programName	Indicates this is a BEP section if the User level field is set to Y. This is published as: BEP - Participation Code 1	String	[S_NM_USR_X]Licensed_BEPFund = Y BEP - Participation Code 1 is published	C
/programTypeDescriptor	Indicates this is a BEP section if the User level field is set to Y. This is published as: BEP ProgramType Descriptor set	String	[S_NM_USR_X]Licensed_BEPFund = Y BEP is published	C
/availableCredits	Credits or units of value awarded for the completion of a course.	Number	[Courses]credit_hours	C
/sequenceOfCourse	If 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.	Number		C
/locationReference A reference to the location of the section.
/schoolID	The school associated with this location. This is an eight-digit number comprising of: 35+[LEA Number - 3 digit]+[School Number - 3 digit]	Integer	LEA Number - [Prefs]Value [Prefs]Name where = districtnumber School Number - [Schools]Alternate_School_Number if the value greater is than zero else the [Schools]School_Number	O
/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	O
/educationalEnvironmentDescriptor	The PED mandated educational environment value. Educational Environment Descriptor set	String	[S_NM_CRS_X]CourseContentCode [S_NM_SEC_X]CourseContentCode	C
/instructionLanguageDescriptor	The PED mandated instructional language value. Language Descriptor set	String	[S_NM_SEC_X]AltInstructionLang	C
/mediumOfInstructionDescriptor	The PED mandated medium of instruction value. Medium Of Instruction Type Descriptor set	String	[S_NM_SCH_X]CourseDeliveryModelCode [S_NM_CRS_X]CourseDeliveryModelCode [S_NM_SEC_X]CourseDeliveryModelCode	R
/nmpedClassPeriodDescriptor	The PED mandated class period code (grades K-12). If a value exists in the "Class Period" field on either the Sections or Course pages, that value will be published (with priority given to the value in Sections [S_NM_SEC_X]ClassPeriod). If "Class Period" is blank on both the Sections and Course pages, the Class Period will be derived based on the portion of the school year that the term represents. Note: The saved field value will publish as the nmpedClassPeriodDescriptor element if it is a valid value from the Class Period Descriptor set.	String	[S_NM_CRS_X]ClassPeriod [S_NM_SEC_X]ClassPeriod	R
/preKClassTypeDescriptor	The PED mandated class period code (Pre-K). If a value exists in the "PreK Class Type" field on either the Sections or Course pages, that value will be published (with priority given to the value in Sections). If "PreK Class Type" is blank on both the Sections and Course pages, this element will not be published. Note: The saved field value will publish as the preKClassTypeDescriptor element if it is a valid value from the Class Type Descriptor set.	String	[S_NM_CRS_X]ClassPeriod [S_NM_SEC_X]ClassPeriod	C