Skip to main content
Skip table of contents


This table stores official mark data.

Column Name


Data Type





Primary Key

Course_Code17.4.0Varchar2(10)The Alberta Course Code.
Credit_Awarded17.4.0NUMBER(5,0)The amount of credit awarded for completing a course.
Effective_UTC17.4.0DATEDate this official mark is valid.
Mark_Calc_Method17.4.0Varchar2(50)Indicates the mark calculation method.
Mark_Format17.4.0Varchar2(10)Indicates the mark format.
Mark_Status17.4.0Varchar2(20)Indicates the status of the mark.
Mark_Value17.4.0Varchar2(3)The student's awarded mark value.
PASI_CoreVersion17.4.0NUMBER(19,0)Unique number allowing easy identification of when an entity has changed.
School_Year17.4.0NUMBER(5,0)A number representing which school year the record belongs to, such as 2017 for 2017-2018 school year.
State_Province_ID17.4.0Varchar2(20)The provincial-assigned student number for the student. In most cases, this number should stay the same from school to school.
Student_Trans_DTLID17.4.0NUMBER(19,0)The AB_STUDENT_TRANS_DTLID from the AB_STUDENT_TRANS_DTL table.
WhoCreated17.4.0Varchar2(100)The name of the person who created the record. Defaults to user.
WhenCreated17.4.0TIMESTAMP(6)The date and time the record was created. Defaults to system date.
WhoModified17.4.0Varchar2(100)The name of person who modified the record. Defaults to 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.