Tool Search: Course Codes Extract
The Course Codes Extract reports all courses for the selected calendar for the purpose of having the courses available in the Kansas Course Code Management System. This provides standardization within other Kansas school districts and at a national level, allowing student transcripts to be more easily reviewed for appropriate content.
Course Codes Extract
Read - Access and generate the Course Codes Extract.
Write - N/A
Add - N/A
Delete - N/A
For more information about Tool Rights and how they function, see the Tool Rights article.
Report Logic
All courses - both active and inactive - included in the selected calendar are included unless:
- The course is marked as Exclude from State Reporting.
- An ad hoc filter is selected that limits the inclusion of a course (e.g., when the filter is only reporting math courses).
One unique record per course is extracted.
Districts need to establish Local Subject Area Codes prior to creating this file. That Subject Area Code is then assigned to the course.
Grade Levels are mapped to a State Code and report a Code Mapping value. See the table below for what State Grade Level value reports which Code Mapping value. This applies to the Current Grade Level field.
Report Editor
The following fields are available for selection on the Course Codes Report.
Field | Description |
|---|---|
Effective Date | Entered date is used to return course information as of this date. This field auto-populates with the current date but it can be modified by typing a new date in mmddyy format or by using the calendar icon to select a date. |
| Start Date Override | Entered date is used as an override for the course start date. When populated, this date reports for ALL courses included in the extract as the Effective Date. |
| Expiration Date Override | Entered date is used as an override for the Expiration Date field in report layout. When populated, the Expiration Date field reports the entered date. |
Ad hoc Filter | When selected, only course information included in the selected filter returns. Filters are built using the Ad hoc Filter Designer Query Wizard with a Course/Section Data Type. |
Format | Selection determines how the report generates. Use the State Format when submitting information to the state. Use the other formats for data review and testing prior to submitting information to the state. Options are:
|
Calendar | Selection indicates from which calendar course data reports. When a school is selected in the Campus toolbar, that calendar is automatically selected. At least one calendar needs to be selected in order for the report to generate. Calendars can be viewed by the Active Year, by the School Name or by Year. |
Generate the Course Codes Extract
- Enter an Effective Date.
- If desired, enter a Start Date Override.
- If desired, enter an Expiration Date Override.
- If desired, select an Ad hoc Filter from the dropdown list.
- Select the desired Format from the dropdown list.
- Select the Calendar(s) from which to pull data.
- Click the Generate Report button. The extract displays in a new browser window.
Course Codes Extract - State Format (Tab Delimited)
Course Codes Extract - Pipe Delimited Format
Course Codes Extract - HTML Format
Course Codes Extract - CSV Format
Report Layout
Data Element | Description | Location |
|---|---|---|
District ID | Reports the state-assigned district number Numeric, 5 digits | District Information > State District Number District.number |
Local Subject Area | Reports the description of district-assigned course subject area code. Alphanumeric, 100 characters | Course > Custom Data Elements > Local Subject Area Code Course.localSubjectArea |
Local Subject Area Code | Reports the code of the district-assigned course subject area code. Alphanumeric, 2 characters | Course > Custom Data Elements > Local Subject Area Code Course.localSubjectArea |
Local Course Identifier | Reports the District-assigned course number. Alphanumeric, 20 characters | Course > Number Course.number |
Local Course Title | Reports the District-assigned name of the course. Alphanumeric, 100 characters | Course > Name Course.name |
Local Course Descriptor | Lists the Course Description entered on the Course Information editor, providing a summary of the course and what the students are taught and perhaps identifying curriculum. Alphanumeric, 2000 characters | Course > Description Course.description |
Course Level | Indicates the academic rigor of the course. Options are:
Alphanumeric, 1 character | Course > Course Level Course.level |
Credits | Reports the calculated number of credits from the grading task. Any value over 9.99 reports as 9.99. Numeric, 3 digits (X.XX) | Calculated value, data not stored Course > Grading Tasks |
Sequence | Reports the total number of courses in a sequence of courses. For example, a Wood Shop course may have two parts and the first part taken is Sequence 1, and a Sequence Total of 2. Numeric, 1 character | Course > Sequence Total Course.sequence |
Grade Level | Reports the state grade level for which the class is taught. Alphanumeric, 2 characters | Calendar Information > Grade Level Calendar.grade |
Targeted Program | Reports the targeted program identifier. Options are:
Alphanumeric, 1 character | Course > Targeted Program Course.targetedProgram |
Delivery Type | Indicates how the curriculum was delivered to the student. Options are:
Alphanumeric, 1 character | Course > Delivery Type Course.deliveryType |
College/Career Type | Reports the College/Career Type. Options are:
Alphanumeric, 1 character | Course > College/Career Type Course.careerCollege |
KSDE Use Only | This field reports blank. | N/A |
State Subject Area Code | Reports the State Subject Area Code. Numeric, 2 digits | Course Subject Area Course.subjectAreaCode |
State Course Identifier | Reports the last three digits from the State Code. Numeric, 3 digits | Course > State Code Course.stateCode |
Effective Date | Reports the start date of the course.
Date field, 10 characters (MM/DD/YYYY) | Data not stored |
Expiration Date | When the Expiration Date Override field is populated on the report editor, reports the entered value for all courses in the extract. When the Active checkbox on the course is not marked, reports the end date of the course. When there is no end date, a value of 06/30/YYYY reports, where YYYY is the end year of the selected calendar. When the Active checkbox on the course is marked, this field reports blank. Date field, 10 characters (MM/DD/YYYY) | Data not stored |
