Skip to main content
Skip table of contents


This table stores diploma exam information from Alberta.

Column Name


Data Type





Primary Key

Course_Code17.4.0Varchar2(20)The Alberta course code
Effective_UTC17.4.0Varchar2(20)Date the record is valid.
Exam_Language17.4.0NUMBER(19,0)Indicates the language of the exam.
Exam_Period17.4.0Varchar2(6)Month of the exam
Examp_Type17.4.0Varchar2(12)Indicates the diploma exam type.
Deleted_Number17.4.0NUMBER(38,0)Indicates if the diploma exam is deleted.
Mark_Format17.4.0Varchar2(16)Indicates the format of the mark.
PASI_CoreVersion17.4.0NUMBERUnique number allowing for easy identification of when an entity has changed.
RefID17.4.0Varchar2(36)Unique system identifier
Registration_Deadline_UTC17.4.0DATELast date of registrations
Rescore_Deadline_Date17.4.0DATELast date re-scores are allowed for this exam.
School_Year17.4.0NUMBER(38,0)A number representing which school year the record belongs to, such as 2017 for 2017-2018 school year.
PS_Updated17.4.0NUMBER(1,0)Flag indicating if StoredGrades table has been updated with this diploma exam.
WhoCreated17.4.0Varchar2(100)The name of the person who created the record. Defaults to the user.
WhenCreated17.4.0TIMESTAMP(6)The date and time the record was created. Defaults to system date.
WhoModified17.4.0Varchar2(100)The name of the person who modified the record. Defaults to the user.
WhenModified17.4.0TIMESTAMP(6)The date and time the record was modified. Defaults to system date.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.