Course Offerings

This view lists 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 rereporting
The course is offered during the year of the Term selected on PowerSchool.

Data Review

Field	Selection
Choose Category	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	Description	Data View Column	Submission	[Table] Field Name	Business Rules
LocalCourseCode	A unique identifier assigned to a course by the local education agency.	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	A unique identifier assigned to a school within the district.	School Number	Required	[Schools]SIF_StatePRID Derived From [Sections]SchoolId	School Identifier format: ttdddbbbb If [Schools]SIF_StatePRID is blank, [Sections]School_Id is pulled. The [Schools]SIF_StatePRID or [Sections]School_Id must match with the Organization Catalog. 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	A standardized code used to identify a course across different schools and districts.	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	A unique identifier assigned to an educational organization, such as a school or district.	Edg ID	Required	Not Applicable	Default to 100000000
SchoolYear	The academic year for which data is being reported, typically spanning from fall of one year to summer of the next.	Year	Required	Calculated using [TERMS]YearID	If 2023-2024, then extract 2024
SessionName	The name given to a specific period within the school year, such as "Fall Semester" or "Spring Term."	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	The number of credits awarded for completing the course.	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	The order in which courses are taken within a program or curriculum	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	The total number of courses in the sequence for a particular program or curriculum.	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	Describes the method of course delivery, such as "Online," "In-Person," or "Hybrid."	Not available	Optional	[S_KS_CRS_X]Delivery_Type	Not applicable.
Extension.CourseProgramTypeDescript	Indicates the type of program associated with the course, such as "Advanced Placement," "Career and Technical Education," or "Special Education.	Not available	Optional	[S_KS_CRS_X]Target_Program	Not applicable.
Extension. CollegeCareerTypeDescript	Describes the college or career readiness aspect of the course, such as "Dual Enrollment" or "Work-Based Learning	Not available	Optional	[S_KS_CRS_X]College_Career_Credits	Not applicable.
CourseLevelCharacteristicDescript	Describes characteristics of the course level, such as "Honors," "Remedial," or "Standard."	Course Level	Required	[S_KS_CRS_X]Course_Level	Not applicable.
GradeLevelDescript	A code or label that specifies the grade level associated with the course, such as "Kindergarten," "Grade 1," or "Grade 12.	Grade	Required	[S_KS_CRS_X]KCC_Grade_Level	Not applicable.