S_AB_CRS_X (ver 17.3.0)
This table is an extension of the Courses table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CoursesDCID | 17.3.0 | NUMBER(10,0) | Primary Key |
| CTSIndicator | 17.3.0 | Varchar2(100) | Identifies course as a Career Technology Studies (CTS) header or module course. Migrated from [Courses.AB_CTS_Indicator]. |
| DiplomaCourse | 17.3.0 | Varchar2(1) | Identifies course as a Diploma course. Migrated from [Courses.AB_Diploma_Course]. |
| ExcludeFromCSR | 17.3.0 | Varchar2(1) | Include or exclude the course from the Class Size Information System report. Migrated from [Courses.AB_Exclude_From_CSR]. |
| FrenchInstrHrs | 17.3.0 | Varchar2(1) | Identifies if French instruction hours are required for the course. Migrated from [Courses.ab_fren_istr_hrs]. |
| SubjectCode | 17.3.0 | Varchar2(4) | Identifies the subject code of the course. Migrated from [Courses.AB_Subject_Code]. |
| ABCourseNumber | 18.8.0 | Varchar2(10) | Identifies the Alberta course code for North West Territories customers. |