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 or section, such as CTE.
-
For school years 2025–2026 and later, Work-Based Learning (WBL) program types are published on the sections record from the section's CTE Program field. WBL program types must be reported on the section, not on the studentSectionAssociations resource.
-
The sections resource is dependent on the prior publishing of the following resources: courseOfferings, locations, and classPeriods.
-
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand ("Run Now" button).
Tip: If WISEdata reports validation error 7510, make sure the Work-Based Learning program is set in the CTE Program field on the section. Then republish the sections resource first, then the studentSectionAssociations resource.
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 |
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 the corresponding courseOffering. |
String |
[Courses]Course_Number |
R |
|
/schoolID |
The school offering the course; must match schoolID in the 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, the 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 or Spring Semester; must match Term in the 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 |
A reference to the related school resource. |
|
|
R |
|
/schoolID |
The school in which the section is offered. |
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 |
|
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), or Face-to-face instruction. |
String |
If [S_WI_SEC_CWCS_X]Virtual = 1, then value = 'Virtual/On-line Distance learning'. If [S_WI_SEC_CWCS_X]Virtual is blank or = 0, and [S_WI_SEC_CWCS_X]DistanceEd = '1', then value = 'Distance Learning (other than online)'. Otherwise, value = 'Face-to-face instruction'. |
O |
|
sectionProgram |
A reference to programs to which the section is associated. |
|
|
O |
|
/programReference |
A reference to the related program resource. |
|
|
O |
|
|
The education organization associated with the program. |
Integer |
LEA as downloaded from the state: '48856' |
R |
|
/type |
The type of program, for example, Dual Enrollment, Bilingual, ESL, or Work-Based Learning (WBL). |
String |
Bilingual/ESL: Derived from [S_WI_SEC_CWCS_X]BilingualESL, or if blank, [S_WI_CRS_CWCS_X]BilingualESL. • 1–4, then value = 'Language Instruction Education Program - Bilingual Program' • 5–7, then value = 'Language Instruction Education Program - ESL Program' • 8, then value = 'Language Instruction Education Program - ESL/Bilingual' • 9, then value = 'Integrated EL-Special Education' • 10, then value = 'Newcomer-Bilingual' • 11, then value = 'Newcomer-ESL' Dual Enrollment: Derived from [S_WI_CRS_CWCS_X]DualEnroll, where the value is not 'NA' and is not blank. • Value = 'Dual Enrollment Program' World Language: Derived from [S_WI_CRS_CWCS_X]WorldLanguage, where the value is not 'NA' and is not blank. • Value = 'World Language Program' CE/CTE Program: Derived from [S_WI_SEC_CWCS_X]CTE_Program. For school years 2024–2025 and prior: • 01–09, then value = 'Certified Career Education Program' • 10–14, then value = 'Non Certified Career Education Program' • 15, then value = 'State Endorsed Regional Career Pathway Program' For school years 2025–2026 and later: • 09, 12, 13, 16, 17, or 18, then value = 'WBL' (uri: |
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. • 1, then value = 'Heritage language program or Indigenous language program' • 2, then value = 'Transitional Bilingual Education' • 3, then value = 'Dual Language Immersion' • 4, then value = 'Developmental or Late - Transitional Bilingual Program' • 5, then value = 'No ESL program available' • 6, then value = 'ESL - Integrated or Co-teaching models' • 7, then value = 'ESL - Sheltered Instruction' • 8, then value = 'Content-Based ESL-Bilingual' • 9, then value = 'Integrated EL-Special Education' • 10, then value = 'Newcomer-Bilingual' • 11, then value = 'Newcomer-ESL' Dual Enrollment: Derived from [S_WI_CRS_CWCS_X]DualEnroll, where the value is not 'NA' and is not blank. For school years 2017–2018 and prior, where [S_WI_CRS_CWCS_X]DualEnroll equals: • AS, then value = 'Advanced Standing (AS)' • CCHS, then value = 'College Credit in High School (CCHS)' • CO, then value = 'Course Options (CO)' • TC, then value = 'Transcripted Credit (TC)' • YA, then value = 'Youth Apprenticeship (YA)' • YOPC, then value = 'Youth Options - Private College (YOPC)' • YOTC, then value = 'Youth Options - Technical College (YOTC)' • YOUW, then value = 'Youth Options - UW-System (YOUW)' For school years 2018–2019 and later, where [S_WI_CRS_CWCS_X]DualEnroll equals: • CLGPRIV, then value = 'College Course with Private College' • CLGTECH, then value = 'College Course with Technical College' • CLGTRIB, then value = 'College Course with Tribal College' • CLGUW, then value = 'College Course with UW System' • HSPRIV, then value = 'High School Course with Private College' • HSTECH, then value = 'High School Course with Technical College' • HSTRIB, then value = 'High School Course with Tribal College' • HSUW, then value = 'High School Course with UW System' World Language: Derived from [S_WI_CRS_CWCS_X]WorldLanguage, where the value is not 'NA' and is not blank. • FLES, then value = 'Foreign Language in the Elementary School Programs (FLES)' • FLEX, then value = 'Foreign Language Exploratory Programs (FLEX)' • IMMR, then value = 'Immersion Programs (IMMR)' • WL, then value = 'World Language (WL)' CE/CTE Program: Derived from [S_WI_SEC_CWCS_X]CTE_Program. • 01, then value = 'IRC - Not State Approved' • 02, then value = 'IRC State Approved Business & Industry' • 03, then value = 'IRC State Approved WTCS- Associates' • 04, then value = 'IRC State Approved WTCS- Embedded Technical Diploma' • 05, then value = 'IRC State Approved WTCS- Technical Diploma' • 06, then value = 'State Co-op Ed. Skill Standards - DPI Employability Skills' • 07, then value = 'State Co-op Ed. Skill Standards - DPI Occupational' • 08, then value = 'State Co-op Ed. Skill Standards - DPI Youth Leadership' • 09, then value = 'Youth Apprenticeship' • 10, then value = 'Internship' • 11, then value = 'Local Co-op' • 12, then value = 'School-based Enterprise' • 13, then value = 'Simulation' • 14, then value = 'Supervised occupational experience' • 15, then value = 'State Endorsed Regional Career Pathway Program' • 16, then value = '[confirm with dev]' • 17, then value = '[confirm with dev]' • 18, then value = '[confirm with dev]' For school years 2025–2026 and later, only Work-Based Learning program names (codes 09, 12, 13, 16, 17, and 18) are published. |
R |