AB_COURSE_RELATIONSHIP
This table stores information on course relationships.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 16.5.0 | NUMBER(19,0) | Primary Key |
| COURSEID | 16.5.0 | NUMBER(19,0) | The AB_COURSEID from the AB_COURSE table |
| CANBEWAIVED | 16.5.0 | NUMBER(1) | Identifies whether the prerequisite can be waived. Mandatory for prerequisite (PRQ) relationships, will be NULL for other relationships. |
| FIRSTSCHOOLYEAR | 16.5.0 | NUMBER(4) | The first school year in which this relationship rule applies. |
| LASTSCHOOLYEAR | 16.5.0 | NUMBER(4) | The last school year in which this relationship rule applies. |
| NUMBERTOCOMPLETE | 22.7.1 | NUMBER(4) | Only used for prerequisite (PRQ) relationships. Identifies how many of the Prerequisite Courses the student must complete in order to satisfy the prerequisite. |
| RELATIONSHIPTYPE | 22.7.1 | VARCHAR2(100 CHAR) | Identifies the type of relationship. Typical Sequence (TYP), Prerequisite (PRQ) and Equivalent (REG/WPC/CHA). The code value of CourseRelationshipType in PASI Code Values. |
| WHOCREATED | 16.5.0 | Varchar2(100) | The name of the person who created the record. Defaults to the user. |
| WHENCREATED | 16.5.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. |
| WHOMODIFIED | 16.5.0 | Varchar2(100) | The name of the person who modified the record. Defaults to the user. |
| WHENMODIFIED | 16.5.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. |