AB_OFF_MARK
This table stores official mark data.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_Off_MarkID | 17.4.0 | NUMBER(19,0) | Primary Key |
| Course_Code | 17.4.0 | Varchar2(10) | The Alberta Course Code. |
| Credit_Awarded | 17.4.0 | NUMBER(5,0) | The amount of credit awarded for completing a course. |
| Effective_UTC | 17.4.0 | DATE | Date this official mark is valid. |
| Mark_Calc_Method | 17.4.0 | Varchar2(50) | Indicates the mark calculation method. |
| Mark_Format | 17.4.0 | Varchar2(10) | Indicates the mark format. |
| Mark_Status | 17.4.0 | Varchar2(20) | Indicates the status of the mark. |
| Mark_Value | 17.4.0 | Varchar2(3) | The student's awarded mark value. |
| PASI_CoreVersion | 17.4.0 | NUMBER(19,0) | Unique number allowing easy identification of when an entity has changed. |
| School_Year | 17.4.0 | NUMBER(5,0) | A number representing which school year the record belongs to, such as 2017 for 2017-2018 school year. |
| State_Province_ID | 17.4.0 | Varchar2(20) | The provincial-assigned student number for the student. In most cases, this number should stay the same from school to school. |
| Student_Trans_DTLID | 17.4.0 | NUMBER(19,0) | The AB_STUDENT_TRANS_DTLID from the AB_STUDENT_TRANS_DTL table. |
| 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 name of person who modified the record. Defaults to user. |
| WhenModified | 17.4.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date |