S_CRS_CRDC_X (ver 16.6.0)
This table is an extension of the [Courses] table and provides CRDC-specific fields for Virginia. To view additional CRDC fields used by all states, refer to S_CRS_CRDC_X in the All States Data Dictionary.
Note: In lieu of the below fields, SCED codes are used in the CRDC for Virginia.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| CoursesDCID | 16.6.0 | Number(10,0) | Foreign Key to the Courses table. |
| APSubjectArea | 16.6.0 | Varchar2(5) | Migrated from: [Courses]CRDC_APSubjectArea |
| CourseTypeAdvMath_YN | 16.6.0 | Varchar2(1) | Migrated from: [Courses]CRDC_CourseTypeAdvMath_YN |
| CourseTypeAlgebraI_YN | 16.6.0 | Varchar2(1) | Migrated from: [Courses]CRDC_CourseTypeAlgebraI_YN |
| CourseTypeAlgebraII_YN | 16.6.0 | Varchar2(1) | Migrated from: [Courses]CRDC_CourseTypeAlgebraII_YN |
| CourseTypeBiology_YN | 16.6.0 | Varchar2(1) | Migrated from: [Courses]CRDC_CourseTypeBiology_YN |
| CourseTypeCalculus_YN | 16.6.0 | Varchar2(1) | Migrated from: [Courses]CRDC_CourseTypeCalculus_YN |
| CourseTypeChemistry_YN | 16.6.0 | Varchar2(1) | Migrated from: [Courses]CRDC_CourseTypeChemistry_YN |
| CourseTypeGeometry_YN | 16.6.0 | Varchar2(1) | Migrated from: [Courses]CRDC_CourseTypeGeometry_YN |
| CourseTypePhysics_YN | 16.6.0 | Varchar2(1) | Migrated from: [Courses]CRDC_CourseTypePhysics_YN |
| SubjectCat | 16.6.0 | Varchar2(5) | Migrated from: [Courses]CRDC_SubjectCat |