Sections

This page lists the course-related resources collected by KSDE are translated into Ed-Fi.

Selection Criteria  

The section is not excluded from state reporting. 
The section is taught during the year for the Term.

Data Review

Field	Selection
Choose Category	Schedules info Summary Schedules info Published Schedules info Dependencies Schedules info Errors
Choose Data view	Statistical Summary Sections

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.	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.
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.
SectionIdentifier	A unique identifier assigned to a specific section of a course	Section Number	Required	Concatenated	SchoolID+[Courses]Course_Number +[Sections]Section_Number +Termdcid
SessionName	The name given to a specific period within the school year, such as "Fall Semester" or "Spring Term.	Session Name	Required	Concatenated	school.schoolnumber+ Terms.abbreviation + Terms.dcid Format: schoolid \|\| '-' \|\| terms.abbreviation \|\| '-' \|\| termdcid;