| Table Name | AETLF |
| Long Name | Licences |
| Description | A teacher can be certified in more than one area and there is a Teacher/Staff Certification record for each certification. |
| Prefix | TL |
| Field Name | Length | Type | Description | Comments |
|---|---|---|---|---|
| tl_enddate | 8 | datetime | End Date | |
| tl_licence | 2 | char | License | |
| tl_udate | 8 | datetime | Record Updated (Date) | |
| tl_uid | 9 | char | Record Updated (User ID) | |
| tl_utime | 8 | char | Record Updated (Time) | |
| tl_staff | 10 | char | Staff ID | |
| tl_comment | 254 | char | Comments | |
| tl_keytlf | 10 | char |