Classic View: KS State Reporting > Course Codes Extract
Search Terms: 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 Editor
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., if 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.
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 will be returned. Filters are built using the Ad hoc Filter Designer Query Wizard with a Course/Section Data Type. |
Format | Selection determines how the report will generate. 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. If a school is selected in the Campus toolbar, that calendar will be auto-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
Course Codes Extract, HTML Format
Course Codes Extract, CSV Format
Report Layout
Data Element | Description | Type, Format and Length | Campus Database | Campus Interface |
|---|---|---|---|---|
District ID | Reports the state-assigned district number | Numeric, 5 digits | District.number | System Administration > Resources > District Information > State District Number |
Local Subject Area | Reports the description of district-assigned course subject area code. | Alphanumeric, 100 characters | CustomCourse. | Scheduling > Courses > Course > Custom Data Elements > Local Subject Area Code |
Local Subject Area Code | Reports the code of the district-assigned course subject area code. | Alphanumeric, 2 characters | CustomCourse. | Scheduling > Courses > Course > Custom Data Elements > Local Subject Area Code |
Local Course Identifier | District-assigned course number. | Alphanumeric, 20 characters | Course.number | Scheduling > Course > Course > Number |
Local Course Title | District-assigned name of the course. | Alphanumeric, 100 characters | Course.name | Scheduling > Courses > Course > Name |
Local Course Descriptor | Text entry on the course editor's Description field, providing a summary of the course and what the students are taught and perhaps identifying curriculum. | Alphanumeric, 2000 characters | Course.description | Scheduling > Courses > Course > Description |
Course Level | Indicates the academic rigor of the course. Options are:
| Alphanumeric, 1 character | Course.level | Scheduling > Courses > Course > 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 | Calculated | Scheduling > Courses > Course > Grade Tasks |
Sequence | 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 | CustomCourse. | Scheduling > Courses > Course > Sequence Total |
Grade Level | State grade level for which the class is taught. | Alphanumeric, 2 characters | Calendar.grade | System Administration > Calendar > Calendar > Grade Level |
Targeted Program | Reports the targeted program identifier. Options are:
| Alphanumeric, 1 character | CustomCourse. | Scheduling > Courses > Course > Targeted Program |
Delivery Type | Indicates how the curriculum was delivered to the student. Options are:
| Alphanumeric, 1 character | CustomCourse. | Scheduling > Courses > Course > Delivery Type |
College/Career Type | Reports the College/Career Type. Options are:
| Alphanumeric, 1 character | CustomCourse. | Scheduling > Courses > Course > College/Career Type |
KSDE Use Only | This field reports blank. | N/A | N/A | N/A |
State Subject Area Code | Reports the State Subject Area Code. | Numeric, 2 digits | Course.subject | Scheduling > Courses > Course Subject Area |
State Course Identifier | Reports the last three digits from the State Code. | Numeric, 3 digits | Course.state | Scheduling > Courses > Course > State Code |
Effective Date | Reports the start date of the course.
| Date field, 10 characters MM/DD/YYYY | Data not stored | Data not stored |
Expiration Date | When the Expiration Date Override field is populated on the report editor, the entered value reports for all courses in the extract. When the Active checkbox on the course is not marked, the end date of the course reports. If 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 | Dat a not stored |
