Course_Relationship, 151 (ver4.0.0)
Ways two courses can be related together. This is mainly used for Scheduling purposes in such ways that a course is a prereq for another or other types of relationship. However this can be used in other areas of the application as needed.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Course_Number1 | 4.0.0 | Varchar(20) | The relationship between the two courses is defined, as Course_Number2 is a RelationshipType to Course_Number1, such as 90001 is a prerequisite of 91001. Required. |
Course_Number2 | 4.0.0 | Varchar(20) | This field identifies the course number of the course that has a relationship to the primary course. This will typically be populated by the schedule commit process from ScheduleCourseRelationships:Course_Number2 but will be exposed to the user for editing in PowerAdmin. The course identified by the course number must be an existing course in the [Courses] table and associated to the current school. Required. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ID | 4.0.0 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Relationship_Code | 4.0.0 | Varchar(12) | This field identifies the type of Block relationship that exists for relationships with a RelationshipType of Block. (Simultaneous - BeforeAfter - Before - After - Term - Combine - OppositeDays - Section) This will only be populated by the schedule commit process from ScheduleCourseRelationships:RelationshipCode and will not be exposed for editing in PowerAdmin. |
Relationship_Type | 4.0.0 | Varchar(12) | This field identifies the type of relationship (Coreq, Postreq, Prereq, Block) existing between Course_Number1 and Course_Number2. This will typically be populated by the schedule commit process from the ScheduleCourseRelationships:RelationshipType but will be exposed to the user for editing in PowerAdmin. |
SchoolID | 4.0.0 | Number(10,0) | The School_Number of the associated Schools record. |
YearID | 4.0.0 | Varchar(4) | A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Maintained in the Terms table. |