CRDC Specific to Texas: S_CRS_CRDC_X (ver 16.1.0)
This table is an extension of the [COURSES] table and provides CRDC-specific fields for Texas. 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 | 16.1.0 | Number(10,0) | Foreign Key. |
APSubjectArea | 16.1.0 | Varchar2(5) | SCH 29, 31, 33. Does this fall under a specific Advanced Placement (AP) subject area? Migrated from [Courses.CRDC_APSubjectArea]. |
CourseTypeAdvMath_YN | 16.1.0 | Varchar2(1) | Does this qualify as an Advanced Math course? Migrated from [Courses.CRDC_CourseTypeAdvMath_YN]. |
CourseTypeAlgebraI_YN | 16.1.0 | Varchar2(1) | Does this qualify as an Algebra I course? Migrated from |
CourseTypeAlgebraII_YN | 16.1.0 | Varchar2(1) | Does this qualify as an Algebra II course? Migrated from |
CourseTypeBiology_YN | 16.1.0 | Varchar2(1) | Does this qualify as an Biology course? Migrated from [Courses.CRDC_CourseTypeBiology_YN]. |
CourseTypeCalculus_YN | 16.1.0 | Varchar2(1) | Does this qualify as an Calculus course? Migrated from |
CourseTypeChemistry_YN | 16.1.0 | Varchar2(1) | Does this qualify as an Chemistry course? Migrated from |
CourseTypeGeometry_YN | 16.1.0 | Varchar2(1) | Does this qualify as an Geometry course? Migrated from |
CourseTypePhysics_YN | 16.1.0 | Varchar2(1) | Does this qualify as an Physics course? Migrated from [Courses.CRDC_CourseTypePhysics_YN]. |
SubjectCat | 16.1.0 | Varchar2(5) | Which subject category does this fall under? Migrated from [Courses.CRDC_SubjectCat]. |