CRDC Specific to Colorado: S_SEC_CRDC_X (ver 14.9.3)
This table is an extension of the [Schools] table and provides CRDC-specific fields for Colorado. To view additional CRDC fields used by all states, refer to S_SCH_CRDC_X in the All States Data Dictionary.
Column Name | Version | Data Type | Description |
|---|---|---|---|
SectionsDCID | 14.9.3 | Number (10,0) | System generated primary key. |
APSubjectArea | 14.9.3 | Varchar2 (5) | Does this fall under a specific Advanced Placement (AP) subject area? |
CourseTypeAdvMath_YN | 14.9.3 | Varchar2 (1) | Does this qualify as an Advanced Math course? |
CourseTypeAlgebraI_YN | 14.9.3 | Varchar2 (1) | Does this qualify as an Algebra I course? |
CourseTypeAlgebraII_YN | 14.9.3 | Varchar2 (1) | Does this qualify as an Algebra II course? |
CourseTypeBiology_YN | 14.9.3 | Varchar2 (1) | Does this qualify as an Biology course? |
CourseTypeCalculus_YN | 14.9.3 | Varchar2 (1) | Does this qualify as an Calculus course? |
| CourseTypeChemistry_YN | 14.9.3 | Varchar2 (1) | Does this qualify as an Chemistry course? |
| CourseTypeGeometry_YN | 14.9.3 | Varchar2 (1) | Does this qualify as an Geometry course? |
| CourseTypePhysics_YN | 14.9.3 | Varchar2 (1) | Does this qualify as an Physics course? |
| SingleSexCode | 14.9.3 | Varchar2 (1) | Is this restricted to a single gender? |
| SubjectCat | 14.9.3 | Varchar2 (5) | Which subject category does this fall under? |