AB_COURSE
This table stores PASI Course information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_COURSEID | 16.5.0 | NUMBER(19,0) | Primary Key |
| COURSE_CODE | 16.5.0 | VARCHAR2(10 CHAR) | Unique course identifier assigned by Alberta Education. |
| ACCUMULATEDCREDITMAXIMUM | 16.5.0 | DATE | When provided, identifies how many credits a student can accumulate in the course by taking the course multiple times. If not provided, identifies that the student cannot accumulate credits in the course. |
| COURSESERIES | 16.5.0 | VARCHAR2(1000 CHAR) | Categorizes the course based on the series provided for the course. |
| DEVELOPEDBY | 16.5.0 | VARCHAR2(100 CHAR) | Identifies if the course is developed provincially by Alberta Education (“P”), or is a Locally Developed Course (“L”). |
| DISCIPLINECODE | 16.5.0 | VARCHAR2(100 CHAR) | Used to sub-categorize the course within the identified subject. |
| ENGLISHFULLNAME | 16.5.0 | VARCHAR2(1000 CHAR) | Course full name in English. |
| ENGLISHSHORTNAME | 16.5.0 | VARCHAR2(1000 CHAR) | Abbreviated course name in English. |
| EVALUATIONMETHOD | 22.7.1 | VARCHAR2(100 CHAR) | Identifies the set of rules used to evaluate the student achievements in the course. |
| FIRSTPILOTSCHOOLYEAR | 22.7.1 | NUMBER(4,0) | Identifies the first school year the course was offered as a pilot. While offered as a pilot, only authorized school authorities may offer the course. |
| FIRSTSCHOOLYEAR | 22.7.1 | NUMBER(4,0) | Identifies the first school year the course is generally available to be offered. |
| FRENCHFULLNAME | 22.7.1 | VARCHAR2(1000 CHAR) | Course full name in French. |
| FRENCHSHORTNAME | 22.7.1 | VARCHAR2(1000 CHAR) | Abbreviated course name in French. |
| FUNDINGTIER | 22.7.1 | VARCHAR2(100 CHAR) | Categorizes the course based on the level of funding provided for the course. |
| INSTRUCTIONALLEVEL | 22.7.1 | VARCHAR2(10 CHAR) | Categorizes the course based on the level expertise being offered in the course. |
| INTENDEDGRADELEVEL | 22.7.1 | VARCHAR2(10 CHAR) | Identifies grade level that the course was intended to be delivered in. Grade Level (Format: A) |
| LASTPILOTSCHOOLYEAR | 22.7.1 | NUMBER(4,0) | Identifies the last school year the course was offered as a pilot. While offered as a pilot, only authorized school or school authorities may offer the course. If FirstPilotSchoolYear is NULL then LastPilotSchoolYear is ignored. |
| LASTPUBLISHEDUTCTIME | 22.7.1 | TIMESTAMP(6) | The date and time that the course definition was last published/updated. Represents the UTC date/time. |
| LASTPUBLISHEDVERSION | 22.7.1 | NUMBER(19,0) | sed to identify the order in which the course data was updated in relation to other courses. |
| LASTSCHOOLYEAR | 22.7.1 | NUMBER(4,0) | Identifies the last school year the course is allowed to be offered. |
| PASI_COREVERSION | 16.5.0 | NUMBER(19,0) | PASI version of the course record. |
| SUBJECTCODE | 16.5.0 | VARCHAR2(100 CHAR) | The unique code for the course subject. |
| 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. |