AB_EXAM_MARK
This table stores exam mark information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_Exam_Mark_ID | 17.4.0 | NUMBER | Primary Key |
| Effective_UTC | 17.4.0 | DATE | Date the exam mark is valid. |
| Exam_Mark_Status | 17.4.0 | Varchar2(4) | Indicates the status of the exam mark. |
| Exam_Ref_ID | 17.4.0 | Varchar2(36) | The REFID from the AB_EXAM table. |
| Deleted | 17.4.0 | Varchar2(38) | Indicates if the exam mark is deleted. |
| Rescored | 17.4.0 | Varchar2(38) | Indicates if the exam mark is re-scored. |
| Mark_Value | 17.4.0 | Varchar2(36) | The student's awarded mark value. |
| PASI_CoreVersion | 17.4.0 | NUMBER | Unique number allowing easy identification of when an entity has changed. |
| RefID | 17.4.0 | Varchar2(38) | Unique system identifier. |
| State_ProvinceID | 17.4.0 | Varchar2208) | The provincial-assigned student number for the student. In most cases, this number should stay the same from school to school. |
| PS_Updated | 17.4.0 | NUMBER(1,0) | Flag that indicates if the StoredGrades table has been updated with this exam mark. |
| WhoCreated | 17.4.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. |
| WhenCreated | 17.4.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. |
| WhoModified | 17.4.0 | Varchar2(100) | The date and time the record was created. Defaults to system date. |
| WhenModified | 17.4.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date |
| Local_ID | 17.4.0 | Varchar2(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. |