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]. |