(CN) Course Master Record

Field

Description

Report Parameters

Schools for which to run?

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.

Reporting Period

Select the reporting period for which you are creating the extract - (L)

Fiscal Year

Enter the fiscal year for the report.

Scheduling

Run Now

Select this option to execute the report in the order it is received in the report queue.

Schedule (available Version 7.1.1.)

Enter the start date and start time for the report.

• Select Run Once and Submit to run the report at the specified date and time.

• Select Repeat to set future dates (Daily, Weekly, Monthly, Yearly) and Submit.

Item #

Data Element

Description

[Table]FieldName

Field Type

Field Length

Begin/End Position

N/A

Filler

Filler

N/A

Numeric

8

1–8

CN010

Sort Type

The sort type equals CN for the Course Master extract.

N/A

Alpha-numeric

2

9–10

N/A

Filler

Filler

N/A

Alpha-numeric

1

11

CN020

Fiscal Year

The fiscal year defaults to the current school year.

N/A

Alpha-numeric

4

12–15

CN030

Reporting Period

This is the reporting period selected on the Course Master Record (CN) Report page, Data and Reporting Reports > Compliance Reports > (CN) Course Master Record Report.

N/A

Alpha-numeric

1

16

CN040

District IRN

This field contains the district number.

This field value is extracted from the Edit District page, District Management > District Setup > District Info.

[Prefs]districtnumber

CST_SUBDISTRICTS.Subdistrict_number

Alpha-numeric

6

17–22

CN050

Subject Code

This field contains the subject of the course.

This field value is extracted from the Edit Course District Information page, District Management > Courses and Programs > Courses > Edit Course Information.

[S_OH_CRS_COURSES_X]Subject_Code (current year)

or

[S_OH_CRS_SNAP_C]Subject_Code (prior year)

Alpha-numeric

6

23–28

CN060

Local Classroom Code

This field is calculated by concatenating the School ID, Course Number, and Section Number.

[Sections]SchoolID [Sections]Course_Number [Sections]Section_Number

Alpha-numeric

20

29–48

N/A

Filler

Filler

Filler

Alpha-numeric

9

49–57

CN080

Course Level

This field contains the level of the course.

This field value is extracted from the Edit Course District Information page, District Management > Courses and Programs > Courses > Edit Course Information.

[S_OH_CRS_COURSES_X]Course_Level (current year)

or

[S_OH_CRS_SNAP_C]Course_Level (prior year)

Alpha-numeric

1

58

CN090

Semester Code

This field contains the semester code for this course or course section.

This field value is extracted from the Semester Code field on the Edit Section page, School Management > Courses and Programs > Course Sections > (Section Number Name) > Edit Section,

Else

If Section field is blank, the value is extracted from the edit Course page, District Management > Courses and Programs > Courses > Edit Course Information.

[S_OH_CRS_COURSES_X]Semester_Code (current year)

or

[S_OH_SEC_X]Semester_Code (current year)

or

[S_OH_CRS_SNAP_C]Semester_Code (prior year)

Alpha-numeric

1

59

CN100

Length of Scheduled Instruction

This field contains the number of instructional hours for this course/course section.

This field value is extracted from the Length of Scheduled Instruction field on the Edit Section page, School Management > Courses and Programs > Course Sections > (Section Number Name) > Edit Section,

Else

If Section field is blank, the value is extracted from the edit Course page, School Management > Courses and Programs > Courses > Edit Course Information.

[S_OH_CRS_COURSES_X]Course_Hours (current year)

or

[S_OH_SEC_X]Course_Hours (current year)

or

[S_OH_CRS_SNAP_C]Course_Hours (prior year)

Numeric

4

60–63

CN110

Location IRN Number

This field contains the location for this course/course section.

This field value is extracted from the Location IRN field on the Edit Section page, School Management > Courses and Programs > Course Sections > (Section Number Name) > Edit Section,

Else

If Section field is blank, the value is extracted from the edit Course page, School Management > Courses and Programs > Courses > Edit Course Information.

[Sections]SchoolID

or

[S_OH_CRS_COURSES_X]Location_IRN (current year)

or

[S_OH_SEC_X]Location_IRN (current year)

or

[S_OH_CRS_SNAP_C]Location_IRN (prior year)

Alpha-numeric

6

64–69

N/A

Filler

Filler

N/A

Alpha-numeric

24

70–93

CN200

High School Credit

This field contains the high school credit earned for this course.

This field is calculated by multiplying the Credit Hours field on the Edit Course District Information page, School Management > Courses and Programs > Courses > (Course Number Name) > Edit Course Information by 100.

[Courses]Credit_Hours * 100

Numeric

3 with 2 decimal places

94–96

CN210

Subject Area for Credit

This field contains the subject area for this course.

This field value is extracted from the Edit Course District Information page, School Management > Courses and Programs > Courses > Edit Course Information.

[S_OH_CRS_COURSES_X]Credit_Subject_Area (current year)

or

[S_OH_CRS_SNAP_C]Credit_Subject_Area (prior year)

Alpha-numeric

3

97–99

CN220

Language Used in Teaching Course

This field contains the code describing the language used in teaching the course for this course/course section.

This field value is extracted from the Language Used in Teaching Course field on the Edit Section page, School Management > Courses and Programs > Course Sections > (Section Number Name) > Edit Section,

Else

If Section field is blank, the value is extracted from the edit Course page, School Management > Courses and Programs > Courses > Edit Course Information.

[S_OH_CRS_COURSES_X]Course_Lang (current year)

or

[S_OH_SEC_X]Course_Lang (current year)

or

[S_OH_CRS_SNAP_C]Course_Lang (prior year)

Alpha-numeric

1

100

N/A

Filler

Filler

N/A

Alpha-numeric

9

101-109

CN280

Course Start Date CCYYMMDD

This field contains the first scheduled day of a course where course dates are required. The format is YYYYMMDD.

This field value is extracted from the Years & Terms page, School Management > Scheduling > Years & Terms.

[Terms]FirstDay

Numeric

8

110–117

CN290

Course End Date CCYYMMDD

This field contains the last scheduled day of a course where course dates are required. The format is YYYYMMDD.

This field value is extracted from the Years & Terms page, School Management > Scheduling > Years & Terms.

[Terms]LastDay

Numeric

8

118–125

N/A

Filler

Filler

N/A

Alpha-numeric

1

126

CN310

Curriculum

This field contains the code identifying the curriculum option for this course/ course section.

This field value is extracted from the Curriculum field on the Edit Section page, School Management > School > Courses and Programs > Course Sections > Course Number Course Name > Edit Section.

Else

If Section field is blank, the value is extracted from the edit Course page, School Management > Courses and Programs > Courses > Edit Course Information.

[S_OH_CRS_COURSES_X]Curriculum (current year)

or

[S_OH_SEC_X]Curriculum (current year)

or

[S_OH_CRS_SNAP_C]Curriculum (prior year)

Alpha-numeric

2

127–128

CN320

Delivery Method

This field contains the code identifying the delivery method for this course/course section.

This field value is extracted from the Delivery Method field on the Edit Section page, School Management > Courses and Programs > Course Sections > Course Number Course Name > Edit Section.

Else

If Section field is blank, the value is extracted from the edit Course page, School Management > Courses and Programs > Courses > Edit Course Information.

[S_OH_CRS_COURSES_X]Delivery_Method (current year)

or

[S_OH_SEC_X]Delivery_Method (current year)

or

[S_OH_CRS_SNAP_C]Delivery_Method (prior year)

Alpha-numeric

2

129–130

CN330

Educational Option

This field contains the code identifying the educational option for this course/course section.

This field value is extracted from the Educational Option field on the Edit Section page, School Management > Courses and Programs > Course Sections > Course Number Course Name > Edit Section.

Else

If Section field is blank, the value is extracted from the edit Course page, School Management > Courses and Programs > Courses > Edit Course Information.

[S_OH_CRS_COURSES_X]Educational Option (current year)

or

[S_OH_SEC_X]Educational Option (current year)

or

[S_OH_CRS_SNAP_C]Educational Option (prior year)

Alpha-numeric

2

131–132

CN340

Student Population

This field contains the code identifying the student population for this course/course section.

This field value is extracted from the Student Population field on the Edit Section page, School Management > Courses and Programs > Course Sections > Course Number Course Name > Edit Section.

Else

If Section field is blank, the value is extracted from the edit Course page, School Management > Courses and Programs > Courses > Edit Course Information.

[S_OH_CRS_COURSES_X]Student_Population (current year)

or

[S_OH_SEC_X]Student_Population (current year)

or

[S_OH_CRS_SNAP_C]Student_Population (prior year)

Alpha-numeric

2

133–134

CN350

Credit Flexibility Code

This field contains the code which determines if a course is being used for credit flex purposes.

This field value is extracted from the Credit Flexibility Code field on the Edit Section page, School Management > Courses and Programs > Course Sections > Course Number Course Name > Edit Section.

Else

If Section field is blank, the value is extracted from the edit Course page, School Management > Courses and Programs > Courses > Edit Course Information.

[S_OH_CRS_COURSES_X]Credit_Flex_Code (current year)

or

[S_OH_SEC_X]Credit_Flex_Code (current year)

or

[S_OH_CRS_SNAP_C]Credit_Flex_Code (prior year)

Alphanurmeric

1

135