AB_DIPLOMA_EXAM
This table stores diploma exam information from Alberta.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_Diploma_ExamID | 17.4.0 | NUMBER | Primary Key |
| Course_Code | 17.4.0 | Varchar2(20) | The Alberta course code |
| Effective_UTC | 17.4.0 | Varchar2(20) | Date the record is valid. |
| Exam_Language | 17.4.0 | NUMBER(19,0) | Indicates the language of the exam. |
| Exam_Period | 17.4.0 | Varchar2(6) | Month of the exam |
| Examp_Type | 17.4.0 | Varchar2(12) | Indicates the diploma exam type. |
| Deleted_Number | 17.4.0 | NUMBER(38,0) | Indicates if the diploma exam is deleted. |
| Mark_Format | 17.4.0 | Varchar2(16) | Indicates the format of the mark. |
| PASI_CoreVersion | 17.4.0 | NUMBER | Unique number allowing for easy identification of when an entity has changed. |
| RefID | 17.4.0 | Varchar2(36) | Unique system identifier |
| Registration_Deadline_UTC | 17.4.0 | DATE | Last date of registrations |
| Rescore_Deadline_Date | 17.4.0 | DATE | Last date re-scores are allowed for this exam. |
| School_Year | 17.4.0 | NUMBER(38,0) | A number representing which school year the record belongs to, such as 2017 for 2017-2018 school year. |
| PS_Updated | 17.4.0 | NUMBER(1,0) | Flag indicating if StoredGrades table has been updated with this diploma exam. |
| WhoCreated | 17.4.0 | Varchar2(100) | The name of the person who created the record. Defaults to the 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 the person who modified the record. Defaults to the user. |
| WhenModified | 17.4.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. |