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 |