AB_COURSE_PERMISSION
This table stores information on locally developed courses identifying which organizations can offer the course and at what credit level(s).
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 |
| ORGANIZATIONCODE | 16.5.0 | VARCHAR2(6 CHAR) | Unique organization identifier assigned by Alberta Education, the code with "S." or "A." prefix |
| 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. |