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.
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 school must have a WISEdata Reporting option.
- 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.
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 | LEA as downloaded from the state: '48856' | R |
/code | The course being offered by the school. This is the state courseCode in the downloaded Course entity. | String | Data element downloaded from State [CST_PubCourse]Code Must match [S_WI_CRS_RSTR_X]Course_Code if entered. Otherwise [S_WI_CRS_CWCS_X]CourseCode must match downloaded CWCS Course Code, stored in [CST_PubCourse]AlternateCode | R |
| schoolReference A reference to the related School resource. | R | |||
/schoolID | The school that offers the course. | Integer | SchoolId downloaded from State Derived from: [S_WI_SCH_X]EdFi_StateSchoolNumber, or if this field is blank then [Schools]Alternate_School_Number] if greater than 0 Otherwise, [Schools]School_Number | R |
sessionReference A reference to the related Session resource. | R | |||
/schoolID | The school for the session resource. | Integer | SchoolId downloaded from State Derived from: [S_WI_SCH_X]EdFi_StateSchoolNumber, or if this field is blank then [Schools]Alternate_School_Number] if greater than 0 Otherwise, [Schools]School_Number | R |
/schoolYear | The identifier for the school year. | Integer | [Terms]YearID | R |
/termDescriptor | The term type of the session. | String | Derived from: [Terms]Portion [Terms]Abbreviation | 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 | R |
| localCourseTitle | The descriptive name given to a course of study offered in the school, if different from the course title. | String | [Courses]Course_Name | O |
careerPathways An array containing additional CTE details for courses offered. | O | |||
/careerPathwayTypes | The career cluster or pathway representing the career path of the Vocational/Career Tech concentrator. | String | Downloaded from state [CST_PubCourse]CareerPathType | 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 school must have a WISEdata Reporting option.
- 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 |
|---|---|---|---|---|
classPeriodReference A reference to the related ClassPeriod resource. | R | |||
/schoolID | The school for the class period. | Integer | SchoolId downloaded from State Derived from: [S_WI_SCH_X]EdFi_StateSchoolNumber, or if this field is blank then [Schools]Alternate_School_Number] if greater than 0 Otherwise, [Schools]School_Number | 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 | [Period]Name | R |
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 | [Courses]Course_Number | R |
/schoolID | The school offering the course; must match SchoolID in corresponding courseOffering. | Integer | SchoolId downloaded from State Derived from: [S_WI_SCH_X]EdFi_StateSchoolNumber, or if this field is blank then [Schools]Alternate_School_Number] if greater than 0 Otherwise, [Schools]School_Number | 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. | Integer | [Terms]YearID | 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. | String | Derived from: [Terms]Portion [Terms]Abbreviation | R |
locationReference A reference to the related Location resource. | R | |||
/schoolID | The school for the section's classroom. | Integer | SchoolId downloaded from State Derived from: [S_WI_SCH_X]EdFi_StateSchoolNumber, or if this field is blank then [Schools]Alternate_School_Number] if greater than 0 Otherwise, [Schools]School_Number | 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 | R | |||
/schoolID | The school associated with the session. | Integer | SchoolId downloaded from State Derived from: [S_WI_SCH_X]EdFi_StateSchoolNumber, or if this field is blank then [Schools]Alternate_School_Number] if greater than 0 Otherwise, [Schools]School_Number | |
| 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: State SchoolID + "-" + [Sections]DCID | R |
| sequenceOfCourse | When a Section is part of a sequence of parts for a course, the number of the sequence. If the course has only one part, the value of this Section attribute is 1. | Integer | '1' | R |
| mediumOfInstructionType | The media through which teachers provide instruction to students and students and teachers communicate about instructional matters; for example: Virtual/On-line Distance learning, Distance Learning (other than online), Face-to-face instruction. | String | if [S_WI_SEC_CWCS_X]Virtual = 1, value = 'Virtual/On-line Distance learning' if [S_WI_SEC_CWCS_X]Virtual is blank or = 0 then if [ S_WI_SEC_CWCS_X]DistanceEd = '1', value = 'Distance Learning (other than online)' Otherwise" 'Face-to-Face instruction' | O |
sectionProgram A reference to programs to which the section is associated. | O | |||
/programReference | O | |||
//educationOrganizationID | The education organization associated with the program. | String | LEA as downloaded from the state: '48856' | R |
//type | The type of program. For example, Dual Enrollment, Bilingual, ESL. | String | Bilingual/ESL - derived from [S_WI_SEC_CWCS_X]BilingualESL, or if blank [S_WI_CRS_CWCS_X]BilingualESL
Dual Enrollment - derived from [S_WI_CRS_CWCS_X]DualEnroll, where value <> 'NA' and is not blank
World Language - derived from [S_WI_CRS_CWCS_X]WorldLanguage, where value <> 'NA' and is not blank
CE/CTE Program - Derived from [S_WI_SEC_CWCS_X]CTE_Program
| R |
//name | The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies. | String | Bilingual/ESL - derived from [S_WI_SEC_CWCS_X]BilingualESL, or if blank [S_WI_CRS_CWCS_X]BilingualESL
Dual Enrollment - derived from [S_WI_CRS_CWCS_X]DualEnroll, where value <> 'NA' and is not blank For school years 2017-2018 and prior
For school years 2018-2019 and later Where [S_WI_CRS_CWCS_X]DualEnroll equals
World Language - derived from [S_WI_CRS_CWCS_X]WorldLanguage, where value <> 'NA' and is not blank
CE/CTE Program - Derived from [S_WI_SEC_CWCS_X]CTE_Program
| R |