Course Codes Extract (Kansas)

Classic View: KS State Reporting > Course Codes Extract

Search TermsCourse 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:

  • State Format (Tab Delimited)
  • Pipe Delimited
  • CSV
  • XML
  • HTML

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

  1. Enter an Effective Date.
  2. If desired, enter a Start Date Override. 
  3. If desired, enter an Expiration Date Override.
  4. If desired, select an Ad hoc Filter from the dropdown list.
  5. Select the desired Format from the dropdown list.
  6. Select the Calendar(s) from which to pull data.
  7. 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.
LocalSubjectArea

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.
LocalSubjectArea

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:

  • B - Basic/Remedial
  • G - General (default value)
  • E - Enriched/Advanced
  • H - Honors
  • X - no specified level of rigor

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

X.XX

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.
sequence

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:

  • S - Special Ed
  • E - ESOL
  • G - General (default value)
  • M - Migrant
  • A - At Risk

Alphanumeric, 1 character

CustomCourse.
targetedProgram

Scheduling > Courses > Course > Targeted Program

Delivery Type

Indicates how the curriculum was delivered to the student. Options are:

  • V - Virtual
  • D - Distance
  • G - General (default value)
  • M - Self-contained Multi
  • S - Self-contained Single

Alphanumeric, 1 character

CustomCourse.
deliveryType

Scheduling > Courses > Course > Delivery Type

College/Career Type

Reports the College/Career Type. Options are:

  • N: Not dual credit (Default Value)
  • D: Dual credit
  • F: CTE credit funded in an approved program
  • X: CTE credit not funded in an approved program
  • C: CTE approved program/college cred
  • L: CTE not funded in approved program/college cred
  • E: CTE Explore course not funded in approved program

Alphanumeric, 1 character

CustomCourse.
careerCollege

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
AreaCode

Scheduling > Courses > Course Subject Area

State Course Identifier

Reports the last three digits from the State Code.

Numeric, 3 digits

Course.state
Code

Scheduling > Courses > Course > State Code

Effective Date 

Reports the start date of the course.

  • If the Start Date Override field is populated on the Extract editor, that value reports for ALL courses included in the extract.
  • If the Start Date field on the Course is populated, that value reports.
  • If there is not a start date for the course, a date of 07/01/YYYY reports, where YYYY is the starting year of the selected calendar.

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