S_CRS_CRDC_X (ver 17.6.0)
This table is an extension of the [Courses] table and provides CRDC-specific fields for Tennessee. 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.6.0 | Number(10,0) | Primary key. |
| APSubjectArea | 17.6.0 | Varchar2(5) | Advanced Placement (AP) subject area. Migrated from Courses.CRDC_APSubjectArea. |
| CourseTypeAdvMath_YN | 17.6.0 | Varchar2(1) | Advanced Math course. Migrated from Courses.CRDC_CourseTypeAdvMath_YN. |
| CourseTypeAlgebraI_YN | 17.6.0 | Varchar2(1) | Algebra I course. Migrated from Courses.CRDC_CourseTypeAlgebraI_YN. |
| CourseTypeAlgebraII_YN | 17.6.0 | Varchar2(1) | Algebra II course. Migrated from Courses.CRDC_CourseTypeAlgebraII_YN. |
| CourseTypeBiology_YN | 17.6.0 | Varchar2(1) | Biology course. Migrated from Courses.CRDC_CourseTypeBiology_YN. |
| CourseTypeCalculus_YN | 17.6.0 | Varchar2(1) | Calculus course. Migrated from Courses.CRDC_CourseTypeCalculus_YN. |
| CourseTypeChemistry_YN | 17.6.0 | Varchar2(1) | Chemistry course. Migrated from Courses.CRDC_CourseTypeChemistry_YN. |
| CourseTypeGeometry_YN | 17.6.0 | Varchar2(1) | Geometry course. Migrated from Courses.CRDC_CourseTypeGeometry_YN. |
| CourseTypePhysics_YN | 17.6.0 | Varchar2(1) | Physics course. Migrated from Courses.CRDC_CourseTypePhysics_YN. |
| SubjectCat | 17.6.0 | Varchar2(5) | Subject Category. Migrated from Courses.CRDC_SubjectCat. |