This table is an extension of the [Courses] table and provides CRDC-specific fields for Maine. 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 |
17.2.0 |
Number(10,0) |
Foreign Key to the Courses table. |
|
APSubjectArea |
17.2.0 |
VarChar2(5) |
Code that describes the subject area of an AP course. Migrated from: [Courses]CRDC_APSubjectArea |
|
CourseTypeAdvMath_YN |
17.2.0 |
VarChar2(1) |
Indicates whether or not a course is an advanced math course. Migrated from: [Courses]CRDC_CourseTypeAdvMath_YN |
|
CourseTypeAlgebraI_YN |
17.2.0 |
VarChar2(1) |
Indicates whether or not a course is an advanced algebra I course. Migrated from: [Courses]CRDC_CourseTypeAlgebraI_YN |
|
CourseTypeAlgebraII_YN |
17.2.0 |
VarChar2(1) |
Indicates whether or not a course is an advanced algebra II course. Migrated from: [Courses]CRDC_CourseTypeAlgebraII_YN |
|
CourseTypeBiology_YN |
17.2.0 |
VarChar2(1) |
Indicates whether or not a course is an advanced biology course. Migrated from: [Courses]CRDC_CourseTypeBiology_YN |
|
CourseTypeCalculus_YN |
17.2.0 |
VarChar2(1) |
Indicates whether or not a course is an advanced calculus course. Migrated from: [Courses]CRDC_CourseTypeCalculus_YN |
|
CourseTypeChemistry_YN |
17.2.0 |
VarChar2(1) |
Indicates whether or not a course is an advanced chemistry course. Migrated from: [Courses]CRDC_CourseTypeChemistry_YN |
|
CourseTypeGeometry_YN |
17.2.0 |
VarChar2(1) |
Indicates whether or not a course is an advanced geometry course. Migrated from: [Courses]CRDC_CourseTypeGeometry_YN |
|
CourseTypePhysics_YN |
17.2.0 |
VarChar2(1) |
Indicates whether or not a course is an advanced physics course. Migrated from: [Courses]CRDC_CourseTypePhysics_YN |
|
SubjectCat |
17.2.0 |
VarChar2(5) |
The subject category of a single-sex class. Migrated from: [Courses]CRDC_SubjectCat |