CRDC: S_CRS_CRDC_X (ver 15.11.0)
This table is an extension of the [Courses] table and provides CRDC-specific fields for Utah. 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.11.0 | Number(10,0) | Primary Key |
| APSubjectArea | 15.11.0 | Varchar2(5) | Advanced Placement (AP) subject. Migrated from [Courses.CRDC_APSubjectArea]. |
CourseTypeAdvMath_YN | 15.11.0 | Varchar2(1) | Advanced Math course (trigonometry, elementary analysis, analytic geometry, statistics, precalculus, etc). Migrated from [Courses.CRDC_CourseTypeAdvMath_YN]. |
| CourseTypeAlgebraI_YN | 15.11.0 | Varchar2(1) | Algebra I course. Migrated from [Courses.CRDC_CourseTypeAlgebraI_YN]. |
| CourseTypeAlgebraII_YN | 15.11.0 | Varchar2(1) | Algebra II course. Migrated from [Courses.CRDC_CourseTypeAlgebraII_YN]. |
| CourseTypeBiology_YN | 15.11.0 | Varchar2(1) | Biology course. Migrated from [Courses.CourseTypeBiology_YN]. |
| CourseTypeCalculus_YN | 15.11.0 | Varchar2(1) | Calculus course. Migrated from [Courses.CRDC_CourseTypeCalculus_YN]. |
| CourseTypeChemistry_YN | 15.11.0 | Varchar2(1) | Chemistry course. Migrated from [Courses.CRDC_CourseTypeChemistry_YN]. |
| CourseTypeGeometry_YN | 15.11.0 | Varchar2(1) | Geometry course. Migrated from [Courses.CRDC_CourseTypeGeometry_YN]. |
| CourseTypePhysics_YN | 15.11.0 | Varchar2(1) | Physics course. Migrated from [Courses.CRDC_CourseTypePhysics_YN]. |
| SubjectCat | 15.11.0 | Varchar2(5) | Subject category. Migrated from [Courses.CRDC_SubjectCat]. |