S_AB_EXAM_MARK_S (ver 17.11.0)
This is a standalone table that stores student's exam marks.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 17.11.0 | NUMBER(11,0) | Primary Key |
Effective_UTC | 17.11.0 | DATE | The date the record is valid. Defaults to system date. |
| ExamMarkStatus | 17.11.0 | Varchar2(2) | Status of the student's exam mark. |
| ExamRefId | 17.11.0 | Varchar2(36) | Ref ID of the diploma exam in the local copy. |
| StateProvinceId | 17.11.0 | Varchar2(20) | The provincial-assigned student number for the student. In most cases, this number should stay the same from school to school. |
| WhoCreated | 17.11.0 | Varchar2(100) | The name of the person who created the record. Defaults to the user. |
| WhenCreated | 17.11.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. |
| WhoModified | 17.11.0 | Varchar2(100) | The name of the person who modified the record. Defaults to the user. |
| WhenModified | 17.11.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. |