S_OH_CRS_COURSES_X (ver 14.7.2)
This table is an extension of the Courses table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CoursesDCID | 14.7.2 | Number(10,0) | Primary key that relates the extended table back to the Courses table. |
| Block_Scheduled_Class | 15.5.2 | VarChar2(1) | Identifies a block scheduled course |
| Core_Area_Code | 15.9.0 | VarChar2(20) | Subject area and/or CORE requirement area in which a student has earned credit/units towards graduation. |
| Course_Hours | 15.9.0 | Number(11,0) | Hours per year that a teacher spends in instruction for the course. |
| Course_Lang | 15.9.0 | VarChar2(20) | The language(s) used by the teacher when presenting to students. |
| Course_Level | 15.9.0 | VarChar2(20) | The level of the course. |
| Course_Type | 15.9.0 | VarChar2(20) | The type of instructional program (Obsolete FY10). |
| Credit_Flex_Code | 15.9.0 | VarChar2(20) | Identifies if the course is an approved credit flex course. |
| Credit_Subject_Area | 15.9.0 | VarChar2(20) | The subject for courses offered in which high school credit toward graduation is being applied. |
| CTAE | 15.9.0 | VarChar2(20) | Designates if a student has completed a minimum of 50% of the high school credits allowed for a single career-technical education (CTE) workforce development program and has enrolled for additional credit in the same CTE program (Obsolete FY11). |
| CTA_CBI_Course | 15.9.0 | Number(1,0) | Identifies courses to be included even if no students are yet enrolled in the course. |
| CTE_College_Credit | 15.9.0 | VarChar2(20) | Indicates if a career-technical course provides an opportunity for students to earn college credit. |
| Curriculum | 15.9.0 | VarChar2(20) | The curriculum source/model/program for a specific course. |
| Delivery_Method | 15.9.0 | VarChar2(20) | Identifies the means by which instruction is provided/communicated to the student(s) in the course. |
Dual_Credit | 14.7.2 | VarChar2(1) | Dual Enrollment Credit Earned. |
Dual_Credit_Override | 14.7.2 | Number(25,10) | Dual Enrollment Credit Earned Override. |
| Educational_Option | 15.9.0 | VarChar2(20) | Identifies the Educational Option status for a course. |
| Exclude_From_FR | 21.1.1.0 | Number(1,0) | A flag to identify courses to exclude from the (FR) Student Course Grade Record. |
| Exclude_From_Truancy | 17.11.0 | Number(1,0) | A flag to identify courses to exclude time scheduled as absent from Ohio House Bill 410 absence time. |
| Teacher Licensure Course (TLC)_IRN | 15.9.0 | VarChar2(20) | IRN used to group courses for the calculations of the percentage of core courses taught by properly certified or licensed staff. |
| Location_IRN | 15.9.0 | VarChar2(20) | The IRN of the building where the course is held. |
| Program_Builders_Code | 15.9.0 | VarChar2(20) | A code used by the school district that uniquely identifies a specific career-technical program within a district (Obsolete FY10). |
| Provider_IRN | 15.9.0 | VarChar2(20) | The district IRN of the entity in contract with the reporting school district. |
| Semester_Code | 15.9.0 | VarChar2(20) | The length of time, in weeks or semesters, that the course is taught. |
| Special_Population | 15.9.0 | VarChar2(20) | Indicates if the special education course type is structured to specifically instruct students with hearing and/or visual impairments (Obsolete FY10). |
| State_ExcludeFromReporting | 15.9.0 | Number(1,0) | A flag to identify courses that are not to be EMIS reported. |
| Student_Population | 15.9.0 | VarChar2(20) | Identifies the attributes of the group of students for which the course is intended. |
| Subject_Code | 15.9.0 | VarChar2(20) | The code for the subject of the course being reported. |