This table is an extension of the [Courses] table and provides CRDC-specific fields for Illinois. 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.6.2 |
Number(10,0) |
Primary key that relates the extended table back to the [Courses] table. |
|
APSubjectArea |
16.6.2 |
Varchar2(5) |
Does this fall under a specific Advanced Placement (AP) subject area? Migrated from [Courses]CRDC_APSubjectArea. |
|
CourseTypeAdvMath_YN |
16.6.2 |
Varchar2(1) |
Does this qualify as an Advanced Math course? Migrated from [Courses]CRDC_CourseTypeAdvMath_YN. |
|
CourseTypeAlgebraI_YN |
16.6.2 |
Varchar2(1) |
Does this qualify as an Algebra I course? Migrated from [Courses]CRDC_CourseTypeAlgebraI_YN. |
|
CourseTypeAlgebraII_YN |
16.6.2 |
Varchar2(1) |
Does this qualify as an Algebra II course? Migrated from [Courses]CRDC_CourseTypeAlgebraII_YN. |
|
CourseTypeBiology_YN |
16.6.2 |
Varchar2(1) |
Does this qualify as a Biology course? Migrated from [Courses]CRDC_CourseTypeBiology_YN. |
|
CourseTypeCalculus_YN |
16.6.2 |
Varchar2(1) |
Does this qualify as a Calculus course? Migrated from [Courses]CRDC_CourseTypeCalculus_YN. |
|
CourseTypeChemistry_YN |
16.6.2 |
Varchar2(1) |
Does this qualify as a Chemistry course? Migrated from [Courses]CRDC_CourseTypeChemistry_YN. |
|
CourseTypeGeometry_YN |
16.6.2 |
Varchar2(1) |
Does this qualify as a Geometry course? Migrated from [Courses]CRDC_CourseTypeGeometry_YN. |
|
CourseTypePhysics_YN |
16.6.2 |
Varchar2(1) |
Does this qualify as a Physics course? Migrated from [Courses]CRDC_CourseTypePhysics_YN. |
|
SubjectCat |
16.6.2 |
Varchar2(5) |
Single-sex Classes: Which subject category does this fall under? Migrated from [Courses]CRDC_SubjectCat. |