CourseEquivalency (ver7.9.0)
This table stores information that defines the relationship between a course and its equivalent. A Course_Number_Equivalent can replace a Course_Number_Original. For example, if EHS101 (Course_Number_Original) and EHS102 (Course_Number_Equivalent) are stored, then EHS102 courses can replace EHS101 grades. EHS102 is "equivalent to" EHS101.
Column Name | Initial Versoin | Data Type | Description |
---|---|---|---|
Course_Number_Equivalent | 7.9.0 | Varchar2(20) | The course that has been defined as equivalent to another course. Required. |
Course_Number_Original | 7.9.0 | Varchar2(20) | The course that is associated to an equivalent course. Required. |
EndDate | 7.9.0 | Date | Course equivalency ends at this day. |
ID | 7.9.0 | Number(10) | Unique sequential number generated by application. Required. |
StartDate | 7.9.0 | Date | Course equivalency begins at this day. |
WhenCreated | 7.9.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 7.9.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhocCeated | 7.9.0 | Varchar(100) | The name of the person who create the record. Defaults to user. |
WhoModified | 7.9.0 | Varchar(100) | The name of person who modified the record. Defaults to user. |