Statewide Standard Course Code Mapping

Introduction

This report collects information regarding the courses that are offered in the current year. The report is intended to be run district wide, but it may be run for a select school. The report extracts one record for each course that’s active for the current year, into a tab-delimited file.

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.

Record Selection

The report selects records from the Schools and Courses tables based on the following criteria:

The school is not flagged as Exclude from State Reporting.
The course is not flagged as Exclude from State Reporting.
The course has a section for the current year.

Report Input

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

Field

Description

Select Schools*

If run at the district level, choose one of the following:

Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report
All Schools – Run the report for the entire district.

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.

Include Header Row*

Choose one of the following:

Yes – Choose this option to have the report output a header row with column descriptions.
No – Choose this option to have the report extract data without column headings.

Back to Top

Report Output

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

Item #	Data Element	Description	[Table]FieldName	Field Length
1	Local Course Identifier	The locally assigned course number.	[Courses]Course_Number	100
2	Local Course Title	The locally assigned course name.	[Courses]Course_Name	100
3	Local Course Descriptor (Optional)	A brief description of the course purpose or content.	[S_CO_CRS_X]Description	2000
4	Course Level	The associated level with the course offered. Note: ‘G’ will extract if no field value has been selected.	[S_CO_CRS_X]CourseLevel	1
5	Credits (Carnegie Units)	The number of length of the course in terms of Carnegie Units. Note: If the CO_CrsCarnegie field is blank, the Credit_Hours field will be reported.	[S_CO_CRS_X]Carnegie [Courses]Credit_Hours	4
6	Sequence (Optional)	The Sequence field combined with “Sequence Total” describes the manner in which school systems may “break up” increasingly difficult or more complex course information. The sequence represents the part of the total. Note: If field value is blank, ‘1’ will be extracted.	[S_CO_CRS_X]CrsSequence	1
7	Sequence Total (Optional)	The total number of classes offered in a series of classes. Used in conjunction with “Sequence”. Note: If field value is blank, ‘1’ will be extracted.	[S_CO_CRS_X]SeqTotal	1
8	State Course Code	The appropriate state course number which corresponds to the local course identifier.	[Courses]Alt_Course_Number	30
9	Optional Sort Field 1	User defined. Will not be collected by the state.	[S_CO_CRS_X]DistUse1	20
10	Optional Sort Field 2	User defined. Will not be collected by the state.	[S_CO_CRS_X]DistUse2	20

Back to Top