Kansas Course Code Export

Introduction

This extract is used to map the local course codes to state course codes. The courses that have been mapped to the district will determine the course information available for the Licensed Personnel Report (LPR) and the Career and Technical Education reporting systems (CaTE).

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records. The report selects all records in the particular table and field entered below.

The course must not be excluded from state reporting.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Use

If run at the district level, choose one of the following from the pop-up menu:

Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria.
Current School Only – Includes all records associated with the current school that meet the selection criteria.
District-Wide – Includes all records on the PowerSchool server that meet the selection criteria.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Output Type

Select the output type for the report:

TAB (excludes column headers)
CSV (includes column headers)

The file format of the Kansas Course Codes Export Report generates a Tab-delimited output file when the TAB (excludes column headers) option is chosen

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Field Ref	Data Element	Description	[Table]FieldName	Max Length
C1	District Identifier	District Number; Ex, D0437.	[Prefs]districtnumber	5
C2	Local Subject Area	Local Subject Area of the course; Math.	[Courses]Sched_CourseSubjectArea_Code	100
C3	Local Subject Area Code	The code assigned to the subject by the local district.	[S_KS_CRS_X]State_Course_ID	2
C4	Local Course Identifier	The districts local course identifier, Example. MATHALG2 (Must be unique)	[Courses]Course_Number	20
C5	Local Course Title	The title designed by the local district for the course. Example: Algebra I or 1234.	[Courses]Course_Name	100
C6	Local Course Descriptor	Description of the course. Note: Do not press the carriage return or have an extra blank line.	[S_KS_CRS_X]Local_Course_Desc	2000
C7	Course Level	Level of the course. Valid values: B = Basic/Remedial G = General E = Enriched H = Honors X = No specified level for rigor	[S_KS_CRS_X]Course_Level	1
C8	Credits	The number of credits a student earns for completing the course. Valid range: 0.00 – 9.99.	[Courses]Credit_Hours	4
C9	Sequence	The manner in which a school may "break up" increasingly difficult or more complex course information. The sequence represents the part of the total. Valid range: 0-9.	[S_KS_CRS_X]Course_Sequence	1
C10	Sequence Total	The total number of classes offered in a series of classes. Valid range: 0-9.	[S_KS_CRS_X]SequenceTotal	2
C11	Grade Level	Grade Level of the course. Valid values: 00 = Spec Ed Infant/toddler 01 = 3 yr old prek 02 = 4 yr old prek 03 = 5 yr old prek 04 = 4 yr old At Risk 05 = Kindergarten 06 = First Grade 07 = Second Grade 08 = Third Grade 09 = Fourth Grade 10 = Fifth Grade 11 = Sixth Grade 12 = Seventh Grade 13 = Eighth Grade 14 = Ninth Grade 15 = Tenth Grade 16 = Eleventh Grade 17 = Twelfth Grade	[S_KS_CRS_X]KCC_Grade_Level	2
C12	Targeted Program	An indicator that the course is funded specifically for the benefit of the subgroup indicated (SPED< ESOL) and the majority of the students in the course are members of the subgroup. Valid values: S = Special Education E = ESOL G = General M = Migrant A = At Risk Default = G	[S_KS_CRS_X]Target_Program	1
C13	Delivery Type	The primary mode of delivery for the course. Valid values: V = Virtual D = Distance G = General M = Self-contained Multi S = Self-contained Single Default = G	[S_KS_CRS_X]Delivery_Type	1
C14	College/Career	Indicatory of whether the course is approved by the state for CTE credit or dual credit. Valid values: N = Not dual credit/Regular course X = CTE credit/not funded IN an approved program/pathway (Introductory level) T = CTE course NOT funded OR part of an approved Pathway (Local Program) L = CTE Credit Dual credit IN an approved program/pathway/Excel in CTE only (old SB155) D = Dual credit NOT funded in a college program F = CTE credit/funded course IN an approved program/pathway (Technical/Application level) C = CTE Dual credit funded IN an approved pathway (HS Only)/Not Excel in CTE (old SB155) R = CTE Dual credit NOT part of an approved program/pathway/Excel in CTE only (old SB155)	[S_KS_CRS_X]College_Career_Credits	1
C15	KSDE Use Only	This column is for 'KSDE Use Only' and will not contain any value in the report.	Not applicable	N/A
C16	State Subject Area Code	One of the defined Kansas Subject Area Codes.	[S_KS_CRS_X]State_Course_ID	2
C17	State Course Identifier	The appropriate state course number which corresponds to the local course identifier. Example 058	[S_KS_CRS_X]Local_Course_ID	3
C18	Effective Date	The first day of the course. If the date is not specified, the date will default to 07/01/yyyy where yyyy = current fiscal year. The course cannot be prior to 7/1/2008.	[S_KS_CRS_X]Effective_Date	10
C19	Expiration Date	The last day of the course. If the date is not specified, it will be blank on the extract.	[S_KS_CRS_X]Expiration_Date	10