AB_DIPLOMA_EXAM_COMPONENT
This table stores diploma exam component information from Alberta.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_Diploma_Exam_Component_ID | 17.4.0 | NUMBER | Primary Key |
| AB_Diploma_ExamID | 17.4.0 | NUMBER | The AB_DIPLOMA_EXAMID from the AB_DIPLOMA_EXAM table |
| Component_Code | 17.4.0 | Varchar2(12) | Indicates whether this is the machine scored or written component of the exam. Valid values: MS=Machine Scored, WR=Written Response. |
| Component_Name | 17.4.0 | Varchar2(20) | Name of the component - Valid Values: Machine Scored, Written Response. |
| Is_Mark_Reportable | 17.4.0 | NUMBER(38,0) | Indicates whether this component is reportable. |
| Weight_Percentage | 17.4.0 | NUMBER | Percentage of overall grade this component is worth. |
| Scheduled_UTC_Time | 17.4.0 | TIMESTAMP(6) | Date the component is scheduled to occur. |
| 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. |