ScheduleRooms, 81 (ver3.6.1)
Room information used for scheduling purposes.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Building | 3.6.1 | Varchar(10) | Building where this room is located. This is optional. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Department | 3.6.1 | Varchar(12) | Department associated to this room. If set, the scheduler will try to match department courses to these room. |
DepartmentUseOnly | 3.6.1 | Number(10,0) | Indicates whether department classes must be held in these rooms. 1=Yes. |
Description | 3.6.1 | Varchar(30) | An optional area to describe any information about this item. |
Facilities | 3.6.1 | Varchar(50) | Any special characteristics of the room, such as Computer lab. |
FacilityUseOnly | 3.6.1 | Number(10,0) | Indicates whether these facilities are required. If deselected then they are optional. 1=Required. |
Free | 3.6.1 | Number(10,0) | Indicates whether this room is to remain always free. If =1, then the system will schedule multiple courses in this room. Usually set for Gymnasiums. |
House | 3.6.1 | Varchar(10) | If this room is located in a house, then its name would be maintained here, such as school that separate 9,10 grade into a house and 11,12 into another. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Maximum | 3.6.1 | Number(10,0) | Maximum number of students who can be in this room. |
RoomNumber | 3.6.1 | Varchar(10) | Number given to this room. Indexed. |
RoomType | 3.6.1 | Varchar(8) | Type of room. Not currently used. |
Scheduled | 3.6.1 | Number(10,0) | Indicates whether this room is to be used by system to be scheduled. 1=Yes. If it is to be used then Maximum must also be entered. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
UseAsHomeRoom | 3.6.1 | Number( 10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |