AB_COURSE_AUTHORIZATION
This table stores information on all courses (Alberta Education and locally developed) identifying at what credit level(s) a course can be offered can be offered.
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 |
CREDITVERSION | 16.5.0 | NUMBER(5) | Identifies the number of credits for which the course can be offered. Typically, this is 1, 3 or 5 credits but can be any number. |
FIRSTSCHOOLYEAR | 16.5.0 | NUMBER(4) | Identifies the first school year in which the course can be offered for the identified credit version. |
LASTSCHOOLYEAR | 16.5.0 | NUMBER(4) | Identifies the last school year in which the course can be offered for the identified credit version. |
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. |