Tool Search: OH Extracts
The Ohio Student Course Master Record (CN) reports a separate record for each active section based on the calendar(s) selected and the Date Range Entered on the extract editor.
Course Master Record (CN) Extract EditorReport Logic
- Courses marked as 'State Exclude' will not be included in the record.
- Only courses marked as Active will be included in the extract.
- Courses are also required to have a State Code to report.
Report Editor
The following table describes the options available in the extract editor.
Editor Field | Description |
|---|---|
Extract Type | The type of extract being generated. In this case, select Course Master Record (CN). |
Reporting Period | Indicates when the report is being submitted. Options are:
|
Date Range | The dates which determine which student enrollments are included in the report, based on the Start and End Dates of enrollments within the selected calendar(s). |
Credit Multiplier | Multiplies High School Credit by the Credit Multiplier, used in instances where the credit entered for the Grading Task may not be accurate. |
Format | The format in which the report will generate. Options are State Format (Fixed width), HTML, CSV and XML. Use HTML, CSV or XML formats for data review and verification and State Format for submission to the State. |
Ad hoc Filter | Allows a previously created Ad hoc Filter to be selected that will limit what students appear in the report. Filters are created in the Filter Designer. |
Calendar(s) | Students enrolled in the selected calendar(s) will appear in the report. |
Generating the Extract
- Select the Course Master Record (CN) Extract Type.
- Select the Reporting Period.
- Enter a Date Range to limit records reported to those that fall on or within the dates entered.
- Select the extract Format. For submission to the state, select the State Format (Fixed width) option. To review data prior to state submission, select any of the other available formats.
- Select which calendar(s) to include within the extract.
- Do not select an Ad hoc Filter. Although this field appears available, Ad hoc reporting functionality has not been implemented for the Course Master Record (CN) extract.
- Click Generate Extract to generate the report in the indicated format or Submit to Batch to schedule when the report will generate.
Users have the option of submitting a Course Master Record report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.
Extract Layout
Element Name | Description & Format | Campus Location |
|---|---|---|
Filler | 7 characters |
|
Filler | 1 character |
|
Sort Type | Always reports a value of CN for the Course Master Record. Alphanumeric 2 characters | N/A |
Filler | 1 character |
|
Fiscal Year | The Fiscal Year determined by the end year of the reported school year (i.e., 2009 for the 2008-2009 school year). YYYY, 4 characters | System Administration > Calendar > School Year > End Year Not Dynamically |
Reporting Period | The reporting period in which data is being pulled from. Alphanumeric 1 character | OH State Reporting > OH Extracts > Reporting Period Not Dynamically Stored |
District IRN | The state assigned six-digit information retrieval number (IRN) of the building.
Alphanumeric 6 characters | System Administration > Resources > District Information > State District Number District.districtID |
Subject Code | Reports the subject of the course being reported. Alphanumeric 6 characters | Scheduling > Course > Course Editor > State Code Course.stateCode |
Local Classroom Code | The code used by the local school district that uniquely identifies a specific classroom (i.e., period and section) within a district. Reports the State School Number-Course Number-Section Number. Alphanumeric 20 characters | System Administration > Resources > School > School Editor > State School Number AND Scheduling > Courses > Course > Course Editor > Number AND Scheduling > Courses > Section > Section Editor > Section Number School.number; Course.number; Section.number |
Employee ID | Filler field, reports blank. Alphanumeric | Scheduling > Courses > Sections > Section Editor > Primary Teacher AND Census > Demographics > Person Identifiers > Staff Number Person.staffNumber |
Course Level | Reports the course level. Alphanumeric 1 character | Scheduling > Course > Course Editor > Course Level Course.courseLevel |
Semester Code | Reports the Semester Code. This is the length of time in which the course is taught. Alphanumeric 1 character | Scheduling > Courses > Section > Section Editor > Semester Code Override OR Scheduling > Course > Course Editor > Semester Code Course.semesterCode |
Length of Scheduled Instruction | The hours per year a teacher spends in instruction for the course/subject. Alphanumeric | Scheduling > Courses > Course > Length of Scheduled Instruction OR Schedule > Courses > Section > Section Schedule Placement AND System Administration > Calendar > Calendar > Periods > Period Schedule/Periods Editor > Period Information AND System Administration > Calendar > Calendar > Days CustomCourse Course.Length; Section.weeklyMinutes; Period.startTime; Period.endTime; Day.duration |
| Location IRN Number | The IRN of the builidng where the course is held. Reports the Location IRN for the Course. Otherwise, reports the IRN Override for the School, or the IRN Override if null. Numeric, 6 characters | Scheduling > Courses > Course > Location IRN; System Administration > Resources > School > IRN Override, State School Number Course.locationIRN School.irnOverride School.number |
High School Credit | The amount of high school credit given for the course. Reports the number of credits given in the course based on whether the High School Credit checkbox is marked. If there is no credit amount associated with the course, this field reports as 000 when generated in Fixed Width format. Alphanumeric | Scheduling > Courses > Course > High School Credit AND Scheduling > Courses > Grading Tasks > Course Grading Task Detail > Credit Course.secondaryCredit |
CORE Area for Credit | The subject for courses offered in which high school credit toward graduation is being applied, whether at middle school or high school level. Alphanumeric 3 characters | Scheduling > Course > Course Editor > CORE Area for Credit Course.transcriptField1 |
Language Used in Teaching Course | The language(s) used by the teacher when instructing to students. Alphanumeric 1 character | Scheduling > Courses > Sections > Section Editor > Language Used Section.languageUsed |
Filler | 1 character |
|
Filler | 1 character |
|
Highly Qualified Teacher | Filler field, reports as blank. Alphanumeric 1 character | Scheduling > Courses > Sections > Section Editor > Highly Qualified Override OR Census > People > District Assignments > Employment Assignment > Employment Assignment Information > Highly Qualified Section.highlyQualified EmploymentAssignment.highlyQualified |
Highly Qualified Teacher IRN | Filler field, reports as blank. Alphanumeric | Scheduling > Courses > Sections > Section Editor > Highly Qualified IRN Override OR System Administration > Resources > School > School Editor > State School Number Section.highlyQualifiedIRN; School.schoolID |
Course Start Date | The first scheduled day the course begins. YYYYMMDD, 8 characters | Scheduling > Courses > Section > Section Editor > Section Schedule Placement AND System Administration > Calendar > Calendar > Terms > Terms Editor > Term Detail > Start Date Term.StartDate; SectionPlacement.periodID |
Course End Date | Last scheduled day of a course where course dates are required. YYYYMMDD, 8 characters | Scheduling > Courses > Section > Section Editor > Section Schedule Placement AND System Administration > Calendar > Calendar > Terms > Terms Editor > Term Detail > End Date Term.endDate; SectionPlacement.periodID |
CTE College Credit | Indicates if a career-technical course provides an opportunity for students to earn college credit. Alphanumeric 1 character | Scheduling > Courses > Course Editor > CTE College Credit Course.cteCollegeCredit |
Curriculum | The type of instructional program. Reports the Curriculum Override for the Section. If null, reports the Curriculum field for the Course.
Valid Options IA – International Baccalaureate AB INITO Alphanumeric 2 characters | Scheduling > Courses > Section > Curriculum Override; Course > Curriculum Section.curriculumOverride Course.curriculum |
Delivery Method | Identifies the means by which instruction is provided/communicated to the student.
Valid Options CC – Correspondence Course Alphanumeric 2 characters | Scheduling > Courses > Sections > Delivery Method Override; Scheduling > Courses > Course > Delivery Method Course.deliveryMethod |
Educational Option | Identifies the Educational Option status for each course. Report Educational Option. If NULL, report NO Valid Options NO – Not an Educational Option Course Alphanumeric | Scheduling > Courses > Course > Educational Option Course.educationalOption |
Student Population | Identifies the attributes of the student group in which the course is intended for.
Valid Options D8 – Preschool Special Education Alphanumeric | Scheduling > Courses > Sections > Student Population Override; Scheduling > Courses > Course > Student Population Course.studentPopulation |
Credit Flexibility Code | Indicates whether the course is customized and developed in collaboration with school officials within the scope of the district board-approved credit flexibility policy, which provides opportunities for students to earn credits in non-traditional way. Report Credit Flexibility Override. If NULL, report Credit Flexibility. If NULL, report N. Valid Options
Alphanumeric, 1 character | Scheduling > Courses > Section > Credit Flexibility Override; Course > Credit Flexibility Code Section.creditFlexibilityOverride Course.creditFlexibilityCode |
Filler | 166 characters |
|
