Skip to main content
Skip table of contents


This table stores evaluated marks information.

Column Name


Data Type





Primary Key


The Alberta Course Code


The amount of credit awarded for completing a course.

Effective_UTC16.5.0DATEDate the mark is valid.
Eval_Date16.5.0DATEDate the mark was awarded.
Eval_Method16.5.0Varchar2(10)Indicates the course evaluation method.
Is_Deleted16.5.0NUMBER(1,0)Indicates whether the mark is deleted. Valid values: 1=Yes, 0=No. Required.
Is_Funding_Req16.5.0NUMBER(1,0)Indicates whether funding has been requested for this mark. Valid values: 1=Yes, 0=No. Required.
Is_Mark_Approved16.5.0NUMBER(1,0)Indicates whether the mark is approved. Valid values: 1=Yes, 0=No. Required.
Mark_Format16.5.0Varchar2(10)Indicates the format of the mark.
Mark_Value16.5.0Varchar2(3)The student's awarded mark value.
ORG_Code16.5.0Varchar2(10)Organization code with prefix
PASI_CoreVersion16.5.0NUMBER(19,0)Unique number allowing for easy identification of when an entity has changed.
RefID16.5.0Varchar2(36)Unique system identifier
School_Year16.5.0NUMBER(5,0)A number representing which school year the record belongs to, such as 2017 for 2017-2018 school year.

The provincial-assigned student number for the student - In most cases, this number should stay the same from school to school.


The DCID of the StoredGrade record in PowerSchool - This is the link between the PASI tables and the PowerSchool tables.

WhoCreated16.5.0Varchar2(100)The name of the person who created the record. Defaults to the user.
WhenCreated16.5.0TIMESTAMP(6)The date and time the record was created. Defaults to system date.
WhoModified16.5.0Varchar2(100)The name of the person who modified the record. Defaults to the user.
WhenModified16.5.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.