S_SEC_CRDC_X (ver 17.6.0)
This table is an extension of the [Sections] table and provides CRDC-specific fields for Tennessee. To view additional CRDC fields used by all states, refer to S_SEC_CRDC_X in the All States Data Dictionary.
Column Name | Version | Data Type | Description |
|---|---|---|---|
SectionsDCID | 17.6.0 | Number(10,0) | Primary key. |
| APSubjectArea | 17.6.0 | Varchar2(5) | AP Subject Area. Migrated from Courses. CRDC_APSubjectArea. |
| CourseTypeAdvMath_YN | 17.6.0 | Varchar2(1) | Advanced Math course. Migrated from Courses.CRDC_CourseTypeAdvMath_YN. |
| CourseTypeAlgebraI_YN | 17.6.0 | Varchar2(1) | Algebra I course. Migrated from Courses.CRDC_CourseTypeAlgebraI_YN. |
| CourseTypeAlgebraII_YN | 17.6.0 | Varchar2(1) | Algebra II course. Migrated from Courses.CRDC_CourseTypeAlgebraII_YN. |
| CourseTypeBiology_YN | 17.6.0 | Varchar2(1) | Biology course. Migrated from Courses.CRDC_CourseTypeBiology_YN |
| CourseTypeCalculus_YN | 17.6.0 | Varchar2(1) | Calculus course. Migrated from Courses.CRDC_CourseTypeCalculus_YN. |
| CourseTypeChemistry_YN | 17.6.0 | Varchar2(1) | Chemistry course. Migrated from Courses.CRDC_CourseTypeChemistry_YN. |
| CourseTypeGeometry_YN | 17.6.0 | Varchar2(1) | Geometry course. Migrated from Courses.CRDC_CourseTypeGeometry_YN. |
| CourseTypePhysics_YN | 17.6.0 | Varchar2(1) | Physics course. Migrated from Courses.CRDC_CourseTypePhysics_YN. |
| SubjectCat | 17.6.0 | Varchar2(5) | Subject Category. Migrated from Courses.CRDC_SubjectCat. |
| SingleSexCode | 17.6.0 | Varchar2(1) | Restricted to a single gender. |