ScheduleTeacherAssignments, 106 (ver3.6.1)
This table stores information about the number of courses teachers are assigned to teach.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
BuildID | 3.6.1 | Number(10,0) | The internal number for the Schedule Build with which this record is associated. Indexed. |
CatalogID | 3.6.1 | Number(10,0) | The internal number for the Schedule Catalog with which this record is associated. |
CourseNumber | 3.6.1 | Varchar(20) | The name of the course assigned by school or district, such as Algebra. Indexed. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Priority | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
RequiredAssignment | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
ScheduleTermCode | 3.6.1 | Varchar(5) | The term abbreviation for this teacher assignment record, such as S1. |
| SchoolID | 23.7.0 | Number(10,0) | The School_Number of the associated Schools record. |
SectionType | 3.6.1 | Varchar(2) | SectionTypeCode from ScheduleSectionTypes associated with this record. Indexed. |
SectionsAssigned | 3.6.1 | Number(10,0) | Number of sections assigned to this teacher. |
TeacherKey | 3.6.1 | Number(10,0) | The internal ID of the teacher for this particular assignment. Indexed. |