AB_EVAL_MARK
This table stores evaluated marks information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_Eval_MarkID | 16.5.0 | NUMBER(19,0) | Primary Key |
| Course_Code | 16.5.0 | Varchar2(10) | The Alberta Course Code |
| Credits_Attempted | 16.5.0 | NUMBER(5,0) | The amount of credit awarded for completing a course. |
| Effective_UTC | 16.5.0 | DATE | Date the mark is valid. |
| Eval_Date | 16.5.0 | DATE | Date the mark was awarded. |
| Eval_Method | 16.5.0 | Varchar2(10) | Indicates the course evaluation method. |
| Is_Deleted | 16.5.0 | NUMBER(1,0) | Indicates whether the mark is deleted. Valid values: 1=Yes, 0=No. Required. |
| Is_Funding_Req | 16.5.0 | NUMBER(1,0) | Indicates whether funding has been requested for this mark. Valid values: 1=Yes, 0=No. Required. |
| Is_Mark_Approved | 16.5.0 | NUMBER(1,0) | Indicates whether the mark is approved. Valid values: 1=Yes, 0=No. Required. |
| Mark_Format | 16.5.0 | Varchar2(10) | Indicates the format of the mark. |
| Mark_Value | 16.5.0 | Varchar2(3) | The student's awarded mark value. |
| ORG_Code | 16.5.0 | Varchar2(10) | Organization code with prefix |
| PASI_CoreVersion | 16.5.0 | NUMBER(19,0) | Unique number allowing for easy identification of when an entity has changed. |
| RefID | 16.5.0 | Varchar2(36) | Unique system identifier |
| School_Year | 16.5.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 | 16.5.0 | Varchar2(20) | The provincial-assigned student number for the student - In most cases, this number should stay the same from school to school. |
| Local_ID | 16.5.0 | Varchar2(100) | The DCID of the StoredGrade record in PowerSchool - This is the link between the PASI tables and the PowerSchool tables. |
| WhoCreated | 16.5.0 | Varchar2(100) | The name of the person who created the record. Defaults to the user. |
| WhenCreated | 16.5.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. |
| WhoModified | 16.5.0 | Varchar2(100) | The name of the person who modified the record. Defaults to the user. |
| WhenModified | 16.5.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. |