CRDC Specific to Minnesota: S_CRS_CRDC_X (ver 16.12.1)
This table is an extension of the [Courses] table and provides CRDC-specific fields for Minnesota. To view additional CRDC fields used by all states, refer to S_CRS_CRDC_X in the All States Data Dictionary.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CoursesDCID | 16.12.1 | Number(10,0) | Primary Key. |
| APSubjectArea | 16.12.1 | Varchar2(5) | An indicator of whether the course falls under a specific Advanced Placement (AP) subject area. |
| CreditRecovery_YN | 17.2.0 | Varchar2(1) | The course qualifies as a credit recovery course. |
| CourseTypeAdvMath_YN | 16.12.1 | Varchar2(1) | The course qualifies as an Advanced Math course (trigonometry, elementary analysis, analytic geometry, statistics, precalculus, etc). |
| CourseTypeAlgebraI_YN | 16.12.1 | Varchar2(1) | The course qualifies as an Algebra I course. |
| CourseTypeAlgebraII_YN | 16.12.1 | Varchar2(1) | The course qualifies as an Algebra II course. |
| CourseTypeBiology_YN | 16.12.1 | Varchar2(1) | The course qualifies as a Biology course. |
| CourseTypeCalculus_YN | 16.12.1 | Varchar2(1) | The course qualifies as a Calculus course. |
| CourseTypeChemistry_YN | 16.12.1 | Varchar2(1) | The course qualifies as a Chemistry course. |
| CourseTypeCompSci_YN | 17.2.0 | Varchar2(1) | The course qualifies as a Computer Science course. |
| CourseTypeGeometry_YN | 16.12.1 | Varchar2(1) | The course qualifies as a Geometry course. |
| CourseTypePhysics_YN | 16.12.1 | Varchar2(1) | The course qualifies as a Physics course |
| SubjectCat | 16.12.1 | Varchar2(5) | The subject category the course falls under. |