S_MD_CRS_MCC_X (ver 15.10.0)
This table is an extension of the [Courses] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CoursesDCID | 15.10.0 | Number (10,0) | Primary Key |
| Assessed_Content_Area | 15.10.0 | Varchar2 (8) | Obsolete - 22.11.3.0 Indicates that the course is associated with a State mandated assessment at the elementary, middle, or high school level. |
| Carnegie_Units | 15.10.0 | Number (25,10) | Obsolete - 22.11.3.0 Amount of Carnegie Unit Credit available to a student who successfully meets the objectives of a secondary course. |
| Course_Cert_Description | 15.10.0 | Varchar2 (100) | Obsolete - 21.4.2.0 Provides a description of the certification or recognition associated with the course. |
| Course_Content_Standards | 15.10.0 | Varchar2 (4) | Indicator of the content standards used to align course curriculum and assess whether students meet grade level expectations. |
| Course_GPA | 15.10.0 | Number (1,0) | Course Grade Point Average Applicability |
| Course_Level | 15.10.0 | Varchar2 (6) | An indication of the course’s level of rigor. |
| Course_Level_Characteristic | 22.11.3.0 | Varchar2 (4) | An additional characteristic associated with the general nature and rigor of instruction throughout a course. |
| CTE_Associated_Course | 15.10.0 | Number (1,0) | Obsolete - 22.11.3.0 Indicates that the course is part of an approved program of study in Career Technology Education (CTE) and is associated with courses that have a designated Classification of Instructional Programs (CIP) code. |
| Delivery_Type | 15.10.0 | Varchar2 (4) | Describes the primary setting or medium of delivery for the course. |
| FACS_Course_Indicator | 15.10.0 | Number (1,0) | Indicates that the course is associated with the Family and Consumer Sciences plan of study. |
| HS_Course_Req | 15.10.0 | Number (1,0) | Indication that successful completion of the course is required in order to earn a high school diploma. |
| Inst_Language | 15.10.0 | Varchar2 (6) | Indicates the language of instruction used to teach the program or course. |
| IPEDS_SchoolCode | 15.10.0 | Number (11,0) | Identifies the institution of higher education where the college-level or dual-credit course is taught. |
| K12_EndofCourse_Req | 15.10.0 | Number (1,0) | Indicates that the course has an end of course examination required by MSDE or the Local Education Agency. |
| LEA_Course_Description | 17.5.0 | Varchar2 (1000) | LEA Course Description |
| NCAA_Eligibility | 15.10.0 | Number (1,0) | Indicates that the course is approved for determining National collegiate Athletic Association (NCAA) eligibility. |
SCED_Course_Code | 15.10.0 | Varchar2 (10) | Three-digit number that distinguishes a course within a SCED Subject Area |
| SCED_Grade_Span1 | 15.10.0 | Varchar2 (4) | SCED lowest grade of instruction |
| SCED_Grade_Span2 | 15.10.0 | Varchar2 (4) | SCED highest grade of instruction |
| SCED_Seq_Course | 15.10.0 | Number (11,0) | Indicates where a specific course lies when it is part of a consecutive sequence of courses. |
| SCED_Seq_Total | 15.10.0 | Number (11,0) | Second part in the sequence or order of a series of courses if there are multiple parts to the course. |
| Technology_Ed_Indicator | 15.10.0 | Varchar2 (6) | Indicates that the course is a General Technology Education or an Advanced Technology Education course. |
| Transition_Course_or_Module | 16.9.4 | Varchar2 (4) | Obsolete - 22.11.3.0 Course or course equivalent method completed by a 12th grade student who has not passed an approved College and Career Readiness (CCR) assessment, in English 11 and/or Algebra 2, by the end of their 11th grade. |