CRDC Specific to Michigan: S_CRS_CRDC_X (ver 17.1.0)
This table is an extension of the [Courses] table and provides CRDC-specific fields for Michigan. 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 | 17.1.0 | Number(10,0) | Primary Key. |
| APSubjectArea | 17.1.0 | Varchar2(5) | Course Advanced Placement subject area. |
| CourseTypeAdvMath_YN | 17.1.0 | Varchar2(1) | Does this qualify as an advanced math course? |
| CourseTypeAlgebraI_YN | 17.1.0 | Varchar2(1) | Does this qualify as an algebra I course? |
| CourseTypeAlgebraII_YN | 17.1.0 | Varchar2(1) | Does this qualify as an algebra II course? |
| CourseTypeBiology_YN | 17.1.0 | Varchar2(1) | Does this qualify as a biology course? |
| CourseTypeCalculus_YN | 17.1.0 | Varchar2(1) | Does this qualify as a calculus course? |
| CourseTypeChemistry_YN | 17.1.0 | Varchar2(1) | Does this qualify as a chemistry course? |
| CourseTypeGeometry_YN | 17.1.0 | Varchar2(1) | Does this qualify as a geometry course? |
| CourseTypePhysics_YN | 17.1.0 | Varchar2(1) | Does this qualify as a physics course? |
| SubjectCat | 17.1.0 | Varchar2(5) | Single-sex subject category. |