AB_LOCAL_AUTH
This table stores local authority course data.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_Local_AuthID | 16.5.0 | NUMBER(19,0) | Primary Key |
| Course_Credit | 16.5.0 | NUMBER(10,0) | The amount of credit awarded for completing a course. |
| CourseID | 16.5.0 | NUMBER(19,0) | The AB_COURSEID from the AB_COURSE table. |
| WhoCreated | 16.5.0 | Varchar2(100) | The name of the person who created the record. Defaults to 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 person who modified the record. Defaults to user. |
| WhenModified | 16.5.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date |
| Effective_Date | 16.5.0 | DATE | Date this course is valid. |
| Expiry_Date | 16.5.0 | DATE | Date this course becomes invalid. |
| ORG_Code | 16.5.0 | Varchar2(255) | Organization code. |
| ORG_Type | 16.5.0 | Varchar2(255) | Identifies if this is a school or a school authority. |