Resource Overview
-
Ed-Fi endpoint:
/data/v3/courseOfferings -
Published view/entity: Course Offering
-
Purpose: The courses available to students in each school
-
Source query:
CourseOffering -
Dependencies:
sessions
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]
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.
-
At least one section of the course must not be excluded from state reporting ("State_ExcludeFromReporting").
-
The course is offered during the year for the Term selected in the PowerSchool UI.
-
The course must have a valid state course code.
Note: The system considers the first six characters of either an alternate course number or course number for matching with downloaded course data from the state. Districts must ensure alignment with state specifications to ensure that valid courses are published.
Resource Output
|
Data Element (Ed-Fi target) |
Data View Column Name |
Submission |
[Table]Field (PowerSchool Source) |
Business Rules |
Comments |
|---|---|---|---|---|---|
|
courseReference.educationOrganizationId |
CourseOrgID |
Y |
Staging rule: CourseOfferings '47' |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: CourseOrgID. |
|
courseReference.courseCode |
CourseCode |
Y |
[cst_pubcourse]Code |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: CourseCode. |
|
schoolReference.schoolId |
SchoolOrgID |
Y |
Publishing framework or supporting query Query alias: SchoolOrgID |
Required by the production resource definition when the resource is published. |
JSON type: number. Query alias: SchoolOrgID. |
|
sessionReference.schoolId |
SchoolOrgID |
Y |
Publishing framework or supporting query Query alias: SchoolOrgID |
Required by the production resource definition when the resource is published. |
JSON type: number. Query alias: SchoolOrgID. |
|
sessionReference.schoolYear |
SchoolYear |
Y |
Staging rule: CourseOfferings p_yearid + 1991 |
Required by the production resource definition when the resource is published. |
JSON type: number. Query alias: SchoolYear. |
|
sessionReference.sessionName |
SessionName |
Y |
[CST_PUBPUBLISHED_TMP]RUNTIMEPROP_4 |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: SessionName. |
|
localCourseCode |
LocalCourseCode |
Y |
[Courses]DCID; [Courses]Course_Number; [Sections]DCID; [Sections]ID; [Sections]Section_Number; Transformation: EDFI_TN_LIB.formaLocalCourseCode(p_profileid, crs.dcid, crs.course_number, p_yearid, sec.dcid, sec.id, sec.section_number) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: LocalCourseCode. |
|
localCourseTitle |
LocalCourseTitle |
Y |
[Courses]Course_Name |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: LocalCourseTitle. |
|
instructionalTimePlanned |
InstructionalTimePlanned |
Conditional |
[Sections]ID |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: InstructionalTimePlanned. |