Skip to main content
Skip table of contents


This table contains exam sitting data. 

Column Name


Data Type





Primary Key

Component_Code Varchar2(6)Indicates the exam component for this sitting.
Exam_Ref_ID Varchar2(36)The REFID from the AB_EXAM table.
Is_Deleted NUMBER(1,0)Indicates whether this sitting is deleted. Valid values: 1=Yes, 0=No. Required.
Is_Special NUMBER(1,0)Indicates whether this is a special sitting. Valid values: 1=Yes, 0=No. Required.
Location_Name Varchar2(120)The physical location (not address) where the exam will be proctored.
Organisation_Code Varchar2(6)Organization code with prefix.
PASI_CoreVersion NUMBERUnique number allowing easy identification of when an entity has changed.
RefID Varchar2(36)Unique system identifier.
Scheduled_DTOTime TIMESTAMP(6)The date and time the record is scheduled to occur.
Student_Capacity NUMBER(11,0)Indicates the maximum student capacity for this sitting.
PS_Updated NUMBER(1,0)Flag that indicates if the StoredGrades table has been updated with this exam mark.
Local_ID Varchar2(100)

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

WhoCreated Varchar2(100)The name of the person who created the record. Defaults to user.
WhenCreated TIMESTAMP(6)The date and time the record was created. Defaults to system date.
WhoModified Varchar2(100)The name of person who modified the record. Defaults to user.
WhenModified TIMESTAMP(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.