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 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 | ||||
/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). Class Period Descriptor 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) Class Type Descriptor set 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 |