UnScheduledRoom, 150 (ver3.7.0)
This table is mainly used by the Auto Study Hall feature and maintains information about rooms that are available (not scheduled) so they can be used for auto scheduling study halls. This is a temporary table for 4D only.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
AlwaysFree | 3.7.0 | Number(10,0) | A room can be designated as Always Free for scheduling purposes if it is always available for assigning sections as in a cafeteria or other multi-purpose room. This tells scheduling software that other constraints can be ignored. |
Bitmap | 3.7.0 | BLOB | Contains the schedule of usage for this room 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. |
Lastmoddate | 3.7.0 | Date | Date stamp for modification of record. Currently this is not used. |
Lastmodtime | 3.7.0 | Date | Time stamp for modification of record. Currently this is not used. |
RoomNumber | 3.7.0 | Varchar(10) | This is a Room identifier that uniquely identifies a room within one school. This field is populated from table Room, column Room_Number |
SchoolID | 3.7.0 | Number(10,0) | The School_Number of the associated Schools record. |