S_NH_CRS_X (ver 16.8.0)
This table is an extension of the [Courses] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CoursesDCID | 16.8.0 | Number(10,0) | Primary Key. |
| ELO_Career_Cluster | 20.7.1.0 | Varchar2(8) | ELO Career Cluster |
| ELO_Community_Partner | 19.10.1.0 | Varchar2(100) | ELO Community Partner/Mentor Name |
| ELO_Credit_Bearing | 20.7.1.0 | Varchar2(1) | Obsolete - ELO Credit Bearing Status |
| ELO_Description | 19.10.1.0 | Varchar2(4) | ELO Description Type |
| ELO_Num_DaysPerWk | 20.7.1.0 | Number(5) | Obsolete - ELO Number of Days Per Week out of School Building |
| ELO_Off_Campus | 20.7.1.0 | Varchar2(1) | ELO Off Campus indicator |
| ELO_Subject_Area | 20.7.1.0 | Varchar2(8) | ELO Subject Area |
| Exclude_from_CATE | 16.11.1 | Number(1,0) | Exclude Course from CATE extracts |
| Exclude_from_i4see | 16.11.1 | Number(1,0) | Exclude Course from i.4.see submissions |
| PrimaryGradeId | 16.11.1 | Varchar2(4) | 1450 - Primary Grade ID (Primary Grade) |
| SCED_Course_Code | 16.8.0 | Varchar2(8) | SCED Common Course Code |
| SCED_Course_Level | 16.8.0 | Varchar2(5) | SCED Common Course Level (B = Basic or Remedial, G = General or Regular, E = Enriched or Advanced, H = Honors) |
| Subject_Code | 16.11.1 | Varchar2(10) | 1300 - Subject Codes (Defines course offered at school) |
| TermID | 16.11.1 | Varchar2(4) | 1430 - Term ID (Term that the course was taught) |