S_VA_CRS_X (ver 14.8.0)
This table is an extension of the Courses table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CoursesDCID | 14.8.0 | Number(10,0) | Foreign Key to the Courses table. |
EnglishEnrollment | 14.8.0 | Varchar2(1) | Indicates whether Course is to be counted in 6-12 English Enrollment Report |
| ComCollegeCrsCollabInd | 15.1.0 | Number(1,0) | Commonwealth College Course Collaborative Indicator. |
| CTEInd | 15.3.0 | Number(1,0) | CTE Indicator. |
| Accelerated | 16.6.0 | Varchar2(1) | Migrated from: [Courses]VA_Accelerated |
| Advanced | 16.6.0 | Varchar2(1) | Migrated from: [Courses]VA_Advanced |
| Advanced_Placement | 16.6.0 | Varchar2(1) | Migrated from: [Courses]VA_Advanced_Placement |
| Baccalaureate | 16.6.0 | Varchar2(1) | Migrated from: [Courses]VA_Baccalaureate |
| CTE_Career_Cluster_Code | 16.6.0 | Varchar2(5) | Migrated from: [Courses]VA_CTE_career_family |
| Honors | 16.6.0 | Varchar2(1) | Migrated from: [Courses]VA_Honors |
| SCED_Avail_Credit | 16.6.0 | Varchar2(5) | Migrated from: [Courses]VA_SCED_Avail_Credit |
| SCED_Course_Identifier | 16.6.0 | Varchar2(4) | Migrated from: [Courses]VA_SCED_Crs_Identifier |
| SCED_Course_Level | 16.6.0 | Varchar2(1) | Migrated from: [Courses]VA_SCED_Crs_Level |
| SCED_Sequence | 16.6.0 | Varchar2(4) | Migrated from: [Courses]VA_SCED_Sequence |
| SCED_Subject_Area | 16.6.0 | Varchar2(3) | Migrated from: [Courses]VA_SCED_Subject_Area |
| SOL_Test | 16.6.0 | Number(11,0) | Migrated from: [Courses]VA_SOL_test |
| SOL_test_alt | 16.6.0 | Number(11,0) | Migrated from: [Courses]VA_SOL_test_alt |
| SOL_test_altlist | 16.6.0 | Varchar2(4000) | Migrated from: [Courses]VA_SOL_test_altlist |
| SOL_testlist | 16.6.0 | Varchar2(4000) | Migrated from: [Courses]VA_SOL_testlist |
| Transcript_Course_Name | 16.6.0 | Varchar2(25) | Migrated from: [Courses]VA_TranscriptCourseName |
| Transcript_Course_Number | 16.6.0 | Varchar2(8) | Migrated from: [Courses]VA_TranscriptCourseNumber |
| VirtualCourseInd | 16.6.0 | Varchar2(40) | Migrated from: [Courses]VA_Virtual_Crs_Indicator |
| State_Assignment_Code | 16.6.0 | Varchar2(6) | Migrated from: [Courses]VA_course_code |
| Distance_Learning | 16.6.0 | Varchar2(1) | Migrated from: [Courses]VA_distance_learning |
| DualEnrollment | 16.6.0 | Varchar2(1) | Migrated from: [Courses]VA_dual_enrollment |
| Exclude_From_CEDC_TF | 16.6.0 | Number(1,0) | Migrated from: [Courses]VA_exclude_cedc |
| Exclude_From_MSC_TF | 16.6.0 | Number(1,0) | Migrated from: [Courses]VA_exclude_from_MSC |
| Exclude_From_Transcript_TF | 16.6.0 | Number(1,0) | Migrated from: [Courses]VA_exclude_from_transcript |
| ExtendedDescription | 16.7.2 | Varchar2(20) | Virginia Extended Description values given by state. |
| Governors_Academy_Code | 17.4.0 | Varchar2(1) | Migrated from: [Courses]VA_GovAcademy |
| Work_Based_Learning_Code | 17.4.0 | Varchar2(2) | Migrated from: [Courses]VA_WorkBasedLearning |
| MOP_ID | 19.8.2.0 | Number(1,0) | ID of the Multi-division Online Provider that provides the course's curriculum and delivery. |