Course Offerings

This infmation describes how all the course-related resources collected by KSDE are translated into Ed-Fi. This section lists fields collected as part of the TASC and KCAN KIDS collections.

CourseOfferings

Selection Criteria

Course and Section not excluded from state repting.
The course is offered during the year f the Term selected on PowerSchool.

Resource Input

Field	SelectioOptional
Choose Categy	Schedules info Summary Schedules info Published Schedules info Dependencies Schedules info Errors
Choose Data View	Statistical Summary Course Offerings

Resource Output

LEAs and Schools may upload (publish) data to the ODS in real time on-demand ("Run Now" button).

Note:

Click Export to export the data collection results to an Excel spreadsheet.
See the Data Publishing > Published Resource > Resource Details to view the data elements that are not available in the Data View Column.

Ed-Fi Data Element	Data View Column	Submission	[Table] Field Name	Business Rules
LocalCourseCode	Local Course ID / Course Number	Required	[S_KS_CRS_X] LocalCourseId [Courses]Course_Number	If [S_KS_CRS_X] LocalCourseId is blank, then extract from [Courses]Course_Number
SchoolId	School Number	Required	Derived From [Sections]SchoolId	School Identifier format: ttdddbbbb Org Id is defaulted to D=14, if district needs another value to be published then district must append alphabet in their district number as per KSDE educationOrganizationID. The course is published based on sections created at the school and it uses the Section School Id
CourseCode	State Course Code	Required	Concatenated [S_KS_CRS_X]State_Subject_Area [S_KS_CRS_X]State_Course_ID	Submit the combination of State Subject Area Code and State Course Identifier value f the state-level course in KCCMS.
EducationganizationId	Edg ID	Required	Not Applicable	Default to 100000000
SchoolYear	Year	Required	Calculated using [TERMS]YearID	If 2023-2024, then extract 2024
SessionName	Session Name	Required	Concatenated [TERMS]YearID [Terms]Name	School Year Term Name If 2023-2024, then extract 2024 Session name is a string that represents any of these time periods: ● Yearlong: 2024 School Year representing 2023-24 School Year ● Semester/Trimester: 2024 First Semester representing 2023-24 First Semester ● Quarter: 2024 Quarter 4 representing 2023-24 Fourth Quarter
Extension.CourseCredits	Not available	Optional	[S_KS_CRS_X]Course_Credit_Hours_Ovrd [Courses]Credit_Hours	If Course Credit Hours Override is not Null, then extract Course Credit Hours Override Else extract from Credit Hours
Extension.CourseSequence	Not available	Optional	[S_KS_SEC_X]Seq_Override [S_KS_CRS_X]Course_Sequence	If Section.Sequence (Override) is not 0 null, then extract Section.Sequence (Override) Else extract from Sequence
Extension.TotalCourseSequence	Not available	Optional	[S_KS_SEC_X]Seq_Total_Override [S_KS_CRS_X]Sequence_Total	If Section.Sequence_Total (Override) is not 0 null, then extract Section.Sequence_Total (Override) Else extract from Sequence Total.
Extension.CourseDeliveryTypeDescript	Not available	Optional	[S_KS_CRS_X]Delivery_Type	Not applicable.
Extension.CourseProgramTypeDescript	Not available	Optional	[S_KS_CRS_X]Target_Program	Not applicable.
Extension. CollegeCareerTypeDescript	Not available	Optional	[S_KS_CRS_X]College_Career_Credits	Not applicable.
CourseLevelCharacteristicDescript	Course Level	Required	[S_KS_CRS_X]Course_Level	Not applicable.
GradeLevelDescript	Grade	Required	[S_KS_CRS_X]KCC_Grade_Level	Not applicable.