S_CT_CRS_X (ver 15.7.3)
This table is an extension of the [Courses] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CoursesDCID | 15.7.3 | Number(10,0) | Primary key that relates the extended table back to the [Courses] table. |
| AdvancedPlacementCourse | 15.7.3 | VarChar2(2) | Indicates whether or not a course is an Advanced Placement course. Migrated from [Courses]CT_Adv_Place_Course. |
| NCESCourseCode | 15.7.3 | VarChar2(12) | The NCES Course Code that most aligns with the content and curriculum of the course offered by the school or district. Migrated from [Courses]CT_NCES_Crse_Cd. |
| UseMarkingPeriodDates | 16.6.2 | Varchar2(1) | Indicates whether the Course should use marking period dates (TermBins table) for reporting Final Grade in TCS Report. |
| DualEnrollPrgmCode | 16.8.0 | Varchar2(10) | Indicates if the course section qualifies as a Dual Enrollment Program course that allows students to earn higher education credits in the designated Dual Enrollment Program. The section value for this element, if present, will take precedence over the course value. |
| College_Level_Course | 17.2.0 | Varchar2(1) | Indicates the college course level for the course. Migrated from: [Courses]CT_College_Lvl_Course. |
| Selected_Courses_Credit | 17.2.0 | Varchar2(20) | Indicates the credit category for selected course. Migrated from: [Courses]CT_Sel_Courses_Credit. |
| Subject_Area | 17.2.0 | Varchar2(2) | Indicates the subject area for the course. Migrated from: [Courses]CT_Subject_Area. |
| WhereTaught | 18.1.0 | Number(11,0) | Indicates the values for the classes taught online. |
| CourseTitleOneServices | 21.8.2 | VarChar2(50) | Title One Service field at course level. |