AB_EXAM_SITTING
This table contains exam sitting data.
Column Name | Version | Data Type | Description |
---|---|---|---|
AB_Exam_Sitting_ID | NUMBER(19,0) | 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 | NUMBER | Unique 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 |