SchoolCourses (ver7.8.0)
This view provides a list of courses by school by parsing the activecrslist.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Code | 7.8.0 | Varchar2(20) | [From Courses] Used to track state-specific codes associated with a course, such as the CIP code. |
Course_Name | 7.8.0 | Varchar2(40) | [From Courses] The name of the course, such as Algebra. |
Course_Number | 7.8.0 | Varchar2(11) | [From Courses] The number the school assigns to a particular course. Indexed. |
CourseDCID | 7.8.0 | Number(10) | [From Courses] Internal DCID for the associated courses record. |
Credit_Hours | 7.8.0 | Float(126) | [From Courses] The amount of credit awarded for completing a course. |
CreditType | 7.8.0 | Varchar2(20) | [From Courses] The type of credit this counts as toward graduation, such as Math or elective. |
Exclude_ADA | 7.8.0 | Number(10) | [From Courses] Indicates whether or not to exclude ADA. |
ExcludeFromClassRank | 7.8.0 | Number(10) | [From Courses] Indicates whether this course should be excluded during class ranking. Valid values: 1 = True, to be excluded, 0 = False. |
ExcludeFromGPA | 7.8.0 | Number(10) | [From Courses] Indicates whether this course should be excluded during GPA calculations. Valid values: 1 = True, to be excluded, 0 = False. |
ExcludeFromHonor Roll | 7.8.0 | Number(10) | [From Courses] Indicates whether this course should be excluded during Honor Roll calculations. Valid values: 1 = True, to be excluded, 0 = False. |
GradeScaleID | 7.8.0 | Number(10) | [From Courses] The ID for the grade scale attached to this course. Relates to the GradescaleItem table. |
SchoolDCID | 7.8.0 | Number(10) | [From Schools] Internal DCID for the associated schools record. |
SchoolID | 7.8.0 | Number(10) | [From Schools] This ID is linked to the School_Number from the School table. |
Vocational | 7.8.0 | Number(10) | [From Courses] Used to flag courses as vocational for searching purposes. Valid values: 1 = Yes/Selected, 0 = No/Deselected. |