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. |