UnScheduledTeacher, 149 (ver3.7.0)
This table is mainly used by the Auto Study Hall feature and maintains information about teachers that are available (not scheduled) so they can be assigned to the study halls. This is a temporary table for 4D only.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Bitmap | 3.7.0 | BLOB | Contains the schedule for this teacher represented in bits and bytes. The format conforms to all schedule bitmaps throughout the application (Byte 1 = Number of Terms, Byte 2 = Number of days, Byte 3 = number of Periods, followed by Byte 1 X Byte 2 X Byte 3 number of bytes). Bits are turned on for Term/Period/Days that are scheduled. |
ID | 3.7.0 | Number(10,0) | Sequential number generated by the application. |
IsAlwaysFree | 3.7.0 | Number(10,0) | This designates a teacher as being always available for scheduling purposes. |
LastModDate | 3.7.0 | Date | Date stamp for modification of record. Currently not used. |
LastModTime | 3.7.0 | Date | Time stamp for modification of record. Currently not used. |
MaxInRow | 3.7.0 | Number(10,0) | This is a constraint for use in the automated study hall function, which indicates at what point a teacher is not available even though their schedule is open. If a teacher has a max in row = 3, they may not be scheduled for 4 consecutive periods unless there is a schedule break after the third period. |
ScheduledBreak | 3.7.0 | Varchar(7) | This designates a Built-in break in the schedule that pertains to all teachers, rooms and students. |
SchoolID | 3.7.0 | Number(10,0) | The School_Number of the associated Schools record. |
TeacherID | 3.7.0 | Number(10,0) | The internal identification number of the teacher in the associated SchoolStaff record. |