CRDC Specific to Connecticut: S_CRS_CRDC_X (ver 15.7.3)
This table is an extension of the [Courses] table and provides CRDC-specific fields for Connecticut. 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 | 15.7.3 | Number (10,0) | Primary key that relates the extended table back to the [Courses] table. |
| APSubjectArea | 15.7.3 | VarChar2 (5) | Code that describes the subject area of an AP course. Migrates from [Courses]CRDC_APSubjectArea. |
| CourseTypeAdvMath_YN | 15.7.3 | VarChar2 (1) | Indicates whether or not a course is an advanced math course. Migrates from [Courses]CRDC_CourseTypeAdvMath_YN. |
| CourseTypeAlgebraI_YN | 15.7.3 | VarChar2 (1) | Indicates whether or not a course is an advanced algebra I course. Migrates from [Courses]CRDC_CourseTypeAlgebraI_YN. |
| CourseTypeAlgebraII_YN | 15.7.3 | VarChar2 (1) | Indicates whether or not a course is an advanced algebra II course. Migrates from [Courses]CRDC_CourseTypeAlgebraII_YN. |
| CourseTypeBiology_YN | 15.7.3 | VarChar2 (1) | Indicates whether or not a course is an advanced biology course. Migrates from [Courses]CRDC_CourseTypeBiology_YN. |
| CourseTypeCalculus_YN | 15.7.3 | VarChar2 (1) | Indicates whether or not a course is an advanced calculus course. Migrates from [Courses]CRDC_CourseTypeCalculus_YN. |
| CourseTypeChemistry_YN | 15.7.3 | VarChar2 (1) | Indicates whether or not a course is an advanced chemistry course. Migrates from [Courses]CRDC_CourseTypeChemistry_YN. |
| CourseTypeGeometry_YN | 15.7.3 | VarChar2 (1) | Indicates whether or not a course is an advanced geometry course. Migrates from [Courses]CRDC_CourseTypeGeometry_YN. |
| CourseTypePhysics_YN | 15.7.3 | VarChar2 (1) | Indicates whether or not a course is an advanced math course. Migrates from [Courses]CRDC_CourseTypePhysics_YN. |
| SubjectCat | 15.7.3 | VarChar2 (5) | The subject category of a single-sex class. Migrates from [Courses]CRDC_SubjectCat. |