Skip to main content
Skip table of contents


This table stores exam mark information.

Column Name


Data Type





Primary Key

Effective_UTC17.4.0DATEDate the exam mark is valid.
Exam_Mark_Status17.4.0Varchar2(4)Indicates the status of the exam mark.
Exam_Ref_ID17.4.0Varchar2(36)The REFID from the AB_EXAM table.
Deleted17.4.0Varchar2(38)Indicates if the exam mark is deleted.
Rescored17.4.0Varchar2(38)Indicates if the exam mark is re-scored.
Mark_Value17.4.0Varchar2(36)The student's awarded mark value.
PASI_CoreVersion17.4.0NUMBERUnique number allowing easy identification of when an entity has changed.
RefID17.4.0Varchar2(38)Unique system identifier.

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

PS_Updated17.4.0NUMBER(1,0)Flag that indicates if the StoredGrades table has been updated with this exam mark.
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 date and time the record was created. Defaults to system date.
WhenModified17.4.0TIMESTAMP(6)The date and time the record was modified. Defaults to system date
Local_ID17.4.0Varchar2(100)The DCID of the S_AB_EXAM_MARK_S record in PowerSchool. This is the link between the PASI tables and the PowerSchool tables.
JavaScript errors detected

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

If this problem persists, please contact our support.