SectionTeacher (ver7.5.0)
his table contains co-teaching information and maintains the associations between sections, teachers, and roles.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Allocation | 7.5.0 | Number(10,2) | The percentage allocation this teacher has for this section. |
End_Date | 7.5.0 | Timestamp(6) | The end date of the association of this teacher to this section. |
ID | 7.5.0 | Number(10,0) | Unique sequential number generated by the application. Indexed. |
Notes | 7.5.0 | CLOB | General comments and notes. |
PriorityOrder | 7.5.0 | Number(10) | The priority order for this teacher and section. |
RoleID | 7.5.0 | Number(10) | The teacher's role ID. This role ID is related to the RoleDef.ID. |
SectionID | 7.5.0 | Number(10) | The teacher's section ID. The section ID is related to the Sections.ID. |
SectionNickname | 11.0.0 | Varchar2(40) | Nickname of the section. Optional. |
Start_Date | 7.5.0 | Timestamp(6) | The start date of the association of this teacher to this section. |
TeacherID | 7.5.0 | Number(10) | The internal identification number of the teacher in the associated SchoolStaff record. |
WhenCreated | 7.5.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 7.5.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. |
WhoCreated | 7.5.0 | Varchar2(100) | The user login that created the record. Defaults to database user. |
WhoModified | 7.5.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. |