PSM_SectionTeacher (ver1.0)
This table contains information used to associate a teacher to a section. Data duplicated here from the originating SIS.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Allocation | 2.6 | Number(10,2) | The percentage allocation that this teacher has for this section. |
End_Date | 2.6 | Timestamp(6) | The end date of the association of this teacher to this section. |
ID | 1.0 | Number(19,0) | Unique sequential number generated by the application. Required. |
PriorityOrder | 1.0 | Number(10,0) | Not currently used. |
RoleID | 2.6 | Number(19,0) | The teacher's role ID. |
SectionID | 1.0 | Number(19,0) | The internal ID for the PSM_Section record to which the record is associated. Required. |
SectionNickName | 1.5 | Varchar2(50) | The informal name of the section as designated by the teacher |
Start_Date | 2.6 | Timestamp(6) | The start date of the association of this teacher to this section. |
TeacherID | 1.0 | Number(19,0) | The internal ID for the PSM_Teacher record to which the record is associated. Required. |